<?php
include_layout_template('admin_menu.php');
?>
<div class="span9">
<h2>Close Form Application</h2>
<hr>
<h3>Note:</h3>
<ul>
<li>Once you close application, nobody will be able to register for any programme</li>
<li>You can also set a date the application will be closed</li>
</ul>
<?php
$database = new MySQLDatabase();
$sql = $database->query("SELECT * FROM application_status WHERE id=1");
$result = $database->fetch_array($sql);
?>
<form action="" method="POST" class="form-horizontal closeapplication" id="closeapplication" >
<div class="control-group">
<label class="control-label" for="inputClosingDate">Closing Date:</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-calendar"></i></span>
<input type="text" class="input-medium datepicker" value="<?php
echo $result['application_close_date'];
?>
" id="date" name="date" maxlength="10" data-date-format="yyyy-mm-dd" placeholder="YYYY-MM-DD" />
</div>
</div>
</div>
?>
<div class="span9">
<h2>Active Notifications</h2>
<hr>
<?php
$database = new MySQLDatabase();
$active_notifications = "SELECT * FROM `applicant_notifications` as app_not JOIN `personal_details` as per WHERE status = 1 AND recipient_id = " . $session->applicant_id . " AND app_not.sender_id=per.applicant_id";
$result = $database->query($active_notifications);
$pagecounter = 1;
$serialno = 1;
$max = 10;
$number_of_notifications = $database->num_rows($result);
echo '<div class="tabbable">
<div class="tab-content">';
while ($row = $database->fetch_array($result)) {
if ($serialno % $max == 1) {
if ($pagecounter == 1) {
echo '<div class="tab-pane active" id="' . $pagecounter . '">';
} else {
echo '<div class="tab-pane" id="' . $pagecounter . '">';
}
echo '<table class="table table-hover">
<thead>
<tr>
<th>S/N</th>
<th>Sender</th>
<th>Title</th>
<th>Date</th>
<th>Time</th>
<th></th>
<?php
# Instance of Session
$session = new Session();
# Instance of MySQLDatabase
$db = new MySQLDatabase();
// print_r( $type);
// die();
# Count the number of submitted transcript applications for an applicant
$query_count = "SELECT count(*) FROM feedbacks WHERE applicant_id ='" . $session->id . "' ";
$result_count = $db->query($query_count);
$feedbacks_count = $db->fetch_array($result_count);
$count = array_shift($feedbacks_count);
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
// 2. records per page ($per_page)
$per_page = 3;
// 3. total record count ($total_count)
$total_count = $count;
// use pagination instead
$pagination = new Pagination($page, $per_page, $total_count);
// Instead of finding all records, just find the records
// for this page
$sql = "SELECT * FROM feedbacks WHERE applicant_id ='" . $session->id . "' ORDER BY `id` DESC ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$active_feedbacks = Feedback::find_by_sql($sql);
// Need to add ?page=$page to all links we want to
// maintain the current page (or store $page in $session)
$counter = 1;
?>
?>
" />
</div>
</div>
</div>
<div class="control-group">
<label class="control-label">Amount</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-xlarge" name="amount" id="amount" >
<?php
$naira = '₦';
$arrayAmount = $database->query("SELECT * FROM form_amount WHERE status=1");
while ($row = $database->fetch_array($arrayAmount)) {
$amountformat = $row['amount'] * 100 . '.00';
if ($amountformat == $result->amount) {
echo '<option selected="selected" value="' . $row['amount'] . '">' . $naira . $row['amount'] . '</option>';
} else {
echo '<option value="' . $row['amount'] . '">' . $naira . $row['amount'] . '</option>';
}
}
?>
</select>
</div>
</div>
</div>
<div class="control-group">
<label class="control-label">Transaction Date</label>
<?php
require_once '../inc/initialize.php';
$db_academic = new MySQLDatabase();
$sql_exam = "SELECT * FROM exam_id";
$result_exam = $db_academic->query($sql_exam);
while ($record = $db_academic->fetch_array($result_exam)) {
echo '<option value="' . $record['exam_type_id'] . '">' . $record['exam_name'] . '</option>';
}
<h2>Search Form Log Transactions</h2>
<hr>
<h3>Note:</h3>
<ul>
<li>This is to search payment records in the form log transactions</li>
</ul>
<form action="" method="POST" class="form-horizontal search_acceptance" id="search_acceptance" >
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-large" name="approval_status" id="approval_status" >
<option selected="selected" value="">--Select Code--</option>
<?php
$arrayDescription = $database->query("SELECT * FROM interswitch_error_code WHERE status=1 ORDER BY `interswitch_error_code`.`response_description` ASC");
while ($rowDesc = $database->fetch_array($arrayDescription)) {
echo '<option value="' . $rowDesc['response_code'] . '">' . $rowDesc['response_description'] . '</option>';
}
?>
</select>
</div>
<?php
$sql_faculty = "SELECT * FROM faculty ORDER BY faculty_name ASC";
$result_set = $database->query($sql_faculty);
?>
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-large" name="faculty_id" id="faculty_id" onChange="get_options(this.value);" >
<option value="">--Select Programme--</option>
function form_id_generator($applicant_id, $programme)
{
//get the length of random number to generate
$random_number_length = 6 - strlen($applicant_id);
//get d last two digits of the session
$database = new MySQLDatabase();
$selectsessionsql = $database->query("SELECT session FROM application_status WHERE id=1");
$result = $database->fetch_array($selectsessionsql);
$year = explode('/', $result['session']);
$year = substr($year[0], 2, 2);
$random_number = rand(pow(10, $random_number_length - 1), pow(10, $random_number_length) - 1);
// The function returns year, programme
return $year . $programme . $random_number . $applicant_id;
}
$rootdirectory = '../documents/transcripts/';
} elseif ($filetype == 'Thesis Proposal') {
$rootdirectory = '../documents/thesis/';
}
$rootdirectory .= $filename;
return $rootdirectory;
}
$applicant_id = customDecrypt($_GET[md5('applicant_id')]);
$user = new User();
$user->applicant_id = $applicant_id;
$progress = $user->find_by_sql("SELECT progress FROM personal_details WHERE applicant_id='" . $user->applicant_id . "'");
$progress = array_shift($progress);
$student_status = $user->get_student_status();
$database = new MySQLDatabase();
$personal_details = $database->query("SELECT * FROM personal_details p, title t, lga l, state s, religion r, nationality n, department d, faculty f, next_of_kin next, marital mar, photographs photo WHERE p.applicant_id='" . $applicant_id . "' AND p.title_id=t.title_id AND p.lga_id=l.lga_id AND l.state_id=s.state_id AND p.religion_id=r.religion_id AND p.country_id=n.country_id AND p.programme_applied_id=d.department_id AND d.faculty_id=f.faculty_id AND p.applicant_id=next.applicant_id AND p.applicant_id=photo.applicant_id AND p.marital_status=mar.marital_status_id");
$personal_details = $database->fetch_array($personal_details);
$admissions = new Admission();
$sql = "select * from admission_status where applicant_id='" . $applicant_id . "'";
$admissions = Admission::find_by_sql($sql);
foreach ($admissions as $admission) {
$date = $admission->date_completed_application;
$time = $admission->time_completed_application;
$academic_session = $admission->academic_session;
$status = $admission->status;
$reason = $admission->reason;
}
if ($status == 0) {
$msg = '<span class="label label-inverse">You have not completed your application form yet</span>';
} elseif ($status == 1) {
$msg = '<span class="label ">Pending</span>';
} elseif ($status == 2) {
<?php
$database = new MySQLDatabase();
?>
<div class="row-fluid">
<div class="span3">
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-xlarge" name="faculty_id" id="faculty_id" onChange="get_options(this.value);" >
<?php
$arraySpecialRoles = array(2 => 12, 3 => array(16, 17));
if (isset($_SESSION['department_id']) && $_SESSION['department_id'] != 0) {
$sql_get_departmentdetails = $database->query("SELECT * FROM department d, faculty f WHERE d.department_id='" . $_SESSION['department_id'] . "' AND d.faculty_id=f.faculty_id");
$result_departmentdetails = $database->fetch_array($sql_get_departmentdetails);
echo '<option value="' . $result_departmentdetails['faculty_id'] . '">' . $result_departmentdetails['faculty_name'] . '</option>';
} elseif (array_key_exists($_SESSION['role'], $arraySpecialRoles) && $_SESSION['department_id'] == 0) {
if (is_array($arraySpecialRoles[$_SESSION['role']])) {
$sql_faculty = $database->query("SELECT * FROM faculty WHERE faculty_id='" . $arraySpecialRoles[$_SESSION['role']][0] . "' OR faculty_id='" . $arraySpecialRoles[$_SESSION['role']][1] . "'");
$output = '';
while ($result_faculty = $database->fetch_array($sql_faculty)) {
$output .= '<option value="' . $result_faculty['faculty_id'] . '">' . $result_faculty['faculty_name'] . '</option>';
}
} else {
$sql_faculty = $database->query("SELECT * FROM faculty WHERE faculty_id='" . $arraySpecialRoles[$_SESSION['role']] . "'");
$result_faculty = $database->fetch_array($sql_faculty);
$output = '<option value="' . $result_faculty['faculty_id'] . '">' . $result_faculty['faculty_name'] . '</option>';
}
echo $output;
} else {
$query_acceptance = "SELECT * FROM acceptance_log acc, personal_details p, department d, faculty f WHERE acc.student_id = p.form_id AND p.programme_applied_id = d.department_id AND f.faculty_id = d.faculty_id" . $whereclause;
//print_r($query_acceptance);
$row_count = 1;
$result = $database->query($query_acceptance);
$number_of_records = $database->num_rows($result);
if ($number_of_records > 0) {
echo '<h4 align="center"><span class="badge badge-info">' . $number_of_records . '</span> applicant(s) found</h4>';
echo '<div class="tabbable">';
//echo '<input type="hidden" value="'.$result.'" name="exportdata"/>';
echo '<div class="tab-content">';
$link_str = "";
$pagecounter = 1;
$serialno = 1;
$max = 10;
$number_of_pages = ceil($number_of_records / $max);
while ($record = $database->fetch_array($result)) {
if ($serialno % $max == 1) {
if ($pagecounter == 1) {
echo '<div class="tab-pane active" id="' . $pagecounter . '">';
} elseif ($pagecounter == 2) {
echo '<div class="tab-pane" id="' . $pagecounter . '">';
} else {
echo '<div class="tab-pane" id="' . $pagecounter . '">';
}
echo '<table class="table table-hover">
<thead>
<tr>';
// if($role == 1 || $role == 6){
// echo'<th></th>';
// }
echo '<th>S/N</th>
$type = 2;
break;
case 3:
$caption = 'All Notifications';
$type = '>=1';
break;
default:
break;
}
// print_r( $type);
// die();
}
# Count the number of submitted transcript applications for an applicant
$query_count = "SELECT count(*) FROM notifications WHERE applicant_id ='" . $session->id . "' AND status = '" . $type . "'";
$result_count = $db->query($query_count);
$notifications_count = $db->fetch_array($result_count);
$count = array_shift($notifications_count);
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
// 2. records per page ($per_page)
$per_page = 3;
// 3. total record count ($total_count)
$total_count = $count;
// use pagination instead
$pagination = new Pagination($page, $per_page, $total_count);
// Instead of finding all records, just find the records
// for this page
$sql = "SELECT * FROM notifications WHERE applicant_id ='" . $session->id . "' AND status = '" . $type . "' ORDER BY `id` DESC ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$active_notifications = Notification::find_by_sql($sql);
$registra = array_shift($registra);
$admissions = new Admission();
$sql = "SELECT * FROM admission_status WHERE applicant_id='" . $session->applicant_id . "'";
$admissions = Admission::find_by_sql($sql);
foreach ($admissions as $admission) {
$time = $admission->time_completed_application;
$academic_session = $admission->academic_session;
$status = $admission->status;
}
if ($status < 5) {
redirect_to('confirmation.php');
}
$student_status = $user->get_student_status();
$database = new MySQLDatabase();
$personal_details = $database->query("SELECT * FROM personal_details p, title t, lga l, state s, religion r, nationality n, department d, faculty f, next_of_kin next, marital mar, photographs photo WHERE p.applicant_id='" . $session->applicant_id . "' AND p.title_id=t.title_id AND p.lga_id=l.lga_id AND l.state_id=s.state_id AND p.religion_id=r.religion_id AND p.country_id=n.country_id AND p.programme_applied_id=d.department_id AND d.faculty_id=f.faculty_id AND p.applicant_id=next.applicant_id AND p.applicant_id=photo.applicant_id AND p.marital_status=mar.marital_status_id");
$personal_details = $database->fetch_array($personal_details);
$admission = $database->query("SELECT * FROM `admission_letter_date` WHERE visible = 1");
$admission = $database->fetch_array($admission);
// $programme = $database->query("SELECT * FROM `department` WHERE `department_id` = ");
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>University of Jos, Nigeria - <?php
echo $personal_details['faculty_name'];
?>
Complete Application Form</title>
<?php
require_once LIB_PATH . DS . 'javascript.php';
require_once LIB_PATH . DS . 'css.php';
<?php
require_once "../../inc/initialize.php";
$database = new MySQLDatabase();
if (isset($_POST)) {
$acceptance_log = new AcceptanceLog();
$acceptance_log->student_id = $_POST['applicant_number'];
$acceptance_log->ResponseCode = $_POST['response_code'];
$result = $database->query("SELECT * FROM `interswitch_error_code` WHERE `response_code` = '" . $acceptance_log->ResponseCode . "'");
$result = $database->fetch_array($result);
$acceptance_log->ResponseDescription = $result['response_description'];
$acceptance_log->PaymentReference = $_POST['payment_reference'];
$acceptance_log->Amount = $_POST['amount'];
$acceptance_log->returned_amount = $_POST['amount'] * 100 . ".00";
$acceptance_log->status = $_POST['student_status'];
if ($acceptance_log->save()) {
echo '<h4 class="alert alert-success">Success</h4>';
echo '<hr>';
echo "<p>You have successfully added a new record into acceptance log for applicant with application number: " . $acceptance_log->student_id . ".</p>";
echo '<hr>';
} else {
echo '<h4 class="alert alert-error">Error</h4>';
echo '<hr>';
echo "Failed to insert into acceptance log.";
echo '<hr>';
}
}
break;
case 3:
break;
case 7:
break;
case 9:
break;
default:
redirect_to('home.php');
break;
}
$db = new MySQLDatabase();
if ($role == 4) {
$sql = "SELECT `department_name` from `department` WHERE `department_id` = '" . $_SESSION["department_id"] . "'";
$dept = $db->Query($sql);
$dept = $db->fetch_array($dept);
$dept = array_shift($dept);
}
$applicant_sql = "SELECT count(*) FROM `personal_details` WHERE `progress`='Completed'";
$total_applicant = $db->query($applicant_sql);
$total_applicant = $db->fetch_array($total_applicant);
$total_applicant = array_shift($total_applicant);
function pd_get_total($column, $value)
{
global $db;
$query = "SELECT count(*) FROM `personal_details` WHERE `progress`='Completed' AND `" . $column . "`='" . $value . "'";
$total = $db->query($query);
$total = $db->fetch_array($total);
$total = array_shift($total);
return $total;
}
function app_id_generator($dt_id, $applicant_id)
{
# Get the length of random number to generate
$random_number_length = 6 - strlen($applicant_id);
# Get the last delivery type code
$database = new MySQLDatabase();
$dtsql = $database->query("SELECT dt_code FROM delivery_type WHERE id='" . $dt_id . "'");
$result = $database->fetch_array($dtsql);
$dt_code = $result['dt_code'];
$random_number = rand(pow(10, $random_number_length - 1), pow(10, $random_number_length) - 1);
$dt = Carbon::now();
$carbon_year = $dt->format('Y');
$year = substr($carbon_year, 2, 2);
# Returns Delivery Type Code.Random Number.Year.Applicant Id
return $dt_code . $random_number . $year . $applicant_id;
}
</div>
<!-- Title -->
<?php
$sql_title = "SELECT * FROM title";
$result = $database->query($sql_title);
?>
<div class="control-group">
<label class="control-label" for="inputTitle">Title</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-user"></i></span>
<select class="input-small" name="title_id" id="title_id" >
<option value="">--Title--</option>
<?php
while ($row = $database->fetch_array($result)) {
if ($row['title_id'] == $result_details->title_id) {
echo '<option selected="selected" value="' . $row['title_id'] . '">' . $row['title_name'] . '</option>';
} else {
echo '<option value="' . $row['title_id'] . '">' . $row['title_name'] . '</option>';
}
}
?>
</select>
</div>
</div>
</div>
<!-- Full name -->
<div class="control-group">
<label class="control-label" for="inputFullname">Fullname</label>
<?php
require_once "../../inc/initialize.php";
$database = new MySQLDatabase();
$id = $_POST['acceptance_id'];
$application_number = $_POST['applicant_number'];
$responsecode = $_POST['approval_status'];
$amount = $_POST['amount'];
$returned_amount = $amount * 100 . '.00';
$payment_reference = $_POST['payment_ref'];
$responseDescription = $database->fetch_array($database->query("SELECT * FROM interswitch_error_code WHERE response_code = '" . $responsecode . "'"));
$responseDescription = $responseDescription['response_description'];
$status = $_POST['student_status'];
$updatesql = "UPDATE acceptance_acceptance_log SET PaymentReference='{$payment_reference}', Amount='{$amount}', returned_amount='{$returned_amount}', ResponseCode='{$responsecode}', ResponseDescription='{$responseDescription}', status='{$status}' WHERE id='{$id}'";
$result = $database->query($updatesql);
if ($result) {
echo '<h4 class="alert alert-success">Success</h4>';
echo '<hr>';
echo "You have successfully edited the acceptance fee payment record for applicant with application number: " . $application_number;
echo '<hr>';
} else {
echo '<h4 class="alert alert-error">Error</h4>';
echo '<hr>';
echo "Your updates were not saved";
}
<?php
//require_once("inc/initialize.php");
$session = new Session();
# Instance of MySQLDatabase
$db = new MySQLDatabase();
# Count the number of submitted transcript applications for an applicant
$query_count = "SELECT count(*) FROM app_histories WHERE applicant_id ='" . $session->id . "' AND application_flag = 1";
$result_count = $db->query($query_count);
$history_count = $db->fetch_array($result_count);
$count = array_shift($history_count);
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
// 2. records per page ($per_page)
$per_page = 3;
// 3. total record count ($total_count)
$total_count = $count;
// use pagination instead
$pagination = new Pagination($page, $per_page, $total_count);
// Instead of finding all records, just find the records
// for this page
$sql = "SELECT * FROM app_histories where applicant_id ='" . $session->id . "' AND application_flag = 1 ORDER BY `application_no` DESC ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$user_application_histories = AppHistory::find_by_sql($sql);
// Need to add ?page=$page to all links we want to
// maintain the current page (or store $page in $session)
$counter = 1;
?>
<h4><p class="label label-info">Application Status</p></h4>
<table class="table table-hover table-striped table-bordered">
echo $admin_details->email;
?>
" id="email" name="email" readonly />
</div>
</div>
</div>
<div class="control-group">
<label class="control-label" for="selectRecipient">Select Recipient: </label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-user"></i></span>
<select name="recipient" class="input-xlarge" id="recipient" required >
<option value="">--Select A Recipient--</option>
<?php
while ($result = $database->fetch_array($sql_all_users)) {
echo '<option value="' . $result['email'] . '">' . $result['surname'] . ' ' . $result['othernames'] . '</option>';
}
?>
</select>
</div>
</div>
</div>
<div class="control-group">
<label class="control-label" for="inputEmail">Password: </label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-lock"></i></span>
<input type="password" class="input-large" value="" id="password" name="password" />
</div>
<?php
# Instance of Session
$session = new Session();
# Get applicant's record from personal_details table using the session->id
$user = User::find_by_id($session->id);
if (isset($user->fullname) && !empty($user->fullname)) {
$label = ucfirst($user->fullname);
} else {
$label = $user->email;
}
$db = new MySQLDatabase();
// get all total notifications for the aplicant
$notifications_sql = "SELECT count(*) FROM `notifications` WHERE applicant_id ='" . $session->id . "'";
$total_notifications = $db->query($notifications_sql);
$total_notifications = $db->fetch_array($total_notifications);
$total_notifications = array_shift($total_notifications);
// get total Read And Unread notifications for the aplicant
//function pd_get_total_int($column, $int_value, $applicant_id)
function pd_get_total_int($column, $int_value)
{
global $db;
$query = "SELECT count(*) FROM `notifications` WHERE `" . $column . "` = " . $int_value;
// $query = "SELECT count(*) FROM `notifications` WHERE `".$column."` = ".$int_value AND $applicant_id ='".$session->id."';
$total = $db->query($query);
$total = $db->fetch_array($total);
$total = array_shift($total);
return $total;
}
$Unread = pd_get_total_int('status', 1);
$Read = pd_get_total_int('status', 2);
// get all total notifications for the aplicant
<?php
$db = new MySQLDatabase();
$session = new Session();
$applicant_fullname = User::applicant_fullname($session->applicant_id);
$result_details = User::find_by_id($session->applicant_id);
$display_greeting = greeting();
/**/
$active_sql = "SELECT COUNT(*) FROM `applicant_notifications` WHERE status = 1 AND recipient_id = " . $session->applicant_id;
$total_active = $db->query($active_sql);
$total_active = $db->fetch_array($total_active);
$total_active = array_shift($total_active);
$inactive_sql = "SELECT COUNT(*) FROM `applicant_notifications` WHERE status = 2 AND recipient_id = " . $session->applicant_id;
$total_inactive = $db->query($inactive_sql);
$total_inactive = $db->fetch_array($total_inactive);
$total_inactive = array_shift($total_inactive);
$admissions = new Admission();
$sql = "select * from admission_status where applicant_id='" . $session->applicant_id . "'";
$admissions = Admission::find_by_sql($sql);
foreach ($admissions as $admission) {
$time = $admission->time_completed_application;
$academic_session = $admission->academic_session;
$status = $admission->status;
$reason_ = $admission->reason;
}
?>
<div class="navbar">
<div class="navbar-inner"> <a class="brand" href="#"></a>
<ul class="nav nav-tabs">
<li class="active"><a href="home.php"><span><i class="icon-home"></i> </span> Home</a></li>
<?php
require_once '../inc/initialize.php';
$db_academic = new MySQLDatabase();
$sql_grade = "SELECT * FROM exam_grade";
$result_grade = $db_academic->query($sql_grade);
while ($record = $db_academic->fetch_array($result_grade)) {
echo '<option value="' . $record['grade_id'] . '">' . $record['grade'] . '</option>';
}
redirect_to('index.php');
}
$user = new User();
$user->applicant_id = $session->applicant_id;
$progress = $user->find_by_sql("SELECT progress FROM personal_details WHERE applicant_id='" . $user->applicant_id . "'");
$progress = array_shift($progress);
if ($progress->progress != 'Completed') {
redirect_to('application_form.php');
}
$student_status = $user->get_student_status();
$database = new MySQLDatabase();
?>
<?php
$personal_details = $database->query("SELECT * FROM personal_details p, title t, lga l, state s, religion r, nationality n, department d, faculty f, next_of_kin next, marital mar, photographs photo WHERE p.applicant_id='" . $session->applicant_id . "' AND p.title_id=t.title_id AND p.lga_id=l.lga_id AND l.state_id=s.state_id AND p.religion_id=r.religion_id AND p.country_id=n.country_id AND p.programme_applied_id=d.department_id AND d.faculty_id=f.faculty_id AND p.applicant_id=next.applicant_id AND p.applicant_id=photo.applicant_id AND p.marital_status=mar.marital_status_id");
$personal_details = $database->fetch_array($personal_details);
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>University of Jos, Nigeria - <?php
echo $personal_details['faculty_name'];
?>
Complete Application Form</title>
<?php
require_once LIB_PATH . DS . 'javascript.php';
require_once LIB_PATH . DS . 'css.php';
?>
<style type="text/css">
@media print{
<th>S/N</th>
<th>Passport</th>
<th>Full Name</th>
<th>Email</th>
<th>Details</th>
</tr>
</thead>
<tbody>
<?php
$db = new MySQLDatabase();
$credits = $db->query("SELECT * FROM credits WHERE status='active' ORDER BY credit_id ASC");
$numrows = $db->num_rows($credits);
$passport_path = "documents" . DS . "credit_passports" . DS;
$serial_no = 1;
$numrows;
while ($row = $db->fetch_array($credits)) {
$mail = str_replace("@", "[at]", $row["email"]);
if (empty($numrows)) {
echo '<tr><td colspan="5" align="center">No Information Uploaded for the developer\'s Team</td></tr>';
} else {
echo '<tr>
<td>' . $serial_no . '</td>
<td><div class="thumbnail" style="width: 100px; height: 133px;"><img src="' . $passport_path . $row["passport"] . '" width="100px" height="90px"></div></td>
<td>' . $row["fullname"] . '</td>
<td>' . $mail . '</td>
<td><a href="developer_details.php?id=' . customEncrypt($row["credit_id"]) . '" class="btn">More...</a></td>
</tr>';
$serial_no++;
}
}
?>
</div>
<!-- Title -->
<?php
$sql_title = "SELECT * FROM titles WHERE title_visible = 1";
$result = $database->query($sql_title);
?>
<div class="control-group">
<label class="control-label" for="inputTitle">Title</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-xlarge" name="title_id" id="title_id" >
<option value="">--Title--</option>
<?php
while ($row = $database->fetch_array($result)) {
if ($row['id'] == $user->title_id) {
echo '<option selected="selected" value="' . $row['id'] . '">' . $row['title_name'] . '</option>';
} else {
echo '<option value="' . $row['id'] . '">' . $row['title_name'] . '</option>';
}
}
?>
</select>
</div>
</div>
</div>
<!-- Fullname -->
<div class="control-group">
<label class="control-label" for="inputFullName">Full Name</label>
$faculty = htmlspecialchars($_POST['faculty_id'], ENT_QUOTES);
$department = htmlspecialchars($_POST['department_id'], ENT_QUOTES);
$state = htmlspecialchars($_POST['state'], ENT_QUOTES);
$gender = htmlspecialchars($_POST['gender'], ENT_QUOTES);
$admission_status = htmlspecialchars($_POST['admission_status'], ENT_QUOTES);
$form_id = htmlspecialchars($_POST['form_id'], ENT_QUOTES);
$applicant_name = htmlspecialchars($_POST['applicant_name'], ENT_QUOTES);
$date_from = htmlspecialchars($_POST['date_from'], ENT_QUOTES);
$date_to = htmlspecialchars($_POST['date_to'], ENT_QUOTES);
$arrayDateSpec = array();
if ($date_from != NULL && $date_to != NULL) {
$arrayDateSpec = array($date_from, $date_to);
}
if ($faculty != 'all') {
$faculty_details_result = $database->query("SELECT * FROM faculty WHERE faculty_id='" . $faculty . "'");
$faculty_details = $database->fetch_array($faculty_details_result);
$faculty_code = $faculty_details['faculty_code'];
} else {
$faculty_code = 'all';
}
if ($state != 'all') {
$lga_result = $database->query("SELECT lga_id FROM lga WHERE state_id = '" . $state . "'");
$lga = array();
while ($row = $database->fetch_array($lga_result)) {
array_push($lga, $row);
}
}
$array_values = array('p.student_status' => $faculty_code, 'p.programme_applied_id' => $department, 'state_id' => $state, 'p.gender' => $gender, 'ads.status' => $admission_status, 'p.form_id' => $form_id, 'applicant_name' => $applicant_name, 'date' => $arrayDateSpec);
function admission_status($status)
{
switch ($status) {
echo $result->student_id;
?>
" />
</div>
</div>
</div>
<div class="control-group">
<label class="control-label">Response Description</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<select class="input-xlarge" name="approval_status" id="approval_status" >
<?php
$arrayDescription = $database->query("SELECT * FROM interswitch_error_code WHERE status=1");
while ($rowDesc = $database->fetch_array($arrayDescription)) {
if ($rowDesc['response_code'] == $result->ResponseCode) {
echo '<option selected="selected" value="' . $rowDesc['response_code'] . '">' . $rowDesc['response_description'] . '</option>';
} else {
echo '<option value="' . $rowDesc['response_code'] . '">' . $rowDesc['response_description'] . '</option>';
}
}
?>
</select>
</div>
</div>
</div>
<div class="control-group">
<label class="control-label">Amount</label>
<div class="controls">
</div>
<!-- Examination Type -->
<div class="control-group">
<label class="control-label" for="inputFormId"><b>Examination Type</b></label>
<div class="controls">
<select class="input-medium" name="<?php
echo $type_arr[1];
?>
" id="<?php
echo $type_arr[1];
?>
" >
<option value="">...</option>
<?php
while ($record = $db_academic->fetch_array($result_exam)) {
if ($record['exam_type_id'] == $olevel_detail[1]->exam_type_id) {
echo '<option selected="selected" value="' . $record['exam_type_id'] . '">' . $record['exam_name'] . '</option>';
} else {
echo '<option value="' . $record['exam_type_id'] . '">' . $record['exam_name'] . '</option>';
}
}
?>
</select>
</div>
</div>
<!-- Examination Centre -->
<div class="control-group">
<label class="control-label" for="inputFormId"><b>Examination Centre Number</b></label>
<div class="controls">
<?php
require_once "../inc/initialize.php";
//checks if admin user is logged in
if (!$session->is_admin_logged_in()) {
redirect_to('index.php');
}
$role = $_SESSION["role"];
if ($role == 4) {
$db = new MySQLDatabase();
$sql = "SELECT `department_name` from `department` WHERE `department_id` = '" . $_SESSION["department_id"] . "'";
$dept = $db->Query($sql);
$dept = $db->fetch_array($dept);
$dept = array_shift($dept);
}
function privilege()
{
global $role;
switch ($role) {
case 1:
$msg = "Main Administrative";
break;
case 2:
$msg = "Post Graduate Administrative";
break;
case 3:
$msg = "Non NUC Administrative";
break;
case 4:
$msg = "Departmental Administrative";
break;
<?php
require_once '../inc/initialize.php';
$db_academic = new MySQLDatabase();
$sql_subject = "SELECT * FROM exam_subject where visible = 1";
$result_subject = $db_academic->query($sql_subject);
while ($record = $db_academic->fetch_array($result_subject)) {
echo '<option value="' . $record['subject_id'] . '">' . $record['subject_name'] . '</option>';
}
