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 = 'All Users';
include 'header.php';

$error = '';
$success = '';

// Handle user actions (edit, add balance, etc.)
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        $user_id = intval($_POST['user_id']);
        
        try {
            switch ($_POST['action']) {
                case 'edit':
                    $fullname = trim($_POST['fullname']);
                    $email = trim($_POST['email']);
                    $phone = trim($_POST['phone']);
                    
                    // Validate email
                    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
                        throw new Exception('Invalid email format');
                    }
                    
                    $stmt = $pdo->prepare("UPDATE users SET fullname = ?, email = ?, phone = ? WHERE id = ?");
                    $stmt->execute([$fullname, $email, $phone, $user_id]);
                    $success = 'User updated successfully.';
                    break;
                    
                case 'add_balance':
                    $amount = floatval($_POST['amount']);
                    
                    // Validate amount
                    if ($amount <= 0) {
                        throw new Exception('Amount must be greater than zero');
                    }
                    
                    // Add amount to user balance
                    $stmt = $pdo->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
                    $stmt->execute([$amount, $user_id]);
                    
                    // Add transaction record
                    $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, note) VALUES (?, 'deposit', ?, 'Balance added by admin')");
                    $stmt->execute([$user_id, $amount]);
                    
                    $success = 'Balance added successfully.';
                    break;
                    
                case 'deduct_balance':
                    $amount = floatval($_POST['amount']);
                    
                    // Validate amount
                    if ($amount <= 0) {
                        throw new Exception('Amount must be greater than zero');
                    }
                    
                    // Check if user has enough balance
                    $stmt = $pdo->prepare("SELECT balance FROM users WHERE id = ?");
                    $stmt->execute([$user_id]);
                    $user = $stmt->fetch();
                    
                    if ($user && $user['balance'] < $amount) {
                        throw new Exception('Insufficient balance');
                    }
                    
                    // Deduct amount from user balance
                    $stmt = $pdo->prepare("UPDATE users SET balance = balance - ? WHERE id = ?");
                    $stmt->execute([$amount, $user_id]);
                    
                    // Add transaction record
                    $stmt = $pdo->prepare("INSERT INTO transactions (user_id, type, amount, note) VALUES (?, 'withdraw', ?, 'Balance deducted by admin')");
                    $stmt->execute([$user_id, $amount]);
                    
                    $success = 'Balance deducted successfully.';
                    break;
                    
                case 'suspend':
                    // In a real application, you might want to implement user suspension
                    $success = 'User suspension feature not implemented in this demo.';
                    break;
                    
                case 'delete':
                    // In a real application, you might want to implement user deletion
                    $success = 'User deletion feature not implemented in this demo.';
                    break;
                    
                default:
                    throw new Exception('Invalid action');
            }
        } catch (Exception $e) {
            $error = 'Error: ' . $e->getMessage();
        } catch (PDOException $e) {
            $error = 'Database error: ' . $e->getMessage();
        }
    } else {
        $error = 'No action specified';
    }
    
    // Refresh user data after POST
    try {
        $stmt = $pdo->prepare("SELECT u.*, p.name as plan_name FROM users u LEFT JOIN plans p ON u.current_plan = p.id ORDER BY u.joined_at DESC");
        $stmt->execute();
        $users = $stmt->fetchAll();
    } catch (PDOException $e) {
        $users = [];
        $error = 'Failed to fetch users: ' . $e->getMessage();
    }
} else {
    // Get all users for GET request
    try {
        $stmt = $pdo->prepare("SELECT u.*, p.name as plan_name FROM users u LEFT JOIN plans p ON u.current_plan = p.id ORDER BY u.joined_at DESC");
        $stmt->execute();
        $users = $stmt->fetchAll();
    } catch (PDOException $e) {
        $users = [];
        $error = 'Failed to fetch users: ' . $e->getMessage();
    }
}
?>

<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">All Users</h1>
</div>

<?php if ($error): ?>
    <div class="alert alert-danger alert-dismissible fade show" role="alert">
        <?php echo htmlspecialchars($error); ?>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
<?php endif; ?>

<?php if ($success): ?>
    <div class="alert alert-success alert-dismissible fade show" role="alert">
        <?php echo htmlspecialchars($success); ?>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
