/** * Calculate distance traveled from the given date. * * @param Request $request * * @return Response */ public function distanceTraveledOn(Request $request) { $startDate = Carbon::parse($request->get('date')); $date = $startDate->format('Y-m-d'); $cars = Car::whereIn('_id', $request->get('cars'))->get(); $imeiTrackers = []; foreach ($cars as $car) { array_push($imeiTrackers, $car->tracker['imei']); } return Spot::whereIn('imei', $imeiTrackers)->where('time', 'LIKE', "%{$date}%")->get(); }