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/ecommer.in/public_html/billing/bakery/branch

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: edit_preorder.php

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

if (!isset($_SESSION['user_id']) || !isset($_SESSION['branch_id'])) {
    header("Location: ../login.php");
    exit();
}

$branch_id = $_SESSION['branch_id'];
$user_id = $_SESSION['user_id'];
$errors = [];
$success = '';

// Check if order ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: pre_orders.php");
    exit();
}

$order_id = (int)$_GET['id'];

// Fetch the existing order
$order = null;
try {
    $stmt = $pdo->prepare("SELECT * FROM pre_orders WHERE id = ? AND branch_id = ?");
    $stmt->execute([$order_id, $branch_id]);
    $order = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if (!$order) {
        header("Location: pre_orders.php");
        exit();
    }
} catch (Exception $e) {
    $errors[] = "Error loading order.";
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get form data
    $customer_name = trim($_POST['customer_name'] ?? '');
    $customer_phone = trim($_POST['customer_phone'] ?? '');
    $customer_address = trim($_POST['customer_address'] ?? '');
    $food_name = trim($_POST['food_name'] ?? '');
    $quantity = (float)($_POST['quantity'] ?? 0);
    $unit = trim($_POST['unit'] ?? 'kg');
    $price_per_unit = (float)($_POST['price_per_unit'] ?? 0);
    $total_amount = (float)($_POST['total_amount'] ?? 0);
    $advance_amount = (float)($_POST['advance_amount'] ?? 0);
    $balance_amount = (float)($_POST['balance_amount'] ?? 0);
    $expected_date = $_POST['expected_date'] ?? '';
    $expected_time = $_POST['expected_time'] ?? '';
    $occasion = trim($_POST['occasion'] ?? '');
    $special_notes = trim($_POST['special_notes'] ?? '');
    $status = trim($_POST['status'] ?? 'pending');
    
    // Validate required fields
    if (empty($customer_name)) $errors[] = "Customer name is required.";
    if (empty($customer_phone)) $errors[] = "Customer phone is required.";
    if (empty($food_name)) $errors[] = "Food name is required.";
    if ($quantity <= 0) $errors[] = "Quantity must be greater than 0.";
    if ($price_per_unit <= 0) $errors[] = "Price per unit must be greater than 0.";
    if (empty($expected_date)) $errors[] = "Expected date is required.";
    if (empty($expected_time)) $errors[] = "Expected time is required.";
    if ($total_amount <= 0) $errors[] = "Total amount must be greater than 0.";
    if ($advance_amount < 0) $errors[] = "Advance amount cannot be negative.";
    if ($balance_amount < 0) $errors[] = "Balance amount cannot be negative.";
    
    // Validate amount consistency
    if (($advance_amount + $balance_amount) != $total_amount) {
        $errors[] = "Advance + Balance must equal Total Amount.";
    }
    
    // Validate status
    $allowed_statuses = ['pending', 'confirmed', 'preparing', 'ready', 'delivered', 'completed', 'cancelled'];
    if (!in_array($status, $allowed_statuses)) {
        $errors[] = "Invalid status selected.";
    }
    
    // If no errors, update the order
    if (empty($errors)) {
        try {
            $stmt = $pdo->prepare("
                UPDATE pre_orders SET 
                    customer_name = ?,
                    customer_phone = ?,
                    customer_address = ?,
                    food_name = ?,
                    quantity = ?,
                    unit = ?,
                    price_per_unit = ?,
                    total_amount = ?,
                    advance_amount = ?,
                    balance_amount = ?,
                    expected_date = ?,
                    expected_time = ?,
                    occasion = ?,
                    special_notes = ?,
                    status = ?,
                    updated_at = NOW()
                WHERE id = ? AND branch_id = ?
            ");
            
            $stmt->execute([
                $customer_name,
                $customer_phone,
                $customer_address,
                $food_name,
                $quantity,
                $unit,
                $price_per_unit,
                $total_amount,
                $advance_amount,
                $balance_amount,
                $expected_date,
                $expected_time,
                $occasion,
                $special_notes,
                $status,
                $order_id,
                $branch_id
            ]);
            
            if ($stmt->rowCount() > 0) {
                $success = "Pre-order updated successfully!";
                
                // Re-fetch the updated order
                $stmt = $pdo->prepare("SELECT * FROM pre_orders WHERE id = ? AND branch_id = ?");
                $stmt->execute([$order_id, $branch_id]);
                $order = $stmt->fetch(PDO::FETCH_ASSOC);
            } else {
                $errors[] = "No changes made or order not found.";
            }
            
        } catch (Exception $e) {
            $errors[] = "Failed to update pre-order: " . $e->getMessage();
        }
    }
}

// Fetch current food items for suggestions if needed
$food_items = [];
try {
    $stmt = $pdo->prepare("SELECT DISTINCT food_name FROM pre_orders WHERE branch_id = ? ORDER BY food_name");
    $stmt->execute([$branch_id]);
    $food_items = $stmt->fetchAll(PDO::FETCH_COLUMN);
} catch (Exception $e) {
    // Silently fail - suggestions are optional
}

include './partials/layouts/layoutTop.php';
?>

<div class="dashboard-main-body">
    
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-16">
        <h6 class="fw-semibold mb-0 text-md">Edit Pre-Order</h6>
        <ul class="d-flex align-items-center gap-1">
            <li class="fw-medium text-sm"><a href="index.php" class="hover-text-primary"><i class="fas fa-home fa-icon"></i> Dashboard</a></li>
            <li>-</li>
            <li class="fw-medium text-sm"><a href="pre_orders.php" class="hover-text-primary">Pre-Orders</a></li>
            <li>-</li>
            <li class="fw-medium text-sm">Edit #<?= $order['id'] ?? '' ?></li>
        </ul>
    </div>

<?php if ($success): ?>
        <div class="alert alert-success alert-dismissible fade show mb-16">
            <i class="fas fa-check-circle fa-icon"></i> <?= htmlspecialchars($success) ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    <?php endif; ?>
    
    <?php if ($errors): ?>
        <div class="alert alert-danger alert-dismissible fade show mb-16">
            <ul class="mb-0">
                <?php foreach ($errors as $e): ?>
                    <li><?= htmlspecialchars($e) ?></li>
                <?php endforeach; ?>
            </ul>
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    <?php endif; ?>

<div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header">
                    <h5 class="section-title card-title mb-0 text-md">
                        <i class="fas fa-edit fa-icon"></i> Edit Pre-Order #<?= $order['id'] ?? '' ?>
                    </h5>
                </div>
                <div class="card-body">
                    <form method="POST" id="editPreorderForm">
                        <div class="row">
                            
                            <div class="col-md-6">
                                <div class="form-section">
                                    <h6 class="section-title text-md">Customer Details</h6>
                                    <div class="mb-3">
                                        <label class="form-label required-field">Customer Name</label>
                                        <input type="text" class="form-control" name="customer_name" 
                                               value="<?= htmlspecialchars($order['customer_name'] ?? '') ?>" required>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label required-field">Customer Phone</label>
                                        <input type="text" class="form-control" name="customer_phone" 
                                               value="<?= htmlspecialchars($order['customer_phone'] ?? '') ?>" required>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">Customer Address</label>
                                        <textarea class="form-control" name="customer_address" rows="2"><?= htmlspecialchars($order['customer_address'] ?? '') ?></textarea>
                                    </div>
                                </div>
                            </div>

<div class="col-md-6">
                                <div class="form-section">
                                    <h6 class="section-title text-md">Delivery Details</h6>
                                    <div class="row">
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label required-field">Expected Date</label>
                                            <input type="date" class="form-control" name="expected_date" 
                                                   value="<?= htmlspecialchars($order['expected_date'] ?? '') ?>" required>
                                        </div>
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label required-field">Expected Time</label>
                                            <input type="time" class="form-control" name="expected_time" 
                                                   value="<?= htmlspecialchars($order['expected_time'] ?? '') ?>" required>
                                        </div>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">Occasion</label>
                                        <input type="text" class="form-control" name="occasion" 
                                               value="<?= htmlspecialchars($order['occasion'] ?? '') ?>">
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">Status</label>
                                        <select class="form-select" name="status">
                                            <option value="pending" <?= ($order['status'] ?? '') == 'pending' ? 'selected' : '' ?>>Pending</option>
                                            <option value="confirmed" <?= ($order['status'] ?? '') == 'confirmed' ? 'selected' : '' ?>>Confirmed</option>
                                            <option value="preparing" <?= ($order['status'] ?? '') == 'preparing' ? 'selected' : '' ?>>Preparing</option>
                                            <option value="ready" <?= ($order['status'] ?? '') == 'ready' ? 'selected' : '' ?>>Ready</option>
                                            <option value="delivered" <?= ($order['status'] ?? '') == 'delivered' ? 'selected' : '' ?>>Delivered</option>
                                            <option value="completed" <?= ($order['status'] ?? '') == 'completed' ? 'selected' : '' ?>>Completed</option>
                                            <option value="cancelled" <?= ($order['status'] ?? '') == 'cancelled' ? 'selected' : '' ?>>Cancelled</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="form-section">
                            <h6 class="section-title text-md">Product Details</h6>
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label required-field">Food Item</label>
                                    <input type="text" class="form-control" name="food_name" 
                                           value="<?= htmlspecialchars($order['food_name'] ?? '') ?>" required
                                           id="food_name" autocomplete="off">
                                    <div class="suggestion-list" id="food_suggestions">
                                        <?php foreach ($food_items as $food): ?>
                                            <div class="suggestion-item" onclick="selectFood('<?= htmlspecialchars(addslashes($food)) ?>')">
                                                <?= htmlspecialchars($food) ?>
                                            </div>
                                        <?php endforeach; ?>
                                    </div>
                                </div>
                                <div class="col-md-3 mb-3">
                                    <label class="form-label required-field">Quantity</label>
                                    <input type="number" class="form-control" name="quantity" step="0.01" min="0.01" 
                                           value="<?= htmlspecialchars($order['quantity'] ?? '') ?>" required
                                           id="quantity" onchange="calculateAmounts()">
                                </div>
                                <div class="col-md-3 mb-3">
                                    <label class="form-label required-field">Unit</label>
                                    <select class="form-select" name="unit" id="unit">
                                        <option value="kg" <?= ($order['unit'] ?? '') == 'kg' ? 'selected' : '' ?>>Kilogram (kg)</option>
                                        <option value="g" <?= ($order['unit'] ?? '') == 'g' ? 'selected' : '' ?>>Gram (g)</option>
                                        <option value="lb" <?= ($order['unit'] ?? '') == 'lb' ? 'selected' : '' ?>>Pound (lb)</option>
                                        <option value="piece" <?= ($order['unit'] ?? '') == 'piece' ? 'selected' : '' ?>>Piece</option>
                                        <option value="dozen" <?= ($order['unit'] ?? '') == 'dozen' ? 'selected' : '' ?>>Dozen</option>
                                        <option value="box" <?= ($order['unit'] ?? '') == 'box' ? 'selected' : '' ?>>Box</option>
                                        <option value="packet" <?= ($order['unit'] ?? '') == 'packet' ? 'selected' : '' ?>>Packet</option>
                                    </select>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-md-6 mb-3">
                                    <label class="form-label required-field">Price per Unit (₹)</label>
                                    <div class="input-group">
                                        <span class="input-group-text currency-addon">₹</span>
                                        <input type="number" class="form-control" name="price_per_unit" step="0.01" min="0.01" 
                                               value="<?= htmlspecialchars($order['price_per_unit'] ?? '') ?>" required
                                               id="price_per_unit" onchange="calculateAmounts()">
                                    </div>
                                </div>
                                <div class="col-md-6 mb-3">
                                    <label class="form-label required-field">Total Amount (₹)</label>
                                    <div class="input-group">
                                        <span class="input-group-text currency-addon">₹</span>
                                        <input type="number" class="form-control" name="total_amount" step="0.01" min="0.01" 
                                               value="<?= htmlspecialchars($order['total_amount'] ?? '') ?>" required
                                               id="total_amount" readonly style="background-color: #f8f9fa;">
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="form-section">
                            <h6 class="section-title text-md">Payment Details</h6>
                            <div class="row">
                                <div class="col-md-4 mb-3">
                                    <label class="form-label">Advance Amount (₹)</label>
                                    <div class="input-group">
                                        <span class="input-group-text currency-addon">₹</span>
                                        <input type="number" class="form-control" name="advance_amount" step="0.01" min="0" 
                                               value="<?= htmlspecialchars($order['advance_amount'] ?? '') ?>"
                                               id="advance_amount" onchange="calculateBalance()">
                                    </div>
                                </div>
                                <div class="col-md-4 mb-3">
                                    <label class="form-label">Balance Amount (₹)</label>
                                    <div class="input-group">
                                        <span class="input-group-text currency-addon">₹</span>
                                        <input type="number" class="form-control" name="balance_amount" step="0.01" min="0" 
                                               value="<?= htmlspecialchars($order['balance_amount'] ?? '') ?>"
                                               id="balance_amount" readonly style="background-color: #f8f9fa;">
                                    </div>
                                </div>
                                <div class="col-md-4 mb-3">
                                    <div class="d-flex align-items-end h-100">
                                        <div class="w-100">
                                            <div class="alert alert-light mb-0 text-center">
                                                <small class="text-muted d-block">Amount Summary</small>
                                                <div class="amount-display text-primary">₹<span id="display_total"><?= number_format($order['total_amount'] ?? 0, 2) ?></span></div>
                                                <small class="text-success">Adv: ₹<span id="display_advance"><?= number_format($order['advance_amount'] ?? 0, 2) ?></span></small> | 
                                                <small class="text-danger">Bal: ₹<span id="display_balance"><?= number_format($order['balance_amount'] ?? 0, 2) ?></span></small>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="form-section">
                            <h6 class="section-title text-md">Additional Information</h6>
                            <div class="mb-3">
                                <label class="form-label">Special Instructions / Notes</label>
                                <textarea class="form-control" name="special_notes" rows="3"><?= htmlspecialchars($order['special_notes'] ?? '') ?></textarea>
                            </div>
                        </div>

<div class="d-flex justify-content-between align-items-center mt-16 pt-3 border-top">
                            <a href="Pre_Orders_List.php" class="btn btn-outline-secondary">
                                <i class="fas fa-arrow-left fa-icon"></i> Back to List
                            </a>
                            <div class="d-flex gap-2">
                                <a href="Pre_Orders_List.php" class="btn btn-secondary">Cancel</a>
                                <button type="submit" class="btn btn-primary">
                                    <i class="fas fa-save fa-icon"></i> Update Pre-Order
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include './partials/layouts/layoutBottom.php'; ?>

// Calculate balance amount
function calculateBalance() {
    const totalAmount = parseFloat(document.getElementById('total_amount').value) || 0;
    const advanceAmount = parseFloat(document.getElementById('advance_amount').value) || 0;
    const balanceAmount = totalAmount - advanceAmount;
    
    document.getElementById('balance_amount').value = Math.max(balanceAmount, 0).toFixed(2);
    document.getElementById('display_balance').textContent = Math.max(balanceAmount, 0).toFixed(2);
    document.getElementById('display_advance').textContent = advanceAmount.toFixed(2);
}

// Food suggestions functionality
document.getElementById('food_name').addEventListener('input', function() {
    const suggestions = document.getElementById('food_suggestions');
    const searchTerm = this.value.toLowerCase();
    const items = suggestions.querySelectorAll('.suggestion-item');
    let hasVisible = false;
    
    items.forEach(item => {
        if (item.textContent.toLowerCase().includes(searchTerm)) {
            item.style.display = 'block';
            hasVisible = true;
        } else {
            item.style.display = 'none';
        }
    });
    
    suggestions.style.display = hasVisible && this.value.length > 0 ? 'block' : 'none';
});

function selectFood(food) {
    document.getElementById('food_name').value = food;
    document.getElementById('food_suggestions').style.display = 'none';
}

// Hide suggestions when clicking outside
document.addEventListener('click', function(e) {
    if (!e.target.closest('#food_name') && !e.target.closest('#food_suggestions')) {
        document.getElementById('food_suggestions').style.display = 'none';
    }
});

// Initialize amounts on page load
document.addEventListener('DOMContentLoaded', function() {
    calculateAmounts();
    calculateBalance();
});

// Form validation
document.getElementById('editPreorderForm').addEventListener('submit', function(e) {
    const totalAmount = parseFloat(document.getElementById('total_amount').value) || 0;
    const advanceAmount = parseFloat(document.getElementById('advance_amount').value) || 0;
    const balanceAmount = parseFloat(document.getElementById('balance_amount').value) || 0;
    
    // Validate amount consistency
    if (Math.abs((advanceAmount + balanceAmount) - totalAmount) > 0.01) {
        e.preventDefault();
        alert('Advance + Balance must equal Total Amount. Please check the amounts.');
        return false;
    }
    
    // Validate date
    const expectedDate = new Date(document.getElementsByName('expected_date')[0].value);
    const today = new Date();
    today.setHours(0, 0, 0, 0);
    
    if (expectedDate < today) {
        if (!confirm('Expected date is in the past. Are you sure you want to save?')) {
            e.preventDefault();
            return false;
        }
    }
    
    return true;
});
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit_preorder.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation