| 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/productionzon/ |
Upload File : |
<?php
?>
<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="1000" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="90"> </td>
<td width="820"><table width="820" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" valign="top"><span class="heading2">Your account : </span><br>
<table width="820" border="0" cellpadding="0" cellspacing="0">
<tr >
<td width="76" class="text">Name:</td>
<td width="197" class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][1]);?> (<?php echo($_SESSION['ASTACUS_SSO_INFO'][10]);?>) </td>
<td class="text">Phone:</td>
<td class="text"><span class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][6]);?></span></td>
<td width="1" rowspan="4" bgcolor="#999999" class="textthin"></td>
<td width="310" rowspan="4" valign="top" class="textthin"><table width="228" border="0" align="center" cellpadding="0" cellspacing="0">
<tr class="text">
<td width="89">Swedish time: </td>
<td width="71">Indian time: </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">E-mail:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][2]);?></td>
<td class="text">Address:</td>
<td class="textthin"><?php echo($_SESSION['ASTACUS_SSO_INFO'][7]);?></td>
</tr>
<tr >
<td class="text">SkypeID:</td>
<td class="textthin"><a href="skype:<?php echo($_SESSION['ASTACUS_SSO_INFO'][11]);?>?call"><img src="http://mystatus.skype.com/smallicon/<?php echo($_SESSION['ASTACUS_SSO_INFO'][11]);?>" alt="My status" width="16" height="16" align="absmiddle" style="border: none;" /></a> <?php echo($_SESSION['ASTACUS_SSO_INFO'][11]);?></td>
<td class="text">Postal address:</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 width="820" size="1">
<span class="heading2"><br>
</span>
<table width="815" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><span class="heading2">Project Status (<a href="?order=Project.ProjectStatusId">Order By</a>)</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"> </td>
</tr>
</table>
<span class="style6"> </span></td>
<td align="right"><table width="342" height="121" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="342" background="../images/platta1.jpg"><table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2">Search projects: </span>
<form name="form1" method="get" action="index.php">
<table width="300" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90" class="text">Customer ID:</td>
<td width="210"><div align="right">
<input name="CustomerID" type="text" class="textthin" id="CustomerID" size="10">
<input name="Submit" type="submit" class="textthin" value="Show">
</div></td>
</tr>
</table>
</form>
<form name="form1" method="get" action="index.php?page=project">
<table width="300" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90" class="text">Project ID:</td>
<td width="210"><div align="right">
<input name="page" type="hidden" id="page" value="project">
<input name="projectId" type="text" class="textthin" id="projectId" size="10">
<input name="Submit" type="submit" class="textthin" value="Show">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<span class="heading2"> <br>
<br>
<br>
</span>
<table width="820" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="677" valign="top">
<table width="780" height="58" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="heading2">Projects for client: <?php echo($_GET['CustomerID']);?> </span> <span class="heading2"><?php echo("<a href='../admin/arkiv_inloggning.php?companyId=".$_GET['CustomerID']."' target='_NEW'> [Open iCAD Archive]</a>")?></span><br>
<table width="818" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="76" class="style6"><strong><a href="?order=Project.CompanyId" class="blacklink">CID</a></strong></td>
<td width="65" class="style6"><strong><a href="?order=Project.ProjectId" class="blacklink">PID</a></strong></td>
<td width="190" class="style6"><strong><a href="?order=Name" class="blacklink">Project name </a></strong></td>
<td width="169" class="text"><span class="style6"><strong><a href="?order=Name" class="blacklink">Estimated hours </a></strong></span></td>
<td width="100" class="text"><span class="style6"><strong><a href="?order=Name" class="blacklink">Spent hours</a></strong></span></td>
<td width="90" class="style6"><strong><a href="?order=RequestedDeliveryDate" class="blacklink">Scheduled del.</a></strong></td>
<td width="128"><span class="style6"><strong><a href="?order=clientProjectManagerName" class="blacklink">Created by: </a></strong></span></td>
</tr>
</table>
<span class="style6">
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$orderby = $_GET['order'];
if($orderby == ""){
$orderby = "Project.ProjectId";
}
if($orderby == "ProjectStatusId"){
$orderby = "ProjectStatus.ProjectStatusId";
}
$CompanyId = $_GET['CustomerID'];
$SystemUserId = $_SESSION['ASTACUS_SSO_INFO'][0];
if($CompanyId == ""){
//$sql = "SELECT * FROM Project, ProjectStatus, ProjectSystemUserJoin WHERE ProjectSystemUserJoin.UserGroupId = 6 and Project.ProjectId = ProjectSystemUserJoin.ProjectId and ProjectSystemUserJoin.SystemUserId = $SystemUserId and Project.ProjectStatusId = ProjectStatus.ProjectStatusId and not ProjectStatus.ProjectStatusID = 11 and not ProjectStatus.ProjectStatusID = 10 order by $orderby desc";
$sql = "SELECT * FROM Project, ProjectStatus, ICADAccount WHERE ICADAccount.CustomerID = Project.CompanyId and Project.ProjectStatusId = ProjectStatus.ProjectStatusId and not ProjectStatus.ProjectStatusID = 11 and not ProjectStatus.ProjectStatusID = 10 and ICADAccount.ICADContact = $SystemUserId group by Project.ProjectId order by $orderby desc ";
}else{
$sql = "SELECT * FROM Project, ProjectStatus WHERE Project.ProjectStatusId = ProjectStatus.ProjectStatusId and CompanyId = $CompanyId and not ProjectStatus.ProjectStatusID = 11 and not ProjectStatus.ProjectStatusID = 10 order by $orderby desc";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$sql = "SELECT * FROM ProjectLog Where ProjectId = ".$row['ProjectId']." order by LogDate desc LIMIT 1";
$result2 = mysql_query($sql);
while ($row2 = mysql_fetch_assoc($result2)){
$prio = $row2['Prio'];
}
$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 = 4 or FromGroup = 8";
$newMessage = "";
$result5 = mysql_query($sql);
while ($row5 = mysql_fetch_assoc($result5)){
if( $row5['Read'] == 1){
$newMessage = "<img src='../images/newMailMessage.gif'>";
}
}
?>
</span>
<table width="819" border="0" cellspacing="0" cellpadding="0">
<tr align="left" >
<td width="30" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['CompanyId']);?></a></td>
<td width="21" bgcolor="<?php echo($color);?>"><img src="../images/prio<?php echo($prio);?>.gif" width="20" height="15"></td>
<td width="25" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['ProjectId']);?></a></td>
<td width="65" align="right" bgcolor="<?php echo($color);?>"><?php echo($newMessage);?></td>
<td width="191" height="20" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['Name']);?></a></td>
<td width="169" bgcolor="<?php echo($color);?>"><span class="textthin"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin">
<?php if($row['estimatedICADHours'] >0){echo($row['estimatedICADHours']." h");}?>
</a></span></td>
<td width="99" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin"><?php echo($row['TimeEstimationFromIndia']);?> h</a></td>
<td width="96" valign="middle" bgcolor="<?php echo($color);?>"><a href="?page=project&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin">
<?php
$RDate = $row['scheduledDeliveryToCustomer'];
if($RDate != ""){
echo(substr($row['scheduledDeliveryToCustomer'],0,10));
}
?>
</a> </td>
<td width="123" 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></td>
</tr>
</table>
<span class="style6"> </span></td>
</tr>
</table>
<span class="style6"><br>
</span>
<hr width="820" size="1">
<span class="style6"> </span></td>
</tr>
</table>
</td>
<td width="90"> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
</table>