Esempio n. 1
0
	<thead>
		<tr>
			<th>SN</th>
			<th>Application No</th>
			<th>Amount</th>
			<th>Payment Date</th>
			<th>Application Status</th>
		</tr>
	</thead>
    <?php 
if (isset($histories) && !empty($histories)) {
    $serial_no = 1;
    # Loop through applicantion history for an applicant
    foreach ($histories as $history) {
        $sql_trans = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no` = '" . $history->application_no . "'";
        $transaction = AdmAccess::find_by_sql($sql_trans);
        $tranx_record = array_shift($transaction);
        ?>
                <tbody>
        	        <tr>
        		        <td><?php 
        echo $serial_no;
        ?>
</td>
                        <td><?php 
        if (isset($tranx_record->jamb_rem_no)) {
            echo $tranx_record->jamb_rem_no;
        }
        ?>
</td>
                        <td><?php 
    $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');
    }
    // Save Record into Table acceptance_log or update as the need be
    $acceptance->save();
    echo "done";
} elseif (isset($_POST['action']) && $_POST['action'] == 'insertaccesscode') {
    $adm = new AdmAccess();
    $adm->jamb_rem_no = $form_no;
    $adm->pin = $RefNumb;
    $adm->amount = $amount . '.00';
    $adm->payment_date = $TranxDate;
    $adm->payment_code = $RetRefNumb;
    $adm->reg_num = $form_no;
    $adm->full_name = $Applicant_detail->surname . " " . $Applicant_detail->first_name . " " . $Applicant_detail->middle_name;
    $adm->status = $Applicant_detail->student_status;
    // Save Record into Table adm_access_code
    $adm->save();
    echo 'done';
}
Esempio n. 3
0
$PNG_TEMP_DIR = 'inc/qrcode/temp/';
# HTML PNG location prefix
$PNG_WEB_DIR = 'inc/qrcode/temp/';
# QR Code Library
include "inc/qrcode/qrlib.php";
# ofcourse we need rights to create temp dir
if (!file_exists($PNG_TEMP_DIR)) {
    mkdir($PNG_TEMP_DIR);
}
# 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 = &#8358;
# Data to be inserted into QR Code
$data = $user->full_name;
$data .= ' ' . $orderId . ' ' . $payment_record->amount;
# QR Code image path on server
Esempio n. 4
0
    redirect_to("index.php");
}
# Instance of user class
$user = User::find_by_id($session->id);
# Get application history form app_histories table
$sql_history = "SELECT * FROM app_histories WHERE applicant_id =" . $user->id . " and application_flag = 0";
$history_details = AppHistory::find_by_sql($sql_history);
$app_history_details = array_shift($history_details);
$application_no = $app_history_details->application_no;
# Check if the application history exist
if (empty($app_history_details)) {
    redirect_to("payment.php");
} else {
    # Get adm payment details from adm_access_code table
    $sql_adm = "SELECT * FROM adm_access_code WHERE jamb_rem_no ='" . $app_history_details->application_no . "'";
    $adm_details = AdmAccess::find_by_sql($sql_adm);
    # Check if payment details exist
    if (empty($adm_details)) {
        redirect_to("payment.php");
    }
}
?>
 
<!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';
<?php

require_once "../../inc/initialize.php";
$database = new MySQLDatabase();
if (isset($_POST)) {
    $AdmAccess = new AdmAccess();
    $AdmAccess->db_fields = array('jamb_rem_no', 'pin', 'amount', 'payment_date', 'ip_addr', 'payment_code', 'branch_code', 'bank_code', 'reg_num', 'full_name', 'status');
    $AdmAccess->jamb_rem_no = $_POST['applicant_number'];
    $AdmAccess->pin = $_POST['access_code'];
    $AdmAccess->amount = $_POST['amount'] * 100 . ".00";
    $AdmAccess->payment_date = $_POST['transaction_date'];
    $AdmAccess->ip_addr = $_POST['ip_address'];
    $AdmAccess->branch_code = $_POST['branch_code'];
    $AdmAccess->reg_num = $_POST['applicant_number'];
    $AdmAccess->full_name = $_POST['full_name'];
    $AdmAccess->status = $_POST['student_status'];
    /*print_r($AdmAccess);
    		die();*/
    if ($AdmAccess->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: " . $AdmAccess->jamb_rem_no . ".</p>";
        echo '<hr>';
    } else {
        echo '<h4 class="alert alert-error">Error</h4>';
        echo '<hr>';
        echo "Failed to insert into acceptance log.";
        echo '<hr>';
    }
}
Esempio n. 6
0
if (!$session->is_logged_in()) {
    redirect_to("index.php");
}
# Instance of Carbon Class with the current time
$date_now = new Carbon('now');
$label = customDecrypt($_GET['app']);
if ($label) {
    // $database = new MySQLDatabase();
    // $sql_user_details="SELECT * from app_histories aph Join adm_access_code adm, applicant_status aps WHERE aph.application_no = '".$label."' AND  adm.application_no=aph.application_no  AND aps.application_no= aph.application_no";
    // $user_history=$database->query($sql_user_details);
    // $myhistory = $database->fetch_array($user_history);
    $sql_app = "SELECT * FROM `app_histories` WHERE `application_no` = '" . $label . "'";
    $application = AppHistory::find_by_sql($sql_app);
    $myapp = array_shift($application);
    $sql_amount = "SELECT * FROM `adm_access_code` WHERE `jamb_rem_no` = '" . $label . "'";
    $transaction = AdmAccess::find_by_sql($sql_amount);
    $amount = array_shift($transaction);
    $sql = "SELECT * FROM `applicant_status` WHERE `application_no` = '" . $label . "'";
    $process = ApplicantStatus::find_by_sql($sql);
}
?>
<!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">
Esempio n. 7
0
<?php

require_once "../../inc/initialize.php";
$adm = new AdmAccess();
$adm->id = $_POST['adm_id'];
$adm->pin = $_POST['access_code'];
$adm->amount = $_POST['amount'] * 100 . '.00';
$adm->payment_date = $_POST['transaction_date'];
$adm->ip_addr = $_POST['ip_address'];
$adm->payment_code = $_POST['payment_code'];
$adm->branch_code = $_POST['branch_code'];
$adm->full_name = $_POST['full_name'];
$adm->status = $_POST['student_status'];
$adm->db_fields = array('pin', 'amount', 'payment_date', 'ip_addr', 'payment_code', 'branch_code', 'bank_code', 'full_name', 'status');
if ($adm->save()) {
    echo '<h4 class="alert alert-success">Success</h4>';
    echo '<hr>';
    echo "You have successfully edited the payment record for applicant with application number: " . $_POST['applicant_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";
$id = $_POST['adm_id'];
$adm = new AdmAccess();
$adm->id = $id;
if ($adm->delete()) {
    echo '<h4 class="alert alert-success">Success</h4>';
    echo '<hr>';
    echo "Payment record successfully deleted";
    echo '<hr>';
    echo '<a href="search_adm.php">Continue</a<>';
} else {
    echo '<h4 class="alert alert-error">Error</h4>';
    echo '<hr>';
    echo "Payment record not deleted";
}
Esempio n. 9
0
		<br>
		<br>

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

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

			<div class="span9">
				<h2>Transaction Log (Successful Payment)</h2>
				<hr>
						<?php 
//$acc_log = new AcceptanceLog();
$result = AdmAccess::find_by_sql("SELECT * FROM `adm_access_code` WHERE `jamb_rem_no` = '" . customDecrypt($_GET['q']) . "' AND reg_num = '" . customDecrypt($_GET['q']) . "'");
$result = array_shift($result);
?>
						<!-- Begining of acceptance log form -->
				<form class="form-horizontal adm_access_details">
					<input type="hidden" name="adm_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->jamb_rem_no;
Esempio n. 10
0
    $RetRefNumb = $rea['RetRefNumb'];
    $TranxDate = $rea['TranxDate'];
    echo '
	<h4 class="alert alert-info">Interswitch says</h4>
	<table class="table table-hover">
		<tr ><td>Response Code:</td><td>' . $ResponseCode . '</td></tr>
		<tr ><td>Response Description:</td><td>' . $ResponseDescription . '</td></tr>
		<tr ><td>Amount:</td><td>' . $amount . '</td></tr>
		<tr ><td>Merchant Reference:</td><td>' . $PaymentReference . '</td></tr>
		<tr ><td>Payment Reference:</td><td>' . $RefNumb . '</td></tr>
		<tr ><td>Returned Ref Number:</td><td>' . $RetRefNumb . '</td></tr>
		<tr ><td>Transaction Date:</td><td>' . $TranxDate . '</td></tr>
		</table>';
    if ($ResponseCode == '00') {
        //get fullname of applicant
        $adm = new AdmAccess();
        $sqlcheck = "SELECT id FROM `adm_access_code` WHERE `jamb_rem_no` = '" . $_POST['number'] . "'";
        $check = $adm->find_by_sql($sqlcheck);
        // Check if the record does not exist in both acceptance_log and adm_access_code then insert and if they do update it
        if (empty($check)) {
            $sql_fullname = "SELECT applicant_id, surname, first_name, middle_name, student_status ";
            $sql_fullname .= "FROM `personal_details` WHERE `form_id` = '" . $_POST['number'] . "'";
            $Applicant_details = User::find_by_sql($sql_fullname);
            $Applicant_detail = array_shift($Applicant_details);
            $acceptance = new AcceptanceLog();
            $acceptance->db_fields = array('ResponseCode', 'ResponseDescription', 'Amount', 'returned_amount', 'MerchantReference', 'PaymentReference', 'status');
            $sql_acc_id = "SELECT id FROM `acceptance_log` WHERE student_id='" . $_POST['number'] . "'";
            $acc_id = $acceptance->find_by_sql($sql_acc_id);
            $acc_id_final = array_shift($acc_id);
            $acceptance->ResponseCode = $ResponseCode;
            $acceptance->ResponseDescription = $ResponseDescription;