Laravel withCount() returns wrong value

Question

In my application there are users making pictures of items. The relationship structure is as follows:

Categories -> SubCategories -> Items -> Pictures -> Users

Now, there's also a shortcut relationship called itemPics between categories <--> pictures so that the number of pictures uploaded by a user can be quickly counted per category using withCount().

These are the relationships on the Category model:

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

public function items()
{
    return $this->hasManyThrough('App\Item', 'App\SubCategory');
}

public function itemPics()
{
    return $this->hasManyThrough('App\Item', 'App\SubCategory')
    ->join('pictures','items.id','=','pictures.item_id')
    ->select('pictures.*');
}

My problem is getting the number of pictures that a user has gathered per category. The itemPics_count column created by withCount() always has the same value as items_count, even though the number of related models for both relations given by with() are different in the JSON output.

        $authorPics = Category::with(['SubCategories', 'SubCategories.items' => function ($q) use ($author_id) {
                $q->with(['pictures' => function ($q) use ($author_id) {
                    $q->where('user_id', $author_id);
                }]);
            }])
        ->with('itemPics') /* added this to check related models in output */
        ->withCount(['items','itemPics'])
        ->get();
        dd($authorPics);

This does not make sense to me. Any help is greatly appreciated.

Might help showing the relationship methods in your model (specifically items and itemPics) — Devon Bessemer
– Devon Bessemer, Commented Aug 7, 2017 at 20:06
withCount tracks until your relationship stop, it ignores join clause, are you try to get the number of pictures only? — Phantom1412
– Phantom1412, Commented Jan 24, 2020 at 3:56
withCount kicks in immediately with your select clause whereas with kicks in with another query, so your join clause will not be treated for withCount. — Phantom1412
– Phantom1412, Commented Jan 24, 2020 at 5:25

Bulut · Accepted Answer · 2022-10-12 20:05:36Z

1

Withcount() function is not work properly if relations include join. it works only table to table relations.

    public function itemPics()
{
    return $this->hasManyThrough('App\Item', 'App\SubCategory')
    ->select('pictures.*');
}

answered Oct 12, 2022 at 20:05

Bulut

1552 silver badges7 bronze badges

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

Comments

Roman Grinev · Accepted Answer · 2020-11-27 17:01:35Z

This solution was worked for me:

//...
public function itemPics()
{
    return $this->hasManyThrough('App\Item', 'App\SubCategory');
}

Then you can do something like this:

$authorPics = Category::with(['SubCategories', 'SubCategories.items' => function ($q) use ($author_id) {
      $q->with(['pictures' => function ($q) use ($author_id) {
         $q->where('user_id', $author_id);
      }]);
   }])
   ->with('itemPics') /* added this to check related models in output */
   ->withCount(['items','itemPics' => function($query){
      $query->join('pictures','items.id','=','pictures.item_id')
         ->select('pictures.*');
   }])
   ->get();
dd($authorPics);

Link to more information about Laravel withCount function here https://laravel.com/docs/8.x/eloquent-relationships#counting-related-models

Collectives™ on Stack Overflow

Laravel withCount() returns wrong value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related