@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">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_no" id="cycle_no" 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($nonReimbursementParents 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($nonReimbursementStudents 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('after-school/reports/unpaid') }}" class="btn btn-warning btn-sm"> Clear </a>
                                            <a href="#" onclick="excel_exprot(this)" type="button" class="btn btn-success btn-sm xls"> XLS </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">First Cycle No</th>
                                                <th class="min-w-150px">Last Cycle No</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($nonReimbursementStudents) !!};

        // 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('after-school/reports/unpaid') }}',
                    'data': {
                        cycle_no: $('#cycle_no').val(),
                        parent_id: $('#parent_id').val(),
                        student_id: $('#student_id').val()
                    }, beforeSend: function() {
                        $.blockUI({
                            css: {
                                border: 'none',
                                padding: '20px',
                                backgroundColor: '#000',
                                '-webkit-border-radius': '10px',
                                '-moz-border-radius': '10px',
                                opacity: 0.6,
                                color: '#fff',
                            }
                        });
                    },
                    complete: function() {
                        $.unblockUI();
                    }
                },
                "order": [[ 6, "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: 'first_cycle', name: 'first_cycle', orderable: false,},
                    {data: 'last_cycle', name: 'last_cycle', orderable: false,},
                    {data: 'credit_card', name: 'credit_card', orderable: false,},
                    {data: 'amount_owing', name: 'amount_owing'},
                ]
            });
        }

        function excel_exprot(ele) {
            var cycle_no = $('#cycle_no').val();
            var parent_id = $('#parent_id').val();
            var student_id = $('#student_id').val();
            var v_token = "{{csrf_token()}}";

            $.ajax({
                type: 'POST',
                url: '{{ url("after-school/reports/unpaid-export") }}',
                data: {
                    _token:v_token,
                    cycle_no: cycle_no,
                    parent_id: parent_id,
                    student_id: student_id
                },
                dataType: 'json',

                success: function (data) {
                    if (data.success) {
                        toastr.success( "Unpaid will be send to you mail in few minutes");
                    }
                }
            });

            return true;
        }

    </script>
@endsection