@extends('layouts.app')

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => 'Alumni Payment Report'])

    <div class="row mt-4 mx-4">
        <div class="col-12">
            <div class="card mb-4">
                <div class="d-flex align-items-center">
                    <p class="mb-0 ms-2 mt-2">Alumni Payment Report</p>
                </div>
                <div class="card-body px-0 pt-0 pb-2">
                    <div class="d-flex justify-content-center">
                        <div class="col-md-8">
                            <form action="{{ route('alumni_payment.gen_report') }}" method="GET">
                                <div class="row mt-3">
                                    <div class="col-3">
                                        <div class="form-group">
                                            <label for="academicyear_Id" class="form-control-label">Academic Year</label>
                                            <select class="form-control select2" name="academicyear_Id" id="academicyear_Id">
                                                <option value="">Select Academic Year</option>
                                                @foreach ($academicYears as $academicYear)
                                                    <option value="{{ $academicYear->academicyear_Id }}"
                                                        {{ old('academicyear_Id', $student->academicyear_Id ?? '') == $academicYear->academicyear_Id ? 'selected' : '' }}>
                                                        {{ $academicYear->academicdetail }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-3">
                                        <div class="form-group">
                                            <label for="cms_department_sid" class="form-control-label">Department</label>
                                            <select class="form-control select2" name="cms_department_sid" id="cms_department_sid">
                                                <option value="">Select Department</option>
                                                @foreach ($departments as $department)
                                                    <option value="{{ $department->cms_department_sid }}">
                                                        {{ $department->department_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-3">
                                        <div class="form-group">
                                            <label for="cms_course_sid" class="form-control-label">Course</label>
                                            <select class="form-control select2" name="cms_course_sid" id="cms_course_sid">
                                                <option value="">Select Course</option>
                                                @foreach ($courses as $course)
                                                    <option value="{{ $course->cms_course_sid }}"
                                                        {{ old('cms_course_sid', $student->cms_course_sid ?? '') == $course->cms_course_sid ? 'selected' : '' }}>
                                                        {{ $course->course_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                            @if ($errors->has('cms_course_sid'))
                                                <sup class="text-danger">{{ $errors->first('cms_course_sid') }}</sup>
                                            @endif
                                        </div>
                                    </div>

                                    <div class="col-3">
                                        <div class="form-group">
                                            <label for="alumni_name" class="form-control-label">Alumni Name</label>
                                            <select class="form-select select2" id="alumni_name" name="alumni_name">
                                                <option value="">Select Alumni Name</option>
                                                @foreach($alumni as $alum)
                                                    <option value="{{ $alum->alumni_sid }}">
                                                        {{ $alum->user_name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>

                                <div class="row mt-3">
                                    <div class="col-6">
                                        <label for="from_date" class="form-label">From Date</label>
                                        <input type="date" id="from_date" name="from_date" class="form-control">
                                    </div>
                                    <div class="col-6">
                                        <label for="to_date" class="form-label">To Date</label>
                                        <input type="date" id="to_date" name="to_date" class="form-control">
                                    </div>
                                </div>

                                <div class="mt-3 text-center">
                                    <button type="submit" class="btn btn-primary">Generate Report</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('scripts')
<script type="text/javascript">
    $(document).ready(function() {
        // Initialize Select2 for dropdowns
        $('.select2').select2();

        // Handle department change event
        $('#cms_department_sid').on('change', function() {
            var department_id = $(this).val(); // Get selected department ID

            if (department_id) {
                $.ajax({
                    url: '/courses/' + department_id, // Laravel route for fetching courses
                    type: 'GET',
                    dataType: 'json',
                    success: function(response) {
                        console.log(response); // Debugging

                        // Clear and repopulate course dropdown
                        $('#cms_course_sid').empty().append('<option value="">Select Course</option>');

                        $.each(response.courses, function(index, course) {
                            $('#cms_course_sid').append('<option value="' + course.cms_course_sid + '">' + course.course_name + '</option>');
                        });

                        // Refresh Select2 for course dropdown
                        $('#cms_course_sid').trigger('change');
                    },
                    error: function(xhr, status, error) {
                        console.error("Error fetching courses: " + error);
                    }
                });
            } else {
                // If no department selected, clear course dropdown
                $('#cms_course_sid').empty().append('<option value="">Select Course</option>');
            }
        });
    });
</script>
@endpush