@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">Afternoon Elective Report</h3>
                                </div>
                                <div class="card-body py-0">
                                    <div class="row">
                                        <div class="col-3 mt-10 mb-10">
                                            <label class="form-label fs-6 fw-semibold"> Class </label>
                                            <select name="class_id" id="class_id" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">
                                                <option value="">--- select class ---</option>
                                                @foreach($classes as $class)
                                                    <option value="{{$class->id}}">{{$class->class_title}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-3 mt-10 mb-10">
                                            <label class="form-label fs-6 fw-semibold"> Start Date </label>
                                            <input type="text"
                                                   class="form-control form-control-sm form-control-solid date"
                                                   name="start_date" id="start_date" value="{{ old('dates') }}" readonly>
                                        </div>
                                        <div class="col-3 mt-10 mb-10">
                                            <label class="form-label fs-6 fw-semibold"> End Date </label>
                                            <input type="text"
                                                   class="form-control form-control-sm form-control-solid date"
                                                   name="end_date" id="end_date" value="{{ old('dates') }}" readonly>
                                        </div>

                                        <div class="col-3 mt-18">
                                            <a type="button" class="btn btn-info btn-sm" id="SubmitFilter"> Filter </a>
                                            <a href="{{ url('after-school/reports/elective-class') }}" class="btn btn-warning btn-sm"> Clear </a>
                                        </div>
                                    </div>
                                    <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-30px">Student ID</th>
                                                <th class="min-w-125px">Student Name</th>
                                                <th class="min-w-150px">Grade</th>
                                                <th class="min-w-150px">Start Date - End Date</th>
                                                <th class="min-w-150px">Attending Count</th>
                                                <th class="min-w-150px">Class Cancellation Count</th>
                                            </tr>
                                            </thead>
                                            <tbody class="fw-semibold text-gray-600"></tbody>
                                            <tfoot id="elective-footer">
                                            <tr class="fw-bold text-muted">
                                                <th colspan="4" style="text-align:right">Total:</th>
                                                <th id="total_attending">0</th>
                                                <th id="total_cancellation">0</th>
                                            </tr>
                                            </tfoot>
                                        </table>

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

@section('js')
    <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
    <script type="text/javascript">

        flatpickr('.date', {
            enableTime: false,
            dateFormat: "Y-m-d",
            allowInput: true,
        });

        datatable();
        $(document).on('click', '#SubmitFilter', function (e) {
            if ($('#class_id').val() == ''){
                toastr.error('Please Select Class.');
                return ;
            }
            if ($('#start_date').val() == ''){
                toastr.error('Please Add Start Date.');
                return ;
            }
            if ($('#end_date').val() == ''){
                toastr.error('Please Add End Date.');
                return ;
            }
            $('#kt_table_report').DataTable().destroy();
            datatable();
        });

        function datatable() {

            var table = $('#kt_table_report').DataTable({
                processing: true,
                serverSide: true,
                ajax : {
                    'type': 'GET',
                    'url': '{{ url('after-school/reports/elective-class') }}',
                    'data': {
                        class_id: $('#class_id').val(),
                        start_date: $('#start_date').val(),
                        end_date: $('#end_date').val()
                    },
                    dataSrc: function (json) {
                        return json.data;
                    }
                },
                "order": [[ 0, "desc" ]],
                columns: [
                    {data: 'student_id', name: 'student_id'},
                    {data: 'student_name', name: 'student_name'},
                    {data: 'grade'},
                    {data: 'dates'},
                    {data: 'dates_count'},
                    {data: 'class_cancellation_count'},
                ],
                drawCallback: function (settings) {
                    const json = settings.json || {};
                    $('#total_attending').text(json.total_attending || 0);
                    $('#total_cancellation').text(json.total_cancellation || 0);
                }
            });
        }

    </script>
@endsection