require_once "../initialize.php";
require_once "../vendor/autoload.php";
use Carbon\Carbon;
$dt = Carbon::now();
$session = new Session();
$orderId = $_POST['orderId'];
// Obtain application_no from orderId
$application_no = $orderId;
$amount = $_POST['amt'];
$ResponseCode = $_POST['ResponseCode'];
$ResponseDescription = $_POST['ResponseDescription'];
$payerName = $_POST['payerName'];
$serial_payment_brakdown = $_SESSION["payment_breakdown"];
# Unset payment breakdown session variable
unset($_SESSION["payment_breakdown"]);
# Update acceptance_log
if (isset($_POST['action']) && $_POST['action'] == 'insertlog') {
# Instance of Acceptance
$acceptance = new AcceptanceLog();
$acceptance->student_id = $application_no;
$acceptance->applicant_id = $session->id;
$acceptance->PaymentReference = $orderId;
$acceptance->ResponseCode = $ResponseCode;
$acceptance->ResponseDescription = $ResponseDescription;
$acceptance->Amount = $amount;
$acceptance->Initiating_date = $dt->toDateTimeString();
$acceptance->returned_paymentreference = $serial_payment_brakdown;
# Save Record into Table acceptance_log
$acceptance->save();
}
<?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>';
}
}
