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 协议》，转载必须注明作者和本文链接