Checking for overlapping appointments and limit attendees

@webrobert This is my code below

	$start_date         = data_get($params, 'start_date');
    $end_date           = data_get($params, 'end_date');
    $min_slot_minutes   = CarbonInterval::minutes(data_get($channel, 'appointment_min_duration', 15));

    $attendees = $this->attendees->queryAttendees([
        'channel_id'    => (int) data_get($params, 'channel_id'),
        'client_id'     => (int) data_get($params, 'client_id'),
        'venue_id'      => $venue->id,
        'start'         => Carbon::make("{$start_date} {$venue->opening_hour}"),
        'end'           => Carbon::make("{$end_date} {$venue->closing_hour}")
    ]);

    $periods    = new CarbonPeriod($start_date, '1 day', $end_date);
    $schedules  = [];
    foreach($periods as $period ) {
        $from   = Carbon::make("{$period->format('Y-m-d')} {$venue->opening_hour}");
        $to     = Carbon::make("{$period->format('Y-m-d')} {$venue->closing_hour}");
        foreach(new CarbonPeriod($from, $min_slot_minutes, $to->sub($min_slot_minutes)) as $slot) {
            $end = $slot->copy()->add($min_slot_minutes);
            
            $schedules[] = [
                'start'     => $slot->format('Y-m-d H:i:s'),
                'end'       => $end->format('Y-m-d H:i:s'),
                'attendees' => 0 // I want push attendees here
            ];
        }
    }

    return $schedules;

@Saturnlai, there was another thread here on time slots that could be helpful... I can't seem to find it at the moment. But why not query the events instead of the attendees and do a withCount for the attendees?

@webrobert An appointment there are many objects attendees such as: Guest number, sellers..... So i can't use withCount in that case.