将此对象数组转换为顶点图中月用户计数的普通数组

Question

[{
"January": 0,
"February": 0,
"March": 0,
"April": 0,
"May": 1342.58,
"June": 0,
"July": 0,
"August": 0,
"September": 0,
"October": 0,
"November": 0,
"December": 0
}]

上面是我希望它转换的对象数组，如下所示：-

[0, 0, 0, 0, 1342.58, 0, 0, 0, 0, 0, 0, 0,]

以下是我的控制器代码：-

public function dashboardView(Request $request){
$data = CustomerTransaction::SELECT(DB::raw("SUM(CASE MONTH(created_at) WHEN 1 THEN total_price ELSE 0 END) AS 'January',
SUM(CASE MONTH(created_at) WHEN 2 THEN total_price ELSE 0 END) AS 'February',
SUM(CASE MONTH(created_at) WHEN 3 THEN total_price ELSE 0 END) AS 'March',
SUM(CASE MONTH(created_at) WHEN 4 THEN total_price ELSE 0 END) AS 'April',
SUM(CASE MONTH(created_at) WHEN 5 THEN total_price ELSE 0 END) AS 'May',
SUM(CASE MONTH(created_at) WHEN 6 THEN total_price ELSE 0 END) AS 'June',
SUM(CASE MONTH(created_at) WHEN 7 THEN total_price ELSE 0 END) AS 'July',
SUM(CASE MONTH(created_at) WHEN 8 THEN total_price ELSE 0 END) AS 'August',
SUM(CASE MONTH(created_at) WHEN 9 THEN total_price ELSE 0 END) AS 'September',
SUM(CASE MONTH(created_at) WHEN 10 THEN total_price ELSE 0 END) AS 'October',
SUM(CASE MONTH(created_at) WHEN 11 THEN total_price ELSE 0 END) AS 'November',
SUM(CASE MONTH(created_at) WHEN 12 THEN total_price ELSE 0 END) AS 'December'"))->get();      
return $data;
}

Answer 1

您只需要从数据的第一行中提取值即可删除键...

return array_values($data[0]);

array_values()将强制将对象$data[0]转换为数组，然后将值提取到数组中。