Laravel - Get The SUM of multiple withCount()

Question

I am looking for the Eloquent, or raw sql, to get the sums of two of my ->withCount. I need to be able to do this without having to ->get() the records, it needs to be implemented using Eloquent, not laravels Collection methods.

I have the following:

$owners = User::active() ->where(function($q){ $q->whereHas('primaryContractOwner') ->orWhereHas('primaryVendorOwner'); }) ->withCount([ 'primaryContractOwner', 'primaryVendorOwner' ]);

I need to get the sum of primary_contract_owner count and primary_vendor_owner count. I tried the following but I am getting primary_contract_owner_count column not found

// This one throws the error $owners = User::active() ->where(function($q){ $q->whereHas('primaryContractOwner') ->orWhereHas('primaryVendorOwner'); }) ->withCount([ 'primaryContractOwner', 'primaryVendorOwner' ]) ->select(['user.*', DB::raw('primary_contract_owner_count + primary_vendor_owner')]);

Why do you need the sum in the query?

Jonas Staudenmeir
– Jonas Staudenmeir

2018-12-17 20:58:08 +00:00
Commented Dec 17, 2018 at 20:58 — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Dec 17, 2018 at 20:58

Jeff · Accepted Answer · 2018-12-17 20:53:20Z

https://laravel.com/docs/5.7/eloquent-relationships#counting-related-models

I believe your counts will be called primaryContractOwner_count and primaryVendorOwner_count. You can run the query without the DB::raw part to check.

iMezied · Accepted Answer · 2020-05-13 13:15:16Z

You can use the collection method reduce as below

$owners->reduce(function($carry,$item){ return $carry+$item->primaryContractOwner_counter; },0);

for more please check the reduce documentation: https://laravel.com/docs/6.x/collections#method-reduce

Collectives™ on Stack Overflow

Laravel - Get The SUM of multiple withCount()

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related