@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">Deposits Report</h3>
                                </div>
                                @php
                                    $currentYear = date('Y');
                                    $years = array();
                                    for($i = $currentYear - 7; $i <= $currentYear + 2; $i++){
                                    $years[] = $i;
                                    }

                                @endphp
                                <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"> 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($allStudents as $student)
                                                    <option value="{{$student->id}}">{{$student->first_name .' '. $student->last_name}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        {{--                                        <div class="col-3 mt-10 mb-10">--}}
                                        {{--                                            <label class="form-label fs-6 fw-semibold"> Years </label>--}}
                                        {{--                                            <select name="year" id="year" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">--}}
                                        {{--                                                @foreach($years as $year)--}}
                                        {{--                                                    <option value="{{$year}}" {{($currentYear == $year) ? 'selected' : ''}} >{{$year}}</option>--}}
                                        {{--                                                @endforeach--}}
                                        {{--                                            </select>--}}
                                        {{--                                        </div>--}}
                                        {{--                                        <div class="col-3 mt-10 mb-10">--}}
                                        {{--                                            <label class="form-label fs-6 fw-semibold"> Is Refund </label>--}}
                                        {{--                                            <select name="is_refund" id="is_refund" class="form-select form-select-sm form-select-solid" data-control="select2" data-placeholder="Select an option">--}}
                                        {{--                                                    <option value="All">All</option>--}}
                                        {{--                                                    <option value="NO">No</option>--}}
                                        {{--                                                    <option value="YES" >Yes</option>--}}
                                        {{--                                            </select>--}}
                                        {{--                                        </div>--}}

                                        <div class="col-3 mt-18">
                                            <a type="button" class="btn btn-info btn-sm" id="SubmitFilter"> Filter </a>
                                            <a href="{{ url('preschool/reports/deposit') }}" class="btn btn-warning btn-sm"> Clear </a>
                                            <a href="{{ url('preschool/reports/deposit/export') }}" 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">Enrollment Year</th>--}}
                                                {{--                                                <th class="min-w-150px">Program</th>--}}
                                                <th class="min-w-150px">Deposit Paid</th>
                                                {{--                                                <th class="min-w-150px">Deposit Owing</th>--}}
                                                {{--                                                <th class="min-w-150px">Refund</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('preschool/reports/deposit') }}',
                    'data': {
                        year: $('#year').val(),
                        student_id: $('#student_id').val(),
                        is_refund: $('#is_refund').val(),
                    }
                },
                "order": [[ 0, "asc" ]],
                columns: [
                    {data: 'student_id', name: 'student_id'},
                    {data: 'student_name', name: 'student_name'},
                    // {data: 'enrollment_year', name: 'enrollment_year'},
                    // {data: 'program', name: 'program'},
                    {data: 'deposit_paid', name: 'deposit_paid'},
                    // {data: 'deposit_owing', name: 'deposit_owing'},
                    // {data: 'refund', name: 'refund'},
                ]
            });
        }

    </script>
@endsection