@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">Reimbursement Unpaid</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"> Cycle </label>
                                            <select name="cycle_id" id="cycle_id" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">
                                                @foreach($cycles as $cycle)
                                                    <option value="{{$cycle->cycle_no}}">Cycle {{$cycle->cycle_no}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-3 mt-10 mb-10">
                                            <label class="form-label fs-6 fw-semibold"> Parents </label>
                                            <select name="parent_id" id="parent_id" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">
                                                <option value="all">All Parents</option>
                                                @foreach($reimbursementParents as $parent)
                                                    <option value="{{$parent->id}}">{{'Mother: ' .$parent->mother_full_name}} -- {{'Father: ' .$parent->father_full_name}}</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="col-3 mt-10 mb-10">
                                            <label class="form-label fs-6 fw-semibold"> Students </label>
                                            <select name="student_id" id="student_id" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">
                                                <option value="all">All Students</option>
                                                @foreach($reimbursementStudents as $student)
                                                    <option value="{{$student->id}}">{{$student->id . ' - ' .$student->first_name .' '. $student->last_name}}</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="col-3 mt-18">
                                            <a type="button" class="btn btn-info btn-sm" id="SubmitFilter"> Filter </a>
                                            <a href="{{ url('winter-camp/reports/reimbursement-unpaid') }}" 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">Parent Info</th>
                                                <th class="min-w-150px">Credit Card Added</th>
                                                <th class="min-w-80px">Amount Owing</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">
        var arrayOfStudents = {!! json_encode($reimbursementStudents) !!};

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

        $('#parent_id').change(function () {
            var parentID = $(this).val();
            if (parentID && parentID != 'all') {
                $("#student_id").empty();
                $("#student_id").append('<option value="all">All Students</option>');
                const filteredStudents = arrayOfStudents.filter(obj => obj.parent_id == parentID);
                filteredStudents.forEach(obj => {
                    $("#student_id").append('<option value="' + obj.id + '">' + obj.first_name + ' ' + obj.last_name + '</option>');

                });
            } else {
                $("#student_id").empty();
                $("#student_id").append('<option value="all">All Students</option>');
                arrayOfStudents.forEach(obj => {
                    $("#student_id").append('<option value="' + obj.id + '">' + obj.first_name + ' ' + obj.last_name + '</option>');

                });
            }
        });

        function datatable() {
            var table = $('#kt_table_report').DataTable({
                processing: true,
                serverSide: true,
                searching: false,
                ajax : {
                    'type': 'GET',
                    'url': '{{ url('winter-camp/reports/reimbursement-unpaid') }}',
                    'data': {
                        cycle_id: $('#cycle_id').val(),
                        parent_id: $('#parent_id').val(),
                        student_id: $('#student_id').val()
                    }
                },
                "order": [[ 4, "desc" ]],
                columns: [
                    {data: 'student_id', name: 'student_id', orderable: false,},
                    {data: 'student_name', name: 'student_name', orderable: false,},
                    {data: 'parent', name: 'parent', orderable: false,},
                    {data: 'credit_card', name: 'credit_card', orderable: false,},
                    {data: 'amount_owing', name: 'amount_owing'},
                ]
            });
        }
    </script>
@endsection