| Server IP : 79.136.114.73 / Your IP : 216.73.216.107 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/icad.astacus.se/customerzon/ |
Upload File : |
<?php
$projectId = $_GET['projectId'];
?>
<link href="../main.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="calendar.js"></script>
<body onLoad="showClockSWE()">
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
-->
</style>
<table width="1200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="25"> </td>
<td width="964"><table width="1200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" valign="top"><span class="heading2"><?php echo($a1);?></span><br>
<table width="1200" border="0" cellpadding="0" cellspacing="0">
<tr >
<td width="76" class="text"><?php echo($a2);?></td>
<td width="181" class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][1]);?> (<?php echo($_SESSION['ASTACUS_SSO_INFO'][10]);?>) </td>
<td width="119" class="text"><?php echo($a5);?></td>
<td width="189" class="text"><span class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][6]);?></span></td>
<td width="3" rowspan="4" bgcolor="#999999"></td>
<td width="366" rowspan="4" valign="top" class="textthin"><table width="228" border="0" align="center" cellpadding="0" cellspacing="0">
<tr class="text">
<td width="89"><?php echo($a8);?> </td>
<td width="71"><?php echo($a9);?> </td>
</tr>
<tr class="textthin">
<td width="89"><div id="showTextSWE"></div></td>
<td> <div id="showTextIND"></div></td>
</tr>
</table></td>
</tr>
<tr >
<td class="text"><?php echo($a3);?></td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][2]);?></td>
<td class="text"><?php echo($a6);?></td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][7]);?></td>
</tr>
<tr >
<td class="text"></td>
<td class="text"><?php echo($a7);?></td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][8]);?> <?php echo($_SESSION['ASTACUS_SSO_INFO'][9]);?></td>
</tr>
<tr class="text">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<hr size="1">
<span class="heading2"><br>
</span>
<table width="1190" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="818" height="677" valign="top"><span class="heading2"><br>
<?php echo($a20);?> <br>
</span>
<table width="450" border="0" cellpadding="0" cellspacing="0">
<tr> <?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$sql = "SELECT ICADAccount.ICADContact, SystemUser.Name, SystemUser.UserPhoto, SystemUser.SkypeId, SystemUser.ICADCompanyGroupId FROM ICADAccount, SystemUser where ICADAccount.ICADContact = SystemUser.SystemUserId and CustomerID = ".$_SESSION['ASTACUS_SSO_INFO'][4];
$Photo = "image_holder.jpg";
$Name = "Vakant";
$SkypeId = "";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$Name = $row['Name'];
$SkypeId = $row['SkypeId'];
$Photo = $row['UserPhoto'];
}
if ( $Photo == ""){
$Photo = "image_holder.jpg";
}
?>
<td width="120"><img src="../images/users/<?php echo($Photo);?>" width="101" height="101" border="1"></td>
<td colspan="2" valign="middle" class="textthin"><span class="style6">
</span> <table width="311" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="59" valign="bottom" class="textthin"><?php echo($a2);?> </td>
<td colspan="2" valign="bottom" class="textthin"><?php echo($Name);?> </td>
</tr>
<tr>
<td class="textthin"> </td>
</tr>
</table></td>
</tr>
</table>
<hr size="1">
<span class="heading2"><br>
<?php echo($a21);?> </span><br>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="65" class="style6"><strong><a href="?order=ProjectId" class="blacklink"><?php echo($a22);?> </a></strong></td>
<td width="240" class="style6"><strong><a href="?order=Name" class="blacklink"><?php echo($a2);?></a></strong></td>
<td width="60" class="style6"><strong><a href="?order=TimeEstimationFromIndia" class="blacklink"><?php echo($a23a);?></a></strong></td>
<?php
$showHrs = true;
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"sydtotal")){
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"lan") === 0 || strpos($_SESSION['ASTACUS_SSO_INFO'][2],"ekonomi") === 0) {
$showHrs = true;
}else{
$showHrs = false;
}
}
if($showHrs){
?>
<td width="55" class="style6"><strong><a href="?order=TimeEstimationFromIndia" class="blacklink"><?php echo($a23);?></a></strong></td>
<?php
}
?>
<td width="90" class="style6"><strong><a href="?order=TimeEstimationFromIndia" class="blacklink"><?php echo($a24);?></a></strong></td>
<td width="90" class="style6"><strong><a href="?order=TimeEstimationFromIndia" class="blacklink"><?php echo($a25);?></a></strong></td>
<td width="90" class="style6"><strong><a href="?order=ProjectStatusId" class="blacklink"><?php echo($a26);?></a></strong></td>
<td width="110" class="style6"><strong><a href="?order=clientProjectManagerName" class="blacklink"><?php echo($a27);?> </a></strong></td>
</tr>
</table>
<span class="style6">
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$orderby = $_GET['order'];
if($orderby == ""){
$orderby = "ProjectId";
}
if($orderby == "ProjectStatusId"){
$orderby = "ProjectStatus.ProjectStatusId";
}
$CompanyId = $_SESSION['ASTACUS_SSO_INFO'][4];
$sql = "SELECT * FROM SystemUser Where SystemUserId = ".$_SESSION['ASTACUS_SSO_INFO'][0];
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$ICADCompanyGroupId = $row['ICADCompanyGroupId'];
}
$extra_sql = "";
if($ICADCompanyGroupId != 0){ // St�d f�r en anv�ndare att se projekt f�r fler kunder.
$sql = "SELECT * FROM ICADCompanyGroup WHERE GroupId = $ICADCompanyGroupId";
$result_extra = mysql_query($sql);
while ($row_extra = mysql_fetch_assoc($result_extra)){
$extra_sql .= " or CompanyId = ".$row_extra['CompanyId'];
}
}
if($_GET['show'] == "archive"){
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and (CompanyId = $CompanyId $extra_sql) and ProjectStatus.ProjectStatusID = 10 order by $orderby desc";
}else{
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and (CompanyId = $CompanyId $extra_sql) and not ProjectStatus.ProjectStatusID = 11 and not ProjectStatus.ProjectStatusID = 10 order by $orderby desc";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$price = $row['TimeEstimationFromIndia'];
/* if($price != 0){
$price = round($price * 140,0);
$price = $price . " kr";
}else {
$price = "";
}*/
if($row['ProjectStatusId'] == 12){
$color = "#FF0000";
}else if($row['ProjectStatusId'] == 1) {
$color = "#ffc600";
}else if($row['ProjectStatusId'] == 8) {
$color = "#00FF00";
}
else if($row['ProjectStatusId'] == 4) {
$color = "#EEEEEE";
}else if($row['ProjectStatusId'] == 13 || $row['ProjectStatusId'] == 9) {
$color = "#0099FF";
}else if($row['ProjectStatusId'] == 14 ) {
$color = "#9966FF";
}else{
$color = "#ffffff";
}
$ProjectId = $row['ProjectId'];
$sql = "SELECT * FROM ICADNewMessage where ProjectId = $ProjectId and (FromGroup = 6 or FromGroup = 8) ";
$newMessage = "";
$result5 = mysql_query($sql);
while ($row5 = mysql_fetch_assoc($result5)){
if( $row5['Read'] == 1){
$newMessage = "<img src='../images/newMailMessage.gif'>";
}
}
if(strlen($row['Name']) > 45){
$Name = substr($row['Name'],0,45)."...";
}else{
$Name = $row['Name'];
}
?>
</span>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr align="left" >
<td width="45" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['ProjectId']);?></a></td>
<td width="20" align="right" bgcolor="<?php echo($color);?>"><?php echo($newMessage);?></td>
<td width="240" height="20" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($Name);?></a></td>
<td width="60" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['iCADSpecialCompanyID']);?></a></td>
<?php
$showHrs = true;
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"sydtotal") || strpos($_SESSION['ASTACUS_SSO_INFO'][2],"imtech")){
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"lan") === 0 || strpos($_SESSION['ASTACUS_SSO_INFO'][2],"ekonomi") === 0) {
$showHrs = true;
}else{
$showHrs = false;
}
}
if($showHrs){
?>
<td width="55" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin">
<?php
if(substr($Name,0,2) == "EP"){
echo("0");
}else{
echo($row['TimeEstimationFromIndia']);
}
?>
h</a></td>
<?php
}
?>
<td width="90" bgcolor="<?php echo($color);?>" class="textthin"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php if($row['estimatedICADHours'] >0){echo($row['estimatedICADHours']." h");}?></a> </td>
<td width="90" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo(substr($row['createDate'],0,10));?></a></td>
<td width="90" valign="middle" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php
$RDate = $row['scheduledDeliveryToCustomer'];
if($RDate != ""){
//echo("V ".date("W",strtotime($row['scheduledDeliveryToCustomer'])));
echo(substr($RDate,0,10));
}else{
$RDate = $row['RequestedDeliveryDate'];
echo(substr($RDate,0,10)."*");
}
?></a> </td>
<td width="110" bgcolor="<?php echo($color);?>" ><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['clientProjectManagerName']);?></a></td>
</tr>
</table>
<span class="style6">
<?php } ?>
<br>
<br>
</span>
<?php if($_GET['show'] == "archive"){?>
<a href="?" class="blacklink"><?php echo($a28);?></a>
<?php }else{?>
<a href="?show=archive" class="blacklink"><?php echo($a29);?></a>
<?php }?>
<span class="style6"><br>
<br>
</span>
<table width="547" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="18" bgcolor="#FF0000"> </td>
<td width="229"> <?php echo($a30);?> </td>
<td width="17" bgcolor="#ffc600"> </td>
<td width="283"> <?php echo($a33);?> </td>
</tr>
<tr class="text">
<td width="18"> </td>
<td width="229"> </td>
<td width="17"> </td>
<td> </td>
</tr>
<tr class="text">
<td width="18" bgcolor="#00FF00"> </td>
<td width="229"> <?php echo($a31);?> </td>
<td width="17" bgcolor="#0099FF"> </td>
<td> <?php echo($a34);?> </td>
</tr>
</table>
<br>
<table width="547" border="0" cellspacing="0" cellpadding="0">
<tr class="text">
<td width="18" bgcolor="#9966FF"> </td>
<td width="227"> <?php echo($a32);?> </td>
<td width="17" bgcolor="#CCCCCC"> </td>
<td width="285" bgcolor="#FFFFFF"> <?php echo($a35);?> </td>
</tr>
<tr class="text">
<td width="18"> </td>
<td width="227"> </td>
<td width="17" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr class="text">
<td width="18"><img src="../images/newMailMessage.gif" width="16" height="16"></td>
<td width="227" bgcolor="#FFFFFF"> <?php echo($a36a);?></td>
<td width="17" bgcolor="#FFFFFF">*</td>
<td bgcolor="#FFFFFF"> <?php echo($a114);?> </td>
</tr>
</table> <span class="style6"> </span></td>
<td width="30"> </td>
<td width="342" valign="top"><table width="342" height="140" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" background="../images/platta1a.jpg"><table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2"><?php echo($a37);?></span><form name="form1" method="post" action="addproject.php">
<table width="300" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="88" class="text"><?php echo($a2);?></td>
<td colspan="3"><div align="right">
<input name="Projectname" type="text" class="textthin" id="Projectname" size="30">
</div></td>
</tr>
<tr>
<td width="88" class="text"><?php echo($a23a );?></td>
<td colspan="3" align="right"><input name="Markning" type="text" class="textthin" id="Markning" size="30"></td>
</tr>
<tr>
<td class="text"><?php echo($a38);?></td>
<td colspan="3"><div align="right" class="textthin">
<script>DateInput('orderdate', true, 'YYYY-MM-DD')</script>
</div></td>
</tr>
<tr>
<td class="text"><?php echo($a39);?></td>
<td width="108"><div align="right">
<select name="type" id="type">
<option value="1">Order</option>
<option value="4">Estimat</option>
</select>
</div></td>
<td width="19"> </td>
<td width="85"><input name="Submit" type="submit" class="textthin" value="<?php echo($a97);?>"></td>
</tr>
</table>
</form> </td>
</tr>
</table></td>
</tr>
</table>
<br>
<?php
$showHrs = true;
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"sydtotal") || strpos($_SESSION['ASTACUS_SSO_INFO'][2],"imtech")){
if( strpos($_SESSION['ASTACUS_SSO_INFO'][2],"lan") === 0 || strpos($_SESSION['ASTACUS_SSO_INFO'][2],"ekonomi") === 0) {
$showHrs = true;
}else{
$showHrs = false;
}
}
if($showHrs == true ){?>
<table width="342" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" valign="top" background="../images/platta1.jpg"><br>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><span class="heading2"><?php echo($a45);?><br>
</span>
<table width="295" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="213" valign="top" class="textthin"><?php echo($a46);?> <a href="?page=sharedupload"><br>
</a></td>
<td width="30"> </td>
<td width="52"><span class="heading2"><a href="?page=report"><img src="../images/Forward-Arrow.png" width="45" height="45" border="0"></a></span></td>
</tr>
</table>
<span class="heading2"> </span></td>
</tr>
</table></td>
</tr>
</table>
<?php }?>
<br>
<table width="342" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" valign="top" background="../images/platta1.jpg"><br>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><span class="heading2"><?php echo($a47);?><br>
</span>
<table width="295" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="213" valign="top" class="textthin"><?php echo($a48);?> <a href="?page=sharedupload"><br>
</a></td>
<td width="30"> </td>
<td width="52"><span class="heading2"><a href="?page=usersettings"><img src="../images/Forward-Arrow.png" width="45" height="45" border="0"></a></span></td>
</tr>
</table>
<span class="heading2"> </span></td>
</tr>
</table></td>
</tr>
</table> <br>
</td>
</tr>
</table>
<span class="style6"><br>
</span>
<hr width="820" size="1">
<span class="style6"> </span></td>
</tr>
</table>
</td>
<td width="11"> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
</table>