| ';echo $clock;echo ' | ';
mysql_select_db("labReservation",$work_link) or die ("Couldn't select!");
$old_time=$time;
while($number<$colNumber){
$query=$dynamic_query.")"." and ((bTime=$time) or (bTime<$time and eTime>$time))";
$result=mysql_query($query,$work_link) or die ("FOOOO");
$num_rows=mysql_num_rows($result); //Number of rows in the result
/*Bgcolor if not empty*/
if($num_rows)
echo '';
else
echo " ";
$col_number=0;
while($row=mysql_fetch_array($result)){
$work_query="select workDescription from workTopics where workNumber='$row[0]'";
$work_result=mysql_db_query("labReservation",$work_query);
$work_row=mysql_fetch_array($work_result);
/*If admin display a link to more work information*/
$col_number=$col_number+1;
if($admin_key==1){
/*Making work_info URL*/
$url="http://$host";
$url=$url.$request_uri;
$url=ereg_replace("display_times.php3","work_info.php3",$url);
$url=$url."?key=".$row[1];
echo '';
echo "$work_row[0]
";
}
/*If not admin and the work is not reserved, display a link to reservation page*/
if($admin_key!=1 && $row[3]==0){
/*Making reservation URL*/
$url="http://$host";
$url=$url.$request_uri;
$url=ereg_replace("display_times.php3","reserve.php3",$url);
$url=$url."?key=".$row[1];
echo '';
echo "$work_row[0]
";
}
/*If not admin and reserved, no link is displayed*/
if($admin_key!=1 && $row[3]==1){
echo "$work_row[0]
";
}
if($row[3]==1){
echo "Res.";
if($admin_key!=1)
echo " Ass. $row[2]";
}
else{
echo "Free";
if($admin_key!=1)
echo " Ass. $row[2]";
}
if($admin_key!=1){
if ($col_number!=$num_rows)
echo "
";
//else
//echo "
";
}
/*If admin, display a link to delete pages*/
if($admin_key==1){
echo " ";
/*Making the delete link*/
$url="http://$host";
$url=$url.$request_uri;
$url=ereg_replace("display_times.php3","delete.php3",$url);
$url=$url."?key=".$row[1];
echo '';
echo "Del ";
if ($col_number!=$num_rows)
echo "
";
}
}
$current_time=time();
if($admin_key==1 && $clock<19 && $time>$current_time){
/*Making the direct-insert link.*/
$url="http://$host";
$url=$url.$request_uri;
$url=ereg_replace("display/display_times.php3","insert/direct_insert.php3",$url);
$url=$url."?time=".$time;
echo '';
echo "Add
";
}
echo " | ";
$time=$time+86400; //One day onwards
/* Clock shift check */
$old_tm=getdate($old_time);
$old_hour=$old_tm['hours'];
$new_tm=getdate($time);
$new_hour=$new_tm['hours'];
if($old_hour!=$new_hour){
$time=$time-3600;
//echo "Kellonsiirto";
}
$old_time=$time;
$number=$number+1;
}
echo "";
}
/*Makes the first row to the schedule*/
function makeTimeRow($btime, $etime){
$time=$btime;
$colNumber=0;
echo '| | ';
while($time<=$etime + 3600){
$today=getdate($time);
$day=$today['weekday'];
$num=$today['mday'];
$month=$today['month'];
echo "$day
$num $month | ";
$time=$time+86400;
$colNumber++;
}
echo " ";
return $colNumber;
}
/*Sends formatted email*/
function sendEmail($email,$number,$description,$btime,$etime,$member1,$member2,$member3,$resTime,$IP,$browser,$Domain,$conf_url,$cancel_url){
/*Contains emailing information*/
require "/home/www/data/labReservation.conf";
$ok=mail($email,"S-38 laboratory work reservation", "You have reserved the work:\n\nWork$number $description\nTime: $btime - $etime\nGroup: $member1, $member2, $member3\n\nTo confirm the reservation, click the link at the end of this message \nor copy it and paste into the URL field of your browser.\nThe confirmation must be made within the next 24 hours after the reservation. \nOtherwise the reservation is cancelled. \nOnly one member of your group has to do the confirmation.\n\nIf you feel this message makes no sense, please reply it.\n\nSome Information of the reservation to catch crackers:\n\nTime: $resTime\nIP: $IP\nDomain: $Domain\nBrowser: $browser\n\nConfirmation via\n $conf_url\n\nAfter confirmation you can cancel the reservation via\n $cancel_url\n\n $mailnote","From: $email_sender",$transcript_receiver);
return $ok;
}
/*Makes clear time from Unix timestamp*/
function getClearTime($timestamp){
$time=getdate($timestamp);
$year=$time['year'];
$month=$time['mon'];
$mday=$time['mday'];
$hour=$time['hours'];
$minute=$time['minutes'];
if($month<10)
$month="0".$month;
if($mday<10)
$mday="0".$mday;
if($hour<10)
$hour="0".$hour;
if($minute<10)
$minute="0".$minute;
$point=".";
$time=$mday.$point;
$time=$time.$month;
$time=$time.".";
$time=$time.$year;
$time=$time." ";
$time=$time.$hour;
$time=$time.":";
$time=$time.$minute;
return $time;
}
?>
|