File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/service/vehicle_service_information.php.bak

Back
<?php include('../../cfg/db.php'); $ro_number = $db->escape($_POST['ro_number']); $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); //echo $id; return; //get customer name if(isset($_POST['cust_id'])){ $customer_record_id = $db->escape(trim($_POST['cust_id'])); } else { $customer_record_id = ""; } //echo $customer_record_id; return; $customer_name = ""; $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 FROM customer ci 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"; $customer_name = $db->select($query); $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, DATE_FORMAT(s.start_date_of_service, '%M %d, %Y') AS start_date_of_service, DATE_FORMAT(s.end_date_of_service, '%M %d, %Y') AS end_date_of_service, sc.name AS dealer, s.ro_total AS ro_total, s.ro_date AS ro_date, s.upload_by, DATE_FORMAT(s.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, sdms.name AS dms, e.first_name AS efname, e.middle_name AS emname, e.last_name AS elname, alls.suffix_name AS suffix, s.job_code 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 INNER JOIN source_dealer sd ON scd.dealer_id=sd.id INNER JOIN source_dms sdms ON s.dms_id=sdms.id INNER JOIN employee e ON s.upload_by=e.id INNER JOIN all_suffix alls ON e.suffix_id=alls.id WHERE s.ro_number='$ro_number'"; //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['date_range'] = ""; $arr_v['dealer'] = ""; $arr_v['customer_name'] = ""; $arr_v['ro_total'] = ""; $arr_v['ro_date'] = ""; $arr_v['date_uploaded'] = ""; $arr_v['upload_by'] = ""; $arr_v['job_code'] = ""; } else { foreach($service_info as $data){ $suffix = $data['suffix']; $date_range = ""; if($data['suffix'] == "None"){ $suffix = ""; } if(($data['start_date_of_service']) && ($data['end_date_of_service']) != ""){ $date_range = $data['start_date_of_service'] . " to " . $data['end_date_of_service']; } else { //$date_range = $data['start_date_of_service'] . " to " . $data['end_date_of_service']; $date_range = ""; } $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'] <> '' ) ? $fmt->formatCurrency($data['customer_paid_amount'], "Php") : ""; $arr_v['customer_discount'] = ($data['customer_discount'] <> '' ) ? $fmt->formatCurrency($data['customer_discount'], "Php") : ""; $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['date_range'] = $date_range; $arr_v['dealer'] = $data['dealer']; $arr_v['customer_name'] = $customer_name; $arr_v['ro_total'] = ($data['ro_total'] <> '' ) ? $fmt->formatCurrency($data['ro_total'], "Php") : ""; $arr_v['ro_date'] = $data['ro_date']; $arr_v['dms'] = $data['dms']; $arr_v['date_uploaded'] = $data['date_uploaded']; $arr_v['upload_by'] = $data['efname'] . " " . $data['emname'] . " " . $data['elname'] . " " . $suffix; $arr_v['job_code'] = $data['job_code']; } } 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