<?php
ob_start();

include('headMain2.php');
extract($_POST);

//if (($amt==0) or ($amtc==0)){

//}
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:31 PM
 */
//session_start();


//echo $amt.'<br>';
//echo $amtc.'<br>';

require('../connect.php');
$db=db_connect();



$sql_current=$db->query("select * from current where sn=2");
$num_current=$sql_current->rowCount();
$row_current=$sql_current->fetch(PDO::FETCH_BOTH);

if ($num_current>0){
    $semester=$_SESSION['asemester']=$row_current['asemester'];
    $asession=$_SESSION['asession']=$row_current['asession'];
}

$_SESSION['payerName']=$payerName;
$_SESSION['payerID']=$_SESSION['idNo']=$regNo=$idNo;
$_SESSION['payerEmail']=$payerEmail;
$_SESSION['payerPhone']=$payerPhone;
 $_SESSION['amount']=$amt;
// $_SESSION['charges']=$amtc=212.5;
 $_SESSION['charges']=$amtc=0;
  $_SESSION['totalAmount']=$amt+$amtc;
$_SESSION['totalAmountReal']=$amt;
//echo $asession=$_SESSION['asession'];
//die();
//echo $paymentType=$ptypek;
$ptype1=explode(',',$_POST['ptype']);
  $paymentType=$_SESSION['paymentTYPE']=$ptype1[0];

$aspoa=0;

//  $specialAspoa="select * from paymentspecial where paymentName='$paymentType' and typeCost<>0";
$specialAspoa="select * from paymentspecial where paymentName='$paymentType'";

$specialAspoaQuery=$db->query($specialAspoa);
if ($specialAspoaQuery->rowCount()==1){
    $specialAspoa_fetch=$specialAspoaQuery->fetch(PDO::FETCH_BOTH);
    $_SESSION['amount']=$specialAspoa_fetch['typeCost'];
     $_SESSION['charges']=$specialAspoa_fetch['typecharges']=$amtc;
      $_SESSION['totalAmount']=$specialAspoa_fetch['totalAmount']+$amtc;
//    die();
    if ($amt<>$_SESSION['amount']){
        $aspoa=1;
    }
}

//die($amt.'_'.$_SESSION['amount']);
//echo $amt.'<br>';
//echo $specialAspoaQuery.'<br>';
// echo $_SESSION['ptype'].'<br>';
//echo $_SESSION['amount'].'<br>';
//echo $_SESSION['charges'].'<br>';
//echo $_SESSION['totalAmount'].'<br>';
////die();

?>
<br>

<div class="col-lg-8 col-lg-offset-2">
<div class="form-group">
    <label class="col-sm-4 control-label">Payer Name</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['payerName']  ;?>"  name="name" >
    </div>
</div>
<div class="form-group">
    <label class="col-sm-4 control-label">Payer Email</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['payerEmail'];?>" name="email" >
    </div>
</div>
<div class="form-group">
    <label class="col-sm-4 control-label">Payer Phone</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['payerPhone'] ;?>" name="phone" >
    </div>
</div>
<div class="form-group" style="display: none">
    <label class="col-sm-4 control-label">Amount</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['amount'] ;?>" name="f_amount" disabled="disabled">
    </div>
</div>
<div class="form-group" style="display">
    <label class="col-sm-4 control-label">Portal Charges</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['charges']  ;?>" name="f_charges" disabled="disabled">
    </div>
</div>
<div class="form-group">
    <label class="col-sm-4 control-label">Total Amount</label>
    <div class="col-sm-8">
        <input type="text" class="form-control" value="<?php echo $_SESSION['totalAmountReal']  ;?>" name="amount" disabled="disabled">
    </div>
</div>
<?php
include 'remita_constants2.php';
//require 'remita_constants2_Demo.php';
  $totalAmount = $_SESSION['totalAmount'];
