One Hat Cyber Team

View File Name : maintenanceByDayOld.php

<?php
ini_set('display_errors',1);
?>
<script language="javascript">
function checkform(form)

{

	if (document.form1.day.value == "") {

		alert( "Please Select Day" );

		document.form1.day.focus();

		return false ;

	}
	else if(document.form1.month.value == ""){
		alert("Please select Month");
		document.form1.month.focus();
		return false;
	}
	else if(document.form1.year.value == ""){
		alert("Please select Year");
		document.form1.year.focus();
		return false;
	}

}

</script>
<center>
<div style="padding:5px; border:1px solid; margin:0px auto;">Resolve Payment Issues</div>
<strong><h3>Instructions:</h3></strong>
<span><pre>Select a date to resolve transaction Issues</pre></span>
<span><pre>Click on Resolve Now to resolve Issues</pre></span>
<div style="margin:0px auto; width:400px;">
<form action="" method="post" name="form1" id="form1">
<fieldset style="width: 200px;">
<legend style="padding: 5px; border:1px solid;">Select Date</legend>
<table width="100%" >

<tr><td>Select Date</td><td>Day</td>
<td>
<select name="day" id="day">
<option value="">Select Day</option>
<?php for($d=1; $d<=31; $d++){
?>	
	<option value="<?php echo $d; ?>"><?php echo $d; ?></option>
	<?php } ?></select></td>
<td>Month</td>
<td><select name="month" id="month">
<option value="">Select Month</option>
<?php for($m=1; $m<=12; $m++){
?>	
	<option value="<?php echo $m; ?>"><?php echo $m; ?></option>
	<?php } ?></select></td>
<td>Year</td>
<td><select name="year" id="year">
<option value="">Select Year</option>
<?php for($y=2013; $y<=date("Y"); $y++){
?>	
	<option value="<?php echo $y; ?>"><?php echo $y; ?></option>
	<?php } ?></select></td>

</tr>
<tr><td align="center" colspan="7"><input type="submit" name="submit" value="Resolve Now" id="submit" onclick="return checkform(this)" /></td></tr>
</table>
</fieldset>

</form>
</div>
</center>
<br /><br />

<?php
//include "nusoap.php";//Do you have this file?
if(isset($_POST['submit'])){
echo "Submitted";
	$datex=$_POST['year']."-".$_POST['month']."-".$_POST['day'];

$client = new SoapClient(null, array('location' => "http://www.branchcollect.com/pay/index.php", 'uri'      => "http://branchcollect.com/pay"));
$MerchantID = "9";
$MerchantCode = "NSE";
//$salt = "$MerchantID|$MerchantCode|$TransactionID";
//$MAC = hash('sha512', $salt);
//END DEFINITION OF CONSTANTS

//DO Database Connections here
/*$connect = mysql_connect('localhost', 'duiwn', '$#upLASjus');
$db_select = mysql_select_db('l_wpy');*/
 /*mysql_connect('localhost','accounts_uthman','accounts_uthman');
    mysql_select_db("accounts_lasu");*/
    include('inc/config.php');
	

//Query the db while looping to get the Transaction IDs with Payment Status as 'Pending'
//$datex=date("Y-m-d");
$qryy = mysql_query("SELECT * FROM corp_reg_pay WHERE status = 'Pending' AND payment_mode='Paychoice' date='$datex'");
$num = mysql_num_rows($qryy);
if($num){
while($row = mysql_fetch_array($qryy)){
$transaction_id_to_confirm = $row['transactionid']; //assuming that the name of the field is 'transid'
//echo "Transaction Number: ".$transaction_id_to_confirm."----".$row['status']."<br>";


$salt = "$MerchantID|$MerchantCode|$transaction_id_to_confirm";
$MAC = hash('sha512', $salt);

$string = <<<XML
<?xml version="1.0"  encoding="UTF-8"?> 
<BranchCollectRequest>
<RequestDetails>
    <Merchant MerchantID="$MerchantID" MerchantCode="$MerchantCode" TransactionID="$transaction_id_to_confirm" MAC="$MAC" />
</RequestDetails>
</BranchCollectRequest>
XML;
?>
<?

	
$params = array('XMLRequest' => $string);
$objectresult = $client->__soapCall("PaidTransactionDetails", $params);
$resp = simplexml_load_string($objectresult);
$reponse = $resp->RespCode;
//echo $reponse;
   if($reponse == '00'){ //he has paid, get other parameters too
       $transaction_id = $resp->TransactionID ;
       //update your database table here for the transaction ID, $transaction_id

       $update1 = mysql_query("UPDATE corp_reg_pay SET status = 'Paid' WHERE transactionid='$transaction_id'");
if(!$update1){
	echo mysql_error();
	}
       $status =  $resp->Message;
       $payment_date  = $resp->DateofPayment;
       $customer_id = $resp->CustomerNo;
       $surname = $resp->CustomerSurname;
       $firstname = $resp->CustomerFirstname;
       $othername = $resp->CustomerOthernames;
       $email = $resp->CustomerEmail; // send him a payment notification notice
       $phone = $resp->CustomerGSM;
       $amount = $resp->TotalAmount;
       $deposit_number = $resp->DepositSlip;
	   
	   echo "Transaction Number: ".$transaction_id_to_confirm."----".$row['status']."---".$status."--Resp---Code".$reponse."<br>";
	   echo "Transaction(s) resolved";
	   header("refresh: 3; url=maintenanceByDay.php");
   } //end if $response == '00'
   else{

	   echo "Transaction Number: ".$transaction_id_to_confirm."----".$row['status']."---".$status."--Resp---Code".$reponse."<br>";
	   //echo "Error: ".$reponse;
   }

} //end of while loop

} //end if($num)
}
?>