Build an Appointment Booking System With Livewire

Sign in Get started

This episode is for members only

Sign up to access "Build an Appointment Booking System With Livewire" right now.

Already a member? Sign in to continue

Playing

13. Removing schedule exclusions

Episodes

0%

Your progress

Total: 3h 4m
Played: 0m
Remaining: 3h 4m

Join or sign in to track your progress

01. Introduction and setting up

01. Introduction and demo

02. A fresh Laravel app

02. Database setup

04. Creating employees and services tables

05. Employee schedules and exclusions tables

06. Creating the appointments table

03. Displaying employees and services

07. Displaying employees and services

08. Showing all services by an employee

04. Core functionality

09. How we build up availability

10. Working with date periods

11. Iterating over requested days in a period

12. Adding schedule availability

13. Removing schedule exclusions

14. Excluding time already passed today

15. Generating slots

16. Using a custom date collection

17. Building the service availability generator

18. Adding employees into slots

19. Removing empty slots

20. Removing slots with booked appointments

05. Building the checkout

21. Scaffolding the checkout design

22. Making the employee optional

23. Loading availability

24. Building Alpine plugins

25. Showing the calendar

26. Locking unavailable dates

27. Showing the slot count on the calendar

28. Updating the selected date

29. Showing time slots

30. Setting a time slot

31. Finding an available employee

06. Booking appointments

32. Taking customer details

33. Re-checking availability

34. Creating the appointment record

07. Appointment confirmation

35. The appointment confirmation page

36. Cancelling appointments

Transcript

00:00

While we're inside of this iteration for each of the days and we add the availability for the schedule, we can also inside of here subtract

00:08

any schedule exclusions. So holidays, lunch breaks, whatever you want to do. OK, so we already know that we've got the relationship set up in here.

00:17

So just after we've added the availability from the schedule, let's go ahead and access the employee. Let's access the schedule exclusions. And let's go ahead and iterate over each of these.

00:28

Now, it's important to note at this point when we're iterating over these, we're not scoping these by the date that we have selected. We might go ahead and update that a little bit later

00:37

and that's going to speed things up a little bit. But since we're accessing the collection here, we're not going to end up with an N plus one problem. OK, so now that we've got the exclusion in here,

00:45

let's pull this into this. So let's just call this, well, we'll call it schedule exclusion. And again, we're going to go ahead

00:52

and defer to another method here. So let's go and say this subtract schedule exclusion. And let's pass that schedule exclusion directly in. OK, let's create out a method to deal with this.

01:06

So subtract schedule exclusion. We pass in the schedule exclusion. And then we just want to do exactly what we did here, but we want to say subtract.

01:18

So let's grab all of this code just to save us a little bit of time. Let's pop this inside of here. And this time we want to subtract the schedule exclusion.

01:27

So for the start date, that is basically just going to be the schedule exclusion starts at date, which we have in the database.

01:35

And then we're going to have the same thing down here. And that's going to be the ends at date. And remember these are carbon objects because over in the schedule exclusion

01:44

a little bit earlier, we cast these. So this is going to beautifully just start to work together. OK, so now that we've done this, just before we start to test this out,

01:52

I'm going to go over to the web and I'm going to change around the period that we're accessing. I'm just going to keep this simple and just do end of day.

02:00

We'll just keep this within a day period, just so it makes sense. OK, so if we come over to the browser, give this a refresh, nothing has changed here.

02:08

We've still got an included start and end date at nine till four minus the service. And we're going to add an exclusion now. So over in the database,

02:18

let's go over to our schedule exclusions. Let's set this for my employee, add in a starts and ends at date. And let's go ahead and change these around.

02:26

So we're going to do it for today. And this is actually a date. Let's just take out a look at the structure. Yes, this is a date.

02:32

I'm going to switch this to a date time. Let's save that out. And just while we're here as well, so we don't forget, let's go over to our create schedule exclusions table

02:42

and make sure we set this to a date time and this to a date time as well. And also over in our exclusion model, let's cast this to a date time.

02:52

So that was my bad. Okay, so now that we've done that, we can go ahead and actually set a date and a time in here. And I'm going to say, well, I want my lunch break.

03:00

So I'm going to set this to 12 to 13 for today. Okay, so back over to the browser, let's give this a refresh. And now we have two periods.

03:11

And that's absolutely normal because the way that we split period collections up means we end up with a period before lunch and a period after lunch.

03:19

Let's check this out. Okay, so we've got a start at nine. That's when I start, but now I finished just before my lunch.

03:25

And then on my second period, you can see that I start just after my lunch. And then of course I finish just before the time that the service takes.

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.