@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">Preschool Deposits History 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"> 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"> 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('preschool/reports/deposit-history') }}"
                                               class="btn btn-warning btn-sm"> Clear </a>

                                            <a 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">Deposit Date</th>
                                                <th class="min-w-150px">Deposit Paid</th>
                                                <th class="min-w-150px">Refund Date</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 src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
    <script type="text/javascript">
        let year = "{{  date('Y') }}";
        flatpickr('#start_date', {
            enableTime: false,
            dateFormat: "Y-m-d",
            allowInput: true,
            defaultDate: year + "-01-01"
        });

        flatpickr('#end_date', {
            enableTime: false,
            dateFormat: "Y-m-d",
            allowInput: true,
            defaultDate: year + "-12-31"
        });

        datatable();
        $(document).on('click', '#SubmitFilter', function (e) {
            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('preschool/reports/deposit-history') }}',
                    'data': {
                        student_id: $('#student_id').val(),
                        start_date: $('#start_date').val(),
                        end_date: $('#end_date').val()
                    }
                },
                "order": [[0, "asc"]],
                columns: [
                    {data: 'student_id', name: 'student_id'},
                    {data: 'student_name', name: 'student_name'},
                    {data: 'enrollment_year', name: 'enrollment_year'},
                    {data: 'deposit_paid_date', name: 'deposit_paid_date'},
                    {data: 'deposit_paid', name: 'deposit_paid'},
                    {data: 'refund_date', name: 'refund_date'},
                    {data: 'refund', name: 'refund'}
                ]
            });
        }

        $(document).ready(function() {
            $('.xls').click(function() {
                var startDate = $('#start_date').val();
                var endDate = $('#end_date').val();
                var url = '/preschool/reports/deposit-history/export?start_date=' + encodeURIComponent(startDate) + '&end_date=' + encodeURIComponent(endDate);
                window.open(url, '_blank');
            });
        });

    </script>
@endsection