public function getTakenSlots(request $request) { $event = Event::find($request['event_id']); if ($event->place->rows != null) { $slots = []; $taken = []; $reserved = []; $slot_presentation = DB::table('slot_presentation')->where('presentation_id', $request['function_id'])->where('status', config('constants.seat_taken'))->get(); foreach ($slot_presentation as $s_p) { $slot = Slot::find($s_p->slot_id); if ($slot->zone->id == $request['zone_id']) { array_push($taken, $slot->row . "_" . $slot->column); } } $slot_presentation = DB::table('slot_presentation')->where('presentation_id', $request['function_id'])->where('status', config('constants.seat_reserved'))->get(); foreach ($slot_presentation as $s_p) { $slot = Slot::find($s_p->slot_id); if ($slot->zone->id == $request['zone_id']) { array_push($reserved, $slot->row . "_" . $slot->column); } } array_push($slots, $taken); array_push($slots, $reserved); } else { $slots = -1; } return $slots; }
public function getIDs($agendaID) { return Slot::find()->where(['agendaID' => $agendaID])->asArray()->orderBy(['slotnum' => SORT_ASC])->all(); }