<?php
require_once '../../config.php';
requireLogin('sub_admin');
$sa = $conn->query("SELECT * FROM sub_admins WHERE id=" . (int)$_SESSION['user_id'])->fetch_assoc();
$sa_id = (int)$_SESSION['user_id'];
$transactions = $conn->query("SELECT * FROM subadmin_wallet_transactions WHERE sub_admin_id=$sa_id ORDER BY created_at DESC LIMIT 50")->fetch_all(MYSQLI_ASSOC);
$total_in = $conn->query("SELECT SUM(amount) as t FROM subadmin_wallet_transactions WHERE sub_admin_id=$sa_id AND transaction_type='credit'")->fetch_assoc()['t'] ?? 0;
$total_out = $conn->query("SELECT SUM(amount) as t FROM subadmin_wallet_transactions WHERE sub_admin_id=$sa_id AND transaction_type='debit'")->fetch_assoc()['t'] ?? 0;
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>My Wallet - Sub Admin | Cricket Exchange</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">
    <style>.btn-primary{background:linear-gradient(135deg,var(--subadmin-accent),#0369a1)}</style>
</head>
<body>
<div class="dashboard-wrapper">
    <?php include 'partials/sidebar.php'; ?>
    <div class="main-content">
        <div class="topbar">
            <div class="topbar-title"><h1>My Wallet</h1><p>View wallet balance and transaction history</p></div>
            <div class="topbar-actions">
                <a href="deposit_request.php" class="btn btn-primary btn-sm"><i class="fas fa-plus"></i> Request Deposit</a>
                <a href="withdrawal_request.php" class="btn btn-secondary btn-sm"><i class="fas fa-minus"></i> Withdraw</a>
            </div>
        </div>
        <div class="page-content">
            <div style="display:grid;grid-template-columns:1fr 1fr 1fr;gap:20px;margin-bottom:28px;">
                <div class="wallet-card">
                    <div style="font-size:13px;color:var(--text-muted);margin-bottom:8px">💰 Current Balance</div>
                    <div class="wallet-amount"><?= formatINR($sa['wallet_balance']) ?></div>
                    <div style="font-size:12px;color:var(--text-muted);margin-top:8px">Code: <span class="code-badge"><?= $sa['unique_code'] ?></span></div>
                </div>
                <div class="stat-card green">
                    <div class="stat-top">
                        <div><div class="stat-value"><?= formatINR($total_in) ?></div><div class="stat-label">Total Received</div></div>
                        <div class="stat-icon icon-green">⬆️</div>
                    </div>
                </div>
                <div class="stat-card red">
                    <div class="stat-top">
                        <div><div class="stat-value"><?= formatINR($total_out) ?></div><div class="stat-label">Total Disbursed</div></div>
                        <div class="stat-icon icon-red">⬇️</div>
                    </div>
                </div>
            </div>

            <div class="card">
                <div class="card-header"><h3>📜 Transaction History</h3></div>
                <div class="table-wrapper">
                    <table>
                        <thead><tr><th>#</th><th>Type</th><th>Amount</th><th>Description</th><th>Recipient</th><th>Balance After</th><th>Date</th></tr></thead>
                        <tbody>
                            <?php foreach ($transactions as $i => $txn): ?>
                            <tr>
                                <td><?= $i+1 ?></td>
                                <td>
                                    <?php if ($txn['transaction_type']==='credit'): ?>
                                    <span class="badge badge-approved">⬆️ Credit</span>
                                    <?php else: ?>
                                    <span class="badge badge-rejected">⬇️ Debit</span>
                                    <?php endif; ?>
                                </td>
                                <td class="txn-amount-<?= $txn['transaction_type'] ?>" style="font-size:15px">
                                    <?= $txn['transaction_type']==='credit'?'+':'-' ?><?= formatINR($txn['amount']) ?>
                                </td>
                                <td><?= htmlspecialchars($txn['description'] ?? '-') ?></td>
                                <td><?= $txn['recipient_name'] ? htmlspecialchars($txn['recipient_name']) : '<span class="text-muted">-</span>' ?></td>
                                <td class="text-primary fw-700"><?= formatINR($txn['balance_after']) ?></td>
                                <td style="font-size:12px;color:var(--text-muted)"><?= date('d M Y H:i', strtotime($txn['created_at'])) ?></td>
                            </tr>
                            <?php endforeach; ?>
                            <?php if (empty($transactions)): ?><tr><td colspan="7"><div class="empty-state"><div class="empty-icon">💳</div><p>No transactions</p></div></td></tr><?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
<?php include 'partials/scripts.php'; ?>
</body>
</html>
