$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 () {
