Php数组拉链-按键值添加两个数组

Question

我正在尽可能高效地完成这项工作。

我有多个阵列：

array1 = [
"2018" => 
[
"JAN" => 100,
"FEB" => 200,
"MAR" => 300,
"APR" => 400
]
]
array2 = [
"2018" => 
[
"FEB" => 200,
"MAR" => 300,
"APR" => 400,
"MAY" => 200,
]
]
array3 = [
"2018" => 
[
"MAY" => 200,
"JUN" => 100,
"JUL" => 300,
"AUG" => 400,
]
]

我想将这些数组与年/月总计的期望输出相加：

sumArray = [
"2018" => 
[
"JAN" => 100,
"FEB" => 400,
"MAR" => 600,
"APR" => 800
"MAY" => 400,
"JUN" => 100,
"JUL" => 300,
"AUG" => 400,
]
]

我想避免多个foreach循环，并认为使用array_map、array_walk或其他任何东西都会有更好的解决方案。有人有主意吗？

感谢

Answer 1

这里有一个foreach。但是三元ifs:

$monthCodes = array("JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC");
foreach($monthCodes as $key => $monthCode){
$add = 0;
$add += ( isset($array1["2018"][$monthCode]) ) ?  $array1["2018"][$monthCode] : 0;
$add += ( isset($array2["2018"][$monthCode]) ) ?  $array2["2018"][$monthCode] : 0;
$add += ( isset($array3["2018"][$monthCode]) ) ?  $array3["2018"][$monthCode] : 0;
if($add <> 0){
$sumArray["2018"][$monthCode] = $add;
}
}

Answer 2

我认为您需要使用某种foreach来有效地做到这一点。

我创建了一个包含所有数组的新数组，并循环它的子数组来求和值。

// Add arrays that needs to be summed in the line below
$new = array_merge_recursive([$array1], [$array2], [$array3]);
foreach($new as $arr){
foreach($arr as $year => $sub){
foreach($sub as $month => $val){
if(!isset($res[$year][$month])) $res[$year][$month] =0;
$res[$year][$month] += $val;
}
}
}
var_dump($res);

https://3v4l.org/WHdDJi