hretic hretic - 1 month ago 6
PHP Question

laravel orm : where condition on table -> related table -> related table

so here is my database for a book store

books : id ,title
category : id, title

book_category : id , book_id, category_id
book_stock : id , book_id , quantity , price


considering all the relations are defined in the model , i can query
book_stock
it goes something like this

Stock::with('Book')->get();


but what if i want to get
stock
of a
book
in the
category = 1


i can use use condition on book

Stock::with('Book' , function($q){
$q->where(['title'=>'abc']);
})->get();


but how can i filter related table of book ?
basically i want to get
book_id
from
book_category
where
category_id = 1
and then use those ids to filter my
books
finally get
stock



ps : i don't want to use query builder

Answer

You can do:

Stock::with('Book.stock', 'Book.category')->get();

You can access any number of nested relations within a with statement.


Related question:

Laravel nested relationships


Armin Sam's answer should also be a viable option.