/**
 * /app/views/certificate_holders.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 *
     FROM certificate_holders
     ORDER BY company_name ASC"
);

$holders = $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">Certificate Holders</h2>

        <a href="certificate_holder_form.php" class="btn btn-success">
            + Add Certificate Holder
        </a>

    </div>

            <div class="alert alert-info">
            No certificate holders 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>