function func_insert_transactionCheckdata($array_transdetails, $company_id_val, $cnn_connection)
{
$trans_id = "";
$trans_insert_status = "";
$reference_number = "NIL";
$str_invalid_date = "";
if (count($array_transdetails) > 0) {
$authorisationno = $array_transdetails[16];
$telephoneno = $array_transdetails[7];
$format_split_date = split("/", $array_transdetails[21]);
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 = "";
}
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 = trim($array_transdetails[10]);
$CCnumber = trim($array_transdetails[11]);
$checkType = trim($array_transdetails[12]);
$accounttype = trim($array_transdetails[13]);
$bankname = trim($array_transdetails[14]);
$bankroutingcode = trim($array_transdetails[15]);
$bankaccountnumber = trim($array_transdetails[16]);
$voiceAuthorizationno = trim($array_transdetails[17]);
$shippingTrackingno = trim($array_transdetails[18]);
$socialSecurity = trim($array_transdetails[19]);
$licensestate = trim($array_transdetails[20]);
$driversLicense = trim($array_transdetails[21]);
$transactionDate = $trans_date_enter;
$billingDate = trim($array_transdetails[22]);
$misc = trim($array_transdetails[23]);
$userid = trim($company_id_val);
$qrt_insert_details = "insert into cs_transactiondetails (name,surname,address,city,state,zipcode,country,phonenumber,email,amount,checkorcard,CCnumber,checktype,accounttype,bankname,bankroutingcode,bankaccountnumber,voiceAuthorizationno,shippingTrackingno,socialSecurity,licensestate,driversLicense,transactionDate,billingDate,misc,userid,passStatus,pass_count,cancelstatus,status,declinedReason,productdescription,company_usertype,company_user_id) \n\t\t\t\tvalues('{$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']},'C','{$array_transdetails['10']}','{$array_transdetails['11']}','{$array_transdetails['12']}','{$array_transdetails['13']}','{$array_transdetails['14']}','{$array_transdetails['15']}','{$array_transdetails['16']}','{$array_transdetails['17']}','{$array_transdetails['18']}','{$array_transdetails['19']}','{$array_transdetails['20']}','{$trans_date_enter}','{$array_transdetails['22']}','{$array_transdetails['23']}',{$company_id_val},'PA',0,'N','D','Error in Data','Service',5,{$userid})";
}
if ($str_invalid_date == "") {
$auth_status = func_isauthorisationno_check($authorisationno, $telephoneno, $company_id_val, $cnn_connection);
if ($auth_status == "") {
if ($authorisationno != "" || $telephoneno != "") {
if (!($sql_insert_data = mysql_query($qrt_insert_details))) {
$trans_insert_status = "failure";
} else {
$trans_id = mysql_insert_id();
$ref_number = func_Trans_Ref_No($trans_id);
$updateSuccess = "";
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_number, 'transactionId', $trans_id, $cnn_connection);
func_update_rate($userid, $trans_id, $cnn_connection);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
$trans_insert_status = "success";
$qrt_select_company = "Select processing_currency ,bank_check 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, "transactions");
exit;
} else {
$processing_currency = mysql_result($show_sql_run, 0, 0);
$bank_check = mysql_result($show_sql_run, 0, 1);
func_ins_bankrates($trans_id, $bank_check, $cnn_connection);
if ($processing_currency == "") {
$processing_currency = "USD";
}
$updateSuccess = func_update_single_field('cs_transactiondetails', 'currencytype ', $processing_currency, 'transactionId', $trans_id, $cnn_connection);
}
}
if ($updateSuccess = 1) {
$trans_insert_status = "success";
}
}
} else {
$trans_insert_status = "success";
}
} else {
$trans_insert_status = "failure";
}
}
} else {
$trans_insert_status = $str_invalid_date;
}
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>";
}
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 = "";
}
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 = $trans_date_enter;
$billingDate = trim($array_transdetails[14]);
$firstnum = substr($CCnumber, 0, 1);
if ($firstnum == "5") {
$cardType = "Master";
} else {
$cardType = "Visa";
}
$userid = $company_id_val;
$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)\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}','{$array_transdetails['14']}',{$company_id_val},'PA',0,'N','D')";
// print $qrt_insert_details ."<br>";
}
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);
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 = mysql_result($show_sql_run, 0, 10);
$firstnum = "";
if ($processing_currency == "") {
$processing_currency = "USD";
}
$firstnum = substr($CCnumber, 0, 0);
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)";
$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 {
$trans_insert_status = $str_invalid_date;
}
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>";
}
}