| Server IP : 79.136.114.73 / Your IP : 216.73.216.48 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['action'] == "close"){
echo "<script> window.opener.location.reload();window.close();</script>";
}
if($_GET['action'] == "found"){
echo "<script> alert('Sorry, there is another project booked for this desk!');</script>";
}
$deskname = $_GET['DeskName'];
$sql = "SELECT * FROM Desks where Name = '$deskname'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$DeskId = $row['DeskId'];
}
$Startdate = $_GET['Startdate'];
$sql = "SELECT * FROM DeskSchedule where DeskId = '$DeskId' and DeskDate = '$Startdate'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$ProjectId = $row['ProjectId'];
}
$sql = "SELECT * FROM Project where ProjectId = '$ProjectId'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$ProjectId = $row['ProjectId'];
$CompanyId = $row['CompanyId'];
$Name = $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=windows-1252" />
<title>Untitled Document</title>
<style type="text/css">
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
#calendar_icon {
vertical-align: middle;
cursor: pointer;
}
.text {
font-family: Verdana, Geneva, sans-serif;
}
.text {
font-size: 12px;
}
</style>
<script type="text/javascript" language="javascript" src="../jquery-1.12.4.js"></script>
<link rel="stylesheet" type="text/css" href="../dhtmlxCalendar/codebase/dhtmlxcalendar.css"/>
<script src="../dhtmlxCalendar/codebase/dhtmlxcalendar.js"></script>
<script>
function setId(){
document.getElementById("projectid").value = document.getElementById("customerlist").options[document.getElementById("customerlist").selectedIndex].value;
}
var myCalendar1;
var myCalendar2;
function doOnLoad() {
myCalendar1 = new dhtmlXCalendarObject({input: "startdate", button: "calendar_icon"});
myCalendar2 = new dhtmlXCalendarObject({input: "enddate", button: "calendar_icon2"});
}
function calc(){
startdate =document.getElementById("startdate").value;
enddate = document.getElementById("enddate").value;
// First we split the values to arrays date1[0] is the year, [1] the month and [2] the day
date1 = startdate.split('-');
date2 = enddate.split('-');
// Now we convert the array to a Date object, which has several helpful methods
date1 = new Date(date1[0], date1[1], date1[2]);
date2 = new Date(date2[0], date2[1], date2[2]);
// We use the getTime() method and get the unixtime (in milliseconds, but we want seconds, therefore we divide it through 1000)
date1_unixtime = parseInt(date1.getTime() / 1000);
date2_unixtime = parseInt(date2.getTime() / 1000);
// This is the calculated difference in seconds
var timeDifference = date2_unixtime - date1_unixtime;
// in Hours
var timeDifferenceInHours = timeDifference / 60 / 60;
// and finaly, in days :)
var timeDifferenceInDays = timeDifferenceInHours / 24;
timeDifferenceInDays = timeDifferenceInDays - parseInt(timeDifferenceInDays/7);
document.getElementById("hrs").value = timeDifferenceInDays*5*2;
}
function validateForm()
{
var x1=document.forms["form1"]["projectid"].value;
var x2=document.forms["form1"]["enddate"].value;
var x3=document.forms["form1"]["startdate"].value;
if(x2 < x3){
alert("End date must be after start date!");
return false;
}
if(x1 == "" || x2 == ""){
alert("You have to enter end date and project id!");
return false;
}
return true;
}
</script>
</head>
<body onload="doOnLoad();">
<form id="form1" name="form1" method="get" action="addbooking.php" onsubmit="return validateForm()">
<table width="574" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" valign="top" class="style6"> </td>
<td width="276" valign="top"> </td>
<td width="18" rowspan="6"> </td>
<td width="87" rowspan="6"> </td>
</tr>
<tr>
<td colspan="2" valign="top" class="style6">Project Type:</td>
<td width="276" valign="top"><span class="text">
<select name="type" id="type">
<option value="0">Select input/ouput</option>
<option value="1">PC/IMAGE -> Revit</option>
<option value="2">PC/IMAGE -> ADT</option>
<option value="3">PC -> AutoCAD 2D</option>
<option value="4">IMAGE->Revit flats</option>
</select>
</span></td>
</tr>
<tr>
<td colspan="2" valign="top" class="style6">Start date:</td>
<td width="276" valign="top"><span class="text">
<img src="../calendar.gif" alt="" id="calendar_icon" border="0" />
<input name="startdate" type="text" id="startdate" size="12" />
</span></td>
</tr>
<tr>
<td colspan="2" valign="top" class="style6">End date:</td>
<td width="276" valign="top"><span class="text">
<img src="../calendar.gif" alt="" id="calendar_icon2" border="0" />
<input name="enddate" type="text" id="enddate" size="12" />
</span></td>
</tr>
<tr>
<td colspan="2" valign="top" class="style6"><span class="text">Hours needed: </span></td>
<td width="276" valign="top"><span class="text">
<input name="hrs" type="text" id="hrs" size="4" />
hrs
<input type="button" name="button" id="button" value="Calculate" onclick="calc();" />
</span></td>
</tr>
<tr>
<td colspan="2" valign="top"> </td>
<td width="276" valign="top"> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td width="90"> </td>
<td width="103"><span class="text">
<label for="shift"></label>
</span></td>
<td> </td>
<td> </td>
<td><input type="submit" name="button2" id="button2" value="Find!" /></td>
</tr>
</table>
</form>
</body>
</html>
<script>
var showOnlyOptionsSimilarToText = function (selectionEl, str, isCaseSensitive) {
if (isCaseSensitive)
str = str.toLowerCase();
// cache the jQuery object of the <select> element
var $el = $(selectionEl);
if (!$el.data("options")) {
// cache all the options inside the <select> element for easy recover
$el.data("options", $el.find("option").clone());
}
var newOptions = $el.data("options").filter(function () {
var text = $(this).text();
if (isCaseSensitive)
text = text.toLowerCase();
return text.match(str);
});
$el.empty().append(newOptions);
};
$("#SearchBox").on("keyup", function () {
var userInput = $("#SearchBox").val();
showOnlyOptionsSimilarToText($("#customerlist"), userInput, true);
});
</script>