Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
contact.php	9.39 KB	-rw-r--r--	2026-03-01 23:09
dashboard.php	12.62 KB	-rw-r--r--	2026-03-01 23:07
login.php	3.36 KB	-rw-r--r--	2026-03-01 20:35
logout.php	90 B	-rw-r--r--	2026-03-01 20:36
orders.php	24.63 KB	-rw-r--r--	2026-03-01 23:09
payment_methods.php	16.54 KB	-rw-r--r--	2026-03-01 23:03
save_contact.php	1.4 KB	-rw-r--r--	2026-03-01 20:30
services.php	15.75 KB	-rw-r--r--	2026-03-01 23:05
settings.php	6.88 KB	-rw-r--r--	2026-03-01 23:10
users.php	7.52 KB	-rw-r--r--	2026-03-01 23:08
verify_payment.php	13.79 KB	-rw-r--r--	2026-03-01 23: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
include '../includes/db.php';
session_start();

// Auth Check
if (!isset($_SESSION['admin_id'])) {
    header('Location: login.php');
    exit;
}

// Stats & Insights
try {
    $total_users = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn();
    $live_services = $pdo->query("SELECT COUNT(*) FROM services WHERE status = 'Active'")->fetchColumn();
    $pending_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE order_status < 8")->fetchColumn();
    $total_revenue = $pdo->query("SELECT SUM(s.price) FROM orders o JOIN services s ON o.service_id = s.id WHERE o.payment_status = 'Paid'")->fetchColumn() ?: 0;

$stats = [
        'total_users' => $total_users,
        'live_services' => $live_services,
        'pending_orders' => $pending_orders,
        'revenue' => number_format($total_revenue, 2)
    ];

// Recent Pipeline Update
    $stmt = $pdo->query("
        SELECT o.*, u.name as client_name, s.name as service_name 
        FROM orders o 
        JOIN users u ON o.user_id = u.id 
        JOIN services s ON o.service_id = s.id 
        ORDER BY o.ordered_at DESC LIMIT 6
    ");
    $recent_orders = $stmt->fetchAll();

}
catch (Exception $e) {
    $stats = ['total_users' => 0, 'live_services' => 0, 'pending_orders' => 0, 'revenue' => '0.00'];
    $recent_orders = [];
}

$sidebar_links = [
    ['name' => 'Dashboard', 'icon' => 'fas fa-chart-line', 'active' => true, 'url' => 'dashboard.php'],
    ['name' => 'Users', 'icon' => 'fas fa-users', 'active' => false, 'url' => 'users.php'],
    ['name' => 'Services', 'icon' => 'fas fa-layer-group', 'active' => false, 'url' => 'services.php'],
    ['name' => 'Orders', 'icon' => 'fas fa-shopping-cart', 'active' => false, 'url' => 'orders.php'],
    ['name' => 'Payment Setup', 'icon' => 'fas fa-credit-card', 'active' => false, 'url' => 'payment_methods.php'],
    ['name' => 'Contact Details', 'icon' => 'fas fa-address-book', 'active' => false, 'url' => 'contact.php'],
    ['name' => 'Admin Details', 'icon' => 'fas fa-user-shield', 'active' => false, 'url' => 'settings.php'],
];
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Enterprise Analytics | CodeBySycho Admin</title>
    <link rel="stylesheet" href="../assets/css/style.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        :root { --sidebar-width: 300px; --accent-soft: rgba(34, 197, 94, 0.1); }
        body { background: #fdfdfd; overflow: hidden; color: #0f172a; font-family: 'Inter', sans-serif; }
        .sidebar { width: var(--sidebar-width); height: 100vh; background: #ffffff; border-right: 1px solid rgba(0,0,0,0.05); position: fixed; left: 0; top: 0; padding: 3.5rem 2rem; display: flex; flex-direction: column; }
        .main-content { margin-left: var(--sidebar-width); height: 100vh; padding: 4rem 5rem; overflow-y: auto; }
        .sidebar-link { display: flex; align-items: center; gap: 1.2rem; padding: 1.2rem 1.6rem; border-radius: 16px; color: #64748b; margin-bottom: 0.6rem; font-weight: 700; text-decoration: none; transition: 0.3s; font-size: 0.95rem; }
        .sidebar-link:hover, .sidebar-link.active { color: var(--primary); background: var(--accent-soft); }
        .sidebar-link i { font-size: 1.1rem; }
        
        .stat-grid { display: grid; grid-template-columns: repeat(4, 1fr); gap: 2.5rem; margin-bottom: 4rem; }
        .stat-card { background: #fff; padding: 3rem 2.5rem; border-radius: 35px; border: 1px solid rgba(0,0,0,0.05); box-shadow: 0 15px 40px rgba(0,0,0,0.02); position: relative; overflow: hidden; transition: 0.4s; }
        .stat-card:hover { transform: translateY(-10px); box-shadow: 0 25px 50px rgba(0,0,0,0.06); }
        .stat-card h4 { color: #64748b; font-size: 0.8rem; font-weight: 800; text-transform: uppercase; letter-spacing: 1.5px; margin-bottom: 1.2rem; }
        .stat-card .value { font-size: 2.4rem; font-weight: 900; color: #0f172a; letter-spacing: -1px; }
        .stat-card .icon-blob { position: absolute; right: -20px; top: -20px; width: 120px; height: 120px; background: var(--accent-soft); border-radius: 50%; display: flex; align-items: center; justify-content: center; opacity: 0.4; }
        .stat-card .icon-blob i { font-size: 2.5rem; color: var(--primary); margin-right: 15px; margin-top: 15px; }

.dashboard-section { background: #fff; padding: 4rem; border-radius: 40px; border: 1px solid rgba(0,0,0,0.05); box-shadow: 0 20px 60px rgba(0,0,0,0.03); }
        table { width: 100%; border-collapse: collapse; }
        th { text-align: left; padding: 1.5rem; color: #64748b; font-size: 0.75rem; font-weight: 800; border-bottom: 2px solid #f1f5f9; text-transform: uppercase; letter-spacing: 1px; }
        td { padding: 1.8rem 1.5rem; border-bottom: 1px solid #f8fafc; font-weight: 600; font-size: 0.95rem; }
        .status-pill { padding: 0.5rem 1.2rem; border-radius: 25px; font-size: 0.72rem; font-weight: 800; letter-spacing: 0.5px; }
    </style>
</head>
<body>

<div class="mobile-admin-header">
        <a href="dashboard.php" class="logo" style="font-size: 1.4rem; text-decoration:none; color:#0f172a;">CodeBy<span style="color: var(--primary);">Sycho</span></a>
        <div class="mobile-toggle" onclick="toggleSidebar()">
            <span></span>
            <span></span>
            <span></span>
        </div>
    </div>

<div class="sidebar-overlay" id="sidebarOverlay" onclick="toggleSidebar()"></div>

<aside class="sidebar" id="adminSidebar">
        <div class="mobile-only" style="text-align: right; padding: 0 1rem 2rem 0;">
            <button onclick="toggleSidebar()" style="background:none; border:none; font-size: 1.5rem; color: #64748b;"><i class="fas fa-times"></i></button>
        </div>
        <a href="dashboard.php" class="logo" style="margin-bottom: 5rem; display: block; font-size: 2rem; text-decoration:none; color:#0f172a;">CodeBy<span style="color: var(--primary);">Sycho</span></a>
        <div style="flex-grow: 1;">
            <?php foreach ($sidebar_links as $link): ?>
                <a href="<?php echo $link['url']; ?>" class="sidebar-link <?php echo $link['active'] ? 'active' : ''; ?>">
                    <i class="<?php echo $link['icon']; ?>"></i> <?php echo $link['name']; ?>
                </a>
            <?php
endforeach; ?>
        </div>
        <div style="border-top: 1px solid #f1f5f9; padding-top: 2.5rem;">
            <p style="font-size: 0.85rem; color: #64748b; margin-bottom: 1.5rem;">Connectivity: <span style="color: var(--primary); font-weight:800;">Secured</span></p>
            <a href="logout.php" style="color: #ef4444; font-weight: 800; text-decoration: none; display: flex; align-items: center; gap: 1rem;"><i class="fas fa-power-off"></i> Terminate Session</a>
        </div>
    </aside>

<main class="main-content">
        <div style="margin-bottom: 3.5rem;">
            <p style="font-size: 0.75rem; font-weight: 800; color: var(--primary); text-transform: uppercase; letter-spacing: 2px; margin-bottom: 0.5rem;">Admin Overview</p>
            <h1 style="font-size: 1.8rem; font-weight: 800; color: #0f172a; letter-spacing: -0.5px;">Command Center</h1>
        </div>

<div class="stat-grid">
            <div class="stat-card admin-card">
                <h4>Total Users</h4>
                <div class="value"><?php echo number_format($stats['total_users']); ?></div>
                <div class="icon-blob"><i class="fas fa-user-friends"></i></div>
            </div>
            <div class="stat-card admin-card">
                <h4>Gross Revenue</h4>
                <div class="value">$<?php echo $stats['revenue']; ?></div>
                <div class="icon-blob"><i class="fas fa-wallet"></i></div>
            </div>
            <div class="stat-card admin-card">
                <h4>Pipeline Orders</h4>
                <div class="value"><?php echo $stats['pending_orders']; ?></div>
                <div class="icon-blob"><i class="fas fa-shopping-bag"></i></div>
            </div>
            <div class="stat-card admin-card">
                <h4>Live Catalog</h4>
                <div class="value"><?php echo $stats['live_services']; ?></div>
                <div class="icon-blob"><i class="fas fa-cubes"></i></div>
            </div>
        </div>

<div class="dashboard-section admin-card" style="padding: 3rem !important;">
            <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 2.5rem; flex-wrap: wrap; gap: 1rem;">
                <h3 style="font-size: 1.4rem; font-weight: 800; color: var(--text-main);">Live Project Pulse</h3>
                <a href="orders.php" style="color: var(--primary); font-weight: 800; font-size: 0.9rem; text-decoration: none; background: var(--primary-light); padding: 0.5rem 1rem; border-radius: 10px;">Pipeline <i class="fas fa-arrow-right" style="margin-left: 0.5rem;"></i></a>
            </div>

<table class="desktop-only-table">
                <thead>
                    <tr>
                        <th style="padding-left: 0;">Order ID</th>
                        <th>Stakeholder</th>
                        <th>Project Focus</th>
                        <th>Fiscal Status</th>
                        <th>Workflow</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if (empty($recent_orders)): ?>
                        <tr><td colspan="5" style="text-align: center; color: #94a3b8; padding: 4rem;">No active project pulse detected.</td></tr>
                    <?php
endif; ?>
                    <?php foreach ($recent_orders as $o): ?>
                        <tr>
                            <td style="padding-left: 0; color: var(--primary); font-weight: 800;">#CS-<?php echo str_pad($o['id'], 4, '0', STR_PAD_LEFT); ?></td>
                            <td><?php echo htmlspecialchars($o['client_name']); ?></td>
                            <td><?php echo htmlspecialchars($o['service_name']); ?></td>
                            <td>
                                <span class="status-pill" style="background: <?php echo $o['payment_status'] == 'Paid' ? '#dcfce7' : '#fee2e2'; ?>; color: <?php echo $o['payment_status'] == 'Paid' ? '#166534' : '#991b1b'; ?>;">
                                    <?php echo $o['payment_status']; ?>
                                </span>
                            </td>
                            <td style="font-weight: 700; color: #64748b;">Stage <?php echo $o['order_status']; ?></td>
                        </tr>
                    <?php
endforeach; ?>
                </tbody>
            </table>

<div class="mobile-only-list">
                <?php foreach ($recent_orders as $o): ?>
                    <div style="background: #f8fafc; border-radius: 20px; padding: 1.2rem; margin-bottom: 1rem; border: 1px solid #f1f5f9;">
                        <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 0.8rem;">
                            <span style="color: var(--primary); font-weight: 800; font-size: 0.85rem;">#CS-<?php echo str_pad($o['id'], 4, '0', STR_PAD_LEFT); ?></span>
                            <span class="status-pill" style="margin: 0; background: <?php echo $o['payment_status'] == 'Paid' ? '#dcfce7' : '#fee2e2'; ?>; color: <?php echo $o['payment_status'] == 'Paid' ? '#166534' : '#991b1b'; ?>;">
                                <?php echo $o['payment_status']; ?>
                            </span>
                        </div>
                        <h4 style="margin: 0 0 0.4rem 0; font-size: 1rem; color: var(--text-main);"><?php echo htmlspecialchars($o['client_name']); ?></h4>
                        <div style="display: flex; justify-content: space-between; align-items: center; font-size: 0.85rem; color: #64748b;">
                            <span><?php echo htmlspecialchars($o['service_name']); ?></span>
                            <span style="font-weight: 700;">Stage <?php echo $o['order_status']; ?></span>
                        </div>
                    </div>
                <?php
endforeach; ?>
            </div>
        </div>
    </main>

</body>
</html>