D:\host\scoreman.in\tldt2025\reconciliation.php
<html>
<?php
include("api.php");
$ccavenue_api = new CCAvenue_API();
//Get pendingorders list
$pendingorders = array("order_no"=>"","reference_no"=>"","order_bill_name"=>"","order_email"=>"","order_bill_tel"=>"","order_fraud_status"=>"","order_currency"=>"","order_type"=>"","page_number"=>"1");
//$response=$ccavenue_api->getPendingOrders($pendingorders);
print_r($response);
include('../dbconnect.php');
ini_set('max_execution_time', 0);
$seq=$_GET["seq"];
$next=$seq+50;
echo '<a href="https://telanganaskate.com/districts2025/pay/reconciliation.php?seq='.$next.'"> Next '.$next.'</a><br/>';
//include('functions.php');
// $databaseQuery = 'SELECT appno,email FROM applications where order_status LIKE "" or order_status IS NULL or order_status LIKE "Awaited" or order_status LIKE "Initiated" or order_status LIKE "No record found." ORDER BY appno DESC LIMIT '.$seq.',200';
$databaseQuery = 'SELECT appno,email FROM applications where order_status="" or order_status="Initiated" or order_status="Awaited" or order_status="Initiated" or order_status="" ORDER BY appno DESC LIMIT '.$seq.',50';
$result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
echo mysqli_num_rows($result3);
//exit();
$i=0;
while($row = mysqli_fetch_array($result3))
{
$appno=trim($row["appno"]);
$email=trim($row["email"]);
echo "<br/>".$appno;
$statusorder = array("order_no"=>$appno,"reference_no"=>"","order_bill_name"=>"","order_email"=>$email,"order_bill_tel"=>"","order_fraud_status"=>"","order_currency"=>"","order_type"=>"","page_number"=>"1");
$response=$ccavenue_api->orderStatusTracker($statusorder);
echo "<br/><br/>" ;
$response=substr($response, 0, strpos($response, "\"}")+2);
echo $response;
$resob=json_decode($response);
//$resob = simplexml_load_string($response);
//echo $resob;
echo $resob->status;
$order_status=$resob->order_status;
if($resob->status===1)
{
$order_status=$resob->error_desc;
}
echo $appno." ".$resob->reference_no." ".$resob->order_status."<br/>";
//echo $appno." ".$resob['reference_no']." ".$resob['order_status']."<br/>";
//print_r($response);
//print($response);
echo "<br/><br/>";
if($order_status==="Successful" ||$order_status==="Shipped" )
{
$order_status="Success";
}
$databaseQuery1 = 'UPDATE applications SET order_id="'.$appno.'",tracking_id="'.$resob->reference_no.'", order_status="'.$order_status.'",payment_mode="'.$resob->order_card_name.'", trans_date="'.$resob->order_date_time.'", amt="'.$resob->order_amt.'", capamt="'.$resob->order_capt_amt.'", ccavenuefee="'.$resob->order_fee_perc_value.'" , paytax="'.$resob->order_tax.'" where appno="'.$appno.'"';
mysqli_query($con,$databaseQuery1) or mysqli_error();
if($order_status==="Success")
{
//echo "<br>Thank you. Your transaction is successful. You will receive Payment Confirmation & Application Form by Email Shortly.";
//sendform($appno);
//echo '<br><a href="applicationpdf.php?appno='.$order_id.'">Click Here to Print / Download Annual Registration Form</a>';
}
}
?>
</html>