/** * @param $id * @return array */ public function getPublicTransportList($id) { $now = new \DateTime('+5 minutes'); $schedule = DB::collection('public_transport_schedule')->orderBy('departure_datetime', 'ASC')->where('id_public_transport_stop', $id)->where('week_day', $this->_formatWeekDay($now))->where('departure_datetime', '>=', $now->format('H:i:s'))->limit(5)->get(); $list = []; foreach ($schedule as $s) { $stop = PublicTransport::findOrNew($s['id_public_transport']); $list[] = ['name' => $stop['name'], 'direction' => $stop['direction'], 'time' => $s['departure_datetime']]; } return $list; }