laravel sum of Records.records.record.column in eloquent

Question

Here is the relation

transaction hasMany Carts
Cart belongsTo product
product->price

here is the Model class

//# TransactionModel
public function getCarts(){
    return $this->hasMany(CartModel::class, 'transaction_id','id');
}
//# CartModel
public function getProduct(){
    return $this->belongsTo(ProductModel::class,'product_id','id');
}

what i want to achieve is to get total price of current transactions(many)

what i do now is still iterate per transation and sum the price in $total

 Class TransactionModel{
 public static function getTotalPrice($transactions){
    $total = 0;
    foreach($transactions as $transaction){
            $total += $transaction->getCarts->sum('getProduct.price');
    }
    return $total;
 }

how to this in eloquent code thanks

It should be something like `$transaction->getCarts->product->sum('price')` — Iftikhar uddin, Feb 24 '19 at 07:19
@Iftikharuddin thats what i did, only get `current transation`. what we want to achieve is total price of `many transaction(S)` — david valentino, Feb 24 '19 at 09:41
What version of Laravel are you using? Also, please may you show the code for all 3 models. — Rwd, Feb 24 '19 at 09:48
Can you update your question with Model relationships? what dos getcarts do? — Mihir Bhende, Feb 24 '19 at 10:10

Mihir Bhende · Answer 1 · 2019-02-24T18:04:38.417

0

I Think this should work :

Class TransactionModel{

    public function getTotalPrice(){

        return $this->getCarts()->withCount([
            'getProduct' => function($q){ 
                return $q->select(DB::raw("SUM(price) as price_sum")); 
            }
        ])->get()->sum('getProduct_count');
    }

}

edited Feb 24 '19 at 18:04

answered Feb 24 '19 at 11:26

Mihir Bhende

8,677
1
30
37

$this in static function ? – faizan.sh Feb 24 '19 at 18:03
Ahh Thanks @faizan.sh I forgot to remove static word, Thanks :) Updated my answer – Mihir Bhende Feb 24 '19 at 18:04
thanks for your answer, but what we want to achieve is total price of many `transaction(S)` see my question first word is `Records`. $this means `1 record` – david valentino Feb 27 '19 at 10:57

score 0 · Accepted Answer · answered Mar 12 '19 at 10:51

0

i finally found a better way with collection reduce instead of foreach

 $totalPrice = $transactions->reduce(function($carry, $current){
                    return $carry + $current->getCarts->sum('getProduct.price');
               },0);

answered Mar 12 '19 at 10:51

david valentino

920
11
18

laravel sum of Records.records.record.column in eloquent

2 Answers2