</tbody> </table> <!-- get the staff name from approval to dispache --> <table width="100%"> <tr> <td width="25%"></td> <td width="25%"></td> <td width="50%"colspan="2"></td> </tr> <tbody> </tr> <?php $sql_staff = "SELECT * FROM `applicant_status`\r\n WHERE `application_no` = '" . $label . "'\r\n ORDER BY status_id ASC Limit 4"; $process = ApplicantStatus::find_by_sql($sql_staff); foreach ($process as $app_status) { if (isset($app_status->status_id) && !empty($app_status->status_id)) { $staff = AdminUsers::find_by_id($app_status->admin_id); $msg = ' <td style=""><i class="icon-user"> </i> by ' . $staff->admin_name . '</td>'; echo output_message($msg); } } ?> </tr> </tbody> </table> <?php } ?>
<?php require_once "inc/initialize.php"; # Get current status on an anplication if ($label) { $status_sql = "SELECT * FROM `applicant_status` WHERE application_no = '" . $label . "' ORDER BY status_id DESC Limit 1"; $application_status = ApplicantStatus::find_by_sql($status_sql); $application_status_final = array_shift($application_status); switch ($application_status_final->status_id) { case 1: $status_label = '<div class="progress progress-striped active"> <div class="bar" style="width: 25%; "></div> </div>'; $passentage = 25; break; case 2: $status_label = '<div class="progress progress-striped active"> <div class="bar" style="width: 50%; "></div> </div>'; $passentage = 50; break; case 3: $status_label = '<div class="progress progress-striped active"> <div class="bar" style="width: 75%; "></div> </div>'; $passentage = 75; break; case 4: $status_label = '<div class="progress progress-striped active"> <div class="bar" style="width: 100%;"></div> </div>';
# Instance of Carbon Class with the current time $date_now = new Carbon('now'); $label = customDecrypt($_GET['app']); if ($label) { // $database = new MySQLDatabase(); // $sql_user_details="SELECT * from app_histories aph Join adm_access_code adm, applicant_status aps WHERE aph.application_no = '".$label."' AND adm.application_no=aph.application_no AND aps.application_no= aph.application_no"; // $user_history=$database->query($sql_user_details); // $myhistory = $database->fetch_array($user_history); $sql_app = "SELECT * FROM `app_histories` WHERE `application_no` = '" . $label . "'"; $application = AppHistory::find_by_sql($sql_app); $myapp = array_shift($application); $sql_amount = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no` = '" . $label . "'"; $transaction = AdmAccess::find_by_sql($sql_amount); $amount = array_shift($transaction); $sql = "SELECT * FROM `applicant_status` WHERE `application_no` = '" . $label . "'"; $process = ApplicantStatus::find_by_sql($sql); } ?> <!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>University of Jos, Nigeria - Transcript System</title> <?php require_once LIB_PATH . DS . 'javascript.php'; require_once LIB_PATH . DS . 'css.php'; ?> <style type="text/css"> body { padding-top: 60px; padding-bottom: 40px;