Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	4.94 KB	-rw-r--r--	2025-10-17 23:43
dashboard.php	10.78 KB	-rw-r--r--	2025-10-18 00:40
deposit.php	6.02 KB	-rw-r--r--	2025-10-17 23:02
deposit_history.php	3.23 KB	-rw-r--r--	2025-10-17 23:03
dpin.php	5.9 KB	-rw-r--r--	2025-10-17 23:03
footer.php	565 B	-rw-r--r--	2025-10-17 23:02
header.php	12.32 KB	-rw-r--r--	2025-10-18 02:06
invite.php	3.53 KB	-rw-r--r--	2025-10-18 00:19
membership.php	11.7 KB	-rw-r--r--	2025-10-18 00:56
profile.php	5.27 KB	-rw-r--r--	2025-10-17 23:04
team.php	5.26 KB	-rw-r--r--	2025-10-17 23:50
transactions.php	3.85 KB	-rw-r--r--	2025-10-17 23:04
withdraw.php	6.19 KB	-rw-r--r--	2025-10-17 23:03

Rename

<?php
$title = 'Team Users';
include 'header.php';

// Get team statistics
try {
    // Total team members
    $stmt = $pdo->prepare("SELECT COUNT(*) as total FROM users WHERE referred_by = ?");
    $stmt->execute([$_SESSION['user_id']]);
    $total_members = $stmt->fetch()['total'] ?? 0;
    
    // Team members with active plans
    $stmt = $pdo->prepare("SELECT COUNT(*) as active FROM users u JOIN plans p ON u.current_plan = p.id WHERE u.referred_by = ?");
    $stmt->execute([$_SESSION['user_id']]);
    $active_members = $stmt->fetch()['active'] ?? 0;
    
    // Total commission earned from team
    $stmt = $pdo->prepare("SELECT SUM(commission_amount) as total_commission FROM referrals WHERE user_id = ?");
    $stmt->execute([$_SESSION['user_id']]);
    $total_commission = $stmt->fetch()['total_commission'] ?? 0;
    
    // Get team members with their commission contributions
    $stmt = $pdo->prepare("SELECT u.*, p.name as plan_name, COALESCE(SUM(r.commission_amount), 0) as commission_earned FROM users u LEFT JOIN plans p ON u.current_plan = p.id LEFT JOIN referrals r ON r.referred_user_id = u.id AND r.user_id = ? WHERE u.referred_by = ? GROUP BY u.id ORDER BY u.joined_at DESC");
    $stmt->execute([$_SESSION['user_id'], $_SESSION['user_id']]);
    $team_members = $stmt->fetchAll();
} catch (PDOException $e) {
    $total_members = 0;
    $active_members = 0;
    $total_commission = 0;
    $team_members = [];
}
?>

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

<div class="row">
    <div class="col-md-3 mb-4">
        <div class="card text-white bg-primary">
            <div class="card-body">
                <h5 class="card-title">Total Members</h5>
                <h3><?php echo $total_members; ?></h3>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-4">
        <div class="card text-white bg-success">
            <div class="card-body">
                <h5 class="card-title">Active Members</h5>
                <h3><?php echo $active_members; ?></h3>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-4">
        <div class="card text-white bg-warning">
            <div class="card-body">
                <h5 class="card-title">Commission Earned</h5>
                <h3>₨<?php echo number_format($total_commission, 2); ?></h3>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-4">
        <div class="card text-white bg-info">
            <div class="card-body">
                <h5 class="card-title">Levels</h5>
                <h3>3</h3>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Team Members</h5>
                <?php if (count($team_members) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Phone</th>
                                    <th>Plan</th>
                                    <th>Commission Earned</th>
                                    <th>Joined Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($team_members as $member): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($member['fullname']); ?></td>
                                        <td><?php echo htmlspecialchars($member['email']); ?></td>
                                        <td><?php echo htmlspecialchars($member['phone']); ?></td>
                                        <td>
                                            <?php if ($member['plan_name']): ?>
                                                <span class="badge bg-success"><?php echo htmlspecialchars($member['plan_name']); ?></span>
                                            <?php else: ?>
                                                <span class="badge bg-secondary">No Plan</span>
                                            <?php endif; ?>
                                        </td>
                                        <td>₨<?php echo number_format($member['commission_earned'], 2); ?></td>
                                        <td><?php echo date('M d, Y', strtotime($member['joined_at'])); ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <p>You don't have any team members yet. Share your referral link to start building your team!</p>
                    <a href="invite.php" class="btn btn-primary">Invite Friends</a>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

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