| Server IP : 79.136.114.73 / Your IP : 216.73.216.217 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/project/ |
Upload File : |
<?php
session_start();
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$countryId = $_SESSION['ASTACUS_SSO_INFO'][12];
?>
<html>
<head>
<meta charset="iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="330" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif;">Project</td>
<td width="220" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">SR</td>
<td width="60" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">%</td>
<td width="85" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">QC Budget</td>
<td width="85" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">QC Spent</td>
<td width="90" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Prod. Comp.</td>
<td width="84" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Cust. Del.</td>
<td width="192" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"> </td>
<td width="97" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Order value</td>
</tr>
</tbody>
</table>
<?php
$TimeTotal = 0;
$TimeTotal2 = 0;
//$sql = "SELECT * FROM Project, ProjectStatus, ProjectManager WHERE ProjectManager.ProjectId = Project.ProjectId and Project.ProjectStatusId = ProjectStatus.ProjectStatusId and Project.ProjectStatusId != 8 and Project.ProjectStatusId != 9 and Project.ProjectStatusId != 10 and Project.ProjectStatusId != 11 and (TimeSpent/TimeReal) > 0.50 and not Project.Description = 'iCAD-Project' group by Project.ProjectId order by Project.CustomerDeliveryDate asc ";
$sql = "SELECT * FROM Project, ProjectStatus, ProjectManager WHERE ProjectManager.ProjectId = Project.ProjectId and Project.ProjectStatusId = ProjectStatus.ProjectStatusId and ProjectStatus.Grouping = 'Project flow' and not Project.ProjectStatusId = 8 and (TimeSpent/TimeReal) > 0.10 and not Project.Description = 'iCAD-Project' order by Project.CustomerDeliveryDate asc ";
$result = mysql_query($sql);
$tot = 0;
$tot2 = 0;
$week = -1;
$TotalOrderWeek = 0;
while ($row = mysql_fetch_assoc($result)){
$sql = "SELECT * FROM ProjectManager, SystemUser where ProjectId = '".$row['ProjectId']."' and SystemUser.SystemUserId = ProjectManager.UserId";
$Time = round($row['TimeSpent']*0.04,1);
if($Time < 0.25){
$Time = 0.25 ;
}
$tot += $Time;
///
$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total2, Username FROM `ProjectTimeV2` WHERE ProjectId = ".$row['ProjectId']." and (ActivityId = 13) GROUP BY PID";
$TotalAdmin = 0;
$result10 = mysql_query($sql);
$Topic = "";
while ($row10 = mysql_fetch_assoc($result10)){
if($row10['Username'] == "cibelia.redha@astacus.se"){
$TotalAdmin = ($row10['Total2']/60)*0.5;
}else{
$TotalAdmin = $row10['Total2']/60;
}
}
$sql = "SELECT ProjectId as PID, (SUM(Hrs*60) + SUM(Min)) as Total2 FROM `ProjectTimeV2_India` WHERE ProjectId = ".$row['ProjectId']." and (ActivityId = 34 or ActivityId = 27) GROUP BY PID";
$result10 = mysql_query($sql);
while ($row10 = mysql_fetch_assoc($result10)){
$TotalAdmin += $row10['Total2']/60;
}
// $TotalAdmin = round($TotalAdmin,2);
$Time2 = $TotalAdmin;
$QCFOLK = "";
$sql = "SELECT Username FROM `ProjectTimeV2` WHERE ProjectId = ".$row['ProjectId']." and (ActivityId = 13) GROUP BY Username";
$result10 = mysql_query($sql);
while ($row10 = mysql_fetch_assoc($result10)){
$QCFOLK .= $row10['Username'] .", ";
}
$sql = "SELECT Username FROM `ProjectTimeV2_India` WHERE ProjectId = ".$row['ProjectId']." and (ActivityId = 34 or ActivityId = 27) GROUP BY Username";
$result10 = mysql_query($sql);
while ($row10 = mysql_fetch_assoc($result10)){
$QCFOLK .= $row10['Username'] .", ";
}
////
$tot2 += $Time2;
$result7 = mysql_query($sql);
$AstacusPM = "";
while ($row7 = mysql_fetch_assoc($result7)){
$AstacusPM = $row7['Name'];
}
if($AstacusPM != $AstacusPMLast){
echo("<br>");
// echo("Tot: $tot h<br>");
// $tot = 0;
}
$AstacusPMLast = $AstacusPM ;
$sql = "SELECT * FROM ICADBalls WHERE ProjectId = ".$row['ProjectId'];
$SRID = "";
$result55 = mysql_query($sql);
while ($row55 = mysql_fetch_assoc($result55)){
$SRID = $row55['SystemUserId'];
}
if($SRID != ""){
$sql = "SELECT * FROM SystemUser WHERE SystemUserId = $SRID";
$result55 = mysql_query($sql);
while ($row55 = mysql_fetch_assoc($result55)){
$AstacusSR = $row55['Name'];
}
}
$QCdate = $row['CustomerDeliveryDate'];
$week1 = date("W", strtotime( $QCdate));
$color = $row['Color'];
?>
<?php if($week != $week1){?>
<?php
$QCdate = $row['scheduledDeliveryDate'];
$week = date("W", strtotime( $QCdate));
}?>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr bgcolor="<?php echo($color);?>">
<td width="330" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><a href="index.php?companyId=&page=project&projectId=<?php echo($row['ProjectId']);?>" target="_new"><?php echo($row['CompanyId']);?>_<?php echo($row['Name']);?> (<?php echo($row['ProjectId']);?>)</a></td>
<td width="220" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($AstacusSR);?></td>
<td width="61" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><a href="?companyId=<?php echo($_GET['companyId']);?>&page=<?php echo($goto_page);?>&projectId=<?php echo($row['ProjectId']);?>" class="blacklinkthin">
<?php
if($row['TimeReal'] != 0){
echo(round(100*($row['TimeSpent']/$row['TimeReal']))." %");
}else{
echo("0 %");
}
?>
</a></td>
<td width="86" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($Time);
$TimeTotal = $Time + $TimeTotal;
$Weektime = $Time + $Weektime;
?> h</td>
<td width="85" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><a href="javascript:alert('<?php echo($QCFOLK);?>');"><?php echo($Time2);
$TimeTotal2 = $Time2 + $TimeTotal2;
$Weektime2 = $Time2 + $Weektime2;
?> h</a></td>
<td width="90" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php
echo( $row['ProductionCompletedDate'] );
?></td>
<td width="82" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php
echo( $row['CustomerDeliveryDate'] );
?></td>
<td width="189" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">
<?php
$old_week = $new_week;
if($row['CustomerDeliveryDate'] != "0000-00-00"){
$date = new DateTime($row['CustomerDeliveryDate']);
$new_week = $date->format("W");
echo("V".$new_week);
}
if($new_week != $old_week){
//echo("<p></p>");
$old_week ="";
}
?>
</td>
<td width="100" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php
$OrderWeek += $row['STATOrderValue'];
echo($row['STATOrderValue']);
?> €</td>
</tr>
</tbody>
</table>
<?php
}
?>
</p>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="331"> </td>
<td width="220"> </td>
<td width="60"> </td>
<td width="87" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($TimeTotal);?> h</td>
<td width="85" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($TimeTotal2);?> h</td>
<td width="90"> </td>
<td width="81"> </td>
<td width="190"> </td>
<td width="99"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">
<?php
echo($TotalOrderWeek);
?>
€</span></td>
</tr>
</tbody>
</table>
<p> </p>
</body>
</html>