This episode is for members only
Sign up to access "Build an Appointment Booking System With Livewire" right now.
Get started
Already a member? Sign in to continue
Playing
05. Employee schedules and exclusions tables
Episodes
01. Introduction and setting up
02. Database setup
03. Displaying employees and services
04. Core functionality
09. How we build up availability
3m 40s
0%
10. Working with date periods
6m 54s
0%
11. Iterating over requested days in a period
3m 30s
0%
12. Adding schedule availability
11m 33s
0%
13. Removing schedule exclusions
3m 35s
0%
14. Excluding time already passed today
2m 17s
0%
15. Generating slots
11m 50s
0%
16. Using a custom date collection
1m 28s
0%
17. Building the service availability generator
6m 18s
0%
18. Adding employees into slots
8m 14s
0%
19. Removing empty slots
3m
0%
20. Removing slots with booked appointments
6m 17s
0%
05. Building the checkout
21. Scaffolding the checkout design
4m
0%
22. Making the employee optional
1m 54s
0%
23. Loading availability
8m 31s
0%
24. Building Alpine plugins
3m 18s
0%
25. Showing the calendar
3m 32s
0%
26. Locking unavailable dates
15m 1s
0%
27. Showing the slot count on the calendar
7m 52s
0%
28. Updating the selected date
3m 29s
0%
29. Showing time slots
5m 43s
0%
30. Setting a time slot
2m 43s
0%
31. Finding an available employee
3m 31s
0%
06. Booking appointments
07. Appointment confirmation
Transcript
00:00
Slightly more complicated are the schedules for the employees and the schedule exclusions, but we're going to dive more into the inner workings of this when we build up the core functionality.
00:10
Let's get the schema done, and hopefully things will start to make a little bit more sense. OK, so we're going to go ahead and create out another model. And this is going to be a schedule for an employee.
00:20
Employees are going to be allowed multiple schedules. We saw that from the introduction about how that looked in the database. Let's go ahead and create this out first of all.
00:29
Let's open up the Create Schedules table migration and start to fill this in. Now, obviously, this belongs to a particular employee. So let's go ahead and pull in a employee ID,
00:41
and let's just constrain this. And then we have that overall starts and ends at date, which is a long-term starts and ends at date. So we might want to have this start at the start of the year
00:53
and end at the end of the year. Then we want a new schedule for the next year, for example. So let's add in starts at, and then we'll do exactly the same thing for ends at.
01:03
Now, the annoying part about this is now we're going to have to define a column for every single day that the user wants to work. Now, there's a really good reason for this,
01:13
and that is that as we go through the employee's availability or their schedule and we build up availability for them inside of the class that we're eventually going to be building,
01:23
it's very easy to see which days that they work. So let's go ahead and build this out, and then like I said, we'll talk about this a little bit more later.
01:30
So we want a time in here, and we want Monday starts at. And that's going to be nullable because they might not work on a Monday. And we're going to have Monday ends at, which also
01:41
is going to be nullable. In fact, every single one of these is going to be nullable. So let's go and fill in the rest of these. OK, so I've gone ahead and added these for every single day
01:51
of the week, a starts at and an ends at. It's going to give us superfine control over the days and the times that people work or our employees work. OK, let's go ahead and run our migrations on this.
02:03
And then we can go over and set up the relationship. So if we head over to the employee model, we know that they have schedules. So let's go ahead and create out a schedules relationship
02:14
in here. And that is just going to have many. So let's just say has many and our schedule class in there. Great.
02:21
Now for the schedule model itself, we want to set up some casts in here. That's really important. So let's go and set up our cast for our starts at and ends
02:31
at date. And the reason we want to do this is we want these to be casted dates, so they are carbon instances.
02:38
So let's say starts at, and we'll set that to a date. That just means we can manipulate that really easily. And the same with ends at as well. We don't need to do this for all of the other days.
02:49
As we'll see a little bit later, we're going to do something a little bit more custom to work out whether they can actually work on them days or not. OK, so now that we've done this, let's work
02:58
on the schedule exclusions. So again, another model in here. And this is going to be a schedule exclusion. Let's create that out.
03:05
Let's open up the Create Schedule Exclusions table. And this is much easier, because we just want a starts at and an ends at date over a period of time when this is unavailable, when that employee is unavailable.
03:18
So again, we just want a foreign ID in here for the employee. And that will be constrained. And again, we just want a starts at and ends at date. That is all we need inside of here.
03:29
So let's say starts at. Let's pull this down and, of course, change this over to ends at. And we should be good.
03:35
OK, so let's go ahead and run our migrations on this. And we are good to go. So again, what we're going to do is head over to our schedule table.
03:44
Remember, we have exactly the same casts here. So we're going to go over to our exclusions. And we are going to apply exactly the same cast. So we get nice carbon objects through to here.
03:55
And we can do what we need. And again, if we head over to the employee where we added the schedules, we also have many schedule exclusions.
04:04
So let's go ahead and add that in now. So we've got that in there. And of course, change that over to schedule exclusion. So the whole idea here, just before we
04:13
start to build the core functionality, is that as we go through our schedules, we know which days and which sort of periods we're working. And we can add them to the availability.
04:23
But with the schedule exclusions, we can subtract them from the availability. So then we end up with the overall availability for the employee based on these two things.
04:33
And like I said, these are two things that are very powerful because schedules are very fine grained. And schedule exclusions will just cut out that availability from anything we've added in there.
36 episodes•3 hrs 4 mins•3 months ago
Overview
Building an availability calendar and booking system is a notoriously difficult problem to solve. That’s exactly what we’re going to cover in this course.
Step by step, we’ll build an appointment slot generator that calculates availability based on employee schedules, employee’s booked time off, the length of service chosen, existing appointments, and cancelled appointments.
For maximum flexibility, we’ll also allow multi-employee availability checks, so we’ll be able to see every employee who can perform a service (and their available slots).
To finish up, we’ll create an entire booking flow with Livewire, including a beautiful booking calendar that shows detailed availability across multiple dates, the ability to choose a time slot — and finally the ability to book an appointment.
Phew. We’ve got a lot to learn — let’s build a booking system with Livewire!
Alex Garrett-Smith
Hey, I'm the founder of Codecourse!
Comments
No comments, yet. Be the first to leave a comment.