@extends('layouts.auth.app')

@section('title', 'Operation Manager - Employer PAYE Liability Report')

@section('content')
<div class="space-y-6">
    <!-- Page Header -->
    <div class="flex items-center justify-between">
        <div>
            <h1 class="text-2xl font-semibold text-gray-900">Operation Manager - Employer PAYE Liability Report</h1>
            <p class="mt-1 text-sm text-gray-500">View employer PAYE liability report with TCC information</p>
        </div>
        <div>
            <button type="button" id="btnExportToExcel" class="inline-flex items-center px-4 py-2 bg-teal-600 border border-transparent rounded-lg font-semibold text-sm text-white hover:bg-teal-700 transition-colors">
                <svg xmlns="http://www.w3.org/2000/svg" class="h-5 w-5 mr-2" fill="none" viewBox="0 0 24 24" stroke="currentColor">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 10v6m0 0l-3-3m3 3l3-3m2 8H7a2 2 0 01-2-2V5a2 2 0 012-2h5.586a1 1 0 01.707.293l5.414 5.414a1 1 0 01.293.707V19a2 2 0 01-2 2z" />
                </svg>
                Export To Excel
            </button>
        </div>
    </div>

    <!-- Data Table Card -->
    <div class="bg-white rounded-2xl shadow-sm border border-gray-100">
        <div class="px-6 py-4 border-b border-gray-200 bg-gray-50">
            <h3 class="text-lg font-semibold text-gray-900">Employer PAYE Liability Report</h3>
        </div>

        <!-- Table Controls -->
        <div class="px-6 py-3 bg-white border-b border-gray-200">
            <div class="flex items-center justify-between flex-wrap gap-4">
                <div class="flex items-center space-x-2">
                    <span class="text-sm text-gray-700">Show:</span>
                    <select id="itemsPerPage" class="px-2 py-1 text-sm border border-gray-300 rounded-md focus:ring-2 focus:ring-teal-500 focus:border-teal-500">
                        <option value="10">10</option>
                        <option value="25">25</option>
                        <option value="50">50</option>
                        <option value="100">100</option>
                    </select>
                    <span class="text-sm text-gray-700">entries</span>
                </div>
                <div class="flex items-center space-x-2">
                    <label for="tableSearch" class="text-sm text-gray-700">Search:</label>
                    <input type="text" id="tableSearch" placeholder="Type to filter..." class="px-3 py-1 text-sm border border-gray-300 rounded-md focus:ring-2 focus:ring-teal-500 focus:border-teal-500 w-48">
                </div>
            </div>
        </div>

        <!-- Table -->
        <div class="overflow-x-auto">
            <table id="tblEmployerPAYELiability" class="min-w-full divide-y divide-gray-200">
                <thead class="bg-gray-50">
                    <tr>
                        <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100" data-column="0">
                            RIN
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100" data-column="1">
                            Tax Payer Name
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100 hidden lg:table-cell" data-column="2">
                            Mobile Number
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100" data-column="3">
                            Asset Name
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100" data-column="4">
                            Count of Staff
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100 hidden xl:table-cell" data-column="5">
                            Count of PAYE Bills
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100 hidden xl:table-cell" data-column="6">
                            PAYE Bill Amount
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100 hidden xl:table-cell" data-column="7">
                            PAYE Bill Payment
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider cursor-pointer hover:bg-gray-100" data-column="8">
                            Liability
                            <span class="sort-icon ml-1"></span>
                        </th>
                        <th scope="col" class="px-6 py-3 text-center text-xs font-medium text-gray-500 uppercase tracking-wider">
                            Action
                        </th>
                    </tr>
                </thead>
                <tbody id="tableBody" class="bg-white divide-y divide-gray-200">
                    <!-- Data will be loaded via AJAX -->
                </tbody>
            </table>
        </div>

        <!-- Loading Spinner -->
        <div id="loadingSpinner" class="px-6 py-8 text-center">
            <div class="inline-block animate-spin rounded-full h-8 w-8 border-b-2 border-teal-600"></div>
            <p class="mt-2 text-sm text-gray-500">Loading...</p>
        </div>

        <!-- Empty State -->
        <div id="emptyState" class="hidden px-6 py-8 text-center">
            <p class="text-gray-500">No data found</p>
        </div>

        <!-- Pagination -->
        <div class="px-6 py-4 bg-gray-50 border-t border-gray-200">
            <div class="flex items-center justify-between flex-wrap gap-4">
                <p class="text-sm text-gray-700">
                    Showing <span id="showingFrom" class="font-medium">0</span> to <span id="showingTo" class="font-medium">0</span> of <span id="totalRecords" class="font-medium">0</span> results
                </p>
                <div id="paginationControls" class="flex items-center space-x-1">
                    <!-- Will be populated by JavaScript -->
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() {
    let currentPage = 1;
    let itemsPerPage = 10;
    let searchTerm = '';
    let totalRecords = 0;
    let sortColumn = 1;
    let sortDirection = 'asc';

    // Initial load
    loadData();

    // Export to Excel
    $('#btnExportToExcel').on('click', function() {
        window.open('{{ route("operation-manager.employer-paye-liability-export") }}', '_blank');
    });

    // Items per page change
    $('#itemsPerPage').on('change', function() {
        itemsPerPage = parseInt($(this).val());
        currentPage = 1;
        loadData();
    });

    // Search input with debounce
    let searchTimeout;
    $('#tableSearch').on('keyup', function() {
        clearTimeout(searchTimeout);
        searchTimeout = setTimeout(function() {
            searchTerm = $('#tableSearch').val();
            currentPage = 1;
            loadData();
        }, 300);
    });

    // Column header click for sorting
    $('th[data-column]').on('click', function() {
        const column = parseInt($(this).data('column'));
        if (sortColumn === column) {
            sortDirection = sortDirection === 'asc' ? 'desc' : 'asc';
        } else {
            sortColumn = column;
            sortDirection = 'asc';
        }
        updateSortIcons();
        loadData();
    });

    function updateSortIcons() {
        $('.sort-icon').html('');
        const activeHeader = $('th[data-column="' + sortColumn + '"] .sort-icon');
        if (sortDirection === 'asc') {
            activeHeader.html('<svg class="inline w-3 h-3" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M5 15l7-7 7 7"/></svg>');
        } else {
            activeHeader.html('<svg class="inline w-3 h-3" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M19 9l-7 7-7-7"/></svg>');
        }
    }

    function loadData() {
        $('#loadingSpinner').removeClass('hidden');
        $('#tableBody').html('');
        $('#emptyState').addClass('hidden');

        $.ajax({
            url: '{{ route("operation-manager.employer-paye-liability-load-data") }}',
            type: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                draw: 1,
                start: (currentPage - 1) * itemsPerPage,
                length: itemsPerPage,
                'search[value]': searchTerm,
                'order[0][column]': sortColumn,
                'order[0][dir]': sortDirection
            },
            success: function(response) {
                $('#loadingSpinner').addClass('hidden');
                totalRecords = response.recordsTotal;

                if (response.data && response.data.length > 0) {
                    renderTable(response.data);
                    updatePagination();
                } else {
                    $('#emptyState').removeClass('hidden');
                    updatePaginationInfo(0, 0, 0);
                    $('#paginationControls').html('');
                }
            },
            error: function(xhr, status, error) {
                $('#loadingSpinner').addClass('hidden');
                $('#emptyState').removeClass('hidden').find('p').text('Error loading data. Please try again.');
                console.error('Error loading data:', error);
            }
        });
    }

    function formatMoney(amount) {
        if (amount === null || amount === undefined) return '0.00';
        return parseFloat(amount).toLocaleString('en-NG', {
            minimumFractionDigits: 2,
            maximumFractionDigits: 2
        });
    }

    function renderTable(data) {
        let html = '';

        data.forEach(function(row) {
            const viewDetailUrl = '{{ route("operation-manager.employer-paye-liability-details") }}?tpid=' + row.TaxPayerID + '&aid=' + row.AssetID;

            html += '<tr class="hover:bg-gray-50">';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' + (row.TaxPayerRIN || '') + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' + (row.TaxPayerName || '') + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 hidden lg:table-cell">' + (row.MobileNumber || '') + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' + (row.AssetName || '') + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 text-right">' + (row.StaffCount || 0) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 text-right hidden xl:table-cell">' + (row.BillCount || 0) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 text-right hidden xl:table-cell">' + formatMoney(row.BillAmount) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 text-right hidden xl:table-cell">' + formatMoney(row.PaymentAmount) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm font-semibold text-right ' + (row.Balance > 0 ? 'text-red-600' : 'text-green-600') + '">' + formatMoney(row.Balance) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-center">';
            html += '<div class="relative inline-block text-left">';
            html += '<button type="button" class="action-dropdown-btn inline-flex items-center px-3 py-1.5 bg-teal-600 text-white text-xs font-medium rounded-lg hover:bg-teal-700 transition-colors">';
            html += 'Action <svg class="ml-1 w-4 h-4" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M19 9l-7 7-7-7"/></svg>';
            html += '</button>';
            html += '<div class="action-dropdown-menu hidden absolute right-0 z-50 mt-2 w-48 origin-top-right rounded-md bg-white shadow-lg ring-1 ring-black ring-opacity-5">';
            html += '<div class="py-1">';
            html += '<a href="' + viewDetailUrl + '" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">View Liability Report</a>';
            html += '</div></div></div></td>';
            html += '</tr>';
        });
        $('#tableBody').html(html);

        // Setup dropdown toggles
        $('.action-dropdown-btn').on('click', function(e) {
            e.stopPropagation();
            const menu = $(this).next('.action-dropdown-menu');
            $('.action-dropdown-menu').not(menu).addClass('hidden');
            menu.toggleClass('hidden');
        });
    }

    // Close dropdowns when clicking outside
    $(document).on('click', function() {
        $('.action-dropdown-menu').addClass('hidden');
    });

    function updatePagination() {
        let start = totalRecords > 0 ? (currentPage - 1) * itemsPerPage + 1 : 0;
        let end = Math.min(currentPage * itemsPerPage, totalRecords);
        updatePaginationInfo(start, end, totalRecords);

        let totalPages = Math.ceil(totalRecords / itemsPerPage);
        let paginationHtml = '';

        if (totalPages > 0) {
            paginationHtml += '<button class="px-3 py-1 text-sm border border-gray-300 rounded-md ' + (currentPage === 1 ? 'bg-gray-100 text-gray-400 cursor-not-allowed' : 'bg-white text-gray-700 hover:bg-gray-50') + '" ' + (currentPage === 1 ? 'disabled' : '') + ' data-page="' + (currentPage - 1) + '">Previous</button>';

            let startPage = Math.max(1, currentPage - 2);
            let endPage = Math.min(totalPages, currentPage + 2);

            if (startPage > 1) {
                paginationHtml += '<button class="px-3 py-1 text-sm border border-gray-300 rounded-md bg-white text-gray-700 hover:bg-gray-50" data-page="1">1</button>';
                if (startPage > 2) {
                    paginationHtml += '<span class="px-2 text-gray-500">...</span>';
                }
            }

            for (let i = startPage; i <= endPage; i++) {
                paginationHtml += '<button class="px-3 py-1 text-sm border rounded-md ' + (i === currentPage ? 'bg-teal-600 text-white border-teal-600' : 'bg-white text-gray-700 border-gray-300 hover:bg-gray-50') + '" data-page="' + i + '">' + i + '</button>';
            }

            if (endPage < totalPages) {
                if (endPage < totalPages - 1) {
                    paginationHtml += '<span class="px-2 text-gray-500">...</span>';
                }
                paginationHtml += '<button class="px-3 py-1 text-sm border border-gray-300 rounded-md bg-white text-gray-700 hover:bg-gray-50" data-page="' + totalPages + '">' + totalPages + '</button>';
            }

            paginationHtml += '<button class="px-3 py-1 text-sm border border-gray-300 rounded-md ' + (currentPage === totalPages ? 'bg-gray-100 text-gray-400 cursor-not-allowed' : 'bg-white text-gray-700 hover:bg-gray-50') + '" ' + (currentPage === totalPages ? 'disabled' : '') + ' data-page="' + (currentPage + 1) + '">Next</button>';
        }

        $('#paginationControls').html(paginationHtml);

        $('#paginationControls button:not(:disabled)').on('click', function() {
            currentPage = parseInt($(this).data('page'));
            loadData();
        });
    }

    function updatePaginationInfo(from, to, total) {
        $('#showingFrom').text(from);
        $('#showingTo').text(to);
        $('#totalRecords').text(total);
    }

    // Initialize sort icon
    updateSortIcons();
});
</script>
@endpush