PHP Group By Array of Object using 2 Keys

Question

I have to modify the original data into a new set of data using PHP, The original from query would return like :

Result                                   Expected Result :
[                                        [
 {                                        {
  'PRODUCT' : 'BANANA',                    'PRODUCT' : 'BANANA',
  'BUY_PERIOD' : '202101',                 'BUY_PERIOD' : '202101',
  'SALES_PERIOD' : '202101',               'SALES_PERIOD' : [ 
  'PERCENT_OF_SALES' : "20",                                 {
 },                                                            '202101' : "20",
 {                                                             '202102' : "10",
  'PRODUCT' : 'BANANA',                                        '202103' : "15",
  'BUY_PERIOD' : '202101',                                     '202104' : "35"
  'SALES_PERIOD' : '202102',                                 }
  'PERCENT_OF_SALES' : "10",                                ]
 },                                       }
 {                                       ]
  'PRODUCT' : 'BANANA',
  'BUY_PERIOD' : '202101',
  'SALES_PERIOD' : '202103',
  'PERCENT_OF_SALES' : "15",
 },
 {
  'PRODUCT' : 'BANANA',
  'BUY_PERIOD' : '202101',
  'SALES_PERIOD' : '202104',
  'PERCENT_OF_SALES' : "35",
 },
]

I need the expected result to make something like :

On my previous question, i already asked the similiar question, using JavaScript ES6.Here is the the link to my previous question JSON Multidimensional Array to HTML Table
This time, i had to do it using PHP (Laravel)
Any kind of help will be really appriciated , Thank you

Does this answer your question? PHP JSON Array - Group by the same value or PHP JSON Group by the same value — Definitely not Rafal
– Definitely not Rafal, Commented Jun 24, 2021 at 7:13
@DefinitelynotRafal i have tried the first code earlier, the second code almost work, but still working on modifying it. the result still not as expected — Bakti Wijaya
– Bakti Wijaya, Commented Jun 24, 2021 at 7:26
Then you should be able to show us what you tried, which are you expected to do. That way we can improve on your attempt and help you understand what went wrong. — Definitely not Rafal
– Definitely not Rafal, Commented Jun 24, 2021 at 7:57

Slava Rozhnev · Accepted Answer · 2021-06-24 09:35:51Z

1

You can use array_reduce function as approach:

$result = array_reduce(
    $data,
    function($res, $el) {
        if (isset($res[$el['PRODUCT'] . "-" . $el['BUY_PERIOD']])) {
            $res[$el['PRODUCT'] . "-" . $el['BUY_PERIOD']]['SALES_PERIOD'][$el['SALES_PERIOD']] = $el['PERCENT_OF_SALES'];
        } else {
            $res[$el['PRODUCT'] . "-" . $el['BUY_PERIOD']] = [
                'PRODUCT' => $el['PRODUCT'],
                'BUY_PERIOD' => $el['BUY_PERIOD'],
                'SALES_PERIOD' => [
                    $el['SALES_PERIOD'] => $el['PERCENT_OF_SALES']
                ]
            ];
        }
        
        return $res;
    },
    
    $res
);

PHP execute online

answered Jun 24, 2021 at 9:35

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

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

3 Comments

Bakti Wijaya Over a year ago

This works well, but if i add more buy_period data , for example 202102 , the new buy period didn't show up

Slava Rozhnev Over a year ago

Here I added new buy period. It looks ok: phpize.online/…

Bakti Wijaya Over a year ago

thank you sir, this allows me to continue to make a pivot table using new dataset

bdbd · Accepted Answer · 2021-06-24 09:21:30Z

0

This doesn't return the data exactly in the format you require, but gives you the same nested structure using two keys as the question specifies. Use PRODUCT as the first key in the array, then SALES_PERIOD as a second key. Add each row to the nested array through your foreach

foreach($result as $row){
    $return[$row['PRODUCT']]['PRODUCT'] = $result['PRODUCT'];
    $return[$row['PRODUCT']]['BUY_PERIOD'] = $result['BUY_PERIOD'];
    $return[$row['PRODUCT']]['SALES_PERIOD'][$result['SALES_PERIOD']] = $result['PERCENT_OF_SALES'];
}

json_encode($return);

answered Jun 24, 2021 at 9:21

bdbd

917 bronze badges

Collectives™ on Stack Overflow

PHP Group By Array of Object using 2 Keys

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related