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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: create-bill.php

<!doctype html>
<html lang="en">

<?php 
include('includes/head.php');
include('includes/db_connection.php');

session_start();

// Initialize variables
$error_message = '';
$success_message = '';
$sale_data = null;

// Get all active medicines for the select dropdown
$medicines = [];
try {
    $medicines_stmt = $conn->prepare("
        SELECT m.*, mc.category_name 
        FROM medicines m 
        LEFT JOIN medicine_categories mc ON m.category_id = mc.id 
        WHERE m.status = 'active' AND m.stock_quantity > 0 
        ORDER BY m.medicine_name
    ");
    $medicines_stmt->execute();
    $medicines_result = $medicines_stmt->get_result();
    
    while ($medicine = $medicines_result->fetch_assoc()) {
        $medicines[] = $medicine;
    }
} catch (Exception $e) {
    $error_message = "Error loading medicines: " . $e->getMessage();
}

// Process form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        $conn->begin_transaction();
        
        // Get form data
        $customer_name = trim($_POST['customer_name'] ?? '');
        $customer_phone = trim($_POST['customer_phone'] ?? '');
        $payment_method = $_POST['payment_method'] ?? 'cash';
        $cart_items = $_POST['cart_items'] ?? [];
        
        if (empty($cart_items)) {
            throw new Exception("No items in cart");
        }
        
        // Calculate totals
        $subtotal = 0;
        $sale_items = [];
        
        foreach ($cart_items as $item) {
            $medicine_id = (int)$item['medicine_id'];
            $quantity = (int)$item['quantity'];
            $price = (float)$item['price'];
            
            // Validate stock
            $stock_stmt = $conn->prepare("SELECT stock_quantity, medicine_name FROM medicines WHERE id = ? AND status = 'active'");
            $stock_stmt->bind_param("i", $medicine_id);
            $stock_stmt->execute();
            $stock_result = $stock_stmt->get_result();
            
            if ($stock_result->num_rows === 0) {
                throw new Exception("Medicine not found or inactive");
            }
            
            $medicine = $stock_result->fetch_assoc();
            if ($medicine['stock_quantity'] < $quantity) {
                throw new Exception("Insufficient stock for {$medicine['medicine_name']}. Available: {$medicine['stock_quantity']}");
            }
            
            $item_total = $price * $quantity;
            $subtotal += $item_total;
            
            $sale_items[] = [
                'medicine_id' => $medicine_id,
                'quantity' => $quantity,
                'price' => $price,
                'subtotal' => $item_total
            ];
        }
        
        // Total amount (no tax)
        $total_amount = $subtotal;
        
        // Create sale record - FIXED: Remove subtotal_amount column
        $sale_stmt = $conn->prepare("
            INSERT INTO sales (sale_date, total_amount, payment_method, customer_name, customer_phone, status) 
            VALUES (NOW(), ?, ?, ?, ?, 'completed')
        ");
        $sale_stmt->bind_param("dsss", $total_amount, $payment_method, $customer_name, $customer_phone);
        $sale_stmt->execute();
        $sale_id = $conn->insert_id;
        
        // Create sale items and update stock
        foreach ($sale_items as $item) {
            // Insert sale item
            $item_stmt = $conn->prepare("
                INSERT INTO sale_items (sale_id, medicine_id, quantity, unit_price, subtotal) 
                VALUES (?, ?, ?, ?, ?)
            ");
            $item_stmt->bind_param("iiidd", $sale_id, $item['medicine_id'], $item['quantity'], $item['price'], $item['subtotal']);
            $item_stmt->execute();
            
            // Update medicine stock
            $update_stmt = $conn->prepare("
                UPDATE medicines 
                SET stock_quantity = stock_quantity - ? 
                WHERE id = ?
            ");
            $update_stmt->bind_param("ii", $item['quantity'], $item['medicine_id']);
            $update_stmt->execute();
        }
        
        $conn->commit();
        
        // Store sale info for receipt
        $sale_data = [
            'sale_id' => $sale_id,
            'sale_date' => date('Y-m-d H:i:s'),
            'customer_name' => $customer_name,
            'customer_phone' => $customer_phone,
            'payment_method' => $payment_method,
            'subtotal' => $subtotal,
            'total_amount' => $total_amount,
            'items' => $sale_items
        ];
        
        $success_message = "Bill created successfully! Sale #{$sale_id}";
        
        // Store sale ID in session for auto-print
        $_SESSION['last_sale_id'] = $sale_id;
        
    } catch (Exception $e) {
        $conn->rollback();
        $error_message = "Error creating bill: " . $e->getMessage();
    }
}

// Get recent sales for display
$recent_sales = [];
try {
    $sales_stmt = $conn->prepare("
        SELECT s.*, COUNT(si.id) as item_count 
        FROM sales s 
        LEFT JOIN sale_items si ON s.id = si.sale_id 
        WHERE s.status = 'completed' 
        GROUP BY s.id 
        ORDER BY s.sale_date DESC 
        LIMIT 10
    ");
    $sales_stmt->execute();
    $sales_result = $sales_stmt->get_result();
    
    while ($sale = $sales_result->fetch_assoc()) {
        $recent_sales[] = $sale;
    }
} catch (Exception $e) {
    // Silently handle error for recent sales display
}
?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php if ($success_message): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo $success_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if ($error_message): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo $error_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">
                                    <i class="mdi mdi-receipt me-2"></i>Create New Bill
                                </h4>

<form method="POST" id="create-bill-form">
                                    
                                    <div class="row mb-4">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Customer Name <span class="text-muted">(Optional)</span></label>
                                                <input type="text" class="form-control" name="customer_name" 
                                                       placeholder="Enter customer name" value="<?php echo htmlspecialchars($_POST['customer_name'] ?? ''); ?>">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Customer Phone <span class="text-muted">(Optional)</span></label>
                                                <input type="text" class="form-control" name="customer_phone" 
                                                       placeholder="Enter phone number" value="<?php echo htmlspecialchars($_POST['customer_phone'] ?? ''); ?>">
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-12">
                                            <h5 class="mb-3">
                                                <i class="mdi mdi-cart-plus me-2"></i>Add Products
                                            </h5>
                                            
                                            <div class="card bg-light">
                                                <div class="card-body">
                                                    <div class="row g-3">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label class="form-label">Select Medicine <span class="text-danger">*</span></label>
                                                                <select class="form-select" id="medicine-select">
                                                                    <option value="">-- Select Medicine --</option>
                                                                    <?php foreach ($medicines as $medicine): ?>
                                                                        <option value="<?php echo $medicine['id']; ?>" 
                                                                                data-price="<?php echo $medicine['selling_price']; ?>"
                                                                                data-stock="<?php echo $medicine['stock_quantity']; ?>"
                                                                                data-batch="<?php echo htmlspecialchars($medicine['batch_number']); ?>"
                                                                                data-prescription="<?php echo $medicine['requires_prescription']; ?>">
                                                                            <?php echo htmlspecialchars($medicine['medicine_name']); ?> 
                                                                            - ₹<?php echo $medicine['selling_price']; ?> 
                                                                            (Stock: <?php echo $medicine['stock_quantity']; ?>)
                                                                        </option>
                                                                    <?php endforeach; ?>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-4">
                                                            <div class="mb-3">
                                                                <label class="form-label">Quantity <span class="text-danger">*</span></label>
                                                                <input type="number" class="form-control" id="quantity-input" 
                                                                       placeholder="Qty" min="1" value="1">
                                                            </div>
                                                        </div>
                                                        <div class="col-md-2">
                                                            <div class="mb-3">
                                                                <label class="form-label">&nbsp;</label>
                                                                <button type="button" class="btn btn-success w-100" id="add-to-bill-btn">
                                                                    <i class="mdi mdi-plus"></i> Add
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="row">
                                                        <div class="col-12">
                                                            <small class="text-muted" id="medicine-info"></small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-12">
                                            <h5 class="mb-3">
                                                <i class="mdi mdi-cart me-2"></i>Cart Items
                                                <span class="badge bg-primary ms-2" id="cart-items-count">0 items</span>
                                            </h5>
                                            
                                            <div id="empty-cart-message" class="alert alert-warning">
                                                <i class="mdi mdi-cart-off me-2"></i>
                                                No items in cart. Add products using the form above.
                                            </div>

<div id="cart-items-container" style="display: none;">
                                                <div class="table-responsive">
                                                    <table class="table table-sm table-centered mb-0">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Product</th>
                                                                <th>Batch</th>
                                                                <th>Price</th>
                                                                <th>Qty</th>
                                                                <th>Total</th>
                                                                <th>Action</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody id="cart-items-table">
                                                            
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Payment Method <span class="text-danger">*</span></label>
                                                <select class="form-select" name="payment_method" required>
                                                    <option value="cash" <?php echo ($_POST['payment_method'] ?? 'cash') === 'cash' ? 'selected' : ''; ?>>Cash</option>
                                                    <option value="card" <?php echo ($_POST['payment_method'] ?? '') === 'card' ? 'selected' : ''; ?>>Card</option>
                                                    <option value="upi" <?php echo ($_POST['payment_method'] ?? '') === 'upi' ? 'selected' : ''; ?>>UPI</option>
                                                    <option value="online" <?php echo ($_POST['payment_method'] ?? '') === 'online' ? 'selected' : ''; ?>>Online</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Sale Date</label>
                                                <input type="text" class="form-control" value="<?php echo date('Y-m-d H:i:s'); ?>" readonly>
                                                <small class="text-muted">Current date and time</small>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-12">
                                            <div class="border-top pt-3">
                                                <div class="row mb-3 border-top pt-2">
                                                    <div class="col-6">
                                                        <span class="fw-bold fs-5">Total Amount:</span>
                                                    </div>
                                                    <div class="col-6 text-end">
                                                        <span class="fw-bold fs-4 text-success">₹<span id="bill-total">0.00</span></span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-12">
                                            <button type="submit" class="btn btn-success btn-lg w-100" id="create-bill-btn" disabled>
                                                <i class="mdi mdi-receipt me-2"></i> 
                                                Create Bill - ₹<span id="bill-total-btn">0.00</span>
                                            </button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">
                                    <i class="mdi mdi-history me-2"></i>Recent Sales
                                </h5>
                                
                                <?php if (empty($recent_sales)): ?>
                                    <div class="text-center py-3">
                                        <i class="mdi mdi-receipt display-4 text-muted"></i>
                                        <p class="text-muted mt-2">No recent sales</p>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive" style="max-height: 300px;">
                                        <table class="table table-sm table-centered mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Sale ID</th>
                                                    <th>Date</th>
                                                    <th>Amount</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($recent_sales as $sale): ?>
                                                    <tr>
                                                        <td>#<?php echo $sale['id']; ?></td>
                                                        <td><?php echo date('M j, g:i A', strtotime($sale['sale_date'])); ?></td>
                                                        <td>₹<?php echo number_format($sale['total_amount'], 2); ?></td>
                                                        <td>
                                                            <a href="receipt.php?sale_id=<?php echo $sale['id']; ?>" 
                                                               class="btn btn-sm btn-outline-primary" target="_blank">
                                                                <i class="mdi mdi-printer"></i>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Quick Actions</h5>
                                <div class="row g-2">
                                    <div class="col-6">
                                        <a href="pos.php" class="btn btn-outline-primary w-100 btn-sm">
                                            <i class="mdi mdi-cart-plus me-1"></i> POS
                                        </a>
                                    </div>
                                    <div class="col-6">
                                        <a href="sales-report.php" class="btn btn-outline-info w-100 btn-sm">
                                            <i class="mdi mdi-chart-bar me-1"></i> Reports
                                        </a>
                                    </div>
                                    <div class="col-6">
                                        <a href="customers-list.php" class="btn btn-outline-success w-100 btn-sm">
                                            <i class="mdi mdi-account-group me-1"></i> Customers
                                        </a>
                                    </div>
                                    <div class="col-6">
                                        <a href="medicines-list.php" class="btn btn-outline-warning w-100 btn-sm">
                                            <i class="mdi mdi-pill me-1"></i> Medicines
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>

<?php if ($sale_data): ?>
                            <div class="card mt-3 border-success">
                                <div class="card-body">
                                    <h5 class="card-title text-success">
                                        <i class="mdi mdi-check-circle me-2"></i>Bill Created
                                    </h5>
                                    <div class="bill-preview">
                                        <p><strong>Sale ID:</strong> #<?php echo $sale_data['sale_id']; ?></p>
                                        <p><strong>Customer:</strong> <?php echo $sale_data['customer_name'] ?: 'Walk-in Customer'; ?></p>
                                        <p><strong>Total:</strong> ₹<?php echo number_format($sale_data['total_amount'], 2); ?></p>
                                        <p><strong>Payment:</strong> <?php echo ucfirst($sale_data['payment_method']); ?></p>
                                        
                                        <div class="mt-3">
                                            <a href="receipt.php?sale_id=<?php echo $sale_data['sale_id']; ?>" 
                                               class="btn btn-success w-100" target="_blank">
                                                <i class="mdi mdi-printer me-2"></i> Print Receipt
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php')?>
    </div>
</div>

<?php include('includes/rightbar.php')?>
<?php include('includes/scripts.php')?>

<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>

// Auto-print functionality
function autoPrintReceipt(saleId) {
    // Open receipt in new window/tab
    const receiptWindow = window.open(`receipt.php?sale_id=${saleId}&auto_print=true`, '_blank');
    
    // Wait for the window to load and trigger print
    if (receiptWindow) {
        receiptWindow.onload = function() {
            setTimeout(() => {
                receiptWindow.print();
                // Optional: Close window after print dialog shows
                // receiptWindow.onafterprint = function() {
                //     receiptWindow.close();
                // };
            }, 500);
        };
    }
}

// Initialize the page
document.addEventListener('DOMContentLoaded', function() {
    initializeSelect2();
    updateCartDisplay();
    attachEventListeners();
    
    // Auto-focus on medicine select
    setTimeout(() => {
        $('#medicine-select').select2('focus');
    }, 100);
    
    // If we have a successful sale, clear the cart and auto-print
    <?php if ($sale_data && isset($_SESSION['last_sale_id'])): ?>
        clearCart();
        setTimeout(() => {
            autoPrintReceipt(<?php echo $_SESSION['last_sale_id']; ?>);
            // Clear the session variable so it doesn't print again on refresh
            <?php unset($_SESSION['last_sale_id']); ?>
        }, 1000);
    <?php endif; ?>
});

// Initialize Select2
function initializeSelect2() {
    $('#medicine-select').select2({
        placeholder: '-- Select Medicine --',
        width: '100%',
        allowClear: true
    });
    
    // When medicine is selected, auto-focus on quantity
    $('#medicine-select').on('select2:select', function(e) {
        setTimeout(() => {
            $('#quantity-input').focus().select();
        }, 100);
    });
}

// Update cart display
function updateCartDisplay() {
    const cartItemsTable = document.getElementById('cart-items-table');
    const emptyCartMessage = document.getElementById('empty-cart-message');
    const cartItemsContainer = document.getElementById('cart-items-container');
    const cartItemsCount = document.getElementById('cart-items-count');
    const createBillBtn = document.getElementById('create-bill-btn');
    
    let subtotal = 0;
    let html = '';
    let itemCount = 0;
    
    // Clear existing items
    cartItemsTable.innerHTML = '';
    
    // Add cart items to table
    for (const medicineId in cart) {
        const item = cart[medicineId];
        const itemTotal = item.price * item.quantity;
        subtotal += itemTotal;
        itemCount++;
        
        html += `
            <tr id="cart-item-${medicineId}">
                <td>
                    <small class="fw-bold">${escapeHtml(item.name)}</small>
                    ${item.requires_prescription ? '<br><span class="badge bg-info badge-sm">Rx</span>' : ''}
                </td>
                <td>
                    <small class="text-muted">${escapeHtml(item.batch_number)}</small>
                </td>
                <td>₹${item.price.toFixed(2)}</td>
                <td>${item.quantity}</td>
                <td>₹${itemTotal.toFixed(2)}</td>
                <td>
                    <button type="button" class="btn btn-sm btn-outline-danger remove-item-btn" 
                            onclick="removeItem(${medicineId})">
                        <i class="mdi mdi-delete"></i>
                    </button>
                </td>
            </tr>
        `;
    }
    
    cartItemsTable.innerHTML = html;
    
    // Update totals (no tax)
    const total = subtotal;
    
    document.getElementById('bill-total').textContent = total.toFixed(2);
    document.getElementById('bill-total-btn').textContent = total.toFixed(2);
    
    // Show/hide empty cart message
    if (itemCount === 0) {
        emptyCartMessage.style.display = 'block';
        cartItemsContainer.style.display = 'none';
        createBillBtn.disabled = true;
    } else {
        emptyCartMessage.style.display = 'none';
        cartItemsContainer.style.display = 'block';
        createBillBtn.disabled = false;
    }
    
    cartItemsCount.textContent = itemCount + ' items';
    
    // Update hidden form fields
    updateCartFormFields();
}

// Update hidden form fields with cart data
function updateCartFormFields() {
    const form = document.getElementById('create-bill-form');
    
    // Remove existing cart item fields
    const existingFields = form.querySelectorAll('input[name^="cart_items"]');
    existingFields.forEach(field => field.remove());
    
    // Add new cart item fields
    let index = 0;
    for (const medicineId in cart) {
        const item = cart[medicineId];
        
        const medicineIdField = document.createElement('input');
        medicineIdField.type = 'hidden';
        medicineIdField.name = `cart_items[${index}][medicine_id]`;
        medicineIdField.value = medicineId;
        form.appendChild(medicineIdField);
        
        const quantityField = document.createElement('input');
        quantityField.type = 'hidden';
        quantityField.name = `cart_items[${index}][quantity]`;
        quantityField.value = item.quantity;
        form.appendChild(quantityField);
        
        const priceField = document.createElement('input');
        priceField.type = 'hidden';
        priceField.name = `cart_items[${index}][price]`;
        priceField.value = item.price;
        form.appendChild(priceField);
        
        index++;
    }
}

// Add product to cart
function addProductToCart() {
    const medicineSelect = document.getElementById('medicine-select');
    const quantityInput = document.getElementById('quantity-input');
    const selectedOption = medicineSelect.options[medicineSelect.selectedIndex];
    
    if (!selectedOption.value) {
        alert('Please select a medicine');
        $('#medicine-select').select2('focus');
        return;
    }
    
    const medicineId = parseInt(selectedOption.value);
    const medicineName = selectedOption.text.split(' - ')[0]; // Get only medicine name
    const price = parseFloat(selectedOption.getAttribute('data-price'));
    const stock = parseInt(selectedOption.getAttribute('data-stock'));
    const batchNumber = selectedOption.getAttribute('data-batch');
    const requiresPrescription = parseInt(selectedOption.getAttribute('data-prescription'));
    const quantity = parseInt(quantityInput.value) || 1;
    
    // Validate quantity
    if (quantity < 1) {
        alert('Please enter a valid quantity');
        quantityInput.focus();
        return;
    }
    
    if (quantity > stock) {
        alert(`Only ${stock} units available for ${medicineName}`);
        quantityInput.focus();
        return;
    }
    
    // Add to cart
    if (cart[medicineId]) {
        cart[medicineId].quantity += quantity;
        // Ensure we don't exceed stock
        if (cart[medicineId].quantity > stock) {
            cart[medicineId].quantity = stock;
            alert(`Maximum ${stock} units available for ${medicineName}. Quantity adjusted.`);
        }
    } else {
        cart[medicineId] = {
            name: medicineName,
            batch_number: batchNumber,
            price: price,
            quantity: quantity,
            stock: stock,
            requires_prescription: requiresPrescription
        };
    }
    
    updateCartDisplay();
    
    // Reset form and focus back on medicine select
    $('#medicine-select').val('').trigger('change');
    quantityInput.value = 1;
    document.getElementById('medicine-info').textContent = '';
    
    // Auto-focus back on medicine select for next product
    setTimeout(() => {
        $('#medicine-select').select2('focus');
    }, 100);
}

// Remove item from cart
function removeItem(medicineId) {
    if (confirm('Remove this item from cart?')) {
        delete cart[medicineId];
        updateCartDisplay();
    }
}

// Clear entire cart
function clearCart() {
    cart = {};
    updateCartDisplay();
}

// Attach event listeners
function attachEventListeners() {
    // Add to bill button
    document.getElementById('add-to-bill-btn').addEventListener('click', addProductToCart);
    
    // Quantity input - Enter key to add product
    document.getElementById('quantity-input').addEventListener('keypress', function(e) {
        if (e.key === 'Enter') {
            e.preventDefault();
            addProductToCart();
        }
    });
    
    // Medicine select change - update info
    document.getElementById('medicine-select').addEventListener('change', function() {
        const selectedOption = this.options[this.selectedIndex];
        const infoElement = document.getElementById('medicine-info');
        
        if (selectedOption.value) {
            const price = selectedOption.getAttribute('data-price');
            const stock = selectedOption.getAttribute('data-stock');
            const batch = selectedOption.getAttribute('data-batch');
            const prescription = selectedOption.getAttribute('data-prescription');
            
            let info = `Price: ₹${price} | Stock: ${stock} | Batch: ${batch}`;
            if (prescription === '1') {
                info += ' | Prescription Required';
            }
            
            infoElement.textContent = info;
        } else {
            infoElement.textContent = '';
        }
    });
    
    // Form submission
    document.getElementById('create-bill-form').addEventListener('submit', function(e) {
        const itemCount = Object.keys(cart).length;
        if (itemCount === 0) {
            e.preventDefault();
            alert('Please add items to cart before creating a bill.');
            $('#medicine-select').select2('focus');
            return;
        }
        
        // Show loading state
        const submitBtn = document.getElementById('create-bill-btn');
        submitBtn.disabled = true;
        submitBtn.innerHTML = '<i class="mdi mdi-loading mdi-spin me-2"></i> Creating Bill...';
    });
}

// Utility function to escape HTML
function escapeHtml(unsafe) {
    if (unsafe === null || unsafe === undefined) return '';
    return String(unsafe)
        .replace(/&/g, "&amp;")
        .replace(/</g, "&lt;")
        .replace(/>/g, "&gt;")
        .replace(/\"/g, "&quot;")
        .replace(/'/g, "&#039;");
}
</script>

.product-card {
    transition: transform 0.2s;
}

.product-card:hover {
    transform: translateY(-2px);
}

.cart-item-quantity {
    width: 60px;
    text-align: center;
}

/* Select2 customization */
.select2-container--default .select2-selection--single {
    height: 38px;
    padding: 6px 12px;
}

.select2-container--default .select2-selection--single .select2-selection__arrow {
    height: 36px;
}

/* Print styles for receipt */
@media print {
    .no-print {
        display: none !important;
    }
    
    .card {
        border: none !important;
        box-shadow: none !important;
    }
}
</style>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: create-bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation