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

🔧 Quick Actions

✏️ Editing: add_order_items.php

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

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

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

$branch_id = $_SESSION['branch_id'];
$data = json_decode(file_get_contents('php://input'), true);

if (!$data || !isset($data['order_id']) || !isset($data['items']) || empty($data['items'])) {
    echo json_encode(['success' => false, 'message' => 'Invalid request']);
    exit();
}

$order_id = (int)$data['order_id'];
$root_order_id = isset($data['root_order_id']) ? (int)$data['root_order_id'] : $order_id;
$items = $data['items'];

try {
    $pdo->beginTransaction();
    
    // Get current order details
    $stmt = $pdo->prepare("
        SELECT order_version, customer_name, customer_contact, order_type, table_number, 
               is_gst_active, cgst_rate, sgst_rate
        FROM orders 
        WHERE order_id = ? AND branch_id = ?
    ");
    $stmt->execute([$order_id, $branch_id]);
    $current_order = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if (!$current_order) {
        throw new Exception('Order not found');
    }
    
    $new_version = $current_order['order_version'] + 1;
    
    // Calculate subtotal for new items
    $subtotal = 0;
    $total_discount = 0;
    $order_items = [];
    
    foreach ($items as $item) {
        // Get food details to verify price and calculate discount
        $stmt = $pdo->prepare("
            SELECT price, is_offer, offer 
            FROM foods 
            WHERE food_id = ? 
            AND food_id IN (SELECT food_id FROM branch_foods WHERE branch_id = ? AND status = 'active')
        ");
        $stmt->execute([$item['food_id'], $branch_id]);
        $food = $stmt->fetch(PDO::FETCH_ASSOC);
        
        if (!$food) {
            throw new Exception('Food item not available');
        }
        
        $original_price = (float)$food['price'];
        $offer_perc = $food['is_offer'] ? (float)$food['offer'] : 0;
        $item_price = $original_price * (1 - $offer_perc / 100);
        $discount_per_unit = $original_price * $offer_perc / 100;
        $quantity = (int)$item['quantity'];
        
        $subtotal_item = $quantity * $item_price;
        $discount_item = $quantity * $discount_per_unit;
        
        $subtotal += $subtotal_item;
        $total_discount += $discount_item;
        
        $order_items[] = [
            'food_id' => $item['food_id'],
            'quantity' => $quantity,
            'price' => $item_price,
            'subtotal' => $subtotal_item,
            'discount_amount' => $discount_item
        ];
    }
    
    // Get previous order total
    $stmt = $pdo->prepare("
        SELECT SUM(total_amount) as previous_total 
        FROM orders 
        WHERE (order_id = ? OR followed_order_id = ?) AND branch_id = ?
    ");
    $stmt->execute([$root_order_id, $root_order_id, $branch_id]);
    $previous = $stmt->fetch(PDO::FETCH_ASSOC);
    $previous_total = $previous['previous_total'] ?? 0;
    
    $total_amount = $subtotal;
    
    // Create new order version (followed order)
    $stmt = $pdo->prepare("
        INSERT INTO orders (
            branch_id, customer_name, customer_contact, order_date, total_amount,
            status, payment_method, order_type, table_number,
            is_gst_active, cgst_rate, sgst_rate, cgst_amount, sgst_amount,
            taxable_amount, extra_charge, staff_id, order_version, followed_order_id
        ) VALUES (
            :branch_id, :customer_name, :customer_contact, NOW(), :total_amount,
            :status, :payment_method, :order_type, :table_number,
            :is_gst_active, :cgst_rate, :sgst_rate, :cgst_amount, :sgst_amount,
            :taxable_amount, :extra_charge, :staff_id, :order_version, :followed_order_id
        )
    ");
    
    $stmt->execute([
        'branch_id' => $branch_id,
        'customer_name' => $current_order['customer_name'],
        'customer_contact' => $current_order['customer_contact'],
        'total_amount' => $total_amount,
        'status' => 'processing',
        'payment_method' => null,
        'order_type' => $current_order['order_type'],
        'table_number' => $current_order['table_number'],
        'is_gst_active' => $current_order['is_gst_active'],
        'cgst_rate' => $current_order['cgst_rate'],
        'sgst_rate' => $current_order['sgst_rate'],
        'cgst_amount' => 0,
        'sgst_amount' => 0,
        'taxable_amount' => $subtotal,
        'extra_charge' => 0,
        'staff_id' => $_SESSION['user_id'] ?? null,
        'order_version' => $new_version,
        'followed_order_id' => $order_id
    ]);
    
    $new_order_id = $pdo->lastInsertId();
    
    // Get next KOT number
    $stmt = $pdo->prepare("SELECT COALESCE(MAX(kot_number), 0) + 1 as next_kot FROM kots WHERE order_id = ?");
    $stmt->execute([$new_order_id]);
    $next_kot = $stmt->fetch(PDO::FETCH_ASSOC)['next_kot'];
    
    // Create new KOT
    $stmt = $pdo->prepare("
        INSERT INTO kots (order_id, kot_number, status, created_at)
        VALUES (?, ?, 'pending', NOW())
    ");
    $stmt->execute([$new_order_id, $next_kot]);
    $kot_id = $pdo->lastInsertId();
    
    // Insert order items
    $stmt = $pdo->prepare("
        INSERT INTO order_items (order_id, kot_id, food_id, quantity, price, subtotal, discount_amount, order_version)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?)
    ");
    
    foreach ($order_items as $item) {
        $stmt->execute([
            $new_order_id,
            $kot_id,
            $item['food_id'],
            $item['quantity'],
            $item['price'],
            $item['subtotal'],
            $item['discount_amount'],
            $new_version
        ]);
    }
    
    $pdo->commit();
    
    echo json_encode([
        'success' => true,
        'message' => 'Items added successfully',
        'new_order_id' => $new_order_id,
        'new_version' => $new_version
    ]);
    
} catch (Exception $e) {
    $pdo->rollBack();
    echo json_encode(['success' => false, 'message' => $e->getMessage()]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add_order_items.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation