@extends('layouts.auth.app')

@section('title', 'Bill Aging Details by Tax Office')

@section('content')
<!-- Hidden fields for JavaScript -->
<input type="hidden" value="{{ $billTypeId }}" id="hdnBillTypeID" />
<input type="hidden" value="{{ $stageId }}" id="hdnStageID" />
<input type="hidden" value="{{ $taxOfficeId }}" id="hdnTaxOfficeID" />

<!-- Header -->
<div class="mb-4">
    <a href="{{ route('operation-manager.bill-aging-by-tax-office') }}" class="inline-flex items-center text-sm text-gray-600 hover:text-teal-600">
        <svg xmlns="http://www.w3.org/2000/svg" class="h-4 w-4 mr-1" fill="none" viewBox="0 0 24 24" stroke="currentColor">
            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M10 19l-7-7m0 0l7-7m-7 7h18" />
        </svg>
        Back to Bill Aging by Tax Office
    </a>
</div>

<!-- Results Table -->
<div class="bg-white rounded-2xl shadow-sm border border-gray-100 overflow-hidden">
    <div class="px-6 py-4 border-b border-gray-200">
        <div class="flex items-center justify-between">
            <div>
                <h3 class="text-lg font-semibold text-gray-900">Bill Aging Details</h3>
                <p class="text-sm text-gray-500 mt-1">Bill List by Tax Office</p>
            </div>
            <div class="flex space-x-3">
                <a href="{{ route('operation-manager.bill-aging-by-tax-office') }}" class="inline-flex items-center px-4 py-2 bg-gray-600 border border-transparent rounded-md font-semibold text-xs text-white uppercase tracking-widest hover:bg-gray-700 transition-colors">
                    Cancel
                </a>
                <a href="{{ route('operation-manager.bill-aging-details-by-tax-office-export', ['BillTypeID' => $billTypeId, 'StageID' => $stageId, 'TaxOfficeID' => $taxOfficeId]) }}" target="_blank" class="inline-flex items-center px-4 py-2 bg-teal-600 border border-transparent rounded-md font-semibold text-xs text-white uppercase tracking-widest hover:bg-teal-700 transition-colors">
                    <svg xmlns="http://www.w3.org/2000/svg" class="h-4 w-4 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 Excel
                </a>
            </div>
        </div>
    </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="tblBillAgingDetails" 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">
                        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" data-column="1">
                        Bill Ref No
                        <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="2">
                        Bill Date
                        <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="3">
                        Amount
                        <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="4">
                        Bill Status
                        <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="hidden 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>
@endsection

@push('scripts')
<script>
// TaxPayerType constants - matches .NET
const TaxPayerType = {
    Individual: 1,
    Company: 2,
    Government: 3,
    Special: 4
};

$(document).ready(function() {
    let currentPage = 1;
    let itemsPerPage = 10;
    let searchTerm = '';
    let totalRecords = 0;
    let sortColumn = 1;
    let sortDirection = 'asc';

    // Load initial data
    loadData();

    // 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.bill-aging-details-by-tax-office-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,
                BillTypeID: $('#hdnBillTypeID').val(),
                StageID: $('#hdnStageID').val(),
                TaxOfficeID: $('#hdnTaxOfficeID').val()
            },
            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 formatDate(dateString) {
        if (!dateString) return '';
        try {
            const date = new Date(dateString);
            if (isNaN(date.getTime())) return '';
            const months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
            const day = String(date.getDate()).padStart(2, '0');
            const month = months[date.getMonth()];
            const year = date.getFullYear();
            return day + '-' + month + '-' + year;
        } catch (e) {
            return '';
        }
    }

    function toSeoUrl(str) {
        if (!str) return '';
        return str.toLowerCase().replace(/\s+/g, '-').replace(/[^a-z0-9-]/g, '');
    }

    function getTaxPayerDetailUrl(taxPayerId, taxPayerTypeId, taxPayerName) {
        const seoName = toSeoUrl(taxPayerName);
        switch (parseInt(taxPayerTypeId)) {
            case TaxPayerType.Individual:
                return '/CaptureIndividual/Details?id=' + taxPayerId + '&name=' + seoName;
            case TaxPayerType.Company:
                return '/CaptureCorporate/Details?id=' + taxPayerId + '&name=' + seoName;
            case TaxPayerType.Government:
                return '/CaptureGovernment/Details?id=' + taxPayerId + '&name=' + seoName;
            case TaxPayerType.Special:
                return '/CaptureSpecial/Details?id=' + taxPayerId + '&name=' + seoName;
            default:
                return '#';
        }
    }

    function getBillDetailUrl(taxPayerId, taxPayerTypeId, taxPayerName, billId, billRefNo) {
        // Redirect to taxpayer details page with action=viewbill to auto-open the View Bill modal
        const seoName = toSeoUrl(taxPayerName);
        const viewBillParams = '&action=viewbill&billid=' + billId + '&billrefno=' + encodeURIComponent(billRefNo);
        switch (parseInt(taxPayerTypeId)) {
            case TaxPayerType.Individual:
                return '/CaptureIndividual/Details/' + taxPayerId + '/' + seoName + '?action=viewbill&billid=' + billId + '&billrefno=' + encodeURIComponent(billRefNo);
            case TaxPayerType.Company:
                return '/CaptureCorporate/Details/' + taxPayerId + '/' + seoName + '?action=viewbill&billid=' + billId + '&billrefno=' + encodeURIComponent(billRefNo);
            case TaxPayerType.Government:
                return '/CaptureGovernment/Details/' + taxPayerId + '/' + seoName + '?action=viewbill&billid=' + billId + '&billrefno=' + encodeURIComponent(billRefNo);
            case TaxPayerType.Special:
                return '/CaptureSpecial/Details/' + taxPayerId + '/' + seoName + '?action=viewbill&billid=' + billId + '&billrefno=' + encodeURIComponent(billRefNo);
            default:
                return '#';
        }
    }

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

        data.forEach(function(row) {
            const taxPayerDetailUrl = getTaxPayerDetailUrl(row.TaxPayerID, row.TaxPayerTypeID, row.TaxPayerName);
            const billDetailUrl = getBillDetailUrl(row.TaxPayerID, row.TaxPayerTypeID, row.TaxPayerName, row.BillID, row.BillRef);

            html += '<tr class="hover:bg-gray-50">';
            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-900">' + (row.BillRef || '') + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' + formatDate(row.BillDate) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 text-right">' + formatMoney(row.Amount) + '</td>';
            html += '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' + (row.BillStatusName || '') + '</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-10 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="' + taxPayerDetailUrl + '" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">Tax Payer Details</a>';
            html += '<a href="' + billDetailUrl + '" class="block px-4 py-2 text-sm text-gray-700 hover:bg-gray-100">View Bill</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