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

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: update_order_status.php

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

// Validate session
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || $_SESSION['role'] !== 'staff' || !isset($_SESSION['branch_id'])) {
    http_response_code(403);
    header('Content-Type: application/json');
    echo json_encode(['success' => false, 'message' => 'Unauthorized access']);
    exit();
}

$branch_id = $_SESSION['branch_id'];

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $order_id = filter_input(INPUT_POST, 'order_id', FILTER_VALIDATE_INT);
    $new_status = trim($_POST['status'] ?? '');

// Validate inputs
    if (!$order_id || !in_array($new_status, ['pending', 'processing', 'completed', 'cancelled'])) {
        http_response_code(400);
        header('Content-Type: application/json');
        echo json_encode(['success' => false, 'message' => 'Invalid order ID or status']);
        exit();
    }

try {
        $pdo->beginTransaction();

// Fetch order details to check order type and table number
        $stmt = $pdo->prepare("
            SELECT order_type, table_number
            FROM orders
            WHERE order_id = :order_id AND branch_id = :branch_id
        ");
        $stmt->execute([
            ':order_id' => $order_id,
            ':branch_id' => $branch_id
        ]);
        $order = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$order) {
            $pdo->rollBack();
            http_response_code(404);
            header('Content-Type: application/json');
            echo json_encode(['success' => false, 'message' => 'Order not found']);
            exit();
        }

// Update order status
        $stmt = $pdo->prepare("
            UPDATE orders
            SET status = :status
            WHERE order_id = :order_id AND branch_id = :branch_id
        ");
        $stmt->execute([
            ':status' => $new_status,
            ':order_id' => $order_id,
            ':branch_id' => $branch_id
        ]);

$rows_affected = $stmt->rowCount();

// Update table status if order is completed and order type is Dine In
        if ($new_status === 'completed' && $order['order_type'] === 'Dine In' && !empty($order['table_number'])) {
            $stmt = $pdo->prepare("
                UPDATE branch_tables
                SET status = 'available'
                WHERE branch_id = :branch_id AND table_number = :table_number AND status = 'occupied'
            ");
            $stmt->execute([
                ':branch_id' => $branch_id,
                ':table_number' => $order['table_number']
            ]);

if ($stmt->rowCount() === 0) {
                // Log a warning if the table was not updated (e.g., already available or not found)
                error_log("Table {$order['table_number']} for branch_id {$branch_id} was not updated to 'available' for order_id {$order_id}.");
            }
        }

$pdo->commit();

header('Content-Type: application/json');
        if ($rows_affected > 0) {
            http_response_code(200);
            echo json_encode(['success' => true, 'message' => 'Order status updated successfully']);
        } else {
            http_response_code(404);
            echo json_encode(['success' => false, 'message' => 'Order not found or no changes made']);
        }
    } catch (PDOException $e) {
        $pdo->rollBack();
        http_response_code(500);
        header('Content-Type: application/json');
        echo json_encode(['success' => false, 'message' => 'Error updating status: ' . htmlspecialchars($e->getMessage())]);
        error_log("Update status error: " . $e->getMessage());
    }
} else {
    http_response_code(405);
    header('Content-Type: application/json');
    echo json_encode(['success' => false, 'message' => 'Method not allowed']);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update_order_status.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation