File manager

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

Back
<?php include_once("../../cfg/db.php"); include_once("../controllers/service.php"); include_once("../controllers/utility.php"); include_once("../controllers/company_dealer.php"); $service = new Service(); $utility = new Utility(); $company_dealer = new CompanyDealer(); if(!isset($_SESSION['user']['id'])){ echo "Session Expired."; exit; } $server_method = $_SERVER["REQUEST_METHOD"]; $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '4068912392351865'){ //Create //$vehicle->create_customer(12,23); } else if($apiKey === '8666047442237808' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $service_id = isset($_REQUEST['service_id']) ? $_REQUEST['service_id'] : '-1'; $vehicle_service_information = $service->read_vehicle_service_main($service_id, $db); if(count($vehicle_service_information) > 0){ $vehicle_service_information['information-service-ro-date'] = $utility->convert_sql_date_to_date_picker($vehicle_service_information['information-service-ro-date']); $vehicle_service_information['information-service-start-date'] = $utility->convert_sql_date_to_date_picker($vehicle_service_information['information-service-start-date']); $vehicle_service_information['information-service-end-date'] = $utility->convert_sql_date_to_date_picker($vehicle_service_information['information-service-end-date']); // $vehicle_service_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_service_information['mod-dd-insurance-company'], $db); // $vehicle_service_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_service_information['mod-dd-insurance-type'], $db); // $vehicle_service_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_service_information['mod-dd-finance-company'], $db); echo json_encode(array($vehicle_service_information)); }else{ echo '[]'; } } else if($apiKey === '5595117711026332'){ //Read //$vehicle->read($utility->generate_uuid($db),23); } else if($apiKey === '7524727441702708' && $utility->isPostMethod($server_method)){ //Read Service Details $service_id = isset($_REQUEST['service_id']) ? $_REQUEST['service_id'] : '-1' ; $service->read_service_details($service_id, $db); } else if($apiKey === '1066045125469611' && $utility->isPostMethod($server_method)){ //Read Vehicle Sales Details //$vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1' ; //$vehicle->read_vehicle_sales_details($vehicle_id, $db); } else if($apiKey === '3060205357561758' && $utility->isPostMethod($server_method)){ //Read Customer Interest //$customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1' ; //$vehicle->read_customer_profile_interest($customer_id,$db); } else if($apiKey === '8018849239399498' && $utility->isPostMethod($server_method)){ //Read Service DMS $service_id = isset($_REQUEST['service_id']) ? $_REQUEST['service_id'] : '-1' ; $service->read_service_dms($service_id, $db); } else if($apiKey === '3736915779452780' && $utility->isPostMethod($server_method)){ //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1' ; $vehicle->read_customer_profile_company($customer_id,$db); } else if($apiKey === '0980097059657749' && $utility->isPostMethod($server_method)){ //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1' ; $vehicle->read_customer_profile_dealer($customer_id,$db); } else if($apiKey === '4eb37a867a5811eca04200ff70631b9a'){ // $service_id = $db->escape($_REQUEST['service_id']) ; $new_record_data = $db->escape($_REQUEST['new_record_data']) ; $new_record_data = intval($new_record_data); // echo $new_record_data;exit; $array_data = json_decode($_REQUEST['service_header'],true); foreach ($array_data as $key => $value){ $array_data[$key] = strtoupper($db->escape($array_data[$key])); } $service_history = isset($_REQUEST['service_history']) ? $_REQUEST['service_history'] : array() ; // print_r($service_history);exit; //check if plate or cs exist is //get the vehicle id //fetch sercie dta //check if ro changes //check if ro already exiust if ro change // update if no problem //update plate and cs // print_r($array_data);exit; if($new_record_data){ $existing_service_id = $service->read_service_id_by_ro($array_data['service_ro_number'],$db); if($utility->isNotEmpty($existing_service_id)){ $return_arr["status"]= 2; $return_arr["message"]=" RO number is already exist."; echo json_encode($return_arr); exit; } }else{ $service_obj = $service->read_service_information($service_id,$utility,$db); $service_arr = array(); foreach($service_obj as $service_row){ $service_arr = $service_row; } // print_r($service_arr);exit; //check if current ro same in service arr ro if($service_arr['ro_number'] != $array_data['service_ro_number']){ $existing_service_id = $service->read_service_id_by_ro($array_data['service_ro_number'],$db); if($utility->isNotEmpty($existing_service_id)){ $return_arr["status"]= 2; $return_arr["message"]=" RO number is already exist."; echo json_encode($return_arr); exit; } } } if(!$utility->isNotEmpty($array_data['service_plate']) && !$utility->isNotEmpty($array_data['service_cs'])){ $return_arr["status"]= 0; // $return_arr["message"]=" Plate or CS not yet exist in vehicle record. Add vehicle record first."; $return_arr["message"]=" Plate or CS is required."; echo json_encode($return_arr); exit; }else{ $vehicle_id = $service->read_vehicle_id_by_plate_or_cs($array_data['service_plate'],$array_data['service_cs'],$db); if(!$utility->isNotEmpty($vehicle_id)){ $return_arr["status"]= 0; $return_arr["message"]=" Plate or CS not yet exist in vehicle record. Add vehicle record first."; echo json_encode($return_arr); exit; } } $company_dealer_id = $company_dealer->read_company_dealer_id($array_data['mod-dd-company'],$array_data['mod-dd-dealer'],'1',$db); if($new_record_data){ $service->create_service_information($service_id,$vehicle_id,$_SESSION['user']['id'],$company_dealer_id,$array_data,$utility,$db); }else{ $service->update_service_information($service_id,$vehicle_id,$_SESSION['user']['id'],$company_dealer_id,$array_data,$utility,$db); $service->delete_service_history_by_ro($service_arr['ro_number'],$db); } if(count($service_history) > 0){ $service_history_array = array(); $service_history = array_map(array($utility, 'upperCaseNestedArray'), $service_history); $service_history = array_map(array($db, 'escape'), $service_history); foreach ($service_history as $service_history_row){ // print_r($service_history_row); $has_value = false; foreach($service_history_row as $service_history_row_row){ if($utility->isNotEmpty($service_history_row_row)){ $has_value = true; break; } } if($has_value){ $service_history_array[] = "('".$array_data['service_ro_number']."','".$service_history_row['Job_Code']."','".$service_history_row['Cause']."','".$service_history_row['Correction']."','".$service_history_row['Job_Summary']."','".$service_history_row['Amount']."','1')"; } } $data_to_insert = implode(',',$service_history_array); // echo $data_to_insert $service->create_service_history($data_to_insert,$db); } if($utility->isNotEmpty($array_data['service_plate'])){ $service->update_vehicle_plate($vehicle_id,$array_data['service_plate'],$db); } if($utility->isNotEmpty($array_data['service_cs'])){ $service->update_vehicle_cs($vehicle_id,$array_data['service_cs'],$db); } // !$utility->isNotEmpty($array_data['service_cs'])){ $return_arr["status"]= 1; $return_arr["message"]=" Successful."; echo json_encode($return_arr); } else if($apiKey === 'READ_SERVICE_INFORMATION'){ $service_id = $db->escape($_REQUEST['service_id']) ; $service_obj = $service->read_service_information($service_id,$utility,$db); $service_arr = array(); foreach($service_obj as $service_row){ // print_r($service_row); $service_arr = array_merge($service_arr,array( 'service_cs'=>$service_row['vconduction_sticker'], 'service_plate'=>$service_row['vplate_number'], 'service_ro_number'=>$service_row['ro_number'], 'service_ro_date'=>$utility_class->convert_sql_date_to_date_picker($service_row['ro_date']), 'service_ro_amount'=>$service_row['ro_total'], 'service_discount'=>$service_row['customer_discount'], 'service_insurance_amount'=>$service_row['insurance_paid_account'], 'service_start_date'=>$utility_class->convert_sql_date_to_date_picker($service_row['start_date_of_service']), 'service_end_date'=>$utility_class->convert_sql_date_to_date_picker($service_row['end_date_of_service']), 'service_notes'=>$service_row['notes'], 'service_recommendation'=>$service_row['recommendation'], 'service_mileage'=>$service_row['mileage'], 'service_sa'=>$service_row['service_advisor'], 'service_dms_id'=>$service_row['dms_id'], 'service_dms_name'=>$service_row['dms_name'], 'service_company_id'=>$service_row['company_id'], 'service_company_name'=>$service_row['company_name'], 'service_company_code'=>$service_row['company_code'], 'service_dealer_id'=>$service_row['dealer_id'], 'service_dealer_name'=>$service_row['dealer_name'], 'service_dealer_code'=>$service_row['dealer_code'], )); } $service_arr['history'] = array(); $service_history_obj = $service->read_service_history_list($service_arr['service_ro_number'],$utility,$db); foreach($service_history_obj as $service_history_row){ $service_arr['history'] = array_merge($service_arr['history'],array($service_history_row)); } echo json_encode($service_arr); }else if($apiKey === '1895061658011882' && $utility->isPostMethod($server_method)){ //Read Customer Interest $start_date = isset($_REQUEST['startDate']) ? $db->escape($_REQUEST['startDate']) : '' ; $end_date = isset($_REQUEST['endDate']) ? $db->escape($_REQUEST['endDate']) : '' ; $company = isset($_REQUEST['company']) ? $db->escape($_REQUEST['company']) : '0' ; $return_arr["total"]= $service->read_service_total_number($start_date,$end_date,$company,$granted_company_ids,$db); echo json_encode($return_arr); } else { $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } ?>

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