如何获取"orderBy"月份的数据，但从当前月份开始，依此类推

Question

尝试按月份获取数据，对于第一部分，它运行得很好，现在只停留在2点。

1. 带有年份的必填月份名称(例如"2022年3月"(
2. 在OrderBy中也需要同样的内容，从当月(2022年3月(开始，然后再继续(2022年4月、2022年5月和2022年6月……2022年1月和2月(

我的控制器

$getdatapermonth    =   Dairyincome::select(
DB::raw('(MONTHNAME(date)) as "month_name",SUM(cmilkquantity) as "cmilkquantity", SUM(cmilkamount) as "cmilkamount",SUM(bmilkquantity) as "bmilkquantity", SUM(bmilkamount) as "bmilkamount", SUM(totalamount) as "totalamount"')
)
->where('customerid',$customerid)   
->whereYear('date', date('Y'))
->groupBy('month_name')
->get()->toArray();

阵列我得到

array:3 [▼
0 => array:6 [▼
"month_name" => "January"
"cmilkquantity" => "0.00"
"cmilkamount" => "0.00"
"bmilkquantity" => "10.00"
"bmilkamount" => "450.00"
"totalamount" => "450.00"
]
1 => array:6 [▼
"month_name" => "February"
"cmilkquantity" => "2.00"
"cmilkamount" => "70.00"
"bmilkquantity" => "0.00"
"bmilkamount" => "0.00"
"totalamount" => "70.00"
]
2 => array:6 [▼
"month_name" => "March"
"cmilkquantity" => "2.00"
"cmilkamount" => "70.00"
"bmilkquantity" => "2.00"
"bmilkamount" => "70.00"
"totalamount" => "140.00"
]
]

提前感谢。

Answer 1

只需更改：

DB::raw('(MONTHNAME(date)) as "month_name"')

至：

DB::raw('DATE_FORMAT(date, "%M %Y") as "month_name"')

它将输出月份名称为"；YYYY月"；总体安排