Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
ads.php	10.11 KB	-rw-r--r--	2025-12-22 20:20
announcements.php	8.13 KB	-rw-r--r--	2025-12-25 17:46
banners.php	9.86 KB	-rw-r--r--	2025-12-22 19:19
boosts.php	5.51 KB	-rw-r--r--	2025-12-24 21:41
daily_targets.php	11.29 KB	-rw-r--r--	2025-12-26 07:59
dashboard.php	9.23 KB	-rw-r--r--	2025-12-25 12:46
deposits.php	13.59 KB	-rw-r--r--	2026-01-26 16:58
dpin_requests.php	7.43 KB	-rw-r--r--	2025-12-24 21:41
dpins.php	9.37 KB	-rw-r--r--	2025-12-23 19:48
error_log	1.14 KB	-rw-r--r--	2026-01-07 16:39
footer.php	122 B	-rw-r--r--	2025-12-25 18:15
header.php	6.83 KB	-rw-r--r--	2026-01-26 17:15
login.php	4.42 KB	-rw-r--r--	2026-01-26 17:46
lucky_wheel.php	24.12 KB	-rw-r--r--	2026-01-26 16:57
orders.php	12.63 KB	-rw-r--r--	2026-01-07 16:27
payment_methods.php	6.53 KB	-rw-r--r--	2025-12-23 19:24
plans.php	22.86 KB	-rw-r--r--	2025-12-29 11:03
products.php	10.72 KB	-rw-r--r--	2026-01-07 16:15
ranks.php	7.31 KB	-rw-r--r--	2025-12-25 16:48
referrals.php	8.7 KB	-rw-r--r--	2025-12-25 12:43
return.php	440 B	-rw-r--r--	2025-12-29 13:55
settings.php	10.77 KB	-rw-r--r--	2026-01-07 16:26
tickets.php	11.98 KB	-rw-r--r--	2025-12-22 19:21
users.php	18.1 KB	-rw-r--r--	2025-12-29 13:53
withdraws.php	11.42 KB	-rw-r--r--	2025-12-24 22:29
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
define('ADMIN_PANEL', true);
require_once '../includes/config.php';
requireAdmin();

$page_title = 'Manage Product Orders';

// Handle order updates
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'];
    $orderId = intval($_POST['order_id']);

try {
        if ($action === 'update_status') {
            $status = $_POST['status'];
            $stmt = $pdo->prepare("UPDATE product_orders SET order_status = ? WHERE id = ?");
            $stmt->execute([$status, $orderId]);
            setSuccess("Order #$orderId status updated to " . ucfirst($status));
        } elseif ($action === 'delete') {
            $stmt = $pdo->prepare("DELETE FROM product_orders WHERE id = ?");
            $stmt->execute([$orderId]);
            setSuccess("Order #$orderId deleted successfully!");
        }
    } catch (PDOException $e) {
        setError("Error: " . $e->getMessage());
    }
    header('Location: orders.php' . (isset($_GET['status']) ? '?status=' . $_GET['status'] : ''));
    exit;
}

// Stats for all sessions
$stats = [];
try {
    $stmt = $pdo->query("SELECT order_status, COUNT(*) as count FROM product_orders GROUP BY order_status");
    while ($row = $stmt->fetch()) {
        $stats[$row['order_status']] = $row['count'];
    }
} catch (PDOException $e) {
}

$current_status = $_GET['status'] ?? 'all';
$where_clause = "";
$params = [];

if ($current_status !== 'all') {
    $where_clause = " WHERE po.order_status = ? ";
    $params = [$current_status];
}

