File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/vehicle/vehicle_information.php

Back
<?php include('../../cfg/db.php'); $id = $db->escape($_POST['vehicle_id']); $query_vehicle_info = ""; if(isset($_POST['customer_id'])){ $customer_record_id = $db -> escape(trim($_POST['customer_id'])); } else { $customer_record_id = ""; } //echo $customer_record_id; return; //get customer name $customer_name = ""; $customer_email = ""; $customer_mobile = ""; $customer_type = ""; $query = "SELECT IF(ci.type = 1, concat(ci.first_name,' ',ci.middle_name,' ',ci.last_name, ' ', IF(suffix_id < 1, '', (SELECT suffix_name FROM all_suffix WHERE id = ci.suffix_id ))) ,ci.corporation_name ) as name, cc.email_1,cc.mobile_phone_1,ci.type FROM customer ci INNER JOIN customer_contact cc ON ci.id = cc.customer_id INNER JOIN customer_dms cd ON cd.customer_record_id=ci.id WHERE ci.id = (SELECT customer_record_id FROM customer_dms WHERE customer_dms_id='$customer_record_id' LIMIT 1) LIMIT 1"; // echo $query;exit; $customer_info = $db->sql_query($query); foreach($customer_info as $customer_info_data){ $customer_name = $customer_info_data['name']; $customer_email = $customer_info_data['email_1']; $customer_mobile = $customer_info_data['mobile_phone_1']; $customer_type = (intval($customer_info_data['type'])) ? 'Individual' : 'Corporate' ; } $query_vehicle_info = "SELECT v.model_no,v.customer_id, vc.name AS color, sb.name AS brand,sb.logo as brand_logo, v.engine_type, v.gas_type, sic.name AS insurance_company, sit.name AS insurance_type, DATE_FORMAT(v.insurance_expiration_date, '%M %d, %Y') AS insurance_expiration_date, sfc.name AS finance_company, scm.name AS model, scm.model_variant_description, v.plate_number, v.chassis_number, v.serial_number, v.vin_number, v.conduction_sticker, v.who_drives, v.purchase_car_as_id, DATE_FORMAT(v.delivery_date, '%M %d, %Y') AS delivery_date, v.vehicle_release_year, v.description AS descript, v.transmission, v.service_advisor, DATE_FORMAT(v.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name AS efname, e.middle_name AS emname, e.last_name AS elname, alls.suffix_name AS suffix, sdms.name AS dms, DATE_FORMAT(v.date_created, '%M %d, %Y') AS date_created, v.sales_person,sc.code as company_name, sd.code as dealer_name, DATE_FORMAT(v.finance_expiration_date, '%M %d, %Y') AS finance_expiration_date FROM vehicle v INNER JOIN vehicle_color vc ON v.color_id=vc.id INNER JOIN source_brand sb ON v.brand_id=sb.id INNER JOIN source_insurance_company sic ON v.insurance_company_id=sic.id INNER JOIN source_insurance_type sit ON v.insurance_type_id=sit.id INNER JOIN source_finance_company sfc ON v.finance_company_id=sfc.id INNER JOIN employee e ON v.upload_by=e.id INNER JOIN all_suffix alls ON e.suffix_id=alls.id INNER JOIN source_dms sdms ON v.dms_id=sdms.id INNER JOIN source_car_model scm ON v.model_id=scm.id INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE v.id='$id'"; $vehicle_info = $db -> return_result($query_vehicle_info); $count = $db -> sql_query($query_vehicle_info)->num_rows; //echo $query_vehicle_info; return; if($count == 0){ $arr_v['customer_id'] = ""; $arr_v['plate_number'] = ""; $arr_v['cs_number'] = ""; $arr_v['customer_name'] = ""; $arr_v['customer_email'] = ""; $arr_v['customer_mobile'] = ""; $arr_v['customer_type'] = ""; $arr_v['service_advisor'] = ""; $arr_v['driver'] = ""; $arr_v['brand'] = ""; $arr_v['model'] = ""; $arr_v['model_no'] = ""; $arr_v['color'] = ""; $arr_v['variant_description'] = ""; $arr_v['year_model'] = ""; $arr_v['engine_type'] = ""; $arr_v['gas_type'] = ""; $arr_v['transmission'] = ""; $arr_v['vin_number'] = ""; $arr_v['serial_number'] = ""; $arr_v['chassis_number'] = ""; $arr_v['sales_person'] = ""; $arr_v['insurance_company'] = ""; $arr_v['insurance_type'] = ""; $arr_v['insurance_expiration_date'] = ""; $arr_v['finance_company'] = ""; $arr_v['finance_expiration_date'] = ""; $arr_v['sales_person'] = ""; $arr_v['purchase_car_as'] = ""; $arr_v['delivery_date'] = ""; $arr_v['date_created'] = ""; $arr_v['date_uploaded'] = ""; $arr_v['uploaded_by'] = ""; $arr_v['dms'] = ""; $arr_v['dealer'] = ""; $arr_v['company'] = ""; $arr_v['finance_expiration_date'] = ""; $arr_v['brand_logo'] = "dist/img/brand/default.png"; } else { foreach($vehicle_info as $data){ $suffix = $data['suffix']; if($data['suffix'] == "None"){ $suffix = ""; } $arr_v['customer_id'] = $data['customer_id']; $arr_v['plate_number'] = $data['plate_number']; $arr_v['cs_number'] = $data['conduction_sticker']; $arr_v['customer_name'] = $customer_name; $arr_v['customer_email'] = $customer_email; $arr_v['customer_mobile'] = $customer_mobile; $arr_v['customer_type'] = $customer_type; $arr_v['driver'] = $data['who_drives']; $arr_v['brand'] = $data['brand']; $arr_v['model'] = $data['model']; $arr_v['model_no'] = $data['model_no']; $arr_v['color'] = $data['color']; $arr_v['variant_description'] = $data['model_variant_description']; $arr_v['year_model'] = $data['vehicle_release_year']; $arr_v['engine_type'] = $data['engine_type']; $arr_v['gas_type'] = $data['gas_type']; $arr_v['transmission'] = $data['transmission']; $arr_v['vin_number'] = $data['vin_number']; $arr_v['serial_number'] = $data['serial_number']; $arr_v['chassis_number'] = $data['chassis_number']; $arr_v['sales_person'] = $data['sales_person']; $arr_v['insurance_company'] = $data['insurance_company']; $arr_v['insurance_type'] = $data['insurance_type']; $arr_v['insurance_expiration_date'] = $data['insurance_expiration_date']; $arr_v['finance_company'] = $data['finance_company']; $arr_v['finance_expiration_date'] = $data['finance_expiration_date']; $arr_v['sales_person'] = $data['sales_person']; $arr_v['purchase_car_as'] = $data['purchase_car_as_id']; $arr_v['service_advisor'] = $data['service_advisor']; $arr_v['delivery_date'] = $data['delivery_date']; $arr_v['date_created'] = $data['date_created']; $arr_v['date_uploaded'] = $data['date_uploaded']; $arr_v['uploaded_by'] = $data['efname'] . " " . $data['emname'] . " " . $data['elname'] . " " . $suffix; $arr_v['dms'] = $data['dms']; $arr_v['dealer'] = $data['dealer_name']; $arr_v['company'] = $data['company_name']; $arr_v['brand_logo'] = "dist/img/brand/".$data['brand_logo']; // $arr_v['describe'] = $data['descript']; } } echo json_encode($arr_v); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>

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