{% extends "base.html" %}

{% block title %}Tune Orders Data - Daily Mirror{% endblock %}

{% block extra_css %}
<link rel="stylesheet" href="{{ url_for('static', filename='css/daily_mirror_tune.css') }}">
<style>
/* Force modal width - using viewport width for maximum responsiveness */
.modal#editModal .modal-dialog {
    max-width: 95vw !important;
    width: 95vw !important;
    margin: 1.75rem auto !important;
}

.modal#editModal .modal-dialog.modal-xl {
    max-width: 95vw !important;
    width: 95vw !important;
}

/* Override ALL Bootstrap media queries */
@media (min-width: 576px) {
    .modal#editModal .modal-dialog {
        max-width: 95vw !important;
        width: 95vw !important;
    }
}

@media (min-width: 992px) {
    .modal#editModal .modal-dialog {
        max-width: 95vw !important;
        width: 95vw !important;
    }
}

@media (min-width: 1200px) {
    .modal#editModal .modal-dialog,
    .modal#editModal .modal-dialog.modal-xl {
        max-width: 95vw !important;
        width: 95vw !important;
    }
}

/* Ensure pointer events work */
.modal#editModal .modal-dialog {
    pointer-events: auto !important;
}
</style>
{% endblock %}

{% block content %}
<div class="container-fluid">
    <!-- Page Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h1 class="h3 mb-0">🛒 Tune Orders Data</h1>
                    <p class="text-muted">Edit and update customer orders information</p>
                </div>
                <div>
                        <!-- Buttons removed; now present in top header -->
                </div>
            </div>
        </div>
    </div>

    <!-- Filters Section -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title mb-0">
                        <i class="fas fa-filter"></i> Filters and Search
                    </h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3 mb-3">
                            <label for="searchInput" class="form-label">Search</label>
                            <input type="text" class="form-control" id="searchInput" 
                                   placeholder="Search by order, customer, or article...">
                        </div>
                        <div class="col-md-3 mb-3">
                            <label for="statusFilter" class="form-label">Order Status</label>
                            <select class="form-control" id="statusFilter">
                                <option value="">All Statuses</option>
                                <!-- Will be populated dynamically -->
                            </select>
                        </div>
                        <div class="col-md-3 mb-3">
                            <label for="customerFilter" class="form-label">Customer</label>
                            <select class="form-control" id="customerFilter">
                                <option value="">All Customers</option>
                                <!-- Will be populated dynamically -->
                            </select>
                        </div>
                        <div class="col-md-3 mb-3">
                            <label for="recordsPerPage" class="form-label">Records per page</label>
                            <select class="form-control" id="recordsPerPage">
                                <option value="25">25</option>
                                <option value="50" selected>50</option>
                                <option value="100">100</option>
                            </select>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-12">
                            <button class="btn btn-primary" onclick="loadOrdersData()">
                                <i class="fas fa-search"></i> Apply Filters
                            </button>
                            <button class="btn btn-secondary" onclick="clearFilters()">
                                <i class="fas fa-times"></i> Clear
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Data Table Section -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h5 class="card-title mb-0">
                        <i class="fas fa-table"></i> Customer Orders Data
                    </h5>
                    <div class="d-flex align-items-center">
                        <span id="recordsInfo" class="text-muted me-3"></span>
                        {% if session.get('role') == 'superadmin' %}
                        <button class="btn btn-danger btn-sm me-2" onclick="clearAllOrders()" id="clearAllBtn">
                            <i class="fas fa-trash-alt"></i> Clear All Orders
                        </button>
                        {% endif %}
                        <button class="btn btn-success btn-sm" onclick="saveAllChanges()">
                            <i class="fas fa-save"></i> Save All Changes
                        </button>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-hover" id="ordersTable">
                            <thead class="table-dark">
                                <tr>
                                    <th>Order Line</th>
                                    <th>Customer</th>
                                    <th>Client Order Line</th>
                                    <th>Article Code</th>
                                    <th>Description</th>
                                    <th>Quantity</th>
                                    <th>Delivery Date</th>
                                    <th>Status</th>
                                    <th>Priority</th>
                                    <th>Product Group</th>
                                    <th>Order Date</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody id="ordersTableBody">
                                <!-- Data will be loaded here -->
                            </tbody>
                        </table>
                    </div>
                    
                    <!-- Loading indicator -->
                    <div id="loadingIndicator" class="text-center py-4" style="display: none;">
                        <i class="fas fa-spinner fa-spin fa-2x"></i>
                        <p class="mt-2">Loading data...</p>
                    </div>
                    
                    <!-- No data message -->
                    <div id="noDataMessage" class="text-center py-4" style="display: none;">
                        <i class="fas fa-info-circle fa-2x text-muted"></i>
                        <p class="mt-2 text-muted">No orders found</p>
                    </div>
                </div>
                
                <!-- Pagination -->
                <div class="card-footer">
                    <nav aria-label="Orders data pagination">
                        <ul class="pagination pagination-sm justify-content-center mb-0" id="pagination">
                            <!-- Pagination will be generated here -->
                        </ul>
                    </nav>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Edit Modal -->
