<?php
try {
    $db = Database::getInstance();
    $pendingTransfers = (int) $db->fetchColumn("SELECT COUNT(*) FROM membership_transfers WHERE status NOT IN ('completed','cancelled','rejected')");
    $upcomingMeeting = $db->fetchOne("SELECT meeting_number, meeting_date, title_en FROM board_meetings WHERE status = 'scheduled' AND meeting_date >= CURDATE() ORDER BY meeting_date ASC LIMIT 1");
    $activeOffers = (int) $db->fetchColumn("SELECT COUNT(*) FROM special_offers WHERE status = 'active' AND end_date >= CURDATE()");
} catch (\Exception $e) {
    $pendingTransfers = 0;
    $upcomingMeeting = null;
    $activeOffers = 0;
}
?>
<div class="card border-info h-100">
    <div class="card-header bg-transparent"><h6 class="mb-0"><i class="fas fa-landmark me-2 text-info"></i><?= lang('board.board_summary') ?></h6></div>
    <div class="card-body">
        <div class="mb-3">
            

---