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.28 TB

🔧 Quick Actions

✏️ Editing: update_payment.php

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

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

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

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

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

try {
    $pdo->beginTransaction();
    
    // First, find the root order ID
    $stmt = $pdo->prepare("
        SELECT COALESCE(followed_order_id, order_id) as root_id
        FROM orders 
        WHERE order_id = ?
    ");
    $stmt->execute([$order_id]);
    $root_result = $stmt->fetch();
    
    if (!$root_result) {
        throw new Exception('Order not found');
    }
    
    $root_id = $root_result['root_id'];
    
    // Find all versions of this order (the entire chain)
    $stmt = $pdo->prepare("
        WITH RECURSIVE order_chain AS (
            -- Start from root
            SELECT order_id, order_version, followed_order_id
            FROM orders
            WHERE order_id = :root_id
            
            UNION ALL
            
            -- Add all orders that follow from previous ones
            SELECT o.order_id, o.order_version, o.followed_order_id
            FROM orders o
            INNER JOIN order_chain oc ON o.followed_order_id = oc.order_id
        )
        SELECT order_id FROM order_chain
    ");
    $stmt->execute(['root_id' => $root_id]);
    $order_ids = $stmt->fetchAll(PDO::FETCH_COLUMN);
    
    // Update payment method for all versions
    if (!empty($order_ids)) {
        $placeholders = implode(',', array_fill(0, count($order_ids), '?'));
        $stmt = $pdo->prepare("UPDATE orders SET payment_method = ? WHERE order_id IN ($placeholders)");
        $params = array_merge([$payment_method], $order_ids);
        $stmt->execute($params);
    }
    
    $pdo->commit();
    
    echo json_encode([
        'success' => true,
        'message' => 'Payment method updated successfully for all versions',
        'updated_count' => count($order_ids)
    ]);
    
} catch (Exception $e) {
    $pdo->rollBack();
    echo json_encode([
        'success' => false, 
        'message' => 'Error: ' . $e->getMessage()
    ]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update_payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation