php - 在 laravel 中按列获取所有条目的总和

Question

所以我有表 prices 结构:

+----+--------+
| id | reward |
+----+--------+
| 1  | 721    |
+----+--------+
| 2  | 54     |
+----+--------+
| 3  | 99     |
+----+--------+

我正在使用这种方法来总结所有奖励:

'withdrawals' => \App\Tradeoffer::where('type', 'withdraw')
            ->where('completed', 1)
            ->where('declined', 0)
            ->where('timeout', 0)
            ->where('created_at', '>', (time() - $hours))
            ->sum('reward')

响应是:7215499 而不是所有条目的总和。这是为什么？如何处理？

Answer 1

我认为你可以这样做，

$totalReward = \App\Tradeoffer::selectRaw('SUM(reward) as total')
        ->where('type', 'withdraw')
        ->where('completed', 1)
        ->where('declined', 0)
        ->where('timeout', 0)
        ->where('created_at', '>', (time() - $hours))
        ->first();

$totalReward->total;