| Server IP : 79.136.114.73 / Your IP : 216.73.216.55 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/workorder/ |
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>Workorder list</title>
<script>
function jumpMenu(projectid){
var Status = document.getElementById("Status"+projectid)[document.getElementById("Status"+projectid).selectedIndex].value;
//alert(Status);
location.href = "updateStatus.php?projectId="+projectid+"&status="+Status;
}
</script>
</head>
<body>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="246" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif;">Project</td>
<td width="129" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">SR</td>
<td width="106" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Budget</td>
<td width="98" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Start</td>
<td width="98" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">End</td>
<td width="269" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Address</td>
<td width="112" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif">Status</td>
</tr>
</tbody>
</table>
<?php
$date1 = date('Y-m-d',strtotime('-6 months'));
$TimeTotal = 0;
$X_TOT = 0;
$sql = "SELECT * FROM Workorder, Project WHERE Workorder.ProjectId = Project.ProjectId AND Enddatetime > '$date1' Order by Startdatetime asc";
$result = mysql_query($sql);
$tot = 0;
$week = -1;
while ($row = mysql_fetch_assoc($result)){
$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['Startdatetime'];
$week1 = date("W", strtotime( $QCdate));
if($row['Status'] == 0){
$color = "#ffc000";
}else if($row['Status'] == 1){
$color = "#d5d5d5";
}else{
$color = "#00ff06";
}
?>
<?php if($week != $week1){?>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0" bgcolor="#9d9fa2">
<tbody>
<tr>
<td width="376" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"> </td>
<td width="682" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($X_TOT);
$X_TOT = 0;
?> h</td>
</tr>
</tbody>
</table>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
<tbody>
<tr>
<td width="522" style="color: #FFFFFF; font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><br>
Week: <?php echo(date("Y", strtotime( $QCdate)) ." - ". $week1);?><br>
<br></td>
<td width="183"> </td>
<td width="157"> </td>
<td width="52"> </td>
<td width="83" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><p><br>
<br>
<br>
</p></td>
<td width="100"> </td>
<td width="117"> </td>
<td width="100"> </td>
</tr>
</tbody>
</table>
<?php
$QCdate = $row['Startdatetime'];
$week = date("W", strtotime( $QCdate));
}
?>
<table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr bgcolor="<?php echo($color);?>">
<td width="246" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><a href="index.php?projectId=<?php echo($row['ProjectId']);?>" target="_new"><?php echo($row['CompanyId']);?>_<?php echo($row['Name']);?> (<?php echo($row['ProjectId']);?>)</a></td>
<td width="138" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($AstacusSR);?></td>
<td width="98" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($row['Budget']);
$X_TOT = $X_TOT + $row['Budget'];
?> h</td>
<td width="98" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php
echo(substr($row['Startdatetime'],0,10));
?></td>
<td width="98" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php
echo(substr($row['Enddatetime'],0,10));
?></td>
<td width="286" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><?php echo($row['Address']);
?></td>
<td width="110" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif"><select name="Status" id="Status<?php echo($row['ProjectId']);?>" onChange="jumpMenu(<?php echo($row['ProjectId']);?>);">
<option value="0" <?php if($row['Status'] == 0){echo("selected");}?>>Requested</option>
<option value="1" <?php if($row['Status'] == 1){echo("selected");}?>>Planned</option>
<option value="2" <?php if($row['Status'] == 2){echo("selected");}?>>Completed</option>
<option value="3" <?php if($row['Status'] == 3){echo("selected");}?>>Data Capture</option>
</select></td>
</tr>
</tbody>
</table>
<?php
}
?>
</p>
</body>
</html>