@extends('layouts.sidebar')

@section('title', 'Billings')
@section('content')
    @if (in_array('Manage Billing', $privileges))
        <div class="w-full p-4 bg-white border border-gray-200 rounded shadow-md lg:w-full">
            <p class="my-10 text-3xl font-bold">Final Billings</p>
            <table id="billing-table" class="min-w-full bg-white border border-gray-200 rounded shadow-md">
                <thead>
                    <tr class="text-sm leading-normal text-white uppercase bg-black">
                        <th class="px-6 py-3">Batch Code</th>
                        <th class="px-6 py-3">Pay Period Start</th>
                        <th class="px-6 py-3">Pay Period End</th>
                        <th class="px-6 py-3">Code Name</th> <!-- New Column for Code ID -->
                        <th class="px-6 py-3">Actions</th>
                    </tr>
                </thead>
                <tbody class="text-sm font-light text-center text-gray-600">
                    <!-- Data will be populated here by DataTables -->
                </tbody>
            </table>
        </div>
    @else
        <div class="my-2 flex h-full w-full justify-center items-center">
            <div>
                <i class="text-3xl bx bx-lock mr-2"></i> <!-- Large lock icon indicating no access -->
                <span class="text-gray-500">You don't have privilege to access this page</span>
            </div>

        </div>
    @endif

    <script>
        $(document).ready(function() {
            var employedTable = $('#billing-table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: "{{ route('final.index') }}",
                    data: function(d) {

                    }
                },
                columns: [{
                        data: 'id', // Adjust according to your Batch Code data
                        name: 'id'
                    },
                    {
                        data: 'pay_period_start', // Matches the field from your server response
                        name: 'pay_period_start'
                    },
                    {
                        data: 'pay_period_end', // Matches the field from your server response
                        name: 'pay_period_end'
                    },

                    {
                        data: 'client_id', // New column for Client ID
                        name: 'client_id'
                    },
                    {
                        data: 'action', // Matches the action column from your server response
                        name: 'action',
                        orderable: false,
                        searchable: false
                    }
                ],
                order: [
                    [0, 'desc'] // Orders by the first column (Batch Code) descending
                ]
            });
        });
    </script>
@endsection