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