<?php
session_start();
$matNo=$formNo=$_SESSION['formNo'];
//http://localhost:8080/response.php?LOGO_URL=http%3A%2F%2Fnsuid.com.ng%2Ffaq.php%2Fmfmlogo.jpg&
//RESPONSE_URL=http%3A%2F%2Flocalhost%3A8080%2Fresponse.php&CURRENCY_CODE=NGN&TERMINAL_ID=0000000001&TRANSACTION_ID=etz1467994932web&
//AMOUNT=1000&DESCRIPTION=Payment+Description&FINAL_CHECKSUM=FD0EBFD90AD46AE42B1BE5772CDA388A&SUCCESS=0&CHECKSUM=dacb90cd175360649a5cb23f8a70ccca&
//TRANS_NUM=ETZ1607081723072132SMIGs&msg=Approved&DEBITED_AMOUNT=1000&ECHODATA=
/*SUCCESS+AMOUNT+TERMINAL_ID+TRANSACTION_ID+RESPONSE_URL+SECRETKEY*/
echo $success = $_REQUEST['SUCCESS'];
$aspoa=explode('&',$success);

$aspoa_status=explode('=',$aspoa[0]);
echo $status= $aspoa_status[1];

$aspoa_orderID=explode('=',$aspoa[1]);
echo $orderID= $aspoa_orderID[1];

$aspoa_card=explode('=',$aspoa[6]);
echo $card= $aspoa_card[1];

$aspoa_paymentType=explode('=',$aspoa[5]);

$aspoa_transDate=explode('=',$aspoa[4]);
echo $transDate= $aspoa_transDate[1];

$aspoa_paymentType=explode('=',$aspoa[5]);
echo $paymentType=$aspoa_paymentType[1];

if (strlen($paymentType)>10){
    $aspoa_paymentType=explode('~',$paymentType);
    $paymentType=$aspoa_paymentType[0];
}


echo '<br> Paymet Type '. $paymentType;
$response_code=$status;
switch ($response_code) {
    case "0":
        $status_desc = "Transaction successful. Payment accepted";
        $transApproved="True";
        break;
    case "-1":
        $status_desc = "Transaction timeout or invalid parameters or unsuccessful transaction in the case of Query History";
        break;
    case "1":
        $status_desc = "Destination Card Not Found";
        break;
    case "2":
        $status_desc = "Card Number Not Found";
        break;
    case "3":
        $status_desc = "Invalid Card PIN";
        break;
    case "4":
        $status_desc = "Card Expiration Incorrect";
        break;
    case "5":
        $status_desc = "Insufficient balance";
        break;
    case "6":
        $status_desc = "Spending Limit Exceeded";
        break;
    case "7":
        $status_desc = "Internal System Error Occurred, please contact the service provider";
        break;
    case "8":
        $status_desc = "Financial Institution cannot authorize transaction, Please try later";
        break;
    case "9":
        $status_desc = "PIN tries Exceeded";
        break;
    case "10":
        $status_desc = "Card has been locked";
        break;
    case "11":
        $status_desc = "Invalid Terminal Id";
        break;
    case "12":
        $status_desc = "Payment Timeout";
        break;
    case "13":
        $status_desc = "Destination card has been locked";
        break;
    case "14":
        $status_desc = "Card has expired";
        break;
    case "15":
        $status_desc = "PIN change required";
        break;
    case "16":
        $status_desc = "Invalid Amount";
        break;
    case "17":
        $status_desc = "Card has been disabled";
        break;
    case "18":
        $status_desc = "Unable to credit this account immediately, credit will be done later";
        break;
    case "19":
        $status_desc = "Transaction not permitted on terminal";
        break;
    case "20":
        $status_desc = "Exceeds withdrawal frequency";
        break;
    case "21":
        $status_desc = "Destination Card has expired";
        break;
    case "22":
        $status_desc = "Destination Card Disabled";
        break;
    case "23":
        $status_desc = "Source Card Disabled";
        break;
    case "24":
        $status_desc = "Invalid Bank Account";
        break;
    case "25":
        $status_desc = "Insufficient Balance";
        break;
    case "26":
        $status_desc = "CHECKSUM/FINAL_CHECKSUM error";
        break;
    default:
        $status_desc = "Your Transaction was not Successful. No amount was debited from your account.";
        break;
}
if ($response_code==0) {
    $transApproved = "True";
}else{
    $transApproved="False";

}
$trans_num=$card;
//echo "Paymet Type :".$paymentType;
//echo "Tras Code: ".$response_code;
//if (($paymentType == '01BNKITSchool Fees') and ($response_code == 0)) {
//    echo "am here";
//}
//die($status_desc);
        require_once('../connect.php');
        $db=db_connect();
        require('../filetoU/logFile.php');
