public static function getVehiclesLastPlace($vehicle_id = null) { $sub = Gps::select(\DB::raw('MAX(id) as id'))->groupBy('vehicle_id'); $prefix = \DB::getTablePrefix(); $vehicles = Gps::select('gps.id', 'vehicle_id', 'latitude', 'longitude', 'geofence')->join(\DB::raw("({$sub->toSql()}) as " . $prefix . "gps2"), 'gps.id', '=', 'gps2.id')->join('vehicles', 'vehicles.id', '=', 'gps.vehicle_id')->where('vehicles.company_id', Auth::user()['company_id']); if (!empty($vehicle_id)) { $vehicles = $vehicles->where('vehicle_id', $vehicle_id); } $vehicles = $vehicles->groupBy('vehicle_id')->get(); $vehicles = self::getVehiclesGeofence($vehicles); return $vehicles; }
public function getDriverProfile($idContact) { $results = Gps::select('speed')->where('driver_id', $idContact)->whereNotNull('speed')->orderBy('id', 'desc')->take(50)->get(); return $results; }