@extends ('Staff.layout')
<link rel="stylesheet" href="https://cdn.datatables.net/2.3.4/css/dataTables.bootstrap5.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/3.0.2/css/buttons.bootstrap5.min.css">

<style>
.dt-search {
    display: none !important;
}
</style>
@section('content')
<div class="row d-flex justify-content-between">
    <div class="col-auto">
        <h5>

            Holidays
        </h5>
    </div>
 
</div>
<div class="card p-0 mt-3">
    <div class="row mb-3 g-1 align-items-center p-3">

        <!-- Page Length -->
        <div class="col-md-2 mt-auto mb-2">
            <select id="yearFilter" class="form-select">
                <option value="all">All Years</option>

                @foreach($years as $year)
                <option value="{{ $year }}" {{ $year == now()->year ? 'selected' : '' }}>
                    {{ $year }}
                </option>
                @endforeach

            </select>
        </div>

        <div class="col d-flex justify-content-end align-items-center gap-3 mt-auto">

            <div class="position-relative mb-2">
                <input type="text" id="searchBox" class="form-control" placeholder="Search...">
            </div>

            <button class="btn btn-label-secondary mb-2" id="exportExcel">
                <i class="ti tabler-download"></i>&nbsp;Export
            </button>

        </div>


    </div>
    <div class="card-datatable table-responsive pt-0">
        <div class="row card-header flex-column flex-md-row border-bottom mx-0 p-0">
            <div class="justify-content-between dt-layout-table">
                <div class=" justify-content-between align-items-center dt-layout-full table-responsive">
                    <table id="dept" class="table">
                        <thead>
                            <th class="text-nowrap">S.No</th>
                            <th class="text-nowrap">Date of Leave</th>
                            <th class="text-nowrap">Reason</th>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.min.js"></script>
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.bootstrap5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.2/js/dataTables.buttons.min.js"></script>

<script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.bootstrap5.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>

<script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.html5.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
$(document).ready(function() {

    let table = $('#dept').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: "{{ route('user_leave_entries_data') }}",
            data: function(d) {
                d.year = $('#yearFilter').val(); 
            }
        },

        pageLength: 10,
        lengthChange: false,
        searching: true,
        ordering: true,
        info: true,

        columnDefs: [{
            targets: '_all',
            className: 'text-nowrap text-center align-middle'
        }],

        columns: [{
                data: 'DT_RowIndex',
                orderable: false,
                searchable: false
            },
            {
                data: 'date',
                name: 'date'
            },
            {
                data: 'reason',
                name: 'reason'
            }
        ]
    });

    $('#searchBox').on('keyup', function() {
        table.search($(this).val()).draw();
    });

    $('#yearFilter').on('change', function() {
        table.ajax.reload(); // reload table when year changes
    });

    $('#exportExcel').on('click', function() {
        let exportData = table.buttons.exportData({
            columns: [0, 1, 2] // 👈 excludes Action column
        });

        let wb = XLSX.utils.book_new();
        let ws = XLSX.utils.aoa_to_sheet([
            ['S.No', 'Date of Leave', 'Reason'],
            ...exportData.body
        ]);

        XLSX.utils.book_append_sheet(wb, ws, "Leave Entries");
        XLSX.writeFile(wb, "leave_entries.xlsx");
    });

});
$(document).on('click', '.delete-btn', function() {
    let id = $(this).data('id');
    $('#delete_leave_id').val(id);
    $('#delete_contact_modal').modal('show');
});
$('#delete_leave_form').on('submit', function() {

    let btn = $('#delete_contact_btn');

    btn.prop('disabled', true);
    btn.text('Deleting...');

});
</script>

@endsection