//echo $paymentType;
//die();
if (( $paymentType=="Transcript Request") or ( $paymentType=="Transcript (Student Copy)") or ( $paymentType=="Additional Reprint Transcript")  or ( $paymentType=="Additional Transcript Payment") ){
    $servicetypeId = SERVICETYPEID_TRA;
}elseif( $paymentType=="Development") {
    $servicetypeId = SERVICETYPEID_DEV;
//    $servicetypeId = SERVICETYPEID_TRA;
}elseif( $paymentType=="Certificate Levy") {
    $servicetypeId = SERVICETYPEID_CER;
}elseif( $paymentType=="Accommodation Levy") {
    $servicetypeId = SERVICETYPEID_ACC;
}elseif( $paymentType=="Student Association/Club Reg.") {
    $servicetypeId = SERVICETYPEID_STU;
}elseif( $paymentType=="JAMB Regularization") {
    $servicetypeId = SERVICETYPEID_JAM;
}elseif( $paymentType=="Additional JAMB Regularization") {
    $servicetypeId = SERVICETYPEID_JAM;
}elseif( $paymentType=="Refund of Turning Advance") {
    $servicetypeId = SERVICETYPEID_REF;
}elseif( $paymentType=="Change of Course Fee") {
    $servicetypeId = SERVICETYPEID_COC;
}elseif( $paymentType=="Late Registration Penalty Charges") {
    $servicetypeId = SERVICETYPEID_LRF;
}elseif( $paymentType=="Verification of result") {
    $servicetypeId = SERVICETYPEID_VER;
}elseif( $paymentType=="Registration of Contractors") {
    $servicetypeId = SERVICETYPEID_ACC;
    //Created on = 01/03/2016-4:48pm
}elseif( $paymentType=="Lost of School Receipt") {
    $servicetypeId = SERVICETYPEID_OTH;
}elseif($paymentType=="Other Payments.") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_OTH;
}elseif($paymentType=="Refund of Cash Advance") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_RCA;
    //Created on = 01/03/2016-4:48pm
}elseif($paymentType=="Tender Fee") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_TEN;
    //Created on = 01/03/2016-4:48pm
}elseif($paymentType=="Reactivation of Studentship") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_OTH;
}elseif($paymentType=="Late File Submission Penalty_1") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_OTH;
}elseif($paymentType=="Late File Submission Penalty_2") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_OTH;
}elseif($paymentType=="Reparation Fee") {
//    $servicetypeId = SERVICETYPEID_COC;
    $servicetypeId = SERVICETYPEID_OTH;
}else {
//    $servicetypeId = SERVICETYPEID_OTH;
    die("No Payment Description".$paymentType);
}
//echo $servicetypeId;
//die();
//die($servicetypeId);
//echo $_SESSION['charges'];
//die();
$id=substr($payerPhone,8);
//$id=1;
$timesammp=DATE("dmyHis");
if ($id<10){
    $id='0000'.$id;
}else if($id<100){
    $id='000'.$id;
}else if($id<1000){
    $id='00'.$id;
}else if($id<10000){
    $id='0'.$id;
}else{
    $id=$id;
}

 $orderID=mt_rand(10000, 99999).$id.'0';
//die($orderID);
$payerName = $_POST["payerName"];
$payerEmail = $_POST["payerEmail"];
$payerPhone = $_POST["payerPhone"];
$responseurl = PATH . "/new-receipt-otherPayment.php";
//$hash_string = MERCHANTID . $servicetypeId . $orderID . $totalAmount . $responseurl . APIKEY;
//$totalAmount=7000;
  $hash_string = MERCHANTID . $servicetypeId . $orderID . $totalAmount . $responseurl . APIKEY;
//die();
$hash = hash('sha512', $hash_string);
$itemtimestamp = $timesammp;
$itemid1="itemid1";
$itemid2="34444".$itemtimestamp;
$itemid3="8694".$itemtimestamp;

$beneficiaryName="Federal Polytechnic Ede";
$beneficiaryAccount="0280451361018";

//$beneficiaryName2="OMEGA PLUS SOLUTIONS LIMITED";
//$beneficiaryAccount2="3041858843";
//$beneficiaryAccount2="2027092585";

$beneficiaryName2="ICT SERVICES STAFF WELFARE FEDERAL POLYTECHNIC EDE";
$beneficiaryAccount2="1140137729";
$bankCode2="076";

//$beneficiaryName2="Cyberline Computer Technology";
//$beneficiaryAccount2="0122927328";

//$beneficiaryAccount3="4017904612";
$bankCode="000";
$bankCode2="035";
 $beneficiaryAmount =$_SESSION['amount'];
 $beneficiaryAmount2 =$_SESSION['charges'];
//$beneficiaryAmount3 ="0";
$deductFeeFrom=1;
$deductFeeFrom2=0;
//die();
/*
$beneficiaryName="Oshadami Mke";
$beneficiaryName2="Mujib Ishola";
$beneficiaryName3="Ogunseye Olarewanju";
$beneficiaryAccount="6020067886";
$beneficiaryAccount2="0360883515";
$beneficiaryAccount3="4017904612";
$bankCode="011";
$bankCode2="050";
$bankCode3="070";
//$bankCode3="070";
$beneficiaryAmount =$_SESSION['amount'];
$beneficiaryAmount2 =$_SESSION['charges'];
//$beneficiaryAmount3 ="0";
$deductFeeFrom=1;
$deductFeeFrom2=0;

//$deductFeeFrom3=0;
*/
//The JSON data.

//echo $paymentType;
//echo $ptype;
//echo $servicetypeId;
//
//die();
   $content = '{"merchantId":"'. MERCHANTID