<div class="modal fade" id="editModal" tabindex="-1" aria-labelledby="editModalLabel" aria-hidden="true" data-bs-backdrop="true" data-bs-keyboard="true">
    <div class="modal-dialog modal-xl modal-dialog-scrollable" style="max-width: 95vw !important; width: 95vw !important;">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editModalLabel">Edit Customer Order</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <form id="editForm">
                    <input type="hidden" id="editRecordId">
                    
                    <div class="row">
                        <!-- Column 1: Order Information -->
                        <div class="col-md-4">
                            
                            <div class="mb-3">
                                <label for="editOrderLine" class="form-label">Order Line</label>
                                <input type="text" class="form-control" id="editOrderLine" readonly>
                            </div>
                            
                            <div class="mb-3">
                                <label for="editOrderId" class="form-label">Order ID</label>
                                <input type="text" class="form-control" id="editOrderId">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editLineNumber" class="form-label">Line Number</label>
                                <input type="text" class="form-control" id="editLineNumber">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editClientOrderLine" class="form-label">Client Order Line</label>
                                <input type="text" class="form-control" id="editClientOrderLine" readonly>
                            </div>
                            
                            <div class="mb-3">
                                <label for="editOrderDate" class="form-label">Order Date</label>
                                <input type="date" class="form-control" id="editOrderDate">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editDeliveryDate" class="form-label">Delivery Date</label>
                                <input type="date" class="form-control" id="editDeliveryDate">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editOrderStatus" class="form-label">Order Status</label>
                                <select class="form-control" id="editOrderStatus">
                                    <option value="PENDING">Pending</option>
                                    <option value="CONFIRMED">Confirmed</option>
                                    <option value="Confirmat">Confirmat</option>
                                    <option value="IN_PROGRESS">In Progress</option>
                                    <option value="FINISHED">Finished</option>
                                    <option value="DELIVERED">Delivered</option>
                                    <option value="CANCELLED">Cancelled</option>
                                </select>
                            </div>
                            
                            <div class="mb-3">
                                <label for="editPriority" class="form-label">Priority</label>
                                <select class="form-control" id="editPriority">
                                    <option value="LOW">Low</option>
                                    <option value="NORMAL">Normal</option>
                                    <option value="HIGH">High</option>
                                    <option value="URGENT">Urgent</option>
                                </select>
                            </div>
                        </div>
                        
                        <!-- Column 2: Customer and Article Information -->
                        <div class="col-md-4">
                            
                            <div class="mb-3">
                                <label for="editCustomerCode" class="form-label">Customer Code</label>
                                <input type="text" class="form-control" id="editCustomerCode">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editCustomerName" class="form-label">Customer Name</label>
                                <input type="text" class="form-control" id="editCustomerName">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editArticleCode" class="form-label">Article Code</label>
                                <input type="text" class="form-control" id="editArticleCode">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editDescription" class="form-label">Article Description</label>
                                <textarea class="form-control" id="editDescription" rows="3"></textarea>
                            </div>
                            
                            <div class="mb-3">
                                <label for="editQuantity" class="form-label">Quantity Requested</label>
                                <input type="number" class="form-control" id="editQuantity">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editBalance" class="form-label">Balance</label>
                                <input type="number" step="0.01" class="form-control" id="editBalance">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editUnitOfMeasure" class="form-label">Unit of Measure</label>
                                <input type="text" class="form-control" id="editUnitOfMeasure">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editArticleStatus" class="form-label">Article Status</label>
                                <input type="text" class="form-control" id="editArticleStatus">
                            </div>
                        </div>
                        
                        <!-- Column 3: Production Information -->
                        <div class="col-md-4">
                            
                            <div class="mb-3">
                                <label for="editProductGroup" class="form-label">Product Group</label>
                                <input type="text" class="form-control" id="editProductGroup">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editModel" class="form-label">Model</label>
                                <input type="text" class="form-control" id="editModel">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editProductionOrder" class="form-label">Production Order</label>
                                <input type="text" class="form-control" id="editProductionOrder">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editProductionStatus" class="form-label">Production Status</label>
                                <input type="text" class="form-control" id="editProductionStatus">
                            </div>
                            
                            <div class="mb-3">
                                <label for="editClosed" class="form-label">Closed</label>
                                <input type="text" class="form-control" id="editClosed">
                            </div>
                        </div>
                    </div>
                </form>
            </div>
            <div class="modal-footer d-flex justify-content-between">
                <button type="button" class="btn btn-danger" onclick="deleteRecord()" style="min-width: 150px;">
                    <i class="fas fa-trash"></i> Delete Record
                </button>
                <div>
                    <button type="button" class="btn btn-secondary me-2" data-bs-dismiss="modal" style="min-width: 100px;">Cancel</button>
                    <button type="button" class="btn btn-primary" onclick="saveRecord()" style="min-width: 150px;">
                        <i class="fas fa-save"></i> Save Changes
                    </button>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
