我已經(jīng)通過(guò)inventory_id 對(duì)列價(jià)格組求和。此外,我需要計(jì)算總價(jià)。$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();我的輸出是:[ { 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" } ] }]現(xiàn)在我需要計(jì)算總價(jià)。如何做到這一點(diǎn)。
在 Laravel 中使用了 groupby 的總和
呼喚遠(yuǎn)方
2022-01-02 16:22:08