Build an Appointment Booking System With Laravel

Sorry, I think I didn't explain myself well or it wasn't clear to me what you told me, sorry! Look, what I need is that once the schedules have been assigned to an employee, I also need to be able to add time slots, such as assigning a time slot for lunch time or break time. so that they are taken into account when calculating the hours of work availability, another example, if he works six days a week from nine am to five pm, he will need to add a time slot for his lunch or break for that reason. I need to see how I add one or more of a free time slot for them. So I don't know which would be the most appropriate way to create a new table, such as schedule_break, to save the time slots for your lunch or break time and take them into account when calculating your availability. Can you give me a little guide on how to achieve that, thank you.

Ah, I see what you mean — so a recurring unavailability set for specific days of the week?

In this case, yes, a new table would be good. Structure it similarly to the availability table where you have the monday_starts_at columns, and then iterate over each record for the user in the ScheduleAvailability class.

Feel free to try it out in code, and if you're stuck post anything here that isn't working :)

I really forgive my ignorance on this subject, I tried all this week to achieve that but I couldn't, I don't know if I misunderstood you but I want you to see what I did.

look at the model:

class ScheduleSlot extends Model { use HasFactory;

protected $fillable = [
    'employee_id',
    'monday_starts_at',
    'monday_ends_at',
    'tuesday_starts_at',
    'tuesday_ends_at',
    'wednesday_starts_at',
    'wednesday_ends_at',
    'thursday_starts_at',
    'thursday_ends_at',
    'friday_starts_at',
    'friday_ends_at',
    'saturday_starts_at',
    'saturday_ends_at',
    'sunday_starts_at',
    'sunday_ends_at',
];

public function employee()
{
    return $this->belongsTo(Employee::class);
}

}

 Look at the function I built guided by subtractScheduleExclusion, look:


protected function LunchcheduleExclusion(ScheduleSlot  $exclusion)
{
      $this->periods = $this->periods->subtract(
        Period::make(
            $exclusion->starts_at,
            $exclusion->ends_at,
            Precision::MINUTE(),
            Boundaries::EXCLUDE_END()
        )
    );

}

Actually, that is one of the functions that I tried since there were many and that model is one of many that I also built, I have tried many, many forms and I couldn't achieve it. Many of them gave me an error and others simply did not exclude the hours of availability. I really tried and I am trying but I ask you, please, if you can help me, I would appreciate it very much. What I need is for employees to be able to enter their working hours. lunch whatever time it is but it applies to every day but according to the day it is added since it can vary from day to day, that is, if on Monday I add a lunch hour from 12 to 13pm, every Monday I exclude them and if Tuesday I add from 1:00 p.m. to 2:00 p.m. so that everything on Tuesdays excludes that time from availability. I don't know if you get my idea. please help me!!

the model

class ScheduleSlot extends Model { useHasFactory;

protected $fillable = [
    'employee_id',
    'monday_starts_at',
    'monday_ends_at',
    'tuesday_starts_at',
    'tuesday_ends_at',
    'wednesday_starts_at',
    'wednesday_ends_at',
    'thursday_starts_at',
    'thursday_ends_at',
    'friday_starts_at',
    'friday_ends_at',
    'saturday_starts_at',
    'saturday_ends_at',
    'sunday_starts_at',
    'sunday_ends_at',
];


public function employee()
{
    return $this->belongsTo(Employee::class);
}

public function getLunchHoursForDate(Carbon $date)
{
    $hours = array_filter([
        $this->{strtolower($date->format('l')) . '_starts_at'},
        $this->{strtolower($date->format('l')) . '_ends_at'},
    ]);

    return empty($hours) ? null : $hours;
}

}

next part of the function and called it on forPeriod

// the function

protected function subtractLunchScheduleExclusion(Carbon $date)
{
    if (!$scheduleslot = $this->employee->scheduleslots->where('starts_at', '<=', $date)->where('ends_at', '>=', $date)->first( )) {
        return;
    }

    if (![$startsAt, $endsAt] = $scheduleslot->getLunchHoursForDate($date)) {
        return;
    }

    $this->periods = $this->periods->subtract(
        Period::make(
            $date->copy()->setTimeFromTimeString($startsAt),
            $date->copy()->setTimeFromTimeString($endsAt)->subMinutes($this->service->duration),
            Precision::MINUTE(),
            Boundaries::EXCLUDE_END()
        )
    );
}

I call it in the forPeriod function and it doesn't give me an error but it doesn't exclude availability hours, can you help me? Please if you have any way to achieve this I would greatly appreciate it!

Thanks for the additional details. Looking into this for you and I'll get back to you soon!

Friend, have you found anything on the subject? You know another way I've seen others use is this look at BusinessTime::enable(Carbon::class, [ 'monday' => ['09:00-12:00', '13:00-18:00'], 'tuesday' => ['09:00-12:00', '13:00-18:00'], 'wednesday' => ['09:00-12:00'], 'thursday' => ['09:00-12:00', '13:00-18:00'], 'friday' => ['09:00-12:00', '13:00-20:00'], 'saturday' => ['09:00-12:00', '13:00-16:00'], ]); They define their schedule but leaving a space of 12 to 13, I don't know if that is another way.