let currentPage = 1;
let currentPerPage = 50;
let currentSearch = '';
let currentStatusFilter = '';
let currentCustomerFilter = '';

document.addEventListener('DOMContentLoaded', function() {
    // Initialize theme
    const savedTheme = localStorage.getItem('theme');
    if (savedTheme === 'dark') {
        document.body.classList.add('dark-mode');
    }
    
    // Load initial data
    loadOrdersData();
    
    // Setup search on enter key
    document.getElementById('searchInput').addEventListener('keypress', function(e) {
        if (e.key === 'Enter') {
            loadOrdersData();
        }
    });
});

function loadOrdersData(page = 1) {
    currentPage = page;
    currentPerPage = document.getElementById('recordsPerPage').value;
    currentSearch = document.getElementById('searchInput').value;
    currentStatusFilter = document.getElementById('statusFilter').value;
    currentCustomerFilter = document.getElementById('customerFilter').value;
    
    // Show loading indicator
    document.getElementById('loadingIndicator').style.display = 'block';
    document.getElementById('ordersTableBody').style.display = 'none';
    document.getElementById('noDataMessage').style.display = 'none';
    
    const params = new URLSearchParams({
        page: currentPage,
        per_page: currentPerPage,
        search: currentSearch,
        status: currentStatusFilter,
        customer: currentCustomerFilter
    });
    
    fetch(`/daily_mirror/api/tune/orders_data?${params}`)
        .then(response => response.json())
        .then(data => {
            document.getElementById('loadingIndicator').style.display = 'none';
            
            if (data.success) {
                if (data.data.length === 0) {
                    document.getElementById('noDataMessage').style.display = 'block';
                } else {
                    displayOrdersData(data.data);
                    updatePagination(data);
                    updateRecordsInfo(data);
                    
                    // Populate filter dropdowns on first load
                    if (currentPage === 1) {
                        populateCustomerFilter(data.customers);
                        populateStatusFilter(data.statuses);
                    }
                }
            } else {
                console.error('Error loading data:', data.error);
                alert('Error loading orders data: ' + data.error);
            }
        })
        .catch(error => {
            document.getElementById('loadingIndicator').style.display = 'none';
            console.error('Error:', error);
            alert('Error loading orders data: ' + error.message);
        });
}

