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: billing-settings.php

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

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

// Database connection
include('includes/db_connection.php');

// Start session if not started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Initialize messages
$success_message = '';
$error_message = '';

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Sanitize input
    $settings = [
        'shop_name' => isset($_POST['shop_name']) ? $conn->real_escape_string($_POST['shop_name']) : '',
        'shop_address' => isset($_POST['shop_address']) ? $conn->real_escape_string($_POST['shop_address']) : '',
        'shop_contact' => isset($_POST['shop_contact']) ? $conn->real_escape_string($_POST['shop_contact']) : '',
        'shop_gst' => isset($_POST['shop_gst']) ? $conn->real_escape_string($_POST['shop_gst']) : '',
        'bill_footer' => isset($_POST['bill_footer']) ? $conn->real_escape_string($_POST['bill_footer']) : '',
        'bill_terms' => isset($_POST['bill_terms']) ? $conn->real_escape_string($_POST['bill_terms']) : '',
        'tax_enabled' => isset($_POST['tax_enabled']) ? 1 : 0,
        'default_tax_rate' => isset($_POST['default_tax_rate']) ? floatval($_POST['default_tax_rate']) : 0,
        'discount_enabled' => isset($_POST['discount_enabled']) ? 1 : 0,
        'max_discount_percent' => isset($_POST['max_discount_percent']) ? floatval($_POST['max_discount_percent']) : 0,
        'loyalty_enabled' => isset($_POST['loyalty_enabled']) ? 1 : 0,
        'default_payment_method' => isset($_POST['default_payment_method']) ? $conn->real_escape_string($_POST['default_payment_method']) : 'cash',
        'print_auto' => isset($_POST['print_auto']) ? 1 : 0,
        'print_copies' => isset($_POST['print_copies']) ? intval($_POST['print_copies']) : 1,
        'receipt_printer_name' => isset($_POST['receipt_printer_name']) ? $conn->real_escape_string($_POST['receipt_printer_name']) : '',
        'invoice_prefix' => isset($_POST['invoice_prefix']) ? $conn->real_escape_string($_POST['invoice_prefix']) : 'INV',
        'invoice_start_number' => isset($_POST['invoice_start_number']) ? intval($_POST['invoice_start_number']) : 1,
        'show_expiry' => isset($_POST['show_expiry']) ? 1 : 0,
        'show_batch' => isset($_POST['show_batch']) ? 1 : 0,
        'show_mfg' => isset($_POST['show_mfg']) ? 1 : 0,
        'show_gst' => isset($_POST['show_gst']) ? 1 : 0,
        'use_html_editor' => isset($_POST['use_html_editor']) ? 1 : 0
    ];
    
    try {
        // Begin transaction
        $conn->begin_transaction();
        
        // Save each setting
        foreach ($settings as $key => $value) {
            // Check if setting exists
            $check_stmt = $conn->prepare("SELECT id FROM billing_settings WHERE setting_key = ?");
            $check_stmt->bind_param("s", $key);
            $check_stmt->execute();
            $check_result = $check_stmt->get_result();
            
            if ($check_result->num_rows > 0) {
                // Update existing setting
                $update_stmt = $conn->prepare("UPDATE billing_settings SET setting_value = ?, updated_at = NOW() WHERE setting_key = ?");
                $update_stmt->bind_param("ss", $value, $key);
                if (!$update_stmt->execute()) {
                    throw new Exception("Error updating setting $key: " . $conn->error);
                }
                $update_stmt->close();
            } else {
                // Insert new setting
                $insert_stmt = $conn->prepare("INSERT INTO billing_settings (setting_key, setting_value) VALUES (?, ?)");
                $insert_stmt->bind_param("ss", $key, $value);
                if (!$insert_stmt->execute()) {
                    throw new Exception("Error inserting setting $key: " . $conn->error);
                }
                $insert_stmt->close();
            }
            
            $check_stmt->close();
        }
        
        // Commit transaction
        $conn->commit();
        $success_message = "Billing settings saved successfully!";
        
        // Store success message in session to show after redirect
        $_SESSION['success_message'] = $success_message;
        
        // Redirect to avoid form resubmission
        header("Location: " . $_SERVER['PHP_SELF']);
        exit();
        
    } catch (Exception $e) {
        // Rollback transaction on error
        $conn->rollback();
        $error_message = $e->getMessage();
        $_SESSION['error_message'] = $error_message;
    }
}

