$qrt_insert_details = "insert into cs_transactiondetails (name,surname,phonenumber,address,checkorcard,CCnumber,accounttype,country,city,state,zipcode,checktype,amount,transactionDate,bankname,bankroutingcode,bankaccountnumber,misc,cancelstatus,status,userid ,ipaddress,voiceAuthorizationno,shippingTrackingno,socialSecurity,driversLicense,billingDate,passStatus,pass_count,licensestate, productdescription,currencytype) values('{$firstname}','{$lastname}','{$phonenumber}','{$address}','C','{$chequenumber}','{$accounttype}','{$country}','{$city}','{$state}','{$zip}','{$chequetype}',{$amount},'{$dateToEnter}','{$bankname}','{$bankroutingcode}','{$bankaccountno}','{$misc}','N','P',{$i_company_id},'{$domain1}','{$voiceauth}','{$shipping}','{$socialno}','{$licenceno}','{$setbilldate}','PE',0,'{$licensestate}','{$productDescription}','{$str_currency}')";
if (!($show_sql = mysql_query($qrt_insert_details, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
$trans_id = mysql_insert_id();
func_update_rate($i_company_id, $trans_id, $cnn_cs);
if ($str_fields != "") {
$qrt_insert_details = "insert into cs_rebillingdetails (rebill_transactionid,name,surname,phonenumber,address,checkorcard,CCnumber,accounttype,country,city,state,zipcode,checktype,amount,transactionDate,bankname,bankroutingcode,bankaccountnumber,misc,cancelstatus,status,userid ,ipaddress,voiceAuthorizationno,shippingTrackingno,socialSecurity,driversLicense,billingDate,licensestate,productdescription" . $str_fields . ") values({$trans_id},'{$firstname}','{$lastname}','{$phonenumber}','{$address}','C','{$chequenumber}','{$accounttype}','{$country}','{$city}','{$state}','{$zip}','{$chequetype}',{$amount},'{$dateToEnter}','{$bankname}','{$bankroutingcode}','{$bankaccountno}','{$misc}','N','P',{$i_company_id},'{$domain1}','{$voiceauth}','{$shipping}','{$socialno}','{$licenceno}','{$setbilldate}','{$licensestate}','{$productDescription}'" . $str_values . ")";
if (!($show_sql = mysql_query($qrt_insert_details, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
}
//changed
//$transid = mysql_insert_id();
$ref_number = func_Trans_Ref_No($trans_id);
func_ins_bankrates($trans_id, $bank_check, $cnn_cs);
$updateSuccess = "";
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_number, 'transactionId', $trans_id, $cnn_cs);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
$headers = "";
$headers .= "From: Etelegate <*****@*****.**>\n";
$headers .= "X-Sender: Admin Etelegate\n";
$headers .= "X-Mailer: PHP\n";
// mailer
$headers .= "X-Priority: 1\n";
// Urgent message!
$headers .= "Return-Path: <*****@*****.**>\n";
// Return path for errors
$headers .= "Content-Type: text/plain; charset=iso-8859-1\n";
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_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 = $recur_charge;
//refnum
func_ins_bankrates($trans_id, $bank_CreditcardId, $cnn_cs);
$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;
}
$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;
