@extends('layouts.auth.app')

@section('title', 'Revise Bill Summary')

@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">Revise Bill Summary</h1>
            <p class="mt-1 text-sm text-gray-500">View summary of revised bills</p>
        </div>
    </div>

    <!-- Search Filters Card -->
    <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 bg-gray-50">
            <h3 class="text-lg font-semibold text-gray-900">Search Filters</h3>
        </div>

        <div class="px-6 py-4">
            <form id="frmSearch">
                <div class="grid grid-cols-1 md:grid-cols-3 lg:grid-cols-5 gap-4">
                    <!-- Year -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Year <span class="text-red-500">*</span></label>
                        <select name="TaxYear" id="cboTaxYear" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-teal-500 focus:border-teal-500" required>
                            @foreach($yearList ?? [] as $year)
                            <option value="{{ $year }}" {{ $year == date('Y') ? 'selected' : '' }}>{{ $year }}</option>
                            @endforeach
                        </select>
                    </div>

                    <!-- From Date -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">From Date</label>
                        <input type="date" name="FromDate" id="txtFromDate" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-teal-500 focus:border-teal-500">
                    </div>

                    <!-- To Date -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">To Date</label>
                        <input type="date" name="ToDate" id="txtToDate" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-teal-500 focus:border-teal-500">
                    </div>

                    <!-- Bill Type -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Bill Type</label>
                        <select name="BillTypeID" id="cboBillTypeID" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-teal-500 focus:border-teal-500">
                            @foreach($billTypeList ?? [] as $billType)
                            <option value="{{ $billType->BillTypeID }}">{{ $billType->BillTypeName }}</option>
                            @endforeach
                        </select>
                    </div>

                    <!-- Revenue Stream -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Revenue Stream</label>
                        <select name="RevenueStreamID" id="cboRevenueStreamID" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-teal-500 focus:border-teal-500">
                            <option value="0">All Revenue Streams</option>
                            @foreach($revenueStreamList ?? [] as $stream)
                            <option value="{{ $stream->RevenueStreamID }}">{{ $stream->RevenueStreamName }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="mt-4 flex justify-end space-x-3">
                    <button type="submit" 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="M21 21l-6-6m2-5a7 7 0 11-14 0 7 7 0 0114 0z" />
                        </svg>
                        Search
                    </button>
                    <button type="button" id="btnExport" class="inline-flex items-center px-4 py-2 bg-green-600 border border-transparent rounded-lg font-semibold text-sm text-white hover:bg-green-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>
            </form>
        </div>
    </div>

    <!-- Data Table Card -->
    <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 bg-gray-50">
            <h3 class="text-lg font-semibold text-gray-900">Revised Bills</h3>
        </div>

        <div class="px-6 py-4">
            <div class="overflow-x-auto">
                <table id="tblReviseBillSummary" class="min-w-full divide-y divide-gray-200">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Bill Ref No</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Bill Date</th>
                            <th class="px-4 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider">Bill Amount</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Revised Date</th>
                            <th class="px-4 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider">Revised Amount</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Status</th>
                        </tr>
                    </thead>
                    <tbody class="bg-white divide-y divide-gray-200"></tbody>
                    <tfoot class="bg-gray-100">
                        <tr>
                            <th colspan="2" class="px-4 py-3 text-left text-sm font-bold text-gray-900">TOTAL</th>
                            <th id="totalBillAmount" class="px-4 py-3 text-right text-sm font-bold text-gray-900">0.00</th>
                            <th></th>
                            <th id="totalRevisedAmount" class="px-4 py-3 text-right text-sm font-bold text-gray-900">0.00</th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(document).ready(function() {
    // Format number as currency
    function formatMoney(amount) {
        return parseFloat(amount || 0).toLocaleString('en-NG', {
            minimumFractionDigits: 2,
            maximumFractionDigits: 2
        });
    }

    // Initialize DataTable
    var table = $('#tblReviseBillSummary').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: '{{ route("revise-bill.load-summary-data") }}',
            type: 'POST',
            data: function(d) {
                d._token = '{{ csrf_token() }}';
                d.TaxYear = $('#cboTaxYear').val();
                d.FromDate = $('#txtFromDate').val();
                d.ToDate = $('#txtToDate').val();
                d.BillTypeID = $('#cboBillTypeID').val();
                d.RevenueStreamID = $('#cboRevenueStreamID').val();
            },
            dataSrc: function(json) {
                // Calculate totals
                var totalBill = 0;
                var totalRevised = 0;
                json.data.forEach(function(row) {
                    totalBill += parseFloat(row.BillAmount || 0);
                    totalRevised += parseFloat(row.RevisedAmount || 0);
                });
                $('#totalBillAmount').text('₦' + formatMoney(totalBill));
                $('#totalRevisedAmount').text('₦' + formatMoney(totalRevised));
                return json.data;
            },
            error: function(xhr, error, thrown) {
                if (xhr.status === 401) {
                    window.location.href = '/login';
                }
            }
        },
        columns: [
            { data: 'BillRef', name: 'BillRef' },
            { data: 'BillDate', name: 'BillDate' },
            {
                data: 'BillAmount',
                name: 'BillAmount',
                className: 'text-right',
                render: function(data, type, row) {
                    return '₦' + formatMoney(data);
                }
            },
            { data: 'RevisedDate', name: 'RevisedDate' },
            {
                data: 'RevisedAmount',
                name: 'RevisedAmount',
                className: 'text-right',
                render: function(data, type, row) {
                    return '<span class="text-orange-600 font-semibold">₦' + formatMoney(data) + '</span>';
                }
            },
            {
                data: 'BillStatusName',
                name: 'BillStatusName',
                render: function(data, type, row) {
                    return '<span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-gray-100 text-gray-800">' + (data || '') + '</span>';
                }
            }
        ],
        order: [[1, 'desc']],
        pageLength: 25,
        lengthMenu: [[10, 25, 50, 100], [10, 25, 50, 100]],
        language: {
            processing: '<div class="flex items-center justify-center"><svg class="animate-spin h-5 w-5 text-teal-600" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24"><circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle><path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4zm2 5.291A7.962 7.962 0 014 12H0c0 3.042 1.135 5.824 3 7.938l3-2.647z"></path></svg><span class="ml-2">Loading...</span></div>',
            emptyTable: 'No revised bills found',
            info: 'Showing _START_ to _END_ of _TOTAL_ entries',
            infoEmpty: 'Showing 0 to 0 of 0 entries',
            infoFiltered: '(filtered from _MAX_ total entries)'
        },
        dom: '<"flex flex-col sm:flex-row sm:items-center sm:justify-between mb-4"<"mb-2 sm:mb-0"l><"mb-2 sm:mb-0"f>>rtip'
    });

    // Date validation
    $('#txtToDate').on('change', function() {
        var fromDate = $('#txtFromDate').val();
        var toDate = $(this).val();
        if (fromDate && toDate && fromDate > toDate) {
            alert('To Date must be greater than or equal to From Date');
            $(this).val('');
        }
    });

    $('#txtFromDate').on('change', function() {
        var fromDate = $(this).val();
        var toDate = $('#txtToDate').val();
        if (fromDate && toDate && fromDate > toDate) {
            alert('From Date must be less than or equal to To Date');
            $(this).val('');
        }
    });

    // Search form submission
    $('#frmSearch').on('submit', function(e) {
        e.preventDefault();
        if (!$('#cboTaxYear').val()) {
            alert('Please select a year');
            return;
        }
        table.ajax.reload();
    });

    // Export to Excel
    $('#btnExport').on('click', function() {
        if (!$('#cboTaxYear').val()) {
            alert('Please select a year');
            return;
        }
        var params = new URLSearchParams({
            TaxYear: $('#cboTaxYear').val(),
            FromDate: $('#txtFromDate').val(),
            ToDate: $('#txtToDate').val(),
            BillTypeID: $('#cboBillTypeID').val(),
            RevenueStreamID: $('#cboRevenueStreamID').val()
        });
        window.location.href = '{{ route("revise-bill.export-summary-excel") }}?' + params.toString();
    });

    // Auto-load on page ready
    table.ajax.reload();
});
</script>
@endpush