Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	15.26 KB	-rw-r--r--	2025-10-18 22:42
dashboard.php	22.01 KB	-rw-r--r--	2025-10-18 22:49
deposit_history.php	4.14 KB	-rw-r--r--	2025-10-18 21:52
deposit_methods.php	11.74 KB	-rw-r--r--	2025-10-18 21:52
deposits.php	12.91 KB	-rw-r--r--	2025-10-18 21:52
dpin_details.php	4.52 KB	-rw-r--r--	2025-10-18 22:26
dpin_management.php	10.04 KB	-rw-r--r--	2025-10-18 21:52
dpin_send.php	6 KB	-rw-r--r--	2025-10-18 22:26
footer.php	148 B	-rw-r--r--	2025-10-18 21:50
header.php	8.2 KB	-rw-r--r--	2025-10-18 22:54
login.php	6.11 KB	-rw-r--r--	2025-10-18 21:41
logout.php	88 B	-rw-r--r--	2025-10-18 21:42
notifications.php	9.34 KB	-rw-r--r--	2025-10-18 21:54
plans.php	15.64 KB	-rw-r--r--	2025-10-18 22:42
referral.php	9.89 KB	-rw-r--r--	2025-10-18 21:52
sidebar.php	5.11 KB	-rw-r--r--	2025-10-18 21:50
transactions.php	4.47 KB	-rw-r--r--	2025-10-18 21:53
users.php	12.66 KB	-rw-r--r--	2025-10-18 22:42
withdraw_history.php	4.2 KB	-rw-r--r--	2025-10-18 21:53
withdraw_methods.php	11.89 KB	-rw-r--r--	2025-10-18 21:53
withdrawals.php	13.4 KB	-rw-r--r--	2025-10-18 21:53

Rename

<?php
require_once '../config.php';

// Check if admin is logged in
if (!isset($_SESSION['admin_id'])) {
    header("Location: login.php");
    exit();
}

// Get statistics
$total_users = 0;
$total_deposits = 0;
$total_withdrawals = 0;
$total_ads = 0;

// Get total users
$stmt = $conn->prepare("SELECT COUNT(*) as count FROM users");
$stmt->execute();
$result = $stmt->get_result();
$total_users = $result->fetch_assoc()['count'];

// Get total deposits (approved)
$stmt = $conn->prepare("SELECT SUM(amount) as total FROM deposits WHERE status = 'approved'");
$stmt->execute();
$result = $stmt->get_result();
$total_deposits = $result->fetch_assoc()['total'] ?? 0;

// Get total withdrawals (approved)
$stmt = $conn->prepare("SELECT SUM(amount) as total FROM withdrawals WHERE status = 'approved'");
$stmt->execute();
$result = $stmt->get_result();
$total_withdrawals = $result->fetch_assoc()['total'] ?? 0;

// Get total ads
$stmt = $conn->prepare("SELECT COUNT(*) as count FROM ads");
$stmt->execute();
$result = $stmt->get_result();
$total_ads = $result->fetch_assoc()['count'];

// Get recent transactions
$recent_transactions = [];
$stmt = $conn->prepare("SELECT t.*, u.name as user_name FROM transactions t JOIN users u ON t.user_id = u.id ORDER BY t.date DESC LIMIT 5");
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    $recent_transactions[] = $row;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin Dashboard - <?php echo $site_name; ?></title>
    
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
    
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    
    <style>
        :root {
            --primary-color: #6f42c1;
            --secondary-color: #00c9a7;
            --dark-bg: #121826;
            --sidebar-bg: #1a1f2d;
            --card-bg: rgba(255, 255, 255, 0.05);
            --text-light: rgba(255, 255, 255, 0.8);
        }
        
        body {
            background-color: var(--dark-bg);
            color: white;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
        }
        
        .sidebar {
            background: var(--sidebar-bg);
            height: 100vh;
            position: fixed;
            overflow-y: auto;
            box-shadow: 0 0 20px rgba(0, 0, 0, 0.3);
            z-index: 1000;
        }
        
        .main-content {
            margin-left: 250px;
            padding: 20px;
            min-height: 100vh;
        }
        
        .nav-link {
            color: var(--text-light);
            border-radius: 8px;
            margin: 5px 10px;
            transition: all 0.3s ease;
        }
        
        .nav-link:hover, .nav-link.active {
            background: linear-gradient(135deg, var(--primary-color), var(--secondary-color));
            color: white;
        }
        
        .card {
            background: var(--card-bg);
            border: 1px solid rgba(255, 255, 255, 0.1);
            border-radius: 15px;
            backdrop-filter: blur(10px);
            margin-bottom: 20px;
        }
        
        .card-header {
            background: rgba(255, 255, 255, 0.05);
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
            font-weight: 600;
        }
        
        .table {
            color: white;
        }
        
        .table th {
            border-top: none;
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
        }
        
        .table td {
            border-top: 1px solid rgba(255, 255, 255, 0.05);
        }
        
        .btn-primary {
            background: linear-gradient(135deg, var(--primary-color), var(--secondary-color));
            border: none;
            border-radius: 10px;
            font-weight: 600;
        }
        
        .btn-primary:hover {
            background: linear-gradient(135deg, var(--secondary-color), var(--primary-color));
        }
        
        .stat-card {
            text-align: center;
            padding: 20px;
            border-radius: 15px;
            margin-bottom: 20px;
            background: var(--card-bg);
            border: 1px solid rgba(255, 255, 255, 0.1);
        }
        
        .stat-card i {
            font-size: 2.5rem;
            margin-bottom: 15px;
        }
        
        .stat-card h3 {
            font-size: 1.8rem;
            margin-bottom: 5px;
            font-weight: 700;
        }
        
        .stat-card p {
            color: var(--text-light);
            margin-bottom: 0;
        }
        
        @media (max-width: 768px) {
            .sidebar {
                width: 100%;
                height: auto;
                position: relative;
            }
            
            .main-content {
                margin-left: 0;
            }
        }
    </style>
