PHPize Online / SQLize Online  /  SQLtest Online

<?php $stocks = collect( [ ['sku' => '123', 'batch' => '123', 'qty_total' =>1 , 'manufacturing_date' => '2024-05-10'], ['sku' => '1233', 'batch' => '123', 'qty_total' => 2, 'manufacturing_date' => '2024-05-10'], ['sku' => '123', 'batch' => '123', 'qty_total' => 3, 'manufacturing_date' => '2024-05-10'], ['sku' => '5', 'batch' => '123', 'qty_total' => 4, 'manufacturing_date' => '2024-05-10'], ] ); var_export($groupedStocks = $stocks->groupBy([ 'sku', 'batch', 'manufacturing_date' ])->map(function ($stockBatch) { return ['sku' => $stockBatch[0]['sku'], 'batch' => $stockBatch[0]['batch'], 'manufacturing_date' => $stockBatch[0]['manufacturing_date'], 'qty_total' => array_sum(array_column($stockBatch, 'qty_total'))]; }));