File manager

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

Back
<?php include_once("../../cfg/db.php"); if ($_SERVER["REQUEST_METHOD"] != "POST") { $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '120321837143'){ if(isset($_REQUEST['customer_id'])){ $customer_record_id = $db -> escape(trim($_REQUEST['customer_id'])); echo json_encode(getFilteredVehicleData($customer_record_id,'ASC','2',$db)); }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else if($apiKey === '257842673824423'){ if(isset($_REQUEST['search'])){ $search = $db -> escape(trim($_REQUEST['search'])); if(isNotEmpty($search)){ echo json_encode(getFilteredVehicleDataSearch($search,'ASC','2',$db)); }else{ $return_arr["message"]=" Enter Plate, CS, Serial or VIN"; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else if($apiKey === '65378465873456'){ $dms_count_query = "SELECT IF(name <> '',name,'NO BRAND') as name, ( (SELECT count(1) FROM (SELECT v.brand_id FROM vehicle v WHERE v.status = 1 ) as t2 WHERE t2.brand_id = source_brand.id ) ) as total FROM `source_brand` WHERE status = 1 OR id = 0 ORDER BY name ASC"; $dms_count = $db -> return_result($dms_count_query); $result_arr["vehicle_by_brand_count"] = array(); foreach($dms_count as $data){ $result_arr["vehicle_by_brand_count"] = array_merge($result_arr["vehicle_by_brand_count"], array(array( 'brand' => (isNotEmpty(trim($data['name']))) ? $data['name'] : "NO BRAND" , 'count' => number_format($data['total']), ))); } echo json_encode($result_arr); return; }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } function getFilteredVehicleData($customer_record_id,$order_by,$sort_by,$db){ $customer_id = " AND v.customer_record_id = $customer_record_id "; switch(intval($sort_by)){ case 1: //lastname $filter_sort_by = " c.last_name "; break; case 2: //firstname $filter_sort_by = " c.first_name "; break; case 3: //corporation name $filter_sort_by = " c.corporation_name "; break; case 4: //date created $filter_sort_by = " v.date_created "; break; case 5: //date uploaded $filter_sort_by = " v.date_uploaded "; break; } $return_data['vehicle'] = array(); $query = "SELECT %s FROM vehicle v INNER JOIN source_brand sb ON v.brand_id=sb.id INNER JOIN vehicle_color vc ON v.color_id=vc.id INNER JOIN source_car_model scm ON v.model_id=scm.id INNER JOIN source_company_dealer scd ON scd.id=v.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id= scd.dealer_id INNER JOIN source_dms sdms ON v.dms_id = sdms.id INNER JOIN employee e ON v.upload_by = e.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id WHERE 1 %s /* customer_ids / AND v.status = 1 GROUP BY v.id ORDER BY $filter_sort_by $order_by"; $count = " count(1) "; $fields = " v.id, scm.name AS model, v.plate_number, v.conduction_sticker, sb.name AS brand, vc.name AS color, v.customer_id, vc.name as color_name,sc.code as company_name, sd.code as dealer_name,sdms.name as dms_name,v.vehicle_release_year,v.engine_type,v.gas_type,v.transmission,v.chassis_number,v.serial_number,v.vin_number,v.sales_person, scm.model_variant_description,v.date_uploaded,concat(e.first_name,' ',e.last_name) as upload_by, v.date_created, IF( c.type = 1, concat(c.first_name,' ',c.middle_name,' ',c.last_name),c.corporation_name ) as name "; // echo sprintf($query, $fields,$customer_id,$brand,$model,$customertype,$filter_upload_by,$state, $city,$gender,$filter_age,$dms,$company,$dealer,$filter_date_upload,$filter_date_created,$filter_dob);exit; $data_list = $db -> sql_query(sprintf($query, $fields,$customer_id)); $query_count = $db -> select("SELECT COUNT() FROM ( ".sprintf($query, $count,$customer_id)." ) as total_count"); if( $query_count > 0){ $record_counter = 1; foreach ($data_list as $data){ $data = array_map("replaceNull", $data); // $return_data = array_merge($return_data,array(array('No.'=>$record_counter++,'Brand'=>$data['brand'],'Model'=>$data['model'],'CS Number'=>$data['conduction_sticker'],'Plate Number'=>$data['plate_number'],'Owner'=>$data['name']))); $return_data['vehicle'] = array_merge($return_data['vehicle'] ,array(array( // 'No.'=>$record_counter++, 'record_id'=>$data['id'], 'customer_no'=>$data['customer_id'], 'brand'=>$data['brand'], 'model'=>$data['model'], 'model_description'=>$data['model_variant_description'], 'color'=>$data['color_name'], 'conduction_sticker'=>$data['conduction_sticker'], 'plate_number'=>$data['plate_number'], 'year_model'=>$data['vehicle_release_year'], 'engine_type'=>$data['engine_type'], 'gas_type'=>$data['gas_type'], 'transmission'=>$data['transmission'], 'vin'=>$data['vin_number'], 'serial_number'=>$data['serial_number'], 'chassis_number'=>$data['chassis_number'], 'sales_person'=>$data['sales_person'], 'dms'=>$data['dms_name'], 'company'=>$data['company_name'], 'dealer'=>$data['dealer_name'], 'date_created'=>$data['date_created'], 'date_uploaded'=>$data['date_uploaded'], 'upload_by'=>$data['upload_by'], ))); } $return_data['found'] =$query_count." Record".((intval($query_count) < 2) ? '' : 's' )." Found"; }else{ $return_data['found'] = "No Record Found"; // $return_data = array_merge($return_data,array(array('Brand'=>'','Model'=>'','CS Number'=>'','Plate Number'=>'','Owner'=>''))); } $return_data['total'] = $query_count; return array($return_data); } function getFilteredVehicleDataSearch($search,$order_by,$sort_by,$db){ $search = alphaNumericOnly($search); switch(intval($sort_by)){ case 1: //lastname $filter_sort_by = " c.last_name "; break; case 2: //firstname $filter_sort_by = " c.first_name "; break; case 3: //corporation name $filter_sort_by = " c.corporation_name "; break; case 4: //date created $filter_sort_by = " v.date_created "; break; case 5: //date uploaded $filter_sort_by = " v.date_uploaded "; break; } $return_data['vehicle'] = array(); $query = "SELECT %s FROM vehicle v INNER JOIN source_brand sb ON v.brand_id=sb.id INNER JOIN vehicle_color vc ON v.color_id=vc.id INNER JOIN source_car_model scm ON v.model_id=scm.id INNER JOIN source_company_dealer scd ON scd.id=v.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id= scd.dealer_id INNER JOIN source_dms sdms ON v.dms_id = sdms.id INNER JOIN employee e ON v.upload_by = e.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id WHERE IFNULL(v.plate_number,'') = '%s' OR IFNULL(v.conduction_sticker,'') = '%s' OR IFNULL(v.serial_number,'') = '%s' OR IFNULL(v.vin_number,'') = '%s' AND v.status = 1 GROUP BY v.id ORDER BY $filter_sort_by $order_by"; $count = " count(1) "; $fields = " v.id, scm.name AS model, v.plate_number, v.conduction_sticker, sb.name AS brand, vc.name AS color, v.customer_id, vc.name as color_name,sc.code as company_name, sd.code as dealer_name,sdms.name as dms_name,v.vehicle_release_year,v.engine_type,v.gas_type,v.transmission,v.chassis_number,v.serial_number,v.vin_number,v.sales_person, scm.model_variant_description,v.date_uploaded,concat(e.first_name,' ',e.last_name) as upload_by, v.date_created, IF( c.type = 1, concat(c.first_name,' ',c.middle_name,' ',c.last_name),c.corporation_name ) as name "; $data_list = $db -> sql_query(sprintf($query, $fields,$search,$search,$search,$search)); $query_count = $db -> select("SELECT COUNT(1) FROM ( ".sprintf($query, $count,$search,$search,$search,$search)." ) as total_count"); if( $query_count > 0){ $record_counter = 1; foreach ($data_list as $data){ $data = array_map("replaceNull", $data); // $return_data = array_merge($return_data,array(array('No.'=>$record_counter++,'Brand'=>$data['brand'],'Model'=>$data['model'],'CS Number'=>$data['conduction_sticker'],'Plate Number'=>$data['plate_number'],'Owner'=>$data['name']))); $return_data['vehicle'] = array_merge($return_data['vehicle'] ,array(array( // 'No.'=>$record_counter++, 'record_id'=>$data['id'], 'customer'=> $data['name'] , 'customer_no'=>$data['customer_id'], 'brand'=>$data['brand'], 'model'=>$data['model'], 'model_description'=>$data['model_variant_description'], 'color'=>$data['color_name'], 'conduction_sticker'=>$data['conduction_sticker'], 'plate_number'=>$data['plate_number'], 'year_model'=>$data['vehicle_release_year'], 'engine_type'=>$data['engine_type'], 'gas_type'=>$data['gas_type'], 'transmission'=>$data['transmission'], 'vin'=>$data['vin_number'], 'serial_number'=>$data['serial_number'], 'chassis_number'=>$data['chassis_number'], 'sales_person'=>$data['sales_person'], 'dms'=>$data['dms_name'], 'company'=>$data['company_name'], 'dealer'=>$data['dealer_name'], 'date_created'=>$data['date_created'], 'date_uploaded'=>$data['date_uploaded'], 'upload_by'=>$data['upload_by'], ))); } $return_data['found'] =$query_count." Record".((intval($query_count) < 2) ? '' : 's' )." Found"; }else{ $return_data['found'] = "No Record Found"; // $return_data = array_merge($return_data,array(array('Brand'=>'','Model'=>'','CS Number'=>'','Plate Number'=>'','Owner'=>''))); } $return_data['total'] = $query_count; return array($return_data); } function isNotEmpty($data){ return preg_match('/\S/', $data); } function quote($str) { return sprintf("'%s'", $str); } function alphaNumericOnly($s){ return preg_replace("/[^a-zA-Z0-9]+/", "", $s); } function replaceNull($s){ return ($s <> null ) ? $s : '' ; } ?>

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