| Server IP : 79.136.114.73 / Your IP : 3.17.73.197 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/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 * FROM DeskSchedule, Desks where Desks.DeskID =DeskSchedule.DeskId and DeskDate = '$TodaysDate'";
$result = mysql_query($sql);
$Desk = array("","","","","","","","","","","","","","","","","","","","","","","","","","","","","","");
while ($row = mysql_fetch_assoc($result)){
$Desk[$row['DeskId']] = $row['Name'];
}
?><!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=UTF-8" />
<title>Untitled Document</title>
<style type="text/css">
#astacus01 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 130px;
top: 578px;
background-color: #00FF00;
opacity:0.5;
}
#astacus02 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 130px;
top: 488px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus03 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 183px;
top: 577px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus04 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 490px;
top: 579px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus05 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 490px;
top: 491px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus06 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 437px;
top: 285px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus07 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 438px;
top: 196px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus08 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 437px;
top: 109px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus09 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 491px;
top: 284px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus10 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 489px;
top: 196px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus11 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 490px;
top: 109px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus12 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 746px;
top: 579px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus13 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 745px;
top: 491px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus14 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 747px;
top: 282px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus15 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 748px;
top: 195px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus16 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 747px;
top: 109px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus17 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 800px;
top: 283px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus18 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 800px;
top: 194px;
background-color: #00FF00;
opacity: 0.5;
}
#astacus19 {
position: absolute;
width: 50px;
height: 86px;
z-index: 1;
left: 802px;
top: 109px;
background-color: #00FF00;
opacity: 0.5;
}
.rubrik {
font-family: Verdana, Geneva, sans-serif;
font-size: 24px;
}
</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){
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] != ""){
// echo('alert("'.$Desk[$i].'");');
echo('document.getElementById("'.$Desk[$i].'").style.backgroundColor = "#FF0000";');
}
}
?>
}
</script>
</head>
<body onload="init();">
<table width="1200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5"><img src="background.png" alt="" width="1200" height="731" />
<a href="" onclick="show('astacus01');"><div id="astacus01"></div></a>
<a href="" onclick="show('astacus02');"><div id="astacus02"></div></a>
<a href="" onclick="show('astacus03');"><div id="astacus03"></div></a>
<a href="" onclick="show('astacus04');"><div id="astacus04"></div></a>
<a href="" onclick="show('astacus05');"><div id="astacus05"></div></a>
<a href="" onclick="show('astacus06');"><div id="astacus06"></div></a>
<a href="" onclick="show('astacus07');"><div id="astacus07"></div></a>
<a href="" onclick="show('astacus08');"><div id="astacus08"></div></a>
<a href="" onclick="show('astacus09');"><div id="astacus09"></div></a>
<a href="" onclick="show('astacus10');"><div id="astacus10"></div></a>
<a href="" onclick="show('astacus11');"><div id="astacus11"></div></a>
<a href="" onclick="show('astacus12');"><div id="astacus12"></div></a>
<a href="" onclick="show('astacus13');"><div id="astacus13"></div></a>
<a href="" onclick="show('astacus14');"><div id="astacus14"></div></a>
<a href="" onclick="show('astacus15');"><div id="astacus15"></div></a>
<a href="" onclick="show('astacus16');"><div id="astacus16"></div></a>
<a href="" onclick="show('astacus17');"><div id="astacus17"></div></a>
<a href="" onclick="show('astacus18');"><div id="astacus18"></div></a>
<a href="" onclick="show('astacus19');"><div id="astacus19"></div></a>
</td>
</tr>
<tr>
<td width="109"> </td>
<td width="282"> </td>
<td width="319">
<span 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></span></td>
<td width="218"> </td>
<td width="273"> </td>
</tr>
</table>
</body>
</html>