//        $orderID=$transid;
        $logD='Payment. OrderID: '.$orderID.' PaymentType: '.$reference;
        logDetail($matNo,$logD);
//         $ade="UPDATE `fedpoly`.`ace_remitaorder` SET `remitaRRR` = '$trans_num',`transDate` = '$transDate',`transStatus` = '$response_code',`transDetail` = '$status_desc',`transApproved` ='$transApproved' WHERE `ace_remitaorder`.`orderID` ='$orderID'";
        $db->query($ade);
//die();

        //=====================Acceptance fees ======================================
//        if (($paymentType == 'Acceptance Fee') and ($response_code == 0)) {
//            echo '<a href="print/acceptancePrint.php" target="_blank">Click Here to Print Acceptance Receipt</a>';
//            echo '<br><a href="print/admissionLetter.php" target="_blank">Print Admission Letter</a>';
//
//            $k = $db->query("select * from ace_remitaorder where regNo='$matNo'and paymentType='Acceptance Fee' and transApproved='True'")->rowCount();
//            if ($k > 0) {
//                $cardGet1 = $db->query("select * from stddata where formNo='$matNo' or jambNo='$matNo'");
//                $cardGet1_fetch = $cardGet1->fetch(PDO::FETCH_BOTH);
//                $cardGet1_num = $cardGet1->rowCount();
//                if ($cardGet1->rowCount() > 0) {
//                    $admittedGet = $db->query("select * from ace_admitted where formNo='$matNo'");
//                    $admittedGet_fetch = $admittedGet->fetch(PDO::FETCH_BOTH);
//                    if ($admittedGet->rowCount() > 0) {
//                        echo $cardGet1_fetch['formNo'] . '==>';
//                        echo $names = $cardGet1_fetch['surname'] . ' ' . $cardGet1_fetch['otherNames'];
//                        $names = str_replace("'", "''", $names);
//                        $course = $admittedGet_fetch['course'];
//                        $levelID = $admittedGet_fetch['levelID'];
//                        $address = $cardGet1_fetch['address'];
//                        $address = str_replace("'", "''", $address);
//                        $state = $cardGet1_fetch['state'];
//                        $lga = $cardGet1_fetch['lga'];
//                        $email = $cardGet1_fetch['email'];
//                        $gsm = $cardGet1_fetch['gsm'];
//                        $ausername = $admittedGet_fetch['formNo'];
//                        $apassword = $admittedGet_fetch['formNo'];
//                        $mode = $admittedGet_fetch['mode'];
//                        $dob = $cardGet1_fetch['dob'];
//                        $sex = $cardGet1_fetch['sex'];
//
////                        $hh = $db->query("INSERT INTO `fedpoly`.`ace_realdata` (`sn`, `formNo`, `matNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `dob`, `gsm`, `sex`, `address`, `email`, `usernamea`, `passworda`, `fresher`) VALUES (NULL, '$matNo', '$matNo', '$names', '$course', '$levelID', '$mode', '$state', '$lga', '$dob', '$gsm', '$sex', '$address', '$email', '$matNo', '$matNo', '4')");
//                    }
//                }
//            }
//        }
        //=======================End Acceptance =====================================

        if (($paymentType == '01BNKITSchool Fees') and ($response_code == 0)) {
//            echo '<a href="print/schoolFeePrint.php"  target="_blank">Click to Print School Receipt</a>';
//
//            echo '<br><a href="admin.php" target="_blank">Continue Registration</a>';
//
//                if ($response_code==0){
//            echo '<a href="print/schoolFeePrint.php" target="_blank">Click to Print School Receipt</a>';

//            echo '<br><a href="admin.php" target="_blank">Continue Registration</a>';

            //===============================================*****************************
            $mSQL = "select * from ossce_realdata where formNo='$matNo' and matNo='$matNo' and fresher=5";
            $mResult = $db->query($mSQL);
              $mNum = $mResult->rowCount();
            $mResult_fetch=$mResult->fetch(PDO::FETCH_BOTH);

            if ($mNum > 0) {
                $matNoOld = $_SESSION['formNo'];
                //generate prefix and sufix
               echo $deptID = $mResult_fetch['course'];
                echo $levelID = $mResult_fetch['levelID'];

                //	echo $_SESSION['course'] ;
                $prefixQ = $db->query("select * from dept where dOption='$deptID'");
                $prefixQ_fetch = $prefixQ->fetch(PDO::FETCH_BOTH);
//                echo "select * from dept where dOption='$dept'";
                $numPrefix = $prefixQ->rowCount();
                $courseName = $prefixQ_fetch['dOption'];
                if ($numPrefix > 0) {
                    if ($levelID == '1') {
                        $prefix = $prefixQ_fetch['nd'];
                        $sufix = '';
                        $levelCode = '01';
                    } elseif ($levelID == '3') {
                        $prefix = $prefixQ_fetch['hnd'];
                        $sufix = '';
                        $levelCode = '01';
                    } elseif ($levelID == '5') {
                        $prefix = $prefixQ_fetch['nd'];
                        $sufix = 'PT';
                        $levelCode = '03';
                    } elseif ($levelID == '8') {
                        $prefix = $prefixQ_fetch['nd'];
                        $sufix = 'DPT';
                        $levelCode = '02';
                    } elseif ($levelID == '10') {
                        $prefix = $prefixQ_fetch['nd'];
                        $sufix = '';
                        $levelCode = '01';
                    } elseif ($levelID == '11') {
                        $prefix = $prefixQ_fetch['hnd'];
                        $sufix = '';
                        $levelCode = '02';
                    }
                }
//                echo $prefix;
//                die($prefix);
                $levelCode='04';
                //End of prefix and sufix
                //generate serial Number
                // echo $courseName;
                //$matSQL="select * from realdata where fresher='20' and course='$courseName' and levelID='$levelID' ";
                $matSQL = "select * from ossce_realdata where fresher='50' ";
                $matResult = $db->query($matSQL);
                echo $matNum = $matResult->rowCount();
                if ($matNum > 0) {
                    $realNo = $matNum + 1;
                    if ($realNo < 10) {
                        $serialNo = '2019' . $levelCode . '0000' . $realNo;
                    } elseif ($realNo < 100) {
                        $serialNo = '2019' . $levelCode . '000' . $realNo;
                    } elseif ($realNo < 1000) {
                        $serialNo = '2019' . $levelCode . '00' . $realNo;
                    } elseif ($realNo < 10000) {
                        $serialNo = '2019' . $levelCode . '0' . $realNo;
                    } else {
                        $serialNo = '2019' . $levelCode . $realNo;
                    }
                } else {
                    $serialNo = '2019' . $levelCode . '00001';
                }
                 $newMatNo = $prefix . $serialNo;
//                die($newMatNo);
                $real="UPDATE `fedpoly`.`ossce_realdata` SET `matNo` = '$newMatNo',`usernamea` = '$newMatNo',`passworda` = '$newMatNo',`fresher` = '50' WHERE `ossce_realdata`.`formNo` ='$matNo'";
                $db->query($real);
                 $real2="UPDATE `fedpoly`.`ossce_remitaorder` SET `regNo` = '$newMatNo' WHERE `ossce_remitaorder`.`orderID` ='$orderID'";
                $db->query($real2);

                 $_SESSION['matNo'] = $newMatNo;

//                copy('../passportForm/' . $matNo . '.jpg', 'passport/Reg' . $newMatNo . '.jpg');
                echo '<font color="#FF0000"><h2><br> Note: Your Username and Password is now ' . $newMatNo . '</h2></font>';
            }
        }
//die();
header('location:'.'ossce_matNoGeneration.php');
        //

        //===============================================*****************************
?>
<!--<!--<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">-->-->
<!--<!---->-->
<!--<!--<html xmlns="http://www.w3.org/1999/xhtml">-->-->
<!--<!--<head runat="server">-->-->
<!--<!--    <title>Response page</title>-->-->
<!--<!--</head>-->-->
<!--<!--<body>-->-->
<!--<!--<table>-->-->
<!--<!--<td >-->-->
<!--<!--Successful response:</td>-->-->
<!--<!--<td>-->--><?php ////echo $_POST['SUCCESS'];?><!--<!--</td>-->-->
<!--<!--</table>-->-->
<!---->
<!--</body>-->
<!--</html>-->