<?php
declare(strict_types=1);
require_once __DIR__ . '/../../authentication/api/connect.php';
if (($_SERVER['REQUEST_METHOD'] ?? '') !== 'GET') { header('Allow: GET'); reply(405, ['status'=>'error','message'=>'Use GET.']); }
$user = require_auth(); $role = (string)$user['role']; $db = db(); $stats = []; $scope = 'All departments · All campuses';
$count = static function (string $sql, array $values = []) use ($db): int { $stmt=$db->prepare($sql); $stmt->execute($values); return (int)$stmt->fetchColumn(); };
if ($role === 'admin' || $role === 'staff') {
    $stats['stat-campuses']=$count('SELECT COUNT(*) FROM campuses WHERE is_active=1');
    $stats['stat-departments']=$count('SELECT COUNT(*) FROM departments WHERE is_active=1');
    $stats['stat-hods']=$count('SELECT COUNT(*) FROM hod_assignments'); $stats['stat-students']=$count('SELECT COUNT(*) FROM students');
} elseif ($role === 'hod') {
    $stmt=$db->prepare('SELECT h.department_id,h.campus_id,d.department_name,c.campus_name FROM hod_assignments h JOIN departments d ON d.id=h.department_id JOIN campuses c ON c.id=h.campus_id WHERE h.user_id=?'); $stmt->execute([(int)$user['id']]); $a=$stmt->fetch();
    if (!$a) reply(403,['status'=>'error','message'=>'HOD account has no assigned department and campus.']);
    $d=(int)$a['department_id']; $c=(int)$a['campus_id'];
    $stats['stat-students']=$count('SELECT COUNT(*) FROM students WHERE department_id=? AND campus_id=?',[$d,$c]);
    $stats['stat-pending']=$count("SELECT COUNT(*) FROM project_submissions s JOIN project_assignments a ON a.id=s.assignment_id AND a.student_id IS NOT NULL JOIN practical_projects p ON p.id=a.project_id WHERE p.department_id=? AND p.campus_id=? AND s.validation_state IN ('pending','valid')",[$d,$c]);
    $scope=$a['department_name'].' · '.$a['campus_name'];
} elseif ($role === 'student') {
    $stmt=$db->prepare('SELECT id FROM students WHERE user_id=?'); $stmt->execute([(int)$user['id']]); $s=$stmt->fetch();
    if (!$s) reply(403,['status'=>'error','message'=>'Student profile is unavailable.']); $sid=(int)$s['id'];
    $stats['stat-assignments']=$count('SELECT COUNT(DISTINCT a.id) FROM project_assignments a WHERE a.student_id=?',[$sid]);
    $stats['stat-grades']=$count('SELECT COUNT(*) FROM project_assignments a LEFT JOIN grades_feedback g ON g.assignment_id=a.id WHERE (a.student_id=?) AND g.id IS NOT NULL',[$sid]);
    $stmt=$db->prepare('SELECT MIN(a.due_at) FROM project_assignments a WHERE (a.student_id=?) AND a.due_at>=UTC_TIMESTAMP()'); $stmt->execute([$sid]); $due=$stmt->fetchColumn();
    $stats['stat-deadline']=$due ? date('d M',strtotime((string)$due)) : '—'; $scope='Your department · Your campus';
} else reply(403,['status'=>'error','message'=>'Dashboard access denied.']);
reply(200,['status'=>'success','stats'=>$stats,'scope'=>$scope]);