<?php endif; ?>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <?php if (count($users) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Phone</th>
                                    <th>Balance</th>
                                    <th>Plan</th>
                                    <th>Join Date</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($users as $user): ?>
                                    <tr>
                                        <td><?php echo $user['id']; ?></td>
                                        <td><?php echo htmlspecialchars($user['fullname']); ?></td>
                                        <td><?php echo htmlspecialchars($user['email']); ?></td>
                                        <td><?php echo htmlspecialchars($user['phone']); ?></td>
                                        <td>₨<?php echo number_format($user['balance'], 2); ?></td>
                                        <td>
                                            <?php if ($user['plan_name']): ?>
                                                <span class="badge bg-success"><?php echo htmlspecialchars($user['plan_name']); ?></span>
                                            <?php else: ?>
                                                <span class="badge bg-secondary">No Plan</span>
                                            <?php endif; ?>
                                        </td>
                                        <td><?php echo date('M d, Y', strtotime($user['joined_at'])); ?></td>
                                        <td>
                                            <div class="btn-group" role="group">
                                                <button type="button" class="btn btn-sm btn-outline-primary" data-bs-toggle="modal" data-bs-target="#editModal<?php echo $user['id']; ?>">
                                                    <i class="fas fa-edit"></i> Edit
                                                </button>
                                                <button type="button" class="btn btn-sm btn-outline-success" data-bs-toggle="modal" data-bs-target="#balanceModal<?php echo $user['id']; ?>">
                                                    <i class="fas fa-wallet"></i> Balance
                                                </button>
                                                <a href="login_as_user.php?user_id=<?php echo $user['id']; ?>" class="btn btn-sm btn-outline-info">
                                                    <i class="fas fa-sign-in-alt"></i> Login As
                                                </a>
                                            </div>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <p>No users found.</p>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

<?php foreach ($users as $user): ?>

<div class="modal fade" id="editModal<?php echo $user['id']; ?>" tabindex="-1" aria-labelledby="editModalLabel<?php echo $user['id']; ?>" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <form method="POST">
                <div class="modal-header">
                    <h5 class="modal-title" id="editModalLabel<?php echo $user['id']; ?>">Edit User: <?php echo htmlspecialchars($user['fullname']); ?></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="user_id" value="<?php echo $user['id']; ?>">
                    <input type="hidden" name="action" value="edit">
                    <div class="mb-3">
                        <label class="form-label">Full Name</label>
                        <input type="text" class="form-control" name="fullname" value="<?php echo htmlspecialchars($user['fullname']); ?>" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Email</label>
                        <input type="email" class="form-control" name="email" value="<?php echo htmlspecialchars($user['email']); ?>" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Phone</label>
                        <input type="text" class="form-control" name="phone" value="<?php echo htmlspecialchars($user['phone']); ?>" required>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-primary">Save Changes</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="balanceModal<?php echo $user['id']; ?>" tabindex="-1" aria-labelledby="balanceModalLabel<?php echo $user['id']; ?>" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <form method="POST">
                <div class="modal-header">
                    <h5 class="modal-title" id="balanceModalLabel<?php echo $user['id']; ?>">Update Balance for <?php echo htmlspecialchars($user['fullname']); ?></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="user_id" value="<?php echo $user['id']; ?>">
                    <div class="mb-3">
                        <label class="form-label">Current Balance: ₨<?php echo number_format($user['balance'], 2); ?></label>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Amount (₨)</label>
                        <input type="number" class="form-control" name="amount" step="0.01" min="0.01" required>
                    </div>
                    <div class="form-check mb-3">
                        <input class="form-check-input" type="radio" name="action" value="add_balance" id="add<?php echo $user['id']; ?>" checked>
                        <label class="form-check-label" for="add<?php echo $user['id']; ?>">Add Balance</label>
                    </div>
                    <div class="form-check">
                        <input class="form-check-input" type="radio" name="action" value="deduct_balance" id="deduct<?php echo $user['id']; ?>">
                        <label class="form-check-label" for="deduct<?php echo $user['id']; ?>">Deduct Balance</label>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-primary">Update Balance</button>
                </div>
            </form>
        </div>
    </div>
</div>
<?php endforeach; ?>

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