@extends('layouts.app')
@section('content')

    @include('layouts.toolbar')

    <div id="kt_content_container" class="d-flex flex-column-fluid align-items-start container-xxl">
        <div class="content flex-row-fluid" id="kt_content">
            <div class="card card-page">
                <div class="card-body">
                    <div class="row gy-12 g-xl-12">
                        <div class="col-xxl-12">
                            <div class="card card-xxl-stretch">
                                <div class="card-header border-0 pt-5">
                                    <h3 class="card-title fw-bold text-gray-800 fs-2"> Lunch Report </h3>
                                </div>
                                <div class="card-body py-0">
                                    <div class="row">
                                        <div class="col-3 mt-10">
                                            <label class="form-label fs-6 fw-semibold"> Select Week </label>
                                            <select name="week_no_elective" id="week_no_elective" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">
                                                <option value="0"> Select Week</option>
                                                @for($x=1;$x<=10;$x++)
                                                    <option value="{{$x}}">Week {{$x}}</option>
                                                @endfor
                                            </select>
                                        </div>

                                        <div class="col-3 mt-18">
                                            <a type="button" class="btn btn-info btn-sm" id="SubmitFilter"> Filter </a>
                                            <a href="{{ url('reports/lunch') }}" class="btn btn-warning btn-sm"> Clear </a>
                                            <a href="{{ url('reports/lunch/export') }}" type="button" class="btn btn-success btn-sm xls"> XLS </a>
                                        </div>
                                    </div>

                                    <br><br><br><hr>

                                    <div class="table-responsive">

                                        <table class="table align-middle table-row-dashed fs-6 gy-5" id="kt_table_report">
                                            <thead>
                                                <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                                    <th class="min-w-100px">Student ID</th>
                                                    <th class="min-w-125px">Student Name</th>
                                                    <th class="min-w-150px">Mother Info</th>
                                                    <th class="min-w-150px">Father Info</th>
                                                    <th class="min-w-125px">Current Grade</th>
                                                    <th class="min-w-125px">Lunch</th>
                                                    <th class="min-w-140px">Lunch Days</th>
                                                    <th class="min-w-125px">Language</th>
                                                </tr>
                                            </thead>
                                            <tbody class="fw-semibold text-gray-600"></tbody>
                                        </table>

                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script type="text/javascript">

        datatable();
        $(document).on('click', '#SubmitFilter', function (e) {
            $('#kt_table_report').DataTable().destroy();
            datatable();
        });

        function datatable() {
            var table = $('#kt_table_report').DataTable({
                processing: true,
                serverSide: true,
                ajax : {
                    'type': 'GET',
                    'url': '{{ url('reports/lunch') }}',
                    'data': {
                        week_no_elective: $('#week_no_elective').val()
                    }
                },
                order: [[0, 'asc']],
                columns: [
                    {data: 'student_id', name: 'student_id'},
                    {data: 'student_name', name: 'student_name'},
                    {data: 'mother', name: 'mother'},
                    {data: 'father', name: 'father'},
                    {data: 'current_grade', name: 'current_grade'},
                    {data: 'lunch', name: 'lunch'},
                    {data: 'lunch_days', name: 'lunch_days'},
                    {data: 'language', name: 'language'}
                ]
            });
        }

    </script>
@endsection