Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	13.96 KB	-rw-r--r--	2025-10-17 23:08
auth.php	343 B	-rw-r--r--	2025-10-17 23:20
dashboard.php	8.71 KB	-rw-r--r--	2025-10-18 00:40
deposit_methods.php	12.36 KB	-rw-r--r--	2025-10-17 23:06
deposits.php	13.24 KB	-rw-r--r--	2025-10-18 00:56
dpin.php	6.16 KB	-rw-r--r--	2025-10-17 23:06
footer.php	565 B	-rw-r--r--	2025-10-17 23:05
header.php	13.05 KB	-rw-r--r--	2025-10-18 00:59
login.php	3.37 KB	-rw-r--r--	2025-10-17 23:09
login_as_user.php	1020 B	-rw-r--r--	2025-10-17 23:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:08
plans.php	13.65 KB	-rw-r--r--	2025-10-17 23:06
referral_commissions.php	11.93 KB	-rw-r--r--	2025-10-18 00:13
team_commissions.php	6.66 KB	-rw-r--r--	2025-10-17 23:45
test_modals.php	4.44 KB	-rw-r--r--	2025-10-18 00:49
test_referral_commissions.php	2.87 KB	-rw-r--r--	2025-10-18 00:13
test_user_edit.php	4.96 KB	-rw-r--r--	2025-10-18 00:44
transactions.php	6.36 KB	-rw-r--r--	2025-10-17 23:08
users.php	13.55 KB	-rw-r--r--	2025-10-18 00:49
withdraw_methods.php	12.49 KB	-rw-r--r--	2025-10-17 23:08
withdraws.php	9.16 KB	-rw-r--r--	2025-10-17 23:39

Rename

<?php
$title = 'Recent Transactions';
include 'header.php';

// Get filter parameters
$user_filter = $_GET['user'] ?? '';
$type_filter = $_GET['type'] ?? '';

// Build query based on filters
$where_clause = "1=1";
$params = [];

if (!empty($user_filter)) {
    $where_clause .= " AND t.user_id = ?";
    $params[] = $user_filter;
}

if (!empty($type_filter)) {
    $where_clause .= " AND t.type = ?";
    $params[] = $type_filter;
}

// Get all users for filter dropdown
try {
    $stmt = $pdo->prepare("SELECT id, fullname, email FROM users ORDER BY fullname");
    $stmt->execute();
    $users = $stmt->fetchAll();
} catch (PDOException $e) {
    $users = [];
}

// Get transactions with filters
try {
    $sql = "SELECT t.*, u.fullname FROM transactions t JOIN users u ON t.user_id = u.id WHERE $where_clause ORDER BY t.created_at DESC LIMIT 100";
    $stmt = $pdo->prepare($sql);
    $stmt->execute($params);
    $transactions = $stmt->fetchAll();
} catch (PDOException $e) {
    $transactions = [];
}
?>

<div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
    <h1 class="h2">Recent Transactions</h1>
</div>

<div class="row mb-3">
    <div class="col-md-12">
        <div class="card">
            <div class="card-body">
                <form method="GET" class="row g-3">
                    <div class="col-md-4">
                        <label for="user" class="form-label">Filter by User</label>
                        <select class="form-select" id="user" name="user">
                            <option value="">All Users</option>
                            <?php foreach ($users as $user): ?>
                                <option value="<?php echo $user['id']; ?>" <?php echo ($user_filter == $user['id']) ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($user['fullname'] . ' (' . $user['email'] . ')'); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-4">
                        <label for="type" class="form-label">Filter by Type</label>
                        <select class="form-select" id="type" name="type">
                            <option value="">All Types</option>
                            <option value="deposit" <?php echo ($type_filter == 'deposit') ? 'selected' : ''; ?>>Deposit</option>
                            <option value="withdraw" <?php echo ($type_filter == 'withdraw') ? 'selected' : ''; ?>>Withdraw</option>
                            <option value="commission" <?php echo ($type_filter == 'commission') ? 'selected' : ''; ?>>Commission</option>
                            <option value="ad" <?php echo ($type_filter == 'ad') ? 'selected' : ''; ?>>Ad Reward</option>
                        </select>
                    </div>
                    <div class="col-md-4 d-flex align-items-end">
                        <button type="submit" class="btn btn-primary me-2">Filter</button>
                        <a href="transactions.php" class="btn btn-secondary">Clear</a>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <?php if (count($transactions) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>User</th>
                                    <th>Type</th>
                                    <th>Amount</th>
                                    <th>Note</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($transactions as $transaction): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($transaction['fullname']); ?></td>
                                        <td>
                                            <?php
                                            switch ($transaction['type']) {
                                                case 'deposit':
                                                    echo '<span class="badge bg-info">Deposit</span>';
                                                    break;
                                                case 'withdraw':
                                                    echo '<span class="badge bg-warning">Withdraw</span>';
                                                    break;
                                                case 'commission':
                                                    echo '<span class="badge bg-success">Commission</span>';
                                                    break;
                                                case 'ad':
                                                    echo '<span class="badge bg-primary">Ad Reward</span>';
                                                    break;
                                                default:
                                                    echo '<span class="badge bg-secondary">' . ucfirst($transaction['type']) . '</span>';
                                            }
                                            ?>
                                        </td>
                                        <td>₨<?php echo number_format($transaction['amount'], 2); ?></td>
                                        <td><?php echo htmlspecialchars($transaction['note'] ?? '-'); ?></td>
                                        <td><?php echo date('M d, Y H:i', strtotime($transaction['created_at'])); ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <p>No transactions found.</p>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

<?php include 'footer.php'; ?>