} } 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;