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";
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');
}
<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 = '₦';
?>
<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>