$cancel_ref_num = $rst_canceladd[19]; if ($cancel_ref_num != "" && $cancel_ref_num != 0) { $qry_select = "select r_chargeback ,r_credit , r_discountrate , r_transactionfee ,r_reserve from cs_transactiondetails where reference_number ={$cancel_ref_num} "; if (!($rst_rates = mysql_query($qry_select, $cnn_cs))) { print "cannot execute query rrr "; } else { $rst_charges = mysql_fetch_array($rst_rates); $i_charge_back = $rst_charges[0]; $i_credit = $rst_charges[1]; $i_discount_rate = $rst_charges[2]; $i_transaction_fee = $rst_charges[2]; $i_reserve = $rst_charges[4]; } } if ($str_processingcurency == "") { $str_processingcurency = func_get_cardcurrency($trans_cardtype, $iuserid, $cnn_cs); } //splitting based on currency type AUD if ($str_processingcurency == "AUD") { //echo "in this"; $audrej_crdtransaction_amt = $i_transaction_fee + $audrej_crdtransaction_amt; $audrej_creditcanceled = $audrej_creditcanceled + 1; $audrej_creditcanceledAmt = $audrej_creditcanceledAmt + $trans_amount; if ($cancel_reason == "Chargeback") { $audrej_crdcharge_back_count = $audrej_crdcharge_back_count + 1; $audrej_crdchargebackamount = $i_charge_back + $audrej_crdchargebackamount; } else { $audrej_crdcredit_count = $audrej_crdcredit_count + 1; $audrej_crdcredit_amount = $audrej_crdcredit_amount + $i_credit; } }
$ProcessingMode = isset($_REQUEST['ProcessingMode']) ? quote_smart($_REQUEST['ProcessingMode']) : ""; if (!$mt_language) { $mt_language = isset($_REQUEST['mt_language']) ? quote_smart($_REQUEST['mt_language']) : ""; } if (!$mt_language) { $mt_language = $_SESSION['tmpl_language']; } if (!$mt_language) { $mt_language = 'eng'; } $_SESSION['tmpl_language'] = $mt_language; $smarty->assign("mt_language", $_SESSION['tmpl_language']); $smarty->assign("tmpl_language", $_SESSION['tmpl_language']); $str_currency = func_get_cardcurrency('Master', $companyid, $cnn_cs); $mastercurrency = $str_currency; $visacurrency = func_get_cardcurrency('Visa', $companyid, $cnn_cs); if (!$ProcessingMode) { $ProcessingMode = $_SESSION['ProcessingMode']; } $_SESSION['card_declined_reset'] = false; if (strpos(strtolower($ProcessingMode), "check") !== false) { $_SESSION['ProcessingMode'] = 'Check'; $company_bank_sql = ', b.bank_check as company_bank_id'; $company_bank_sql_join = 'bank_check'; } else { if (strpos(strtolower($ProcessingMode), "credit") !== false) { $_SESSION['ProcessingMode'] = 'Credit'; $company_bank_sql = ', b.bank_Creditcard as company_bank_id'; $company_bank_sql_join = 'bank_Creditcard'; } else { if (strpos(strtolower($ProcessingMode), "useraccount") !== false) {
Reason</span></td> <td width='125' class='cl1'><span class="subhd">Action </span></td> </tr> <?php } $i = $i + 1; if ($show_select_val['cardtype'] == 'Check') { $ctype = "Check"; } else { $ctype = "Creditcard"; } $str_processingcurency = $show_select_val['currencytype']; $str_cardtype = $show_select_val[21]; if ($str_processingcurency == "") { if ($ctype == "CreditCard") { $str_processingcurency = func_get_cardcurrency($str_cardtype, $iCompanyId, $cnn_cs); } else { $str_processingcurency = 'USD'; } } if ($show_select_val[7] == "") { $misc = " "; } else { $misc = $show_select_val[7]; } ?> <form action="" method="post"> <input name="curinc" type="hidden" id="curinc" value="<?php echo $curinc; ?> ">
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>"; } }
$str_phone = mysql_result($rssel_report, $i, 1); $str_bill_date = mysql_result($rssel_report, $i, 2); $str_first_name = mysql_result($rssel_report, $i, 3); $str_surname = mysql_result($rssel_report, $i, 4); $str_company = mysql_result($rssel_report, $i, 5); $str_checkorcard = mysql_result($rssel_report, $i, 6) == "C" ? "Check" : "Credit Card"; $i_amount = mysql_result($rssel_report, $i, 7); $str_cancellation_reason = mysql_result($rssel_report, $i, 9) == "" ? mysql_result($rssel_report, $i, 8) : mysql_result($rssel_report, $i, 9); $str_currency = mysql_result($rssel_report, $i, 10); $i_company_id = mysql_result($rssel_report, $i, 11); $i_refnum = mysql_result($rssel_report, $i, 12); $i_bnk_creditcard = mysql_result($rssel_report, $i, 13); $i_bnk_chek = mysql_result($rssel_report, $i, 14); $cancel_refer_num = mysql_result($rssel_report, $i, 15); $cardtype = mysql_result($rssel_report, $i, 16); $currency = func_get_cardcurrency($cardtype, $i_company_id, $cnn_cs); $len = strlen($cancel_refer_num); $bank_Creditcard = $i_bnk_creditcard; if ($bank_Creditcard == 6 || $bank_Creditcard == 7 || $bank_Creditcard == 8) { $bnk = "v"; } else { if ($bank_Creditcard == 9 || $bank_Creditcard == 10) { $bnk = "s"; } } if ($bank_Creditcard == 3) { $bnk = "b"; } $old_tr_id = substr($cancel_refer_num, 4, $len - 6); $str_qry = ""; $bank_trid = "";