| Server IP : 79.136.114.73 / Your IP : 3.142.97.186 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/appsrv.astacus.se/reports/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>AstacusProject - Projektraport</title>
<style type="text/css">
<!--
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.style4 {font-size: 12px}
.style7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
.style8 {color: #FFCC00}
-->
</style>
</head>
<body alink="#000000" vlink="#000000" link="#000000">
<?php
function daysDifference($endDate, $beginDate)
{
//explode the date by "-" and storing to array
$date_parts1=explode("-", $beginDate);
$date_parts2=explode("-", $endDate);
//gregoriantojd() Converts a Gregorian date to Julian Day Count
$start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]);
$end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]);
return $end_date - $start_date;
}
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$sql ="SELECT SystemUser.Name as Name, Email, SystemUser.SystemUserId as SystemUserId
FROM ProjectSystemUserJoin , SystemUser, Project
WHERE ProjectSystemUserJoin.UserGroupId = 5
AND SystemUser.SystemUserId = ProjectSystemUserJoin.SystemUserId
AND SystemUserStatusId =1
AND ProjectSystemUserJoin.ProjectId = Project.ProjectId
AND NOT (Project.ProjectStatusId = 9 OR Project.ProjectStatusId = 10 OR Project.ProjectStatusId = 11)
GROUP BY ProjectSystemUserJoin.SystemUserId";
$result2 = mysql_query($sql);
while ($row2 = mysql_fetch_assoc($result2)){
$SystemUserId = $row2['SystemUserId'];
$sql = "select * from SystemUser where SystemUserId = $SystemUserId";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$Name = $row['Name'];
}
?>
<br>
<br>
<table width="642" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" class="style7">Projektrapport för: <?php echo($Name);?></td>
</tr>
<tr>
<td colspan="4" class="style3"> </td>
</tr>
<tr>
<td width="40" bgcolor="#00FF00" class="style3"> </td>
<td width="211" class="style3"> Projektet är levererat </td>
<td width="40" bgcolor="#66CCFF" class="style3"> </td>
<td width="351" class="style3"> Produktion pågår </td>
</tr>
<tr>
<td colspan="4" class="style3"> </td>
</tr>
<tr>
<td bgcolor="#FFCC00" class="style3"> </td>
<td class="style3"> Misstänkt felaktig status </td>
<td bgcolor="#FF0000" class="style3"> </td>
<td class="style3"> RFMI eller leveransdatum har passerat </td>
</tr>
<tr>
<td colspan="4" class="style3"> </td>
</tr>
<tr>
<td colspan="4" class="style3"> </td>
</tr>
</table>
<table width="1066" border="0" cellspacing="0" cellpadding="0" bgcolor="<?php echo($color) ?>">
<tr>
<td width="10"><span class="style4"></span></td>
<td width="420" class="style7"><strong><a href="?id=<?php echo($_GET['id']);?>&sort=CompanyId">Projekt</a>:</strong></td>
<td width="120" class="style7"><span class="style7"><a href="?id=<?php echo($_GET['id']);?>&sort=createDate">Startdatum</a>:</span></td>
<td width="120" class="style7"><span class="style7"><a href="?id=<?php echo($_GET['id']);?>&sort=RequestedDeliveryDate">Lev. datum</a>:</span> </td>
<td width="134" class="style7"><span class="style7"><a href="?id=<?php echo($_GET['id']);?>&sort=ProjectTypeDisplayValue">Projekttyp</a>:</span></td>
<td width="160" class="style7"><a href="?id=<?php echo($_GET['id']);?>&sort=JobTypeDisplayValue">Typ</a>:</td>
<td width="102" class="style7"><span class="style7"><a href="?id=<?php echo($_GET['id']);?>&sort=ProjectStatusDisplayValue">Status</a>:</span></td>
</tr>
</table>
<?php
$Order = $_GET['sort'];
$sql = "SELECT Project.CompanyId, Project.Name, Company.Name as Company, JobTypeDisplayValue, Project.ProjectId, createDate, ProjectType.ProjectTypeDisplayValue, ProjectStatus.ProjectStatusDisplayValue, RequestedDeliveryDate, Project.ProjectStatusId, Project.ProjectStatusId
FROM ProjectSystemUserJoin, Project, ProjectStatus, ProjectType, Company, JobType, SystemUser
WHERE ProjectSystemUserJoin.ProjectId = Project.ProjectId
AND ProjectStatus.ProjectStatusId = Project.ProjectStatusId
AND ProjectType.ProjectTypeId = Project.ProjectTypeId
AND ProjectSystemUserJoin.SystemUserId = $SystemUserId
AND Company.CompanyId = Project.CompanyId
AND JobType.JobTypeId = Project.JobTypeId
AND (
Project.ProjectStatusId <9
OR Project.ProjectStatusId =12
)
AND ProjectSystemUserJoin.UserGroupId =5
GROUP BY Project.ProjectId";
if($Order != ""){
$sql = $sql . " ORDER BY $Order";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$CompanyId = $row['CompanyId'];
$Company = $row['Company'];
$Name = $row['Name'];
$ProjectId = $row['ProjectId'];
$createDate = substr($row['createDate'],0,10);
$ProjectTypeDisplayValue= $row['ProjectTypeDisplayValue'];
$ProjectStatusDisplayValue = $row['ProjectStatusDisplayValue'];
$RequestedDeliveryDate = substr($row['RequestedDeliveryDate'],0,10);
$ProjectStatusId = $row['ProjectStatusId'];
$JobTypeDisplayValue = $row['JobTypeDisplayValue'];
$color = "#FFFFFF";
$d = date("Y-m-d",strtotime($createDate));
$days = daysDifference(date("Y-m-d"),$d);
if($ProjectStatusId == 1 && $days > 6){
$color = "#FFCC00";
}
if($row['ProjectStatusId'] == 6 || $row['ProjectStatusId'] == 7){
$color = "#66CCFF";
}
if($row['ProjectStatusId'] == 12){
$color = "#FF0000";
}
if($RequestedDeliveryDate != ""){
$d = date("Y-m-d", strtotime($RequestedDeliveryDate));
if($d < date("Y-m-d") && $ProjectStatusId < 8){
$color = "#FF0000";
}
}
if($ProjectStatusId > 7 && $ProjectStatusId != 12){
$color = "#00FF66";
}
?>
<table width="1225" border="0" cellspacing="0" cellpadding="0" bgcolor="<?php echo($color) ?>">
<tr>
<td width="11"><span class="style4"></span></td>
<td width="419"><span class="style3"><a href="http://astacusproject.astacus.se/astacusproject/ProjectSelected.do?projectId=<?php echo($ProjectId);?>" target="_blank" title="<?php echo($Company);?>"><?php echo($CompanyId."_".$Name." (".$ProjectId.")");?></a></span></td>
<td width="119"><span class="style3"><?php echo($createDate);?></span></td>
<td width="121"><span class="style3"><?php echo($RequestedDeliveryDate);?></span> </td>
<td width="134"><span class="style3"><?php echo($ProjectTypeDisplayValue);?></span></td>
<td width="160"><span class="style3"><?php echo($JobTypeDisplayValue);?></span></td>
<td width="261"><span class="style3"><?php echo($ProjectStatusDisplayValue);?></span></td>
</tr>
</table>
<?php
}
}
?>
<p> </p>
<p class="style8"> </p>
<p class="style8"> </p>
</body>
</html>