}
} else {
/*if($str_set_query == "")
$str_set_query = "passStatus='ND',cancelstatus ='Y',cancellationDate = '$strDateTime',reason='Customer Service'";
else
$str_set_query .= ",passStatus='ND',cancelstatus ='Y',cancellationDate = '$strDateTime',reason='Customer Service'";*/
$return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs);
$qryUpdate = "update cs_transactiondetails set passStatus='ND',cancelstatus='Y',reason='Customer Service',cancellationDate='{$strDateTime}' where transactionId={$return_insertId} and userId = {$i_user_id}";
//print($qryUpdate."<br>");
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
}
if ($str_check_or_card == "C") {
func_send_cancel_mail($i_user_id, $str_check_or_card);
}
func_canceledTransaction_receipt($i_user_id, $return_insertId, $cnn_cs);
}
$str_cancel_status = "1";
}
if ($str_set_query != "") {
$qryUpdate = "update cs_transactiondetails set " . $str_set_query;
$qryUpdate .= " where transactionId =" . $strTransactionId;
if (!mysql_query($qryUpdate)) {
print "Can not execute query";
exit;
}
}
/*$qry_select = "SELECT * FROM cs_callnotes WHERE call_date_time >='$strCurrentDate1' and call_date_time<='$strCurrentDate2' and transaction_id=$strTransactionId";
if(!($rst_select = mysql_query($qry_select)))
$strCancel = isset($HTTP_POST_VARS["cancel_status{$iLoop}"]) ? Trim($HTTP_POST_VARS["cancel_status{$iLoop}"]) : "";
$strPaymentType = isset($HTTP_POST_VARS["payment_type{$iLoop}"]) ? Trim($HTTP_POST_VARS["payment_type{$iLoop}"]) : "";
$strBankRoutingCode = isset($HTTP_POST_VARS["bank_routing_code{$iLoop}"]) ? Trim($HTTP_POST_VARS["bank_routing_code{$iLoop}"]) : "";
$strCancel = isset($HTTP_POST_VARS["cancel_status{$iLoop}"]) ? Trim($HTTP_POST_VARS["cancel_status{$iLoop}"]) : "";
$iCompanyId = isset($HTTP_POST_VARS["company_id{$iLoop}"]) ? Trim($HTTP_POST_VARS["company_id{$iLoop}"]) : "";
$qryUpdate = "";
$qryUpdateCallNotes = "";
//print("transID= $iTransactionId C/H= $strPaymentType Code= $strBankRoutingCode");
if ($iTransactionId != "") {
if ($strCancel != "") {
if ($strCancel == "accept") {
$qryUpdate = "update cs_transactiondetails set passStatus='ND',cancelstatus='Y',reason='Customer Service',cancellationDate='{$strCurrentDateTime}',admin_approval_for_cancellation='A' where transactionId={$iTransactionId}";
if ($strPaymentType == "C") {
//if($strBankRoutingCode != "")
//{
func_send_cancel_mail($iCompanyId, $strPaymentType);
//}
}
} else {
if ($strCancel == "reject") {
$qryUpdateCallNotes = "update cs_callnotes set cancel_status='0' where note_id={$iNoteId}";
$qryUpdate = "update cs_transactiondetails set admin_approval_for_cancellation='D' where transactionId={$iTransactionId}";
}
}
if ($qryUpdate != "") {
//print($qryUpdate);
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
}
} else {
$msgtodisplay = "<table width='370' height='100' align='center' valign='top' style='border:2px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='2' color='red'>Selected transaction has been canceled and is waiting for Admin's Approval.</font></td></tr><tr><td align='center'><a href='index.htm'><img border='0' src='images/back_tran.gif'></a></td></tr></table>";
}
} else {
$return_insertId = func_transaction_updatenew($trans_id, $cnn_cs);
$qryUpdate = "update cs_transactiondetails set passStatus='ND',cancelstatus='Y',reason='{$cancelreason}',cancellationDate='{$canceldate}' where transactionId={$trans_id} and userid={$user_id}";
//print($qryUpdate."<br>");
if (!mysql_query($qryUpdate, $cnn_cs)) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Can not execute query cancel update query";
exit;
} else {
$msgtodisplay = "<table width='370' height='100' align='center' valign='top' style='border:2px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='2' color='red'>Selected transactions has been canceled.</font></td></tr><tr><td align='center'><a href='index.htm'><img border='0' src='images/back_tran.gif'></a></td></tr></table>";
}
if ($crorcq1 == "C") {
func_send_cancel_mail($user_id, $crorcq1);
}
func_canceledTransaction_receipt($user_id, $return_insertId, $cnn_cs);
}
}
$qrt_update_details = "Update cs_transactiondetails set cancelstatus='Y', passStatus='ND',reason='{$cancelreason}' where transactionId={$trans_id}";
$qrt_update_details1 = "Update cs_transactiondetails set cancellationDate='{$canceldate}' where transactionId={$trans_id}";
if (!($qrt_update_run = mysql_query($qrt_update_details))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
$msgtodisplay = "<table width='370' height='100' align='center' valign='top' style='border:2px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='2' color='red'>Selected transactions has been canceled.</font></td></tr><tr><td align='center'><a href='index.htm'><img border='0' src='images/back_tran.gif'></a></td></tr></table>";
}
if (mysql_affected_rows() == 0) {
$msgtodisplay = "<table width='370' height='100' align='center' valign='top' style='border:2px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='2' color='red'>This transaction has been already canceled.</font></td></tr><tr><td align='center'><a href='index.htm'><img border='0' src='images/back_tran.gif'></a></td></tr></table>";
}
if (!($qrt_update_run1 = mysql_query($qrt_update_details1))) {
} else {
//send mail to the bank if the billing date is on or before current date and status is approved
$user_id = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "userId", "transactionId", $return_insertId);
func_canceledTransaction_receipt($user_id, $iTransactionId, $cnn_cs);
$qry_select = "SELECT billingDate,status,bankroutingcode FROM cs_transactiondetails WHERE transactionId = " . $return_insertId;
$rst_select = mysql_query($qry_select, $cnn_cs);
if (mysql_num_rows($rst_select) > 0) {
$str_bill_date = mysql_result($rst_select, 0, 0);
$str_approval_status = mysql_result($rst_select, 0, 1);
$strBankRoutingCode = mysql_result($rst_select, 0, 2);
//print("id= ".$iTransactionId." bill date= ".$str_bill_date." current= ".$strCurrentDateTime." status= ".$str_approval_status."<br>");
if ($str_bill_date != "") {
if ($strCurrentDateTime >= $str_bill_date && $str_approval_status == "A") {
if ($str_payment_type == "C") {
//if($strBankRoutingCode != "") {
func_send_cancel_mail($iCompanyId, $str_payment_type);
//}
}
}
}
}
}
}
}
}
?>
<html>
<body onLoad="document.dates1.submit()">
<form name="dates1" action="viewGatewayTransactions.php" method="POST">
<input type="hidden" name="opt_from_year" value="<?php
echo $i_from_year;
