Did use sum of sum with groupby in Laravel

Question

Alreay i sum the column price groupby inventory_id .Additionally i need to calculate total price.

$record = ProductDetails::with('inventoryName')->whereDate('created_at', '=', date($date))
      ->select('inventory_id',DB::raw('sum(price) as item_price'),DB::raw('sum(quantity) as quantity'))->groupBy('inventory_id')->get();

My output is :

[
  {
    inventory_id: 9,
    item_price: 30,
    quantity: 30,
    inventory_name: [
      {
        id: 9,
        name: "sugar"
      }
    ]
  },
  {
    inventory_id: 10,
    item_price: 70,
    quantity: 70,
    inventory_name: [
      {
        id: 10,
        name: "oil"
      }
    ]
  }
]

Now i need to calculate total price.How to do this.

Possible duplicate of [Laravel Eloquent: sum with groupBy](https://stackoverflow.com/questions/24887708/laravel-eloquent-sum-with-groupby) — Ankur Tiwari, Sep 06 '19 at 07:04
Do you want `total price = (item_1_price * item_1_quantity) +(item_2_price * item_2_quantity) +...` ? — Dark Knight, Sep 06 '19 at 07:12

score 1 · Accepted Answer · answered Sep 06 '19 at 07:26

1

You can use Laravel Collection: SUM method.

1. If $record is already a collection:
echo $record->sum('item_price');

2. If $record is an array.
$collection = collect($record);
$collection->sum('item_price');

answered Sep 06 '19 at 07:26

Dark Knight

6,116
1
15
37

Did use sum of sum with groupby in Laravel

1 Answers1