// Thursday
echo "<th>";
if (checkIfToday($thudate)) {
echo "<u>";
}
// if
echo "Thursday";
echo "<br>" . styleDate($thudate) . "</u></th>";
// Friday
echo "<th>";
if (checkIfToday($fridate)) {
echo "<u>";
}
// if
echo "Friday";
echo "<br>" . styleDate($fridate) . "</u></th>";
?>
</tr>
<tr>
<!--PERIOD 1-6-->
<?php
for ($period = 1; $period <= 8; $period++) {
echo "<tr>";
echo "<th>" . writeTimeSlot($period) . "</th>";
writeCell($conn, $mondate, $period);
writeCell($conn, $tuedate, $period);
writeCell($conn, $weddate, $period);
writeCell($conn, $thudate, $period);
writeCell($conn, $fridate, $period);
echo "</tr>";
}
function writeTable($conn, $showall)
{
$id = $_SESSION["id"];
$sqlGetBookings = "SELECT * FROM RecurringBookings\n WHERE BookedByID={$id}";
$resultGetBookings = mysqli_query($conn, $sqlGetBookings);
$today = date('Ymd');
while ($row = mysqli_fetch_assoc($resultGetBookings)) {
// if we want to show all bookings
// or today's date is less than the end date of the booking
if ($showall == true || strtotime($today) <= strtotime($row["EndDate"])) {
echo "<tr>";
echo "<td>" . styleResource($row["Resource"]) . "</td>";
echo "<td>" . styleDay($row["RecurDay"]) . "</td>";
echo "<td>" . stylePeriod($row["RecurPeriod"], getResourceType($row["Resource"])) . "</td>";
echo "<td>";
if ($row["isWeekly"] == 1) {
echo "Week";
} else {
echo "Fortnight";
}
echo "</td>";
echo "<td>" . styleDate($row["StartDate"]) . "</td>";
echo "<td>" . styleDate($row["EndDate"]) . "</td>";
?>
<td>
<form method="POST" action="managerecurring.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 recurring record? \nThat includes ALL future bookings related to this recurrence!');"
value=<?php
echo "'" . $row["BookingID"] . "," . $row["Resource"] . "," . $row["BookedByID"] . "'";
?>
>Delete</button>
</form>
</td>
<?php
}
// if
}
// while
}
function writeTable($conn, $table)
{
?>
<form method="POST" action="/createrecurring_test.php">
<button type='submit' id="prevweek" name="prevweek" <?php
echo "value='" . $_SESSION['mondate'] . "'";
?>
>Previous Week</button>
<b>Week of <?php
echo styleWeekOf();
?>
</b>
<button type='submit' id="nextweek" name="nextweek"<?php
echo "value='" . $_SESSION['mondate'] . "'";
?>
>Next Week</button><br>
<button type='submit' id="currentweek" name="currentweek"<?php
echo "value='" . $_SESSION['mondate'] . "'";
?>
>Current Week</button><br>
</form>
<table class="calendar">
<tr>
<!-- Write table headers -->
<th></th>
<?php
// Establish the date of each day, store in individual variables
$mondate = $_SESSION["mondate"];
// calculate whole week
$tuedate = findNextDate($mondate);
$weddate = findNextDate($tuedate);
$thudate = findNextDate($weddate);
$fridate = findNextDate($thudate);
// Monday
echo "<th>";
if (checkIfToday($mondate)) {
echo "<u>";
}
// if
echo "Monday";
echo "<br>" . styleDate($mondate) . "</u></th>";
// Tuesday
echo "<th>";
if (checkIfToday($tuedate)) {
echo "<u>";
}
// if
echo "Tuesday";
echo "<br>" . styleDate($tuedate) . "</u></th>";
// Wednesday
echo "<th>";
if (checkIfToday($weddate)) {
echo "<u>";
}
// if
echo "Wednesday";
echo "<br>" . styleDate($weddate) . "</u></th>";
// Thursday
echo "<th>";
if (checkIfToday($thudate)) {
echo "<u>";
}
// if
echo "Thursday";
echo "<br>" . styleDate($thudate) . "</u></th>";
// Friday
echo "<th>";
if (checkIfToday($fridate)) {
echo "<u>";
}
// if
echo "Friday";
echo "<br>" . styleDate($fridate) . "</u></th>";
?>
</tr>
<tr>
<!--PERIOD 1-6-->
<?php
for ($period = 1; $period <= 8; $period++) {
echo "<tr>";
echo "<th>Period {$period}</th>";
writeCell($conn, $table, $mondate, $period);
writeCell($conn, $table, $tuedate, $period);
writeCell($conn, $table, $weddate, $period);
writeCell($conn, $table, $thudate, $period);
writeCell($conn, $table, $fridate, $period);
echo "</tr>";
}
// for
?>
</table>
<?php
}
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
}
