/**
 * /app/views/sent_certificates.php
 */

require_once dirname(__DIR__) . '/config/config.php';
require_once dirname(__DIR__) . '/config/database.php';

require_once dirname(__DIR__) . '/services/AuthService.php';

AuthService::requireLogin();

include dirname(__DIR__) . '/views/partials/header.php';

global $pdo;

$stmt = $pdo->query(
    "SELECT
        sc.id,
        sc.sent_date,
        sc.pdf_filename,
        sc.sent_to_email,
        ch.company_name,
        ch.id AS holder_id
     FROM sent_certificates sc
     JOIN certificate_holders ch
        ON ch.id = sc.certificate_holder_id
     ORDER BY sc.sent_date DESC"
);

$sent = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<div class="container-fluid">

    <div class="d-flex justify-content-between align-items-center mb-4">

        <h2 class="mb-0">Sent Certificates</h2>

    </div>

            <div class="alert alert-info">
            No sent certificates found.
        </div>
    
</div>


    </div> <!-- end container / page wrapper -->

    <footer class="bg-light border-top mt-5 py-3">
        <div class="container text-center text-muted small">
            COI Generator v1 &copy; 2026 - Internal Use Only
        </div>
    </footer>

    <!-- Bootstrap JS -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>

</body>
</html>