function DeleteDate($ID) { $result = 0; $date = RetrieveDateByID($ID); if ($date != NULL) { $filter[APPR_ABS_BOOK_DATE_DATE_ID] = $date[DATE_TABLE_DATE_ID]; $approvedAbsenceBookingDates = RetrieveApprovedAbsenceBookingDates($filter); if ($approvedAbsenceBookingDates != NULL) { foreach ($approvedAbsenceBookingDates as $value) { DeleteApprovedAbsenceBooking($value[APPR_ABS_BOOK_DATE_ABS_BOOK_ID]); } } if ($date[DATE_TABLE_PUBLIC_HOL_ID] != NULL) { DeletePublicHoliday($date[DATE_TABLE_PUBLIC_HOL_ID]); } $sql = "DELETE FROM dateTable WHERE dateID=" . $ID . ";"; $result = performSQL($sql); } return $result; }
header('Location: index.php'); exit; } if (isset($_POST["submit"])) { ClearStatus(); $dateID = RetrieveDateIDByDate($_POST["date"]); $holiday = CreatePublicHoliday($_POST["name"], $dateID); } if (isset($_POST["amend"])) { ClearStatus(); $url = "Location:editpublicholiday.php?ID=" . $_POST["amend"]; header($url); } if (isset($_POST["delete"])) { ClearStatus(); DeletePublicHoliday($_POST["delete"]); } function DisplayPublicHolidayTableBody() { $holidays = RetrievePublicHolidays(); if ($holidays != NULL) { foreach ($holidays as $holiday) { $date = RetrieveDateByID($holiday[PUB_HOL_DATE_ID]); echo "<tr>"; echo "<td>" . $holiday[PUB_HOL_ID] . "</td>"; echo "<td>" . $holiday[PUB_HOL_NAME] . "</td>"; echo "<td>" . $holiday[PUB_HOL_DATE_ID] . "</td>"; echo "<td>" . $date[DATE_TABLE_DATE] . "</td>"; echo '<td> <button class="btn btn-success" type="submit" ' . 'name="amend" value="' . $holiday[PUB_HOL_ID] . '">' . 'Amend</button></td>'; echo '<td> <button class="btn btn-danger" type="submit"' . 'name="delete" value="' . $holiday[PUB_HOL_ID] . '">' . 'Delete</button></td>'; echo '</tr>';