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.06 KB	-rw-r--r--	2025-10-18 02:06
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 = 'Team Commissions';
include 'header.php';

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

// Handle manual commission addition
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add_commission') {
    $user_id = intval($_POST['user_id']);
    $amount = floatval($_POST['amount']);
    $note = trim($_POST['note']);
    
    // Validation
    if (empty($user_id) || $amount <= 0) {
        $error = 'Please select a user and enter a valid amount.';
    } else {
        try {
            // Check if user exists
            $stmt = $pdo->prepare("SELECT id, fullname FROM users WHERE id = ?");
            $stmt->execute([$user_id]);
            $user = $stmt->fetch();
            
            if (!$user) {
                $error = 'Invalid user selected.';
            } else {
                // Add commission 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 (?, 'commission', ?, ?)");
                $stmt->execute([$user_id, $amount, 'Manual commission: ' . $note]);
                
                $success = 'Commission of ₨' . number_format($amount, 2) . ' added to ' . htmlspecialchars($user['fullname']) . '\'s account successfully.';
            }
        } catch (PDOException $e) {
            $error = 'Failed to add commission. Please try again.';
        }
    }
}

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

// Get recent manual commissions
try {
    $stmt = $pdo->prepare("SELECT t.*, u.fullname FROM transactions t JOIN users u ON t.user_id = u.id WHERE t.type = 'commission' AND t.note LIKE 'Manual commission:%' ORDER BY t.created_at DESC LIMIT 20");
    $stmt->execute();
    $recent_commissions = $stmt->fetchAll();
} catch (PDOException $e) {
    $recent_commissions = [];
}
?>

<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">Team Commissions</h1>
</div>

<?php if ($error): ?>
    <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div>
<?php endif; ?>

<?php if ($success): ?>
    <div class="alert alert-success"><?php echo htmlspecialchars($success); ?></div>
<?php endif; ?>

<div class="row">
    <div class="col-md-6">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Add Manual Commission</h5>
                <form method="POST">
                    <input type="hidden" name="action" value="add_commission">
                    <div class="mb-3">
                        <label for="user_id" class="form-label">Select User</label>
                        <select class="form-select" id="user_id" name="user_id" required>
                            <option value="">Select a user</option>
                            <?php foreach ($users as $user): ?>
                                <option value="<?php echo $user['id']; ?>"><?php echo htmlspecialchars($user['fullname'] . ' (' . $user['email'] . ')'); ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label for="amount" class="form-label">Commission Amount (₨)</label>
                        <input type="number" class="form-control" id="amount" name="amount" step="0.01" min="0.01" required>
                    </div>
                    <div class="mb-3">
                        <label for="note" class="form-label">Note/Reason</label>
                        <textarea class="form-control" id="note" name="note" rows="3" placeholder="Enter reason for manual commission..." required></textarea>
                    </div>
                    <button type="submit" class="btn btn-primary">Add Commission</button>
                </form>
            </div>
        </div>
    </div>
    <div class="col-md-6">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">About Manual Commissions</h5>
                <p>Use this page to manually add commissions to user accounts for special circumstances such as:</p>
                <ul>
                    <li>Bonuses for top performers</li>
                    <li>Referral rewards not automatically processed</li>
                    <li>Special promotions or campaigns</li>
                    <li>Correction of commission calculation errors</li>
                </ul>
                <p class="mb-0">All manual commissions will be recorded in the transaction history for auditing purposes.</p>
            </div>
        </div>
    </div>
</div>

<div class="row mt-4">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Recent Manual Commissions</h5>
                <?php if (count($recent_commissions) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>User</th>
                                    <th>Amount</th>
                                    <th>Note</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($recent_commissions as $commission): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($commission['fullname']); ?></td>
                                        <td>₨<?php echo number_format($commission['amount'], 2); ?></td>
                                        <td><?php echo htmlspecialchars(str_replace('Manual commission: ', '', $commission['note'])); ?></td>
                                        <td><?php echo date('M d, Y H:i', strtotime($commission['created_at'])); ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <p>No manual commissions found.</p>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

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