php二维数组格式在laravel中转换为echarts格式

Question

我有一个从数据库中查询的结果集。

$promotions = array(
array('goods_num' => 2, 'promotion_type' => 'General goods', 'date' => '2020-02-04',),
array('goods_num' => 1, 'promotion_type' => 'Discount', 'date' => '2020-02-04',),
array('goods_num' => 1, 'promotion_type' => 'Flash sale', 'date' => '2020-02-04',),

array('goods_num' => 10, 'promotion_type' => 'Discount', 'date' => '2020-02-05',),
array('goods_num' => 10, 'promotion_type' => 'General goods', 'date' => '2020-02-05',),
array('goods_num' => 9, 'promotion_type' => 'Flash sale', 'date' => '2020-02-05',),
array('goods_num' => 2, 'promotion_type' => 'Flash sale', 'date' => '2020-02-06',),
array('goods_num' => 1, 'promotion_type' => 'General goods', 'date' => '2020-02-06',),
array('goods_num' => 2, 'promotion_type' => 'General goods', 'date' => '2020-02-06',),
array('goods_num' => 1, 'promotion_type' => 'General goods', 'date' => '2020-02-07',),
array('goods_num' => 2, 'promotion_type' => 'Flash sale', 'date' => '2020-02-07',),
array('goods_num' => 3, 'promotion_type' => 'Discount', 'date' => '2020-02-07',),
);

我想把它显示为图表。像这个演示一样，我想把上面的数组转换成这样的格式：

array(
0 => array(0 => 'date', 1 => '2020-02-04', 2 => '2020-02-05', 3 => '2020-02-06', 4 => '2020-02-07',),
1 => array(0 => 'General goods', 1 => 2, 2 => 10, 3 => 3, 4 => 1,),
2 => array(0 => 'Discount', 1 => 1, 2 => 10, 3 => 0, 4 => 3,),
3 => array(0 => 'Flash sale', 1 => 1, 2 => 9, 3 => 2, 4 => 2,),
);

第一行是x轴的日期，之后是每次促销日期中商品数量的总和。

我试着用两个foreach循环来处理它，但我无法得到我想要的结果。感谢所有

Answer 1

您可以使用array_column来获取日期，然后循环数组来构建goods_num。

$promotions = array(
array('goods_num' => 2, 'promotion_type' => 'General goods', 'date' => '2020-02-04',),
array('goods_num' => 1, 'promotion_type' => 'Discount', 'date' => '2020-02-04',),
array('goods_num' => 1, 'promotion_type' => 'Flash sale', 'date' => '2020-02-04',),
array('goods_num' => 10, 'promotion_type' => 'Discount', 'date' => '2020-02-05',),
array('goods_num' => 10, 'promotion_type' => 'General goods', 'date' => '2020-02-05',),
array('goods_num' => 9, 'promotion_type' => 'Flash sale', 'date' => '2020-02-05',),
array('goods_num' => 2, 'promotion_type' => 'Flash sale', 'date' => '2020-02-06',),
array('goods_num' => 1, 'promotion_type' => 'General goods', 'date' => '2020-02-06',),
array('goods_num' => 2, 'promotion_type' => 'General goods', 'date' => '2020-02-06',),
array('goods_num' => 1, 'promotion_type' => 'General goods', 'date' => '2020-02-07',),
array('goods_num' => 2, 'promotion_type' => 'Flash sale', 'date' => '2020-02-07',),
array('goods_num' => 3, 'promotion_type' => 'Discount', 'date' => '2020-02-07',),
);
$dates = array_unique(array_column($promotions , "date"));
$new[] = array(array_merge(['date'], $dates));
// Now the array has all the dates done
foreach($promotions as $item){
// Make associative array and place values in the subarrays
if(!isset($new[$item['promotion_type']])){
$new[$item['promotion_type']][] = $item['promotion_type'];
}
$new[$item['promotion_type']][] =$item['goods_num'];
}
//Remove associative array
$new = array_values($new);
var_dump($new);

