/** * Get all cars with information * * @return $allCars */ public function getAllCars() { return Car::select('cars.id', 'cars.brand', 'cars.model', 'cars.color', 'cars.year', 'cars.seat_number', 'cars.plate', 'cars.vin', 'cars.mileage', 'cars.transmission_id', 'cars.available', 'cars.rental_fee', 'cars.created_at', 'cars.updated_at', 'images.url', 'transmission_reference.abbreviate', 'transmission_reference.name as transmission_name')->join('images', 'cars.id', '=', 'images.car_id', 'left outer')->join('transmission_reference', 'cars.transmission_id', '=', 'transmission_reference.id', 'left outer')->get(); }