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>";
}
}
exit;
} else {
$int_table = "cs_test_transactiondetails";
if ($integration_mode == "Live") {
$int_table = "cs_transactiondetails";
}
$qrt_insert_details = "insert into {$int_table} (td_product_id,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,email,productdescription,company_usertype,company_user_id,currencytype,td_is_pending_check,return_url,from_url,bank_id,td_site_ID,td_username,td_password,td_recur_next_date,td_rebillingID,td_enable_rebill) \n\t\t\tvalues('{$td_product_id}','{$firstname}','{$lastname}','{$phonenumber}','{$address}','C','" . etelEnc($chequenumber) . "','{$accounttype}','{$country}','{$city}','{$state}','{$zip}','{$chequetype}','{$amount}','{$dateToEnter}','{$bankname}','{$bankroutingcode}','{$bankaccountno}','{$misc}','N','',{$companyid},'{$ipaddress}','{$voiceauth}','{$shipping}','{$socialno}','{$licenceno}','{$setbilldate}','PE',0,'{$licensestate}','{$email}','{$productDescription}',4,{$companyid},'{$str_currency}','1','{$i_return_url}','{$from_url}','{$bank_CreditcardId}','{$site_id}','{$td_username}','{$td_password}','{$td_recur_next_date}','{$mt_subAccount}','{$td_enable_rebill}')";
if (!($show_sql = mysql_query($qrt_insert_details, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute query";
$return_message = "INT";
exit;
} else {
//changed
$trans_id = mysql_insert_id();
func_update_rate($companyid, $trans_id, $cnn_cs, "ch");
//func_ins_bankrates($trans_id,$bank_check,$cnn_cs);
$ref_number = func_Trans_Ref_No($trans_id);
$updateSuccess = "";
$updateSuccess = func_update_single_field($int_table, 'reference_number', $ref_number, 'transactionId', $trans_id, $cnn_cs);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
if ($reference_number != "") {
$return_message = "SUC";
}
//inserting data into rebilling section
$str_fields = "";
$str_values = "";
if ($str_recur_date == "Y") {
if ($str_recurdate_mode != "") {
if ($i_recur_charge != "") {
$str_fields .= ",recur_charge";
$str_values .= "," . $i_recur_charge;
}
if ($i_recur_times != "") {
$str_fields .= ",recur_times";
$str_values .= "," . $i_recur_times;
}
}
}
$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;
}
$recur_day = $str_row1[43];
$recur_week = $str_row1[44];
$recur_month = $str_row1[45];
$recur_start_date = $str_row1[46];
$recur_charge = $str_row1[47];
$recur_times = $str_row1[48];
$service_user_id = $str_row1[49];
$productdesc = $str_row1[53];
$cardExpir = explode("/", $validupto);
$year = $cardExpir[0];
$cardExpire = $cardExpir[1] . "/" . substr($year, 2, 3);
$dat = date("Y-m-d H:i:s");
$declinedreason = "Transaction Incomplete";
$str_qry_insert = "INSERT INTO cs_transactiondetails (declinedReason,transactionDate,name,surname,phonenumber,address,CCnumber,cvv,checkorcard,country,city,state,zipcode,amount,memodet,signature,bankname,bankroutingcode,bankaccountnumber,accounttype,misc ,email,cancelstatus,status,userId,Checkto,cardtype,checktype,validupto,reason,other,ipaddress,voiceAuthorizationno,shippingTrackingno,socialSecurity,driversLicense,billingDate,service_user_id,productdescription,company_usertype,bank_id) VALUES ('{$declinedreason}','{$dat}','{$name}','{$surname}','{$phonenumber}','{$address}','{$CCnumber}','{$cvv}','{$checkorcard}','{$country}','{$city}','{$state}','{$zipcode}','{$amount}','{$memodet}','{$signature}','{$bankname}','{$bankroutingcode}','{$bankaccountnumber}','{$accounttype}','{$misc}','{$email}','{$cancelstatus}','{$status}','{$userId}','{$Checkto}','{$cardtype}','{$checktype}','{$validupto}','{$reason}','{$other}','{$ipaddress}','{$voiceAuthorizationno}','{$shippingTrackingno}','{$socialSecurity}','{$driversLicense}','{$billingDate}','{$service_user_id}','{$productdesc}',7,'{$bank_CreditcardId}')";
$trans_id = mysql_insert_id();
func_update_rate($userId, $trans_id, $cnn_cs);
if (!($str_ins_result = mysql_query($str_qry_insert, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
$insertionSuccess = "YES";
$trans_id = mysql_insert_id();
$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 == "") {
