Forum Querying a model using conditions in relationship

faridsilva

posted 6 years ago

Database Eloquent

Last updated 1 year ago.

rocketpastsix

replied 6 years ago

This can be cleaned up a lot...

Banner::isVisible()->startDate($today)->endDate($today)->categories()->byCategoryId($category->id)->get();

All those wheres could be thrown into query scopes so you can create more readable code. To access inside the categories relationship, you need the parens with creates a query builder. I don't have your data to test, but this should help you.

faridsilva

replied 6 years ago

Solution

Thank you rocketpastsix for your advice, I will read more about those wheres and take it in count.

I received solution from users in laracast forum, so I share here, because it may helps somebody else.

Correct query in eloquent way is:

$banners = Banner::where('visible', 1)
    ->where('visible', 1)
    ->where('up_at','<=', $today)
    ->where('down_at','>=', $today)->get();
    ->with('categories')
    ->whereHas('categories', function($query) use ($categoryId)  {
        $query->where('id', $categoryId);
    })->get();