<?php
ob_start();
		require_once('connect.php');
$db=db_connect();
$daValue=0;
//session_start();
//$matNo=$_SESSION['idNo'];
require 'remita_constants.php';
/*$orderID = "";
if( isset( $_GET['id'] )) {
 $orderID = $_GET['id'];
 $ptype=$_GET['ptype'];
}

*/
// $aspoa="select * from remitaorder where transApproved='False' and req=0 and regNo<>'e' and length(orderID)>10 order by sn desc limit 0,100";
$aspoa="SELECT * FROM `remitaorder` where paymentType='School Fees' and req=0  and transApproved='False' and pay_session='2021/2022' and (regNo like '%2021%' or regNo like '%2021%' or regNo like '%2021%') and regNo not in (SELECT regNo FROM `remitaorder` where paymentType='School Fees' and transApproved='True' and pay_session='2021/2022')";
$queryResult=$db->query($aspoa);
  $queryNum=$queryResult->rowCount();
$i=0;
//while ($i< $queryNum){
    while ($row=$queryResult->fetch(PDO::FETCH_BOTH)){
//        die("am here");
	$orderId=$row['orderID'];
	$response_code ="";
	$rrr = "";
	$response_message = "";
	if($orderId !=null){

		 $response = remita_transaction_details($orderId);
		  echo $response_code = $response['status'];
//        echo "am here";
		 if (isset($response['RRR'])){
			echo $rrr = $response['RRR'];
		 }
		echo $response_message = $response['message'];
		 $transactiontime= $response['transactiontime'];
		 $RRR= $response['RRR'];
		echo  $status= $response['status'];
		 $message= $response['message'];
        if (($status=='00') or ($status=='01')){
            $transA='True';
            $daValue+=1;
            echo $orderId;

        }else{
            $transA='False';
        }
     //  $k= $db->query("UPDATE `fedpoly`.`remitaorderform` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA',`clientProxy ` = 'manualQ' WHERE `remitaorderform`.`orderID` ='$orderId'");
        echo $aspoa1="UPDATE `fedpoly`.`remitaorder` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA',`req`=1  WHERE `remitaorder`.`orderID` ='$orderId'";
        $k= $db->query($aspoa1);
        if (($k) and ($transA=='True')){
    echo $RRR.'---'.$orderId.'<br>';
}else{
   // echo 'No';
}
	}
        echo '<br>';
	++$i;
}

if ($daValue>0) {
    echo $daValue . ' Record Updated ';
}
//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;
}

ob_end_flush();
?>