<?php
$current_page = basename($_SERVER['PHP_SELF'], '.php');
$sa_id = (int)$_SESSION['user_id'];
$pending_dep = $conn->query("SELECT COUNT(*) as c FROM user_deposit_requests WHERE sub_admin_id=$sa_id AND status='pending'")->fetch_assoc()['c'];
$pending_wit = $conn->query("SELECT COUNT(*) as c FROM user_withdrawal_requests WHERE sub_admin_id=$sa_id AND status='pending'")->fetch_assoc()['c'];
$total_pending = $pending_dep + $pending_wit;
?>
<aside class="sidebar" id="mainSidebar">
    <div class="sidebar-header">
        <div class="sidebar-logo">
            <div class="logo-icon" style="background:linear-gradient(135deg,var(--subadmin-accent),#0369a1)">🏏</div>
            <div class="logo-text">
                <h2>Cricket Exchange</h2>
                <span>Sub Admin Panel</span>
            </div>
        </div>
    </div>
    <div class="sidebar-user">
        <div class="user-avatar avatar-subadmin">👤</div>
        <div class="user-info">
            <div class="name"><?= htmlspecialchars($_SESSION['full_name'] ?? 'Sub Admin') ?></div>
            <span class="role-badge role-subadmin">Sub Admin</span>
        </div>
    </div>
    <nav class="sidebar-nav">
        <div class="nav-section-label">Overview</div>
        <a href="dashboard.php" class="nav-item <?= $current_page==='dashboard'?'active':'' ?>">
            <span class="nav-icon">📊</span> Dashboard
        </a>
        <a href="wallet.php" class="nav-item <?= $current_page==='wallet'?'active':'' ?>">
            <span class="nav-icon">💰</span> My Wallet
        </a>
        <div class="nav-section-label">My Users</div>
        <a href="users.php" class="nav-item <?= $current_page==='users'?'active':'' ?>">
            <span class="nav-icon">🙋</span> Manage Users
        </a>
        <a href="requests.php" class="nav-item <?= $current_page==='requests'?'active':'' ?>">
            <span class="nav-icon">📋</span> User Requests
            <?php if ($total_pending > 0): ?><span class="nav-badge"><?= $total_pending ?></span><?php endif; ?>
        </a>
        <div class="nav-section-label">My Account</div>
        <a href="deposit_request.php" class="nav-item <?= $current_page==='deposit_request'?'active':'' ?>">
            <span class="nav-icon">📥</span> Request Deposit
        </a>
        <a href="withdrawal_request.php" class="nav-item <?= $current_page==='withdrawal_request'?'active':'' ?>">
            <span class="nav-icon">📤</span> Withdraw Funds
        </a>
        <div class="nav-section-label">Cricket Match Center</div>
        <a href="../../scores.php" target="_blank" class="nav-item">
            <span class="nav-icon">🏏</span> Live Scores & Odds
        </a>
    </nav>
    <div class="sidebar-footer">
        <a href="logout.php" class="btn btn-secondary btn-full btn-sm">
            <i class="fas fa-sign-out-alt"></i> Logout
        </a>
    </div>
</aside>
