<?php
require_once __DIR__ . '/../config.php';
require_once __DIR__ . '/../includes/db.php';
require_once __DIR__ . '/../includes/auth.php';

Auth()->requireRole(['college', 'admin', 'super_admin']);
$db = DB();

$id = intval($_GET['id'] ?? 0);
$s = $db->fetchOne("SELECT s.*, c.course_name, c.course_code FROM students s JOIN courses c ON s.course_id = c.id WHERE s.id = ?", [$id]);

if (!$s || !$s['result_declared']) {
    die("Result not found or not declared yet.");
}

$subjects = $db->fetchAll("SELECT s.*, m.obtained_marks 
                          FROM subjects s 
                          LEFT JOIN marks_entry m ON s.id = m.subject_id AND m.student_id = ? 
                          WHERE s.course_id = ? 
                          ORDER BY s.type, s.subject_name", [$id, $s['course_id']]);

$theorySubjects = array_filter($subjects, fn($sub) => $sub['type'] === 'Theory');
$practicalSubjects = array_filter($subjects, fn($sub) => $sub['type'] === 'Practical');
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Mark Sheet - <?= $s['registration_number'] ?></title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Roboto:wght@400;700;900&display=swap');
        body { background: #f0f0f0; font-family: 'Roboto', sans-serif; }
        .marksheet-container {
            width: 210mm;
            min-height: 297mm;
            padding: 20mm;
            margin: 20px auto;
            background: white;
            box-shadow: 0 0 20px rgba(0,0,0,0.1);
            position: relative;
            border: 2px solid #3b0b7c;
        }
        .watermark {
            position: absolute;
            top: 50%;
            left: 50%;
            transform: translate(-50%, -50%) rotate(-45deg);
            font-size: 8rem;
            color: rgba(59, 11, 124, 0.03);
            white-space: nowrap;
            pointer-events: none;
            font-weight: 900;
        }
        .header-logo { width: 120px; }
        .board-title { color: #3b0b7c; font-weight: 900; letter-spacing: 1px; }
        .marks-table th { background: #f8f9fa !important; border-bottom: 2px solid #3b0b7c; }
        .footer-sign { margin-top: 50px; }
        .sign-box { border-top: 1px solid #333; width: 200px; display: inline-block; padding-top: 5px; }
        
        @media print {
            body { background: none; }
            .marksheet-container { margin: 0; box-shadow: none; border: none; }
            .btn-print { display: none; }
            @page { size: A4; margin: 0; }
        }
    </style>
</head>
<body>

<div class="text-center mt-3 mb-3">
    <button onclick="window.print()" class="btn btn-primary btn-lg px-5 fw-bold btn-print"><i class="fas fa-print me-2"></i>Print Mark Sheet</button>
</div>

<div class="marksheet-container">
    <div class="watermark">IBVTE</div>

    <!-- Header -->
    <div class="row align-items-center mb-4 pb-3 border-bottom">
        <div class="col-3 text-center">
            <img src="../assets/img/logo.jpeg" class="header-logo" alt="IBVTE Logo">
        </div>
        <div class="col-9 text-center pe-5">
            <h2 class="board-title mb-0">INDIAN BOARD OF VOCATIONAL AND TECHNICAL EDUCATION</h2>
            <p class="mb-0 text-muted small">An Autonomous Board Registered under NCT of Delhi, Government of India</p>
            <h5 class="mt-2 fw-bold text-decoration-underline">STATEMENT OF MARKS</h5>
        </div>
    </div>

    <!-- Student Info -->
    <div class="row mb-4">
        <div class="col-8">
            <table class="table table-borderless table-sm">
                <tr><td width="180"><strong>Roll Number:</strong></td><td><?= $s['roll_number'] ?? 'N/A' ?></td></tr>
                <tr><td><strong>Registration No.:</strong></td><td><?= $s['registration_number'] ?></td></tr>
                <tr><td><strong>Student Name:</strong></td><td><?= strtoupper($s['full_name']) ?></td></tr>
                <tr><td><strong>Father's Name:</strong></td><td><?= strtoupper($s['father_name']) ?></td></tr>
                <tr><td><strong>Institution:</strong></td><td class="small"><?= htmlspecialchars($s['training_center']) ?></td></tr>
                <tr><td><strong>Course:</strong></td><td class="fw-bold"><?= strtoupper($s['course_name']) ?></td></tr>
                <tr><td><strong>Session:</strong></td><td><?= $s['session_year'] ?></td></tr>
            </table>
        </div>
        <div class="col-4 text-center">
            <img src="../<?= $s['photo_path'] ?? 'assets/img/avatar.png' ?>" class="border p-1" style="width:120px;height:140px;object-fit:cover;">
        </div>
    </div>

    <!-- Marks Table -->
    <table class="table table-bordered marks-table text-center align-middle">
        <thead>
            <tr>
                <th rowspan="2">S.No.</th>
                <th rowspan="2" class="text-start">Subject Name</th>
                <th colspan="3">Theory / Practical</th>
            </tr>
            <tr>
                <th width="100">Max Marks</th>
                <th width="100">Min Pass</th>
                <th width="120">Obtained</th>
            </tr>
        </thead>
        <tbody>
            <!-- Theory Section -->
            <tr><td colspan="5" class="bg-light text-start ps-3 fw-bold small">SECTION 1: THEORY SUBJECTS</td></tr>
            <?php $sn = 1; foreach($theorySubjects as $sub): ?>
            <tr>
                <td><?= $sn++ ?></td>
                <td class="text-start"><?= $sub['subject_name'] ?></td>
                <td><?= $sub['max_marks'] ?></td>
                <td><?= $sub['pass_marks'] ?></td>
                <td class="fw-bold"><?= $sub['obtained_marks'] ?></td>
            </tr>
            <?php endforeach; ?>

            <!-- Practical Section -->
            <tr><td colspan="5" class="bg-light text-start ps-3 fw-bold small">SECTION 2: PRACTICAL / VIVA</td></tr>
            <?php foreach($practicalSubjects as $sub): ?>
            <tr>
                <td><?= $sn++ ?></td>
                <td class="text-start"><?= $sub['subject_name'] ?></td>
                <td><?= $sub['max_marks'] ?></td>
                <td><?= $sub['pass_marks'] ?></td>
                <td class="fw-bold"><?= $sub['obtained_marks'] ?></td>
            </tr>
            <?php endforeach; ?>
        </tbody>
        <tfoot class="bg-light h5 fw-bold">
            <tr>
                <td colspan="2" class="text-end pe-4">GRAND TOTAL:</td>
                <td><?= $s['total_marks'] ?></td>
                <td>-</td>
                <td class="text-primary"><?= $s['marks_obtained'] ?></td>
            </tr>
        </tfoot>
    </table>

    <!-- Result Summary -->
    <div class="row mt-4">
        <div class="col-4">
            <div class="p-3 border rounded text-center">
                <div class="small text-muted">PERCENTAGE</div>
                <div class="h4 fw-bold mb-0"><?= number_format($s['percentage'], 2) ?>%</div>
            </div>
        </div>
        <div class="col-4">
            <div class="p-3 border rounded text-center">
                <div class="small text-muted">DIVISION</div>
                <div class="h4 fw-bold mb-0"><?= strtoupper($s['division']) ?></div>
            </div>
        </div>
        <div class="col-4">
            <div class="p-3 border rounded text-center">
                <div class="small text-muted">RESULT STATUS</div>
                <div class="h4 fw-bold mb-0 <?= $s['status']=='passed'?'text-success':'text-danger' ?>">
                    <?= $s['status'] == 'passed' ? 'PASS' : 'FAIL' ?>
                </div>
            </div>
        </div>
    </div>

    <!-- Footer -->
    <div class="row footer-sign text-center">
        <div class="col-4">
            <div class="sign-box mt-5">Verified By</div>
        </div>
        <div class="col-4">
            <div class="mt-4"><img src="../assets/img/qr-placeholder.png" style="width:80px;opacity:0.3;"></div>
            <small class="text-muted d-block">Result Declared Date: <?= date('d/m/Y', strtotime($s['updated_at'])) ?></small>
        </div>
        <div class="col-4">
            <div class="sign-box mt-5">Controller of Examination</div>
        </div>
    </div>

    <div class="mt-5 pt-3 border-top text-center small text-muted">
        For verification - Send documents to <strong>info@ibvte.com</strong> | Website: www.ibvte.com
    </div>
</div>

<script src="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/js/all.min.js"></script>
</body>
</html>
