<?php

//require 'remita_constants2.php';
require_once('https://www.federalpolyede.edu.ng/ace_admin_student/eTranConstant.php');
$orderID = "";

if( isset( $_GET['id'] )) {
    $orderID = $_GET['id'];
    $ptype=$_GET['ptype'];
    $formNo= $matNo=$_SESSION['formNo']=$_GET['formNo'];
}
//die($orderID.$ptype.$formNo);
$response_code ="";
$rrr = "";
$response_message = "";

//Verify Transaction
function remita_transaction_details($orderId){
    $mert =  MERCHANTID;
    $api_key =  APIKEY;
    $concatString = $orderId . $api_key . $mert;
    $hash = hash('sha512', $concatString);
    $url 	= trim(CHECKSTATUSURL . '/' . $mert  . '/' . $orderId . '/' . $hash . '/' . 'orderstatus.reg');
    //  Initiate curl

    $ch = curl_init();
    // Disable SSL verification
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    // Will return the response, if false it print the response
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    // Set the url
    curl_setopt($ch, CURLOPT_URL,$url);
    // Execute
    $result=curl_exec($ch);
    // Closing
    curl_close($ch);
    $result;
    $response = json_decode($result, true);
    return $response;
}

if($orderID !=null){

    $response = remita_transaction_details($orderID);
    $response_code = $response['status'];
    if (isset($response['RRR']))
    {
        $rrr = $response['RRR'];
    }
    $response_message = $response['message'];


    $transactiontime= $response['transactiontime'];
    $RRR= $response['RRR'];
    $status= $response['status'];
    $message= $response['message'];
//echo $response['Approved'];

    if (($status=='00') or ($status=='01')){
        $transA='True';
    }else{
        $transA='False';
    }

    require_once('../connect.php');
    $db=db_connect();
    require('../filetoU/logFile.php');
    $logD='Requerying.  OrderID: '.$orderID.' RRR: '.$RRR;
    logDetail($matNo,$logD);

    $db->query("UPDATE `fedpoly`.`remitaorder` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA' WHERE `remitaorder`.`orderID` ='$orderID'");


//----------------------------------------------------------------------
    if ($ptype=='Acceptance Fee'){
        $k=$db->query("select * from remitaorder where regNo='$matNo'and paymentType='Acceptance Fee' and transApproved='True'")->rowCount();
        if ($k>0){
            $cardGet=$db->query("select * from admitted where formNo='$matNo'");
            $numGet=$cardGet->rowCount();
            $cardGet_fetch=$cardGet->fetch(PDO::FETCH_BOTH);

            if ($numGet>0){
                $names=$cardGet_fetch['names'];
                $names=str_replace("'","''",$names);
                $course=$cardGet_fetch['course'];
                $levelID=$cardGet_fetch['levelID'];
                $address=$cardGet_fetch['address'];
                $state=$cardGet_fetch['state'];
                $lga=$cardGet_fetch['lga'];
                $email=$cardGet_fetch['email'];
                $gsm=$cardGet_fetch['gsm'];
                $ausername=$cardGet_fetch['formNo'];
                $apassword=$cardGet_fetch['formNo'];
                $mode=$cardGet_fetch['mode'];
                $dob=$cardGet_fetch['dob'];
                $sex=$cardGet_fetch['sex'];

                $db->query("INSERT INTO `fedpoly`.`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')");
            }
        }
    }else{

        //repeater

        $pValue=$db->query("select * from remitaorder where regNo='$matNo' and transApproved='True' and paymenttype='School Fees'")->rowCount();
//	if (($transApproved=='True') and ($ptype=='School Fees')){
        if ($pValue>0){
            /*
                            if (isset($_SESSION['repeater'])){
                                if ($db->query("select * from realdata where matNo='$matNo' and status='Repeater'")->rowCount()!=1){

                                    if ($_SESSION['repeater']=='Repeater'){
                                        $levelID=$levelID-1;
                                        $db->query("update realdata set levelID='$levelID',status='Repeater' where matNo='$matNo'");
                                    }
                                }
                            }
            */
            //Generate Matric Number-

            //$arrayN=array(54=>'MB201500054',253=>'AH201500253',97=>'ST201500097PT',92=>'201500092',99=>'PM201500099', 101=>'CS201500101',115='201500115');
//echo $matNo;

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


            if ($mNum>0){
                $matNoOld=$_SESSION['formNo'];
                $dept=$mResult_fetch['course'];
                //generate prefix and sufix
                // $deptID=$_SESSION['deptID'] ;
                $levelID=$mResult_fetch['levelID'] ;
                //	echo $_SESSION['course'] ;
                $prefixQ=$db->query("select * from dept where dOption='$dept'");
                $prefixQ_fetch=$prefixQ->fetch(PDO::FETCH_BOTH);
                 $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'){
                        echo $prefix=$prefixQ_fetch['nd'];
                        $sufix='';
                        $levelCode='01';
                    }elseif($levelID=='11'){
                        $prefix=$prefixQ_fetch['hnd'];
                        $sufix='';
                        $levelCode='02';
                    }
                }
                //End of prefix and sufix
                //generate serial Number
                // echo $courseName;
//                echo $levelID;
//
//                echo $courseName;
//                echo $formNo;

                //$matSQL="select * from realdata where fresher='20' and course='$courseName' and levelID='$levelID' ";
                $matSQL="select * from realdata where fresher='40' ";
                $matResult=$db->query($matSQL);
                 $matNum=$matResult->rowCount();
//                die();
                if ($matNum>0) {
                    $realNo = $matNum + 1;
                    if ($realNo < 10) {
                        $serialNo = '2018'.$levelCode.'0000' . $realNo;
                    } elseif ($realNo < 100) {
                        $serialNo = '2018'.$levelCode.'000' . $realNo;
                    } elseif ($realNo < 1000) {
                        $serialNo = '2018'.$levelCode.'00' . $realNo;
                    } elseif ($realNo < 10000) {
                        $serialNo = '2018'.$levelCode.'0' . $realNo;
                    } else {
                        $serialNo = '2018'.$levelCode . $realNo;
                    }
                }else{
                    $serialNo = '2018'.$levelCode.'00001';
                }
                 $newMatNo=$prefix.$serialNo;
//                die();
                $db->query("UPDATE `fedpoly`.`realdata` SET `matNo` = '$newMatNo',`usernamea` = '$newMatNo',`passworda` = '$newMatNo',`fresher` = '40' WHERE `realdata`.`formNo` ='$matNo'");
                $db->query("UPDATE `fedpoly`.`remitaorder` SET `regNo` = '$newMatNo' WHERE `remitaorder`.`orderID` ='$orderID'");

                $_SESSION['matNo']=$newMatNo;
                //=====picture handling
                // rename('image1.jpg', 'del/image1.jpg');
                // rename($matNoOld.'.jpg','../passport/Reg'.$newMatNo.'.jpg');


                /*      $src = opendir('../passportForm/');
                      $dest = opendir('../passport/');
                      $readFile=$matNoOld.'.jpg';
                      $readFile2=$newMatNo.'.jpg';
                      while($readFile = readdir($src)){
                          if($readFile != '.' && $readFile != '..'){
                              if(!file_exists($readFile)){
                                  if(copy($src.$readFile, $dest.$readFile2)){
                                      echo "Copy file";
                                  }else{
                                      echo "Canot Copy file";
                                  }
                              }
                          }
                      }*/
                //=============End of picture handling
                // echo '<font color="#FF0000"><h2><br> Note: Your Username and Password is now '.$newMatNo.'</h2></font>';
            }
        }
//



        header('location:'.'matNoGeneration.php');
    }
}
ob_end_flush();
?>