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

// Get user statistics
try {
    // Total Earnings
    $stmt = $pdo->prepare("SELECT SUM(amount) as total FROM transactions WHERE user_id = ? AND type IN ('ad', 'commission')");
    $stmt->execute([$_SESSION['user_id']]);
    $total_earnings = $stmt->fetch()['total'] ?? 0;
    
    // Today's Earnings
    $stmt = $pdo->prepare("SELECT SUM(amount) as today FROM transactions WHERE user_id = ? AND type IN ('ad', 'commission') AND DATE(created_at) = CURDATE()");
    $stmt->execute([$_SESSION['user_id']]);
    $today_earnings = $stmt->fetch()['today'] ?? 0;
    
    // Monthly Earnings
    $stmt = $pdo->prepare("SELECT SUM(amount) as monthly FROM transactions WHERE user_id = ? AND type IN ('ad', 'commission') AND MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE())");
    $stmt->execute([$_SESSION['user_id']]);
    $monthly_earnings = $stmt->fetch()['monthly'] ?? 0;
    
    // Total Withdrawn
    $stmt = $pdo->prepare("SELECT SUM(amount) as withdrawn FROM transactions WHERE user_id = ? AND type = 'withdraw'");
    $stmt->execute([$_SESSION['user_id']]);
    $total_withdrawn = $stmt->fetch()['withdrawn'] ?? 0;
    
    // Total Referral Commissions
    $stmt = $pdo->prepare("SELECT SUM(amount) as commissions FROM transactions WHERE user_id = ? AND type = 'commission'");
    $stmt->execute([$_SESSION['user_id']]);
    $total_commissions = $stmt->fetch()['commissions'] ?? 0;
    
    // Remaining Tasks (assuming 10 tasks per day as default)
    $daily_limit = 10;
    $stmt = $pdo->prepare("SELECT COUNT(*) as completed FROM transactions WHERE user_id = ? AND type = 'ad' AND DATE(created_at) = CURDATE()");
    $stmt->execute([$_SESSION['user_id']]);
    $completed_today = $stmt->fetch()['completed'] ?? 0;
    $remaining_tasks = max(0, $daily_limit - $completed_today);
    
    // Check if user has an active plan
    $has_active_plan = false;
    if ($user['current_plan']) {
        // Check if plan is still active
        $stmt = $pdo->prepare("SELECT * FROM plans WHERE id = ?");
        $stmt->execute([$user['current_plan']]);
        $plan = $stmt->fetch();
        if ($plan) {
            $has_active_plan = true;
        }
    }
} catch (PDOException $e) {
    die("Error fetching dashboard data: " . $e->getMessage());
}
?>

<div class="user-dashboard-header">
    <div class="row align-items-center">
        <div class="col-md-8">
            <h1 class="h2 mb-0">Welcome back, <?php echo htmlspecialchars($user['fullname']); ?>!</h1>
            <p class="mb-0">Here's what's happening with your account today</p>
        </div>
        <div class="col-md-4 text-end">
            <div class="btn-group">
                <a href="deposit.php" class="btn btn-light">Deposit Funds</a>
                <a href="membership.php" class="btn btn-light">Buy Plan</a>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xl-3 col-md-6 mb-4">
        <div class="user-stat-card">
            <div class="card-body text-center">
                <div class="user-stat-icon bg-primary">
                    <i class="fas fa-wallet"></i>
                </div>
                <div class="user-stat-value">₨<?php echo number_format($total_earnings, 2); ?></div>
                <div class="user-stat-label">Total Earnings</div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-4">
        <div class="user-stat-card">
            <div class="card-body text-center">
                <div class="user-stat-icon bg-success">
                    <i class="fas fa-coins"></i>
                </div>
                <div class="user-stat-value">₨<?php echo number_format($today_earnings, 2); ?></div>
                <div class="user-stat-label">Today's Earnings</div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-4">
        <div class="user-stat-card">
            <div class="card-body text-center">
                <div class="user-stat-icon bg-warning">
                    <i class="fas fa-tasks"></i>
                </div>
                <div class="user-stat-value"><?php echo $remaining_tasks; ?></div>
                <div class="user-stat-label">Remaining Tasks</div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6 mb-4">
        <div class="user-stat-card">
            <div class="card-body text-center">
                <div class="user-stat-icon bg-info">
                    <i class="fas fa-calendar-alt"></i>
                </div>
                <div class="user-stat-value">₨<?php echo number_format($monthly_earnings, 2); ?></div>
                <div class="user-stat-label">Monthly Earnings</div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-lg-6 mb-4">
        <div class="card user-stat-card">
            <div class="card-header">
                <h5 class="mb-0"><i class="fas fa-user-circle me-2"></i>Account Summary</h5>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-md-6 mb-3">
                        <div class="user-stat-label">Account Balance</div>
                        <div class="user-stat-value text-primary">₨<?php echo number_format($user['balance'], 2); ?></div>
                    </div>
                    <div class="col-md-6 mb-3">
                        <div class="user-stat-label">Total Withdrawn</div>
                        <div class="user-stat-value text-warning">₨<?php echo number_format($total_withdrawn, 2); ?></div>
                    </div>
                    <div class="col-md-6 mb-3">
                        <div class="user-stat-label">Referral Commissions</div>
                        <div class="user-stat-value text-success">₨<?php echo number_format($total_commissions, 2); ?></div>
                    </div>
                    <div class="col-md-6 mb-3">
                        <div class="user-stat-label">Plan Status</div>
                        <div>
                            <?php if ($has_active_plan): ?>
                                <span class="badge bg-success"><i class="fas fa-check-circle me-1"></i> Active</span>
                                <?php if ($plan): ?>
                                    <div class="mt-2 small text-muted"><?php echo htmlspecialchars($plan['name']); ?></div>
                                <?php endif; ?>
                            <?php else: ?>
                                <span class="badge bg-danger"><i class="fas fa-exclamation-circle me-1"></i> Expired</span>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
                <div class="mt-3">
                    <?php if (!$has_active_plan): ?>
                        <a href="membership.php" class="btn btn-primary me-2">Buy Plan with Balance</a>
                        <a href="deposit.php" class="btn btn-outline-primary">Deposit Funds</a>
                    <?php else: ?>
                        <a href="membership.php" class="btn btn-outline-primary">View Plans</a>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
    <div class="col-lg-6 mb-4">
        <div class="card user-stat-card">
            <div class="card-header">
                <h5 class="mb-0"><i class="fas fa-exchange-alt me-2"></i>Recent Transactions</h5>
            </div>
            <div class="card-body">
                <?php
                try {
                    $stmt = $pdo->prepare("SELECT * FROM transactions WHERE user_id = ? ORDER BY created_at DESC LIMIT 5");
                    $stmt->execute([$_SESSION['user_id']]);
                    $transactions = $stmt->fetchAll();
                } catch (PDOException $e) {
                    $transactions = [];
                }
                ?>
                <?php if (count($transactions) > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-hover">
                            <thead>
                                <tr>
                                    <th>Type</th>
                                    <th>Amount</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($transactions as $transaction): ?>
                                    <tr>
                                        <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;
                                            }
                                            ?>
                                        </td>
                                        <td class="fw-bold">₨<?php echo number_format($transaction['amount'], 2); ?></td>
                                        <td><?php echo date('M d, Y', 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'; ?>