Now we need to find a way to access our relationships.

So, we've related the two models, we've created our database for the to do items,

we've given it a foreign field or a foreign key for the to do list ID.

Now it's time to look at our listings, so here you

see my listings or my list and we need some items.

Before I do that, I'm gonna clean up my list

titles to make it seem a little more sensible, so

let's head back to our main listing here, our main

page and I'm gonna edit my lists that are currently there.

So I'm going to destroy this list and then I'm going to edit this one

and call it Hampton's tasks, and hit update,

and then I'm going to edit this one, and do Charlies tasks.

And then say update that one.

Ok, so now we have two people, two task lists.

So, let's go to my tasks and I have none.

So I want to create some tasks.

Let's do it manually.

Use our related ID and then use our relationship in a

loop to get our data and display it to the screen.

Let's start by adding some manual data to our database.

So, first, my to do list is ID of one, Charlie's is to do list ID of sixteen.

So keep that in mind as we're adding items to each person's list.

Let's add a couple to mine.

So, the first ID is going to be automatic.

The to do list ID for me is one and, let's say, wash

car and then don't need it completed on, but we'll do it now, as our date.

Same thing here and now we have one item.

Let's go ahead and add a couple of more items.

So, automatic one, and then, clean house.

That's a big item.

And then, now and now.

Okay.

So here I have two items.

Let's go ahead and refresh our page.

Nothing is going to be here cuz we need to find a query.

We'll do that inside of our controller and dump it back to the

screen so we can actually show my items that need to be completed.

Head back to our controller.

Go to controllers, TodoListController, and then scroll down and we're gonna use the

show method here on the TodoListController to show our to do items.

Now, a to do item should need its own controller, and it will, but for us right

now, we want to show our to do list items on our to do list page or show page.

So we're going to actually do our query right here.

Now, how are we going to do that?

We have our list which is good but now we need a list of our items.

So let's create a, another variable here which will end up

being an object, items and then we're gonna do another search.

We're gonna search on our existing found to do list.

So, that is list, which has been found previously or failed and then

we're going to pass through our argument or our find for the related items.

How do we know what that's called?

Well, we defined it earlier on the to do list model.

List here, this object, is an instance of the to do list model.

So, if we open up the to do list model and

we look, we only have one method here and that's list items.

So it would make sense to get the return of

all these to do items, we're gonna say list items.

So let's head back over to our controller

and say, list items, right here under show.

Then open and close parents and then we want to do a query on those

which is get and that's gonna return all of them to us in this list.

Let's go ahead and return the item to the screen.

Actually, we'll be items plural, so let's return the items to the screen.

See what we get.

Refresh and here are my items.

If you notice, I have todo_list_id, Wash Car and Clean House.

Doesn't have completed on but it does have our created and updated_at.

So it's returning our records and it's done it very simply

just by passing through to do list, list items and then get.

It's super simple but what's going on the background is not.

Let's add a little something to our routes file, so you can kind

of see what's happening in the background as we continue going through this process.

Let's open up our routes file.

Now, in our routes file, we have a route resource and we have

a route get, but Laravel has something even cooler than that, called an event.

So event, which is any event, and we're gonna listen, so a listener.

Listen and we're gonna listen for something in particular and for us it's

gonna be the illuminate, but .query.

So this is listening for any query event that comes across the illuminate class.

So the main core and then we're going to pass through a closure or a function, that

has a single argument that comes through and that's gonna be the actual query.

All right?

Now we're gonna open up and close this, just like we've

done before in closures, but we're gonna return something back here.

We're just gonna var dump.

And we're gonna var dump our query.

Let's go back over to our controller and then inside

of our controller we're going to take our return items here.

Let's go ahead and get rid of that and just go

back to what we had before which is just showing the list.

We know we're collecting the items so we're definitely going to be running

some queries, we're just not passing them back through to the view just yet.

But let's see what queries are actually running.

So here as we've refreshed our page, you can

see that here's the list that says: Hamptons Tasks.

There are no task listed, but you can see the two queries that ran.

We have selected all from to do lists, where the id is equal to this ID.

So there's one, limit is one and then we are selecting all from to do items which

is our new table, where, to do items dot to do list ID is equal to the same.

So, you see, we're using a related query, but we've done it with eloquent, and we've

done it very, very simply, just by saying list, list items, get.

The next thing we're gonna wanna do is actually take

these items and pass them through to our show page.

So, I'm gonna tab this down, just for readability

and say, with again, so yet another chain, with

items, and then we're gonna pass through our items

object here, which is gonna have all of our items.

Then we need to switch over to our view to display them.

We're gonna go to our to do's and then show and

then run a for loop here underneath each of these names.

Right, and then show what our items are.

So let's go ahead and do that now.

We'll do it with a simple for each inside of a blank syntax.

So at for each, and then inside of the for each, we're going to do

what we need and then to close to our four each, we're going to say at, end for each.

And inside of here we wanna list all of our items,

but we have to pass through what we want as our arguments.

So, for each items, which we know what's coming through, as item.

Okay, so now we'll do a list of the items.

So, we'll just do it as h4's.

Our triple curly brace syntax, some spaces in there for clarity and then

do item and then we want to get the item content which is the name of our field.

So save that, let's go back to our page and refresh.

Now we have a list of my items, which are wash car and clean house.

Notice we've still got the queries up there, so we can for now go ahead and just

comment out that section instead of our routes,

so we don't need to see those right now.

We will want to readdress those later, but we'll

do that in our final stage where we're refactoring.

Head back over to Sublime, we can close this, close out all of this and

head to our routes, and then we're just going to comment out these three lines.

So now I'll go back to our page and refresh.

Now we have our items, so here's my task, and here are my items.

Just to make sure that we're doing the right

queries all the way across the board, let's add a

new item to our database, and that's going to

be an item that's related to Charlie's tasks, not mine.

So we're gonna make sure that it has the related ID of 16.

So, let's do another one.

So, new item.

Related ID is 16, or to do list ID and

then this one will be, eat all of your dinner.

All right, and then now,

do the same thing over here, and hit enter.

So, eat all of you dinner, let's let's update that, eat all of your dinner.

All right, now head back over, refresh my page.

I don't have that item, but if I go back to the main page and click on her tasks.

Eat all of your dinner is her tasks.

So very simple, little bits of code just a couple of

lines and eloquent has really done some powerful things in the background.

The next step for us to do is to

continue our [UNKNOWN] by nesting our routes, nesting controllers,

and making all of the stuff work the same as to do list, but just with our items.

Over the last several lessons, you've absorbed a lot of information.

My first suggestion would be to start from

the beginning and go through the process again.

The second and third time around, you will not need to focus on the

tests and the challenges, but only on the task of building out the application.

Please reach out on our forums, and get involved in the Lauravale community.

Together, we can grow our knowledge.

Until next time, remember, work hard, and have a little joy.