File manager

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

Back
<?php class Service { function read_vehicle_service_main($service_id, $db){ $query = "SELECT v.plate_number,v.conduction_sticker,sb.name as vehicle_brand,scm.name as vehicle_model,s.service_advisor,v.customer_record_id,s.`customer_id`,s.ro_number,s.ro_date,s.ro_total,s.customer_discount,s.insurance_paid_account,s.mileage,s.recommendation,s.notes,s.start_date_of_service,s.end_date_of_service, DATE_FORMAT(s.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name, e.last_name, sdms.name as dms_name, scy.code as company_code,sdr.code as dealer_code FROM `service` s INNER JOIN vehicle v ON s.vehicle_id = v.id INNER JOIN source_company_dealer scd ON s.company_dealer_id = scd.id INNER JOIN source_company scy ON scd.company_id = scy.id INNER JOIN source_dealer sdr ON scd.dealer_id = sdr.id INNER JOIN source_dms sdms ON scy.dms_id = sdms.id INNER JOIN employee e ON s.upload_by = e.id LEFT OUTER JOIN source_brand sb ON v.brand_id = sb.id LEFT OUTER JOIN source_car_model scm ON v.model_id = scm.id WHERE s.id = '$service_id' LIMIT 1"; // echo $query;exit; $vehicle = $db -> return_result($query); $json = array(); foreach($vehicle as $vehicle_data){ $json = [ 'customer_record_id'=> $vehicle_data['customer_record_id'], 'service-brand-top'=> $vehicle_data['vehicle_brand'], 'service-model-top'=> $vehicle_data['vehicle_model'], 'service-plate-top'=> $vehicle_data['plate_number'], 'service-cs-top'=> $vehicle_data['conduction_sticker'], 'information-service-ro-no'=> $vehicle_data['ro_number'], 'information-service-advisor'=> $vehicle_data['service_advisor'], 'information-service-ro-date'=> $vehicle_data['ro_date'], 'information-service-ro-amount'=> $vehicle_data['ro_total'], 'information-service-discount'=> $vehicle_data['customer_discount'], 'information-service-paid-account'=> $vehicle_data['insurance_paid_account'], 'information-service-mileage'=> $vehicle_data['mileage'], 'information-service-recommendation'=> $vehicle_data['recommendation'], 'information-service-notes'=> $vehicle_data['notes'], 'information-service-start-date'=> $vehicle_data['start_date_of_service'], 'information-service-end-date'=> $vehicle_data['end_date_of_service'], 'service-date-uploaded'=>$vehicle_data['date_uploaded'], 'service-dealer'=>$vehicle_data['dealer_code'], 'service-company'=>$vehicle_data['company_code'], 'service-dms'=>$vehicle_data['dms_name'], // 'sales_profileDisplay'=>"dist/img/customer/".$vehicle_data['photo_name'], 'service-uploaded-by'=>$vehicle_data['first_name']. ' '.$vehicle_data['last_name'] ]; } // echo json_encode($json); return $json; } function read_service_details($service_id, $db){ $query_read_service_details = " SELECT s.ro_number, s.ro_total, DATE_FORMAT(s.ro_date, '%m/%d/%Y') AS ro_date, s.customer_paid_amount, s.customer_discount, s.insurance_paid_account, s.mileage, s.recommendation, s.notes FROM service s WHERE s.id = '$service_id'"; $service_details = $db -> return_result($query_read_service_details); //echo $query_read_service_details; return; $json = []; foreach($service_details AS $details){ $json[] = ['ro_number'=>$details['ro_number'], 'ro_total'=>$details['ro_total'], 'ro_date'=>$details['ro_date'], 'customer_paid_amount'=>$details['customer_paid_amount'], 'customer_discount'=>$details['customer_discount'], 'insurance_paid_account'=>$details['insurance_paid_account'], 'mileage'=>$details['mileage'], 'recommendation'=>$details['recommendation'], 'notes'=>$details['notes']]; } echo json_encode($json); } // function read_vehicle_sales_details($vehicle_id, $db){ // $query_read_vehicle_sales_details = " // SELECT v.insurance_company_id, v.insurance_type_id, v.finance_company_id, v.insurance_expiration_date, v.finance_expiration_date, v.delivery_date, v.who_drives // FROM vehicle v // WHERE v.id = '$vehicle_id'"; // $vehicle_sales_details = $db -> return_result($query_read_vehicle_sales_details); //echo $query_read_vehicle_sales_details; return; // $json = []; // foreach($vehicle_sales_details AS $details){ // $json[] = ['insurance_company_id'=>$details['insurance_company_id'], 'insurance_type_id'=>$details['insurance_type_id'], 'finance_company_id'=>$details['finance_company_id'], // 'insurance_expiration_date'=>$details['insurance_expiration_date'], 'finance_expiration_date'=>$details['finance_expiration_date'], 'delivery_date'=>$details['delivery_date'], // 'who_drives'=>$details['who_drives']]; // } // echo json_encode($json); // } function read_service_dms($service_id, $db){ $query_read_service_dms = "SELECT sdms.id, sdms.name 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 = scd.id INNER JOIN source_dms sdms ON sc.`dms_id` = sdms.id WHERE s.id = '$service_id'"; $service_dmss = $db -> return_result($query_read_service_dms); //echo $query_read_service_dms; return; $json = []; foreach($service_dmss AS $sdms){ $json[] = ['service_id'=>$sdms['id'],'dms_id'=>$sdms['id'],'dms_name'=>$sdms['name']]; } echo json_encode($json); } function read_service_total_number($start_date,$end_date,$company,$granted_company_ids,$db){ $company_filter = (intval($company) === 0) ? $granted_company_ids : $company ; $date_filter = ($start_date !== '' && $end_date !== '') ? " AND se.date_uploaded BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') " : '' ; return $db -> select("SELECT SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM service se INNER JOIN vehicle v ON se.vehicle_id = v.id INNER JOIN source_company_dealer scd ON se.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE se.status = 1 AND v.status =1 AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY se.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total_count FROM `source_dms` WHERE status = 1 "); } function universal_query(){ return " SELECT %s FROM `service` s INNER JOIN vehicle v ON s.vehicle_id = v.id INNER JOIN source_company_dealer scd ON s.company_dealer_id = scd.id INNER JOIN source_company scy ON scd.company_id = scy.id INNER JOIN source_dealer sdr ON scd.dealer_id = sdr.id INNER JOIN source_dms sdms ON scy.dms_id = sdms.id INNER JOIN employee e ON s.upload_by = e.id WHERE 1 "; } function read_service_information($service_id,$utility_class,$db){ $universal_query = $this->universal_query(); $fields = " s.,v.id as vehicle_id,v.customer_record_id,v.conduction_sticker as vconduction_sticker,v.plate_number as vplate_number, sdms.id as dms_id,sdms.name as dms_name, scy.id as company_id,scy.code as company_code,scy.name as company_name,sdr.id as dealer_id,sdr.code as dealer_code,sdr.name as dealer_name"; $query = $universal_query." AND s.id = $service_id "; $query_formatted = sprintf($query,$fields); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_service_history_list($ro_number,$utility_class,$db){ $query = "SELECT FROM `service_history` WHERE 1 AND `ro_number` = '$ro_number' AND status = 1"; return $db->sql_query($query); } function read_vehicle_id_by_plate_or_cs($plate,$cs,$db){ return $db->select("SELECT id FROM `vehicle` WHERE 1 AND ((plate_number = '$plate' AND plate_number != '' AND plate_number IS NOT NULL) OR (conduction_sticker = '$cs' AND conduction_sticker != '' AND conduction_sticker IS NOT NULL)) LIMIT 1"); } function read_service_id_by_ro($ro,$db){ return $db->select("SELECT id FROM `service` WHERE 1 and `ro_number` = '$ro' LIMIT 1"); } function update_service_information($service_id,$vehicle_id,$user_id,$company_dealer_id,$array_data,$utility_class,$db){ $ro_number = $array_data['service_ro_number']; $ro_date = $utility_class->convert_sql_date($array_data['service_ro_date'],'mm/dd/yyyy'); $ro_total = $array_data['service_ro_amount']; $mileage = $array_data['service_mileage']; $recommendation = $array_data['service_recommendation']; $customer_discount = $array_data['service_discount']; $insurance_paid_account = $array_data['service_insurance_amount']; $service_advisor = strtoupper($array_data['service_sa']); $start_date_of_service = $utility_class->convert_sql_date($array_data['service_start_date'],'mm/dd/yyyy'); $end_date_of_service = $utility_class->convert_sql_date($array_data['service_end_date'],'mm/dd/yyyy'); $notes = $array_data['service_notes']; $query="UPDATE `service` SET `vehicle_id`='$vehicle_id', `ro_number`='$ro_number', `ro_date`='$ro_date', `ro_total`='$ro_total', `mileage`='$mileage', `recommendation`='$recommendation', `customer_discount`='$customer_discount', `insurance_paid_account`='$insurance_paid_account', `start_date_of_service`='$start_date_of_service', `end_date_of_service`='$end_date_of_service', `service_advisor`='$service_advisor', `notes`='$notes', `company_dealer_id`=$company_dealer_id, /`upload_by`=$user_id,/ `date_modify`=NOW(), `status`=1 WHERE 1 AND id = $service_id "; // echo $query;exit; return $db->sql_query_num_inserted($query); } function create_service_information($service_id,$vehicle_id,$user_id,$company_dealer_id,$array_data,$utility_class,$db){ $ro_number = $array_data['service_ro_number']; $ro_date = $utility_class->convert_sql_date($array_data['service_ro_date'],'mm/dd/yyyy'); $ro_total = $array_data['service_ro_amount']; $mileage = $array_data['service_mileage']; $recommendation = $array_data['service_recommendation']; $customer_discount = $array_data['service_discount']; $insurance_paid_account = $array_data['service_insurance_amount']; $service_advisor = $array_data['service_sa']; $start_date_of_service = $utility_class->convert_sql_date($array_data['service_start_date'],'mm/dd/yyyy'); $end_date_of_service = $utility_class->convert_sql_date($array_data['service_end_date'],'mm/dd/yyyy'); $notes = $array_data['service_notes']; // $query="UPDATE `service` SET // `vehicle_id`='$vehicle_id', // `ro_number`='$ro_number', // `ro_date`='$ro_date', // `ro_total`='$ro_total', // `mileage`='$mileage', // `recommendation`='$recommendation', // `customer_discount`='$customer_discount', // `insurance_paid_account`='$insurance_paid_account', // `start_date_of_service`='$start_date_of_service', // `end_date_of_service`='$end_date_of_service', // `service_advisor`='$service_advisor', // `notes`='$notes', // `company_dealer_id`=$company_dealer_id, // `upload_by`=$user_id, // `date_uploaded`=NOW(), // `status`=1 // WHERE 1 AND // id = $service_id "; $query = "INSERT INTO `service`( id, `vehicle_id`, `ro_number`, `ro_date`, `ro_total`, `mileage`, `recommendation`, `customer_discount`, `insurance_paid_account`, `start_date_of_service`, `end_date_of_service`, `service_advisor`, `notes`, `company_dealer_id`, `upload_by`, `date_uploaded`, `status`) VALUES ( UUID_SHORT(), '$vehicle_id', '$ro_number', '$ro_date', '$ro_total', '$mileage', '$recommendation', '$customer_discount', '$insurance_paid_account', '$start_date_of_service', '$end_date_of_service', '$service_advisor', '$notes', $company_dealer_id, $user_id, NOW(), 1 )"; // echo $query;exit; return $db->sql_query_num_inserted($query); } function update_vehicle_plate($vehicle_id,$plate,$db){ $db->sql_query("update ignore vehicle set plate_number = '$plate' WHERE id =$vehicle_id "); } function update_vehicle_cs($vehicle_id,$cs,$db){ $db->sql_query("update ignore vehicle set conduction_sticker = '$cs' WHERE id =$vehicle_id "); } function delete_service_history_by_ro($ro_number,$db){ $query = "DELETE FROM `service_history` WHERE 1 AND `ro_number` = '$ro_number' "; $db->sql_query($query); } function create_service_history($data_to_insert,$db){ $query="INSERT INTO `service_history`( `ro_number`, `job_code`, `problem_cause`, `correction`, `job_summary`, `amount`,`status`) VALUES ".$data_to_insert.""; // echo $query; $db->sql_query($query); } } ?>

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