.'"'.',"serviceTypeId":"'.$servicetypeId
.'"'.",".'"totalAmount":"'.$totalAmount
.'","hash":"'. $hash
.'"'.',"orderId":"'.$orderID
.'"'.",".'"responseurl":"'.$responseurl
.'","payerName":"'. $payerName
.'"'.',"payerEmail":"'.$payerEmail
.'"'.",".'"payerPhone":"'.$payerPhone
.'","lineItems":[
{"lineItemsId":"'.$itemid1.'","beneficiaryName":"'.$beneficiaryName.'","beneficiaryAccount":"'.$beneficiaryAccount.'","bankCode":"'.$bankCode.'","beneficiaryAmount":"'.$beneficiaryAmount.'","deductFeeFrom":"'.$deductFeeFrom.'"},
{"lineItemsId":"'.$itemid2.'","beneficiaryName":"'.$beneficiaryName2.'","beneficiaryAccount":"'.$beneficiaryAccount2.'","bankCode":"'.$bankCode2.'","beneficiaryAmount":"'.$beneficiaryAmount2.'","deductFeeFrom":"'.$deductFeeFrom2.'"}
]}';
//die();
$curl = curl_init(GATEWAYURL);
curl_setopt($curl, CURLOPT_HEADER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_HTTPHEADER,
array("Content-type: application/json"));
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, $content);

/*$json_response = curl_exec($curl);
$status = curl_getinfo($curl, CURLINFO_HTTP_CODE);
curl_close($curl);
echo $jsonData = substr($json_response, 6, -1);
 $response = json_decode($jsonData, true);
 $statuscode = $response['statuscode'];
 $statusMsg = $response['status'];
//echo "am here";

if($statuscode=='025'){
$rrr = trim($response['RRR']);
$new_hash_string = MERCHANTID . $rrr . APIKEY;
$new_hash = hash('sha512', $new_hash_string);
*/
//echo $response['amtPaid'];
//die();
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
$json_response = curl_exec($curl);
$status = curl_getinfo($curl, CURLINFO_HTTP_CODE);
curl_close($curl);
//echo $json_response;
 $jsonData = substr($json_response, 6, -1);
 $response = json_decode($jsonData, true);
//echo var_dump($response);
$statuscode = $response['statuscode'];
$statusMsg = $response['status'];