https://3v4l.org/GDNpP

Answer 2

我用laravel的集合解决了这个问题

$dataSets = array_unique( array_column($promotions, 'date'));
$promotionTypes = array_unique(array_column($promotions, 'promotion_type'));
$promotionTypeOrders = $promotions->groupBy('promotion_type')->map(function ($item) {
return $item->groupBy('date');
});
$promotionGroups = [];
foreach ($dateSets as $dateSet) {
foreach ($promotionTypes as $promotionType) {
$promotionGroups[$promotionType][$dateSet] = isset($promotionTypeOrders[$promotionType][$dateSet]) ? $promotionTypeOrders[$promotionType][$dateSet]->sum('goods_num') : 0;
}
}
$result = [];
foreach ($promotionGroups as $promotionName => $promotionGroup) {
$result[] = array_merge([$promotionName], array_values($promotionGroup));
}
array_unshift($dateSets, 'date');
return array_merge([array_values($dateSets)], $result);

Answer 3

这里是一个使用原始PHP的示例。但是，您的数组中没有相同的计数($keys(，所以：

# Create variables
$results  = [];
$date     = ['Date'];
$goods    = ['General goods'];
$sale     = ['Flash sale'];
$discount = ['Discount'];
# Fetch data
foreach ($promotions as $promo) {
# Getting general goods values
if (array_search('General goods', $promo)) {
array_push($goods, $promo['goods_num']);
array_push($date, $promo['date']);
}
# Getting flash sale values
if (array_search('Flash sale', $promo)) {
array_push($sale, $promo['goods_num']);
array_push($date, $promo['date']);
}
# Getting discount values
if (array_search('Discount', $promo)) {
array_push($discount, $promo['goods_num']);
array_push($date, $promo['date']);
}
}
# Construct results
array_push($results, $date);
array_push($results, $goods);
array_push($results, $sale);
array_push($results, $discount);
# Clear ram
unset($date, $goods, $sale, $discount, $promo);
# Printing results
echo "<pre>";
print_r($results);

结果：

Array
(
[0] => Array
(
[0] => Date
[1] => 2020-02-04
[2] => 2020-02-04
[3] => 2020-02-04
[4] => 2020-02-05
[5] => 2020-02-05
[6] => 2020-02-05
[7] => 2020-02-06
[8] => 2020-02-06
[9] => 2020-02-06
[10] => 2020-02-07
[11] => 2020-02-07
[12] => 2020-02-07
)
[1] => Array
(
[0] => General goods
[1] => 2
[2] => 10
[3] => 1
[4] => 2
[5] => 1
)
[2] => Array
(
[0] => Flash sale
[1] => 1
[2] => 9
[3] => 2
[4] => 2
)
[3] => Array
(
[0] => Discount
[1] => 1
[2] => 10
[3] => 3
)
)

Answer 4

function group_by($key, $data) {
$result = array();
foreach($data as $val) {
if(array_key_exists($key, $val)){
$result[$val[$key]][] = $val;
}else{
$result[""][] = $val;
}
}
return $result;
}
function format_chart($promotions){
$group_by_date = group_by("date", $promotions);
$dates = array_keys($group_by_date);
$top = array_merge(array("date"), $dates);
$data = array();
foreach($promotions as $promotion){
if(isset($data[$promotion['promotion_type']][$promotion['date']])){
$data[$promotion['promotion_type']][$promotion['date']] += $promotion['goods_num'];
}
else{
$data[$promotion['promotion_type']][$promotion['date']] = $promotion['goods_num'];
}
}
$final[] = $top;
foreach($data as $key => $val){
$row[] = $key;
foreach($dates as $date){
$count = 0;
if(isset($val[$date])){
$count = $val[$date];
}
$row[] = $count;
}
$final[] = $row;
$row = array();
}
return $final;
}
$formatted_data = format_chart($promotions);