@extends('layouts.auth.app')

@section('title', 'TCC Monthly Commission')

@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">TCC Monthly Commission</h1>
            <p class="mt-1 text-sm text-gray-500">View monthly summary of Tax Clearance Certificate commission</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 gap-6">
                    <!-- 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>

                    <!-- Status -->
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">TCC Status</label>
                        <select name="StatusID" id="cboStatusID" 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 Statuses</option>
                            @foreach($statusList ?? [] as $status)
                            <option value="{{ $status->StatusID }}">{{ $status->StatusName }}</option>
                            @endforeach
                        </select>
                    </div>

                    <!-- Actions -->
                    <div class="flex items-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>
                </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">Monthly Commission Summary</h3>
        </div>

        <div class="px-6 py-4">
            <div class="overflow-x-auto">
                <table id="tblTCCMonthlyCommission" 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">Month #</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Month</th>
                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Request Count</th>
                            <th class="px-4 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider">Commission Amount</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="totalRequestCount" class="px-4 py-3 text-left text-sm font-bold text-gray-900">0</th>
                            <th id="totalCommission" class="px-4 py-3 text-right text-sm font-bold text-gray-900">0.00</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 = $('#tblTCCMonthlyCommission').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: '{{ route("tcc-monthly-commission.load-data") }}',
            type: 'POST',
            data: function(d) {
                d._token = '{{ csrf_token() }}';
                d.TaxYear = $('#cboTaxYear').val();
                d.StatusID = $('#cboStatusID').val();
            },
            dataSrc: function(json) {
                // Calculate totals
                var totalCount = 0;
                var totalCommission = 0;
                json.data.forEach(function(row) {
                    totalCount += parseInt(row.RequestCount || 0);
                    totalCommission += parseFloat(row.CommissionAmount || 0);
                });
                $('#totalRequestCount').text(totalCount);
                $('#totalCommission').text(formatMoney(totalCommission));
                return json.data;
            },
            error: function(xhr, error, thrown) {
                if (xhr.status === 401) {
                    window.location.href = '/login';
                }
            }
        },
        columns: [
            { data: 'MonthID', name: 'MonthID' },
            { data: 'StartMonthName', name: 'StartMonthName' },
            {
                data: 'RequestCount',
                name: 'RequestCount',
                render: function(data, type, row) {
                    return '<span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-blue-100 text-blue-800">' + (data || 0) + '</span>';
                }
            },
            {
                data: 'CommissionAmount',
                name: 'CommissionAmount',
                className: 'text-right',
                render: function(data, type, row) {
                    return '<span class="text-green-600 font-semibold">₦' + formatMoney(data) + '</span>';
                }
            }
        ],
        order: [[0, 'asc']],
        pageLength: 12,
        lengthMenu: [[12, 24, 50], [12, 24, 50]],
        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 commission data available',
            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'
    });

    // 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 taxYear = $('#cboTaxYear').val();
        var statusId = $('#cboStatusID').val();
        window.location.href = '{{ route("tcc-monthly-commission.export-excel") }}?TaxYear=' + taxYear + '&StatusID=' + statusId;
    });

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