PHP RetrieveAdHocAbsenceRequests示例

示例#1

文件： employeeDisplayDetails.php 项目： rusli-nasir/absencetrackingsystem

function DisplayPendingAdHocRequestsTableBody($userID)
{
    $filter[AD_HOC_EMP_ID] = $userID;
    $adHocRequests = RetrieveAdHocAbsenceRequests($filter);
    if ($adHocRequests != NULL) {
        foreach ($adHocRequests as $request) {
            $absenceTypeID = $request[AD_HOC_ABSENCE_TYPE_ID];
            $absenceType = RetrieveAbsenceTypeByID($absenceTypeID);
            echo '<tr>';
            echo '<td>' . $request[AD_HOC_START] . '</td>';
            echo '<td>' . $request[AD_HOC_END] . '</td>';
            echo '<td>' . $absenceType[ABS_TYPE_NAME] . '</td>';
            echo '<td> <button class="btn btn-success" type="submit" ' . 'name="amendAdHoc"  value="' . $request[AD_HOC_REQ_ID] . '">Amend' . '</button></td>';
            echo '<td> <button class="btn btn-danger" type="submit" ' . 'name="deleteAdHoc"  value="' . $request[AD_HOC_REQ_ID] . '">Delete' . '</button></td>';
            echo '</tr>';
        }
    }
}

示例#2

文件： adminAdHocAbsenceRequest.php 项目： rusli-nasir/absencetrackingsystem

function PopulateAdHocTable()
{
    $requests = RetrieveAdHocAbsenceRequests();
    if ($requests != NULL) {
        foreach ($requests as $request) {
            $employeeID = $request[AD_HOC_EMP_ID];
            $employee = RetrieveEmployeeByID($employeeID);
            $absenceTypeID = $request[AD_HOC_ABSENCE_TYPE_ID];
            $absenceType = RetrieveAbsenceTypeByID($absenceTypeID);
            echo '<tr>';
            echo '<td>' . $employee[EMP_NAME] . '</td>';
            echo '<td>' . $request[AD_HOC_START] . '</td>';
            echo '<td>' . $request[AD_HOC_END] . '</td>';
            echo '<td>' . $absenceType[ABS_TYPE_NAME] . '</td>';
            echo '<td> <button class="btn btn-success" type="submit" name="amend"' . 'value="' . $request[AD_HOC_REQ_ID] . '">Amend</button></td>';
            echo '<td> <button class="btn btn-danger" type="submit" name="delete"' . 'value="' . $request[AD_HOC_REQ_ID] . '">Delete</button></td>';
            echo '</tr>';
        }
    }
}

示例#3

文件： KeyAlgorithms.php 项目： rusli-nasir/absencetrackingsystem

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

示例#4

文件： EmployeeTable.php 项目： rusli-nasir/absencetrackingsystem

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

示例#5

文件： AbsenceTypeTable.php 项目： rusli-nasir/absencetrackingsystem

function DeleteAbsenceType($ID)
{
    $isValidRequest = TRUE;
    // Ensure there are no AdHocAbsenceRequest records which reference this record.
    $filter[AD_HOC_ABSENCE_TYPE_ID] = $ID;
    $adHocAbsenceRequests = RetrieveAdHocAbsenceRequests($filter);
    if ($adHocAbsenceRequests != NULL) {
        error_log("Attempt to DeleteAbsenceType failed. " . "One or more adHocAbsenceRequest records exist with an " . "absence type ID of " . $ID);
        $isValidRequest = FALSE;
    }
    // Ensure there are no ApprovedAbsenceBooking records which reference this record.
    unset($filter);
    $filter[APPR_ABS_ABS_TYPE_ID] = $ID;
    $approvedBookings = RetrieveApprovedAbsenceBookings($filter);
    if ($approvedBookings != NULL) {
        error_log("Attempt to DeleteAbsenceType failed. " . "One or more approvedAbsenceBooking records exist with an " . "absence type ID of " . $ID);
        $isValidRequest = FALSE;
    }
    $result = 0;
    if ($isValidRequest) {
        $sql = "DELETE FROM absenceTypeTable WHERE absenceTypeID=" . $ID . ";";
        $result = performSQLDelete($sql);
        GenerateStatus(true, "Record has been deleted.");
    }
    return $result;
}

示例#6

文件： administerVacation.php 项目： rusli-nasir/absencetrackingsystem

function DisplayAdHocRequestTableBody()
{
    $requests = RetrieveAdHocAbsenceRequests();
    if ($requests != NULL) {
        foreach ($requests as $request) {
            $employee = RetrieveEmployeeByID($request[AD_HOC_EMP_ID]);
            echo "<tr>";
            echo "<td>" . $employee[EMP_NAME] . "</td>";
            echo "<td>" . $request[AD_HOC_START] . "</td>";
            echo "<td>" . $request[AD_HOC_END] . "</td>";
            echo '<td> <button class="btn btn-success" type="submit" ' . 'name="approveadhoc"  value="' . $request[AD_HOC_REQ_ID] . '">Approve</button></td>';
            echo '<td> <button class="btn btn-danger" type="submit" ' . 'name="rejectadhoc"  value="' . $request[AD_HOC_REQ_ID] . '">Reject</button></td>';
            echo "</tr>";
        }
    }
}