<?php
session_start();
if (!isset($_SESSION['admin_logged_in'])) { header('Location: ../index.php'); exit(); }
if (file_exists(__DIR__ . '/../../db.php')) {
    require_once __DIR__ . '/../../db.php';
} elseif (file_exists(__DIR__ . '/../db.php')) {
    require_once __DIR__ . '/../db.php';
}

if (file_exists(__DIR__ . '/../../result_db_setup.php')) {
    require_once __DIR__ . '/../../result_db_setup.php';
} elseif (file_exists(__DIR__ . '/../result_db_setup.php')) {
    require_once __DIR__ . '/../result_db_setup.php';
} elseif (file_exists(__DIR__ . '/result_db_setup.php')) {
    require_once __DIR__ . '/result_db_setup.php';
}
setupResultTables($conn);

// Get stats
function safeCount($conn, $table, $where='') {
    $q = "SELECT COUNT(*) as c FROM $table" . ($where ? " WHERE $where" : "");
    $r = $conn->query($q);
    return ($r && $r->num_rows > 0) ? $r->fetch_assoc()['c'] : 0;
}
$total_students   = safeCount($conn,'result_students','is_active=1');
$total_classes    = safeCount($conn,'result_classes');
$total_subjects   = safeCount($conn,'result_subjects');
$active_session   = $conn->query("SELECT session_name FROM result_sessions WHERE is_active=1 LIMIT 1")->fetch_assoc()['session_name'] ?? '---';
$published_results = safeCount($conn,'result_remarks','is_published=1');
$pending_marks    = safeCount($conn,'result_marks','marks_obtained IS NULL AND status=\'present\'');