function displayOrdersData(data) {
    const tbody = document.getElementById('ordersTableBody');
    tbody.innerHTML = '';
    tbody.style.display = 'table-row-group';
    
    data.forEach(record => {
        const row = document.createElement('tr');
        row.innerHTML = `
            <td><strong>${record.order_line}</strong></td>
            <td>
                <small class="text-muted d-block">${record.customer_code}</small>
                ${record.customer_name}
            </td>
            <td>${record.client_order_line || '-'}</td>
            <td><code>${record.article_code}</code></td>
            <td><small>${record.article_description || '-'}</small></td>
            <td><span class="badge bg-info">${record.quantity_requested}</span></td>
            <td>${record.delivery_date || '-'}</td>
            <td><span class="badge bg-primary">${record.order_status}</span></td>
            <td><span class="badge bg-warning">${record.priority || 'NORMAL'}</span></td>
            <td><small>${record.product_group || '-'}</small></td>
            <td>${record.order_date || '-'}</td>
            <td>
                <button class="btn btn-sm btn-primary" onclick="editRecord(${record.id})" 
                        title="Edit Order">
                    <i class="fas fa-edit"></i>
                </button>
            </td>
        `;
        tbody.appendChild(row);
    });
}

function populateCustomerFilter(customers) {
    const filter = document.getElementById('customerFilter');
    // Keep the "All Customers" option and add new ones
    const currentValue = filter.value;
    filter.innerHTML = '<option value="">All Customers</option>';
    
    customers.forEach(customer => {
        const option = document.createElement('option');
        option.value = customer.code;
        option.textContent = `${customer.code} - ${customer.name}`;
        filter.appendChild(option);
    });
    
    filter.value = currentValue;
}

function populateStatusFilter(statuses) {
    const filter = document.getElementById('statusFilter');
    const currentValue = filter.value;
    filter.innerHTML = '<option value="">All Statuses</option>';
    
    statuses.forEach(status => {
        const option = document.createElement('option');
        option.value = status;
        option.textContent = status;
        filter.appendChild(option);
    });
    
    filter.value = currentValue;
}

function updatePagination(data) {
    const pagination = document.getElementById('pagination');
    pagination.innerHTML = '';
    
    if (data.total_pages <= 1) return;
    
    // Previous button
    const prevLi = document.createElement('li');
    prevLi.className = `page-item ${data.page === 1 ? 'disabled' : ''}`;
    prevLi.innerHTML = `<a class="page-link" href="#" onclick="loadOrdersData(${data.page - 1})">Previous</a>`;
    pagination.appendChild(prevLi);
    
    // Page numbers
    const startPage = Math.max(1, data.page - 2);
    const endPage = Math.min(data.total_pages, data.page + 2);
    
    for (let i = startPage; i <= endPage; i++) {
        const li = document.createElement('li');
        li.className = `page-item ${i === data.page ? 'active' : ''}`;
        li.innerHTML = `<a class="page-link" href="#" onclick="loadOrdersData(${i})">${i}</a>`;
        pagination.appendChild(li);
    }
    
    // Next button
    const nextLi = document.createElement('li');
    nextLi.className = `page-item ${data.page === data.total_pages ? 'disabled' : ''}`;
    nextLi.innerHTML = `<a class="page-link" href="#" onclick="loadOrdersData(${data.page + 1})">Next</a>`;
    pagination.appendChild(nextLi);
}

