<?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>
示例#3
0
<?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 = '&#8358;';
$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>
示例#7
0
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) {
示例#9
0
	<?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>
示例#11
0
            $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);
示例#12
0
$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>';
    }
}
示例#14
0
        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;
}
示例#15
0
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;
}
示例#16
0
                    </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";
}
示例#18
0
<?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">
示例#19
0
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>
示例#20
0
 <?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>';
}
示例#23
0
    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{
示例#24
0
				<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>
示例#26
0
$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) {
示例#27
0
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">
示例#29
0
<?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>';
}