File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/service/service_information.php

Back
<?php include('../../cfg/db.php'); $fmt = new NumberFormatter('PHP', NumberFormatter::CURRENCY); if(isset($_POST['customer_id'])){ $customer_record_id = $db->escape(trim($_POST['customer_id'])); } else { $customer_record_id = ""; } if(isset($_POST['service_id'])){ $id = $db->escape($_POST['service_id']); $where_data = " s.id='$id' "; } if(isset($_POST['ro_number'])){ $order_number = $db->escape($_POST['ro_number']); $where_data = " s.ro_number='$order_number' "; } $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"; $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_service_info = "SELECT %s FROM service s INNER JOIN source_brand sb ON s.brand_id = sb.id INNER JOIN source_car_model scm ON s.model_id = scm.id 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 "; $fields = " 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.code AS company,sd.code AS dealer, s.ro_total AS ro_total, DATE_FORMAT(s.ro_date, '%M %d, %Y') 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 ,sb.name as brand,scm.name as model,s.notes as service_note,s.brand_id,s.model_id "; $count_data = " count(1) "; $service_info = $db -> return_result(sprintf($query_service_info,$fields,$where_data)); $count = $db -> select(sprintf($query_service_info,$count_data,$where_data)); $get_brand_model = "SELECT sb.name as brand, scm.name as model FROM `vehicle` v INNER JOIN source_brand sb ON v.`brand_id` = sb.id INNER JOIN source_car_model scm ON v.`model_id` = scm.id WHERE 1 "; if($count == 0){ $arr_v['customer_id'] = ""; $arr_v['customer_email'] = ""; $arr_v['customer_mobile'] = ""; $arr_v['customer_type'] = ""; $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['company'] = ""; $arr_v['customer_name'] = ""; $arr_v['ro_total'] = ""; $arr_v['ro_date'] = ""; $arr_v['date_uploaded'] = ""; $arr_v['upload_by'] = ""; $arr_v['job_code'] = ""; $arr_v['model'] = ""; $arr_v['brand'] = ""; $arr_v['service_note'] = ""; } else { foreach($service_info as $data){ $car['brand'] = ""; $car['model'] = ""; if(isNotEmpty($data['plate_number']) && isNotEmpty($data['conduction_sticker'])){ $get_brand_model = $get_brand_model." AND v.plate_number='".$data['plate_number']."' OR v.conduction_sticker='".$data['conduction_sticker']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } else if(isNotEmpty($data['plate_number'])){ $get_brand_model = $get_brand_model." AND v.plate_number= '".$data['plate_number']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } else if(isNotEmpty($data['conduction_sticker'])){ $get_brand_model = $get_brand_model." AND v.conduction_sticker= '".$data['conduction_sticker']."'"; $car_info = $db -> sql_query($get_brand_model); foreach($car_info as $car_data){ $car['brand'] = $car_data['brand']; $car['model'] = $car_data['model']; } } $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['company'] = $data['company']; $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['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']; $arr_v['brand'] = (intval($data['brand_id']) <> 0) ? $data['brand'] : $car['brand']; $arr_v['model'] = (intval($data['model_id']) <> 0) ? $data['model'] : $car['model']; $arr_v['service_note'] = $data['service_note']; } } 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