计算具有相同日期的元素的和 - Calculate the sum of elements if have the same date

Calculate the sum of elements if have the same date

本文关键字：元素日期计算 | 更新日期: 2023-09-27

我有一个问题，我有这个数组:

Array
(
[0] => Array
    (
        [date] => 2015-07-07
        [nb] => 12
    )
[1] => Array
    (
        [date] => 2015-07-10
        [nb] => 6
    )
[2] => Array
    (
        [date] => 2015-07-07
        [nb] => 8
    )
[3] => Array
    (
        [date] => 2015-07-09
        [nb] => 48
    )
[4] => Array
    (
        [date] => 2015-07-09
        [nb] => 42
    )
 }

但是我想得到这个:

Array
(
 [0] => Array
  (
    [date] => 2015-07-07
    [nb] => 20
  )
 [1] => Array
  (
    [date] => 2015-07-09
    [nb] => 90
   )
 [2] => Array
  (
    [date] => 2015-07-10
    [nb] => 6
   )
 }

这个想法是如果数组中存在多个日期[nb]必须加起来。

我试过了:

foreach($aTotalRows as $k=>$row){
  if($row[$k]['date'] == $row[$k+1]['date']){
    $row[$k]['nb'] = $row[$k]['nb'] + $row[$k+1]['nb'] 
  }
}

但不工作这个解决方案，你能帮我吗?提前致谢

不行，只有先按日期排序....才能正常工作试着构建如下代码:

$aggregateArray = array();
foreach($aTotalRows as $row) {
    if(!array_key_exists($row['date'], $aggregateArray) {
        $aggregateArray[$row['date']] = 0;
    }
    $aggregateArray[$row['date']] += $row['nb'] 
}

，它会给你这样的东西:

Array(
    ['2015-07-07'] => 20
    ['2015-07-10'] => 90
    ['2015-07-11'] => 6
)

你可以在必要的时候重新构造它

如果您想处理未排序的数组，您必须更改代码，如

$input = array(
    array('date' => '2015-07-07', 'nb' => 12),
    array('date' => '2015-07-10', 'nb' => 6),
    array('date' => '2015-07-07', 'nb' => 8),
    array('date' => '2015-07-09', 'nb' => 48),
    array('date' => '2015-07-09', 'nb' => 42)
 );
$required = array();
array_walk($input, function($v) use(&$required){
    if(!isset($required[$v['date']])){ $required[$v['date']] = 0; }
    $required[$v['date']] += $v['nb'];
});
$final = array_map(function($v, $k){
            return array('date'=>$k, 'nb'=>$v);
        }, $required, array_keys($required));

dump $required

array (size=3)
  '2015-07-07' => int 20
  '2015-07-10' => int 6
  '2015-07-09' => int 90

dump of $final

array (size=3)
  0 => 
    array (size=2)
      'date' => string '2015-07-07' (length=10)
      'nb' => int 20
  1 => 
    array (size=2)
      'date' => string '2015-07-10' (length=10)
      'nb' => int 6
  2 => 
    array (size=2)
      'date' => string '2015-07-09' (length=10)
      'nb' => int 90

你可以在一个路径

$keys = array(); // array date => index in result
$i = 0;
foreach($input as $item) 
   if (isset($keys[$item['date']]))                         // if exist
       $result[$keys[$item['date']]]['nb'] += $item['nb'];  //  add value
   else {  
       $keys[$item['date']] = $i;                           // create new items in arrays
       $result[$i++] = $item;
   }
print_r($result);