//die($aspoa);
if(($statuscode=='025')and  ($aspoa==0)){
    $rrr = trim($response['RRR']);
    $new_hash_string = MERCHANTID . $rrr . APIKEY;
    $new_hash = hash('sha512', $new_hash_string);

echo '<html>
<head>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/bootstrap-dark.min.css">
</head>
<style type="text/css">
        body {
            background-color: #CFD1DE;
            background-image: url(../images/logo2fade.png);
        }
    </style>
<body>


<form action="'.GATEWAYRRRPAYMENTURL.'" method="POST">
<input id="merchantId" name="merchantId" value="'.MERCHANTID.'" type="hidden"/>
<input id="rrr" name="rrr" value="'.$rrr.'" type="hidden"/>
<input id="responseurl" name="responseurl" value="'.$responseurl.'" type="hidden"/>
<input id="hash" name="hash" value="'.$new_hash.'" type="hidden"/>
<div class="form-group">
	<label class="col-sm-4 control-label">Payment Type</label>
	<div class="col-sm-8">

		<select name="paymenttype" class="form-control">
			<option value=""> -- Select --</option>
			<option value="REMITA_PAY"> Remita Account Transfer</option>
			<option value="Interswitch"> Verve Card</option>
			<option value="UPL"> Visa</option>
			<option value="UPL"> MasterCard</option>
			<option value="PocketMoni"> PocketMoni</option>
			<option value="RRRGEN"> POS</option>
			<option value="ATM"> ATM</option>
			<option value="BANK_BRANCH">BANK BRANCH</option>
			<option value="BANK_INTERNET">BANK INTERNET</option>
		</select>
	</div>
</div>

 <div class="form-group">
	<div class="col-sm-8 col-sm-offset-4">
		<input type="submit" class="btn btn-sm btn-primary" name="submit" value="Submit" />
	</div>
</div>
	</form>


</div>

</body>
</html>';
    //echo "Here _o";

//    echo "Here";
//require('../filetoU/logFile.php');
//$logD='OrderID: '.$orderID.' PaymentType: '.$paymentType;
//logDetail($idNo,$logD);
$ip2=$_SERVER['HTTP_X_FORWARDED_FOR'];
$ip1=$_SERVER['REMOTE_ADDR'];
//    $amount=$amount-100;
//    echo "INSERT INTO `fedpoly`.`remitaorder` (`sn`, `orderID`, `remitaRRR`, `transDate`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`descr`,`pay_session`) VALUES  (NULL, '$orderID', '0', '0', '-1', '$regNo', 'Not Yet Approved', '$amt', '$paymentType', 'False','$ip1','$ip2','$pdis','$asession')";
//    die();
   $r= "INSERT INTO `fedpoly`.`remitaorder` (`sn`, `orderID`, `remitaRRR`,  `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`descr`,`pay_session`) VALUES  (NULL, '$orderID', '0',  '-1', '$regNo', 'Not Yet Approved', '$amt', '$paymentType', 'False','$ip1','$ip2','$pdis','$asession')";
//die();
    $db->query($r);
     $aspoa="INSERT INTO `fedpoly`.`remitaorder_2` (`sn`, `orderID`, `remitaRRR`,  `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`descr`,`pay_session`) VALUES  (NULL, '$orderID', '0',  '-1', '$regNo', 'Not Yet Approved', '$amtc', '$paymentType', 'False','$ip1','$ip2','$pdis','$asession')";
    $db->query($aspoa);
//    die();
   // $db->query("INSERT INTO `fedpoly`.`remitaorder` (`sn`, `orderID`, `remitaRRR`, `transDate`, `dateCreated`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`, `bankCode`, `channnel`, `branchCode`, `datesent`, `daterequested`, `clientIP`, `clientProxy`, `descr`, `status`, `pay_session`) VALUES (NULL, '$orderID', '0', '0', CURRENT_TIMESTAMP, '-1', '$formNo', 'Not Yet Approved', '7', '8', '9', '0', '1', '2', '1', '2', '3', '4', '5', '6', '5')");

  //  echo "INSERT INTO `fedpoly`.`remitaorder` (`sn`, `orderID`, `remitaRRR`, `transDate`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`pay_session`) VALUES (NULL, '$orderID', '0', '0', '-1', '$formNo', 'Not Yet Approved', '$amount', '$paymentType', 'False','$ip1','$ip2','2017/2018')";


//    $db->query("UPDATE `fedpoly`.`admitted` SET `email` = '$payerEmail',`gsm` = '$payerPhone',`acceptance`=1 WHERE `admitted`.`formNo` = '$formNo'");

  //  echo "Here";
//    ================ other payment table===================

    $sql="select * from otherpayment where idNo='$regNo'";
    $result=$db->query($sql);
    $num=$result->rowCount();
    if ($num>0){
//    die("here");
//    $dd="UPDATE `fedpoly`.`otherpayment` SET `names` = '$payerName',`email` = '$payerEmail',`phone` = '$payerPhone',`descr` = '$desc',`orderID` = '$orderID' WHERE `otherpayment`.`idNo` ='$idNo' and (`names`='' OR `names`='.')"
//	$db->query($dd);
        $princess=$db->prepare("UPDATE `fedpoly`.`otherpayment` SET `names` = ?,`email` = ?,`phone` = ?,`descr` = ?,`orderID` = ? WHERE `otherpayment`.`idNo` =? and (`names`='' OR `names`='.')");
        $princess->execute([$payerName,$payerEmail,$payerPhone,$pdis,$orderID,$regNo]);
    }else{
        $payerName=str_replace("'","''",$payerName);
        $desc=$pdis;
//        echo "INSERT INTO `fedpoly`.`otherpayment` (`sn`, `idNo`, `names`, `email`, `phone`,`ptype`,`descr`,`orderID`) VALUES (NULL, '$regNo', '$payerName', '$payerEmail', '$payerPhone','$desc','$desc','$orderID')";
//        die();
        $db->query("INSERT INTO `fedpoly`.`otherpayment` (`sn`, `idNo`, `names`, `email`, `phone`,`ptype`,`descr`,`orderID`) VALUES (NULL, '$regNo', '$payerName', '$payerEmail', '$payerPhone','$desc','$desc','$orderID')");
    }
//    ===================end of other payment================================================================


}else{
//    require('../connect.php');
//$db=db_connect();
//        $db->query("INSERT INTO `fedpoly`.`remitaorder` (`sn`, `orderID`, `remitaRRR`, `transDate`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`pay_session`) VALUES  (NULL, '$orderID', '0', '0', '-1', '$formNo', 'Not Yet Approved', '$amount', '$paymentType', 'False','$ip1','$ip2','2019/2020')");
//        echo $aspoa="INSERT INTO `fedpoly`.`remitaorder_2` (`sn`, `orderID`, `remitaRRR`, `transDate`, `transStatus`, `regNo`, `transDetail`, `amtPaid`, `paymentType`, `transApproved`,`clientIP`,`clientProxy`,`pay_session`) VALUES  (NULL, '$orderID', '0', '0', '-1', '$formNo', 'Not Yet Approved', '$amtc', '$paymentType', 'False','$ip1','$ip2','2019/2020')";
//        $db->query($aspoa);

        echo "Error Generating RRR - " .$statusMsg .'-'.$amt;
        echo $statuscode. '<h2>Kindly exercise patient or check your Network. Thanks</h2>';
//        echo $statusMsg;
}

?>
    </div>