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: create_preorder.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'];
$errors = []; $success = '';
// Generate CSRF token if not set
if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
$csrf = $_SESSION['csrf_token'];
// Fetch foods for the specific branch
try {
    $stmt = $pdo->prepare("
        SELECT f.food_name, bfs.price_per_unit
        FROM foods f
        JOIN branch_foods bf ON f.food_id = bf.food_id
        JOIN branch_food_stock bfs ON bf.branch_food_id = bfs.branch_food_id
        WHERE bf.branch_id = ?
        ORDER BY f.food_name
    ");
    $stmt->execute([$branch_id]);
    $foods = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $errors[] = "Error fetching foods: " . htmlspecialchars($e->getMessage());
    $foods = [];
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Verify CSRF token
    if (!isset($_POST['csrf']) || $_POST['csrf'] !== $_SESSION['csrf_token']) {
        $errors[] = "Invalid CSRF token.";
    } else {
        $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';
        // Validation
        if (empty($customer_name)) $errors[] = "Customer name required.";
        if (empty($customer_phone)) $errors[] = "Phone number required.";
        if (empty($product_name)) $errors[] = "Product name required.";
        if (!in_array($unit, ['piece', 'kg'])) $errors[] = "Invalid unit selected.";
        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($order_date)) $errors[] = "Order date required.";
        if (empty($expected_date)) $errors[] = "Expected delivery date required.";
        if (empty($expected_time)) $errors[] = "Expected delivery time required.";
        if (empty($errors)) {
            try {
                $pdo->beginTransaction();
                $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, $_SESSION['user_id']
                ]);
                $id = $pdo->lastInsertId();
                $pdo->commit();
                // ---- REDIRECT HERE ----
                header("Location: Pre_Orders_List.php?success=" . urlencode("Pre-Order #$id created successfully!"));
                exit();
            } catch (Exception $e) {
                $pdo->rollBack();
                $errors[] = "Error: " . htmlspecialchars($e->getMessage());
            }
        }
    }
}
include './partials/layouts/layoutTop.php';
?>
<style>
.fa-icon { font-size: 15px; margin-right: 5px; }
.section-title { font-size: 1rem; color: #4361ee; font-weight: 600; }
.amount-box {
    background: #f8f9fa; border-radius: 10px; padding: 1rem; text-align: center;
    font-size: 0.9rem; min-height: 90px;
}
.amount-box.total { border: 2px solid #4361ee; }
.amount-box.advance { border: 2px solid #28a745; }
.amount-box.balance { background: #fee2e2; border: 2px solid #ef4444; color: #dc3545; }
.amount-value { font-size: 1.4rem; font-weight: 800; }
.form-control, .form-select { font-size: 0.9rem; }
</style>
<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">Create New Pre-Order</h6>
        <ul class="d-flex align-items-center gap-1 text-sm">
            <li><a href="index.php" class="hover-text-primary"><i class="fas fa-home fa-icon"></i> Dashboard</a></li>
            <li>-</li>
            <li><a href="pre_orders.php" class="hover-text-primary">Pre-Orders</a></li>
            <li>-</li>
            <li class="text-primary">Create</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 btn-sm" 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 text-sm">
                <?php foreach ($errors as $e): ?><li><?= htmlspecialchars($e) ?></li><?php endforeach; ?>
            </ul>
            <button type="button" class="btn-close btn-sm" data-bs-dismiss="alert"></button>
        </div>
    <?php endif; ?>
    <div class="card">
        <div class="card-body p-20">
            <form method="POST" class="row g-3">
                <input type="hidden" name="csrf" value="<?= htmlspecialchars($csrf) ?>">
                
                <div class="col-12">
                    <h6 class="section-title mb-2"><i class="fas fa-user fa-icon"></i> Customer Details</h6>
                </div>
                <div class="col-sm-4">
                    <small>Customer name </small>
                    <input type="text" name="customer_name" class="form-control form-control-sm" placeholder="Name *" value="<?= $_POST['customer_name'] ?? '' ?>" required>
                </div>
                <div class="col-sm-4">
                    <small>Customer phone </small>
                    <input type="text" name="customer_phone" class="form-control form-control-sm" placeholder="Phone *" value="<?= $_POST['customer_phone'] ?? '' ?>" required>
                </div>
                <div class="col-sm-4">
                    <small>Address </small>
                    <input type="text" name="customer_address" class="form-control form-control-sm" placeholder="Address" value="<?= $_POST['customer_address'] ?? '' ?>">
                </div>
                
                <div class="col-12 mt-3">
                    <h6 class="section-title mb-2"><i class="fas fa-birthday-cake fa-icon"></i> Product Details</h6>
                </div>
                <div class="col-sm-5">
                    <small>Product </small>
                    <input type="text" list="cakeList" name="product_name" id="product_name" class="form-control form-control-sm"
                           placeholder="Enter or select product name *" value="<?= $_POST['product_name'] ?? '' ?>" required>
                    <datalist id="cakeList">
                        <?php foreach ($foods as $f): ?>
                            <option value="<?= htmlspecialchars($f['food_name']) ?>" data-price="<?= htmlspecialchars($f['price_per_unit']) ?>">
                        <?php endforeach; ?>
                    </datalist>
                </div>
                <div class="col-sm-2">
                    <small>Price </small>
                    <input type="number" step="0.01" name="price_per_unit" id="price_per_unit" class="form-control form-control-sm text-primary fw-bold"
                           placeholder="Price/Unit *" value="<?= $_POST['price_per_unit'] ?? '' ?>" required>
                </div>
                <div class="col-sm-2">
                    <small>Qnt </small>
                    <input type="number" step="0.01" name="quantity" id="quantity" class="form-control form-control-sm"
                           placeholder="Qty" min="0.01" value="<?= $_POST['quantity'] ?? '1' ?>" required>
                </div>
                <div class="col-sm-3">
                    <small>Unit </small>
                    <select name="unit" class="form-select form-select-sm" required>
                        <option value="">Unit</option>
                        <option value="kg" <?= ($_POST['unit'] ?? '') == 'kg' ? 'selected' : '' ?>>KG</option>
                        <option value="piece" <?= ($_POST['unit'] ?? '') == 'piece' ? 'selected' : '' ?>>Piece</option>
                    </select>
                </div>
                
                <div class="col-12 mt-3">
                    <div class="row g-3">
                        <div class="col-sm-4">
                            <div class="amount-box total">
                                <small>Total Amount</small>
                                <div class="amount-value text-primary">₹<span id="totalDisplay">0.00</span></div>
                                <input type="hidden" name="total_amount" id="total_amount">
                            </div>
                        </div>
                        <div class="col-sm-4">
                            <div class="amount-box advance">
                                <small>Advance Paid</small>
                                <input type="number" step="0.01" name="advance_amount" id="advance_amount"
                                       class="form-control form-control-sm text-center border-0 bg-transparent text-success fw-bold"
                                       value="<?= $_POST['advance_amount'] ?? '0' ?>">
                            </div>
                        </div>
                        <div class="col-sm-4">
                            <div class="amount-box balance">
                                <small>Balance Due</small>
                                <div class="amount-value">₹<span id="balanceAmount">0.00</span></div>
                            </div>
                        </div>
                    </div>
                </div>
                
                <div class="col-12 mt-3">
                    <h6 class="section-title mb-2"><i class="fas fa-truck fa-icon"></i> Delivery & Occasion</h6>
                </div>
                <div class="col-sm-4">
                    <small> Order Date</small>
                    <input type="date" name="order_date" class="form-control form-control-sm" value="<?= $_POST['order_date'] ?? date('Y-m-d') ?>" required>
                </div>
                <div class="col-sm-4">
                    <small>Expected Delivery Date</small>
                    <input type="date" name="expected_date" class="form-control form-control-sm" min="<?= date('Y-m-d') ?>" required>
                </div>
                <div class="col-sm-4">
                    <small>Expected Delivery time</small>
                    <input type="time" name="expected_time" class="form-control form-control-sm" required>
                </div>
                <div class="col-sm-6">
                     <small>Reason</small>
                    <select name="occasion" class="form-select form-select-sm">
                        <option value="Birthday" <?= ($_POST['occasion'] ?? '') == 'Birthday' ? 'selected' : '' ?>>Birthday</option>
                        <option value="Anniversary" <?= ($_POST['occasion'] ?? '') == 'Anniversary' ? 'selected' : '' ?>>Anniversary</option>
                        <option value="Wedding" <?= ($_POST['occasion'] ?? '') == 'Wedding' ? 'selected' : '' ?>>Wedding</option>
                        <option value="Other" <?= ($_POST['occasion'] ?? '') == 'Other' ? 'selected' : '' ?>>Other</option>
                    </select>
                </div>
                <div class="col-sm-6">
                     <small>Status</small>
                    <select name="status" class="form-select form-select-sm">
                        <option value="pending" <?= ($_POST['status'] ?? '') == 'pending' ? 'selected' : '' ?>>Pending</option>
                        <option value="confirmed" <?= ($_POST['status'] ?? '') == 'confirmed' ? 'selected' : '' ?>>Confirmed</option>
                        <option value="preparing" <?= ($_POST['status'] ?? '') == 'preparing' ? 'selected' : '' ?>>Preparing</option>
                        <option value="ready" <?= ($_POST['status'] ?? '') == 'ready' ? 'selected' : '' ?>>Ready</option>
                    </select>
                </div>
                <div class="col-12 mt-2">
                    <small>Description </small>
                    <textarea name="special_notes" class="form-control form-control-sm" rows="3"
                              placeholder="Message on cake, flavor, design..."><?= $_POST['special_notes'] ?? '' ?></textarea>
                </div>
                <div class="col-12 text-end mt-3">
                    <a href="pre_orders.php" class="btn btn-outline-secondary btn-sm me-2">Cancel</a>
                    <button type="submit" class="btn btn-primary btn-sm px-4">
                        <i class="fas fa-save fa-icon"></i> Create Pre-Order
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>
<script>
// Auto-fill price from datalist
document.getElementById('product_name').addEventListener('input', function() {
    const val = this.value.trim();
    const option = document.querySelector(`#cakeList option[value="${val}"]`);
    if (option && option.dataset.price) {
        document.getElementById('price_per_unit').value = option.dataset.price;
    }
    calculate();
});
// Calculate total
function calculate() {
    const price = parseFloat(document.getElementById('price_per_unit').value) || 0;
    const qty = parseFloat(document.getElementById('quantity').value) || 0;
    const total = (price * qty).toFixed(2);
   
    document.getElementById('total_amount').value = total;
    document.getElementById('totalDisplay').textContent = total;
    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);
}
// Attach events
['price_per_unit', 'quantity', 'advance_amount'].forEach(id => {
    document.getElementById(id).addEventListener('input', () => {
        calculate();
        calcBalance();
    });
});
// Initial calc
calculate();
</script>
<?php include './partials/layouts/layoutBottom.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: create_preorder.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation