Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
includes	[ DIR ]	drwxr-xr-x	2026-03-11 22:58
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
404.php	5.09 KB	-rw-r--r--	2026-03-12 12:29
admin-profile.php	4.68 KB	-rw-r--r--	2026-03-13 19:31
assignments.php	20.91 KB	-rw-r--r--	2026-03-30 15:12
deposits.php	8.48 KB	-rw-r--r--	2026-03-12 13:18
error_log	3.7 KB	-rw-r--r--	2026-03-23 09:01
index.php	137 B	-rw-r--r--	2026-03-12 12:26
index_real.php	3.95 KB	-rw-r--r--	2026-03-13 19:31
login.php	2.46 KB	-rw-r--r--	2026-03-13 19:32
logout.php	88 B	-rw-r--r--	2026-03-11 22:57
maintenance.php	3.68 KB	-rw-r--r--	2026-03-12 12:35
payment-methods.php	7.03 KB	-rw-r--r--	2026-03-12 12:35
plans.php	7.85 KB	-rw-r--r--	2026-03-12 12:35
referrals.php	4.91 KB	-rw-r--r--	2026-03-31 10:44
settings.php	17.83 KB	-rw-r--r--	2026-03-31 10:21
tickets.php	9.89 KB	-rw-r--r--	2026-03-12 13:15
users.php	19.8 KB	-rw-r--r--	2026-03-29 05:10
withdraw-methods.php	8.28 KB	-rw-r--r--	2026-03-12 15:17
withdrawals.php	6.26 KB	-rw-r--r--	2026-03-12 15:18
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

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

// Top 10 Referrers
$topStmt = $pdo->query("SELECT referrer_id, u.full_name, COUNT(r.id) as total_referrals, SUM(r.commission_earned) as total_commission FROM referrals r JOIN users u ON r.referrer_id = u.id GROUP BY r.referrer_id ORDER BY total_referrals DESC LIMIT 10");
$top_referrers = $topStmt->fetchAll();

// Recent 50 Referrals
$recStmt = $pdo->query("SELECT r.*, referrer.full_name as referrer_name, referred.full_name as referred_name FROM referrals r JOIN users as referrer ON r.referrer_id = referrer.id JOIN users as referred ON r.referred_id = referred.id ORDER BY r.created_at DESC LIMIT 50");
$recent_referrals = $recStmt->fetchAll();

<h2 style="margin-bottom:30px;">Referrals Overview</h2>

<div class="grid" style="grid-template-columns: 1fr; gap:30px;">
    
    
    <div class="card" style="padding:20px; overflow-x:auto;">
        <h3 style="margin-bottom:20px; color:var(--primary-color);">Top 10 Referrers</h3>
        <table class="admin-table">
            <thead>
                <tr>
                    <th>Rank</th>
                    <th>Referrer Name</th>
                    <th>Total Active Referrals</th>
                    <th>Commissions Earned</th>
                </tr>
            </thead>
            <tbody>
                <?php $i = 1;
foreach ($top_referrers as $top): ?>
                    <tr>
                        <td style="font-weight:700;">#<?php echo $i++; ?></td>
                        <td style="font-weight:600;"><?php echo htmlspecialchars($top['full_name']); ?></td>
                        <td><?php echo $top['total_referrals']; ?> User(s)</td>
                        <td style="color:var(--primary-color); font-weight:600;">Rs <?php echo number_format($top['total_commission'], 2); ?></td>
                    </tr>
                <?php
endforeach; ?>
                <?php if (empty($top_referrers)): ?>
                    <tr><td colspan="4" style="text-align:center;">No completed referrals yet.</td></tr>
                <?php
endif; ?>
            </tbody>
        </table>
    </div>

<div class="card" style="padding:20px;">
        <h3 style="margin-bottom:20px;">Recent 50 Referrals</h3>
        <div class="custom-scrollbar" style="max-height: 550px; overflow-y: auto; overflow-x: auto;">
            <table class="admin-table" style="border-collapse: separate; border-spacing: 0; width: 100%;">
                <thead>
                    <tr>
                        <th style="position: sticky; top: 0; z-index: 100; background: var(--card-bg) !important; height: 50px; border-bottom: 1px solid rgba(0, 210, 106, 0.2); vertical-align: middle; padding: 0 15px;">Date</th>
                        <th style="position: sticky; top: 0; z-index: 100; background: var(--card-bg) !important; height: 50px; border-bottom: 1px solid rgba(0, 210, 106, 0.2); vertical-align: middle; padding: 0 15px;">Referred User (Joined)</th>
                        <th style="position: sticky; top: 0; z-index: 100; background: var(--card-bg) !important; height: 50px; border-bottom: 1px solid rgba(0, 210, 106, 0.2); vertical-align: middle; padding: 0 15px;">Referrer (Invited By)</th>
                        <th style="position: sticky; top: 0; z-index: 100; background: var(--card-bg) !important; height: 50px; border-bottom: 1px solid rgba(0, 210, 106, 0.2); vertical-align: middle; padding: 0 15px;">Level</th>
                        <th style="position: sticky; top: 0; z-index: 100; background: var(--card-bg) !important; height: 50px; border-bottom: 1px solid rgba(0, 210, 106, 0.2); vertical-align: middle; padding: 0 15px;">Commission Awarded</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($recent_referrals as $rec): ?>
                        <tr>
                            <td><?php echo date('M d, Y h:i A', strtotime($rec['created_at'])); ?></td>
                            <td style="font-weight:600;"><?php echo htmlspecialchars($rec['referred_name']); ?></td>
                            <td style="color:var(--text-muted);"><?php echo htmlspecialchars($rec['referrer_name']); ?></td>
                            <td>Lvl <?php echo $rec['level']; ?></td>
                            <td style="color:var(--primary-color);">Rs <?php echo number_format($rec['commission_earned'], 2); ?></td>
                        </tr>
                    <?php
    endforeach; ?>
                    <?php if (empty($recent_referrals)): ?>
                        <tr><td colspan="5" style="text-align:center;">No recent referrals to list.</td></tr>
                    <?php
    endif; ?>
                </tbody>
            </table>
        </div>
    </div>

</div>

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