@extends('admin.layout')
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="{{asset('assets/css/table_filter.css')}}">

@section('content')

<div class="card p-2">
    <h5 class="fw-bold mb-2 text-center">Meal Consumption Report</h5>

    <div class="row mb-3 align-items-center">
        <div class="col-auto mb-3">
            <select id="pageLength" class="form-select">
                <option value="10">10</option>
                <option value="25">25</option>
                <option value="50">50</option>
                <option value="100">100</option>
                <option value="All">All</option>
            </select>
        </div>
        <div class="col-lg-4 col-12 mb-3">
            <div class="search-cluster w-100">
                <div class="search-field">
                    {{-- <i class="ti tabler-hash"></i> --}}
                    <input class="form-control" type="text" id="dpSearch" placeholder="DP No" class="w-100">
                </div>
            </div>
        </div>
        <div class="col-lg-4 col-12 mb-3">
            <div class="search-cluster w-100">
                <div class="search-field">
                    {{-- <i class="ti tabler-user"></i> --}}
                    <input class="form-control" type="text" id="nameSearch" placeholder="Employee Name" class="w-100">
                </div>
            </div>
        </div>
        <div class="col-lg-1 col-12 mb-3">
            <button class="btn btn-secondary w-100" id="resetBtn" type="reset">
                <span>Reset</span>
            </button>
        </div>
        <div class="col-lg-1 col-12 mb-3">
<a href="{{ route('admin.reports.export') }}" class="btn btn-label-secondary w-100">Export</a>        </div>
    </div>

    <div class="table-responsive pt-0 pb-2">
        <table class="table" id="reportsTable">
            <thead>
                <tr>
                    <th>S.No</th>
                    <th>Date</th>
                    <th>DP No</th>
                    <th>Name</th>
                    <th>Meal Type</th>
                    <th>Token No</th>
                    <th>Served At</th>
                </tr>
            </thead>
        </table>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script>
    $(document).ready(function() {

        const table = $('#reportsTable').DataTable({
            destroy: true,
            ajax: {
                url: "{{ route('admin.reports.data') }}",
                dataSrc: 'data'
            },
            searching: true,
            lengthChange: false,
            pageLength: 10,
            autoWidth: false,

            columns: [
                {
                    data: null,
                    render: function (data, type, row, meta) {
                        return meta.row + 1;
                    }
                },
                { data: 'report_date' },
                {
                    data: 'dp_no',
                    render: function (data) {
                        return `<span class="fw-semibold text-primary">${data}</span>`;
                    }
                },
                { data: 'name' },
                {
                    data: 'meal_type',
                    render: function (data) {
                        return `<span class="badge bg-label-info">${data}</span>`;
                    }
                },
                { data: 'token_no' },
                { data: 'served_at' },
            ]
        });

        $('#pageLength').on('change', function () {
            const val = this.value === 'All' ? -1 : parseInt(this.value, 10);
            table.page.len(val).draw();
        });

        $('#dpSearch').on('keyup', function () {
            table.column(2).search(this.value).draw();
        });

        $('#nameSearch').on('keyup', function () {
            table.column(3).search(this.value).draw();
        });

        $('#resetBtn').on('click', function () {
            $('#dpSearch, #nameSearch').val('');
            table.search('').columns().search('').draw();
        });

    });
</script>
@endsection