dongwuwan5646 2017-12-22 18:19
浏览 33
已采纳

PHP动态列的总和

I would like to have the sum of the 4th column of a table, and I dry miserably.

My controller:

public function ticket()
{
    $cmdbars = DB::table('bars')
             ->orderBy('updated_at', 'asc')
             ->get();

    return view('bar_iframe', compact('cmdbars'));
}

My view :

<table>
@foreach($cmdbars as $cmdbar)

<tr>
    <td>
        {{ $cmdbar->la_qtt }}
    </td>
    <td>
        {{ $cmdbar->la_denom }}
    </td>
    <td class="txtr">
        {{ number_format($cmdbar->le_tarif_bar/100, 2, '.', ' ') }}
    </td>
    <td class="txtr">
        @php
        $sum_produit = $cmdbar->le_tarif_bar * $cmdbar->la_qtt;
        @endphp
        {{ number_format($sum_produit/100, 2, '.', ' ') }}
    </td>
</tr>
@endforeach

<tr>
    <td colspan="4">
        <div class="total_cmd">
            {{-- HERE, I would like the sum of the 4th column --}} €
        </div>
    </td>
</tr>

I'm looking for a day and I'm blocking on this problem, Thanks for your help

  • 写回答

3条回答 默认 最新

  • dongqijuan3786 2017-12-22 18:22
    关注

    Something like this should be working:

    {{ number_format($cmdbars->sum(function($el) {return $el->le_tarif_bar * $el->la_qtt; })/100, 2, '.', ' ') }}
    

    (assuming you are using Laravel 5.3.+ where Query builder is returning collection of elements - method sum is used here)

    Also I don't see any point in using:

    @php
    $sum_produit = $cmdbar->le_tarif_bar * $cmdbar->la_qtt;
    @endphp
    {{ number_format($sum_produit/100, 2, '.', ' ') }}
    

    Use:

    {{ number_format(($cmdbar->le_tarif_bar * $cmdbar->la_qtt)/100, 2, '.', ' ') }}
    

    instead. Using PHP in Blade (or generally in views) is bad practice and should be avoided if possible.

    EDIT

    Personally I would use Eloquent for this and create Bar model and get bars like this:

    $cmdbars = Bar::orderBy('updated_at', 'asc')->get();
    

    In Bar model I would add accessor:

    public function getPriceAttribute()
    {
       return $this->le_tarif_bar * $this->la_qtt;
    }
    

    and then in view instead of:

    @php
    $sum_produit = $cmdbar->le_tarif_bar * $cmdbar->la_qtt;
    @endphp
    {{ number_format($sum_produit/100, 2, '.', ' ') }}
    

    I would use:

    {{ number_format($cmdbar->price/100, 2, '.', ' ') }}
    

    and to get sum I would use:

    {{ number_format($cmdbars->sum('price')/100, 2, '.', ' ') }}
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题