Laravel 根据 relation sum 结果排序的小技巧
189 / 3 / 发布于 6个月前
最近项目遇到的小问题，找了一下发现了新姿势
原文：https://www.itsolutionstuff.com/post/larav...
- laravel 6
$customers = Customer::addSelect(['balance' => CustomerBalance::selectRaw('sum(amount) as total')
->whereColumn('customer_id', 'customers.id')
->groupBy('customer_id')
])
->orderBy('balance', 'DESC')
->get()
->toArray();
dd($customers);- laravel 5
$customers = User::select("*", \DB::raw('(SELECT SUM(amount) FROM customer_balances WHERE customer_balances.customer_id = customers.id) as balance'))
->orderBy('balance', 'DESC')
->get()
->toArray();
dd($customers);本作品采用《CC 协议》，转载必须注明作者和本文链接
关于 LearnKu
粤公网安备 44030502004330号
推荐文章：