Laravel 根据 relation sum 结果排序的小技巧
最近项目遇到的小问题,找了一下发现了新姿势
原文: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 协议》,转载必须注明作者和本文链接
推荐文章: