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>'; } }