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; }