// Recent students
$recent = $conn->query("SELECT rs.*, rc.class_name, rc.section FROM result_students rs 
    JOIN result_classes rc ON rs.class_id=rc.id ORDER BY rs.id DESC LIMIT 5");
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Result Management | BSPS Admin</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700;800&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary: #0b3b60; --accent: #f5a623; --dark: #1e293b;
            --success: #10b981; --danger: #ef4444; --info: #3b82f6;
            --purple: #8b5cf6; --sidebar-w: 260px;
        }
        * { box-sizing: border-box; }
        body { background: #f0f4f8; font-family: 'Inter', sans-serif; margin: 0; }

        /* SIDEBAR */
        .sidebar {
            position: fixed; top:0; left:0; height:100vh; width: var(--sidebar-w);
            background: linear-gradient(180deg, #0f172a 0%, #1e293b 100%);
            overflow-y: auto; z-index: 1000; transition: 0.3s;
        }
        .sidebar-brand { padding: 22px 20px; border-bottom: 1px solid rgba(255,255,255,0.08); }
        .sidebar-brand h5 { color:#fff; font-weight:700; margin:0; font-size:15px; }
        .sidebar-brand small { color: var(--accent); font-size:11px; }
        .sidebar-section { padding: 8px 16px 4px; font-size:10px; color:rgba(255,255,255,0.35); text-transform:uppercase; letter-spacing:1.2px; font-weight:600; margin-top:8px; }
        .sidebar a {
            display:flex; align-items:center; gap:10px;
            color:rgba(255,255,255,0.65); text-decoration:none;
            padding:10px 20px; font-size:13.5px; transition:0.2s; border-left:3px solid transparent;
        }
        .sidebar a:hover, .sidebar a.active {
            color:#fff; background:rgba(255,255,255,0.07); border-left-color: var(--accent);
        }
        .sidebar a i { width:18px; text-align:center; }

        /* MAIN */
        .main { margin-left: var(--sidebar-w); padding: 30px; min-height: 100vh; }

        /* TOPBAR */
        .topbar {
            display:flex; justify-content:space-between; align-items:center;
            background:#fff; padding:14px 24px; border-radius:12px;
            box-shadow:0 2px 12px rgba(0,0,0,0.06); margin-bottom:28px;
        }
        .topbar h4 { margin:0; font-weight:700; color: var(--dark); font-size:18px; }
        .badge-session { background: linear-gradient(135deg,var(--primary),#1a6ba0); color:#fff; padding:6px 14px; border-radius:20px; font-size:12px; font-weight:600; }

        /* STAT CARDS */
        .stat-card {
            background:#fff; border-radius:14px; padding:22px; box-shadow:0 2px 16px rgba(0,0,0,0.06);
            transition:0.3s; position:relative; overflow:hidden;
        }
        .stat-card:hover { transform:translateY(-4px); box-shadow:0 8px 28px rgba(0,0,0,0.1); }
        .stat-card .icon {
            width:54px; height:54px; border-radius:12px; display:flex; align-items:center;
            justify-content:center; font-size:22px; color:#fff; margin-bottom:14px;
        }
        .stat-card h3 { font-size:30px; font-weight:800; margin:0; }
        .stat-card p { font-size:12.5px; color:#64748b; margin:4px 0 0; font-weight:500; }
        .stat-card .bg-blob {
            position:absolute; right:-20px; top:-20px; width:100px; height:100px;
            border-radius:50%; opacity:0.06;
        }

        /* MODULE CARDS */
        .module-card {
            background:#fff; border-radius:14px; padding:20px; box-shadow:0 2px 12px rgba(0,0,0,0.05);
            text-decoration:none; color: var(--dark); display:block; transition:0.3s;
            border:2px solid transparent;
        }
        .module-card:hover { border-color: var(--accent); transform:translateY(-3px); box-shadow:0 8px 24px rgba(0,0,0,0.1); color:var(--dark); }
        .module-card .mod-icon { font-size:32px; margin-bottom:12px; }
        .module-card h6 { font-weight:700; font-size:14px; margin-bottom:4px; }
        .module-card p { font-size:12px; color:#64748b; margin:0; }

        /* TABLE */
        .table-card { background:#fff; border-radius:14px; box-shadow:0 2px 12px rgba(0,0,0,0.05); overflow:hidden; }
        .table-card .card-header { padding:18px 24px; background:#fff; border-bottom:1px solid #f1f5f9; }
        .table-card .card-header h6 { font-weight:700; margin:0; font-size:15px; }
        .custom-table th { font-size:11.5px; text-transform:uppercase; letter-spacing:0.5px; color:#94a3b8; font-weight:600; padding:12px 16px; background:#f8fafc; }
        .custom-table td { padding:12px 16px; font-size:13px; border-bottom:1px solid #f1f5f9; vertical-align:middle; }
        .custom-table tr:last-child td { border:none; }

        @media(max-width:768px) {
            .sidebar { transform:translateX(-100%); }
            .main { margin-left:0; padding:20px; }
        }
    </style>
</head>
<body>

<!-- SIDEBAR -->
<div class="sidebar">
    <div class="sidebar-brand">
        <h5><i class="fas fa-graduation-cap me-2" style="color:var(--accent)"></i>Result System</h5>
        <small>BS Public School</small>
    </div>

    <div class="sidebar-section">Main</div>
    <a href="dashboard.php" class="active"><i class="fas fa-tachometer-alt"></i> Dashboard</a>
    <a href="../dashboard.php"><i class="fas fa-arrow-left"></i> Back to Admin</a>

    <div class="sidebar-section">Setup & Config</div>
    <a href="sessions.php"><i class="fas fa-calendar-alt"></i> Academic Sessions</a>
    <a href="classes.php"><i class="fas fa-chalkboard"></i> Classes & Sections</a>
    <a href="subjects.php"><i class="fas fa-book"></i> Subjects Master</a>
    <a href="class_subjects.php"><i class="fas fa-link"></i> Class-Subject Mapping</a>
    <a href="terms.php"><i class="fas fa-list-ol"></i> Exam Terms</a>
    <a href="exam_structure.php"><i class="fas fa-sitemap"></i> Exam Structure</a>
    <a href="grading.php"><i class="fas fa-star"></i> Grading Scale</a>

    <div class="sidebar-section">Students</div>
    <a href="students.php"><i class="fas fa-user-graduate"></i> Manage Students</a>
    <a href="student_import.php"><i class="fas fa-file-excel"></i> Bulk Import</a>

    <div class="sidebar-section">Marks & Results</div>
    <a href="marks_entry.php"><i class="fas fa-pen-to-square"></i> Marks Entry</a>
    <a href="attendance.php"><i class="fas fa-calendar-check"></i> Attendance</a>
    <a href="coscholastic.php"><i class="fas fa-palette"></i> Co-Scholastic</a>
    <a href="remarks.php"><i class="fas fa-comment-dots"></i> Remarks & Publish</a>

    <div class="sidebar-section">Reports</div>
    <a href="report_card.php"><i class="fas fa-file-invoice"></i> Report Cards</a>
    <a href="analytics.php"><i class="fas fa-chart-bar"></i> Analytics</a>
    <a href="toppers.php"><i class="fas fa-trophy"></i> Toppers List</a>

    <div style="padding:16px 20px; margin-top:20px;">
        <a href="../logout.php" class="btn btn-outline-danger w-100 btn-sm">
            <i class="fas fa-sign-out-alt me-1"></i> Logout
        </a>
    </div>
</div>

<!-- MAIN -->
<div class="main">
    <div class="topbar">
        <div>
            <h4><i class="fas fa-graduation-cap me-2" style="color:var(--primary)"></i>Result Management System</h4>
            <div class="text-muted" style="font-size:12px; margin-top:2px;">Nursery to Class 8 | Comprehensive Academic Result Platform</div>
        </div>
        <div class="d-flex align-items-center gap-3">
            <span class="badge-session"><i class="fas fa-calendar me-1"></i><?= htmlspecialchars($active_session) ?></span>
            <a href="report_card.php" class="btn btn-primary btn-sm">
                <i class="fas fa-file-invoice me-1"></i> Generate Reports
            </a>
        </div>
    </div>

    <!-- STAT CARDS -->
    <div class="row g-3 mb-4">
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--primary)"></div>
                <div class="icon" style="background:linear-gradient(135deg,var(--primary),#1a6ba0)">
                    <i class="fas fa-user-graduate"></i>
                </div>
                <h3><?= $total_students ?></h3>
                <p>Total Students</p>
            </div>
        </div>
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--success)"></div>
                <div class="icon" style="background:linear-gradient(135deg,#059669,var(--success))">
                    <i class="fas fa-chalkboard"></i>
                </div>
                <h3><?= $total_classes ?></h3>
                <p>Classes / Sections</p>
            </div>
        </div>
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--info)"></div>
                <div class="icon" style="background:linear-gradient(135deg,#2563eb,var(--info))">
                    <i class="fas fa-book"></i>
                </div>
                <h3><?= $total_subjects ?></h3>
                <p>Subjects</p>
            </div>
        </div>
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--accent)"></div>
                <div class="icon" style="background:linear-gradient(135deg,#d97706,var(--accent))">
                    <i class="fas fa-check-circle"></i>
                </div>
                <h3><?= $published_results ?></h3>
                <p>Results Published</p>
            </div>
        </div>
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--purple)"></div>
                <div class="icon" style="background:linear-gradient(135deg,#7c3aed,var(--purple))">
                    <i class="fas fa-clock"></i>
                </div>
                <h3><?= $pending_marks ?></h3>
                <p>Pending Marks</p>
            </div>
        </div>
        <div class="col-6 col-lg-2">
            <div class="stat-card">
                <div class="bg-blob" style="background:var(--danger)"></div>
                <div class="icon" style="background:linear-gradient(135deg,#dc2626,var(--danger))">
                    <i class="fas fa-layer-group"></i>
                </div>
                <h3>4</h3>
                <p>Exam Terms</p>
            </div>
        </div>
    </div>

    <!-- MODULE GRID -->
    <h6 class="fw-700 mb-3" style="font-weight:700; color:#374151;">Quick Access Modules</h6>
    <div class="row g-3 mb-4">
        <?php
        $modules = [
            ['sessions.php','📅','Academic Sessions','Manage 2025-26, 2026-27 sessions','#dbeafe'],
            ['classes.php','🏫','Classes & Sections','Nur, LKG, UKG, Class 1–8 A/B','#dcfce7'],
            ['subjects.php','📚','Subjects Master','Configure all subjects & grading type','#fef3c7'],
            ['class_subjects.php','🔗','Class-Subject Map','Map subjects to classes + teachers','#f3e8ff'],
            ['terms.php','📋','Exam Terms','Term 1, Term 2, Half-Yearly, Annual','#fee2e2'],
            ['exam_structure.php','📐','Exam Structure','Set max marks, passing marks per component','#e0f2fe'],
            ['students.php','👨‍🎓','Students','Add, edit, manage all students','#fff7ed'],
            ['marks_entry.php','✏️','Marks Entry','Fast spreadsheet-style bulk marks entry','#f0fdf4'],
            ['attendance.php','✅','Attendance','Record term-wise attendance','#fdf4ff'],
            ['coscholastic.php','🎨','Co-Scholastic','Art, Sports, Discipline grades','#fff1f2'],
            ['report_card.php','📄','Report Cards','Generate & print A4 report cards','#f8fafc'],
            ['analytics.php','📊','Analytics','Toppers, pass%, grade distribution','#eff6ff'],
        ];
        foreach($modules as $m): ?>
        <div class="col-6 col-md-4 col-lg-3">
            <a href="<?= $m[0] ?>" class="module-card">
                <div class="mod-icon"><?= $m[1] ?></div>
                <h6><?= $m[2] ?></h6>
                <p><?= $m[3] ?></p>
            </a>
        </div>
        <?php endforeach; ?>
    </div>

    <!-- RECENT STUDENTS -->
    <div class="table-card">
        <div class="card-header d-flex justify-content-between align-items-center">
            <h6><i class="fas fa-user-graduate me-2 text-primary"></i>Recently Added Students</h6>
            <a href="students.php" class="btn btn-sm btn-outline-primary">View All</a>
        </div>
        <table class="table custom-table mb-0">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Student Name</th>
                    <th>Admission No</th>
                    <th>Class</th>
                    <th>Gender</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                <?php if ($recent && $recent->num_rows > 0): while($s = $recent->fetch_assoc()): ?>
                <tr>
                    <td><?= $s['id'] ?></td>
                    <td class="fw-600"><?= htmlspecialchars($s['first_name'].' '.$s['last_name']) ?></td>
                    <td><code><?= $s['admission_no'] ?></code></td>
                    <td><span class="badge bg-primary"><?= $s['class_name'].' '.$s['section'] ?></span></td>
                    <td><?= $s['gender'] ?></td>
                    <td><a href="marks_entry.php?class_id=<?= $s['class_id'] ?>" class="btn btn-xs btn-outline-success btn-sm" style="font-size:11px;">Entry Marks</a></td>
                </tr>
                <?php endwhile; else: ?>
                <tr><td colspan="6" class="text-center text-muted py-4">No students added yet. <a href="students.php">Add students</a></td></tr>
                <?php endif; ?>
            </tbody>
        </table>
    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