// Fetch filtered orders with product details
try {
    $stmt = $pdo->prepare("
        SELECT po.*, p.name as product_name, p.price as product_price, p.image as product_image
        FROM product_orders po 
        JOIN products p ON po.product_id = p.id 
        $where_clause
        ORDER BY po.created_at DESC
    ");
    $stmt->execute($params);
    $orders = $stmt->fetchAll();
} catch (PDOException $e) {
    $orders = [];
}

include 'header.php';
?>

.session-tab {
        text-decoration: none;
        padding: 12px 20px;
        background: var(--card-bg);
        border: 1px solid var(--border-color);
        border-radius: 14px;
        color: var(--text-secondary);
        font-weight: 700;
        font-size: 14px;
        display: flex;
        align-items: center;
        gap: 10px;
        white-space: nowrap;
        transition: 0.3s;
    }

.session-tab.active {
        background: var(--primary-color);
        border-color: var(--primary-color);
        color: #000;
        box-shadow: 0 10px 20px rgba(0, 255, 163, 0.2);
    }

.session-tab:hover:not(.active) {
        border-color: var(--primary-color);
        color: var(--primary-color);
    }

.session-tab .count {
        background: rgba(255, 255, 255, 0.1);
        padding: 2px 8px;
        border-radius: 6px;
        font-size: 12px;
    }

.session-tab.active .count {
        background: rgba(0, 0, 0, 0.1);
    }

/* Original styles preserved and optimized */
    .orders-container {
        display: grid;
        grid-template-columns: repeat(auto-fill, minmax(380px, 1fr));
        gap: 20px;
        margin-top: 10px;
    }

.order-card {
        background: var(--card-bg);
        border: 1px solid var(--border-color);
        border-radius: 20px;
        padding: 20px;
        position: relative;
        transition: 0.3s;
        display: flex;
        flex-direction: column;
        gap: 18px;
    }

.order-card:hover {
        border-color: var(--primary-color);
        transform: translateY(-5px);
        box-shadow: 0 15px 30px rgba(0, 0, 0, 0.2);
    }

.order-header {
        display: flex;
        justify-content: space-between;
        align-items: center;
        padding-bottom: 15px;
        border-bottom: 1px solid var(--border-color);
    }

.order-id {
        font-family: 'Outfit', sans-serif;
        font-weight: 800;
        color: var(--primary-color);
        font-size: 16px;
    }

.order-date {
        font-size: 12px;
        color: var(--text-secondary);
    }

.order-body {
        display: flex;
        gap: 15px;
    }

.order-product-img {
        width: 70px;
        height: 70px;
        border-radius: 10px;
        object-fit: cover;
        border: 1px solid var(--border-color);
    }

.order-product-info h4 {
        margin: 0 0 5px 0;
        font-size: 16px;
        color: var(--text-primary);
    }

.order-price {
        font-weight: 800;
        color: var(--primary-color);
        font-size: 18px;
    }

.customer-box {
        background: rgba(255, 255, 255, 0.02);
        padding: 15px;
        border-radius: 12px;
        border: 1px solid var(--border-color);
    }

.customer-info-row {
        display: flex;
        align-items: flex-start;
        gap: 10px;
        margin-bottom: 10px;
        font-size: 13px;
        color: var(--text-primary);
    }

.customer-info-row:last-child {
        margin-bottom: 0;
    }

.customer-info-row i {
        color: var(--primary-color);
        width: 14px;
        margin-top: 3px;
    }

.status-badge {
        display: inline-block;
        padding: 5px 10px;
        border-radius: 6px;
        font-size: 10px;
        font-weight: 800;
        text-transform: uppercase;
        letter-spacing: 0.5px;
    }

.status-pending {
        background: rgba(255, 193, 7, 0.1);
        color: #ffc107;
    }

.status-processing {
        background: rgba(0, 123, 255, 0.1);
        color: #007bff;
    }

.status-shipped {
        background: rgba(23, 162, 184, 0.1);
        color: #17a2b8;
    }

.status-completed {
        background: rgba(40, 167, 69, 0.1);
        color: #28a745;
    }

.status-cancelled {
        background: rgba(220, 53, 69, 0.1);
        color: #dc3545;
    }

.status-select {
        width: 100%;
        padding: 10px;
        border-radius: 10px;
        background: var(--dark-bg);
        border: 1px solid var(--border-color);
        color: #fff;
        font-size: 13px;
    }

.action-btns {
        display: flex;
        gap: 8px;
        margin-top: auto;
    }
</style>

<div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 25px;">
    <h2 style="margin: 0; font-family: 'Outfit', sans-serif;"><i class="fas fa-shopping-cart"
            style="color: var(--primary-color);"></i> Order <span>Manager</span></h2>
    <div class="badge badge-primary"><?php echo count($orders); ?> Orders found</div>
</div>

<div class="order-sessions">
    <a href="?status=all" class="session-tab <?php echo $current_status === 'all' ? 'active' : ''; ?>">
        <i class="fas fa-list"></i> All Sessions
    </a>
    <a href="?status=pending" class="session-tab <?php echo $current_status === 'pending' ? 'active' : ''; ?>">
        <i class="fas fa-clock"></i> Pending <span class="count"><?php echo $stats['pending'] ?? 0; ?></span>
    </a>
    <a href="?status=processing" class="session-tab <?php echo $current_status === 'processing' ? 'active' : ''; ?>">
        <i class="fas fa-sync"></i> Processing <span class="count"><?php echo $stats['processing'] ?? 0; ?></span>
    </a>
    <a href="?status=shipped" class="session-tab <?php echo $current_status === 'shipped' ? 'active' : ''; ?>">
        <i class="fas fa-truck"></i> Shipped <span class="count"><?php echo $stats['shipped'] ?? 0; ?></span>
    </a>
    <a href="?status=completed" class="session-tab <?php echo $current_status === 'completed' ? 'active' : ''; ?>">
        <i class="fas fa-check-double"></i> Completed <span class="count"><?php echo $stats['completed'] ?? 0; ?></span>
    </a>
    <a href="?status=cancelled" class="session-tab <?php echo $current_status === 'cancelled' ? 'active' : ''; ?>">
        <i class="fas fa-times-circle"></i> Cancelled <span class="count"><?php echo $stats['cancelled'] ?? 0; ?></span>
    </a>
</div>

<?php if (empty($orders)): ?>
    <div class="card" style="text-align: center; padding: 100px 20px;">
        <i class="fas fa-search" style="font-size: 50px; color: var(--text-secondary); margin-bottom: 20px;"></i>
        <h3 style="color: var(--text-secondary);">No orders found in this session.</h3>
    </div>
<?php else: ?>
    <div class="orders-container">
        <?php foreach ($orders as $order): ?>
            <div class="order-card">
                <div class="order-header">
                    <div>
                        <span class="order-id">#ORD-<?php echo str_pad($order['id'], 5, '0', STR_PAD_LEFT); ?></span>
                        <div class="order-date"><?php echo date('d M Y, h:i A', strtotime($order['created_at'])); ?></div>
                    </div>
                    <div class="status-badge status-<?php echo $order['order_status']; ?>">
                        <?php echo $order['order_status']; ?>
                    </div>
                </div>

<div class="order-body">
                    <img src="../uploads/products/<?php echo $order['product_image']; ?>" alt="Product"
                        class="order-product-img">
                    <div class="order-product-info">
                        <h4><?php echo htmlspecialchars($order['product_name']); ?></h4>
                        <div class="order-price"><?php echo formatCurrency($order['product_price']); ?></div>
                    </div>
                </div>

<div class="action-btns">
                    <form method="POST" style="flex: 1; margin: 0;">
                        <input type="hidden" name="action" value="update_status">
                        <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                        <select name="status" class="status-select" onchange="this.form.submit()">
                            <option value="pending" <?php echo $order['order_status'] === 'pending' ? 'selected' : ''; ?>>Pending
                            </option>
                            <option value="processing" <?php echo $order['order_status'] === 'processing' ? 'selected' : ''; ?>>
                                Processing</option>
                            <option value="shipped" <?php echo $order['order_status'] === 'shipped' ? 'selected' : ''; ?>>Shipped
                            </option>
                            <option value="completed" <?php echo $order['order_status'] === 'completed' ? 'selected' : ''; ?>>
                                Completed</option>
                            <option value="cancelled" <?php echo $order['order_status'] === 'cancelled' ? 'selected' : ''; ?>>
                                Cancelled</option>
                        </select>
                    </form>
                    <form method="POST" onsubmit="return confirm('Delete this order?')" style="margin: 0;">
                        <input type="hidden" name="action" value="delete">
                        <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                        <button type="submit" class="btn btn-danger"
                            style="height: 40px; width: 40px; border-radius: 10px; display: grid; place-items: center; padding: 0;">
                            <i class="fas fa-trash-alt"></i>
                        </button>
                    </form>
                </div>
            </div>
        <?php endforeach; ?>
    </div>
<?php endif; ?>

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