Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
activate_dpin.php	7.76 KB	-rw-r--r--	2025-10-18 22:14
ads.php	11.49 KB	-rw-r--r--	2025-10-18 22:44
commission.php	7.01 KB	-rw-r--r--	2025-10-18 21:56
dashboard.php	17.28 KB	-rw-r--r--	2025-10-18 22:49
deposit.php	6.03 KB	-rw-r--r--	2025-10-18 21:45
deposit_history.php	4.26 KB	-rw-r--r--	2025-10-18 21:55
dpin.php	7.2 KB	-rw-r--r--	2025-10-18 22:26
dpin_history.php	5.91 KB	-rw-r--r--	2025-10-18 22:15
invite.php	6.44 KB	-rw-r--r--	2025-10-18 21:43
logout.php	91 B	-rw-r--r--	2025-10-18 21:42
notifications.php	3.73 KB	-rw-r--r--	2025-10-18 21:47
plans.php	10.34 KB	-rw-r--r--	2025-10-18 22:43
profile.php	6.69 KB	-rw-r--r--	2025-10-18 21:43
purchase_plan.php	4.99 KB	-rw-r--r--	2025-10-18 21:46
sidebar.php	5.16 KB	-rw-r--r--	2025-10-18 22:15
team.php	6.81 KB	-rw-r--r--	2025-10-18 21:47
transactions.php	4.37 KB	-rw-r--r--	2025-10-18 21:47
withdraw.php	7.92 KB	-rw-r--r--	2025-10-18 21:56
withdraw_history.php	7.74 KB	-rw-r--r--	2025-10-18 21:56

Rename

<?php
require_once '../includes/header.php';

// Get referral commissions for user
$stmt = $conn->prepare("SELECT rc.*, u.name as from_user_name FROM referral_commissions rc JOIN users u ON rc.from_user = u.id WHERE rc.to_user = ? ORDER BY rc.date DESC");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$commissions_result = $stmt->get_result();
$commissions = [];
while ($row = $commissions_result->fetch_assoc()) {
    $commissions[] = $row;
}

// Get total referral earnings
$stmt = $conn->prepare("SELECT SUM(amount) as total FROM referral_commissions WHERE to_user = ?");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$total_result = $stmt->get_result();
$total_earnings = $total_result->fetch_assoc()['total'] ?? 0;

// Get referral settings
$referral_settings = [];
$stmt = $conn->prepare("SELECT * FROM referral_settings ORDER BY level ASC");
$stmt->execute();
$settings_result = $stmt->get_result();
while ($row = $settings_result->fetch_assoc()) {
    $referral_settings[$row['level']] = $row['percentage'];
}
?>

<div class="container-fluid">
    <div class="row">
        
        <?php include 'sidebar.php'; ?>
        
        
        <main class="col-md-9 ms-sm-auto col-lg-10 main-content">
            <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">Referral Commission</h1>
            </div>
            
            <div class="row">
                <div class="col-md-12">
                    <div class="stat-card">
                        <i class="fas fa-wallet text-success"></i>
                        <h3><?php echo format_currency($total_earnings); ?></h3>
                        <p>Total Referral Earnings</p>
                    </div>
                </div>
            </div>
            
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Commission Structure</h5>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-striped">
                                    <thead>
                                        <tr>
                                            <th>Level</th>
                                            <th>Commission Percentage</th>
                                            <th>Description</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php if (empty($referral_settings)): ?>
                                            <tr>
                                                <td colspan="3" class="text-center">No referral settings configured</td>
                                            </tr>
                                        <?php else: ?>
                                            <?php foreach ($referral_settings as $level => $percentage): ?>
                                                <tr>
                                                    <td>Level <?php echo $level; ?></td>
                                                    <td><?php echo $percentage; ?>%</td>
                                                    <td>
                                                        <?php if ($level == 1): ?>
                                                            Direct referrals (friends you invited)
                                                        <?php elseif ($level == 2): ?>
                                                            Referrals of your referrals
                                                        <?php else: ?>
                                                            Level <?php echo $level; ?> referrals
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        <?php endif; ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Commission History</h5>
                        </div>
                        <div class="card-body">
                            <?php if (empty($commissions)): ?>
                                <div class="text-center py-5">
                                    <i class="fas fa-percentage fa-3x text-muted mb-3"></i>
                                    <h4>No Commission History</h4>
                                    <p class="mb-3">You haven't earned any referral commissions yet.</p>
                                    <a href="invite.php" class="btn btn-primary">Invite Friends</a>
                                </div>
                            <?php else: ?>
                                <div class="table-responsive">
                                    <table class="table table-striped">
                                        <thead>
                                            <tr>
                                                <th>Date</th>
                                                <th>From User</th>
                                                <th>Level</th>
                                                <th>Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($commissions as $commission): ?>
                                                <tr>
                                                    <td><?php echo date('M d, Y H:i', strtotime($commission['date'])); ?></td>
                                                    <td><?php echo htmlspecialchars($commission['from_user_name']); ?></td>
                                                    <td>Level <?php echo $commission['level']; ?></td>
                                                    <td><?php echo format_currency($commission['amount']); ?></td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
        </main>
    </div>
</div>

<?php
require_once '../includes/footer.php';
?>