</head>
<body>
    <div class="container-fluid">
        <div class="row">
            
            <nav id="sidebar" class="col-md-3 col-lg-2 d-md-block sidebar collapse">
                <div class="position-sticky pt-3">
                    <div class="text-center mb-4">
                        <h4>Admin<span class="text-success">Panel</span></h4>
                        <p class="text-muted">Welcome, Admin!</p>
                    </div>
                    
                    <ul class="nav flex-column">
                        <li class="nav-item">
                            <a class="nav-link active" href="dashboard.php">
                                <i class="fas fa-home me-2"></i>Dashboard
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="users.php">
                                <i class="fas fa-users me-2"></i>All Users
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="plans.php">
                                <i class="fas fa-box me-2"></i>Membership Plans
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="referral.php">
                                <i class="fas fa-percentage me-2"></i>Referral Commission
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="deposit_methods.php">
                                <i class="fas fa-money-check me-2"></i>Deposit Methods
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="deposits.php">
                                <i class="fas fa-file-invoice-dollar me-2"></i>Deposit Management
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="deposit_history.php">
                                <i class="fas fa-history me-2"></i>Deposit History
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="dpin_send.php">
                                <i class="fas fa-key me-2"></i>D.Pin Send
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="dpin_management.php">
                                <i class="fas fa-cogs me-2"></i>D.Pin Management
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="dpin_details.php">
                                <i class="fas fa-info-circle me-2"></i>D.Pin Details
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="withdraw_methods.php">
                                <i class="fas fa-money-check-alt me-2"></i>Withdraw Methods
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="withdrawals.php">
                                <i class="fas fa-file-invoice-dollar me-2"></i>Withdrawal Management
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="withdraw_history.php">
                                <i class="fas fa-history me-2"></i>Withdrawal History
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="transactions.php">
                                <i class="fas fa-exchange-alt me-2"></i>Recent Transactions
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="ads.php">
                                <i class="fas fa-ad me-2"></i>Ads Management
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="notifications.php">
                                <i class="fas fa-bell me-2"></i>Notifications
                            </a>
                        </li>
                    </ul>
                    
                    <hr class="my-4">
                    
                    <ul class="nav flex-column">
                        <li class="nav-item">
                            <a class="nav-link" href="logout.php">
                                <i class="fas fa-sign-out-alt me-2"></i>Logout
                            </a>
                        </li>
                    </ul>
                </div>
            </nav>
            
            
            <main class="col-md-9 ms-sm-auto col-lg-10 main-content">
                <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">Dashboard</h1>
                    <div class="btn-toolbar mb-2 mb-md-0">
                        
                        <div class="mobile-menu-container">
                            <button class="mobile-menu-btn" id="mobileMenuBtn">
                                <i class="fas fa-bars"></i> Menu
                            </button>
                            <div class="mobile-dropdown-menu" id="mobileDropdownMenu">
                                <a href="dashboard.php"><i class="fas fa-home me-2"></i> Dashboard</a>
                                <a href="users.php"><i class="fas fa-users me-2"></i> All Users</a>
                                <a href="plans.php"><i class="fas fa-box me-2"></i> Membership Plans</a>
                                <a href="referral.php"><i class="fas fa-percentage me-2"></i> Referral Commission</a>
                                <a href="deposit_methods.php"><i class="fas fa-money-check me-2"></i> Deposit Methods</a>
                                <a href="deposits.php"><i class="fas fa-file-invoice-dollar me-2"></i> Deposit Management</a>
                                <a href="deposit_history.php"><i class="fas fa-history me-2"></i> Deposit History</a>
                                <a href="dpin_send.php"><i class="fas fa-key me-2"></i> D.Pin Send</a>
                                <a href="dpin_management.php"><i class="fas fa-cogs me-2"></i> D.Pin Management</a>
                                <a href="dpin_details.php"><i class="fas fa-info-circle me-2"></i> D.Pin Details</a>
                                <a href="withdraw_methods.php"><i class="fas fa-money-check-alt me-2"></i> Withdraw Methods</a>
                                <a href="withdrawals.php"><i class="fas fa-file-invoice-dollar me-2"></i> Withdrawal Management</a>
                                <a href="withdraw_history.php"><i class="fas fa-history me-2"></i> Withdrawal History</a>
                                <a href="transactions.php"><i class="fas fa-exchange-alt me-2"></i> Recent Transactions</a>
                                <a href="ads.php"><i class="fas fa-ad me-2"></i> Ads Management</a>
                                <a href="notifications.php"><i class="fas fa-bell me-2"></i> Notifications</a>
                                <a href="logout.php"><i class="fas fa-sign-out-alt me-2"></i> Logout</a>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-md-3">
                        <div class="stat-card">
                            <i class="fas fa-users text-primary"></i>
                            <h3><?php echo $total_users; ?></h3>
                            <p>Total Users</p>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="stat-card">
                            <i class="fas fa-money-bill-wave text-success"></i>
                            <h3><?php echo format_currency($total_deposits); ?></h3>
                            <p>Total Deposits</p>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="stat-card">
                            <i class="fas fa-money-check-alt text-info"></i>
                            <h3><?php echo format_currency($total_withdrawals); ?></h3>
                            <p>Total Withdrawals</p>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="stat-card">
                            <i class="fas fa-ad text-warning"></i>
                            <h3><?php echo $total_ads; ?></h3>
                            <p>Total Ads</p>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">Site Statistics</h5>
                            </div>
                            <div class="card-body">
                                <canvas id="statsChart" height="100"></canvas>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">User Growth</h5>
                            </div>
                            <div class="card-body">
                                <canvas id="growthChart" height="100"></canvas>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">Recent Transactions</h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-striped table-sm">
                                        <thead>
                                            <tr>
                                                <th>Date</th>
                                                <th>User</th>
                                                <th>Type</th>
                                                <th>Amount</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($recent_transactions as $transaction): ?>
                                            <tr>
                                                <td><?php echo date('M d, Y', strtotime($transaction['date'])); ?></td>
                                                <td><?php echo htmlspecialchars($transaction['user_name']); ?></td>
                                                <td><?php echo ucfirst(str_replace('_', ' ', $transaction['type'])); ?></td>
                                                <td><?php echo format_currency($transaction['amount']); ?></td>
                                                <td>
                                                    <span class="badge <?php 
                                                        echo $transaction['status'] == 'completed' ? 'bg-success' : 
                                                            ($transaction['status'] == 'pending' ? 'bg-warning' : 'bg-danger'); 
                                                    ?>">
                                                        <?php echo ucfirst($transaction['status']); ?>
                                                    </span>
                                                </td>
                                            </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </main>
        </div>
    </div>

