<?php
/**
 * IBVTE - Student Certificate Page
 */
require_once __DIR__ . '/../config.php';
require_once __DIR__ . '/../includes/db.php';

if (empty($_SESSION['student_id'])) { header('Location: login.php'); exit; }

$db = DB();
$studentId = $_SESSION['student_id'];

$student = $db->fetchOne(
    "SELECT s.*, c.course_name, c.course_code, u.institution_name
     FROM students s
     LEFT JOIN courses c ON s.course_id = c.id
     LEFT JOIN users u ON s.institution_id = u.id
     WHERE s.id = ?",
    [$studentId]
);

if (!$student) { session_destroy(); header('Location: login.php'); exit; }

// Check from certificates table too
$cert = $db->fetchOne("SELECT * FROM certificates WHERE student_id = ? LIMIT 1", [$studentId]);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Certificate - <?= APP_SHORT_NAME ?></title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet">
    <style>
        :root { --primary: #3b0b7c; --secondary: #6c4ab6; --gold: #c9a227; }
        body { background: #f4f6fc; font-family: 'Segoe UI', sans-serif; }
        .top-bar { background: linear-gradient(135deg, var(--primary), var(--secondary)); }
        .top-bar .nav-link { color: rgba(255,255,255,.85) !important; padding: 16px 14px !important; }
        .top-bar .nav-link:hover, .top-bar .nav-link.active { color: #fff !important; background: rgba(255,255,255,.12); }
        .top-bar .nav-link i { display: block; font-size: 1rem; text-align: center; }
        .page-header { background: linear-gradient(135deg, var(--primary), var(--secondary)); color: white; padding: 30px 0; }
        .section-card { background: white; border-radius: 16px; box-shadow: 0 4px 20px rgba(0,0,0,.06); }

        /* Certificate design */
        .certificate-box {
            border: 12px solid var(--gold);
            border-radius: 4px;
            padding: 40px;
            background: white;
            position: relative;
            max-width: 800px;
            margin: 0 auto;
            text-align: center;
        }
        .certificate-box::before {
            content: '';
            position: absolute;
            inset: 8px;
            border: 2px solid var(--gold);
            pointer-events: none;
            border-radius: 2px;
        }
        .cert-logo { height: 80px; border-radius: 50%; border: 3px solid var(--gold); padding: 4px; }
        .cert-title { font-size: 2rem; font-weight: 800; color: var(--primary); letter-spacing: 3px; text-transform: uppercase; margin: 10px 0; }
        .cert-subtitle { font-size: .9rem; color: #666; text-transform: uppercase; letter-spacing: 2px; }
        .cert-name { font-size: 2.2rem; font-weight: 700; color: var(--primary); border-bottom: 2px solid var(--gold); display: inline-block; padding-bottom: 6px; margin: 16px 0; }
        .cert-text { font-size: 1rem; color: #444; line-height: 1.8; }
        .cert-course { font-size: 1.3rem; font-weight: 700; color: var(--secondary); }
        .cert-details { display: flex; justify-content: space-around; margin-top: 24px; }
        .cert-detail-item { text-align: center; }
        .cert-detail-item .label { font-size: .75rem; text-transform: uppercase; color: #888; letter-spacing: 1px; }
        .cert-detail-item .value { font-weight: 700; color: #333; border-top: 1px solid #ccc; padding-top: 4px; margin-top: 2px; }
        .cert-sig { border-top: 1px solid #333; padding-top: 6px; font-size: .85rem; }
        @media print {
            .no-print { display: none !important; }
            body { background: white; }
            .certificate-box { border-color: #c9a227; }
        }
    </style>
</head>
<body>
    <nav class="navbar navbar-expand-lg top-bar no-print">
        <div class="container">
            <a class="navbar-brand d-flex align-items-center gap-2 text-white fw-bold" href="dashboard.php">
                <img src="../assets/images/logo.jpeg" alt="IBVTE" style="height:36px;border-radius:50%;border:2px solid rgba(255,255,255,.4);">
                Student Portal
            </a>
            <button class="navbar-toggler border-0 text-white" type="button" data-bs-toggle="collapse" data-bs-target="#navMenu">
                <i class="fas fa-bars"></i>
            </button>
            <div class="collapse navbar-collapse" id="navMenu">
                <ul class="navbar-nav ms-auto">
                    <li class="nav-item"><a class="nav-link" href="dashboard.php"><i class="fas fa-home"></i> Home</a></li>
                    <li class="nav-item"><a class="nav-link" href="admission.php"><i class="fas fa-file-alt"></i> Admission</a></li>
                    <li class="nav-item"><a class="nav-link" href="admit-card.php"><i class="fas fa-id-card"></i> Admit Card</a></li>
                    <li class="nav-item"><a class="nav-link" href="result.php"><i class="fas fa-chart-bar"></i> Result</a></li>
                    <li class="nav-item"><a class="nav-link active" href="certificate.php"><i class="fas fa-certificate"></i> Certificate</a></li>
                    <li class="nav-item"><a class="nav-link" href="course.php"><i class="fas fa-book"></i> Course</a></li>
                    <li class="nav-item"><a class="nav-link text-warning" href="logout.php"><i class="fas fa-sign-out-alt"></i> Logout</a></li>
                </ul>
            </div>
        </div>
    </nav>

    <div class="page-header no-print">
        <div class="container">
            <h4 class="mb-0"><i class="fas fa-certificate me-2"></i> Certificate</h4>
            <small class="opacity-75">Download your course completion certificate</small>
        </div>
    </div>

    <div class="container py-4">
        <div class="d-flex justify-content-between align-items-center mb-3 no-print">
            <a href="dashboard.php" class="btn btn-sm btn-outline-secondary"><i class="fas fa-arrow-left me-1"></i> Back</a>
            <?php if ($student['certificate_issued'] || $cert): ?>
            <button onclick="window.print()" class="btn btn-sm" style="background:linear-gradient(135deg,var(--primary),var(--secondary));color:white;">
                <i class="fas fa-print me-1"></i> Print / Download
            </button>
            <?php endif; ?>
        </div>

        <?php if ($student['status'] !== 'passed'): ?>
        <!-- Not passed yet -->
        <div class="section-card p-5 text-center">
            <div style="width:90px;height:90px;background:linear-gradient(135deg,#888,#666);border-radius:50%;display:flex;align-items:center;justify-content:center;margin:0 auto 20px;">
                <i class="fas fa-hourglass-half fa-2x text-white"></i>
            </div>
            <h4 class="text-secondary">Certificate Not Available</h4>
            <p class="text-muted">Your course is still in progress or result has not been declared.</p>
            <p class="text-muted small">Certificate will be available once you pass the examination and the result is declared.</p>
        </div>

        <?php elseif (!$student['certificate_issued'] && !$cert): ?>
        <!-- Passed but not issued -->
        <div class="section-card p-5 text-center">
            <div style="width:90px;height:90px;background:linear-gradient(135deg,#fd7e14,#e65100);border-radius:50%;display:flex;align-items:center;justify-content:center;margin:0 auto 20px;">
                <i class="fas fa-clock fa-2x text-white"></i>
            </div>
            <h4 class="text-warning">Certificate Under Processing</h4>
            <p class="text-muted">Congratulations on passing! Your certificate is being processed and will be available soon.</p>
            <div class="alert alert-info d-inline-block mt-2">
                <i class="fas fa-phone me-2"></i> For queries: <?= INSTITUTION_PHONE ?>
            </div>
        </div>

        <?php else: ?>
        <!-- Show Certificate -->
        <?php
        $certNo = $student['certificate_number'] ?? ($cert['certificate_number'] ?? 'IBVTE-' . date('Y') . '-' . str_pad($studentId, 5, '0', STR_PAD_LEFT));
        $issueDate = !empty($student['certificate_issued_at']) ? $student['certificate_issued_at'] : (!empty($cert['issued_at']) ? $cert['issued_at'] : date('Y-m-d'));
        ?>
        <div class="certificate-box mb-4">
            <img src="../assets/images/logo.jpeg" alt="IBVTE" class="cert-logo">
            <div class="cert-title">IBVTE</div>
            <div class="cert-subtitle">Indian Board of Vocational and Technical Education</div>
            <div class="cert-subtitle" style="font-size:.8rem;margin-bottom:16px;">60 Futa Road, Samar Garden Colony, Meerut (UP) – 250002</div>

            <div style="background:linear-gradient(135deg,var(--primary),var(--secondary));color:white;padding:10px 30px;border-radius:30px;display:inline-block;letter-spacing:3px;font-size:.85rem;font-weight:700;text-transform:uppercase;margin-bottom:20px;">
                Certificate of Achievement
            </div>

            <p class="cert-text">This is to certify that</p>
            <div class="cert-name"><?= htmlspecialchars($student['full_name']) ?></div>
            <p class="cert-text">
                Son/Daughter of <strong><?= htmlspecialchars($student['father_name'] ?? '___________') ?></strong><br>
                has successfully completed the course of
            </p>
            <div class="cert-course"><?= htmlspecialchars($student['course_name'] ?? '-') ?></div>
            <p class="cert-text mt-2">
                from <strong><?= htmlspecialchars($student['institution_name'] ?? 'IBVTE Affiliated Institution') ?></strong><br>
                during the session <strong><?= htmlspecialchars($student['session_year'] ?? date('Y')) ?></strong><br>
                with <strong><?= getDivisionLabel($student['division'] ?? 'first') ?></strong>
                (<?= number_format($student['percentage'] ?? 0, 2) ?>%)
            </p>

            <div class="cert-details mt-4">
                <div class="cert-detail-item">
                    <div class="label">Certificate No.</div>
                    <div class="value"><?= htmlspecialchars($certNo) ?></div>
                </div>
                <div class="cert-detail-item">
                    <div class="label">Roll Number</div>
                    <div class="value"><?= htmlspecialchars($student['roll_number']) ?></div>
                </div>
                <div class="cert-detail-item">
                    <div class="label">Issue Date</div>
                    <div class="value"><?= formatDate($issueDate) ?></div>
                </div>
            </div>

            <div class="row mt-5">
                <div class="col-4 text-center">
                    <div class="cert-sig">Principal / Director<br><?= htmlspecialchars($student['institution_name'] ?? '') ?></div>
                </div>
                <div class="col-4 text-center">
                    <img src="../assets/images/logo.jpeg" alt="seal" style="height:60px;opacity:.15;position:absolute;left:50%;transform:translateX(-50%) translateY(-50%);top:50%;">
                    <div class="cert-sig text-primary fw-bold">IBVTE<br>Official Seal</div>
                </div>
                <div class="col-4 text-center">
                    <div class="cert-sig">Controller of Examinations<br>IBVTE</div>
                </div>
            </div>
        </div>
        <?php endif; ?>
    </div>

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