时间戳

首页 > 解决方案 > 如何计算 laravel 表格中的小计和总计？

laravel - 如何计算 laravel 表格中的小计和总计？

问题描述

如果我调试我的 laravel eloquent，结果如下：

SELECT a.transaction_number a.date, a.item_number, b.desc, a.variant_code, sum(a.quantity) AS quantity, a.cost
FROM `items_details` AS a
JOIN `items` AS b ON b.id = a.item_number
WHERE a.item_number = 0101010
GROUP BY a.variant_code
ORDER BY transaction_number, variant_code

我将用分页返回集合

但在这里我只显示数组。像这样的数组：

$data = array(
    array('transaction_number' => 'AB-0001','date' => '2018-08-01', 'item_number' => '0101010', 'desc' => 'This is a', 'variant_code' => '002', 'quantity' => '2','cost' => '2000'),
    array('transaction_number' => 'AB-0001','date' => '2018-08-01', 'item_number' => '0101010', 'desc' => 'This is a', 'variant_code' => '004', 'quantity' => '3','cost' => '2000'),
    array('transaction_number' => 'AB-0001','date' => '2018-08-01', 'item_number' => '0101010', 'desc' => 'This is a', 'variant_code' => '005', 'quantity' => '4','cost' => '2000'),
    array('transaction_number' => 'AB-0001','date' => '2018-08-01', 'item_number' => '0101010', 'desc' => 'This is a', 'variant_code' => '006', 'quantity' => '5','cost' => '2000'),
    array('transaction_number' => 'AB-0001','date' => '2018-08-01', 'item_number' => '0101010', 'desc' => 'This is a', 'variant_code' => '008', 'quantity' => '1','cost' => '2000'),
    array('transaction_number' => 'AB-0002','date' => '2018-08-02', 'item_number' => '0101010', 'desc' => 'This is b', 'variant_code' => '013', 'quantity' => '2','cost' => '2000'),
    array('transaction_number' => 'AB-0002','date' => '2018-08-02', 'item_number' => '0101010', 'desc' => 'This is b', 'variant_code' => '020', 'quantity' => '3','cost' => '2500'),
    array('transaction_number' => 'AB-0002','date' => '2018-08-02', 'item_number' => '0101010', 'desc' => 'This is b', 'variant_code' => '022', 'quantity' => '4','cost' => '2500'),
    array('transaction_number' => 'AB-0003','date' => '2018-08-03', 'item_number' => '0101010', 'desc' => 'This is c', 'variant_code' => '007', 'quantity' => '1','cost' => '2500'),
    array('transaction_number' => 'AB-0003','date' => '2018-08-03', 'item_number' => '0101010', 'desc' => 'This is c', 'variant_code' => '015', 'quantity' => '7','cost' => '2500')
);

我在 laravel 刀片中的脚本显示如下：

<table class="table">
    <tr>
        <th>transaction_number</th>
        <th>date</th>
        <th>item_number</th>
        <th>desc</th>
        <th>variant_code</th>
        <th>quantity</th>
        <th>cost</th>
    </tr>
    @foreach ($items as $item)
        <tr>
            <td>{{ $item->transaction_number }}</td>
            <td>{{ $item->date }}</td>
            <td>{{ $item->item_number }}</td>
            <td>{{ $item->desc }}</td>
            <td>{{ $item->variant_code }}</td>
            <td>{{ $item->quantity }}</td>
            <td>{{ $item->cost }}</td>
        </tr>
    @endforeach
</table>

结果是这样的：

在此处输入图像描述

我想要这样的结果：

在此处输入图像描述

最好的方法是什么？无论是通过mysql查询还是laravel eloquent都可以这样显示？还是通过视图刀片 laravel 安排的？

请帮我。我很困惑 ：）

标签： laravellaravel-5eloquentlaravel-bladelaravel-5.6

解决方案

没有分页，我会做这样的事情（未经测试）......

要求分页增加了关于可能分解事务组和总数的复杂性。

阅读以下内容，
https ://laravel.com/docs/5.6/blade#the-loop-variable
https://laravel.com/docs/5.6/blade#include-sub-views

你需要 Laravel 5.3+ 用于$loop.

小计.blade.php

<tr>
    <td colspan="4"></td>
    <td>SUBTOTAL</td>
    <td>{{ $items->where('transaction_number', $current_transaction_number)->sum('quantity') }}</td>
    <td>{{ $items->where('transaction_number', $current_transaction_number)->sum('cost') }}</td>
</tr>
<tr>
    <td colspan="7"></td>
</tr>

总刀片.php

<tr>
    <td colspan="4"></td>
    <td>TOTAL</td>
    <td>{{ $items->sum('quantity') }}</td>
    <td>{{ $items->sum('cost') }}</td>
</tr>

主刀片.php

<table class="table">
    <tr>
        <th>transaction_number</th>
        <th>date</th>
        <th>item_number</th>
        <th>desc</th>
        <th>variant_code</th>
        <th>quantity</th>
        <th>cost</th>
    </tr>
    @php ($current_transaction_number = null)

    @foreach ($items as $item)
        @if ($loop->index > 0 && $current_transaction_number != $item->transaction_number)
           @include ('subtotal', compact('items', 'current_transaction_number'))
        @endif
        <tr>
            @if ($current_transaction_number == $item->transaction_number)
                <td colspan="2"></td>
            @else
                @php ($current_transaction_number = $item->transaction_number)
                <td>{{ $item->transaction_number }}</td>
                <td>{{ $item->date }}</td>
            @endif
            <td>{{ $item->item_number }}</td>
            <td>{{ $item->desc }}</td>
            <td>{{ $item->variant_code }}</td>
            <td>{{ $item->quantity }}</td>
            <td>{{ $item->cost }}</td>
        </tr>
        @if ($loop->last)
           @include ('subtotal', compact('items', 'current_transaction_number'))
           @include ('total', compact('items'))
        @endif
    @endforeach
</table>

{{ $items->links() }}

推荐阅读