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;
}
