File manager - Edit - /home/autoph/public_html/data03252025consolidation/src/Models/Vehicle.php
Back
<?php namespace App\Models; use App\Core\Database; use App\Core\Model; class Vehicle extends Model { public function getVehicleDataByCS($cs) { $query = "SELECT v.*, sc.name as company, sd.name as dealer, sb.name as brand, scm.name as model, scmv.name as model_variant , cc.mobile_phone_1, cc.email_1, sd.id as dealer_id FROM vehicle v 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 sd ON scd.dealer_id = sd.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 LEFT OUTER JOIN source_car_model_variant scmv ON v.model_variant_description = scmv.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id WHERE 1 AND v.conduction_sticker = ? "; $paramType = "s"; $paramValue = array( $cs, ); return Database::connect()->runQuery($query, $paramType, $paramValue); } public function updateVehiclePlate($array_data) { $query = "UPDATE `vehicle` SET `plate_number` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['plate'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } public function updateVehicleOr($array_data) { $query = "UPDATE `vehicle` SET `official_receipt` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['or'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } public function updateVehicleCr($array_data) { $query = "UPDATE `vehicle` SET `certificate_of_registration` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['cr'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } public function updateVehicleMv($array_data) { $query = "UPDATE `vehicle` SET `mv_file` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['mv'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } public function updateVehicleEngineNo($array_data) { $query = "UPDATE `vehicle` SET `engine_number` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['engine_no'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } public function updateVehicleChassisNo($array_data) { $query = "UPDATE `vehicle` SET `chassis_number` = ?, `modified_by` = ?, `date_modified` = NOW() WHERE `id` = ? "; $paramType = "sii"; $paramValue = array( $array_data['chassis_no'], $array_data['user_id'], $array_data['vehicle_id'], ); $result = Database::connect()->update($query, $paramType, $paramValue); return $result; } }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.06 |
proxy
|
phpinfo
|
Settings