function func_insert_transactiondata($array_transdetails, $company_id_val, $trans_type, $cnn_connection)
{
$trans_insert_status = "";
if ($trans_type == "Check") {
if (count($array_transdetails) > 0) {
$authorisationno = $array_transdetails[16];
$telephoneno = $array_transdetails[7];
$trans_date_enter = "{$array_transdetails['21']}:00";
$trans_date_enter = func_format_date_time($trans_date_enter);
$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) \n\t\t\t\t\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},'PE',0,'N','P')";
// print $qrt_insert_details ."<br>";
}
} else {
if (count($array_transdetails) > 0) {
$authorisationno = $array_transdetails[14];
$telephoneno = $array_transdetails[7];
$trans_date_enter = "{$array_transdetails['19']}:00";
$trans_date_enter = func_format_date_time($trans_date_enter);
$qrt_insert_details = "insert into cs_transactiondetails (name,surname,address,city,state,zipcode,country,phonenumber,email,amount,checkorcard,cardtype,CCnumber,cvv,validupto,voiceAuthorizationno,shippingTrackingno,socialSecurity,licensestate,driversLicense,transactionDate,billingDate,misc,userid,passStatus,pass_count,cancelstatus,status)\n\t\t\t\t\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','{$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']}','{$trans_date_enter}','{$array_transdetails['20']}','{$array_transdetails['21']}',{$company_id_val},'PE',0,'N','P')";
// print $qrt_insert_details ."<br>";
}
}
$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_insert_status = "success";
}
} else {
$trans_insert_status = "success";
}
} else {
$trans_insert_status = "failure";
}
print "<tr><td class='leftbottomright'> {$array_transdetails['0']}</td><td class='cl1'> {$array_transdetails['2']}</td><td class='cl1'> {$array_transdetails['3']}</td><td class='cl1'> {$array_transdetails['8']}</td><td class='cl1'> {$array_transdetails['7']}</td><td class='cl1'> {$authorisationno}</td><td class='cl1'> {$trans_insert_status}</td></tr>";
}
function func_get_current_date_time()
{
$str_time_difference = date("O");
$str_sign = substr($str_time_difference, 0, 1);
$str_hour_difference = substr($str_time_difference, 1, 2);
$str_minute_difference = substr($str_time_difference, 3, 2);
$str_year = date("Y");
$str_month = date("m");
$str_day = date("d");
$str_hour = date("G");
$str_minute = date("i");
$str_second = date("s");
if ($str_sign == "+") {
$str_hour = $str_hour - $str_hour_difference;
$str_minute = $str_minute - $str_minute_difference;
} else {
$str_hour = $str_hour + $str_hour_difference;
$str_minute = $str_minute + $str_minute_difference;
}
$str_return_date = date("Y m d H:i:s", mktime($str_hour, $str_minute, $str_second, $str_month, $str_day, $str_year));
$str_year = substr($str_return_date, 0, 4);
$str_month = substr($str_return_date, 5, 2);
$str_day = substr($str_return_date, 8, 2);
$str_hour = substr($str_return_date, 11, 2);
$str_minute = substr($str_return_date, 14, 2);
$str_second = substr($str_return_date, 17, 2);
$str_current_date_time = $str_year . "-" . $str_month . "-" . $str_day . " " . $str_hour . ":" . $str_minute . ":" . $str_second;
$str_current_date_time = func_format_date_time($str_current_date_time);
return $str_current_date_time;
}
