Grouping and adding values multidimensional array

Question

Code

foreach ($summary as $split) {
    if (isset($split['currency'])) {
        if (!isset($result[$split['currency']]) {
            $result[$split['currency']] = [
                'duration' => 0,
                'cost' => 0
            ];
        }
        $result[$split['currency']]['employee'] = $split['employee'];
        $result[$split['currency']]['duration'] += $split['duration'];
        $result[$split['currency']]['cost'] += $split['cost'];
    } else {
        $result[0]['employee'] = $split['employee'];
        $result[0]['duration'] += $split['duration'];
        $result[0]['cost'] += $split['cost'];
    }
}

My array looks like this

$summary = Array
(
[0] => Array
   (
    [employee] => John
    [currency] => SGD
    [duration] => 8.00
    [cost] => 228.57
)

[1] => Array
   (
    [employee] => Fil
    [currency] => SGD
    [duration] => 8.00
    [cost] => 228.57
 )

[2] => Array
(
    [employee] => John
    [currency] => 
    [duration] => 8.00
    [cost] => 
)

[3] => Array
(
    [employee] => John
    [currency] => MYR
    [duration] => 12.00
    [cost] => 342.86
)

[4] => Array
(
    [employee] => Sam
    [currency] => SGD
    [duration] => 8.00
    [cost] => 228.57
)

[5] => Array
(
    [employee] => Fil
    [currency] => MYR
    [duration] => 12.00
    [cost] => 342.86
)

I want to group the above array by employee and currency. What I require is similar to Stackoverflow

but in this grouping is done for currency only so in the output array there will be 3 inner array only.

I want to group the array such that the result will group first employee and then currency. So there will be 3 inner array for each employee

Avinash · Accepted Answer · 2016-11-14 07:01:54Z

1

just add the name as the key in $result array before currency key,

foreach ($summary as $split) {
        if (isset($split['currency'])) {
            if (!isset($result[$split['employee']][$split['currency']]) {
                $result[$split['employee']][$split['currency']] = [
                    'duration' => 0,
                    'cost' => 0
                ];
            }
            $result[$split['employee']][$split['currency']]['employee'] = $split['employee'];
            $result[$split['employee']][$split['currency']]['duration'] += $split['duration'];
            $result[$split['employee']][$split['currency']]['cost'] += $split['cost'];
        } else {
            $result[0]['employee'] = $split['employee'];
            $result[0]['duration'] += $split['duration'];
            $result[0]['cost'] += $split['cost'];
        }
    }

edited Nov 14, 2016 at 7:01

Avinash

2,0157 gold badges31 silver badges57 bronze badges

answered Nov 11, 2016 at 7:31

Parth Mahida

6141 gold badge5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cske · Accepted Answer · 2016-11-11 07:33:41Z

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);

$in = [
   ['employee'=>'A','currency'=>'USD','duration'=>8.00,'cost'=>42]
  ,['employee'=>'A','currency'=>'SDU','duration'=>8.00,'cost'=>42]
  ,['employee'=>'A','currency'=>'','duration'=>8.00,'cost'=>42]
  ,['employee'=>'B','currency'=>'USD','duration'=>8.00,'cost'=>42]
  ,['employee'=>'B','currency'=>'SDU','duration'=>8.00,'cost'=>42]
  ,['employee'=>'B','currency'=>'','duration'=>8.00,'cost'=>42]
];

$result = [];
$groupSum = function ($v) use (&$result) {
    $emp = $v['employee'];
    $curr = $v['currency'];
    if ( !array_key_exists($emp,$result) ) {
      $result[$emp] = [];
    }
    if ( !array_key_exists($curr,$result[$emp]) ) {
        $result[$emp][$curr] = ['duration'=>0,'cost'=>0];
    }
    $result[$emp][$curr]['duration'] += $v['duration'];
    $result[$emp][$curr]['cost'] += $v['cost'];
};
array_map($groupSum,$in);

print_r($result);

Collectives™ on Stack Overflow

Grouping and adding values multidimensional array

Code

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related