Beispiel #1
0
 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;
 }