求助php 数组转换问题

Question

昨天有朋友说看不懂什么意思 我现在截图说明一下 我想用echarts 做图表数据 查询出来的数据是下图左边的样子 要做成右边数据图表对应的样式所以求大神帮帮忙 再附一张图片格式的数据

Answer 1

   json_decode

Answer 2

先转让数据格式为下面的（不知道还有没有精简的方法。。）

    $arr = [
        '1' => [
            [
                'month'     => '2016-08',
                'sum_money' => 250000,
            ],
            [
                'month'     => '2016-09',
                'sum_money' => 250000,
            ],
        ],
        '2' => [
            [
                'month'     => '2016-08',
                'sum_money' => 250000,
            ],
            [
                'month'     => '2016-09',
                'sum_money' => 250000,
            ],
        ],
        '3' => [
            [
                'month'     => '2016-08',
                'sum_money' => 250000,
            ],
            [
                'month'     => '2016-09',
                'sum_money' => 250000,
            ],
        ]
    ];
    foreach ($arr as $name => $item) {
        $series[] = [
            'name' => $name,
            'data' => array_column($item, 'sum_money')
        ];
    }

    $xAxis = array_column(array_pop($arr), 'month');
    dump($xAxis);

    $series = json_encode($series);
    dump($series);

Answer 3

我思路是,你先把日期取出来,array_column这样就可以获取到日期数组,然后根据日期数组去遍历元数组获取统计数据,所有数据需要跟日期的数组顺序一致,然后json_encode返回给前端.

Answer 4

<?php
$array = [
        ['month'=>'2016-08', 'borrow_duration' => '1', 'sum_money'=>'1234'],
        ['month'=>'2016-08', 'borrow_duration' => '2', 'sum_money'=>'1231'],
        ['month'=>'2016-09', 'borrow_duration' => '1', 'sum_money'=>'2230'],
        ['month'=>'2016-09', 'borrow_duration' => '3', 'sum_money'=>'56723'],
    ];

$month = [];
$data  = [];
foreach($array as $key => $value){
    $month[$value['month']] = $value['month'];
    $data[$value['borrow_duration']]['name'] = $value['borrow_duration'];
    $data[$value['borrow_duration']]['data'][] = $value['sum_money'];
}
$month = array_values($month);
$data = array_values($data);

echo json_encode($month);
echo json_encode($data);

Answer 5

echarts好像可以直接用json格式的

Answer 6

class SegmentFault
{

public $array = array(
    array('month' => '2016-03', 'borrow_duration' => '1', 'sum_money' => '230000'),
    array('month' => '2016-04', 'borrow_duration' => '2', 'sum_money' => '240000'),
    array('month' => '2016-05', 'borrow_duration' => '3', 'sum_money' => '250000'),
    array('month' => '2016-06', 'borrow_duration' => '1', 'sum_money' => '260000'),
    array('month' => '2016-07', 'borrow_duration' => '2', 'sum_money' => '270000'),
    array('month' => '2016-08', 'borrow_duration' => '3', 'sum_money' => '280000')
);

public function echarts()
{
    foreach ($this->array as $key => $value)
    {
        $res['data'][] = $value['month'];
        $res[$value['borrow_duration']]['name'] = $value['borrow_duration'];
        $res[$value['borrow_duration']]['data'][] = $value['sum_money'];
    }

    return $res;
}

}

$instance = new SegmentFault();
$res = $instance->echarts();
echo json_encode($res);