Laravel query a model in a nested query?

Question

I have an Appointment model that has a relation to Employee and an Employee to a User. I am trying to query a list of appointments between specific dates ($weekStart and $weekEnd) and retrieve the appointments as well as the related Employees and Users.

So far this works, it returns all my Clients with all appointments and the assigned Employees/Users (Employees belong to User).

'clients' => Client::with('careType','appointments.employees.user')->get(),

However I wish to specify between dates on the appointments model. So I have this:

$data = [
  'clients' => Client::with(['appointments' => function ($query)  use ($weekStart, $weekEnd) {
        $query->whereBetween('starts_at', [$weekStart, $weekEnd]);
        }])->get(), 
];

In the above what is the syntax to also retrieve the employees and user models when I have a sub query?

Daniel · Accepted Answer · 2017-07-17 19:13:52Z

1

You just add your other models in your Client's with() array.

$data = [
  'clients' => Client::with(['appointments' => function ($query)  use ($weekStart, $weekEnd) {
        $query->whereBetween('starts_at', [$weekStart, $weekEnd]);
        }, 'appointments.employees.user'])->get(), 
];

answered Jul 17, 2017 at 19:13

Daniel

11.3k12 gold badges56 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eden WebStudio Over a year ago

Thanks. That works. Not sure how. Does everything in the [] get evaluated as one? At first glance, I thought this would just reset the appointments and get() all rather than the query list.

Daniel Over a year ago

Laravel's Eager Loading is a little complicated, but basically all string elements in the with statement (like appointments.employees.user) are evaluated first, and then any functions in the array will be evaluated and replace existing string elements.

Collectives™ on Stack Overflow

Laravel query a model in a nested query?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related