// Check for session messages
if (isset($_SESSION['success_message'])) {
    $success_message = $_SESSION['success_message'];
    unset($_SESSION['success_message']);
}

if (isset($_SESSION['error_message'])) {
    $error_message = $_SESSION['error_message'];
    unset($_SESSION['error_message']);
}

// Check if billing_settings table exists, create if not
$table_check = $conn->query("SHOW TABLES LIKE 'billing_settings'");
if ($table_check->num_rows == 0) {
    // Create billing_settings table with LONGTEXT for HTML content
    $create_table_sql = "
    CREATE TABLE billing_settings (
        id INT(11) NOT NULL AUTO_INCREMENT,
        setting_key VARCHAR(100) NOT NULL,
        setting_value LONGTEXT,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (id),
        UNIQUE KEY (setting_key)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    ";
    
    if ($conn->query($create_table_sql)) {
        // Insert default settings
        $default_settings = [
            ['shop_name', 'MD Medicals'],
            ['shop_address', 'Nagadhasampatti, Pennagaram main road, Dharmapuri - 636813'],
            ['shop_contact', 'Phone: 7200314099'],
            ['shop_gst', 'GSTIN: 33ABCDE1234F1Z5'],
            ['bill_footer', 'Thank you for your purchase! Visit Again'],
            ['bill_terms', 'Goods once sold cannot be returned. Subject to Jurisdiction of Dharmapuri'],
            ['tax_enabled', '0'],
            ['default_tax_rate', '0'],
            ['discount_enabled', '1'],
            ['max_discount_percent', '10'],
            ['loyalty_enabled', '1'],
            ['default_payment_method', 'cash'],
            ['print_auto', '0'],
            ['print_copies', '1'],
            ['receipt_printer_name', ''],
            ['invoice_prefix', 'INV'],
            ['invoice_start_number', '1'],
            ['show_expiry', '1'],
            ['show_batch', '1'],
            ['show_mfg', '0'],
            ['show_gst', '1'],
            ['use_html_editor', '0']
        ];
        
        foreach ($default_settings as $setting) {
            $conn->query("INSERT INTO billing_settings (setting_key, setting_value) VALUES ('{$setting[0]}', '{$setting[1]}')");
        }
    }
}

// Load existing settings
$settings_result = $conn->query("SELECT setting_key, setting_value FROM billing_settings");
$settings = [];
while ($row = $settings_result->fetch_assoc()) {
    $settings[$row['setting_key']] = $row['setting_value'];
}

// Get payment methods for dropdown
$payment_methods = ['cash' => 'Cash', 'card' => 'Card', 'upi' => 'UPI', 'online' => 'Online'];

// Build bill_header from separate fields for backward compatibility
if (!isset($settings['bill_header']) && isset($settings['shop_name'])) {
    $settings['bill_header'] = '<div style="text-align: center;">' .
        '<h3>' . htmlspecialchars($settings['shop_name']) . '</h3>' .
        '<p>' . htmlspecialchars($settings['shop_address'] ?? '') . '<br>' .
        htmlspecialchars($settings['shop_contact'] ?? '') . '<br>' .
        htmlspecialchars($settings['shop_gst'] ?? '') . '</p>' .
        '</div>';
}
?>

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

<div id="layout-wrapper">

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

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>

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

<?php if (!empty($success_message)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo htmlspecialchars($success_message); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if (!empty($error_message)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo htmlspecialchars($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-12">
                        <div class="card">
                            <div class="card-body">
                                <form method="POST" action="" id="billingSettingsForm">
                                    <div class="row">
                                        
                                        
                                        <div class="col-md-12 mb-3">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="use_html_editor" name="use_html_editor" <?php echo (isset($settings['use_html_editor']) && $settings['use_html_editor'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="use_html_editor">Use Rich Text Editor for Footer & Terms</label>
                                            </div>
                                            <small class="text-muted">(Shop information always uses plain text for better thermal printing)</small>
                                        </div>
                                        
                                        
                                        <div class="col-md-12">
                                            <h5 class="mb-3 border-bottom pb-2">Shop Information</h5>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="shop_name" class="form-label">Shop Name *</label>
                                            <input type="text" class="form-control" id="shop_name" name="shop_name" 
                                                   placeholder="e.g., MD Medicals" 
                                                   value="<?php echo htmlspecialchars($settings['shop_name'] ?? 'MD Medicals'); ?>" required>
                                            <small class="text-muted">Appears as first line on receipt</small>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="shop_contact" class="form-label">Contact Information</label>
                                            <input type="text" class="form-control" id="shop_contact" name="shop_contact" 
                                                   placeholder="e.g., Phone: 7200314099, Email: info@example.com" 
                                                   value="<?php echo htmlspecialchars($settings['shop_contact'] ?? ''); ?>">
                                            <small class="text-muted">Phone, email, etc.</small>
                                        </div>
                                        
                                        <div class="col-md-12 mb-3">
                                            <label for="shop_address" class="form-label">Shop Address *</label>
                                            <textarea class="form-control" id="shop_address" name="shop_address" rows="2" 
                                                      placeholder="Full address including city, state, pincode" 
                                                      required><?php echo htmlspecialchars($settings['shop_address'] ?? ''); ?></textarea>
                                            <small class="text-muted">Full address for billing</small>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="shop_gst" class="form-label">GST Number</label>
                                            <input type="text" class="form-control" id="shop_gst" name="shop_gst" 
                                                   placeholder="e.g., GSTIN: 33ABCDE1234F1Z5" 
                                                   value="<?php echo htmlspecialchars($settings['shop_gst'] ?? ''); ?>">
                                            <small class="text-muted">Optional GST registration number</small>
                                        </div>
                                        
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="invoice_prefix" class="form-label">Invoice Prefix</label>
                                            <input type="text" class="form-control" id="invoice_prefix" name="invoice_prefix" 
                                                   value="<?php echo htmlspecialchars($settings['invoice_prefix'] ?? 'INV'); ?>">
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="invoice_start_number" class="form-label">Invoice Start Number</label>
                                            <input type="number" class="form-control" id="invoice_start_number" name="invoice_start_number" 
                                                   min="1" value="<?php echo htmlspecialchars($settings['invoice_start_number'] ?? '1'); ?>">
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <h5 class="mb-3 border-bottom pb-2">Footer & Terms</h5>
                                        </div>
                                        
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="bill_footer" class="form-label">Footer Text</label>
                                            <div class="html-editor-container" style="<?php echo (isset($settings['use_html_editor']) && $settings['use_html_editor'] == '1') ? '' : 'display: none;'; ?>">
                                                <div id="bill_footer_editor"></div>
                                                <textarea id="bill_footer" name="bill_footer" style="display: none;"><?php echo htmlspecialchars($settings['bill_footer'] ?? ''); ?></textarea>
                                            </div>
                                            <div class="plain-editor-container" style="<?php echo (isset($settings['use_html_editor']) && $settings['use_html_editor'] == '1') ? 'display: none;' : ''; ?>">
                                                <textarea class="form-control" id="bill_footer_plain" name="bill_footer_plain" rows="3" 
                                                          placeholder="Thank you message that appears at bottom..."><?php echo htmlspecialchars($settings['bill_footer'] ?? ''); ?></textarea>
                                            </div>
                                            <small class="text-muted">Appears at the bottom of every bill</small>
                                        </div>
                                        
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="bill_terms" class="form-label">Terms & Conditions</label>
                                            <div class="html-editor-container" style="<?php echo (isset($settings['use_html_editor']) && $settings['use_html_editor'] == '1') ? '' : 'display: none;'; ?>">
                                                <div id="bill_terms_editor"></div>
                                                <textarea id="bill_terms" name="bill_terms" style="display: none;"><?php echo htmlspecialchars($settings['bill_terms'] ?? ''); ?></textarea>
                                            </div>
                                            <div class="plain-editor-container" style="<?php echo (isset($settings['use_html_editor']) && $settings['use_html_editor'] == '1') ? 'display: none;' : ''; ?>">
                                                <textarea class="form-control" id="bill_terms_plain" name="bill_terms_plain" rows="3" 
                                                          placeholder="Terms and conditions..."><?php echo htmlspecialchars($settings['bill_terms'] ?? ''); ?></textarea>
                                            </div>
                                            <small class="text-muted">Appears below footer</small>
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <h5 class="mb-3 border-bottom pb-2">Tax & Pricing</h5>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="tax_enabled" name="tax_enabled" <?php echo (isset($settings['tax_enabled']) && $settings['tax_enabled'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="tax_enabled">Enable Tax Calculation</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="default_tax_rate" class="form-label">Default Tax Rate (%)</label>
                                            <input type="number" class="form-control" id="default_tax_rate" name="default_tax_rate" 
                                                   min="0" max="100" step="0.01" 
                                                   value="<?php echo htmlspecialchars($settings['default_tax_rate'] ?? '0'); ?>">
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="discount_enabled" name="discount_enabled" <?php echo (isset($settings['discount_enabled']) && $settings['discount_enabled'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="discount_enabled">Enable Discounts</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="max_discount_percent" class="form-label">Maximum Discount (%)</label>
                                            <input type="number" class="form-control" id="max_discount_percent" name="max_discount_percent" 
                                                   min="0" max="100" step="0.01" 
                                                   value="<?php echo htmlspecialchars($settings['max_discount_percent'] ?? '10'); ?>">
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <h5 class="mb-3 border-bottom pb-2">Payment & Loyalty</h5>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="default_payment_method" class="form-label">Default Payment Method</label>
                                            <select class="form-select" id="default_payment_method" name="default_payment_method">
                                                <?php foreach ($payment_methods as $value => $label): ?>
                                                    <option value="<?php echo $value; ?>" <?php echo (isset($settings['default_payment_method']) && $settings['default_payment_method'] == $value) ? 'selected' : ''; ?>>
                                                        <?php echo $label; ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            </select>
                                        </div>
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="loyalty_enabled" name="loyalty_enabled" <?php echo (isset($settings['loyalty_enabled']) && $settings['loyalty_enabled'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="loyalty_enabled">Enable Loyalty Program</label>
                                            </div>
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <h5 class="mb-3 border-bottom pb-2">Printing Settings</h5>
                                        </div>
                                        
                                        <div class="col-md-4 mb-3">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="print_auto" name="print_auto" <?php echo (isset($settings['print_auto']) && $settings['print_auto'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="print_auto">Auto Print After Sale</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-4 mb-3">
                                            <label for="print_copies" class="form-label">Print Copies</label>
                                            <input type="number" class="form-control" id="print_copies" name="print_copies" 
                                                   min="1" max="5" value="<?php echo htmlspecialchars($settings['print_copies'] ?? '1'); ?>">
                                        </div>
                                        
                                        <div class="col-md-4 mb-3">
                                            <label for="receipt_printer_name" class="form-label">Receipt Printer Name</label>
                                            <input type="text" class="form-control" id="receipt_printer_name" name="receipt_printer_name" 
                                                   placeholder="e.g., EPSON TM-T88V" 
                                                   value="<?php echo htmlspecialchars($settings['receipt_printer_name'] ?? ''); ?>">
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <h5 class="mb-3 border-bottom pb-2">Bill Content Options</h5>
                                        </div>
                                        
                                        <div class="col-md-3 mb-3">
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" id="show_expiry" name="show_expiry" <?php echo (isset($settings['show_expiry']) && $settings['show_expiry'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="show_expiry">Show Expiry Date</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3 mb-3">
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" id="show_batch" name="show_batch" <?php echo (isset($settings['show_batch']) && $settings['show_batch'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="show_batch">Show Batch Number</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3 mb-3">
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" id="show_mfg" name="show_mfg" <?php echo (isset($settings['show_mfg']) && $settings['show_mfg'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="show_mfg">Show Manufacturer</label>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-3 mb-3">
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" id="show_gst" name="show_gst" <?php echo (isset($settings['show_gst']) && $settings['show_gst'] == '1') ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="show_gst">Show GST Details</label>
                                            </div>
                                        </div>
                                        
                                        
                                        <div class="col-md-12 mt-4">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="mdi mdi-content-save me-1"></i> Save Settings
                                            </button>
                                            <button type="button" class="btn btn-secondary" onclick="resetToDefaults()">
                                                <i class="mdi mdi-restore me-1"></i> Reset to Defaults
                                            </button>
                                            <button type="button" class="btn btn-outline-info" onclick="testPrint()">
                                                <i class="mdi mdi-printer me-1"></i> Test Print Preview
                                            </button>
                                        </div>
                                        
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-4">Thermal Receipt Preview</h5>
                                <div class="border p-4 bill-preview-container" id="billPreview" style="background: white; max-width: 80mm; margin: 0 auto; font-family: 'Courier New', monospace; font-size: 10px;">
                                    
                                </div>
                                <div class="mt-3 text-center">
                                    <button type="button" class="btn btn-outline-primary" onclick="updatePreview()">
                                        <i class="mdi mdi-refresh me-1"></i> Refresh Preview
                                    </button>
                                    <small class="text-muted ms-3">Preview shows 3-inch thermal receipt</small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

<link href="https://cdn.quilljs.com/1.3.6/quill.snow.css" rel="stylesheet">
<script src="https://cdn.quilljs.com/1.3.6/quill.min.js"></script>

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

// Initialize Quill editors if HTML editor is enabled
function initQuillEditors() {
    if (useHtmlEditor) {
        // Footer Editor
        footerEditor = new Quill('#bill_footer_editor', {
            theme: 'snow',
            modules: {
                toolbar: [
                    ['bold', 'italic', 'underline'],
                    [{ 'align': [] }],
                    ['clean']
                ]
            },
            placeholder: 'Enter bill footer text...'
        });
        
        // Set initial content
        footerEditor.root.innerHTML = `<?php echo addslashes($settings['bill_footer'] ?? 'Thank you for your purchase!<br>Visit Again'); ?>`;
        
        // Update hidden textarea on content change
        footerEditor.on('text-change', function() {
            document.getElementById('bill_footer').value = footerEditor.root.innerHTML;
        });

// Terms Editor
        termsEditor = new Quill('#bill_terms_editor', {
            theme: 'snow',
            modules: {
                toolbar: [
                    ['bold', 'italic'],
                    [{ 'list': 'ordered'}, { 'list': 'bullet' }],
                    ['clean']
                ]
            },
            placeholder: 'Enter terms and conditions...'
        });
        
        termsEditor.root.innerHTML = `<?php echo addslashes($settings['bill_terms'] ?? 'Goods once sold cannot be returned.<br>Subject to Jurisdiction of Dharmapuri'); ?>`;
        
        termsEditor.on('text-change', function() {
            document.getElementById('bill_terms').value = termsEditor.root.innerHTML;
        });
    }
}

// Toggle between HTML and plain text editors for footer/terms
function toggleEditorMode() {
    useHtmlEditor = document.getElementById('use_html_editor').checked;
    
    const htmlContainers = document.querySelectorAll('.html-editor-container');
    const plainContainers = document.querySelectorAll('.plain-editor-container');
    
    if (useHtmlEditor) {
        // Show HTML editors, hide plain text
        htmlContainers.forEach(container => container.style.display = 'block');
        plainContainers.forEach(container => container.style.display = 'none');
        
        // Initialize Quill editors
        initQuillEditors();
        
        // Transfer plain text to HTML editors
        const footerPlain = document.getElementById('bill_footer_plain').value;
        const termsPlain = document.getElementById('bill_terms_plain').value;
        
        if (footerEditor) {
            footerEditor.root.innerHTML = `<div style="text-align: center;"><p>${footerPlain.replace(/\n/g, '<br>')}</p></div>`;
        }
        if (termsEditor) {
            termsEditor.root.innerHTML = `<div style="text-align: center;"><p>${termsPlain.replace(/\n/g, '<br>')}</p></div>`;
        }
    } else {
        // Show plain text, hide HTML editors
        htmlContainers.forEach(container => container.style.display = 'none');
        plainContainers.forEach(container => container.style.display = 'block');
        
        // Transfer HTML content to plain text
        if (footerEditor) {
            const footerHtml = footerEditor.root.innerHTML;
            const footerPlain = stripHtml(footerHtml);
            document.getElementById('bill_footer_plain').value = footerPlain;
        }
        if (termsEditor) {
            const termsHtml = termsEditor.root.innerHTML;
            const termsPlain = stripHtml(termsHtml);
            document.getElementById('bill_terms_plain').value = termsPlain;
        }
    }
    
    updatePreview();
}

// Strip HTML tags for plain text
function stripHtml(html) {
    const tmp = document.createElement('div');
    tmp.innerHTML = html;
    return tmp.textContent || tmp.innerText || '';
}

// Update bill preview with thermal printer format
function updatePreview() {
    // Get shop information
    const shopName = document.getElementById('shop_name').value || 'MD Medicals';
    const shopAddress = document.getElementById('shop_address').value || 'Nagadhasampatti, Pennagaram main road, Dharmapuri - 636813';
    const shopContact = document.getElementById('shop_contact').value || 'Phone: 7200314099';
    const shopGst = document.getElementById('shop_gst').value || 'GSTIN: 33ABCDE1234F1Z5';
    
    // Get footer and terms
    let footerText, termsText;
    const isHtml = document.getElementById('use_html_editor').checked;
    
    if (isHtml) {
        footerText = footerEditor ? stripHtml(footerEditor.root.innerHTML) : document.getElementById('bill_footer').value;
        termsText = termsEditor ? stripHtml(termsEditor.root.innerHTML) : document.getElementById('bill_terms').value;
    } else {
        footerText = document.getElementById('bill_footer_plain').value;
        termsText = document.getElementById('bill_terms_plain').value;
    }
    
    const invoicePrefix = document.getElementById('invoice_prefix').value || 'INV';
    const defaultPaymentMethod = document.getElementById('default_payment_method').value.toUpperCase();
    const taxEnabled = document.getElementById('tax_enabled').checked;
    const discountEnabled = document.getElementById('discount_enabled').checked;
    const showExpiry = document.getElementById('show_expiry').checked;
    const showBatch = document.getElementById('show_batch').checked;
    
    const preview = document.getElementById('billPreview');
    
    // Split address into lines for thermal printer (max 32 chars per line)
    function splitForThermal(text, maxLength = 32) {
        const lines = [];
        const words = text.split(' ');
        let currentLine = '';
        
        for (const word of words) {
            if ((currentLine + ' ' + word).length <= maxLength) {
                currentLine = currentLine ? currentLine + ' ' + word : word;
            } else {
                if (currentLine) lines.push(currentLine);
                currentLine = word;
            }
        }
        if (currentLine) lines.push(currentLine);
        return lines;
    }
    
    const addressLines = splitForThermal(shopAddress);
    const contactLines = splitForThermal(shopContact);
    const gstLines = splitForThermal(shopGst);
    const footerLines = splitForThermal(footerText);
    const termsLines = splitForThermal(termsText);
    
    // Create thermal receipt preview
    let previewHtml = `
        <div style="padding: 5px; font-size: 10px; line-height: 1.1;">
            
            <div style="text-align: center; font-weight: 900; font-size: 11px; margin-bottom: 2px;">
                ${shopName.toUpperCase()}
            </div>
            
            
            ${addressLines.map(line => `
                <div style="text-align: center; font-weight: bold; margin-bottom: 1px;">
                    ${line}
                </div>
            `).join('')}
            
            
            ${contactLines.map(line => `
                <div style="text-align: center; font-weight: bold; margin-bottom: 1px;">
                    ${line}
                </div>
            `).join('')}
            
            
            ${gstLines.map(line => `
                <div style="text-align: center; font-weight: bold; margin-bottom: 3px;">
                    ${line}
                </div>
            `).join('')}
            
            <hr style="border-top: 2px solid #000; margin: 3px 0;">
            
            
            <div style="margin-bottom: 3px;">
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">INVOICE #:</span>
                    <span>${invoicePrefix}-001</span>
                </div>
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">DATE:</span>
                    <span>${new Date().toLocaleDateString()}</span>
                </div>
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">TIME:</span>
                    <span>${new Date().toLocaleTimeString([], {hour: '2-digit', minute:'2-digit'})}</span>
                </div>
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">CUSTOMER:</span>
                    <span>Walk-in Customer</span>
                </div>
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">PAYMENT:</span>
                    <span style="font-weight: 900;">${defaultPaymentMethod}</span>
                </div>
            </div>
            
            <hr style="border-top: 2px solid #000; margin: 3px 0;">
            
            
            <table style="width: 100%; font-size: 9px; margin-bottom: 3px;">
                <thead>
                    <tr>
                        <th style="text-align: left; padding: 1px 0;">ITEM</th>
                        <th style="text-align: center; padding: 1px 0;">QTY</th>
                        <th style="text-align: right; padding: 1px 0;">PRICE</th>
                        <th style="text-align: right; padding: 1px 0;">TOTAL</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td style="padding: 1px 0;">
                            Paracetamol 500mg
                            ${showBatch ? '<br><small>B: B123</small>' : ''}
                            ${showExpiry ? '<br><small>E: 12/2025</small>' : ''}
                        </td>
                        <td style="text-align: center; padding: 1px 0;">2</td>
                        <td style="text-align: right; padding: 1px 0;">₹15.00</td>
                        <td style="text-align: right; padding: 1px 0;">₹30.00</td>
                    </tr>
                    <tr>
                        <td style="padding: 1px 0;">
                            Vitamin C Tablets
                            ${showBatch ? '<br><small>B: V456</small>' : ''}
                            ${showExpiry ? '<br><small>E: 06/2026</small>' : ''}
                        </td>
                        <td style="text-align: center; padding: 1px 0;">1</td>
                        <td style="text-align: right; padding: 1px 0;">₹45.00</td>
                        <td style="text-align: right; padding: 1px 0;">₹45.00</td>
                    </tr>
                </tbody>
            </table>
            
            <hr style="border-top: 1px dotted #000; margin: 3px 0;">
            
            
            <div style="font-size: 10px; margin-bottom: 3px;">
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">SUBTOTAL:</span>
                    <span>₹75.00</span>
                </div>
                ${taxEnabled ? `
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">TAX (5%):</span>
                    <span>₹3.75</span>
                </div>
                ` : ''}
                ${discountEnabled ? `
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px;">
                    <span style="font-weight: bold;">DISCOUNT:</span>
                    <span>-₹7.50</span>
                </div>
                ` : ''}
                <div style="display: flex; justify-content: space-between; margin-bottom: 1px; border-top: 2px solid #000; padding-top: 2px; font-weight: 900; font-size: 11px;">
                    <span>TOTAL:</span>
                    <span>₹${taxEnabled ? '71.25' : (discountEnabled ? '67.50' : '75.00')}</span>
                </div>
            </div>
            
            <hr style="border-top: 2px solid #000; margin: 3px 0;">
            
            
            ${footerLines.map(line => `
                <div style="text-align: center; font-weight: bold; margin-bottom: 1px;">
                    ${line}
                </div>
            `).join('')}
            
            
            ${termsLines.map(line => `
                <div style="text-align: center; font-size: 8px; margin-bottom: 1px;">
                    ${line}
                </div>
            `).join('')}
            
            
            <div style="text-align: center; font-size: 8px; margin-top: 3px; border-top: 1px dashed #000; padding-top: 2px;">
                Cashier: SYSTEM<br>
                ${new Date().toLocaleDateString()} ${new Date().toLocaleTimeString([], {hour: '2-digit', minute:'2-digit'})}
            </div>
            
            
            <div style="text-align: center; margin-top: 5px; font-size: 8px;">
                - - - - - - - - - - - - - - - - - - -
            </div>
        </div>
    `;
    
    preview.innerHTML = previewHtml;
}

// Test print preview
function testPrint() {
    const previewContent = document.getElementById('billPreview').innerHTML;
    const printWindow = window.open('', '_blank', 'width=400,height=600');
    
    printWindow.document.write(`
        <!DOCTYPE html>
        <html>
        <head>
            <title>Test Thermal Receipt</title>
            <style>
                @media print {
                    body { margin: 0; padding: 0; }
                    .no-print { display: none; }
                }
                body {
                    font-family: 'Courier New', monospace;
                    font-size: 10px;
                    max-width: 80mm;
                    margin: 0 auto;
                    padding: 5px;
                }
                .print-btn {
                    margin: 10px;
                    padding: 8px 16px;
                    background: #007bff;
                    color: white;
                    border: none;
                    cursor: pointer;
                    border-radius: 3px;
                    font-size: 10px;
                }
            </style>
        </head>
        <body>
            <div>${previewContent}</div>
            <div class="no-print" style="text-align: center;">
                <button class="print-btn" onclick="window.print()">🖨️ Print Receipt</button>
                <button class="print-btn" onclick="window.close()">✖️ Close</button>
            </div>
        </body>
        </html>
    `);
    
    printWindow.document.close();
}

// Reset to default settings
function resetToDefaults() {
    if (confirm('Are you sure you want to reset all billing settings to defaults? This cannot be undone.')) {
        // Reset shop information
        document.getElementById('shop_name').value = 'MD Medicals';
        document.getElementById('shop_address').value = 'Nagadhasampatti, Pennagaram main road, Dharmapuri - 636813';
        document.getElementById('shop_contact').value = 'Phone: 7200314099';
        document.getElementById('shop_gst').value = 'GSTIN: 33ABCDE1234F1Z5';
        
        // Reset invoice settings
        document.getElementById('invoice_prefix').value = 'INV';
        document.getElementById('invoice_start_number').value = '1';
        
        // Reset footer and terms
        document.getElementById('use_html_editor').checked = true;
        toggleEditorMode();
        
        if (footerEditor) {
            footerEditor.root.innerHTML = 'Thank you for your purchase!<br>Visit Again';
        }
        if (termsEditor) {
            termsEditor.root.innerHTML = 'Goods once sold cannot be returned.<br>Subject to Jurisdiction of Dharmapuri';
        }
        document.getElementById('bill_footer_plain').value = 'Thank you for your purchase! Visit Again';
        document.getElementById('bill_terms_plain').value = 'Goods once sold cannot be returned. Subject to Jurisdiction of Dharmapuri';
        
        // Reset tax and pricing
        document.getElementById('tax_enabled').checked = false;
        document.getElementById('default_tax_rate').value = '0';
        document.getElementById('discount_enabled').checked = true;
        document.getElementById('max_discount_percent').value = '10';
        document.getElementById('default_payment_method').value = 'cash';
        document.getElementById('loyalty_enabled').checked = true;
        
        // Reset printing settings
        document.getElementById('print_auto').checked = false;
        document.getElementById('print_copies').value = '1';
        document.getElementById('receipt_printer_name').value = '';
        
        // Reset content options
        document.getElementById('show_expiry').checked = true;
        document.getElementById('show_batch').checked = true;
        document.getElementById('show_mfg').checked = false;
        document.getElementById('show_gst').checked = true;
        
        updatePreview();
        
        // Show success message
        showMessage('Settings reset to defaults successfully!', 'success');
    }
}

// Show message
function showMessage(message, type) {
    const alertDiv = document.createElement('div');
    alertDiv.className = `alert alert-${type} alert-dismissible fade show mt-3`;
    alertDiv.innerHTML = `
        <i class="mdi mdi-${type === 'success' ? 'check-all' : 'block-helper'} me-2"></i>
        ${message}
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    `;
    document.querySelector('.card-body').prepend(alertDiv);
}

// Initialize on page load
document.addEventListener('DOMContentLoaded', function() {
    // Initialize editors based on current setting
    if (useHtmlEditor) {
        initQuillEditors();
    }
    
    // Setup toggle event
    document.getElementById('use_html_editor').addEventListener('change', toggleEditorMode);
    
    // Update preview when settings change
    const inputs = document.querySelectorAll('#billingSettingsForm input, #billingSettingsForm select, #billingSettingsForm textarea');
    inputs.forEach(input => {
        input.addEventListener('change', updatePreview);
        input.addEventListener('keyup', updatePreview);
    });
    
    // Auto-dismiss alerts after 5 seconds
    setTimeout(function() {
        const alerts = document.querySelectorAll('.alert');
        alerts.forEach(function(alert) {
            const bsAlert = new bootstrap.Alert(alert);
            bsAlert.close();
        });
    }, 5000);
    
    // Initial preview
    updatePreview();
});

// Form submission - sync editors
document.getElementById('billingSettingsForm').addEventListener('submit', function(e) {
    if (useHtmlEditor) {
        // Ensure hidden fields are updated
        if (footerEditor) {
            document.getElementById('bill_footer').value = footerEditor.root.innerHTML;
        }
        if (termsEditor) {
            document.getElementById('bill_terms').value = termsEditor.root.innerHTML;
        }
    } else {
        // Convert plain text to HTML for storage
        const footerPlain = document.getElementById('bill_footer_plain').value;
        const termsPlain = document.getElementById('bill_terms_plain').value;
        
        // Create hidden inputs if not exists
        if (!document.getElementById('bill_footer')) {
            const footerInput = document.createElement('input');
            footerInput.type = 'hidden';
            footerInput.id = 'bill_footer';
            footerInput.name = 'bill_footer';
            this.appendChild(footerInput);
        }
        
        if (!document.getElementById('bill_terms')) {
            const termsInput = document.createElement('input');
            termsInput.type = 'hidden';
            termsInput.id = 'bill_terms';
            termsInput.name = 'bill_terms';
            this.appendChild(termsInput);
        }
        
        document.getElementById('bill_footer').value = footerPlain;
        document.getElementById('bill_terms').value = termsPlain;
    }
    
    // Validate required fields
    const shopName = document.getElementById('shop_name').value.trim();
    const shopAddress = document.getElementById('shop_address').value.trim();
    
    if (!shopName) {
        alert('Please enter Shop Name');
        e.preventDefault();
        return false;
    }
    
    if (!shopAddress) {
        alert('Please enter Shop Address');
        e.preventDefault();
        return false;
    }
    
    return true;
});
</script>

</body>
</html>

<?php
// Close database connection
if (isset($conn)) {
    $conn->close();
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: billing-settings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation