File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/app/Models/Vehicle.php
Back
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; class Vehicle extends Model { use HasFactory; protected $fillable = [ 'owner_fname', 'owner_mname', 'owner_lname', 'owner_address', 'owner_phone', 'owner_email', 'vehicle_make', 'vehicle_model', 'vehicle_year', 'vehicle_vin', 'license_plate', 'vehicle_color', 'purchase_date', 'purchase_price', 'dealer_location', 'financing_details', 'registration_expiry', 'registration_number', 'registration_state', 'insurance_provider', 'policy_number', 'policy_expiry', 'last_service_date', 'last_service_type', 'next_service_due', 'service_provider', ]; public function fetchCarplusTicketQuery(){ return "SELECT %s FROM `vehicles` `vhc` INNER JOIN `carplus_tickets` `cp` ON `cp`.`vehicle_id` = `vhc`.`id` INNER JOIN `users` `usr` ON `usr`.`id` = `cp`.`ticket_creator_id` WHERE 1 %s %s %s %s "; } public function fetchCarplusTickets($array_data){ // dd($array_data); $fields = " `cp`.`id`, `cp`.`ticket_creator_id` , `cp`.`status`, `cp`.`created_at`, CONCAT(`usr`.`f_name`,' ',`usr`.`l_name`) as sender, `usr`.`deal_code`, `usr`.`comp_code` "; $query = sprintf( $this->fetchCarplusTicketQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function fetchCarplusTicketsCount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->fetchCarplusTicketQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function fetchCarplusTicketsFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->fetchCarplusTicketQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } public function getNotes($id){ $query = "SELECT note,f_name,l_name, vehicle_notes.created_at FROM vehicle_notes INNER JOIN users ON created_by = users.id WHERE vehicle_id = $id "; return DB::select($query); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.11 |
proxy
|
phpinfo
|
Settings