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

// Get statistics
try {
    // Total Users
    $stmt = $pdo->prepare("SELECT COUNT(*) as total FROM users");
    $stmt->execute();
    $total_users = $stmt->fetch()['total'] ?? 0;
    
    // Active Users (users with active plans)
    $stmt = $pdo->prepare("SELECT COUNT(*) as active FROM users u JOIN plans p ON u.current_plan = p.id");
    $stmt->execute();
    $active_users = $stmt->fetch()['active'] ?? 0;
    
    // Total Deposits
    $stmt = $pdo->prepare("SELECT SUM(amount) as total FROM deposits WHERE status = 'approved'");
    $stmt->execute();
    $total_deposits = $stmt->fetch()['total'] ?? 0;
    
    // Total Withdrawals
    $stmt = $pdo->prepare("SELECT SUM(amount) as total FROM withdraws WHERE status = 'approved'");
    $stmt->execute();
    $total_withdrawals = $stmt->fetch()['total'] ?? 0;
    
    // Total Ads
    $stmt = $pdo->prepare("SELECT COUNT(*) as total FROM ads");
    $stmt->execute();
    $total_ads = $stmt->fetch()['total'] ?? 0;
    
    // Total Earnings (sum of all ad rewards and commissions)
    $stmt = $pdo->prepare("SELECT SUM(amount) as total FROM transactions WHERE type IN ('ad', 'commission')");
    $stmt->execute();
    $total_earnings = $stmt->fetch()['total'] ?? 0;
    
    // Recent Transactions
    $stmt = $pdo->prepare("SELECT t.*, u.fullname FROM transactions t JOIN users u ON t.user_id = u.id ORDER BY t.created_at DESC LIMIT 10");
    $stmt->execute();
    $recent_transactions = $stmt->fetchAll();
} catch (PDOException $e) {
    die("Error fetching dashboard data: " . $e->getMessage());
}
?>

<div class="admin-dashboard-header">
    <div class="row align-items-center">
        <div class="col-md-8">
            <h1 class="h2 mb-0">Admin Dashboard</h1>
            <p class="mb-0">Welcome back, Administrator! Here's what's happening today</p>
        </div>
        <div class="col-md-4 text-end">
            <div class="btn-group">
                <a href="users.php" class="btn btn-light">Manage Users</a>
                <a href="deposits.php" class="btn btn-light">View Deposits</a>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-primary">
                    <i class="fas fa-users"></i>
                </div>
                <div class="admin-stat-value"><?php echo number_format($total_users); ?></div>
                <div class="admin-stat-label">Total Users</div>
            </div>
        </div>
    </div>
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-success">
                    <i class="fas fa-user-check"></i>
                </div>
                <div class="admin-stat-value"><?php echo number_format($active_users); ?></div>
                <div class="admin-stat-label">Active Users</div>
            </div>
        </div>
    </div>
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-info">
                    <i class="fas fa-arrow-down"></i>
                </div>
                <div class="admin-stat-value">₨<?php echo number_format($total_deposits, 2); ?></div>
                <div class="admin-stat-label">Total Deposits</div>
            </div>
        </div>
    </div>
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-warning">
                    <i class="fas fa-arrow-up"></i>
                </div>
                <div class="admin-stat-value">₨<?php echo number_format($total_withdrawals, 2); ?></div>
                <div class="admin-stat-label">Total Withdrawals</div>
            </div>
        </div>
    </div>
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-danger">
                    <i class="fas fa-ad"></i>
                </div>
                <div class="admin-stat-value"><?php echo number_format($total_ads); ?></div>
                <div class="admin-stat-label">Total Ads</div>
            </div>
        </div>
    </div>
    <div class="col-xl-2 col-lg-4 col-md-6 mb-4">
        <div class="admin-stat-card">
            <div class="card-body text-center">
                <div class="admin-stat-icon bg-secondary">
                    <i class="fas fa-chart-line"></i>
                </div>
                <div class="admin-stat-value">₨<?php echo number_format($total_earnings, 2); ?></div>
                <div class="admin-stat-label">Total Earnings</div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="admin-table">
            <div class="admin-table-header">
                <h5 class="mb-0"><i class="fas fa-exchange-alt me-2"></i>Recent Transactions</h5>
            </div>
            <div class="card-body">
                <?php if (count($recent_transactions) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-hover">
                            <thead>
                                <tr>
                                    <th>User</th>
                                    <th>Type</th>
                                    <th>Amount</th>
                                    <th>Note</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($recent_transactions as $transaction): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($transaction['fullname']); ?></td>
                                        <td>
                                            <?php
                                            switch ($transaction['type']) {
                                                case 'deposit':
                                                    echo '<span class="badge bg-info"><i class="fas fa-arrow-down me-1"></i> Deposit</span>';
                                                    break;
                                                case 'withdraw':
                                                    echo '<span class="badge bg-warning"><i class="fas fa-arrow-up me-1"></i> Withdraw</span>';
                                                    break;
                                                case 'commission':
                                                    echo '<span class="badge bg-success"><i class="fas fa-percentage me-1"></i> Commission</span>';
                                                    break;
                                                case 'ad':
                                                    echo '<span class="badge bg-primary"><i class="fas fa-ad me-1"></i> Ad Reward</span>';
                                                    break;
                                                default:
                                                    echo '<span class="badge bg-secondary"><i class="fas fa-question-circle me-1"></i> ' . ucfirst($transaction['type']) . '</span>';
                                            }
                                            ?>
                                        </td>
                                        <td class="fw-bold">₨<?php echo number_format($transaction['amount'], 2); ?></td>
                                        <td><?php echo htmlspecialchars($transaction['note'] ?? '-'); ?></td>
                                        <td><?php echo date('M d, Y H:i', strtotime($transaction['created_at'])); ?></td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <div class="text-center py-5">
                        <i class="fas fa-exchange-alt fa-3x text-muted mb-3"></i>
                        <p class="text-muted mb-0">No recent transactions found</p>
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

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