@if($agency_type == 'local')
    <table class="table table-striped yearly-local-datatable table-bordered table-hover table-sm mt-1">
@else
    <table class="table table-striped yearly-foreign-datatable table-bordered table-hover table-sm mt-1">
@endif
    <col width="40%">
    <col width="30%">
    <col width="30%">
    <thead>
    <tr class="bg-light bg-success text-nowrap">
        <th>Fiscal Year</th>
        <th class="text-right">Receivable Amount (TK)</th>
        <th class="text-right">Paid Amount (TK)</th>
    </tr>
    </thead>
    <tbody id="exam-data">
        @if (isset($data) && $data)
            @foreach($data as $dt)
                <tr class="text-nowrap">
                    <td>{{$dt->fiscal_year}}</td>
                    <td class="text-right">
                        @if($dt->receivable_amount > 0)
                            <a href="javascript:void(0)"
                               data-agency_type_id="{{$agency_type_id}}"
                               data-year="{{$dt->fiscal_year}}"
                               class="yearly-rcv-data">{{number_format($dt->receivable_amount, 2)}}</a>
                        @else
                            {{$dt->receivable_amount}}
                        @endif
                    </td>
                    <td class="text-right">
                        @if($dt->paid_amount > 0)
                            <a href="javascript:void(0)"
                               data-agency_type_id="{{$agency_type_id}}"
                               data-year="{{$dt->fiscal_year}}"
                               class="yearly-paid-data">{{number_format($dt->paid_amount, 2)}}</a>
                        @else
                            {{$dt->paid_amount}}
                        @endif
                    </td>
                </tr>
            @endforeach
        @endif
    </tbody>
</table>

<script>
    @if($agency_type=='local')
    if ($.fn.DataTable.isDataTable('.yearly-local-datatable')) {
        // Destroy the existing DataTable instance
        $('.yearly-local-datatable').DataTable().destroy();
    }
    $('.yearly-local-datatable').DataTable({
        "paging": true,
        "pageLength": 10,
        "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ],
        "searching": true,
        "ordering": false,
    });
    @else
    if ($.fn.DataTable.isDataTable('.yearly-foreign-datatable')) {
        // Destroy the existing DataTable instance
        $('.yearly-foreign-datatable').DataTable().destroy();
    }
    $('.yearly-foreign-datatable').DataTable({
        "paging": true,
        "pageLength": 10,
        "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ],
        "searching": true,
        "ordering": false,
    });
    @endif
</script>