PHP怎么往间隔数组中添加数据

Question

现有一数组如下：
[site003] => Array

    (
        [0] => Array
            (
                [key] => site003
                [riqi] => 2016-06-14
                [shijian] => 00
                [num] => 1
            )

        [1] => Array
            (
                [key] => site003
                [riqi] => 2016-06-14
                [shijian] => 04
                [num] => 2
            )

        [2] => Array
            (
                [key] => site003
                [riqi] => 2016-06-14
                [shijian] => 07
                [num] => 6
            )

    )

由于时间shijian字段00到-04点中间没有01，02，03时间点,所以想对01，02，03时间点组装数据的num字段补充为0，
后者04-07中间时间点05，06也对num的时间点补充数组为0
麻烦各路高手指点迷津！小弟在此谢谢！

Answer 1

首先你需要确定你是否需要插入相关数据以及你插入的数据的方案，如果你不能确定中间缺失的shijian字段的始末的话，需要遍历这个数组去确定，然后将没有的字段加进去，然后用usort进行排序。
也可以在插入的时候决定你插入的位置，但是由于你插入会影响你数组的下标，所以还是上面第一个方法比较方便。
参考代码

<?php


$max_shijian = date("H");

// 填充主方法
$fill_date = function ($input,$key) use($max_shijian) {
  $hours = range(0,$max_shijian);
  $riqi = null;
  // 筛选出不存在的时间
  // http://php.net/manual/zh/function.array-map.php
  array_map(function(&$item,$key) use(&$hours,&$riqi){
    empty($riqi) and $riqi = $item['riqi'];
    unset($hours[intval($item['shijian'])]);
  },$input);
  // 填充不存在的时间
  foreach ($hours as $hour) {
    $input[] =   [
        'key' => $key,
        'riqi'  => $riqi,
        'shijian' => getFullHour($hour),
        'num' => 0,
      ];
  }
  // 排序
  // http://php.net/manual/zh/function.usort.php
  usort($input,function($a,$b){
    return (intval($a['shijian'])<intval($b['shijian']))?-1:1;
  });
  return $input;
};

// 将小时补全为2位
function getFullHour($hour){
  return (strlen($hour)==1)?("0".$hour):$hour;
}

$json = '{"site001":[{"key":"site001","riqi":"2016-06-14","shijian":"00","num":"10"},{"key":"site001","riqi":"2016-06-14","shijian":"01","num":"4"},{"key":"site001","riqi":"2016-06-14","shijian":"02","num":"1"},{"key":"site001","riqi":"2016-06-14","shijian":"03","num":"3"},{"key":"site001","riqi":"2016-06-14","shijian":"04","num":"2"},{"key":"site001","riqi":"2016-06-14","shijian":"05","num":"1"},{"key":"site001","riqi":"2016-06-14","shijian":"07","num":"9"},{"key":"site001","riqi":"2016-06-14","shijian":"08","num":"2"}],"site002":[{"key":"site002","riqi":"2016-06-14","shijian":"00","num":"3"},{"key":"site002","riqi":"2016-06-14","shijian":"01","num":"13"},{"key":"site002","riqi":"2016-06-14","shijian":"02","num":"8"},{"key":"site002","riqi":"2016-06-14","shijian":"03","num":"23"},{"key":"site002","riqi":"2016-06-14","shijian":"04","num":"14"},{"key":"site002","riqi":"2016-06-14","shijian":"05","num":"6"},{"key":"site002","riqi":"2016-06-14","shijian":"06","num":"4"},{"key":"site002","riqi":"2016-06-14","shijian":"07","num":"7"},{"key":"site002","riqi":"2016-06-14","shijian":"08","num":"18"},{"key":"site002","riqi":"2016-06-14","shijian":"09","num":"6"}],"site003":[{"key":"site003","riqi":"2016-06-14","shijian":"00","num":"1"},{"key":"site003","riqi":"2016-06-14","shijian":"04","num":"2"},{"key":"site003","riqi":"2016-06-14","shijian":"07","num":"6"}],"site004":[{"key":"site004","riqi":"2016-06-14","shijian":"00","num":"3"},{"key":"site004","riqi":"2016-06-14","shijian":"02","num":"1"},{"key":"site004","riqi":"2016-06-14","shijian":"03","num":"4"},{"key":"site004","riqi":"2016-06-14","shijian":"04","num":"7"},{"key":"site004","riqi":"2016-06-14","shijian":"05","num":"4"},{"key":"site004","riqi":"2016-06-14","shijian":"06","num":"2"}]}';
$data = json_decode($json,true);

foreach ($data as $key => $value) {
  $data[$key] = call_user_func($fill_date,$value,$key);
}
print_r($data);


?>

array_map
usort

Answer 2

我说说我理解的思路，首先要先取你这个数组中shijian字段的最大值，然后根据最大值循环填充。

Answer 3

你试下以下方法，
主要采用的思路是：
1.先从给定的数组中过滤出最大的shijian值，同时存储已经存在的时间值，
2.添加小于最大shijian值且不存在数组中的数据

    $srcArray = array
    (array(
                'key'  => 'site003',
                'riqi'=> '2016-06-14',
                'shijian' => 00,
                'num' => 1,
            )
                 ,array
            (
                'key' => 'site003',
                'riqi' => '2016-06-14',
                'shijian' => 02,
                'num'=> 2
            )
     ,array
            (
                'key' => 'site003',
                'riqi' => '2016-06-14',
                'shijian' => 04,
                'num'=> 2
            )
    );

    $data=array(-1);
    foreach($srcArray as $key=>$innerArray){
        array_push($data,$innerArray['shijian']);
        if($innerArray['shijian'] > $data[0]){
            $data[0] = intval($innerArray['shijian']);
        }
    }
    print_r($data);
    for($index = 0;$index<$data[0];$index++){
        $exits= !array_search(intval($index),$data);
        if($exits){
            $temp = array(
                'key'  => 'site003',
                'riqi'=> '2016-06-14',
                'shijian' => $index<10?'0'.$index:$index,
                'num' => 0,
            );
            array_push($srcArray,$temp);
        }
    }
    print_r($srcArray);