function transaction_cancel_rebill($trans_id)
{
$ref_no = func_Trans_Ref_No($trans_id);
$trans = new transaction_class(false);
$trans->pull_transaction($trans_id);
$status = $trans->process_cancel_request(array("actor" => 'Administrator'));
return $status;
}
function func_insert_transactionCreditdata($array_transdetails, $company_id_val, $cnn_connection)
{
$trans_insert_status = "";
$reference_number = "NIL";
$str_invalid_date = "";
if (count($array_transdetails) > 0) {
$telephoneno = $array_transdetails[7];
/* $format_split_date = split("/",$array_transdetails[15]);
if(count($format_split_date)== 3 ) {
$format_split_date[0] = strlen(trim($format_split_date[0])) == 1 ? "0".$format_split_date[0] : $format_split_date[0];
$format_split_date[1] = strlen(trim($format_split_date[1])) == 1 ? "0".$format_split_date[1] : $format_split_date[1];
$trans_date_enter = "$format_split_date[0]-$format_split_date[1]-$format_split_date[2]:00";
$trans_date_enter = func_get_date_inyyyymmdd_time($trans_date_enter);
} else {
$trans_date_enter = "";
}*/
$trans_date_enter = date("Y-m-d H:i:s");
if ($trans_date_enter == "") {
$str_invalid_date = "Invalid Date";
} else {
$name = trim($array_transdetails[0]);
$surname = trim($array_transdetails[1]);
$address = trim($array_transdetails[2]);
$city = trim($array_transdetails[3]);
$state = trim($array_transdetails[4]);
$zipcode = trim($array_transdetails[5]);
$country = trim($array_transdetails[6]);
$phonenumber = trim($array_transdetails[7]);
$email = trim($array_transdetails[8]);
$amount = trim($array_transdetails[9]);
$checkorcard = "H";
$cardType = trim($array_transdetails[10]);
$CCnumber = trim($array_transdetails[11]);
$cvv = trim($array_transdetails[12]);
$validupto = trim($array_transdetails[13]);
$transactionDate = date("Y-m-d H:i:s");
$productdescription = trim($array_transdetails[14]);
$billingDate = trim($array_transdetails[15]);
$firstnum = substr($CCnumber, 0, 1);
if ($firstnum == "5") {
$cardType = "Master";
} else {
$cardType = "Visa";
}
$userid = $company_id_val;
$domain = GetHostByName($_SERVER["REMOTE_ADDR"]);
$temp = $billingDate;
$tem = explode("/", $temp);
$mm = $tem[0];
$dd = $tem[1];
$yyyy = $tem[2];
$d = $yyyy . "-" . $mm . "-" . $dd;
$qrt_insert_details = "insert into cs_transactiondetails (name,surname,address,city,state,zipcode,country,phonenumber,email,amount,checkorcard,cardtype,CCnumber,cvv,validupto,transactionDate,billingDate,userid,passStatus,pass_count,cancelstatus,status,ipaddress,productdescription,declinedReason,company_usertype,company_user_id)\n\t\t\t\t values('{$array_transdetails['0']}','{$array_transdetails['1']}','{$array_transdetails['2']}','{$array_transdetails['3']}','{$array_transdetails['4']}','{$array_transdetails['5']}','{$array_transdetails['6']}','{$array_transdetails['7']}','{$array_transdetails['8']}',{$array_transdetails['9']},'H','{$cardType}','{$array_transdetails['11']}','{$array_transdetails['12']}','{$array_transdetails['13']}','{$trans_date_enter}','{$d}',{$company_id_val},'PA',0,'N','D','{$domain}','{$array_transdetails['14']}','Error in data',5,{$userid})";
// print $qrt_insert_details ."<br>";
}
if (func_isvalidCardnumber($CCnumber)) {
if (func_isvalidCardnumber($cvv)) {
if ($str_invalid_date == "") {
// Credit card details.
if (!($sql_insert_data = mysql_query($qrt_insert_details))) {
$trans_insert_status = "failure";
} else {
$transactionId = mysql_insert_id();
$ref_number = func_Trans_Ref_No($transactionId);
$updateSuccess = "";
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_number, 'transactionId', $transactionId, $cnn_connection);
func_update_rate($userid, $transactionId, $cnn_connection);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
$qrt_select_company = "Select companyname,transaction_type,billingdescriptor,email,send_mail,send_ecommercemail,bank_Creditcard,bank_shopId,bank_Username,bank_Password,processing_currency from cs_companydetails where userid='{$company_id_val}'";
if (!($show_sql_run = mysql_query($qrt_select_company))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
if (mysql_num_rows($show_sql_run) == 0) {
$msgtodisplay = "You are not a valid user";
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$company_name = mysql_fetch_array($show_sql_run);
$transaction_type = mysql_result($show_sql_run, 0, 1);
$billingdescriptor = mysql_result($show_sql_run, 0, 2);
$fromaddress = mysql_result($show_sql_run, 0, 3);
$send_mails = mysql_result($show_sql_run, 0, 4);
$send_ecommercemail = mysql_result($show_sql_run, 0, 5);
$bank_CreditcardId = mysql_result($show_sql_run, 0, 6);
$bank_shopId = mysql_result($show_sql_run, 0, 7);
$bank_Username = mysql_result($show_sql_run, 0, 8);
$bank_Password = mysql_result($show_sql_run, 0, 9);
$processing_currency = func_get_cardcurrency($cardType, $company_id_val, $cnn_connection);
func_ins_bankrates($transactionId, $bank_CreditcardId, $cnn_connection);
$firstnum = "";
if ($processing_currency == "") {
$processing_currency = "USD";
}
$updateSuccess = func_update_single_field('cs_transactiondetails', 'currencytype ', $processing_currency, 'transactionId', $transactionId, $cnn_connection);
$updateSuccess = func_update_single_field('cs_transactiondetails', 'bank_id ', $bank_CreditcardId, 'transactionId', $transactionId, $cnn_connection);
$firstnum = substr($CCnumber, 0, 1);
if ($firstnum == "5") {
$cardType = "Master";
} else {
$cardType = "Visa";
}
$cardExpir = split("/", $validupto);
$year = $cardExpir[0];
$cardExpire = $cardExpir[1] . "/" . substr($year, 2, 3);
$abbrCountry = func_country_abbreviation($country);
$abbrState = func_state_abbreviation($state);
// function for submitting to bank
// print "func_volpay_bankprocess($bank_Username,$bank_Password,$reference_number,$cardType,$CCnumber,$cardExpire,$cvv,$name,$surname,$address,$zipcode,$city,$abbrCountry,$phonenumber,$abbrState,$email,$processing_currency,$amount,$cnn_connection,$transactionId)";
if ($bank_CreditcardId == 6 || $bank_CreditcardId == 7 || $bank_CreditcardId == 8) {
$trans_insert_status = func_volpay_bankprocess($bank_Username, $bank_Password, $reference_number, $cardType, $CCnumber, $cardExpire, $cvv, $name, $surname, $address, $zipcode, $city, $abbrCountry, $phonenumber, $abbrState, $email, $processing_currency, $amount, $cnn_connection, $transactionId, $company_id_val);
} else {
if ($bank_CreditcardId == 3) {
$cardTypeBr = $cardType == "Visa" ? "V" : "M";
$trans_insert_status = func_bardo_bankprocess($bank_shopId, "Service", $processing_currency, $reference_number, $surname, $name, $email, $address, $city, $zipcode, $abbrState, $abbrCountry, $phonenumber, $amount, $cardTypeBr, $CCnumber, $cardExpire, $cvv, $transaction_type, $transactionId, $cnn_connection);
}
}
}
}
}
} else {
$trans_insert_status = $str_invalid_date;
}
} else {
$trans_insert_status = "Error in Data";
}
} else {
$trans_insert_status = "Error in Data";
}
print "<tr height='20'><td class='leftbottomright'><font face='verdana' size='1'> {$reference_number}</font></td><td class='leftbottomright'><font face='verdana' size='1'> {$array_transdetails['0']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['1']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['2']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['8']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['7']}</font></td><td class='cl1'><font face='verdana' size='1'> {$trans_insert_status}</font></td></tr>";
}
}
}
if ($i_crdnet_amt >= 500) {
$i_crdnet_amt -= 50;
$wirefee = 50;
}
if ($creditcardAmt != 0) {
$qry_invoice = "insert into cs_invoicedetails (userId,gatewayid,totalAmt,approvedAmt,declinedAmt,creditAmt,pendingamt ,chargeBack,credit,discount,transactionFee,voiceAuthorisation_fee,reserveFee,totalDeductions,netAmount,adminApproved,generateddate,startdate,enddate,checkorcard,processingcurrency,transactionno,approvedno,declinedno,pendingno,creditno,voiceuploadfee,chargebackno, resellerid,canceledno,nopass,nopasscount,passed,passedcount,voiceuploadcount,wirefee,bank_id,reject_count,reject_amt,reject_creditamt,reject_chargebackamt,reject_transfee,cancel_startdate,cancel_enddate,reject_creditcount,reject_chargebackcount)values('{$iuserid}','{$igatewayid}','{$creditcardAmt}','{$creditapprovedAmt}','{$creditdeclinedAmt}','{$creditcanceledAmt}','{$creditpendingAmt}','{$crdchargebackamount}','{$crdcredit_amount}','{$i_crddiscount_amt}','{$i_crdtransaction_amt}',{$i_crdvoiceauth_amt},'{$i_crdreserve_amt}','{$crddeducted_amt}','{$i_crdnet_amt}','N','{$approvedstatusdate}','{$str_startdate}','{$str_afterdate}','H',";
$qry_invoice .= "'{$str_processingcurency}','{$creditcard}','{$creditapproved}','{$creditdeclined}','{$creditpending}','{$crdcredit_count}',0,'{$crdcharge_back_count}','{$iresellerid}','{$creditcanceled}'";
$qry_invoice .= ",'{$creditnonpassAmt}','{$creditnonpass}','{$creditpassAmt}','{$creditpass}','{$chqvoice_authcount}',{$wirefee},{$ibankid},{$rej_creditcanceled},{$rej_creditcanceledAmt},{$rej_crdcredit_amount},{$rej_crdchargebackamount},{$rej_crdtransaction_amt},'{$cancelstartdate}','{$cancelenddate}',{$rej_crdcredit_count},{$rej_crdcharge_back_count} )";
if (!($rst_result = mysql_query($qry_invoice, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute insert query";
exit;
} else {
$transid = mysql_insert_id();
$ref_number = func_Trans_Ref_No($transid);
$updateSuccess = func_update_single_field('cs_invoicedetails', 'invoiceReferenceNumber', $ref_number, 'invoiceId', $transid, $cnn_cs);
}
}
//inserting the currency details AUD
if ($audcreditcardAmt != 0) {
$qry_invoice = "insert into cs_invoicecurrencydetails (userId,gatewayid,totalAmt,approvedAmt,declinedAmt,creditAmt,pendingamt ,chargeBack,credit,discount,transactionFee,voiceAuthorisation_fee,reserveFee,totalDeductions,netAmount,adminApproved,generateddate,startdate,enddate,checkorcard,processingcurrency,transactionno,approvedno,declinedno,pendingno,creditno,voiceuploadfee,chargebackno, resellerid,canceledno,nopass,nopasscount,passed,passedcount,voiceuploadcount,wirefee,bank_id,reject_count,reject_amt,reject_creditamt,reject_chargebackamt,reject_transfee,cancel_startdate,cancel_enddate,reject_creditcount,reject_chargebackcount,invoiceId)values('{$iuserid}','{$igatewayid}','{$audcreditcardAmt}','{$audcreditapprovedAmt}','{$audcreditdeclinedAmt}','{$audcreditcanceledAmt}','{$audcreditpendingAmt}','{$audcrdchargebackamount}','{$audcrdcredit_amount}','{$audi_crddiscount_amt}','{$audi_crdtransaction_amt}',0,'{$audi_crdreserve_amt}','{$audcrddeducted_amt}','{$audi_crdnet_amt}','N','{$approvedstatusdate}','{$str_startdate}','{$str_afterdate}','H',";
$qry_invoice .= "'AUD','{$audcreditcard}','{$audcreditapproved}','{$audcreditdeclined}','{$audcreditpending}','{$audcrdcredit_count}',0,'{$audcrdcharge_back_count}','{$iresellerid}','{$audcreditcanceled}'";
$qry_invoice .= ",'{$audcreditnonpassAmt}','{$audcreditnonpass}','{$audcreditpassAmt}','{$audcreditpass}','0',{$wirefee},{$ibankid},{$audrej_creditcanceled},{$audrej_creditcanceledAmt},{$audrej_crdcredit_amount},{$audrej_crdchargebackamount},{$audrej_crdtransaction_amt},'{$cancelstartdate}','{$cancelenddate}',{$audrej_crdcredit_count},{$audrej_crdcharge_back_count},{$transid} )";
if (!($rst_result = mysql_query($qry_invoice, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute insert query";
exit;
}
}
//CAD
$str_qry_select = "select bank_Username,bank_Password,bank_Creditcard,bank_check,bank_shopId,processing_currency,transaction_type from cs_companydetails where userId ={$userid}";
$str_sel_result = mysql_query($str_qry_select, $cnn_cs);
$str_sel_row = mysql_fetch_array($str_sel_result);
$bank_Username = $str_sel_row[0];
$bank_Password = $str_sel_row[1];
$bank_Creditcard = $str_sel_row[2];
$bank_check = $str_sel_row[3];
$bank_shopId = $str_sel_row[4];
$processing_currency = $str_sel_row[5];
if ($processing_currency == "") {
$processing_currency = "USD";
}
$transaction_type = $str_sel_row[6];
$trans_amount = $amount;
//refnum
$ref_no = func_Trans_Ref_No($trans_id);
$str_qry_update_ref = "UPDATE cs_transactiondetails set reference_number='{$ref_no}', currencytype ='{$processing_currency}' WHERE transactionId ='{$trans_id}'";
if (!($str_result_update_ref = mysql_query($str_qry_update_ref, $cnn_cs))) {
echo "error on update";
exit;
}
exit;
$trans_amount *= 100;
if ($state == "") {
$state = "Others";
}
$abbrCountry = func_country_abbreviation($country);
$abbrState = func_state_abbreviation($state);
$bank_CreditcardId = $bank_Creditcard;
if ($bank_CreditcardId == 6 || $bank_CreditcardId == 7 || $bank_CreditcardId == 8) {
$bUserId = $bank_Username;
function process_cancel_request($info = array())
{
if ($this->row['subscriptionTable']['ss_rebill_status'] == 'inactive') {
return false;
}
if (!$this->row['subscriptionTable']) {
return false;
}
$notes = '';
if ($info['notes']) {
$notes = "\nNotes: " . $info['notes'];
}
if (!$info['actor']) {
$info['actor'] = 'System';
}
if ($info['verifyuserId'] && $info['verifyuserId'] != $this->row['subscriptionTable']['ss_user_ID']) {
toLog('erroralert', 'system', 'UserId Verification Failed! ' . print_r($info, true) . print_r($this->row['subscriptionTable'], true));
return false;
}
$ref_no = func_Trans_Ref_No($values['append']);
$transTable = $this->test ? "cs_test_transactiondetails" : "cs_transactiondetails";
$sql = "UPDATE cs_subscription as ss left join {$transTable} as td on td.td_ss_ID = ss.ss_ID \n\t\tSET `td_enable_rebill` = '0', \n\t\t\tcancel_refer_num = '{$ref_no}',\n\t\t\tss_cancel_id = '{$ref_no}',\n\t\t\tss_rebill_status = 'inactive',\n\t\t\tss_rebill_status_text = 'Subscription Cancelled by " . $info['actor'] . "',\n\t\t\tss_account_notes = CONCAT(ss_account_notes, '\n\n', NOW(), ': Rebill Cancelled (Ref: {$ref_no}) . Subscription will not Rebill Again.{$notes}')\n\t\t\n\t\tWHERE `ss_ID` = '" . $this->row['subscriptionTable']['ss_ID'] . "' AND ss_user_ID = '" . $this->row['subscriptionTable']['ss_user_ID'] . "'";
$result = sql_query_write($sql) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query<br><b>{$sql}</b>");
$this->row = $this->getRow();
// Update Status
if (mysql_affected_rows()) {
$data['site_URL'] = $this->row['websiteTable']['cs_name'];
$data['reference_number'] = $this->row['transactionTable']['reference_number'];
$data['subscription_ID'] = $this->row['subscriptionTable']['ss_subscription_ID'];
$data['full_name'] = $this->row['subscriptionTable']['ss_billing_firstname'] . " " . $this->row['subscriptionTable']['ss_billing_mi'] . " " . $this->row['subscriptionTable']['ss_billing_lastname'];
$data['email'] = $this->row['subscriptionTable']['ss_cust_email'];
$data['cancel_reference_number'] = $ref_no;
$data["gateway_select"] = $this->row['websiteTable']['cs_gatewayId'];
send_email_template('customer_cancel_confirmation', $data);
if ($transInfo['cd_recieve_order_confirmations']) {
$data['email'] = $transInfo['cd_recieve_order_confirmations'];
send_email_template('customer_cancel_confirmation', $data, $str_is_test . "(Merchant Copy) ");
}
return array('success' => true, 'ss_cancel_id' => $ref_no);
}
return false;
}
require_once "includes/dbconnection.php";
include 'includes/function2.php';
require_once 'includes/function.php';
$no_fields = 0;
$qry_empty_reference = "SELECT transactionId,reference_number FROM cs_transactiondetails ";
$rst_select = mysql_query($qry_empty_reference, $cnn_cs);
$i_count = mysql_num_rows($rst_select);
$updateSuccess = "";
$a = 0;
//echo($i_count."<BR>");
for ($i = 0; $i < $i_count; $i++) {
$resultSet = mysql_fetch_array($rst_select);
$transaction_no = $resultSet['transactionId'];
$reference_number = $resultSet['reference_number'];
if ($reference_number == "") {
//echo($transaction_no."<BR>");
$a = $a + 1;
$ref_num = func_Trans_Ref_No($transaction_no);
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_num, 'transactionId', $transaction_no, $cnn_cs);
if ($updateSuccess == 0) {
echo "cannot update" . "<BR>";
exit;
}
}
}
if ($updateSuccess == 1) {
echo $a . " Transactions are updated in the table" . "<BR>";
} else {
echo "NO REFERENCE FIELDS ARE EMPTY TO UPDATE";
}
//***********************************//
$approvedstatus = func_update_approval($companyid, $startdate, $enddate, $chkapproved, $checkexsists, $cnn_cs);
}
// inserted only if there is no exsisting records
//************************************************//
if ($checkexsists == 0) {
$qrt_insert_details = "insert into cs_invoicedetails (userId ,subtotalAmt,totalAmt,approvedAmt ,declinedAmt,creditAmt,chargeBack,credit,discount,transactionFee,voiceAuthorisation_fee,reserveFee,totalDeductions ,miscAdd,miscSub,netAmount,adminApproved,approvedstatusdate,startdate,enddate,frequency) values({$companyid},{$subtotalamt},{$transAmt},{$Approvedamt},{$declinedamt},{$cancelamt},{$chargeback},{$credit},{$discount},{$transFees},{$voiceAuthFees},{$reserve},{$totalDeduction},{$miscAdd},{$miscSub},{$netAmt},'{$chkapproved}','{$approvedstatusdate}','{$startdate}','{$enddate}','{$frequency}')";
//echo $qrt_insert_details;
if (!($show_sql = mysql_query($qrt_insert_details, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
$insert = 1;
//reference no updatation
//***********************//
$invoiceid = mysql_insert_id();
$invoice_reference_no = func_Trans_Ref_No($invoiceid);
$updateSuccess = func_update_single_field('cs_invoicedetails', 'invoiceReferenceNumber', $invoice_reference_no, 'invoiceId', $invoiceid, $cnn_cs);
}
//checkexsists loop ends here
$appstatus = $appstatus . "}" . $approvedstatus;
}
//if loop ends here (netAmt)
}
//for loop ends here
//echo $appstatus."<BR>";
if ($insert == 1) {
$msgtodisplay_1 = "Invoice Summary added successfully";
header("location:transactionupdateview.php?msg_1={$msgtodisplay_1} & msgid={$companyid}");
exit;
}
if ($approvedstatus != "") {
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<?php
$trans_refno = func_Trans_Ref_No(26786766);
echo $trans_refno . "<Br>";
$c = strlen($trans_refno);
echo $c . "<br>";
$a = substr($trans_refno, 2, $c - 4);
echo $a;
function func_Trans_Ref_No($trans_id)
{
$random_first = rand(0, 9);
$random_second = rand(0, 9);
$random_firststr = func_assign_randstr_value($random_second);
$random_secondstr = func_assign_randstr_value($random_first);
$return_refno = $random_first . $random_second . $trans_id . $random_firststr . $random_secondstr;
return $return_refno;
}
function func_assign_randstr_value($num)
{
switch ($num) {
case "1":
$rand_value = "A";
break;
case "2":
$rand_value = "B";
break;
case "3":
$rand_value = "C";
break;
case "4":
$rand_value = "D";
// viewreportpage_negative.php,batchuploads.php,voicesystem.php,voicesystemreport.php,voicesystemdetails.php,companyAdd.php,companies_blank.php
// modifycompany.php,companyuser.php,orderemail.php,enquires.php,report_custom.php,service_users.php,export.php,ledger.php
// labels.php,printemailforms.php,maileditor.php,shipping.php,shippingdetails.php,logout.php
// Cancelrequests.php:
$allowBank = true;
include "includes/sessioncheck.php";
require_once '../includes/function2.php';
$headerInclude = "customerservice";
include "includes/header.php";
include "includes/message.php";
if ($_POST['Action'] == "Delete" && $adminInfo['li_level'] == 'full') {
$sql = "DELETE FROM `cs_callnotes` WHERE note_id = '" . $_POST['note_id'] . "'";
$result = mysql_query($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query");
}
if ($_POST['Action'] == "Refund" && $adminInfo['li_level'] == 'full') {
$ref_no = func_Trans_Ref_No($_POST['transactionId']);
$qry_details = "UPDATE `cs_transactiondetails` SET `cancelstatus` = 'Y', `admin_approval_for_cancellation` = 'A', `cancellationDate` = CONCAT(CURDATE(),' ',CURRENT_TIME()), `reason` = 'Administrator Refund From Found Call', `cancel_refer_num` = '{$ref_no}' WHERE `transactionId` = '" . $_POST['transactionId'] . "'";
$rst_details = mysql_query($qry_details, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query");
//func_canceledTransaction_receipt('', $_POST['transactionId'],$cnn_cs);
func_email_cancel_reciept($_POST['transactionId'], "customer_refund_confirmation");
}
$Transtype = isset($_GET['trans_type']) ? quote_smart($_GET['trans_type']) : "";
$companytype = isset($_GET['companymode']) ? $_GET['companymode'] : "A";
$companytrans_type = isset($_GET['companytrans_type']) ? quote_smart($_GET['companytrans_type']) : "A";
$company_name = isset($_GET['companyname']) ? $_GET['companyname'] : "";
$bank_id = $_GET['bank_id'];
if (!$bank_id) {
$bank_id = $_POST['bank_id'];
}
if ($bank_id) {
$bank_sql = " AND bank_id = '{$bank_id}' ";
