<?php include "../includes/sessioncheckserviceuser.php"; require_once "../includes/function.php"; $strReasonCombo = isset($HTTP_POST_VARS["optReason"]) ? Trim($HTTP_POST_VARS["optReason"]) : ""; $strOtherReason = isset($HTTP_POST_VARS["txtReason"]) ? Trim($HTTP_POST_VARS["txtReason"]) : ""; $iTransactionId = isset($HTTP_POST_VARS["hdTransactionId"]) ? Trim($HTTP_POST_VARS["hdTransactionId"]) : ""; $strDateTime = func_get_current_date_time(); $return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs); $qryUpdate = "update cs_transactiondetails set cancelstatus ='Y',cancellationDate = '{$strDateTime}',reason='{$strReasonCombo}',other='{$strOtherReason}'"; $qryUpdate .= " where transactionId =" . $return_insertId; if (!mysql_query($qryUpdate)) { print "Can not execute query"; exit; } $user_id = func_get_value_of_field($cnn_cs, "cs_transactiondetails", "userId", "transactionId", $return_insertId); func_canceledTransaction_receipt($user_id, $return_insertId, $cnn_cs); header('location:customerservice.php');
$other = isset($HTTP_GET_VARS['other']) ? Trim($HTTP_GET_VARS['other']) : ""; if ($cancel) { $iTransactionId = $id; $return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs); $query = "Update transactiondetails set cancelstatus='Y' where transactionId={$return_insertId} and userid={$sessionlogin}"; // echo $query; mysql_query($query); if (mysql_affected_rows() == 0) { $outhtml = "y"; $msgtodisplay = "This transaction has been already canceled"; message($msgtodisplay, $outhtml, $headerInclude); exit; } else { $show_sql = mysql_query("update transactiondetails set reason='{$cancelreason}',cancellationDate='{$canceldate}' where transactionId={$return_insertId} and userid={$sessionlogin}"); $show_sql = mysql_query("update transactiondetails set other='{$other}' where transactionId={$return_insertId} and userid={$sessionlogin}"); func_canceledTransaction_receipt($sessionlogin, $id, $cnn_cs); $outhtml = "y"; $msgtodisplay = "Selected transactions has been canceled"; message($msgtodisplay, $outhtml, $headerInclude); exit; } } else { if ($cnumber != "" && $id != "" || $tele_number != "") { if ($cnumber) { $cnumber_qry = "a.CCnumber ='" . etelEnc($cnumber) . "' and"; } if ($id) { $tid_qry = "a.transactionId={$id} and "; } $querystr = "select b.companyname,a.name,a.surname,a.transactionDate,a.checkorcard,a.CCnumber,a.checkto,a.amount,a.status,a.bankaccountnumber,a.bankroutingcode,a.phonenumber,a.address,a.country,a.city,a.state,a.zipcode,a.memodet,a.signature,a.email,a.transactionId,a.cardtype,a.validupto,a.reason,a.other,a.cvv,a.misc,a.Invoiceid,a.checktype,a.bankname,a.accounttype,a.ipaddress,a.cancelstatus,a.voiceAuthorizationno,a.shippingTrackingno,a.socialSecurity,a.driversLicense,a.chequedate,a.billingDate,a.licensestate from transactiondetails as a,customerdetails as b where " . $tid_qry . "a.userid={$sessionlogin} and " . $cnumber_qry . " " . $telephone_qry . " a.userid=b.userid"; // echo $querystr;
print "Can not execute query cancel update query"; exit; } $qryUpdate = "update cs_transactiondetails set reason=null, other=null,cancellationDate=null,admin_approval_for_cancellation='N' where transactionId={$iTransactionId}"; if (!mysql_query($qryUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query cancel return query"; exit; } if ($strPaymentType == "C") { //if($strBankRoutingCode != "") //{ func_send_cancel_mail($iCompanyId, $strPaymentType); //} } func_canceledTransaction_receipt($iCompanyId, $return_insertId, $cnn_cs); } 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 (!mysql_query($qryUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query cancel update query"; exit; } $qryUpdate = "update cs_transactiondetails set reason=null, other=null,cancellationDate=null,admin_approval_for_cancellation='N' where transactionId={$iTransactionId}"; if (!mysql_query($qryUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query cancel update query"; exit; }
exit; } if (mysql_num_rows($rst_select_status) > 0) { $db_passstatus = mysql_result($rst_select_status, 0, 0); $db_status = mysql_result($rst_select_status, 0, 1); $db_cancelstatus = mysql_result($rst_select_status, 0, 2); $db_passcount = mysql_result($rst_select_status, 0, 3); $db_approvalcount = mysql_result($rst_select_status, 0, 4); } $qrydeclineUpdate = "update cs_transactiondetails set td_is_chargeback = '{$td_is_chargeback}', cancelstatus = '{$cancelstatus}',reason='{$strtxt}' where transactionId={$iTransactionId}"; if (!mysql_query($qrydeclineUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query pass update query"; exit; } func_canceledTransaction_receipt($companyids, $iTransactionId, $cnn_cs); if ($strDeclinedReason != "") { $qrydeclineUpdate = "update cs_transactiondetails set declinedReason = '{$strDeclinedReason}' where transactionId={$iTransactionId}"; if (!mysql_query($qrydeclineUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query pass update query"; exit; } } if ($strPassStatus != "" && $strPassStatus != $db_passstatus) { if ($strPassStatus == "NP") { $qryUpdate = "update cs_transactiondetails set td_is_chargeback = '{$td_is_chargeback}', cancelstatus = '{$cancelstatus}', nopasscomments = '{$strNoPassReason}' where transactionId={$iTransactionId}"; } else { if ($db_passstatus == "NP") { $qryUpdate = "update cs_transactiondetails set nopasscomments = '' where transactionId={$iTransactionId}"; }
print "Can not execute query status update"; exit; } } } if ($strCancel != "" && $strCancel != $db_cancelstatus) { $return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs); $qryUpdate = "update cs_transactiondetails set passStatus='ND',cancelstatus='Y',reason='{$strCancelReason}',other='{$strOtherReason}',cancellationDate='{$strCurrentDateTime}' where transactionId={$return_insertId}"; if (!mysql_query($qryUpdate, $cnn_cs)) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Can not execute query cancel update query"; exit; } 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); //} } }