数组计算差值及项的小计,该如何处理

程序员文章站 2024-01-28 14:54:40

...

数组计算差值及项的小计

本帖最后由 lazygc520 于 2014-04-14 16:19:41 编辑 $s = array ( 0 => array ( 0 => array ( 0 => '2014-04-11', 'time' => '2014-04-11', 1 => 'BEA01-120N', 'type' => 'BEA01-120N', 2 => 176, 'count' => 176, ), 1 => array ( 0 => '2014-04-11', 'time' => '2014-04-11', 1 => 'BEA21-110N', 'type' => 'BEA21-110N', 2 => 1056, 'count' => 1056, ), ), 1 => array ( 0 => array ( 0 => '2014-04-11', 'time' => '2014-04-11', 1 => 'BEA01-120N', 'type' => 'BEA01-120N', 2 => 192, 'count' => 192, ), 1 => array ( 0 => '2014-04-11', 'time' => '2014-04-11', 1 => 'BEA21-110N', 'type' => 'BEA21-110N', 2 => 960, 'count' => 960, ), ), )

求其type对应的差值和$s[0]及$s[1]的type项的小计。（小计部分已实现，用了unset）

理想得到的结果：

小计的结果： BEA01-120N 176 BEA01-120N 192 差值：176-192 = -16
BEA21-110N 1056 BEA21-110N 960 1056-960 = 96
小计：176+1056=1232 192+960 = 1152
------解决方案--------------------

$s = array (
  0 => array (
    0 => array (
      0 => '2014-04-11', 'time' => '2014-04-11',
      1 => 'BEA01-120N', 'type' => 'BEA01-120N',
      2 => 176, 'count' => 176,
    ),
    1 => array (
      0 => '2014-04-11', 'time' => '2014-04-11',
      1 => 'BEA21-110N', 'type' => 'BEA21-110N',
      2 => 1056, 'count' => 1056,
    ),
  ),
  1 => array (
    0 => array (
      0 => '2014-04-11', 'time' => '2014-04-11',
      1 => 'BEA01-120N', 'type' => 'BEA01-120N',
      2 => 192, 'count' => 192,
    ),
    1 => array (
      0 => '2014-04-11', 'time' => '2014-04-11',
      1 => 'BEA21-110N', 'type' => 'BEA21-110N',
      2 => 960, 'count' => 960,
    ),
  ),
);

function foo($a, $b) {
  for($i=0; $i    $res[] = array($a[$i]['type'], $a[$i]['count'] - $b[$i]['count']);
  }
  return $res;
}

$t = call_user_func_array('foo', $s);
print_r($t);

Array
(
    [0] => Array
        (
            [0] => BEA01-120N
            [1] => -16
        )

    [1] => Array
        (
            [0] => BEA21-110N
            [1] => 96
        )

)

小计你已经做了，我就偷懒了
------解决方案--------------------
$s = array (
0 => array (
0 => array (
0 => '2014-04-11', 'time' => '2014-04-11',
1 => 'BEA01-120N', 'type' => 'BEA01-120N',
2 => 176, 'count' => 176,
),