Files

21 lines
900 B
PHP

<?php
namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use App\Models\User;
use App\Models\QuestionAttempt;
use App\Models\RewardRedemption;
class DashboardController extends Controller {
public function index() {
$children = User::where('role','child')->count();
$questions = \App\Models\Question::count();
$attempts_today = QuestionAttempt::whereDate('created_at', today())->count();
$pending = RewardRedemption::where('status','pending')->count();
$topKids = User::where('role','child')->orderByDesc('points')->take(5)->get();
$recentAttempts = QuestionAttempt::with(['user','question.subject'])
->latest('id')->take(10)->get();
return view('admin.dashboard', compact(
'children','questions','attempts_today','pending','topKids','recentAttempts'
));
}
}