Sum of multidimensional array in same format

Question

I have a multidimensional array in the following format :

array (
  0 => 
  array (
    'manual' => 1,
    'cancelled' => 1,
    'expired' => 1,
    'earned' => 1,
    'user' => 
    array (
      'user1' => 1,
      'user2' => 1,
      'user3' => 1,
      'user4' => 1,
    ),
    'transfer' => 
    array (
      'transfer1' => 
      array (
        'key1' => 1,
        'key2' => 1,
        'key3' => 1,
      ),
      'transfer2' => 
      array (
        'key5' => 1,
        'key6' => 1,
        'key7' => 1,
      ),
    ),
    'date' => '2018-03-07',
  ),
  1 => 
  array (
    'manual' => 1,
    'cancelled' => 1,
    'expired' => 1,
    'earned' => 1,
    'user' => 
    array (
      'user1' => 1,
      'user2' => 1,
      'user3' => 1,
      'user4' => 1,
    ),
    'transfer' => 
    array (
      'transfer1' => 
      array (
        'key1' => 1,
        'key2' => 1,
        'key3' => 1,
      ),
      'transfer2' => 
      array (
        'key5' => 1,
        'key6' => 1,
        'key7' => 1,
      ),
    ),
    'date' => '2018-03-08',
  ),

)I need to calculate the sum of the array values with same index. So the total array should be as the following

Array
(
    [total] => Array
        (
            [manual] => 2
            [cancelled] => 2
            [expired] => 2
            [earned] => 2
            [user] => Array
                (
                    [user1] => 2
                    [user2] => 2
                    [user3] => 2
                    [user4] => 2
                )

            [transfer] => Array
                (
                    [transfer1] => Array
                        (
                            [key1] => 2
                            [key2] => 2
                            [key3] => 2
                        )

                    [transfer2] => Array
                        (
                            [key5] => 2
                            [key6] => 2
                            [key7] => 2
                        )
        )

That is the total should have the same format except date, but it needs to show the total sum of the value. How can this be done in PHP ? I have used the following code

$final = array_shift($input);
foreach ($final as $key => &$value){
  $value += array_sum(array_column($input, $key));
}

unset($value);

var_dump($final);

where $input is considered as the first array and $final is total. I think this only work with single indexes.

@AlivetoDie the index manual in the 0th element needs to be added to manual in the first element. So in total the value for manual index is 2. This is same for all other indexes. — Happy Coder
– Happy Coder, Commented Mar 19, 2018 at 11:38
so based on manual you are going to check sub-arrays need to be added or not? Am i right? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Mar 19, 2018 at 11:39
you can find the solution here stackoverflow.com/questions/1496682/… — kashalo
– kashalo, Commented Mar 19, 2018 at 11:42
nope. It is like $total['total']['manual'] = $array[0]['manual']+ $array[1]['manual'] and $total['total']['cancelled'] = $array[0]['cancelled']+ $array[1]['cancelled'] and $total['total']['user']['user1'] = $array[0]['user']['user1']+ $array[1]['user']['user1'] — Happy Coder
– Happy Coder, Commented Mar 19, 2018 at 11:44

ABelikov · Accepted Answer · 2018-03-19 14:13:51Z

You can use recursive function which walk through all you "tree".

There

If element is array create same in result array and run function for each key. If it has a number, just add value to result.

Here is a SAMPLE

<?php
// Array with data
$arr=array(array('manual'=>1,'cancelled'=>1,'expired'=>1,'earned'=>1,'user'=>array('user1'=>1,'user2'=>1,'user3'=>1,'user4'=>1,),'transfer'=>array('transfer1'=>array('key1'=>1,'key2'=>1,'key3'=>1,),'transfer2'=>array('key5'=>1,'key6'=>1,'key7'=>1,)),'date'=>'2018-03-07',),array('manual'=>1,'cancelled'=>1,'expired'=>1,'earned'=>1,'user'=>array('user1'=>1,'user2'=>1,'user3'=>1,'user4'=>1,),'transfer'=>array('transfer1'=>array('key1'=>2,'key2'=>2,'key3'=>2,),'transfer2'=>array('key5'=>2,'key6'=>2,'key7'=>2,)),'date'=>'2018-03-08',)); 

//Init result array
$res=array('total'=>array());

foreach ($arr as $key=>$val) {
    //Run it for each element and store result to $res['total']
   countTotal($res['total'],$val);
}

//Show result
print_r($res);


/*
* Count totals for branch of array
* @param $res - reference to branch of result array
* @param $arr - branch of data array
*/
function countTotal(&$res,$arr) {
        foreach ($arr as $key=>$val) {
            if (is_array($val)) {
                //it's array. Create "branch" in $res and run countTotal() to calc total for it
                if (!isset($res[$key])) $res[$key]=array();
                countTotal($res[$key],$val);
            } else if (is_numeric($val)) {
                // it's number. Create "leaf" if need and add value.
                if (!isset($res[$key])) $res[$key]=0;
                $res[$key]+=$val;
            }
        }
}

As you see it use reference to branch of result array for accumulating totals

Results

    Array
    (
        [total] => Array
            (
                [manual] => 2
                [cancelled] => 2
                [expired] => 2
                [earned] => 2
                [user] => Array
                    (
                        [user1] => 2
                        [user2] => 2
                        [user3] => 2
                        [user4] => 2
                    )

                [transfer] => Array
                    (
                        [transfer1] => Array
                            (
                                [key1] => 3
                                [key2] => 3
                                [key3] => 3
                            )

                        [transfer2] => Array
                            (
                                [key5] => 3
                                [key6] => 3
                                [key7] => 3
                            )

                    )

            )

    )

In second "transfer" I have used "2" so it's "3" in sum

sevavietl · Accepted Answer · 2018-03-19 13:12:02Z

You can write the recursive function like the following:

function array_sum_recursive_assoc($array, &$result = [])
{
    $keys = array_keys($array[0] ?? []);

    foreach ($keys as $key) {
        foreach (($column = array_column($array, $key)) as $value) {
            if (is_array($value)) {
                $result[$key] = [];
                array_sum_recursive_assoc($column, $result[$key]);
                continue 2;
            }

            // In this case date safe guard.
            if (!is_numeric($value)) {
                continue;
            }

            $result[$key] = ($result[$key] ?? 0) + $value;
        }
    }

    return $result;
}

var_dump(array_sum_recursive_assoc($array));

Here is the demo.

Collectives™ on Stack Overflow

Sum of multidimensional array in same format

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related