$articles = $articles->orderBy('articles.updated_at', 'desc')->select(DB::raw('articles.id, articles.text, articles.title, articles.slug, articles.user_id, articles.updated_at'))->paginate(5); $topUsers = Article::published()->limit(3)->groupBy('user_id')->orderByRaw('count(user_id) DESC')->get(); $bestUsers = User::all(); $bestUsers = collect($bestUsers->sortByDesc(function ($user) { return $user->average_rating; }))->reject(function ($user) { return $user->average_rating == 0; }); $bestUsers = $bestUsers->slice(0, 3); return view('index', ['articles' => $articles, 'topUsers' => $topUsers, 'bestUsers' => $bestUsers, 'search' => $search]); }); Route::get('/about-us', function () { $users = User::where('role', '=', User::TEACHER_ROLE)->get(); $articlesCount = Article::published()->count(); $usersCount = User::count(); $commentsCount = \App\Models\Discussion::count(); return view('aboutus', ['users' => $users, 'articlesCount' => $articlesCount, 'usersCount' => $usersCount, 'commentsCount' => $commentsCount]); }); Route::get('/faq', function () { return view('faq'); }); Route::get('/rules', function () { return view('rules'); }); Route::get('/migrate/{id}', function () { Artisan::call('migrate', ['--force' => true]); })->where('id', 'lesna_jahoda'); Route::get('/seed/{id}', function () { Artisan::call('db:seed', ['--force' => true]); })->where('id', 'lesna_jahoda'); Route::get('/refresh/{id}', function () {