php - 如何在 laravel mongodb 中对两个字段求和？

Question

我从这里获得引用:https://github.com/jenssegers/laravel-mongodb

如果在 mysql 中这样查询:

SELECT SUM(tota_salary), SUM(total_player) 
FROM club
WHERE code_club = 9

我想在 laravel eloquent 中改变它

从文档 laravel mongodb 中，我这样尝试:

Club::where('code_club', '=', 9)
     ->sum('total_salary')
     ->sum('total_player');

存在这样的错误:

Call to a member function sum() on float

如果我只有 1 个这样的总和:

Club::where('code_club', '=', 9)
     ->sum('total_salary');

有效

为什么使用 2 sum 时失败？

Answer 1

这里有一个解决方法

  $clubs = Club::where('code_club', '=', 9)->get(); // or first() idk

 $data['sum_player'] = $clubs->sum('total_player');
 $data['sum_salery'] = $clubs->sum('total_salary');