コード例 #1
0
ファイル: StatsController.php プロジェクト: Cheddam/health
 private function getLeaderboardSince(Carbon $date)
 {
     $stats = Entry::select('users.name as name', DB::raw('sum(goals.points) as points'))->where('completed_on', '>=', $date)->join('users', 'users.id', '=', 'entries.user_id')->join('goals', 'goals.id', '=', 'entries.goal_id')->groupBy('entries.user_id')->orderBy('points', 'desc')->limit(5)->get();
     return $stats;
 }