Laravel/PHP: Add another condition in array_reduce function

Question

I have multidimensional array and I want to sum all the same value with a certain condition.

Here's what my array looks like

$input_taxes = [ [ "tax_account_id" => 65, "checkbox" => false, "amount" => "13950.89", ], [ "tax_account_id" => 64, "checkbox" => 0, "amount" => "1920.70", ] ];

What I've researched, they used array_reduce. Below is my code:

$result = array_reduce($input_taxes, function ($carry, $item) { if (! isset($carry[$item['tax_account_id']])) { $chart_of_account = ChartOfAccount::where('id', $item['tax_account_id']) ->first() ->name; $carry[$item['tax_account_id']] = [ 'tax_account_id' => $item['tax_account_id'], 'amount_to_apply' => $item['amount_to_apply'], 'chart_of_account' => $chart_of_account ]; } else { $carry[$item['tax_account_id']]['amount_to_apply'] += $item['amount_to_apply']; } return $carry; });

Currently, it will sum all the same values even though it is not checked. Now I want to put a condition where it should be check first before it will sum all the same values.

NOTE: I already tried to put an if statement inside of both if and else statement but unfortunately it didn't work.

Question: How can I add a certain condition within array_reduce?

"Currently, it will sum all the same value even though it is not checked.", What do you want to achieve ? — Pascal Tovohery
– Pascal Tovohery, Commented Nov 13, 2022 at 18:26
Please, add an example output you would expect, and share more info as it is confusing what you want out. I do see the initial example has both checkbox as false, so should the output be 0? — matiaslauriti
– matiaslauriti, Commented Nov 13, 2022 at 18:41

Vlad · Accepted Answer · 2022-11-13 21:30:22Z

The check must be inserted at the beginning of your function.

$result = array_reduce($input_taxes, function ($carry, $item) { if (!$item['checkbox']) { return $carry; } if (! isset($carry[$item['tax_account_id']])) { $chart_of_account = ChartOfAccount::where('id', $item['tax_account_id']) ->first() ->name; $carry[$item['tax_account_id']] = [ 'tax_account_id' => $item['tax_account_id'], 'amount_to_apply' => $item['amount_to_apply'], 'chart_of_account' => $chart_of_account ]; } else { $carry[$item['tax_account_id']]['amount_to_apply'] += $item['amount_to_apply']; } return $carry; });

I can also offer a small optimization to reduce the number of requests to the database

$chartOfAccountNames = UserProfile::query() ->whereIn('id', array_column($input_taxes, 'tax_account_id')) ->pluck('name', 'id') ->toArray(); $result = array_reduce($input_taxes, static function ($carry, $item) use ($chartOfAccountNames) { if (!$item['checkbox']) { return $carry; } if (isset($carry[$item['tax_account_id']])) { $carry[$item['tax_account_id']]['amount_to_apply'] += $item['amount']; return $carry; } $carry[$item['tax_account_id']] = [ 'tax_account_id' => $item['tax_account_id'], 'amount_to_apply' => $item['amount'], 'chart_of_account' => $chartOfAccountNames[$item['tax_account_id']], ]; return $carry; });

Collectives™ on Stack Overflow

Laravel/PHP: Add another condition in array_reduce function

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related