Booking overview
'$firstday' and start < adddate('$firstday', $interval) ".
"order by r1;";
$result_bookings = db_query($query, $connection);
?>
Date ";
while ($row = @ mysql_fetch_array($result_rooms)) {
echo "| ".$row["name"]." | ";
$rooms[$row["name"]]=$row["name"];
}
while ($row = @ mysql_fetch_array($result_bookings)) {
$starttime = strtotime($row["start"]);
$endtime = strtotime($row["end"]);
for ($i = 0; $i < $interval; $i++) {
$mytime = strtotime("$firstday + $i days");
if ($mytime >= $starttime && $mytime < $endtime) {
$user[$row["name"]][$i] = substr($row["first_name"],0,1).". ".$row["user"];
$email[$row["name"]][$i] = $row["e_mail"];
$bid[$row["name"]][$i] = $row["bid"];
}
}
}
for ($i = 0; $i < $interval; $i++) {
echo "";
echo "| ".
date("D d.m.Y",strtotime("$firstday + $i days"))." | ";
foreach ($rooms as $r) {
if ($user[$r][$i] != "")
echo " ".$user[$r][$i]." | ";
else
echo " | ";
}
echo "
";
}
#while ($row = @ mysql_fetch_row($result)) {
# echo "";
# foreach ($row as $data) {
# echo "| test ${data} | ";
# }
# echo "
";
#}
?>
Pending requests
| Arrival |
Departure |
Name |
Comment |
0)
echo "Accept in | ";
if (preg_match("/admin/", $_SESSION["role"]) != 0)
echo "Admin | ";
?>
";
echo " $row[start] | ";
echo " $row[end] | ";
echo " $row[first_name] $row[name] | ";
echo " $row[comment] | ";
if (count($room_own) > 0) {
echo "";
$r1 = min(max(0, $row[r1]),$interval);
$r2 = min(max(0, $row[r2]-1),$interval);
foreach ($room_own as $room_id => $room_name) {
echo <<
$room_name
EOT;
}
echo " | ";
}
if (preg_match("/admin/", $_SESSION["role"]) != 0) {
echo "";
echo "Reject
";
echo "";
echo " | ";
}
echo "";
}
?>
List of bookings
| Arrival |
Departure |
Person |
Room |
0) echo " Move to | "; ?>
Change booking"; ?>
$row[start] |
$row[end] |
$row[first_name] $row[user] |
$row[name] |
EOT;
if (count($room_own) > 0) {
$r1 = min(max(0, $row[r1]),$interval);
$r2 = min(max(0, $row[r2]-1),$interval);
echo "";
foreach ($room_own as $room_id => $room_name) {
echo <<
$room_name
EOT;
}
echo " | ";
if (preg_match("/sadmin/", $_SESSION["role"]) != 0) {
echo "Unbook | ";
}
}
echo "";
}
?>