Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$stocks = collect(
[
['sku' => '123', 'batch' => '123', 'qty_total' => 1],
['sku' => '1233', 'batch' => '123', 'qty_total' => 2],
['sku' => '123', 'batch' => '123', 'qty_total' => 3],
['sku' => '5', 'batch' => '123', 'qty_total' => 4],
]
);
var_export(
$stocks
->groupBy(fn($row) => $row['sku'] . '_' . $row['batch'])
->map(fn($set) => array_merge($set->first(), ['qty_total' => $set->sum('qty_total')]))
->values()
->toArray()
);