<?php
ob_start();
ini_set('memory_limit','-1');
		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'];
}

*/
$aspAll=0;
$aspFalse=0;
$aspTrue=0;
// $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_2` where remitaRRR='' and req=0  order by sn desc limit 0,200";
$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);
		   $response_code = $response['status'];
//        echo "am here";
		 if (isset($response['RRR'])){
			 $rrr = $response['RRR'];
		 }
		 $response_message = $response['message'];
		 $transactiontime= $response['transactiontime'];
		 $RRR= $response['RRR'];
		  $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'");
         $aspoa1="UPDATE `fedpoly`.`remitaorder_2` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA',`req`=1  WHERE `remitaorder_2`.`orderID` ='$orderId'";
        $k= $db->query($aspoa1);
        $aspAll+=1;
        if (($k) and ($transA=='True')){
     $aspTrue+=1;
}else{
   // echo 'No';
            $aspFalse+=1;
}
	}
//        echo '<br>';
	++$i;
}

//if ($daValue>0) {
    echo $daValue . ' Record Updated <br>';
echo $aspFalse . ' False Updated <br>';
echo $aspTrue . ' True Updated <br>';
echo $aspAll . ' All Updated <br>';
//}
//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();
?>