用拉拉威尔语做报告

Question

我按月做报告，我需要得到产品本月售出的数量和数量我的代码返回所有产品，但我如何对同一产品求和，例如

{
product_id: 1,
qty: 2,
line_total: 120,
created_at: "2020-07-30T12:06:04.000000Z"
},
{
product_id: 1,
qty: 2,
line_total: 120,
created_at: "2020-07-30T12:06:04.000000Z"
},

我需要像这个一样退货

{
product_id: 1,
qty: 4,
line_total: 240,
created_at: "2020-07-30T12:06:04.000000Z"
}

我的代码

$product_orders =  AppOrderProduct::select('product_id','qty','line_total','created_at')
->orderBy('created_at')->get();
$product_orders->groupBy(function ($item, $key) {
return $item->created_at->format('m');
});
return $product_orders;

Answer 1

试试这个代码。。。希望它能起作用

使用数据库；

$products= OrderProduct::select(
DB::raw('MONTHNAME(created_at) as month'),
DB::raw('YEAR(created_at) as year'),
DB::raw('DAY(created_at) as day'),DB::raw('sum(line_total) as total_line') , 'product_id','qty','line_total','created_at')->groupBy('year', 'month','day')->get();