<?php
session_start();
ob_start();
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:51 PM
 */
//echo $orderID;
include('headMain2.php');
require 'remita_constants.php';
$orderID = "";
if( isset( $_GET['id'] )) {
    $orderID = $_GET['id'];
    $ptype=$_GET['ptype'];
}
$response_code ="";
$rrr = "";
$response_message = "";

//echo $orderID;
//die();
		//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;
}

	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';
        }else{
            $transA='False';
        }
//        echo $transA;
//        echo $rrr;
//        die();
        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'");
//        echo "Update `fedpoly`.`remitaorder` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA' WHERE `remitaorder`.`orderID` ='$orderID'";
//die($orderID);
//        echo $transactiontime;
//        $transactiontime= DATE_FORMAT($transactiontime,'yy-m-d h:m:s');
//       echo $transactiontime=date_format($transactiontime,'YYYY-MM-DD HH:MI:SS');
         $transactiontime=substr($transactiontime,0,19);

//        SET_SESSION_SQL_MODE='ALLOW_INVALID_DATES';
//        echo "UPDATE `fedpoly`.`remitaorder` SET `remitaRRR` = '$RRR',`transDate` ='$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA' WHERE `remitaorder`.`orderID` ='$orderID'";
//        die();

        $princess= $db->prepare("UPDATE `fedpoly`.`remitaorder` SET `remitaRRR` = ?,`transDate` = ?,`transStatus` = ?,`transDetail` = ?,`transApproved` =? WHERE `remitaorder`.`orderID` =?");
        $princess->execute([$RRR,$transactiontime,$status,$message,$transA,$orderID]);

//        $db->query("UPDATE `fedpoly`.`remitaorder_2` SET `remitaRRR` = '$RRR',`transDate` = '$transactiontime',`transStatus` = '$status',`transDetail` = '$message',`transApproved` = '$transA' WHERE `remitaorder`.`orderID` ='$orderID'");
        $princess= $db->prepare("UPDATE `fedpoly`.`remitaorder_2` SET `remitaRRR` = ?,`transDate` = ?,`transStatus` = ?,`transDetail` = ?,`transApproved` =? WHERE `remitaorder_2`.`orderID` =?");
        $princess->execute([$RRR,$transactiontime,$status,$message,$transA,$orderID]);

        header('location:'.'paymentHistoryb.php');
    }

include('footMain.php');
ob_end_flush();
?>