File manager

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

Back
<?php class Vehicle { // function create_vehicle($vehicle_id, $customer_number, $plate_number, $conduction_sticker, $brand_id, $model_id, $color_id, $model_description, $vin, $year_model, $serial_number, // $reg_number, $engine_type, $gas_type, $transmission, $type, $dms_id, $company_id, $dealer_id, $db){ // $query = " // SELECT id // FROM source_company_dealer // WHERE company_id='$company_id' AND dealer_id='$dealer_id' AND type='1'"; // $comp_deal_id = $db -> return_result($query); //echo $query; return; // $compdeal_id = ""; // foreach($comp_deal_id AS $cdi){ // $compdeal_id = $cdi['id']; // } // $customer_id = $customer_number . $dms_id . $compdeal_id; // //create vehicle // $create_vehicle_query = " // INSERT IGNORE INTO `vehicle` (`id`, `customer_id`, `plate_number`, `conduction_sticker`, `brand_id`, `model_id`, `color_id`, `model_variant_description`, `vin_number`, `vehicle_release_year`, // `serial_number`, `registration_number`, `engine_type`, `gas_type`, `transmission`, `vehicle_type_id`) // VALUES ('$vehicle_id', '$customer_id', '$plate_number', '$conduction_sticker', '$brand_id', '$model_id', '$color_id', '$model_description', '$vin', '$year_model', '$serial_number', // '$reg_number', '$engine_type', '$gas_type', '$transmission', '$type')"; // $rows_affected_vehicle = $db->sql_query_num_inserted($create_vehicle_query); //echo $create_vehicle_query; // return $rows_affected_vehicle; // } // pending function create_vehicle($id, $customer_dms_id, $customer_record_id, $color_id, $engine_type, $gas_type, $brand_id, $model_id, $model_no, $model_variant_description, $plate_number, $chassis_number, $serial_number, $vin_number, $conduction_sticker, $who_drives, $purchase_car_as_id, $delivery_date, $vehicle_release_year, $transmission, $vehicle_type_id, $registration_number, $release_number, $company_dealer_id, $upload_by, $status, $array_data, $db) { $query = "INSERT IGNORE INTO `vehicle`(`id`, `customer_id`, `customer_record_id`, `color_id`, `engine_type`, `gas_type`, `brand_id`, `model_id`, `model_no`, `model_variant_description`, `plate_number`, `chassis_number`, `serial_number`, `vin_number`, `conduction_sticker`,`official_receipt`, `certificate_of_registration`,`who_drives`, `purchase_car_as_id`, `delivery_date`, `date_created`, `time_created`, `vehicle_release_year`, `transmission`, `vehicle_type_id`, `registration_number`, `release_number`, `company_dealer_id`, `upload_by`, `date_uploaded`, `status`) VALUES ('$id','$customer_dms_id','$customer_record_id','$color_id','$engine_type','$gas_type','$brand_id','$model_id','$model_no','$model_variant_description',NULLIF('$plate_number', ''),'$chassis_number','$serial_number','$vin_number',NULLIF('$conduction_sticker', ''),NULLIF('" . $array_data['or'] . "', ''),NULLIF('" . $array_data['cr'] . "', ''),'$who_drives','$purchase_car_as_id','$delivery_date',NOW(),NOW(),'$vehicle_release_year','$transmission','$vehicle_type_id','$registration_number','$release_number','$company_dealer_id','$upload_by',NOW(),'$status')"; // echo $query; return $db->sql_query_num_inserted($query); } // pending function read_orcr_plate_entry($vehicle_id, $type, $db) { $query = "SELECT COUNT(1) FROM `vehicle_orcr_plate_status` WHERE 1 AND vehicle_id = '$vehicle_id' AND `type` IN ('$type')"; return $db->select($query); } function create_orcr_plate_entry($vehicle_id, $user_id, $type, $db) { $query = "INSERT INTO `vehicle_orcr_plate_status`(`vehicle_id`, `user_id`,`date_added`, `type`, `status`) VALUES ('$vehicle_id','$user_id',NOW(),'$type','1')"; return $db->sql_query($query); } function update_vehicle($id, $customer_dms_id, $customer_record_id, $color_id, $engine_type, $gas_type, $brand_id, $model_id, $model_no, $model_variant_description, $plate_number, $chassis_number, $serial_number, $vin_number, $conduction_sticker, $who_drives, $purchase_car_as_id, $delivery_date, $vehicle_release_year, $transmission, $vehicle_type_id, $registration_number, $release_number, $company_dealer_id, $modified_by, $status, $array_data, $db) { $query = "UPDATE `vehicle` SET `customer_id` = '$customer_dms_id', `customer_record_id` = '$customer_record_id' , `color_id` = '$color_id', `engine_type`='$engine_type' , `gas_type`='$gas_type' , `brand_id`= '$brand_id', `model_id`= '$model_id', `model_no`= '$model_no', `model_variant_description`= '$model_variant_description', `plate_number`= NULLIF('$plate_number', ''), `chassis_number`='$chassis_number' , `serial_number`= '$serial_number', `vin_number`='$vin_number' , `conduction_sticker`=NULLIF('$conduction_sticker', '') , `official_receipt`=NULLIF('" . $array_data['or'] . "', '') , `certificate_of_registration`= NULLIF('" . $array_data['cr'] . "', '') , `who_drives`='$who_drives' , `purchase_car_as_id`= '$purchase_car_as_id', `delivery_date`='$delivery_date' , `vehicle_release_year`='$vehicle_release_year' , `transmission`= '$transmission', `vehicle_type_id`='$vehicle_type_id' , `registration_number`='$registration_number' , `release_number`= '$release_number', `company_dealer_id`='$company_dealer_id' , `modified_by`='$modified_by' , `date_modified`=NOW() , `status` ='$status' WHERE id = '$id' "; // echo $query;exit; return $db->sql_query_num_inserted($query); } //----------------------------------------------------------------------------FETCH READ--------------// function read_vehicle_details($vehicle_id, $db) { $query_read_vehicle_details = " SELECT v.customer_id, v.plate_number, v.conduction_sticker, v.brand_id, v.model_id, v.color_id, v.vehicle_type_id, v.vin_number, v.vehicle_release_year, v.engine_type, v.gas_type, v.transmission, v.serial_number, v.registration_number, v.model_variant_description, v.vehicle_type_id FROM vehicle v WHERE v.id = '$vehicle_id'"; $vehicle_details = $db->return_result($query_read_vehicle_details); //echo $query_read_vehicle_details; return; $json = array(); foreach ($vehicle_details as $details) { $json = [ 'mod-customer-number' => $details['customer_id'], 'mod-plate-number' => $details['plate_number'], 'mod-cs-number' => $details['conduction_sticker'], 'mod-dd-brand' => $details['brand_id'], 'mod-dd-model' => $details['model_id'], 'mod-dd-color' => $details['color_id'], 'mod-model-description' => $details['model_variant_description'], 'mod-dd-type' => $details['vehicle_type_id'], 'mod-vin-number' => $details['vin_number'], 'mod-year-model' => $details['vehicle_release_year'], 'mod-engine-type' => $details['engine_type'], 'mod-gas-type' => $details['gas_type'], 'mod-transmission' => $details['transmission'], 'mod-serial-number' => $details['serial_number'], 'mod-reg-number' => $details['registration_number'] ]; } return $json; } function read_vehicle_sales_details($vehicle_id, $db) { } function delete_vehicle($vehicle_id, $db) { $query = $db->sql_query("SELECT conduction_sticker,plate_number FROM vehicle WHERE id = $vehicle_id LIMIT 1"); $vehicle_data = array(); foreach ($query as $row) { $vehicle_data = $row; } $status = 0; if (count($vehicle_data) > 0) { $status = $db->sql_query_num_inserted("UPDATE vehicle SET plate_number = NULL, conduction_sticker = NULL, deleted_plate_number = '" . $vehicle_data['plate_number'] . "', deleted_conduction_sticker = '" . $vehicle_data['conduction_sticker'] . "',status = 0 WHERE id = $vehicle_id "); } if ($status > 0) { $json_array['status'] = 1; $json_array['message'] = 'Vehicle successfully removed.'; } else { $json_array['status'] = 0; $json_array['message'] = 'Vehicle not remove, please try again.'; } return $json_array; } function read_vehicle_dms($vehicle_id, $db) { $query_read_vehicle_dms = " SELECT sdms.id AS dms_id, sc.id AS company_id, sd.id AS dealer_id /SELECT sdms.id AS dms_id, sdms.name AS dms_name, sc.code AS company_code, sc.name AS company_name, sd.code AS dealer_code, sd.name AS dealer_name / FROM `vehicle` v INNER JOIN source_company_dealer scd ON scd.id = v.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dms sdms ON sc.dms_id = sdms.id INNER JOIN source_dealer sd ON sd.id = scd.dealer_id WHERE v.id = '$vehicle_id'"; $vehicle_dmss = $db->return_result($query_read_vehicle_dms); //echo $query_read_vehicle_dms; return; $json = []; foreach ($vehicle_dmss as $vdms) { $json[] = ['dms_id' => $vdms['dms_id'], 'company_id' => $vdms['company_id'], 'dealer_id' => $vdms['dealer_id']]; // $json[] = ['vehicle_id'=>$vdms['id'],'dms_id'=>$vdms['dms_id'],'dms_name'=>$vdms['dms_name'], 'company_code'=>$vdms['company_code'], 'company_name'=>$vdms['company_name'], // 'dealer_code'=>$vdms['dealer_code'], 'dealer_name'=>$vdms['dealer_name']]; } echo json_encode($json); } function read_vehicle_cs_if_exist($cs, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `conduction_sticker` = '$cs'"; return $db->sql_query($query)->num_rows; } function read_vehicle_plate_number_if_exist($plate_number, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `plate_number` = '$plate_number'"; return $db->sql_query($query)->num_rows; } function read_vehicle_vin_if_exist($vin, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `vin_number` = '$vin'"; return $db->sql_query($query)->num_rows; } function read_vehicle_serial_number_if_exist($serial_number, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `serial_number` = '$serial_number'"; return $db->sql_query($query)->num_rows; } function read_vehicle_id_by_conduction_sticker($conduction_sticker, $db) { $query = "SELECT `id` FROM `vehicle` WHERE `conduction_sticker` = '$conduction_sticker' "; return $db->select($query); } function read_vehicle_id_by_plate_number($plate_number, $db) { $query = "SELECT `id` FROM `vehicle` WHERE `plate_number` = '$plate_number' "; return $db->select($query); } function read_vehicle_profile($id, $db) { $vehicle = $db->return_result("SELECT v., sd.name as dms_name, sc.name as company_name, sdr.name as dealer_name, sd.id as dms_id, sc.id as company_id, sdr.id as dealer_id FROM `vehicle` v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN source_dms sd ON sc.dms_id = sd.id INNER JOIN source_dealer sdr ON scd.dealer_id = sdr.id WHERE v.`id` = '$id' "); $json = array(); foreach ($vehicle as $vehicle_data) { $json = [ 'mod-dd-brand' => $vehicle_data['brand_id'], 'mod-dd-model' => $vehicle_data['model_id'], 'mod-model-description' => $vehicle_data['model_variant_description'], 'mod-model-number' => $vehicle_data['model_no'], 'mod-cs-number' => $vehicle_data['conduction_sticker'], 'mod-plate-number' => $vehicle_data['plate_number'], 'mod-or' => $vehicle_data['official_receipt'], 'mod-cr' => $vehicle_data['certificate_of_registration'], 'mod-vin-number' => $vehicle_data['vin_number'], 'mod-dd-color' => $vehicle_data['color_id'], 'mod-dd-model-variant' => $vehicle_data['model_variant_description'], 'mod-transmission' => $vehicle_data['transmission'], 'mod-dd-type' => $vehicle_data['vehicle_type_id'], 'mod-engine-type' => $vehicle_data['engine_type'], 'mod-gas-type' => $vehicle_data['gas_type'], 'mod-year-model' => $vehicle_data['vehicle_release_year'], 'mod-reg-number' => $vehicle_data['registration_number'], 'mod-customer-number' => $vehicle_data['customer_record_id'], 'mod-dd-dms-name' => $vehicle_data['dms_name'], 'mod-dd-company-name' => $vehicle_data['company_name'], 'mod-dd-dealer-name' => $vehicle_data['dealer_name'], 'mod-dd-dms' => $vehicle_data['dms_id'], 'mod-dd-company' => $vehicle_data['company_id'], 'mod-dd-dealer' => $vehicle_data['dealer_id'] ]; } // echo json_encode($json); return $json; } function read_vehicle_profile_main($id, $db) { $vehicle = $db->return_result("SELECT DATE_FORMAT(v.date_modified, '%M %d, %Y - %h:%i:%s %p') AS date_modified, em.first_name AS emfname, em.middle_name AS emmname, em.last_name AS emlname, v.id,sb.id as brand_id,sb.name as brand_name, scm.id as model_id,scm.name as model_name,v.model_no, scmv.name as model_variant, v.conduction_sticker,v.plate_number,v.vin_number,v.registration_number,vc.id as color_id,vc.name as color_name, v.vehicle_release_year, vt.id as transmission_id,vt.name as transmission_name,vtype.id as vehicle_type_id,vtype.name as vehicle_type_name,sb.logo as brand_logo, v.engine_type,v.gas_type,sd.name as dms_name,sc.code as company_code, sc.name as company_name ,sdl.code dealer_code, sdl.name dealer_name, DATE_FORMAT(v.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name, e.last_name 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 INNER JOIN vehicle_color vc ON v.color_id = vc.id INNER JOIN vehicle_transmission vt ON v.transmission = vt.id INNER JOIN vehicle_type vtype ON v.vehicle_type_id = vtype.id LEFT OUTER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id LEFT OUTER JOIN source_company sc ON scd.company_id=sc.id LEFT OUTER JOIN source_dealer sdl ON scd.dealer_id=sdl.id LEFT OUTER JOIN source_dms sd ON sc.dms_id = sd.id INNER JOIN employee e ON v.upload_by = e.id LEFT OUTER JOIN employee em ON v.modified_by=em.id LEFT OUTER JOIN source_car_model_variant scmv ON v.model_variant_description = scmv.id WHERE v.`id` = '$id' "); $json = array(); foreach ($vehicle as $vehicle_data) { $json = [ 'information-vehicle-brand' => $vehicle_data['brand_name'], 'information-vehicle-model' => $vehicle_data['model_name'], 'information-vehicle-model-number' => $vehicle_data['model_no'], 'information-vehicle-model-variant' => $vehicle_data['model_variant'], 'information-vehicle-cs' => $vehicle_data['conduction_sticker'], 'information-vehicle-plate' => $vehicle_data['plate_number'], 'information-vehicle-vin' => $vehicle_data['vin_number'], 'information-vehicle-color' => $vehicle_data['color_name'], 'information-vehicle-reg-no' => $vehicle_data['registration_number'], 'information-vehicle-transmission' => $vehicle_data['transmission_name'], 'information-vehicle-type' => $vehicle_data['vehicle_type_name'], 'information-vehicle-engine-type' => $vehicle_data['engine_type'], 'information-vehicle-gas-type' => $vehicle_data['gas_type'], 'information-vehicle-year-model' => $vehicle_data['vehicle_release_year'], 'vehicle-date-uploaded' => $vehicle_data['date_uploaded'], 'vehicle-dealer' => $vehicle_data['dealer_code'], 'vehicle-company' => $vehicle_data['company_code'], 'vehicle-dms' => $vehicle_data['dms_name'], 'profileDisplay' => $vehicle_data['brand_logo'], 'vehicle-uploaded-by' => $vehicle_data['first_name'] . ' ' . $vehicle_data['last_name'], 'information_modified_by' => $vehicle_data['emfname'] . ' ' . $vehicle_data['emlname'], 'information_date_modified' => $vehicle_data['date_modified'] ]; } // echo json_encode($json); return $json; } function read_model_name_by_id($id, $db) { return $db->select("SELECT name FROM `source_car_model` WHERE status = 1 AND `id` = '$id'"); } function read_customer_profile_display($customer_id, $granted_company_ids, $db) { $query = "SELECT ci.id, ci.corporation_name,ci.first_name, ci.middle_name, ci.last_name, DATE_FORMAT(ci.date_created, '%M %d, %Y') AS date_created, cc.email_1, cc.email_2, cc.mobile_phone_1, cc.mobile_phone_2, cc.residential_phone, cc.fax_phone, cc.business_phone, cc.landline, DATE_FORMAT(ci.date_of_birth, '%M %d, %Y') AS birthdate, cc.address_1, cc.address_2, acity1.citymunDesc AS address_1_city, acity2.citymunDesc AS address_2_city, cc.address_1_postal, cc.address_2_postal, ci.photo, ci.spouse_name, ci.type, cc.viber, cc.facebook, cc.instagram, cc.whatsapp, cc.telegram, cc.website, ( IF( ci.category_id <> 0,ccat.name, IF( COUNT(v.id) > 0 && COUNT(s.id) < 1, 'SVO', IF( COUNT(se.id) < 1 && COUNT(s.id) > 0, 'SAO', IF( COUNT(v.id) = 1 && COUNT(se.id) > 0 && COUNT(s.id) > 0, 'LYL', IF( COUNT(v.id) > 1 && COUNT(v.id) < 4, 'SLY', IF( COUNT(v.id) > 3, 'VIP','None'/VVIP/ ) ) ) ) ) ) ) as customer_category, IF( (SELECT DATEDIFF(NOW(),se.start_date_of_service) <= 365) \|\| (SELECT DATEDIFF(NOW(),s.activity_date) <= 365) , '1','2' ) as isActive, sct.name as customer_type, ci.aha_status FROM customer ci LEFT OUTER JOIN customer_category ccat ON ci.category_id = ccat.id LEFT OUTER JOIN customer_contact cc ON ci.id=cc.customer_id LEFT OUTER JOIN customer_dms cd ON ci.id=cd.customer_record_id LEFT OUTER JOIN all_city acity1 ON cc.address_1_city=acity1.id LEFT OUTER JOIN all_city acity2 ON cc.address_2_city=acity2.id LEFT OUTER JOIN source_customer_type sct ON ci.type=sct.id LEFT OUTER JOIN vehicle v ON cd.customer_dms_id = v.customer_id LEFT OUTER JOIN sales s ON v.id = s.vehicle_id LEFT OUTER JOIN service se ON v.id = se.vehicle_id WHERE ci.id='$customer_id' ORDER BY ci.id ASC LIMIT 1"; // echo $query; $customer_info = $db->return_result($query); foreach ($customer_info as $data) { $get_image_query = "SELECT vi.name FROM vehicle v INNER JOIN vehicle_images vi ON v.id = vi.vehicle_id INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id WHERE 1 AND v.customer_record_id ='" . $data['id'] . "' AND v.customer_record_id <> 0 AND scd.company_id IN (" . $granted_company_ids . ") AND vi.name <> 'default.png' AND vi.status <> 0 AND v.status <> 0 ORDER BY v.id DESC LIMIT 1"; // echo $get_image_query; $get_image_name = $db->select($get_image_query); if ($get_image_name <> '') { $data['photo'] = $get_image_name; } $arr['photo'] = $data['photo']; // $arr['full_name'] = $data['first_name'] . " " . $data['middle_name'] . " " . $data['last_name'] . " " . $suffix; // $arr['main_first_name'] = $data['first_name']; // $arr['main_middle_name'] = $data['middle_name']; // $arr['main_last_name'] = $data['last_name']; // $arr['main_corporation_name'] = $data['corporation_name']; // $arr['suffix'] = $suffix; $arr['main_email'] = $data['email_1']; $arr['main_customer_email_2'] = $data['email_2']; // $arr['information_religion'] = $data['religion']; $arr['main_customer_mobile'] = $data['mobile_phone_1']; $arr['main_customer_landline'] = $data['landline']; $arr['main_customer_mobile_2'] = $data['mobile_phone_2']; $arr['main_customer_home_mobile'] = $data['residential_phone']; // $arr['fax_phone'] = $data['fax_phone']; $arr['main_customer_business_mobile'] = $data['business_phone']; $arr['main_customer_type'] = $data['customer_type']; // $arr['information_gender'] = $data['gender_name']; // $arr['information_date_created'] = $data['date_created']; // // $arr['information_dob'] = $data['birthdate']; // // $arr['information_nationality'] = $data['nationality']; // $arr['no_of_children'] = $data['no_of_children']; // $arr['information_age'] = $data['age_number']; // $arr['information_position'] = $data['occupation']; // $arr['information_marital_status'] = $data['marital_status']; // $arr['information_spouse'] = $data['spouse_name']; // $arr['source_name'] = $data['sources']; // $arr['mode_of_contact'] = $data['mode_of_contact']; // $arr['contact_person'] = $data['contact_person']; // $arr['time_created'] = $data['time_created']; // $arr['information_source_company'] = $data['source_company']; // $arr['information_source_dealer'] = $data['source_dealer']; // $arr['information_source_dms'] = $data['source_dms']; $arr['main_address_1'] = $data['address_1']; $arr['main_address_2'] = $data['address_2']; $arr['main_city_1'] = $data['address_1_city']; $arr['main_city_2'] = $data['address_2_city']; // $arr['main_state_1'] = $data['address_1_state']; // $arr['main_state_2'] = $data['address_2_state']; $arr['main_postal_1'] = $data['address_1_postal']; $arr['main_postal_2'] = $data['address_2_postal']; $arr['main_customer_address_1'] = $arr['main_address_1'] . ' ' . $arr['main_city_1'] . ' ' . $arr['main_postal_1']; $arr['main_customer_address_2'] = $arr['main_address_2'] . ' ' . $arr['main_city_2'] . ' ' . $arr['main_postal_2']; // $arr['information_uploaded_by'] = $data['efname'] . " " . $data['emname']. " " . $data['elname']; // $arr['information_date_uploaded'] = $data['date_uploaded']; $arr['customer_type'] = (intval($data['type']) === 1) ? 'Individual' : 'Corporation'; $arr['main_name'] = (intval($data['type']) === 1) ? $data['first_name'] . " " . $data['last_name'] : $data['corporation_name']; $arr['main_category'] = $data['customer_category']; $arr['main_customer_status'] = (intval($data['isActive']) == 1 ? 'Active' : 'Inactive'); $arr['main_customer_aha_status'] = (intval($data['aha_status']) == 1 ? 'Registered' : 'Not Registered'); $arr['main_facebook'] = $data['facebook']; $arr['main_instagram'] = $data['instagram']; $arr['main_viber'] = $data['viber']; $arr['main_telegram'] = $data['telegram']; $arr['main_whatsapp'] = $data['whatsapp']; $arr['main_website_link'] = $data['website']; // $arr['information_business_company_name'] = $data['business_name']; // $arr['information_nature_of_work_business'] = $data['nature_of_business']; } return $arr; } function update_vehicle_customer_record_id_by_vehicle_id($customer_record_id, $vehicle_id, $db) { return $db->sql_query("UPDATE vehicle SET customer_record_id = '$customer_record_id' WHERE id = '$vehicle_id' "); // return $db -> select("SELECT name FROM `source_car_model` WHERE status = 1 AND `id` = '$id'"); } function insert_vehicle_image($vehicle_id, $image_name, $db) { $query = "INSERT INTO `vehicle_images`(`vehicle_id`, `name`) VALUES ('$vehicle_id','$image_name')"; return $db->sql_query_num_inserted($query); } function update_vehicle_image($vehicle_id, $image_name, $db) { // $query = "INSERT INTO `vehicle_images`(`vehicle_id`, `name`) VALUES ('$vehicle_id','$image_name')"; $query = "UPDATE `vehicle_images` SET name = '$image_name' WHERE vehicle_id = '$vehicle_id'"; return $db->sql_query_num_inserted($query); } function get_vehicle_id_by_vehicle_id($vehicle_id, $db) { return $db->select("SELECT id FROM vehicle WHERE vehicle_id = '$vehicle_id' LIMIT 1"); } function read_vehicle_image($vehicle_id, $db) { return $db->return_result("SELECT FROM vehicle_images WHERE status = 1 AND vehicle_id = '$vehicle_id'"); } function read_vehicle_image_display($vehicle_id, $db) { return $db->return_result("SELECT id,DATE_FORMAT(date_added, '%M %d, %Y - %h:%i:%s %p') AS date_added,name FROM vehicle_images WHERE status = 1 AND vehicle_id = '$vehicle_id'"); } function read_vehicle_by_conduction_sticker($conduction_sticker, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `conduction_sticker` = '$conduction_sticker' "; return $db->select($query); } function read_vehicle_by_plate_number($plate_number, $db) { $query = "SELECT 1 FROM `vehicle` WHERE `plate_number` = '$plate_number' "; return $db->select($query); } function read_plate_number_by_vehicle_id($vehicle_id, $db) { return $db->select("SELECT `plate_number` FROM `vehicle` WHERE `id` = '$vehicle_id' "); } function delete_vehicle_image($image_id, $db) { return $db->sql_query("UPDATE `vehicle_images` SET `status` = 0 WHERE `id` = '$image_id' "); } function read_conduction_sticker_by_vehicle_id($vehicle_id, $db) { return $db->select("SELECT `conduction_sticker` FROM `vehicle` WHERE `id` = '$vehicle_id' "); } function insert_all_vehicle_image($data_to_insert, $db) { $query = "INSERT INTO `vehicle_images`(`vehicle_id`, `name`) VALUES " . $data_to_insert . ""; // echo $query;exit; // $query = "INSERT INTO `customer_contact_person`(`customer_id`, `first_name`, `last_name`, `email`, `mobile_phone`, `status`) VALUES ".$data_to_insert.""; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function read_vehicle_cs_plate_and_id($granted_company_ids, $search, $db) { $customers = $db->return_result("SELECT v.*,v.id as vehicle_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id WHERE scd.company_id IN (" . $granted_company_ids . ") AND v.conduction_sticker = '$search' OR v.plate_number = '$search'"); $json = []; foreach ($customers as $customer) { $name = ($customer['conduction_sticker'] != '') ? $customer['conduction_sticker'] : $customer['plate_number']; $json[] = ['id' => $customer['vehicle_id'], 'text' => $name]; } echo json_encode($json); } function read_vehicle_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 v.date_uploaded BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') " : ''; $query = " SELECT SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN source_dms sd ON sc.dms_id = sd.id WHERE v.status = 1 AND scd.company_id IN (" . $company_filter . ") $date_filter GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total_count FROM `source_dms` WHERE status = 1"; // echo $query;exit; return $db->select($query); } }

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