function updateRecordsInfo(data) {
    const start = (data.page - 1) * data.per_page + 1;
    const end = Math.min(data.page * data.per_page, data.total_records);
    document.getElementById('recordsInfo').textContent = 
        `Showing ${start}-${end} of ${data.total_records} orders`;
}

function clearFilters() {
    document.getElementById('searchInput').value = '';
    document.getElementById('statusFilter').value = '';
    document.getElementById('customerFilter').value = '';
    loadOrdersData(1);
}

function editRecord(recordId) {
    // Find the record data from the current display
    const rows = document.querySelectorAll('#ordersTableBody tr');
    let recordData = null;
    
    // Get data via API for editing
    fetch(`/daily_mirror/api/tune/orders_data?page=${currentPage}&per_page=${currentPerPage}&search=${currentSearch}&status=${currentStatusFilter}&customer=${currentCustomerFilter}`)
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                recordData = data.data.find(record => record.id === recordId);
                if (recordData) {
                    populateEditModal(recordData);
                    
                    // Get modal elements
                    const modalElement = document.getElementById('editModal');
                    const modalDialog = modalElement.querySelector('.modal-dialog');
                    
                    // Remove any existing modal instances to prevent conflicts
                    const existingModal = bootstrap.Modal.getInstance(modalElement);
                    if (existingModal) {
                        existingModal.dispose();
                    }
                    
                    const modal = new bootstrap.Modal(modalElement, {
                        backdrop: true,
                        keyboard: true,
                        focus: true
                    });
                    
                    // Show the modal first
                    modal.show();
                    
                    // Force the modal dialog width AFTER modal is shown - using 95% of viewport width
                    setTimeout(() => {
                        if (modalDialog) {
                            console.log('Applying width after modal shown');
                            modalDialog.style.setProperty('max-width', '95vw', 'important');
                            modalDialog.style.setProperty('width', '95vw', 'important');
                            modalDialog.style.setProperty('margin', '1.75rem auto', 'important');
                            
                            // Also apply to modal content for good measure
                            const modalContent = modalDialog.querySelector('.modal-content');
                            if (modalContent) {
                                modalContent.style.setProperty('width', '100%', 'important');
                            }
                            
                            console.log('Modal dialog computed width:', window.getComputedStyle(modalDialog).width);
                        }
                    }, 100);
                }
            }
        })
        .catch(error => {
            console.error('Error:', error);
            alert('Error loading record data: ' + error.message);
        });
}

function populateEditModal(record) {
    document.getElementById('editRecordId').value = record.id;
    document.getElementById('editOrderLine').value = record.order_line;
    document.getElementById('editOrderId').value = record.order_id;
    document.getElementById('editLineNumber').value = record.line_number || '';
    document.getElementById('editCustomerCode').value = record.customer_code;
    document.getElementById('editCustomerName').value = record.customer_name;
    document.getElementById('editClientOrderLine').value = record.client_order_line || '';
    document.getElementById('editArticleCode').value = record.article_code;
    document.getElementById('editDescription').value = record.article_description || '';
    document.getElementById('editQuantity').value = record.quantity_requested;
    document.getElementById('editBalance').value = record.balance || '';
    document.getElementById('editUnitOfMeasure').value = record.unit_of_measure || '';
    document.getElementById('editDeliveryDate').value = record.delivery_date;
    document.getElementById('editOrderDate').value = record.order_date;
    document.getElementById('editOrderStatus').value = record.order_status;
    document.getElementById('editArticleStatus').value = record.article_status || '';
    document.getElementById('editPriority').value = record.priority || 'NORMAL';
    document.getElementById('editProductGroup').value = record.product_group || '';
    document.getElementById('editProductionOrder').value = record.production_order || '';
    document.getElementById('editProductionStatus').value = record.production_status || '';
    document.getElementById('editModel').value = record.model || '';
    document.getElementById('editClosed').value = record.closed || '';
}

