$ResponseCode = $_POST['ResponseCode'];
$CardNumber = $_POST['CardNumber'];
$RefNumb = $_POST['RefNumb'];
$RetRefNumb = $_POST['RetRefNumb'];
$TranxDate = $_POST['TranxDate'];
$ResponseDescription = $_POST['ResponseDescription'];
$PaymentReference = $_POST['PaymentReference'];
$form_no = substr($RefNumb, 2, sizeof($RefNumb) - 3);
$sql_fullname = "SELECT applicant_id, surname, first_name, middle_name, student_status FROM `personal_details` WHERE `form_id` = '" . $form_no . "'";
$Applicant_details = User::find_by_sql($sql_fullname);
$Applicant_detail = array_shift($Applicant_details);
if (isset($_POST['action']) && $_POST['action'] == 'updateit') {
$acceptance = new AcceptanceLog();
$acceptance->db_fields = array('student_id', 'ResponseCode', 'ResponseDescription', 'Amount', 'returned_amount', 'MerchantReference', 'PaymentReference', 'Initiating_date', 'Interswitch_date', 'status');
$sql_acc_id = "SELECT id FROM `acceptance_log` WHERE student_id='" . $form_no . "'";
$acc_id = $acceptance->find_by_sql($sql_acc_id);
$acc_id_final = array_shift($acc_id);
$acceptance->student_id = $form_no;
$acceptance->ResponseCode = $ResponseCode;
$acceptance->ResponseDescription = $ResponseDescription;
$acceptance->Amount = $amount / 100;
$acceptance->returned_amount = $amount . '.00';
$acceptance->MerchantReference = $PaymentReference;
$acceptance->PaymentReference = $RefNumb;
$acceptance->Interswitch_date = $TranxDate;
$acceptance->status = $Applicant_detail->student_status;
if (!empty($acc_id_final)) {
$acceptance->id = $acc_id_final->id;
} else {
$acceptance->Initiating_date = date('Y-m-d H:i:s');
}
}
# QR Code properties
$errorCorrectionLevel = 'H';
$matrixPointSize = 4;
# Get payment record for an application form
// $sql = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no`='".$orderId."' AND `reg_num`='".$orderId."'";
$sql = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no`='" . $orderId . "'";
$payment = AdmAccess::find_by_sql($sql);
$payment_record = array_shift($payment);
# Redirect applicant to make payment if no user is found
if (empty($payment_record)) {
redirect_to('payment.php');
}
# Get log record for payment
$sql_log = "SELECT * FROM `acceptance_log` WHERE `student_id` = '" . $orderId . "'";
$log_payment = AcceptanceLog::find_by_sql($sql_log);
$log = array_shift($log_payment);
$payment_breakdown = unserialize($log->returned_paymentreference);
// $naira = ₦
# Data to be inserted into QR Code
$data = $user->full_name;
$data .= ' ' . $orderId . ' ' . $payment_record->amount;
# QR Code image path on server
$filename = $PNG_TEMP_DIR . $orderId . md5($errorCorrectionLevel . '|' . $matrixPointSize . '|' . $orderId) . '.png';
# Create QR Code
QRcode::png($data, $filename, $errorCorrectionLevel, $matrixPointSize, 2);
$imgqrcode = '<img src="' . $PNG_WEB_DIR . basename($filename) . '" />';
?>
<section class="slice">
<!-- Invoice wrapper -->
<div id="invoice" class="paid">
<td>' . $result["faculty_name"] . '</td>
<td>' . $result["department_name"] . '</td>
<td>₦' . $result["amount"] . '</td>
<td>₦' . $transaction_charge . '</td>
<td>₦' . ($result["amount"] + $transaction_charge) . '</td>';
?>
</tr>
</tbody>
</table>
<div class="row">
<div class="span4 offset5">
<?php
$acceptance = new AcceptanceLog();
$sql = "SELECT * FROM acceptance_log WHERE student_id = '" . $applicantFormId->form_id . "' AND ResponseDescription = 'Pending...' LIMIT 1";
//$checks = AcceptanceLog::find_by_sql($sql);
$checks = $acceptance->find_by_sql($sql);
$check = array_shift($checks);
if (!empty($check) and $check->ResponseDescription == "Pending...") {
?>
<button id="Exit" onClick="location.replace('logout.php?logoff=logoff');" class="btn btn-danger">
Oppsy - You Have a Pending Transaction clear it to avoid double payment
</button>
<?php
} else {
?>
<img src="images/interswitch_logo.png" alt="interswitch_logo">
<br>
<br>
<!-- Content -->
<div class="row-fluid">
<?php
include_layout_template('admin_menu.php');
?>
<div class="span9">
<h2>Form Transaction Log</h2>
<hr>
<?php
//$acc_log = new AcceptanceLog();
$result = AcceptanceLog::find_by_sql("SELECT * FROM `acceptance_log` WHERE `student_id` = '" . customDecrypt($_GET['q']) . "'");
$result = array_shift($result);
?>
<!-- Begining of acceptance log form -->
<form class="form-horizontal acceptance_log_details">
<input type="hidden" name="acceptance_id" value="<?php
echo $result->id;
?>
"/>
<div class="control-group">
<label class="control-label">Application Number</label>
<div class="controls">
<div class="input-prepend">
<span class="add-on"><i class="icon-chevron-down"></i></span>
<input type="text" readonly name="applicant_number" placeholder="Applicant Number" class="input-xlarge" value="<?php
echo $result->student_id;
$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 = 4;
// 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 `acceptance_log` WHERE applicant_id ='" . $session->id . "' ORDER BY `student_id` DESC ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$Users = AcceptanceLog::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">Transaction History</p></h4>
<table class="table table-hover table-striped table-bordered">
<thead>
<tr>
<th>SN</th>
<th>Application No</th>
<th>Response Description</th>
<th>Amount</th>
<th>Initiating Date</th>
</tr>
</thead>
if (isset($_SESSION["lga_id"])) {
$lga_id = $_SESSION["lga_id"];
unset($_SESSION["lga_id"]);
}
// print_r($transctiondetails);
// die();
$orderId = $transctiondetails["orderId"];
$tranxTime = $transctiondetails["transactiontime"];
$RRR = $transctiondetails["RRR"];
$ResponseCode = $transctiondetails["status"];
$ResponseDescription = $transctiondetails["message"];
# Instance of Acceptance
$acc = new AcceptanceLog();
# Get id, Amount, student_id for acceptance_log record
$sql_acceptance_log = "SELECT id, Amount, student_id FROM `acceptance_log` WHERE student_id='" . $orderId . "'";
$acceptance_log = $acc->find_by_sql($sql_acceptance_log);
$log = array_shift($acceptance_log);
$amount = $log->Amount;
$acc_id = $log->id;
$application_no = $log->student_id;
?>
<!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">
<thead>
<tr>
<th>SN</th>
<th>Application No</th>
<th>Response Description</th>
<th>Amount</th>
<th>Initiating Date</th>
<th>View</th>
</tr>
</thead>
<?php
if (isset($Users)) {
$serial_no = 1;
foreach ($Users as $user_record) {
$sql_trans = "SELECT * FROM `acceptance_log` WHERE `student_id` = '" . $user_record->application_no . "'";
$transaction = AcceptanceLog::find_by_sql($sql_trans);
$transaction_rec = array_shift($transaction);
?>
<tbody data-provides="rowlink">
<tr class="rowlink">
<td><?php
echo $serial_no;
?>
</td>
<td><?php
if (isset($transaction_rec->student_id)) {
echo $transaction_rec->student_id;
}
?>
</td>
<td><?php
