我想總結表中的money列payments:

然后,將它附加到每個Clientinindex方法(我都得到了user->clients)。
uj5u.com熱心網友回復:
Eloquent 已經為關系提供了聚合方法來做到這一點:
$clients = Client::where(...)->withSum('payments as sum', 'payment_money')->get();
foreach ($clients as $client) {
echo $client->sum;
}
Laravel 8.x 檔案 - Eloquent - 關系 - 其他聚合函式 withSum
uj5u.com熱心網友回復:
$clients = Client::where('user_id', auth()->user()->id)->paginate(20);
$clients->each(function ($p) {
$p->sum = $p->payments()->sum('payment_money');
});
return compact('clients');
轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/402793.html
標籤:
