function writeCell($conn, $date, $period)
{
// checks if available
$name = checkAvailable($conn, $date, $period);
// if something is returned, then it is booked
if ($name) {
echo "<td class='booked'><b>" . $name . "</b></td>";
} else {
// check if the date is in the past
if (checkIfInThePast($date)) {
//if in the past, write a cell
echo "<td class='past'></td>";
} else {
// checks if user is read only or not
if (!readOnly($conn)) {
if (canBookSLT($conn)) {
// else write a form containing a button to POST
echo "<form method='POST' action='slt_clip.php'>";
echo "<td class='available'><button type='submit' id='availablebtn' name='book'";
echo "onclick=\"return confirm('" . writeDialog("CLIP", $date, $period) . "');\"";
echo "value='" . $date . "," . $period . "'>Book</button></td>";
echo "</form>";
} else {
// if can't book vehicles, does not write book button
echo "<td class='available'></td>";
}
// else
} else {
// if read-only, does not write book button
echo "<td class='available'></td>";
}
// else
}
// else
}
// else
}
function writeCell($conn, $date, $period, $table)
{
// checks if available
$minibuscodes = ["jbx", "jha", "lle", "yhj"];
$name = checkAvailable($conn, $date, $period, $table);
// if something is returned, then it is booked
if ($name) {
// sql to get the booking description of the booking
$sqlGetDescription = "SELECT BookingDesc FROM {$table}\n WHERE BookingDate={$date} AND BookingPeriod={$period}";
$resultGetDescription = mysqli_query($conn, $sqlGetDescription);
if (!$resultGetDescription) {
$bookingdesc = "Unable to get booking description";
} else {
$row = mysqli_fetch_assoc($resultGetDescription);
$bookingdesc = $row["BookingDesc"];
}
// on hover replaces the text with the description using JQuery
echo "<td class='booked'><span class='bookedtext'>" . $bookingdesc . "</a></span>\n <input type='hidden' id='description' value=\"{$bookingdesc}\"' /></td>";
} else {
// check if the date is in the past
if (checkIfInThePast($date)) {
//if in the past, write a cell
echo "<td class='past'></td>";
} else {
// checks if user is read only or not
if (!readOnly($conn)) {
if (canBookVehicles($conn)) {
// else write a form containing a button to POST
echo "<form method='POST' action='all_vehicles.php' id={$date},{$period},{$table}>";
echo "<td class='available'>";
echo "<input type='hidden' id='hiddenbooking,{$date},{$period},{$table}' name='hiddenbookingdesc' value='' runat='server'>";
echo "<input type='hidden' id='{$date},{$period}' name='table' value='{$table}' runat='server'>";
echo "</form>";
} else {
echo "<td class='available'></td>";
}
} else {
// if read-only, does not write book button
echo "<td class='available'></td>";
}
// else
}
// else
}
// else
}
function writeCell($conn, $date, $period)
{
// checks if available
$name = checkAvailable($conn, $date, $period);
// if something is returned, then it is booked
if ($name) {
// sql to get the booking description of the booking
$sqlGetDescription = "SELECT BookingDesc FROM minibusyhj\n WHERE BookingDate={$date} AND BookingPeriod={$period}";
$resultGetDescription = mysqli_query($conn, $sqlGetDescription);
if (!$resultGetDescription) {
$bookingdesc = "Unable to get booking description";
} else {
$row = mysqli_fetch_assoc($resultGetDescription);
$bookingdesc = $row["BookingDesc"];
}
// on hover replaces the text with the description using JQuery
echo "<b><td class='booked'><span class='bookedtext' style='font-weight:bold'>" . $name . "</a></span>\n <input type='hidden' id='description' value=\"{$bookingdesc}\"' /></td></b>";
} else {
// check if the date is in the past
if (checkIfInThePast($date)) {
//if in the past, write a cell
echo "<td class='past'></td>";
} else {
// checks if user is read only or not
if (!readOnly($conn)) {
if (canBookVehicles($conn)) {
// else write a form containing a button to POST
echo "<form method='POST' action='minibusyhj.php' id={$date},{$period}>";
echo "<td class='available'>";
echo "<input type='hidden' id='hiddenbooking,{$date},{$period}' name='hiddenbookingdesc' value='' runat='server'>";
echo "<button type='submit' id='availablebtn' name='book' ";
echo "onclick=\"getBookingDescription({$date},{$period}); return confirm('" . writeDialog("Minibus YHJ", $date, $period) . "');\"";
echo "value='" . $date . "," . $period . "'>Book</button></td>";
echo "</form>";
} else {
echo "<td class='available'></td>";
}
} else {
// if read-only, does not write book button
echo "<td class='available'></td>";
}
// else
}
// else
}
// else
}
function writeBookingsForTable($includepast, $conn, $id, $table, $tablestring)
{
$sqlGetBookings = "SELECT BookingID,BookingDate,BookingPeriod,BookingDesc FROM {$table}\n WHERE BookedByID={$id} ORDER BY bookingdate DESC, bookingperiod ASC";
$resultGetBookings = mysqli_query($conn, $sqlGetBookings);
while ($row = mysqli_fetch_assoc($resultGetBookings)) {
// If includepast=true, i.e. write ALL bookings, past and current
if ($includepast) {
echo "<tr>";
echo "<td>" . $row["BookingDesc"] . "</td>";
echo "<td>" . $row["BookingDate"] . "</td>";
echo "<td>" . stylePeriod($row["BookingPeriod"], getResourceType($table)) . "</td>";
echo "<td>{$tablestring}</td>";
?>
<td>
<form method="POST" action="managebookings.php">
<!--Has a confirm box to make sure user can cancel action-->
<button type="submit" id="deletebooking" name="deletebooking" onclick="return confirm('Are you sure you want to delete this record?');" value=<?php
echo "'" . $row["BookingID"] . "," . $table . "'";
?>
>Delete</button>
</form>
</td>
<?php
echo "</tr>";
} else {
// If booking date is not in the past, print row
if (!checkIfInThePast($row["BookingDate"])) {
echo "<tr>";
echo "<td>" . $row["BookingDesc"] . "</td>";
echo "<td>" . styleDate($row["BookingDate"]) . "</td>";
echo "<td>" . stylePeriod($row["BookingPeriod"], getResourceType($table)) . "</td>";
echo "<td>{$tablestring}</td>";
?>
<td>
<form method="POST" action="managebookings.php">
<!--Has a confirm box to make sure user can cancel action-->
<button type="submit" id="deletebooking" name="deletebooking" onclick="return confirm('Are you sure you want to delete this record?');" value=<?php
echo "'" . $row["BookingID"] . "," . $table . "'";
?>
>Delete</button>
</form>
</td>
<?php
echo "</tr>";
}
// if
}
// else
}
// while
}