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>';
