Laravelで日月年ごとにレポートを作成する

Question

私のコードサム製品と数量と価格ですが、最初は日、年、月に3つの関数が必要です。次は毎月、最後は毎年、製品の合計を取得します。

コード

$product_orders = \App\OrderProduct::select(DB::raw('sum(line_total) as total_line'),
DB::raw('sum(qty) as qty') , 'product_id','line_total','created_at')->
orderBy('created_at')->groupBy('product_id')->get();

DB

id , prdouct_id ,order_id, qty ,unit_total , line_total , created_at , updated_at

Answer 1

##for grouping you can use it like these

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

これを試して、何が起こったのか教えてください