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