dongpu9481 2017-02-07 07:31
浏览 138

使用分页从Laravel模型的结果添加键值对

In my controller i am calling my invoices model which is doing a paginated selected. After i get the results i then need to loop through each result and add a key => value pair to the original results. I have my laravel set up in config/database.php to get results as arrays:

'fetch' => PDO::FETCH_ASSOC,

My code in my controller is

    $invoices = Invoices::getInvoices($clientId);
    $total = 0;
    foreach($invoices as $key=>$inv) {

        $payments = Payments::getPaymentAmount($inv['InvoiceId']);

        foreach($payments as $pmt) {

                $total += $pmt['Pmt_Amount'];

        }

        $invoices[$key]['total'] = $total;
    }

My Invoices Model is:

public static function getInvoices($clientId)
{
   $invoices = DB::table('invoices')
    ->where('ClientId', '=', $clientId)
    ->paginate(25);
   return $invoices;
}

and my payments model

public static function getPaymentAmount($invoiceId)
{
    $payment = DB::table('payments')
        ->select('Pmt_Amount', 'PaymentStatusId')
        ->where('InvoiceId', $invoiceId)
        ->get();

    return $payment;
}

When i try to add 'total' to the invoices array i get the following error

Indirect modification of overloaded element of Illuminate\Pagination\LengthAwarePaginator has no effect

  • 写回答

1条回答 默认 最新

  • dongwenghe2416 2017-02-07 07:51
    关注

    Your $invoices is object, try toArray() after your getInvoices() function :

    $invoices = $invoices->toArray();
    
    评论

报告相同问题?

悬赏问题

  • ¥15 想问一下stata17中这段代码哪里有问题呀
  • ¥15 flink cdc无法实时同步mysql数据
  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决