function saveRecord() {
    const recordId = document.getElementById('editRecordId').value;
    const data = {
        order_line: document.getElementById('editOrderLine').value,
        order_id: document.getElementById('editOrderId').value,
        line_number: document.getElementById('editLineNumber').value,
        customer_code: document.getElementById('editCustomerCode').value,
        customer_name: document.getElementById('editCustomerName').value,
        client_order_line: document.getElementById('editClientOrderLine').value,
        article_code: document.getElementById('editArticleCode').value,
        article_description: document.getElementById('editDescription').value,
        quantity_requested: parseInt(document.getElementById('editQuantity').value) || 0,
        balance: parseFloat(document.getElementById('editBalance').value) || null,
        unit_of_measure: document.getElementById('editUnitOfMeasure').value,
        delivery_date: document.getElementById('editDeliveryDate').value,
        order_date: document.getElementById('editOrderDate').value,
        order_status: document.getElementById('editOrderStatus').value,
        article_status: document.getElementById('editArticleStatus').value,
        priority: document.getElementById('editPriority').value,
        product_group: document.getElementById('editProductGroup').value,
        production_order: document.getElementById('editProductionOrder').value,
        production_status: document.getElementById('editProductionStatus').value,
        model: document.getElementById('editModel').value,
        closed: document.getElementById('editClosed').value
    };
    
    fetch(`/daily_mirror/api/tune/orders_data/${recordId}`, {
        method: 'PUT',
        headers: {
            'Content-Type': 'application/json',
        },
        body: JSON.stringify(data)
    })
    .then(response => response.json())
    .then(result => {
        if (result.success) {
            // Close modal
            const editModal = bootstrap.Modal.getInstance(document.getElementById('editModal'));
            editModal.hide();
            
            // Reload data
            loadOrdersData(currentPage);
            
            // Show success message
            alert('Order updated successfully!');
        } else {
            alert('Error updating order: ' + result.error);
        }
    })
    .catch(error => {
        console.error('Error:', error);
        alert('Error updating order: ' + error.message);
    });
}

function deleteRecord() {
    const recordId = document.getElementById('editRecordId').value;
    const orderLine = document.getElementById('editOrderLine').value;
    
    if (!confirm(`⚠️ Are you sure you want to delete order line "${orderLine}"?\n\nThis action cannot be undone.`)) {
        return;
    }
    
    fetch(`/daily_mirror/api/tune/orders_data/${recordId}`, {
        method: 'DELETE',
        headers: {
            'Content-Type': 'application/json'
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.error) {
            throw new Error(data.error);
        }
        
        // Close modal and reload data
        const modal = bootstrap.Modal.getInstance(document.getElementById('editModal'));
        modal.hide();
        
        alert('Record deleted successfully!');
        loadOrdersData(currentPage);
    })
    .catch(error => {
        console.error('Error deleting record:', error);
        alert('Error deleting record: ' + error.message);
    });
}

function saveAllChanges() {
    alert('Save All Changes functionality will be implemented for bulk operations.');
}

function clearAllOrders() {
    if (!confirm('⚠️ WARNING: This will permanently delete ALL customer orders from the database!\n\nAre you absolutely sure you want to continue?')) {
        return;
    }
    
    // Second confirmation for safety
    if (!confirm('This action CANNOT be undone! All customer order data will be lost.\n\nClick OK to proceed with deletion.')) {
        return;
    }
    
    const clearBtn = document.getElementById('clearAllBtn');
    const originalText = clearBtn.innerHTML;
    clearBtn.disabled = true;
    clearBtn.innerHTML = '<i class="fas fa-spinner fa-spin"></i> Deleting...';
    
    fetch('/daily_mirror/clear_orders', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            alert('✅ ' + data.message);
            // Reload the page to show empty table
            loadOrdersData(1);
        } else {
            alert('❌ Error: ' + (data.message || 'Failed to clear orders'));
        }
    })
    .catch(error => {
        console.error('Error:', error);
        alert('❌ Error clearing orders: ' + error.message);
    })
    .finally(() => {
        clearBtn.disabled = false;
        clearBtn.innerHTML = originalText;
    });
}
</script>
{% endblock %}