I have a collection and would like to sum by type.
[
['type' => 0, 'amount' => 5],
['type' => 1, 'amount' => 5],
['type' => 0, 'amount' => 5]
]
What I want:
[
['type' => 0, 'amount' => 10],
['type' => 1, 'amount' => 5]
]
How can I achieve this in Laravel?
Here you go:
$yourCollectionSums = $yourCollection->groupBy('type')
->map(function ($row) {
return $row->sum('amount');
});
$result = [];
foreach($yourCollectionSums as $key => $sum){
$result[$key] = ['type' => $key, 'sum' => $sum]
}
// $result will give you desired result.
try the code will help you
$result[] = [];
$collection = $collection->groupBy('type')
->map(function ($row) {
return $row->sum('amount');
})
->map(function ($amount, $type) {
$result['type'] = $type;
$result['amount'] = $amount;
return $result;
});