1. Home
2. php - How to show the total on the last rows with same value? (Laravel)

151 votes

1 answers

php - How to show the total on the last rows with same value? (Laravel)

Get the solution ↓↓↓

I have table 'transaction_items' in my dtaabse that looks similar to this...

id	transaction_id	qty	unit_price
1	100	1	10.00
1	100	2	10.00
1	100	3	10.00
1	200	1	20.00
1	200	1	20.00
1	300	1	15.00

Undefined asked

2021-12-1

Write your answer

---

959

votes

Answer

Solution:

Simple - Laravel collections is powerful

$total = $total->reduce(function ($carry, $item) {
    return $carry + ($item->qty * $item->unit_price);
});
Copy code

Or inline (I did not checked this code, probably not working)

$total = $total->reduce(fn ($carry, $item) => $carry + ($item->qty * $item->unit_price));
Copy code

---

UPDATED

I did not read question properly, sorry. But collections still powerful. Btw, I think, you must think about this behaviour - more nice way is add one dimension - group by transaction and add subtotal for each group

$totals = DB::table('transaction_items')
    ->select('qty', 'unit_price')
    ->where('transaction_id', '=', $trans->transaction_id)
    ->get()
    ->groupBy('transaction_id')->each(function($item) {
        $sum = $item->reduce(fn($carry, $product) => $carry + ($product['qty'] * $product['unit_price']));
        $lastRow = $item->pop();
        $lastRow['sum'] = $sum;
        $item->push($lastRow);
        return $item;
})->flatten(1);
Copy code

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: too few arguments to function laravel

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

467 Laravel php artisan shows error of JWT

685 php - Save data to two different tables in CakePHP 3

335 php - Using PHPThumb and Thickbox/Colorbox

133 php - More efficient way to grab MySQL row populated with single value

657 php - How to retrieve response headers after an Ajax request with jQuery based on lastinsertid?

893 php - Insert Variable into Laravel CSV file import array

122 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

189 PHP running out of memory when uploading to s3 bucket - Laravel 5.2

448 php - Check if a variable has been set with the name of the value of another variable

579 php - How to read value from HTML text input?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Laravel

Laravel is a free open source PHP framework that came out in 2011. Since then, it has been able to become the framework of choice for web developers. One of the main reasons for this is that Laravel makes it easier, faster, and safer to develop complex web applications than any other framework.
https://laravel.com/