// Growth Chart
    const growthCtx = document.getElementById('growthChart').getContext('2d');
    const growthChart = new Chart(growthCtx, {
        type: 'doughnut',
        data: {
            labels: ['New Users', 'Returning Users'],
            datasets: [{
                data: [75, 25],
                backgroundColor: [
                    '#6f42c1',
                    '#00c9a7'
                ],
                borderWidth: 0
            }]
        },
        options: {
            responsive: true,
            plugins: {
                legend: {
                    labels: {
                        color: 'rgba(255, 255, 255, 0.7)'
                    }
                }
            }
        }
    });

// Mobile Menu Toggle
    document.addEventListener('DOMContentLoaded', function() {
        const mobileMenuBtn = document.getElementById('mobileMenuBtn');
        const mobileDropdownMenu = document.getElementById('mobileDropdownMenu');
        
        if (mobileMenuBtn && mobileDropdownMenu) {
            mobileMenuBtn.addEventListener('click', function(e) {
                e.stopPropagation();
                mobileDropdownMenu.classList.toggle('show');
            });
            
            // Close dropdown when clicking outside
            document.addEventListener('click', function(e) {
                if (!mobileMenuBtn.contains(e.target) && !mobileDropdownMenu.contains(e.target)) {
                    mobileDropdownMenu.classList.remove('show');
                }
            });
        }
    });
    </script>

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