Nested "with()" laravel

Question

I'm having issues with some relationships. I have the following situation

Product:

public function catalogues()

 {
     return $this->belongsToMany('App\Catalogue');
 }

public function category()
{
    return $this->belongsTo('App\Category');
}

Category:

 public function products()
   {
       return $this->hasMany('App\Product');
   }

Catalogue:

    public function products()
   {
       return $this->belongsToMany('App\Product');
   }

With a single query, I need to get all the categories that have products belonging to a certain catalogue. How can I achieve it?

You need join

user6478676
– user6478676

2018-02-19 12:47:15 +00:00
Commented Feb 19, 2018 at 12:47 — user6478676
– user6478676, Commented Feb 19, 2018 at 12:47

Alexey Mezenin · Accepted Answer · 2018-02-19 13:07:57Z

3

Use whereHas():

Category::whereHas('products.catalogues', function($q) use($catalogueId) {
    $q->where('catalogues.id', $catalogueId);
})
->get();

Or:

Category::whereHas('products', function($q) use($catalogueId) {
    $q->whereHas('catalogues', function($q) use($catalogueId) {
        $q->where('id', $catalogueId);
    })
})
->get();

answered Feb 19, 2018 at 13:07

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

Dani Over a year ago

This won't work either, it retrieves all the products from those categories.

Alexey Mezenin Over a year ago

@Dani it can't retrieve any products, it will return categories only. Do not modify the code, use it as is.

Ryan Over a year ago

Thanks. In Laravel Backpack, I was able to use

$this->crud->query = $this->crud->query->whereHas('contactTags', function($q) use($tagId) {                 $q->where('tag_id', $tagId);             });

FULL STACK DEV · Accepted Answer · 2018-02-20 08:07:12Z

0

You need whereHas and

    Category::whereHas('products')
  ->with(['products' => function($query) use ($id){
        $query->with('catalogues' => function($query) use ($id){

         $query->where('catalogues.id',$id);

      });

   }])
  ->get();

Hope this helps.

edited Feb 20, 2018 at 8:07

answered Feb 19, 2018 at 12:51

FULL STACK DEV

16k6 gold badges49 silver badges67 bronze badges

6 Comments

Dani Over a year ago

Thank you, but actually what I need to do later is to loop it by category, not by products. That's why I'm a little confused, as I tried the "with" method, which works perfectly if I just pick the products, not if I join the catalogues too as there's no relationship b/w catalogues and categories

FULL STACK DEV Over a year ago

@Dani I have updated the answer have a look. it may helps you

Dani Over a year ago

Amazing, this works! Thank you, you saved me from a huge headache :)

FULL STACK DEV Over a year ago

@Dani I am glad this works for you. If this really worked for you can accept this answer.

Alexey Mezenin Over a year ago

@Dani this can't possibly work for you because this code will give you an error and with() will load the data instead of filtering categories by related data.

|

Collectives™ on Stack Overflow

Nested "with()" laravel

2 Answers 2

3 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related