| Server IP : 79.136.114.73 / Your IP : 216.73.216.57 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/schedule/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
if($_GET['date'] == ""){
$TodaysDate = date("Y-m-d");
}else{
$TodaysDate = date("Y-m-d",strtotime($_GET['date'] ));
}
$sql = "SELECT DeskSchedule.ProjectId, DeskSchedule.Shift, Desks.Name as DName, Project.Name as Name, Project.CompanyId as CompanyId, DeskSchedule.DeskId, DeskSchedule.Hrs, Project.TimeReal as TimeReal, Project.TimeSpent as TimeSpent, Project.CustomerDeliveryDate FROM DeskSchedule, Desks, Project where Desks.DeskID =DeskSchedule.DeskId and Project.ProjectId = DeskSchedule.ProjectId and DeskDate = '$TodaysDate' ";
$result = mysql_query($sql);
$Desk = array("","","","","","","","","","","","","","","","","","","","","","","","","","","","","","");
$DeskInfo = array("","","","","","","","","","","","","","","","","","","","","","","","","","","","","","");
$DeskInfoList = array("","","","","","","","","","","","","","","","","","","","","","","","","","","","","","");
$DeskInfoHrs = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$Estimate = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$Spent = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
while ($row = mysql_fetch_assoc($result)){
$Desk[$row['DeskId']] = $row['DName'];
$DeskInfo[$row['DeskId']] .= "Project: ". $row['CompanyId']."_".$row['Name']. " (".$row['ProjectId']. ") Shift: ".$row['Shift']. " Hrs: ".$row['Hrs']."<br><br>";
$ScheduledDeliveryToCustomer = substr($row['CustomerDeliveryDate'],0,10);
$DeskInfoList[$row['DeskId']] .= $row['CompanyId']."_".$row['Name']. " (".$row['ProjectId']. ") L: ". $ScheduledDeliveryToCustomer ." <br>";
$DeskInfoHrs[$row['DeskId']] += $row['Hrs'];
if($row['Shift'] == 3){
$DeskInfoHrs[$row['DeskId']] += $row['Hrs'];
}
$Estimate[$row['DeskId']] = $row['TimeReal'];
$TimeSpent[$row['DeskId']] = $row['TimeSpent'];
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
<title>Untitled Document</title>
<style type="text/css">
#SYS175 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 298px;
top: 398px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS187 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 333px;
top: 398px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus03 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 333px;
top: 339px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus04 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 127px;
top: 396px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus05 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 127px;
top: 338px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS123 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 299px;
top: 203px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus07 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 298px;
top: 144px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus08 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 297px;
top: 85px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS235 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 332px;
top: 203px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS300 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 332px;
top: 144px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus11 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 333px;
top: 85px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS131 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 504px;
top: 398px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS101 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 503px;
top: 339px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus14 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 504px;
top: 200px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus15 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 503px;
top: 141px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus16 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 504px;
top: 82px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS157 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 538px;
top: 200px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS180 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 539px;
top: 141px;
background-color: #00FF00;
opacity: 0.5;
}
#SYS165 {
position: absolute;
width: 32px;
height: 56px;
z-index: 1;
left: 539px;
top: 83px;
background-color: #00FF00;
opacity: 0.5;
}
.rubrik {
font-family: Verdana, Geneva, sans-serif;
font-size: 24px;
text-align: center;
}
/* Tooltip container */
.tooltip {
position: relative;
display: inline-block;
border-bottom: 1px dotted black; /* If you want dots under the hoverable text */
}
/* Tooltip text */
.tooltip .tooltiptext {
visibility: hidden;
width: 120px;
background-color: #000;
color: #fff;
text-align: center;
padding: 5px 0;
border-radius: 6px;
/* Position the tooltip text */
position: absolute;
z-index: 1;
bottom: 125%;
left: 50%;
margin-left: -60px;
/* Fade in tooltip */
opacity: 1;
transition: opacity 1s;
}
/* Tooltip arrow */
.tooltip .tooltiptext::after {
content: "";
position: absolute;
top: 100%;
left: 50%;
margin-left: -5px;
border-width: 5px;
border-style: solid;
border-color: #555 transparent transparent transparent;
}
/* Show the tooltip text when you mouse over the tooltip container */
.tooltip:hover .tooltiptext {
visibility: visible;
opacity: 1;
}
</style>
<script>
function MM_openBrWindow2(theURL,winName) { //v2.0
window.open(theURL,winName,'status=yes, resizable=yes','width='+screen.width,'height='+screen.height);
}
function MM_openBrWindow2(theURL,winName,extra) { //v2.0
window.open(theURL,winName,extra);
}
function show(name){
if(name == "free"){
MM_openBrWindow2('Find.php?&Startdate=<?php echo($TodaysDate);?>','win','scrollbars=yes,width=670,height=400');
}else{
MM_openBrWindow2('Bookdesk.php?DeskName='+name+'&Startdate=<?php echo($TodaysDate);?>','win','scrollbars=yes,width=670,height=400');
}
}
function init(){
<?php
$text = "";
for ($i = 1; $i <= 30; $i++) {
if($Desk[$i] != ""){
if(strpos($DeskInfoList[$i], "24441") !== false){
echo('document.getElementById("'.$Desk[$i].'").style.backgroundColor = "#000000";');
}else{
if($DeskInfoHrs[$i] > 1 && $DeskInfoHrs[$i] <= 7 ){
echo('document.getElementById("'.$Desk[$i].'").style.backgroundColor = "#f4f700";');
}else if($DeskInfoHrs[$i] > 7 && $DeskInfoHrs[$i] <= 13){
echo('document.getElementById("'.$Desk[$i].'").style.backgroundColor = "#f7a300";');
}else if($DeskInfoHrs[$i] > 13){
echo('document.getElementById("'.$Desk[$i].'").style.backgroundColor = "#FF0000";');
}
}
echo('document.getElementById("'.$Desk[$i].'").style.opacity = 0.7;');
echo('document.getElementById("'.$Desk[$i].'A").innerHTML = "'.$DeskInfo[$i]." Total Hrs: ".$DeskInfoHrs[$i]." ".'";');
}
}
?>
}
</script>
<meta http-equiv="refresh" content="3600;URL='https://icad.astacus.se/project/schedule/" >
</head>
<body onload="init();">
<table width="100%" border="0">
<tbody>
<tr>
<td valign="top"><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr> </tr>
<tr>
<td colspan="5"><br />
<img src="background.png" alt="" width="800" /><br /></td>
<td colspan="5" valign="top"></td>
<td colspan="5"><a href="" onclick="show('SYS175');">
<div id="SYS175" class="tooltip"><span class="tooltiptext" id="SYS175A">Empty!</span></div>
</a> <a href="" onclick="show('SYS187');">
<div id="SYS187" class="tooltip"><span class="tooltiptext" id="SYS187A">Empty!</span></div>
</a> <a href="" onclick="show('astacus03');">
<div id="astacus03" class="tooltip"><a href="" onclick="show('astacus03');"><span class="tooltiptext" id="astacus03A">Empty!</span></div>
</a> <a href="" onclick="show('astacus05');">
<div id="astacus05" class="tooltip"><span class="tooltiptext" id="astacus05A">Empty!</span></div>
</a> <a href="" onclick="show('astacus04');">
<div id="astacus04" class="tooltip"><span class="tooltiptext" id="astacus04A">Empty!</span></div>
</a> <a href="" onclick="show('SYS123');">
<div id="SYS123" class="tooltip"><span class="tooltiptext" id="SYS123A">Empty!</span></div>
</a> <a href="" onclick="show('astacus07');">
<div id="astacus07" class="tooltip"><span class="tooltiptext" id="astacus07A">Empty!</span></div>
</a> <a href="" onclick="show('astacus08');">
<div id="astacus08" class="tooltip"><span class="tooltiptext" id="astacus08A">Empty!</span></div>
</a> <a href="" onclick="show('SYS235');">
<div id="SYS235" class="tooltip"><span class="tooltiptext" id="SYS235A">Empty!</span></div>
</a> <a href="" onclick="show('SYS300');">
<div id="SYS300" class="tooltip"><span class="tooltiptext" id="SYS300A">Empty!</span></div>
</a> <a href="" onclick="show('astacus11');">
<div id="astacus11" class="tooltip"><span class="tooltiptext" id="astacus11A">Empty!</span></div>
</a> <a href="" onclick="show('SYS131');">
<div id="SYS131" class="tooltip"><span class="tooltiptext" id="SYS131A">Empty!</span></div>
</a> <a href="" onclick="show('SYS101');">
<div id="SYS101" class="tooltip"><span class="tooltiptext" id="SYS101A">Empty!</span></div>
</a> <a href="" onclick="show('astacus14');">
<div id="astacus14" class="tooltip"><span class="tooltiptext" id="astacus14A">Empty!</span></div>
</a> <a href="" onclick="show('astacus15');">
<div id="astacus15" class="tooltip"><span class="tooltiptext" id="astacus15A">Empty!</span></div>
</a> <a href="" onclick="show('astacus16');">
<div id="astacus16" class="tooltip"><span class="tooltiptext" id="astacus16A">Empty!</span></div>
</a> <a href="" onclick="show('SYS157');">
<div id="SYS157" class="tooltip"><span class="tooltiptext" id="SYS157A">Empty!</span></div>
</a> <a href="" onclick="show('SYS180');">
<div id="SYS180" class="tooltip"><span class="tooltiptext" id="SYS180A">Empty!</span></div>
</a> <a href="" onclick="show('SYS165');">
<div id="SYS165" class="tooltip"><span class="tooltiptext" id="SYS165A">Empty!</span></div>
</a></td>
</tr>
<tr>
<td width="109"> </td>
<td width="282"> </td>
<td width="500"><p class="rubrik">
<?php
$date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d');
$prev_date = date('Y-m-d', strtotime($date .' -1 day'));
$next_date = date('Y-m-d', strtotime($date .' +1 day'));
?>
<a href="?date=<?php echo($prev_date);?>"><-- </a><?php echo($TodaysDate);?> <a href="?date=
<?php echo($next_date);?>"> --></a></p>
<p class="rubrik"> </p></td>
<td width="218"> </td>
<td width="273"> </td>
</tr>
<tr></tr>
</table></td>
<td valign="top"><br>
<br /><br>
<span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 9"> <strong>Registration</strong></span>
<table width="800" border="1" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 9">
<tbody>
<tr>
<td width="75">Table:</td>
<td width="466">Projects:</td>
<td width="60"> Today:</td>
<td width="57"> </td>
<td width="57"> </td>
<td width="45"> </td>
</tr>
<?php
$tot = 0;
for ($i = 1; $i <= 30; $i++) {
if(strpos($DeskInfoList[$i], "24441") === false){
if($Desk[$i] != "" && (strpos($Desk[$i], "175") !== false or strpos($Desk[$i], "187") !== false)){
$tot += $DeskInfoHrs[$i];
?>
<tr>
<td width="75"valign="top"><?php echo($Desk[$i]);?> </td>
<td width="466" valign="top"><?php echo($DeskInfoList[$i]);?></td>
<td width="60"valign="top"><?php echo($DeskInfoHrs[$i]);?> h </td>
<td width="57"> </td>
<td width="57"> </td>
<td width="45"> </td>
</tr>
<?php }}
}?>
</tbody>
</table>
<br />
<span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 9"><strong>Production</strong></span><br />
<table width="800" border="1" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 9">
<tbody>
<tr>
<td width="75">Table:</td>
<td width="466">Projects:</td>
<td width="60"> Today:</td>
<td width="57">Spent:</td>
<td width="57">Est:</td>
<td width="45">%</td>
</tr>
<?php
$tot = 0;
for ($i = 1; $i <= 30; $i++) {
if(strpos($DeskInfoList[$i], "24441") === false){
if($Desk[$i] != "" && (strpos($Desk[$i], "175") === false or strpos($Desk[$i], "187") === false)){
$tot += $DeskInfoHrs[$i];
?>
<tr>
<td width="75"valign="top"><?php echo($Desk[$i]);?></td>
<td width="466" valign="top"><?php echo($DeskInfoList[$i]);?></td>
<td width="60"valign="top"><?php echo($DeskInfoHrs[$i]);?> h </td>
<td width="57"><?php echo($TimeSpent[$i]);?> h </td>
<td width="57"><?php echo($Estimate[$i]);?> h </td>
<td width="45"><?php echo(round(($TimeSpent[$i] /$Estimate[$i])*100) );?>%</td>
</tr>
<?php }}
}?>
</tbody>
</table>
<table width="800" border="1" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 9">
<tbody>
<tr>
<td width="76"></td>
<td width="466"></td>
<td width="123"><?php echo($tot);?> h </td>
<td width="58"> </td>
<td width="43"> </td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
</body>
</html>