<?php
require_once '../config.php';
requireLogin('master_admin');

$users = $conn->query("SELECT u.*, sa.full_name as sa_name, sa.unique_code FROM users u JOIN sub_admins sa ON sa.id=u.sub_admin_id ORDER BY u.created_at DESC")->fetch_all(MYSQLI_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>All Users - Cricket Exchange Admin</title>
    <link rel="stylesheet" href="../assets/style.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
</head>
<body>
<div class="dashboard-wrapper">
    <?php include 'partials/sidebar.php'; ?>
    <div class="main-content">
        <div class="topbar">
            <div class="topbar-title"><h1>All Users</h1><p>View all users across all sub admins</p></div>
            <div class="topbar-actions">
                <div class="search-box">
                    <span class="search-icon">🔍</span>
                    <input type="text" placeholder="Search users..." id="searchInput" onkeyup="filterTable()">
                </div>
            </div>
        </div>
        <div class="page-content">
            <div class="card">
                <div class="card-header">
                    <h3>🙋 All Users (<?= count($users) ?>)</h3>
                    <div class="stats-mini" style="display:flex;gap:16px;font-size:13px;">
                        <?php 
                        $total_user_bal = array_sum(array_column($users, 'wallet_balance'));
                        ?>
                        <span class="text-primary">Total Wallets: <?= formatINR($total_user_bal) ?></span>
                    </div>
                </div>
                <div class="table-wrapper">
                    <table id="usersTable">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>User</th>
                                <th>Sub Admin</th>
                                <th>Wallet Balance</th>
                                <th>Total Received</th>
                                <th>Status</th>
                                <th>Joined</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($users as $i => $u): ?>
                            <tr>
                                <td><?= $i+1 ?></td>
                                <td>
                                    <div style="font-weight:600"><?= htmlspecialchars($u['full_name']) ?></div>
                                    <div style="font-size:12px;color:var(--text-muted)">@<?= htmlspecialchars($u['username']) ?></div>
                                    <?php if ($u['mobile']): ?><div style="font-size:12px;color:var(--text-muted)">📱 <?= $u['mobile'] ?></div><?php endif; ?>
                                </td>
                                <td>
                                    <div style="font-weight:600"><?= htmlspecialchars($u['sa_name']) ?></div>
                                    <span class="code-badge"><?= $u['unique_code'] ?></span>
                                </td>
                                <td><span class="text-primary fw-700"><?= formatINR($u['wallet_balance']) ?></span></td>
                                <td><?= formatINR($u['total_received']) ?></td>
                                <td><span class="badge badge-<?= $u['status'] ?>"><?= ucfirst($u['status']) ?></span></td>
                                <td style="font-size:12px;color:var(--text-muted)"><?= date('d M Y', strtotime($u['created_at'])) ?></td>
                            </tr>
                            <?php endforeach; ?>
                            <?php if (empty($users)): ?>
                            <tr><td colspan="7"><div class="empty-state"><div class="empty-icon">🙋</div><p>No users yet</p></div></td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
<?php include 'partials/scripts.php'; ?>
<script>
function filterTable() {
    const val = document.getElementById('searchInput').value.toLowerCase();
    document.querySelectorAll('#usersTable tbody tr').forEach(tr => {
        tr.style.display = tr.textContent.toLowerCase().includes(val) ? '' : 'none';
    });
}
</script>
</body>
</html>
