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';

// Quick stats queries
$stats = [];
$stats['active_users'] = $pdo->query("SELECT COUNT(*) FROM users WHERE status = 'active' AND role != 'admin'")->fetchColumn();
$stats['inactive_users'] = $pdo->query("SELECT COUNT(*) FROM users WHERE status = 'inactive' AND role != 'admin'")->fetchColumn();
$stats['total_withdrawn'] = $pdo->query("SELECT SUM(amount) FROM withdrawals WHERE status = 'approved'")->fetchColumn() ?: 0.00;
$stats['pending_withdrawals'] = $pdo->query("SELECT COUNT(*) FROM withdrawals WHERE status = 'pending'")->fetchColumn();
$stats['active_plans'] = $pdo->query("SELECT COUNT(*) FROM plans")->fetchColumn();
$stats['total_income'] = $pdo->query("SELECT SUM(amount) FROM transactions WHERE type = 'plan_purchase'")->fetchColumn() ?: 0.00;
$stats['pending_deposits'] = $pdo->query("SELECT COUNT(*) FROM deposits WHERE status = 'pending'")->fetchColumn();
$stats['pending_assignments'] = $pdo->query("SELECT COUNT(*) FROM assignment_submissions WHERE status = 'pending'")->fetchColumn();
?>

<?php
// Enforce Pakistan Timezone
date_default_timezone_set('Asia/Karachi');
$hour = date('H');
if ($hour >= 5 && $hour < 12) {
    $greeting = "Good Morning";
} elseif ($hour >= 12 && $hour < 17) {
    $greeting = "Good Afternoon";
} elseif ($hour >= 17 && $hour < 21) {
    $greeting = "Good Evening";
} else {
    $greeting = "Good Night";
}
?>

<h3 style="margin-bottom:30px; font-weight: 700; font-size: 1.5rem;"><?php echo $greeting; ?>, <span style="color:var(--primary-color);">Administrator</span> 👋</h3>

<div class="stat-grid">
    <div class="stat-card">
        <div class="stat-title">Total Active Users</div>
        <div class="stat-value"><?php echo $stats['active_users']; ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #f39c12;">
        <div class="stat-title">Inactive Users</div>
        <div class="stat-value"><?php echo $stats['inactive_users']; ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #27ae60;">
        <div class="stat-title">Total Income</div>
        <div class="stat-value">Rs <?php echo number_format($stats['total_income'], 2); ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #e74c3c;">
        <div class="stat-title">Pending Deposits</div>
        <div class="stat-value"><?php echo $stats['pending_deposits']; ?></div>
    </div>
</div>

<div class="stat-grid">
    <div class="stat-card" style="border-left-color: #3498db;">
        <div class="stat-title">Total Withdrawn</div>
        <div class="stat-value">Rs <?php echo number_format($stats['total_withdrawn'], 2); ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #9b59b6;">
        <div class="stat-title">Pending Withdrawals</div>
        <div class="stat-value"><?php echo $stats['pending_withdrawals']; ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #1abc9c;">
        <div class="stat-title">Active Plans</div>
        <div class="stat-value"><?php echo $stats['active_plans']; ?></div>
    </div>
    <div class="stat-card" style="border-left-color: #e67e22;">
        <div class="stat-title">Pending Assignments</div>
        <div class="stat-value"><?php echo $stats['pending_assignments']; ?></div>
    </div>
</div>

<div class="grid" style="grid-template-columns: 1fr 1fr;">
    <div class="card" style="text-align:left;">
        <h3 style="margin-bottom:20px;">Quick Actions</h3>
        <div style="display:flex; flex-direction:column; gap:10px;">
            <a href="deposits.php" class="btn-primary">Review Pending Deposits</a>
            <a href="assignments.php" class="btn-outline">Review Assignment Submissions</a>
            <a href="withdrawals.php" class="btn-outline">Process Pending Withdrawals</a>
        </div>
    </div>
</div>

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