Exemple #1
0
require_once "inc/initialize.php";
if (!$session->is_logged_in()) {
    redirect_to('index.php');
}
$user = new User();
$user->applicant_id = $session->applicant_id;
$form_id = $user->get_form_id();
$sql = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no`='" . $form_id . "' AND `reg_num`='" . $form_id . "'";
$payment_record = $user->find_by_sql($sql);
if (empty($payment_record)) {
    redirect_to('select_form.php');
}
$student_status = $user->get_student_status();
$database = new MYSQLDatabase();
$sqlprogrammedetails = "SELECT * FROM personal_details p, department d, faculty f WHERE p.applicant_id=" . $session->applicant_id . " AND p.programme_applied_id=d.department_id AND d.faculty_id=f.faculty_id";
$programmedetails = $database->fetch_array($database->query($sqlprogrammedetails));
$sessiondetails = $database->fetch_array($database->query("SELECT session FROM application_status WHERE id=1"));
$paymentdetails = $database->fetch_array($database->query("SELECT * FROM adm_access_code WHERE jamb_rem_no='" . $programmedetails['form_id'] . "'"));
$invoice = new Invoice();
$invoice->db_fields = array('applicant_id', 'date', 'amount');
$invoice->applicant_id = $session->applicant_id;
$invoice->date = date('Y-m-d H:i:s', time());
$invoice->amount = $paymentdetails['amount'];
$invoice->save();
$invoicedetails = $database->fetch_array($database->query("SELECT * FROM invoice WHERE applicant_id='" . $session->applicant_id . "'"));
//set it to writable location, a place for temp generated PNG files
// $PNG_TEMP_DIR = dirname(__FILE__).DIRECTORY_SEPARATOR.'temp'.DIRECTORY_SEPARATOR;
$PNG_TEMP_DIR = 'inc/qrcode/temp/';
//html PNG location prefix
$PNG_WEB_DIR = 'inc/qrcode/temp/';
include "inc/qrcode/qrlib.php";
Exemple #2
0
    header("Content-Type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename={$filename}.xls");
    header("Pragma: no-cache");
    header("Expires: 0");
    /*******Start of Formatting for Excel*******/
    //define separator (defines columns in excel & tabs in word)
    $sep = "\t";
    //tabbed character
    $schema_insert = "";
    echo 'S/N' . $sep;
    echo 'Application Number' . $sep;
    echo 'Fullname' . $sep;
    echo 'Programme' . $sep;
    echo 'Date of Application' . $sep;
    echo 'Admission Status' . $sep;
    print "\n";
    $serialno = 1;
    while ($row = $database->fetch_array($result)) {
        $schema_insert .= $serialno . $sep;
        $schema_insert .= $row["form_id"] . $sep;
        $schema_insert .= ucwords($row["surname"]) . ' ' . $row["first_name"] . ' ' . $row["middle_name"] . $sep;
        $schema_insert .= $row["department_name"] . $sep;
        $schema_insert .= date('Y-m-d', $row["time_completed_application"]) . $sep;
        $schema_insert .= admission_status($row["status"]) . $sep;
        $schema_insert .= "\n";
        $serialno++;
    }
    echo $schema_insert;
} else {
    redirect_to('view_applicant.php');
}
Exemple #3
0
<body>
<?php 
include_layout_template("header.php");
?>

<!-- beginnning of main content-->
<div class="container">
	<div class="row-fluid">
		<div class="span10 offset1" >
            <h4>MAKE PAYMENT</h4>
            <hr>
            <?php 
$database = new MYSQLDatabase();
$sql = "SELECT * FROM `personal_details` p JOIN `faculty` f JOIN `department` d JOIN `form_amount` fa WHERE p.applicant_id='" . $session->applicant_id . "' AND p.programme_applied_id=d.department_id AND f.faculty_id=d.faculty_id AND fa.student_status=p.student_status";
$result = $database->query($sql);
$result = $database->fetch_array($result);
$transaction_charge = $result["transaction_amount"];
$our_total = ($result["amount"] + $transaction_charge) * 100;
$payment_id = $result["pay_item_id"];
$naira = '&#8358;';
?>
            <table class="table table-hover table-bordered">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Programme</th>
                        <th>Course</th>
                        <th>Programme Charge</th>
                        <th>Transaction Charge</th>
                        <th>Total Charge</th>
                    </tr>
		<br>

		<!-- Content -->
		<div class="row-fluid">

			<?php 
include_layout_template('admin_menu.php');
?>

			<div class="span9">
				<h2>Edit Amount Details</h2>
				<hr>
				<?php 
$amount_id = customDecrypt($_POST['amount_id']);
$amount_details_sql = $database->query("SELECT * FROM `form_amount` WHERE amount_id = " . $amount_id . "");
$amount_details = $database->fetch_array($amount_details_sql);
?>
				<!-- Begining of Credit form -->
				<form class="form-horizontal amount_update" id="amount_update">
					<input type="hidden" name="amount_id" value="<?php 
echo $amount_details['amount_id'];
?>
"/>
					<div class="control-group">
						<label class="control-label">Programme</label>
						<div class="controls">
							<div class="input-prepend">
								<span class="add-on"><i class="icon-user"></i></span>
                                <select name="programme">
								<?php 
$sql_faculty = "SELECT * FROM faculty WHERE `status` = 1 ORDER BY faculty_name ASC";
<?php

require_once "inc/initialize.php";
if (!isset($_POST['txnref'])) {
    redirect_to("index.php");
}
require_once "inc/ajiya/webservice.php";
$transctiondetails = checkTranxact(getStatus($_SESSION["transaction_id"]));
$applicant = User::find_by_id($session->applicant_id);
$database = new MYSQLDatabase();
$sqlprogrammedetails = "SELECT `faculty_name`,`department_name` FROM personal_details p, department d, faculty f WHERE p.applicant_id=" . $_SESSION["applicant_id"] . " AND p.programme_applied_id=d.department_id AND d.faculty_id=f.faculty_id";
$programmedetails = $database->fetch_array($database->query($sqlprogrammedetails));
$sessiondetails = $database->fetch_array($database->query("SELECT session FROM application_status WHERE id=1"));
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>University of Jos, Nigeria</title>
<?php 
require_once LIB_PATH . DS . 'javascript.php';
require_once LIB_PATH . DS . 'css.php';
?>
<style type="text/css">
	@media print{
		.noprint{display:none}
		.imgg{
			margin-top:-400px; 
			opacity:0.1; 
			width:200px; 
			display:inline-block !important;
    	</div>
    </div>
  </div>
  
  <div class="control-group">
    <label class="control-label" for="inputPassword">Role</label>
    <div class="controls">
      <div class="input-prepend">
      		<span class="add-on"><i class="icon-bookmark"></i></span>
            <select name="role" class="input-xlarge" id="role" required >
            	<option value="">--Select A Role--</option>
                <?php 
$database = new MYSQLDatabase();
$roles = $database->query("SELECT * FROM admin_roles");
//The key acts as values in the database
while ($row_roles = $database->fetch_array($roles)) {
    echo '<option value="' . $row_roles['admin_role_id'] . '">' . $row_roles['admin_role_name'] . '</option>';
}
?>
            </select>
    	</div>
    </div>
  </div>
  <?php 
$database = new MySQLDatabase();
$sql_faculty = "SELECT * FROM faculty ORDER BY faculty_name ASC";
$result_set = $database->query($sql_faculty);
?>
  <div class="department_administrator" style="display:none">
	<div class="control-group">
    <label class="control-label">Programme</label>