@extends('layouts.business')

@section('title', 'Clients')
@section('breadcrumb_title', 'Clients')
@section('breadcrumb_title_route', route('business.clients.index'))
@section('breadcrumb_sub_title', 'List')
@section('page_title', 'Clients')

@section('content')
    <div class="min-h-screen bg-gray-50">
        <div class="row mt-4">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <h5 class="mb-0">Clients</h5>
                                <p class="text-sm mb-0">View all clients and their bookings.</p>
                            </div>
                        </div>
                    </div>

                    <div class="table-responsive">
                        <table class="table table-flush" id="datatable-search">
                            <thead class="thead-light">
                                <tr>
                                    <th>#</th>
                                    <th>Full Name</th>
                                    <th>Email</th>
                                    <th>Phone</th>
                                    <th>Total Bookings</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody id="clients-table-body">
                                <!-- Data will be loaded here via JavaScript -->
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <!-- DataTables Script -->
    <script src="{{ asset('js/plugins/datatables.js') }}"></script>

    <style>
        .jconfirm .jconfirm-buttons .btn {
            width: 120px !important;
            min-width: 120px !important;
        }

        /* Set table font size */
        #datatable-search {
            font-size: 14px;
        }

        #datatable-search th {
            font-size: 10px;
            white-space: nowrap !important;
            padding-right: 25px !important;
            position: relative !important;
        }

        #datatable-search td {
            font-size: 14px;
            white-space: nowrap !important;
        }

        /* Fix DataTable sorting overlap */
        .dataTable-sorter {
            padding-right: 20px !important;
        }

        .dataTable-table th a {
            display: inline-block !important;
            padding-right: 20px !important;
            position: relative !important;
        }

        .dataTable-table th.dataTable-ascending a::after,
        .dataTable-table th.dataTable-descending a::after {
            position: absolute !important;
            right: 5px !important;
            top: 50% !important;
            transform: translateY(-50%) !important;
        }

        /* Prevent text overflow and overlap */
        .dataTable-table th,
        .dataTable-table td {
            overflow: visible !important;
            text-overflow: ellipsis !important;
        }

        /* Ensure proper column spacing */
        .dataTable-table thead th {
            padding: 12px 25px 12px 15px !important;
            vertical-align: middle !important;
        }

        .dataTable-table tbody td {
            padding: 10px 15px !important;
            vertical-align: middle !important;
        }

        /* Fix table header alignment */
        .dataTable-top,
        .dataTable-bottom {
            padding: 8px 10px !important;
        }

        /* Prevent sorting arrow overlap */
        .dataTable-sorter::before,
        .dataTable-sorter::after {
            right: 8px !important;
        }
    </style>

    <script>
        $(document).ready(function() {
            let dataTable;
            let currentFilters = {};

            // Load initial data
            loadClients(true);

            function initializeDataTable() {
                // Initialize DataTable only once
                dataTable = new simpleDatatables.DataTable("#datatable-search", {
                    searchable: true,
                    fixedHeight: true,
                    perPage: 10,
                    perPageSelect: [5, 10, 15, 20, 25],
                    paging: true,
                    nextPrev: true,
                    firstLast: false,
                    columns: [
                        {
                            select: 0, // # (ID) - Sortable
                            sortable: true
                        },
                        {
                            select: 1, // Full Name - Sortable
                            sortable: true
                        },
                        {
                            select: 2, // Email - Sortable
                            sortable: true
                        },
                        {
                            select: 3, // Phone - Not sortable
                            sortable: false
                        },
                        {
                            select: 4, // Total Bookings - Sortable
                            sortable: true
                        },
                        {
                            select: 5, // Actions - Not sortable
                            sortable: false
                        }
                    ],
                    labels: {
                        placeholder: "Search...",
                        perPage: "{select} entries per page",
                        noRows: "No entries found",
                        info: "Showing {start} to {end} of {rows} entries"
                    }
                });

                // Custom sort comparator using data-order attributes
                dataTable.on('datatable.sort', function(column, direction) {
                    const tbody = dataTable.table.tBodies[0];
                    const rows = Array.from(tbody.querySelectorAll('tr'));
                    
                    rows.sort((rowA, rowB) => {
                        const cellA = rowA.cells[column];
                        const cellB = rowB.cells[column];
                        
                        if (!cellA || !cellB) return 0;
                        
                        // Get sort values from data-order attribute
                        let valueA = cellA.getAttribute('data-order') || cellA.textContent.trim();
                        let valueB = cellB.getAttribute('data-order') || cellB.textContent.trim();
                        
                        // Try to parse as numbers
                        const numA = parseFloat(valueA);
                        const numB = parseFloat(valueB);
                        
                        if (!isNaN(numA) && !isNaN(numB)) {
                            // Numeric comparison
                            return direction === 'desc' ? numB - numA : numA - numB;
                        } else {
                            // String comparison
                            if (direction === 'desc') {
                                return valueB.toString().localeCompare(valueA.toString());
                            } else {
                                return valueA.toString().localeCompare(valueB.toString());
                            }
                        }
                    });
                    
                    // Re-append rows in sorted order
                    rows.forEach(row => tbody.appendChild(row));
                });

                console.log('DataTable initialized');
            }

            function loadClients(isInitialLoad = false) {
                console.log('Loading Clients with filters:', currentFilters);

                // Only show loader if it's not the initial page load
                if (!isInitialLoad && $('#loader').length) {
                    $('#loader').show();
                }

                $.get('{{ route('business.clients.get-list') }}', currentFilters)
                    .done(function(response) {
                        console.log(response);
                        if ($('#loader').length) {
                            $('#loader').hide();
                        }

                        if (response.success) {
                            if (dataTable) {
                                try {
                                    dataTable.destroy();
                                    dataTable = null;
                                } catch (error) {
                                    console.error('Error destroying DataTable:', error);
                                }
                            }

                            // Update table body with new data
                            updateTableBody(response.data);

                            // Reinitialize DataTable after a small delay
                            setTimeout(function() {
                                initializeDataTable();
                            }, 100);
                        } else {
                            showError('Failed to load clients');
                        }
                    })
                    .fail(function() {
                        if ($('#loader').length) {
                            $('#loader').hide();
                        }
                        showError('Error loading clients');
                    });
            }

            function updateTableBody(clients) {
                let rowsHtml = '';

                if (clients.length === 0) {
                    rowsHtml =
                        '<tr><td colspan="6" class="text-center text-muted py-4">No clients found.</td></tr>';
                } else {
                    clients.forEach(function(client, index) {
                        rowsHtml += '<tr>' +
                            '<td class="text-sm font-weight-normal" style="padding: 0.75rem 1.5rem;">' + (index + 1) + '</td>' +
                            '<td class="text-sm font-weight-normal" style="padding: 0.75rem 1.5rem;">' +
                            escapeHtml(client.full_name || 'N/A') + '</td>' +
                            '<td class="text-sm font-weight-normal" style="padding: 0.75rem 1.5rem;">' +
                            escapeHtml(client.email || 'N/A') + '</td>' +
                            '<td class="text-sm font-weight-normal" style="padding: 0.75rem 1.5rem;">' +
                            escapeHtml(client.phone || 'N/A') + '</td>' +
                            '<td class="text-sm font-weight-normal" style="padding: 0.75rem 1.5rem;" data-order="' + (client.total_bookings || 0) + '">' +
                            '<span class="badge bg-primary">' + (client.total_bookings || 0) + ' Bookings</span>' +
                            '</td>' +
                            '<td class="text-sm font-weight-normal">' +
                            '<div class="d-flex align-items-center">' +
                            '<a href="{{ route('business.clients.show', '') }}/' + client.id + '" ' +
                            'class="text-info me-3" style="cursor: pointer; font-size: 16px;" title="View">' +
                            '<i class="fas fa-eye"></i></a>' +
                            '</div>' +
                            '</td>' +
                            '</tr>';
                    });
                }

                $('#clients-table-body').html(rowsHtml);
            }

            function showError(message) {
                $.confirm({
                    theme: 'modern',
                    columnClass: 'col-lg-6 col-md-8 col-sm-10 col-12',
                    title: 'Error!',
                    content: message,
                    type: 'red',
                    typeAnimated: true,
                    buttons: {
                        confirm: {
                            text: 'OK',
                            btnClass: 'btn-danger'
                        }
                    }
                });
            }

            // Helper function to escape HTML
            function escapeHtml(text) {
                if (text === null || text === undefined) {
                    return '';
                }
                // Convert to string if not already
                text = String(text);
                const map = {
                    '&': '&amp;',
                    '<': '&lt;',
                    '>': '&gt;',
                    '"': '&quot;',
                    "'": '&#039;'
                };
                return text.replace(/[&<>"']/g, function(m) {
                    return map[m];
                });
            }
        });
    </script>
@endsection