Laravel Eloquent subquery and count subquery results

Question

Let's say there's a Post model. It has a hasMany relationship called comments() defined in its model.

I'm trying to:

Get the count of comments
That belongs to a specific set of Posts, defined by an array of ids
Where the comments are posted in a certain date range

I thought the following would work:

$ids = [1, 2, 3, 4];

$results = Post::whereIn('id', $ids)
    ->with(['comments'])
    ->whereHas('comments', function($q) {
       $q->whereMonth('created_at', Carbon::now()->month);
    })
    ->withCount('comments')
    ->get();

And then do

$count = array_sum($results->pluck('comments_count')->toArray());

The result of the query does include comments_count so that's working, and $count works as well.

But the date range in the subquery is not applied, it counts all comments. What am I missing?

Angad Dubey · Accepted Answer · 2020-03-20 20:03:44Z

3

You will need to pass the same condition/subquery to the withCount method:

->withCount(['comments' => function($q) {
       $q->whereMonth('created_at', Carbon::now()->month);
    }])

https://laravel.com/api/5.5/Illuminate/Database/Eloquent/Concerns/QueriesRelationships.html#method_withCount

answered Mar 20, 2020 at 20:03

Angad Dubey

5,4728 gold badges33 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Laravel Eloquent subquery and count subquery results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related