File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/customer/customer_fni.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $type = $_POST['type']; $arr_has_vehicle_record = array(); if($type == 1){ $arr = $_POST['arr']; $plate_number = array(); // print_r($arr['vehicle'][0][0]); exit; // [0][0]->plate; [0][1]->cs for($i=0; $i<count($arr['vehicle']); $i++){ for($j=0; $j<2; $j++){ $check_plate = 0; $check_cs = 0; if($j == 0){ $plate_number = $arr['vehicle'][$i][$j]; // echo "Plate: " . $plate_number; exit; if(!is_null($plate_number)){ $check_plate = $db->select("SELECT COUNT(1) FROM `finance` WHERE `plate_cs_number1` = '$plate_number' OR `plate_cs_number2` = '$plate_number'"); } } else if($j == 1){ $conduction_sticker = $arr['vehicle'][$i][$j]; if(!is_null($conduction_sticker)){ $check_cs = $db->select("SELECT COUNT(1) FROM `finance` WHERE `plate_cs_number1` = '$conduction_sticker' OR `plate_cs_number2` = '$conduction_sticker'"); } } if(!$check_plate == 0 && $check_cs == 0){ if($check_plate > 0){ $get_plate = $db->select("SELECT `plate_cs_number1` FROM `finance` WHERE `plate_cs_number1` = '$plate_number'"); // putInArray($get_plate); if(!in_array($get_plate, $arr_has_vehicle_record)){ array_push($arr_has_vehicle_record, $get_plate); } } else { $get_cs = $db->select("SELECT `plate_cs_number1` FROM `finance` WHERE `plate_cs_number1` = '$conduction_sticker'"); // putInArray($get_cs); if(!in_array($get_cs, $arr_has_vehicle_record)){ array_push($arr_has_vehicle_record, $get_cs); } } } else { } } } // print_r($arr_has_vehicle_record); exit; echo json_encode($arr_has_vehicle_record); } else if($type == 2){ $arr_tr = array(); $arr = $_POST['arr']; $count_arr = count($arr); for($i=0; $i<$count_arr; $i++){ $plate_cs_number = $arr[$i]; $sql = "SELECT f.`plate_cs_number1`, f.`plate_cs_number2`, f.`policy_number`, DATE_FORMAT(f.`policy_issue_date`, '%M %d, %Y') AS issue_date, DATE_FORMAT(f.`policy_start_date`, '%M %d, %Y') AS start_date, DATE_FORMAT(f.`policy_end_date`, '%M %d, %Y') AS end_date, fibt.name AS ins_type, fis.name AS ins_company FROM `finance` f INNER JOIN `finance_ins_provider` fis ON fis.id = f.insurance_provider INNER JOIN `finance_ins_business_type` fibt ON fibt.id = f.insurance_business_type WHERE f.`plate_cs_number1` = '$plate_cs_number' OR f.`plate_cs_number2` = '$plate_cs_number'"; // echo $sql; exit; $sql_list = $db->sql_query($sql); $plate_cs_number = ""; $policy_number = ""; $issue_date = ""; $start_end_date = ""; $ins_type = ""; $ins_company = ""; foreach($sql_list AS $row){ $row['plate_cs_number1'] == "" ? $plate_cs_number = $row['plate_cs_number2'] : $plate_cs_number = $row['plate_cs_number1']; $policy_number = $row['policy_number']; $issue_date = $row['issue_date']; $start_end_date = $row['start_date'] . " - " . $row['end_date']; $insurance_type = $row['ins_type']; $insurance_company = $row['ins_company']; $table_data = "<tr> <td>".$plate_cs_number."</td> <td>".$policy_number."</td> <td>".$issue_date."</td> <td>".$start_end_date."</td> <td>".$insurance_type."</td> <td>".$insurance_company."</td> </tr>"; echo $table_data; } } } ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings