Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/medical/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: pos.php

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

// Error logging function
function logError($message) {
    $logFile = __DIR__ . '/pos_errors.log';
    $timestamp = date('Y-m-d H:i:s');
    $logMessage = "[$timestamp] $message\n";
    error_log($logMessage, 3, $logFile);
}

// Set error handler
set_error_handler(function($errno, $errstr, $errfile, $errline) {
    logError("PHP Error [$errno]: $errstr in $errfile on line $errline");
});

// Set exception handler
set_exception_handler(function($exception) {
    logError("Uncaught Exception: " . $exception->getMessage() . " in " . $exception->getFile() . " on line " . $exception->getLine());
});

// If it's an AJAX request, handle it immediately
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['ajax'])) {
    // Turn off all error reporting for AJAX
    error_reporting(0);
    ini_set('display_errors', 0);
    
    // Set JSON header
    header('Content-Type: application/json; charset=utf-8');
    
    // Start output buffering
    ob_start();
    
    $action = $_POST['action'] ?? '';
    $response = ['success' => false, 'message' => 'Unknown action'];
    
    try {
        switch($action) {
            case 'test_json':
                $response = [
                    'success' => true,
                    'message' => 'JSON test successful',
                    'timestamp' => date('Y-m-d H:i:s')
                ];
                break;
                
            case 'search_products':
                $search_query = trim($_POST['search_query'] ?? '');
                $category_filter = (int)($_POST['category_filter'] ?? 0);
                
                $sql = "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";
                
                $params = [];
                $types = '';
                
                if (!empty($search_query)) {
                    $sql .= " AND (m.medicine_name LIKE ? OR m.generic_name LIKE ? OR m.batch_number LIKE ?)";
                    $search_param = "%$search_query%";
                    $params = array_merge($params, [$search_param, $search_param, $search_param]);
                    $types .= 'sss';
                }
                
                if ($category_filter > 0) {
                    $sql .= " AND m.category_id = ?";
                    $params[] = $category_filter;
                    $types .= 'i';
                }
                
                $sql .= " ORDER BY m.medicine_name LIMIT 50";
                
                $stmt = $conn->prepare($sql);
                if ($params) {
                    $stmt->bind_param($types, ...$params);
                }
                $stmt->execute();
                $result = $stmt->get_result();
                
                $products = [];
                while ($row = $result->fetch_assoc()) {
                    $products[] = $row;
                }
                
                $response = ['success' => true, 'products' => $products];
                break;
                
            case 'add_to_cart':
                $medicine_id = (int)($_POST['medicine_id'] ?? 0);
                $quantity = max(1, (int)($_POST['quantity'] ?? 1));
                
                $stmt = $conn->prepare("SELECT * FROM medicines WHERE id = ? AND status = 'active'");
                $stmt->bind_param("i", $medicine_id);
                $stmt->execute();
                $result = $stmt->get_result();
                
                if ($result->num_rows === 0) {
                    $response = ['success' => false, 'message' => 'Product not found'];
                    break;
                }
                
                $product = $result->fetch_assoc();
                
                if ($product['stock_quantity'] < $quantity) {
                    $response = ['success' => false, 'message' => "Only {$product['stock_quantity']} units available"];
                    break;
                }
                
                if (!isset($_SESSION['pos_cart'])) {
                    $_SESSION['pos_cart'] = [];
                }
                
                if (isset($_SESSION['pos_cart'][$medicine_id])) {
                    $_SESSION['pos_cart'][$medicine_id]['quantity'] += $quantity;
                    if ($_SESSION['pos_cart'][$medicine_id]['quantity'] > $product['stock_quantity']) {
                        $_SESSION['pos_cart'][$medicine_id]['quantity'] = $product['stock_quantity'];
                    }
                } else {
                    $_SESSION['pos_cart'][$medicine_id] = [
                        'name' => $product['medicine_name'],
                        'batch_number' => $product['batch_number'],
                        'price' => (float)$product['selling_price'],
                        'quantity' => $quantity,
                        'stock' => (int)$product['stock_quantity'],
                        'requires_prescription' => (int)$product['requires_prescription']
                    ];
                }
                
                $response = [
                    'success' => true,
                    'message' => "{$product['medicine_name']} added to cart!",
                    'cart_count' => count($_SESSION['pos_cart']),
                    'cart' => $_SESSION['pos_cart']
                ];
                break;
                
            case 'get_cart':
                $response = [
                    'success' => true,
                    'cart' => $_SESSION['pos_cart'] ?? []
                ];
                break;
                
            case 'update_cart':
                $medicine_id = (int)($_POST['medicine_id'] ?? 0);
                $quantity = max(0, (int)($_POST['quantity'] ?? 0));
                
                if (!isset($_SESSION['pos_cart'])) {
                    $_SESSION['pos_cart'] = [];
                }
                
                if ($quantity <= 0) {
                    unset($_SESSION['pos_cart'][$medicine_id]);
                } else {
                    if (isset($_SESSION['pos_cart'][$medicine_id])) {
                        $_SESSION['pos_cart'][$medicine_id]['quantity'] = $quantity;
                    }
                }
                
                $response = [
                    'success' => true,
                    'cart' => $_SESSION['pos_cart']
                ];
                break;
                
            case 'remove_from_cart':
                $medicine_id = (int)($_POST['medicine_id'] ?? 0);
                
                if (!isset($_SESSION['pos_cart'])) {
                    $_SESSION['pos_cart'] = [];
                }
                
                if (isset($_SESSION['pos_cart'][$medicine_id])) {
                    unset($_SESSION['pos_cart'][$medicine_id]);
                    $response = [
                        'success' => true,
                        'message' => 'Item removed from cart',
                        'cart' => $_SESSION['pos_cart']
                    ];
                } else {
                    $response = ['success' => false, 'message' => 'Item not in cart'];
                }
                break;
                
            case 'clear_cart':
                $_SESSION['pos_cart'] = [];
                $response = [
                    'success' => true,
                    'message' => 'Cart cleared',
                    'cart' => $_SESSION['pos_cart']
                ];
                break;
                
            case 'process_sale':
                $customer_name = trim($_POST['customer_name'] ?? '');
                $customer_phone = trim($_POST['customer_phone'] ?? '');
                $payment_method = $_POST['payment_method'] ?? 'cash';
                $prescription_details_json = $_POST['prescription_details'] ?? '{}';
                $prescription_details = json_decode($prescription_details_json, true);
                
                if (!isset($_SESSION['pos_cart']) || empty($_SESSION['pos_cart'])) {
                    echo json_encode(['success' => false, 'message' => 'Cart is empty']);
                    exit;
                }
                
                $cart = $_SESSION['pos_cart'];

// Check if prescription details are provided for prescription-required medicines
                $prescription_required = false;
                foreach ($cart as $medicine_id => $item) {
                    if ($item['requires_prescription']) {
                        $prescription_required = true;
                        if (empty(trim($prescription_details['doctor_name'] ?? ''))) {
                            $response = [
                                'success' => false, 
                                'message' => "Doctor name is required for prescription medicines"
                            ];
                            echo json_encode($response);
                            exit;
                        }
                    }
                }

$conn->begin_transaction();

// Calculate totals
                $subtotal = 0;
                foreach ($cart as $medicine_id => $item) {
                    $subtotal += $item['price'] * $item['quantity'];
                }

// Insert sale
                $stmt = $conn->prepare("
                    INSERT INTO sales (sale_date, total_amount, subtotal_amount, payment_method, 
                                      customer_name, customer_phone, status)
                    VALUES (NOW(), ?, ?, ?, ?, ?, 'completed')
                ");
                
                $stmt->bind_param("ddsss", $subtotal, $subtotal, $payment_method, $customer_name, $customer_phone);
                $stmt->execute();
                $sale_id = $stmt->insert_id;

// Insert sale items and update stock
                foreach ($cart as $medicine_id => $item) {
                    $item_subtotal = $item['price'] * $item['quantity'];
                    
                    // 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, $medicine_id, $item['quantity'], $item['price'], $item_subtotal);
                    $item_stmt->execute();

// Update stock
                    $stock_stmt = $conn->prepare("
                        UPDATE medicines 
                        SET stock_quantity = stock_quantity - ? 
                        WHERE id = ? AND stock_quantity >= ?
                    ");
                    $stock_stmt->bind_param("iii", $item['quantity'], $medicine_id, $item['quantity']);
                    $stock_stmt->execute();
                    
                    if ($stock_stmt->affected_rows === 0) {
                        throw new Exception("Insufficient stock for medicine ID: $medicine_id");
                    }

// Insert prescription details if required
                    if ($item['requires_prescription'] && !empty($prescription_details['doctor_name'])) {
                        $presc_stmt = $conn->prepare("
                            INSERT INTO prescription_details 
                            (sale_id, medicine_id, doctor_name, doctor_license, patient_name, prescription_date)
                            VALUES (?, ?, ?, ?, ?, ?)
                        ");
                        $doctor_license = trim($prescription_details['doctor_license'] ?? '');
                        $patient_name = trim($prescription_details['patient_name'] ?? '');
                        $prescription_date = !empty($prescription_details['prescription_date']) ? $prescription_details['prescription_date'] : date('Y-m-d');
                        
                        $presc_stmt->bind_param(
                            "iissss", 
                            $sale_id, 
                            $medicine_id, 
                            trim($prescription_details['doctor_name']),
                            $doctor_license,
                            $patient_name,
                            $prescription_date
                        );
                        $presc_stmt->execute();
                    }
                }

// Update customer if phone provided
                if (!empty($customer_phone)) {
                    $customer_stmt = $conn->prepare("
                        INSERT INTO customers (customer_name, customer_phone, total_purchases, last_purchase_date)
                        VALUES (?, ?, ?, NOW())
                        ON DUPLICATE KEY UPDATE 
                            customer_name = VALUES(customer_name),
                            total_purchases = total_purchases + VALUES(total_purchases),
                            last_purchase_date = NOW()
                    ");
                    $customer_stmt->bind_param("ssd", $customer_name, $customer_phone, $subtotal);
                    $customer_stmt->execute();
                }

$conn->commit();
                
                // Store sale ID in session for receipt
                $_SESSION['last_sale_id'] = $sale_id;
                
                // Clear cart
                $_SESSION['pos_cart'] = [];

$response = [
                    'success' => true,
                    'sale_id' => $sale_id,
                    'message' => 'Sale processed successfully'
                ];
                break;
                
            default:
                $response = ['success' => false, 'message' => 'Invalid action: ' . $action];
        }
    } catch (Exception $e) {
        if (isset($conn) && $conn instanceof mysqli) {
            $conn->rollback();
        }
        $response = ['success' => false, 'message' => 'Server error: ' . $e->getMessage()];
    }
    
    // Clean output buffer and send response
    ob_end_clean();
    echo json_encode($response);
    exit;
}

// Normal page load continues below...

// Initialize cart in session
if (!isset($_SESSION['pos_cart']) || !is_array($_SESSION['pos_cart'])) {
    $_SESSION['pos_cart'] = [];
}

// Get categories for filter
$categories = [];
try {
    $categories_result = $conn->query("SELECT id, category_name FROM medicine_categories WHERE status = 'active' ORDER BY category_name");
    if ($categories_result) {
        while ($category = $categories_result->fetch_assoc()) {
            $categories[] = $category;
        }
    }
} catch (Exception $e) {
    $categories = [
        ['id' => 1, 'category_name' => 'General']
    ];
}

// Calculate cart totals
$cart_total = 0;
$cart_items_count = 0;
$prescription_required_count = 0;
foreach ($_SESSION['pos_cart'] as $item) {
    $cart_total += $item['price'] * $item['quantity'];
    $cart_items_count += $item['quantity'];
    if ($item['requires_prescription']) {
        $prescription_required_count++;
    }
}
?>

<!doctype html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <title>Point of Sale - Medical Store</title>
    <style>
        .fixed-checkout-bar {
            position: fixed;
            bottom: 0;
            left: 0;
            right: 0;
            background: white;
            border-top: 2px solid #e9ecef;
            padding: 15px;
            box-shadow: 0 -2px 10px rgba(0,0,0,0.1);
            z-index: 1000;
            display: none;
        }
        .fixed-checkout-bar.show {
            display: block;
        }
        body {
            padding-bottom: 120px; /* Space for fixed checkout bar */
        }
        @media (min-width: 992px) {
            .fixed-checkout-bar {
                left: 250px; /* Adjust based on your sidebar width */
            }
            body[data-sidebar="dark"] .fixed-checkout-bar {
                left: 250px;
            }
        }
    </style>
</head>
<body data-sidebar="dark">

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

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                <div class="row">
                    
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title">Products</h4>
                                    <div class="d-flex gap-2">
                                        <a href="medicines-list.php" class="btn btn-outline-primary btn-sm">
                                            <i class="mdi mdi-format-list-bulleted me-1"></i> All Medicines
                                        </a>
                                        <button type="button" id="clear-cart-btn" class="btn btn-outline-danger btn-sm">
                                            <i class="mdi mdi-cart-off me-1"></i> Clear Cart
                                        </button>
                                        <button type="button" id="test-json-btn" class="btn btn-info btn-sm">
                                            <i class="mdi mdi-check me-1"></i> Test JSON
                                        </button>
                                    </div>
                                </div>

<div class="row g-3 mb-4">
                                    <div class="col-md-8">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="search-input" 
                                                   placeholder="Search by medicine name, generic name, or batch number..."
                                                   onclick="clearSearchIfProducts()">
                                            <button class="btn btn-primary" type="button" id="search-btn">
                                                <i class="mdi mdi-magnify me-1"></i> Search
                                                <div class="spinner-border spinner-border-sm loading-spinner ms-1" role="status" style="display: none;">
                                                    <span class="visually-hidden">Loading...</span>
                                                </div>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <select class="form-select" id="category-filter">
                                            <option value="">All Categories</option>
                                            <?php foreach ($categories as $category): ?>
                                                <option value="<?php echo $category['id']; ?>">
                                                    <?php echo htmlspecialchars($category['category_name']); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                </div>

<div class="row" id="products-container">
                                    <div class="col-12 text-center py-4">
                                        <i class="mdi mdi-magnify display-4 text-muted"></i>
                                        <h5 class="mt-2">Search for products</h5>
                                        <p class="text-muted">Use the search bar above to find medicines</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">
                                    Shopping Cart 
                                    <span class="badge bg-primary ms-2" id="cart-count"><?php echo count($_SESSION['pos_cart']); ?> items</span>
                                    <?php if ($prescription_required_count > 0): ?>
                                        <span class="badge bg-warning ms-2" id="prescription-count">
                                            <i class="mdi mdi-file-document"></i> <?php echo $prescription_required_count; ?> Rx
                                        </span>
                                    <?php endif; ?>
                                </h4>

<div id="empty-cart-message" class="text-center py-4" <?php echo !empty($_SESSION['pos_cart']) ? 'style="display:none;"' : ''; ?>>
                                    <i class="mdi mdi-cart-outline display-4 text-muted"></i>
                                    <h5 class="mt-2">Your cart is empty</h5>
                                    <p class="text-muted">Add products from the left panel</p>
                                </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="medicines-list.php" class="btn btn-outline-primary w-100 btn-sm">
                                            <i class="mdi mdi-pill me-1"></i> Medicines
                                        </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="low-stock-alerts.php" class="btn btn-outline-warning w-100 btn-sm">
                                            <i class="mdi mdi-alert me-1"></i> Stock Alerts
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

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

<div class="fixed-checkout-bar" id="fixed-checkout-bar">
    <div class="container-fluid">
        <div class="row align-items-center">
            <div class="col-md-3">
                <div class="d-flex align-items-center">
                    <div class="me-3">
                        <span class="badge bg-primary fs-6" id="fixed-cart-count"><?php echo count($_SESSION['pos_cart']); ?> items</span>
                    </div>
                    <div class="fw-bold fs-5" id="fixed-cart-total">₹<?php echo number_format($cart_total, 2); ?></div>
                </div>
            </div>
            
            <div class="col-md-6">
                <div class="row g-2">
                    <div class="col-md-4">
                        <input type="text" class="form-control form-control-sm" id="fixed-customer-name" 
                               placeholder="Customer Name">
                    </div>
                    <div class="col-md-4">
                        <input type="text" class="form-control form-control-sm" id="fixed-customer-phone" 
                               placeholder="Phone Number">
                    </div>
                    <div class="col-md-4">
                        <select class="form-select form-select-sm" id="fixed-payment-method">
                            <option value="cash">Cash</option>
                            <option value="card">Card</option>
                            <option value="upi">UPI</option>
                            <option value="online">Online</option>
                        </select>
                    </div>
                </div>
            </div>
            
            <div class="col-md-3">
                <button type="button" id="fixed-process-sale-btn" class="btn btn-success btn-lg w-100">
                    <i class="mdi mdi-point-of-sale me-2"></i> 
                    Process Sale
                </button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="prescriptionModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header bg-warning">
                <h5 class="modal-title text-white">
                    <i class="mdi mdi-file-document me-2"></i>
                    Prescription Details Required
                </h5>
                <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div class="alert alert-info mb-3">
                    <i class="mdi mdi-information me-2"></i>
                    <strong>Note:</strong> The same doctor details will be used for all prescription medicines in this sale.
                </div>
                
                <form id="prescription-form">
                    <div class="row g-3">
                        <div class="col-12">
                            <label class="form-label">Doctor Name <span class="text-danger">*</span></label>
                            <input type="text" class="form-control" id="modal-doctor-name" 
                                   placeholder="Dr. Name" required>
                        </div>
                        <div class="col-12">
                            <label class="form-label">Doctor License (Optional)</label>
                            <input type="text" class="form-control" id="modal-doctor-license" 
                                   placeholder="License Number">
                        </div>
                        <div class="col-12">
                            <label class="form-label">Patient Name (Optional)</label>
                            <input type="text" class="form-control" id="modal-patient-name" 
                                   placeholder="Patient Name">
                        </div>
                        <div class="col-12">
                            <label class="form-label">Prescription Date</label>
                            <input type="date" class="form-control" id="modal-prescription-date" 
                                   value="<?php echo date('Y-m-d'); ?>">
                        </div>
                    </div>
                </form>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-light" data-bs-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-warning" id="save-prescription-btn">
                    <i class="mdi mdi-content-save me-1"></i> Save Details
                </button>
            </div>
        </div>
    </div>
</div>

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

// Utility functions
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;");
}

// Clear search input when clicking if products are already displayed
function clearSearchIfProducts() {
    const searchInput = document.getElementById('search-input');
    if (productsDisplayed && searchInput.value) {
        searchInput.value = '';
        searchInput.focus();
    }
}

// AJAX helper - ROBUST VERSION
function ajaxPost(action, data = {}) {
    const formData = new FormData();
    formData.append('ajax', 'true');
    formData.append('action', action);

for (const key in data) {
        if (data.hasOwnProperty(key)) {
            if (typeof data[key] === 'object' && data[key] !== null) {
                formData.append(key, JSON.stringify(data[key]));
            } else {
                formData.append(key, data[key]);
            }
        }
    }

return fetch(window.location.href, {
        method: 'POST',
        body: formData,
        headers: {
            'Accept': 'application/json'
        },
        cache: 'no-cache'
    })
    .then(response => {
        return response.text().then(text => {
            try {
                const jsonData = JSON.parse(text);
                return jsonData;
            } catch (e) {
                console.error('Server returned non-JSON:', text.substring(0, 500));
                
                if (text.includes('Fatal error') || text.includes('Parse error') || text.includes('<b>')) {
                    throw new Error('Server PHP error detected. Please check server logs.');
                } else if (text.includes('<html') || text.includes('<!DOCTYPE')) {
                    throw new Error('Server returned HTML page instead of JSON.');
                } else {
                    throw new Error('Invalid response format from server.');
                }
            }
        });
    })
    .then(responseData => {
        if (!responseData.success && responseData.message) {
            throw new Error(responseData.message);
        }
        return responseData;
    });
}

// Update fixed checkout bar
function updateFixedCheckoutBar() {
    const fixedBar = document.getElementById('fixed-checkout-bar');
    const fixedCartCount = document.getElementById('fixed-cart-count');
    const fixedCartTotal = document.getElementById('fixed-cart-total');
    
    let totalItems = 0;
    let subtotal = 0;
    
    for (const medicineId in cart) {
        const item = cart[medicineId];
        totalItems += item.quantity;
        subtotal += item.price * item.quantity;
    }
    
    // Show/hide fixed checkout bar
    if (Object.keys(cart).length > 0) {
        fixedBar.classList.add('show');
    } else {
        fixedBar.classList.remove('show');
    }
    
    // Update counters
    fixedCartCount.textContent = totalItems + ' items';
    fixedCartTotal.textContent = '₹' + subtotal.toFixed(2);
}

// Initialize
document.addEventListener('DOMContentLoaded', function() {
    updateCartDisplay();
    updateFixedCheckoutBar();
    attachEventListeners();
    document.getElementById('search-input').focus();
    
    // Initialize fixed checkout bar inputs from session
    if (sessionStorage.getItem('customerName')) {
        document.getElementById('fixed-customer-name').value = sessionStorage.getItem('customerName');
    }
    if (sessionStorage.getItem('customerPhone')) {
        document.getElementById('fixed-customer-phone').value = sessionStorage.getItem('customerPhone');
    }
});

// Event listeners
function attachEventListeners() {
    // Search
    document.getElementById('search-btn').addEventListener('click', searchProducts);
    document.getElementById('search-input').addEventListener('keypress', function(e) {
        if (e.key === 'Enter') searchProducts();
    });
    document.getElementById('category-filter').addEventListener('change', searchProducts);
    
    // Clear cart
    document.getElementById('clear-cart-btn').addEventListener('click', function() {
        if (confirm('Clear entire cart?')) {
            clearCart();
        }
    });
    
    // Test JSON button
    document.getElementById('test-json-btn').addEventListener('click', function() {
        const btn = this;
        const originalText = btn.innerHTML;
        btn.disabled = true;
        btn.innerHTML = '<i class="mdi mdi-loading mdi-spin me-1"></i> Testing...';
        
        ajaxPost('test_json')
        .then(response => {
            alert('✓ JSON test successful!\n' + JSON.stringify(response, null, 2));
            console.log('JSON Test Success:', response);
        })
        .catch(error => {
            alert('✗ JSON test failed:\n' + error.message);
            console.error('JSON Test Error:', error);
        })
        .finally(() => {
            btn.disabled = false;
            btn.innerHTML = originalText;
        });
    });
    
    // Fixed checkout bar - Save customer info to session storage
    document.getElementById('fixed-customer-name').addEventListener('change', function() {
        sessionStorage.setItem('customerName', this.value);
    });
    
    document.getElementById('fixed-customer-phone').addEventListener('change', function() {
        sessionStorage.setItem('customerPhone', this.value);
    });
    
    // Fixed checkout bar - Process sale
    document.getElementById('fixed-process-sale-btn').addEventListener('click', processSaleFromFixedBar);
    
    // Prescription modal save button
    document.getElementById('save-prescription-btn').addEventListener('click', function() {
        const modal = bootstrap.Modal.getInstance(document.getElementById('prescriptionModal'));
        
        // Validate
        const doctorName = document.getElementById('modal-doctor-name').value.trim();
        if (!doctorName) {
            alert('Doctor name is required');
            return;
        }
        
        // Save prescription details
        prescriptionDetails = {
            doctor_name: doctorName,
            doctor_license: document.getElementById('modal-doctor-license').value.trim(),
            patient_name: document.getElementById('modal-patient-name').value.trim(),
            prescription_date: document.getElementById('modal-prescription-date').value
        };
        
        modal.hide();
        
        // Continue with sale
        if (typeof window.pendingSaleCallback === 'function') {
            window.pendingSaleCallback();
            window.pendingSaleCallback = null;
        }
    });
}

// Clear cart
function clearCart() {
    ajaxPost('clear_cart')
    .then(response => {
        if (response.success) {
            cart = {};
            prescriptionDetails = {};
            updateCartDisplay();
            updateFixedCheckoutBar();
        } else {
            alert('Failed to clear cart: ' + response.message);
        }
    })
    .catch(error => {
        console.error('Clear cart error:', error);
        alert('Failed to clear cart: ' + error.message);
    });
}

// Search products
function searchProducts() {
    const searchQuery = document.getElementById('search-input').value.trim();
    const categoryFilter = document.getElementById('category-filter').value;
    const searchBtn = document.getElementById('search-btn');
    const spinner = searchBtn.querySelector('.loading-spinner');

searchBtn.disabled = true;
    spinner.style.display = 'inline-block';

ajaxPost('search_products', {
        search_query: searchQuery,
        category_filter: categoryFilter
    })
    .then(response => {
        if (response.success) {
            displayProducts(response.products);
            productsDisplayed = true; // Mark that products are displayed
        } else {
            alert('Search failed: ' + (response.message || 'Unknown error'));
        }
    })
    .catch(error => {
        console.error('Search error:', error);
        alert('Search failed: ' + error.message);
    })
    .finally(() => {
        searchBtn.disabled = false;
        spinner.style.display = 'none';
    });
}

// Display products
function displayProducts(productsToShow) {
    const container = document.getElementById('products-container');
    
    if (!productsToShow || productsToShow.length === 0) {
        container.innerHTML = `
            <div class="col-12 text-center py-4">
                <i class="mdi mdi-emoticon-sad-outline display-4 text-muted"></i>
                <h5 class="mt-2">No products found</h5>
                <p class="text-muted">Try different search terms</p>
            </div>
        `;
        return;
    }

let html = '';
    productsToShow.forEach(product => {
        const stockClass = product.stock_quantity <= 5 ? 'text-danger' : 'text-primary';
        const prescriptionBadge = product.requires_prescription ? 
            '<span class="badge bg-warning mt-2"><i class="mdi mdi-file-document"></i> Prescription Required</span>' : '';

html += `
            <div class="col-xl-3 col-lg-4 col-md-6 mb-3">
                <div class="card product-card">
                    <div class="card-body text-center p-3">
                        <h6 class="card-title mb-1">${escapeHtml(product.medicine_name)}</h6>
                        ${product.generic_name ? `<small class="text-muted d-block">${escapeHtml(product.generic_name)}</small>` : ''}
                        <small class="text-muted">${escapeHtml(product.category_name || 'General')}</small>
                        
                        <div class="product-info mt-2">
                            <div class="row text-center">
                                <div class="col-6">
                                    <small class="text-muted">Price</small>
                                    <div class="fw-bold text-success">₹${parseFloat(product.selling_price).toFixed(2)}</div>
                                </div>
                                <div class="col-6">
                                    <small class="text-muted">Stock</small>
                                    <div class="fw-bold ${stockClass}">
                                        ${product.stock_quantity}
                                    </div>
                                </div>
                            </div>
                        </div>

${prescriptionBadge}
                    </div>
                </div>
            </div>
        `;
    });

container.innerHTML = html;
    attachProductEventListeners();
}

// Attach product event listeners
function attachProductEventListeners() {
    document.querySelectorAll('.add-to-cart-btn').forEach(button => {
        button.addEventListener('click', function() {
            const medicineId = parseInt(this.dataset.medicineId);
            const medicineName = this.dataset.medicineName;
            const price = parseFloat(this.dataset.price);
            const batch = this.dataset.batch;
            const stock = parseInt(this.dataset.stock);
            const requiresPrescription = parseInt(this.dataset.prescription);
            const quantityInput = this.parentElement.querySelector('.quantity-input');
            const quantity = parseInt(quantityInput.value) || 1;

if (quantity < 1) {
                alert('Please enter a valid quantity');
                return;
            }

if (quantity > stock) {
                alert(`Only ${stock} units available`);
                return;
            }

// Update cart display
function updateCartDisplay() {
    const cartContainer = document.getElementById('cart-content');
    const emptyMessage = document.getElementById('empty-cart-message');
    const cartCount = document.getElementById('cart-count');
    const prescriptionCount = document.getElementById('prescription-count');

if (Object.keys(cart).length === 0) {
        emptyMessage.style.display = 'block';
        cartContainer.style.display = 'none';
        cartCount.textContent = '0 items';
        if (prescriptionCount) prescriptionCount.style.display = 'none';
        return;
    }

let totalItems = 0;
    let subtotal = 0;
    let prescriptionRequiredCount = 0;
    let html = `
        <div class="table-responsive" style="max-height: 300px;">
            <table class="table table-sm table-centered mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Product</th>
                        <th>Qty</th>
                        <th>Price</th>
                        <th>Total</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
    `;

for (const medicineId in cart) {
        const item = cart[medicineId];
        const itemTotal = item.price * item.quantity;
        totalItems += item.quantity;
        subtotal += itemTotal;
        
        if (item.requires_prescription) {
            prescriptionRequiredCount++;
        }

html += `
            <tr>
                <td>
                    <small class="fw-bold">${escapeHtml(item.name)}</small>
                    <br>
                    <small class="text-muted">Batch: ${escapeHtml(item.batch_number)}</small>
                    ${item.requires_prescription ? '<br><span class="badge bg-warning badge-sm"><i class="mdi mdi-file-document"></i> Rx</span>' : ''}
                </td>
                <td>
                    <input type="number" class="form-control form-control-sm cart-quantity" 
                           value="${item.quantity}" 
                           min="1" 
                           max="${item.stock}"
                           style="width: 70px;"
                           data-medicine-id="${medicineId}">
                </td>
                <td>₹${item.price.toFixed(2)}</td>
                <td>₹${itemTotal.toFixed(2)}</td>
                <td>
                    <button type="button" class="btn btn-sm btn-outline-danger remove-item-btn" data-medicine-id="${medicineId}">
                        <i class="mdi mdi-delete"></i>
                    </button>
                </td>
            </tr>
        `;
    }

html += `
                </tbody>
            </table>
        </div>

<div class="row mt-3">
            <div class="col-6">
                <button type="button" id="update-cart-btn" class="btn btn-outline-primary btn-sm w-100">
                    <i class="mdi mdi-refresh me-1"></i> Update
                </button>
            </div>
            <div class="col-6">
                <button type="button" id="clear-cart-confirm-btn" class="btn btn-outline-danger btn-sm w-100">
                    <i class="mdi mdi-cart-off me-1"></i> Clear All
                </button>
            </div>
        </div>

<div class="border-top mt-3 pt-3">
            <div class="row mb-2">
                <div class="col-6"><span class="text-muted">Items:</span></div>
                <div class="col-6 text-end"><span class="fw-bold">${totalItems}</span></div>
            </div>
            <div class="row mb-2">
                <div class="col-6"><span class="text-muted">Subtotal:</span></div>
                <div class="col-6 text-end"><span class="fw-bold">₹${subtotal.toFixed(2)}</span></div>
            </div>
            <div class="row mb-3 border-top pt-2">
                <div class="col-6"><span class="fw-bold">Total:</span></div>
                <div class="col-6 text-end"><span class="fw-bold fs-5 text-success">₹${subtotal.toFixed(2)}</span></div>
            </div>
        </div>

`;

// Show prescription notice if required
    if (prescriptionRequiredCount > 0) {
        html += `
            <div class="alert alert-warning mb-3">
                <div class="d-flex align-items-center">
                    <i class="mdi mdi-file-document fs-4 me-3"></i>
                    <div>
                        <strong>Prescription Required:</strong>
                        <p class="mb-0">${prescriptionRequiredCount} item(s) require prescription details.</p>
                        ${prescriptionDetails.doctor_name ? 
                            `<small class="text-success"><i class="mdi mdi-check-circle me-1"></i> Doctor: ${escapeHtml(prescriptionDetails.doctor_name)}</small>` :
                            `<small class="text-danger"><i class="mdi mdi-alert-circle me-1"></i> Click "Process Sale" to enter prescription details</small>`
                        }
                    </div>
                </div>
            </div>
        `;
    }

cartContainer.innerHTML = html;
    cartContainer.style.display = 'block';
    emptyMessage.style.display = 'none';
    cartCount.textContent = `${Object.keys(cart).length} items`;
    
    if (prescriptionCount) {
        prescriptionCount.textContent = ` ${prescriptionRequiredCount} Rx`;
        prescriptionCount.style.display = 'inline-flex';
    } else if (prescriptionRequiredCount > 0) {
        // Create prescription count badge if it doesn't exist
        const cartTitle = document.querySelector('.card-title');
        const rxBadge = document.createElement('span');
        rxBadge.className = 'badge bg-warning ms-2';
        rxBadge.id = 'prescription-count';
        rxBadge.innerHTML = `<i class="mdi mdi-file-document"></i> ${prescriptionRequiredCount} Rx`;
        cartTitle.appendChild(rxBadge);
    }

attachCartEventListeners();
}

// Attach cart event listeners
function attachCartEventListeners() {
    // Quantity changes
    document.querySelectorAll('.cart-quantity').forEach(input => {
        input.addEventListener('change', function() {
            const medicineId = this.dataset.medicineId;
            const quantity = parseInt(this.value) || 0;
            
            if (quantity <= 0) {
                if (confirm('Remove this item from cart?')) {
                    removeFromCart(medicineId);
                } else {
                    this.value = cart[medicineId].quantity;
                }
            } else {
                updateCartItem(medicineId, quantity);
            }
        });
    });

// Remove buttons
    document.querySelectorAll('.remove-item-btn').forEach(button => {
        button.addEventListener('click', function() {
            const medicineId = this.dataset.medicineId;
            if (confirm('Remove this item from cart?')) {
                removeFromCart(medicineId);
            }
        });
    });

// Update cart button
    const updateBtn = document.getElementById('update-cart-btn');
    if (updateBtn) {
        updateBtn.addEventListener('click', function() {
            updateCartDisplay();
            updateFixedCheckoutBar();
        });
    }

// Clear cart confirm
    const clearConfirmBtn = document.getElementById('clear-cart-confirm-btn');
    if (clearConfirmBtn) {
        clearConfirmBtn.addEventListener('click', function() {
            if (confirm('Clear entire cart?')) {
                clearCart();
            }
        });
    }
}

// Remove from cart
function removeFromCart(medicineId) {
    ajaxPost('remove_from_cart', { medicine_id: medicineId })
    .then(response => {
        if (response.success) {
            cart = response.cart;
            // Check if we should remove prescription details
            let hasPrescriptionItems = false;
            for (const id in cart) {
                if (cart[id].requires_prescription) {
                    hasPrescriptionItems = true;
                    break;
                }
            }
            if (!hasPrescriptionItems) {
                prescriptionDetails = {};
            }
            updateCartDisplay();
            updateFixedCheckoutBar();
        } else {
            alert('Error removing item: ' + response.message);
        }
    })
    .catch(error => {
        alert('Error removing item: ' + error.message);
    });
}

// Update cart item
function updateCartItem(medicineId, quantity) {
    ajaxPost('update_cart', {
        medicine_id: medicineId,
        quantity: quantity
    })
    .then(response => {
        if (response.success) {
            cart = response.cart;
            updateCartDisplay();
            updateFixedCheckoutBar();
        } else {
            alert('Error updating cart: ' + response.message);
        }
    })
    .catch(error => {
        alert('Error updating cart: ' + error.message);
    });
}

// Check if prescription is required
function hasPrescriptionRequiredItems() {
    for (const medicineId in cart) {
        if (cart[medicineId].requires_prescription) {
            return true;
        }
    }
    return false;
}

// Process sale from fixed bar
function processSaleFromFixedBar() {
    if (Object.keys(cart).length === 0) {
        alert('Cart is empty');
        return;
    }

const customerName = document.getElementById('fixed-customer-name').value.trim();
    const customerPhone = document.getElementById('fixed-customer-phone').value.trim();
    const paymentMethod = document.getElementById('fixed-payment-method').value;
    const processBtn = document.getElementById('fixed-process-sale-btn');
    const originalText = processBtn.innerHTML;

processBtn.disabled = true;
    processBtn.innerHTML = '<i class="mdi mdi-loading mdi-spin me-2"></i> Processing...';

// Check if prescription is required
    if (hasPrescriptionRequiredItems() && !prescriptionDetails.doctor_name) {
        processBtn.disabled = false;
        processBtn.innerHTML = originalText;
        
        // Store callback for after modal
        window.pendingSaleCallback = function() {
            processSaleFromFixedBar(); // Retry after modal
        };
        
        // Show prescription modal
        const prescriptionModal = new bootstrap.Modal(document.getElementById('prescriptionModal'));
        prescriptionModal.show();
        return;
    }

ajaxPost('process_sale', {
        customer_name: customerName,
        customer_phone: customerPhone,
        payment_method: paymentMethod,
        prescription_details: prescriptionDetails
    })
    .then(response => {
        if (response.success) {
            // INSTANTLY REDIRECT TO RECEIPT PAGE
            window.location.href = `receipt.php?sale_id=${response.sale_id}`;
        } else {
            alert('Error: ' + response.message);
            processBtn.disabled = false;
            processBtn.innerHTML = originalText;
        }
    })
    .catch(error => {
        alert('Error: ' + error.message);
        processBtn.disabled = false;
        processBtn.innerHTML = originalText;
    });
}

// Toast notification
function showToast(type, message) {
    // Create toast container if it doesn't exist
    let toastContainer = document.querySelector('.toast-container');
    if (!toastContainer) {
        toastContainer = document.createElement('div');
        toastContainer.className = 'toast-container position-fixed top-0 end-0 p-3';
        document.body.appendChild(toastContainer);
    }

const toastId = 'toast-' + Date.now();
    const bgColor = type === 'success' ? 'bg-success' : 'bg-danger';
    const icon = type === 'success' ? 'mdi-check-circle' : 'mdi-alert-circle';

const toastHtml = `
        <div id="${toastId}" class="toast" role="alert" aria-live="assertive" aria-atomic="true">
            <div class="toast-header ${bgColor} text-white">
                <i class="mdi ${icon} me-2"></i>
                <strong class="me-auto">Notification</strong>
                <button type="button" class="btn-close btn-close-white" data-bs-dismiss="toast" aria-label="Close"></button>
            </div>
            <div class="toast-body">
                ${message}
            </div>
        </div>
    `;

toastContainer.insertAdjacentHTML('beforeend', toastHtml);
    
    const toastElement = document.getElementById(toastId);
    const toast = new bootstrap.Toast(toastElement, { delay: 3000 });
    toast.show();
    
    // Remove toast after it's hidden
    toastElement.addEventListener('hidden.bs.toast', function () {
        toastElement.remove();
    });
}
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pos.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation