function ProcessAdHocRequests(&$statusMessage)
{
$requests = RetrieveAdHocAbsenceRequests();
$return = true;
foreach ($requests as $request) {
$id = $request[AD_HOC_REQ_ID];
$employeeID = $request[AD_HOC_EMP_ID];
$startDate = $request[AD_HOC_START];
$endDate = $request[AD_HOC_END];
$absenceTypeID = $request[AD_HOC_ABSENCE_TYPE_ID];
$employee = RetrieveEmployeeByID($employeeID);
$statusMessage .= "<b>[Processing AdHoc request for " . $employee[EMP_NAME] . "]</b><br/>";
$result = ProcessAbsenceRequest($employeeID, $startDate, $endDate, $absenceTypeID, $statusMessage);
if ($result == false) {
$return = false;
}
DeleteAdHocAbsenceRequest($id);
}
return $return;
}
function DeleteEmployee($ID)
{
$result = 0;
$statusMessage = "";
$employee = RetrieveEmployeeByID($ID);
if ($employee != NULL) {
if ($employee[EMP_MAIN_VACATION_REQ_ID] != NULL) {
DeleteMainVacatioNRequest($employee[EMP_MAIN_VACATION_REQ_ID]);
}
$filter[AD_HOC_EMP_ID] = $ID;
$adHocAbsenceRequests = RetrieveAdHocAbsenceRequests($filter);
foreach ((array) $adHocAbsenceRequests as $value) {
DeleteAdHocAbsenceRequest($value[AD_HOC_REQ_ID]);
}
unset($filter);
$filter[APPR_ABS_EMPLOYEE_ID] = $ID;
$approvedAbsenceBookings = RetrieveApprovedAbsenceBookings($filter);
if ($approvedAbsenceBookings != NULL) {
foreach ($approvedAbsenceBookings as $value) {
DeleteApprovedAbsenceBooking($value[APPR_ABS_BOOKING_ID]);
}
}
$sql = "DELETE FROM employeeTable WHERE employeeID=" . $ID . ";";
$result = performSQL($sql);
$statusMessage .= "Record deleted.</br>";
GenerateStatus(true, $statusMessage);
}
return $result;
}
if (isset($_POST["employeeID"])) {
$employeeID = $_POST["employeeID"];
}
$request = CreateAdHocAbsenceRequest($employeeID, $_POST["startDate"], $_POST["endDate"], $_POST["absenceType"]);
}
// If user has clicked the amend button, redirect them to the edit adhoc absence
// page, using a GET parameter with the ID of the record to edit.
if (isset($_POST["amend"])) {
ClearStatus();
$url = "Location:editAdHocAbsenceRequest.php?ID=" . $_POST["amend"] . "&back=adminAdHocAbsenceRequest.php";
header($url);
}
// If user has clicked the delete button, delete the record from the table.
if (isset($_POST["delete"])) {
ClearStatus();
DeleteAdHocAbsenceRequest($_POST["delete"]);
}
//-----------------------------------------------------------------------------
// This function will generate the HTML necessary for the Employee select
// dropdown.
//-----------------------------------------------------------------------------
function CreateEmployeeSelect()
{
echo '<select class="form-control" name="employeeID" id="employeeID" >';
echo '<option value="" disabled selected>Select Employee</option>';
$employees = RetrieveEmployees();
if ($employees != NULL) {
foreach ($employees as $employee) {
echo '<option value="' . $employee[EMP_ID] . '">' . $employee[EMP_NAME] . '</option>';
}
}
function ApproveAdHocRequest($requestID)
{
$statusMessage = "";
$succeeded = true;
$request = RetrieveAdHocAbsenceRequestByID($requestID);
if ($request != NULL) {
$absenceType = $request[AD_HOC_ABSENCE_TYPE_ID];
$start = $request[AD_HOC_START];
$end = $request[AD_HOC_END];
$succeeded = ProcessAbsenceRequest($request[AD_HOC_EMP_ID], $start, $end, $absenceType, $statusMessage);
if ($succeeded) {
DeleteAdHocAbsenceRequest($requestID);
}
} else {
$statusMessage .= "Error: Unable to process your request." . "The AdHoc Request ID of {$requestID} " . "could not be found in the database. Please " . "contact your system administrator.</br>";
$succeeded = false;
}
GenerateStatus($succeeded, $statusMessage);
}
