App\Http\Controllers\TopUsersController::index()

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function index() {
        $topUsers = DB::table('snippets_votes')
            ->join('snippets', 'snippets.id', '=', 'snippets_votes.snippet_id')
            ->join('users', 'users.id', '=', 'snippets.user_id')
            ->select(DB::raw('count(*) as votes, name, username'))
            ->groupBy('snippets.user_id')
            ->orderBy('votes', 'desc')
            ->limit(10)
            ->get();

        return response()->json([
            'topUsers' => $topUsers,
        ]);
    }   
}