GiniBukan, Php - rextester

Language: Layout:

<?php //php 7.2.24

$data =[
        'SM070158985750731-272' => [
            'salesNum' => 'SM070158985750731',
            'menuCategoryDesc' => 'BEVERAGE',
            'menuCategoryDetailDesc' => 'DRINKS',
            'menuID' => '272',
            'menuName' => 'Ice Lemon Tea',
            'menuCode' => '321 100 014',
            'statusMenu' => 'Ala Carte',
            'qty' => '1.00000000',
            'unitPrice' => '11818.0000',
            'subtotal' => '11818.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '1181.00000000',
            'total' => '12999.00000000',
        ],
        'SM070158944044119-257' => [
            'salesNum' => 'SM070158944044119',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'EXTRA ORDER',
            'menuID' => '257',
            'menuName' => 'Bawang Sukiyaki',
            'menuCode' => '311 030 011',
            'statusMenu' => 'Ala Carte',
            'qty' => '1.00000000',
            'unitPrice' => '5455.0000',
            'subtotal' => '5455.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '546.00000000',
            'total' => '6001.00000000',
        ],
        'SM070158944044119-330' => [
            'salesNum' => 'SM070158944044119',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'PACKAGE MENU',
            'menuID' => '330',
            'menuName' => 'Paket Maru A',
            'menuCode' => '311 901 009',
            'statusMenu' => 'Package',
            'qty' => '1.00000000',
            'unitPrice' => '45455.0000',
            'subtotal' => '45455.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '4546.00000000',
            'total' => '50001.00000000',
            'packages' => [
                [
                    'salesNum' => 'SM070158944044119',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '11',
                    'menuName' => 'Kitsune Udon',
                    'menuCode' => '311001012',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
                [
                    'salesNum' => 'SM070158944044119',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '23',
                    'menuName' => 'Hot Ocha',
                    'menuCode' => '321100005',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
            ],
        ],
        'SM070158944050117-331' => [
            'salesNum' => 'SM070158944050117',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'PACKAGE MENU',
            'menuID' => '331',
            'menuName' => 'Paket Maru B',
            'menuCode' => '311 901 010',
            'statusMenu' => 'Package',
            'qty' => '2.00000000',
            'unitPrice' => '45455.0000',
            'subtotal' => '45455.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '0.00000000',
            'total' => '90910.00000000',
            'packages' => [
                [
                    'salesNum' => 'SM070158944050117',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '313',
                    'menuName' => 'Chikuwa Tempura',
                    'menuCode' => '311 020 021',
                    'statusMenu' => 'Package Content',
                    'qty' => '2.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
                [
                    'salesNum' => 'SM070158944050117',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '272',
                    'menuName' => 'Ice Lemon Tea',
                    'menuCode' => '321 100 014',
                    'statusMenu' => 'Package Content',
                    'qty' => '2.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
            ],
        ],
        'SM070158944058972-331' => [
            'salesNum' => 'SM070158944058972',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'PACKAGE MENU',
            'menuID' => '331',
            'menuName' => 'Paket Maru B',
            'menuCode' => '311 901 010',
            'statusMenu' => 'Package',
            'qty' => '1.00000000',
            'unitPrice' => '45455.0000',
            'subtotal' => '45455.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '4546.00000000',
            'total' => '50001.00000000',
            'packages' => [
                [
                    'salesNum' => 'SM070158944058972',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '7',
                    'menuName' => 'Tori Baitan Udon',
                    'menuCode' => '311001007',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
                [
                    'salesNum' => 'SM070158944058972',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '346',
                    'menuName' => 'Cold Ocha',
                    'menuCode' => '',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
            ],
        ],
        'SM070158985742040-331' => [
            'salesNum' => 'SM070158985742040',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'PACKAGE MENU',
            'menuID' => '331',
            'menuName' => 'Paket Maru B',
            'menuCode' => '311 901 010',
            'statusMenu' => 'Package',
            'qty' => '1.00000000',
            'unitPrice' => '45454.0000',
            'subtotal' => '45454.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '0.00000000',
            'total' => '45454.00000000',
            'packages' => [
                [
                    'salesNum' => 'SM070158985742040',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '7',
                    'menuName' => 'Tori Baitan Udon',
                    'menuCode' => '311001007',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
                [
                    'salesNum' => 'SM070158985742040',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '272',
                    'menuName' => 'Ice Lemon Tea',
                    'menuCode' => '321 100 014',
                    'statusMenu' => 'Package Content',
                    'qty' => '1.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
            ],
        ],
        'SM070158944055521-333' => [
            'salesNum' => 'SM070158944055521',
            'menuCategoryDesc' => 'FOOD',
            'menuCategoryDetailDesc' => 'PACKAGE MENU',
            'menuID' => '333',
            'menuName' => 'Paket Maru D',
            'menuCode' => '312 901 010',
            'statusMenu' => 'Package',
            'qty' => '2.00000000',
            'unitPrice' => '45455.0000',
            'subtotal' => '45455.000000000000',
            'discountTotal' => '0.00000000',
            'otherTaxTotal' => '0.00000000',
            'taxTotal' => '0.00000000',
            'total' => '90910.00000000',
            'packages' => [
                [
                    'salesNum' => 'SM070158944055521',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '16',
                    'menuName' => 'Abura Udon (ori)',
                    'menuCode' => '311001018',
                    'statusMenu' => 'Package Content',
                    'qty' => '2.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
                [
                    'salesNum' => 'SM070158944055521',
                    'menuCategoryDesc' => 'FOOD',
                    'menuCategoryDetailDesc' => 'PACKAGE MENU',
                    'menuID' => '272',
                    'menuName' => 'Ice Lemon Tea',
                    'menuCode' => '321 100 014',
                    'statusMenu' => 'Package Content',
                    'qty' => '2.00000000',
                    'unitPrice' => '0.00000000',
                    'subtotal' => '0.00000000',
                    'discountTotal' => '0.00000000',
                    'otherTaxTotal' => '0.00000000',
                    'taxTotal' => '0.00000000',
                    'total' => '0.00000000',
                ],
            ],
        ]
    ];

function recursive($items, $root = false){
        $res = array_reduce(array_values($items), function($carry, $x) use($root) {
            $menuID = $x['menuID'];
            if(!isset($carry[$x['menuID']])) {
                $carry[$menuID] = [
                    'menuID' => $menuID,
                    'qty' => floatVal($x['qty']),
                    'total' => floatVal($x['total']),
                ];
            } else {
                $carry[$menuID]['qty'] += $x['qty'];
                $carry[$menuID]['total'] += $x['total'];
            }
            
            if ($root) {
                if (!isset($carry[$menuID]['packages'])) $carry[$menuID]['packages'] = [];

$packs = isset($x['packages']) ? $x['packages'] : [];
                $carry[$menuID]['packages'] = recursive(array_merge($carry[$menuID]['packages'], $packs), false);
            }
            
            return $carry;
        });
        return $res;
    };
   
    $salesGroup = recursive(array_values($data), true);

echo json_encode(array_values($salesGroup));
?>

[ + ] Show input
Absolute running time: 0.19 sec, cpu time: 0.06 sec, memory peak: 14 Mb, absolute service time: 0,22 sec