<?php
ob_start();
		require_once('connect.php');
$db=db_connect();
$daValue=0;
//session_start();
//$matNo=$_SESSION['idNo'];
require 'remita_constants2.php';
/*$orderID = "";
if( isset( $_GET['id'] )) {
 $orderID = $_GET['id'];
 $ptype=$_GET['ptype'];
}
*/
echo "select * from remitaorder where transDate is Null and transApproved='True'";
$queryResult=$db->query("select * from remitaorder where  transApproved='True' and regNo in (select regNo from latepaid)");
 $queryNum=$queryResult->rowCount();
$i=0;
//while ($i< $queryNum){
    while ($row=$queryResult->fetch(PDO::FETCH_BOTH)){
	$orderId=$row['orderID'];
         $orderId.'<br>';
	$response_code ="";
	$rrr = "";
	$response_message = "";
	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'];
        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'");
        $k= $db->query("UPDATE `fedpoly`.`remitaorder` SET `transDate` = '$transactiontime' WHERE `remitaorder`.`orderID` ='$orderId'");
        if (($k) and ($transA=='True')){
    echo $RRR.'---'.$orderId.'<br>';
}else{
   // echo 'No';
}
	}
	++$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 	= 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();
?>