Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/.trash/ajax

Free Space:

10.2 TB

🔧 Quick Actions

✏️ Editing: get_order_versions.php

<?php
session_start();
require_once '../config/db_config.php';

header('Content-Type: application/json');

// Validate session
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || !in_array($_SESSION['role'], ['branch', 'staff'])) {
    echo json_encode(['success' => false, 'error' => 'Unauthorized']);
    exit();
}

$order_id = isset($_GET['order_id']) ? intval($_GET['order_id']) : 0;

if ($order_id <= 0) {
    echo json_encode(['success' => false, 'error' => 'Invalid order ID']);
    exit();
}

try {
    // Get all versions of this order
    $stmt = $pdo->prepare("
        SELECT o.order_id, o.order_version, o.total_amount, o.order_date,
               (SELECT COUNT(*) FROM order_items WHERE order_id = o.order_id AND order_version = o.order_version) as item_count
        FROM orders o
        WHERE o.order_id = :order_id OR o.followed_order_id = :order_id OR o.order_id IN (
            SELECT followed_order_id FROM orders WHERE order_id = :order_id
        )
        ORDER BY o.order_version ASC
    ");
    $stmt->execute(['order_id' => $order_id]);
    $versions = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Get items for each version
    foreach ($versions as &$version) {
        $stmt = $pdo->prepare("
            SELECT oi.food_id, oi.quantity, oi.price, oi.subtotal, f.food_name 
            FROM order_items oi 
            JOIN foods f ON oi.food_id = f.food_id 
            WHERE oi.order_id = ? AND oi.order_version = ?
        ");
        $stmt->execute([$version['order_id'], $version['order_version']]);
        $version['items'] = $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    
    echo json_encode([
        'success' => true,
        'versions' => $versions
    ]);
    
} catch (PDOException $e) {
    error_log("Get versions error: " . $e->getMessage());
    echo json_encode([
        'success' => false,
        'error' => 'Database error: ' . $e->getMessage()
    ]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_order_versions.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation