CODEWITHSUNDEEP
phparraysmultidimensional-array
flydev
flydev

Reputation: 5664

PHP Merge 2 arrays of multi-dimension arrays and sum value

I would like to merge those two arrays and make the sum of the value movements while keeping day.

first array:

array (30)
0 => array (2)
    day => "01" (2)
    movements => 49
1 => array (2)
    day => "02" (2)
    movements => 50
2 => array (2)
    day => "03" (2)
    movements => 54
...

second array : 

array (30)
0 => array (2)
    day => "01" (2)
    movements => 50
1 => array (2)
    day => "02" (2)
    movements => 51
2 => array (2)
    day => "03" (2)
    movements => 41
...

As a result I am expecting, an array of arrays with the same day index and the sum of movements:

array (30)
0 => array (2)
    day => "01" (2)
    movements => 99
1 => array (2)
    day => "02" (2)
    movements => 101
2 => array (2)
    day => "03" (2)
    movements => 95
...

Any help would be greatly appreciated.

Upvotes: 1

Views: 66

Answers (2)

Ravi Roshan
Ravi Roshan

Reputation: 570

$arr1 = [ ['day' => '01', 'movement' => 50], ['day' => '02', 'movement' => 10] ];
$arr2 = [ ['day' => '01', 'movement' => 20], ['day' => '02', 'movement' => 10] ];

$sum = [];

echo '<pre>';
print_r($arr1);
print_r($arr2);


if(!empty($arr1)){
    $result = [];
    foreach ($arr1 as $key => $value) {
        if(isset($arr2[$key]['day']) && $arr2[$key]['day'] == $value['day']){
            $result['day'] = $value['day'];
            $result['movement'] = $value['movement']+$arr2[$key]['movement'];
        }
        array_push($sum, $result);
    }
}

print_r($sum);

Upvotes: 1

Evaldas
Evaldas

Reputation: 58

It is even calculate movments if any array miss any day.

<?php
$arrayFirst = [
    ['day' => '01', 'movements' => 10],
    ['day' => '02', 'movements' => 20],
    ['day' => '04', 'movements' => 40],
];

$arraySecond = [
    ['day' => '01', 'movements' => 15],
    ['day' => '03', 'movements' => 30],
    ['day' => '04', 'movements' => 45],
];

$arrColFirst = array_column($arrayFirst, 'movements', 'day');
$arrColSecond = array_column($arraySecond, 'movements', 'day');
$merrgedArray = array_merge($arrColFirst, $arrColSecond);

$result = [];
foreach ($merrgedArray as $day=> $movments) {
    $result[$day] =  [
        'day' => $day,
        'movements' => isset($arrColFirst[$day]) ? $arrColFirst[$day] + $movments : $movments,
    ];
}

sort($result);

Upvotes: 1

Related Questions