File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/service/service_view.php.bak
Back
<?php include('../../cfg/db.php'); $id = $db->escape($_POST['id']); $query_vehicle_info = ""; $ind = 0; //get customer name $customer_name = ""; $individual_name = $db->sql_query("SELECT concat(`first_name`,' ',`middle_name`,' ',`last_name`,' ', IF(suffix_id < 1, '', (SELECT suffix_name FROM all_suffix WHERE id = customer.suffix_id ))) as name FROM `customer` WHERE `customer_id` = (SELECT customer_id FROM service WHERE id='$id') and status = 1 LIMIT 1"); $count_name = $individual_name -> num_rows; if($count_name > 0 ){ while($data = $individual_name->fetch_assoc()){ $customer_name = $data['name']; } } else { $corporate_name = $db->sql_query("SELECT company_name FROM `customer_corporation` WHERE `customer_id` = (SELECT customer_id FROM service WHERE id='$id') and status = 1 LIMIT 1"); $count_name = $corporate_name -> num_rows; if($count_name > 0 ){ while($data = $corporate_name->fetch_assoc()){ $customer_name = $data['company_name']; } } } $query_service_info = "SELECT s.customer_id, s.ro_number, s.serial_number, s.plate_number, s.mileage, s.customer_paid_amount, s.customer_discount, s.recommendation, s.insurance_paid_account, s.conduction_sticker, s.service_advisor, s.job_summary, s.problem_cause, s.correction, s.start_date_of_service, s.end_date_of_service, sc.name AS dealer FROM service s INNER JOIN source_company_dealer scd ON s.company_dealer_id=scd.id INNER JOIN source_company sc ON scd.company_id=sc.id WHERE s.id='$id'"; //echo $query_service_info; return; $service_info = $db -> return_result($query_service_info); $count = $db -> sql_query($query_service_info) -> num_rows; if($count == 0){ $arr_v['customer_id'] = ""; $arr_v['ro_number'] = ""; $arr_v['serial_number'] = ""; $arr_v['plate_number'] = ""; $arr_v['mileage'] = ""; $arr_v['customer_paid_amount'] = ""; $arr_v['customer_discount'] = ""; $arr_v['recommendation'] = ""; $arr_v['insurance_paid_account'] = ""; $arr_v['conduction_sticker'] = ""; $arr_v['service_advisor'] = ""; $arr_v['job_summary'] = ""; $arr_v['problem_cause'] = ""; $arr_v['correction'] = ""; $arr_v['start_date_of_service'] = ""; $arr_v['end_date_of_service'] = ""; $arr_v['dealer'] = ""; $arr_v['customer_name'] = ""; } else { foreach($service_info as $data){ $suffix = ""; $arr_v['customer_id'] = $data['customer_id']; $arr_v['ro_number'] = $data['ro_number']; $arr_v['serial_number'] = $data['serial_number']; $arr_v['plate_number'] = $data['plate_number']; $arr_v['mileage'] = $data['mileage']; $arr_v['customer_paid_amount'] = $data['customer_paid_amount']; $arr_v['customer_discount'] = $data['customer_discount']; $arr_v['recommendation'] = $data['recommendation']; $arr_v['insurance_paid_account'] = $data['insurance_paid_account']; $arr_v['conduction_sticker'] = $data['conduction_sticker']; $arr_v['service_advisor'] = $data['service_advisor']; $arr_v['job_summary'] = $data['job_summary']; $arr_v['problem_cause'] = $data['problem_cause']; $arr_v['correction'] = $data['correction']; $arr_v['start_date_of_service'] = $data['start_date_of_service']; $arr_v['end_date_of_service'] = $data['end_date_of_service']; $arr_v['dealer'] = $data['dealer']; $arr_v['customer_name'] = $customer_name; } } echo json_encode($arr_v); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings