@extends("admin.layout.layout")
@section("styles")
    @php
        $titulo = "Reportes";
        $modulo = "Reportes";
        $vista="Estudiantes por materias";
    @endphp
    <title>{{getenv("APP_NAME")}} | {{$titulo}}</title>
@endsection

@section("contenido")
    <div class="d-flex flex-column-fluid">
        <div class="container-fluid">
            <div class="card card-custom">
                <div class="card-header flex-wrap border-0 pt-6 pb-0">
                    <div class="card-title">
                        <h3 class="card-label">{{$vista}}
                            <span class="d-block text-muted pt-2 font-size-sm"></span>
                        </h3>
                    </div>
                </div>
                <div class="card-body table-responsive">
                    <div class="row mb-5">
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="curso_lectivo_id" class="required">Curso lectivo</label>
                                <select name="curso_lectivo_id" id="curso_lectivo_id" class="form-select form-select-sm">
                                    @foreach($cursos_lectivos as $curso_lectivo)
                                        <option value="{{$curso_lectivo->id}}">{{$curso_lectivo->curso_lectivo}}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="nivel_id" class="required">Nivel</label>
                                <select name="nivel_id" id="nivel_id" class="form-select form-select-sm">
                                    <option value="">-</option>
                                    @foreach($niveles as $nivel)
                                        <option value="{{$nivel->id}}">{{$nivel->nivel}}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-1" title="Plan Nacional">
                            <div class="form-group">
                                <label for="plan_nacional" class="required">PN</label>
                                <select name="plan_nacional" id="plan_nacional" class="form-select form-select-sm">
                                    <option value="0">NO</option>
                                    <option value="1">SI</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="seccion_id" class="required">Sección</label>
                                <select name="seccion_id" id="seccion_id" class="form-select form-select-sm">
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="materia_id" class="required">Materia</label>
                                <select name="materia_id" id="materia_id" class="form-select form-select-sm">
                                </select>
                            </div>
                        </div>
                        <div class="col-md-1">
                            <button class="btn btn-info btn-sm mt-6" id="btnBuscar"> <i class="fas fa-search"></i></button>
                        </div>
                    </div>
                    <table class="table table-hover table-condensed table-sm table-bordered" id="tabla">
                        <tbody></tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection
@section("scripts")
    <script src="assets/plugins/custom/datatables/datatables.bundle.js"></script>

    @vite(['resources/js/reportes/matriculas/materias.js'])
    <script> window.dataTable = "{{ route('admin::reportes.getDataEstudiantePorMateria') }}";</script>
    <script>
        $(document).ready(function () {
            $('#curso_lectivo_id, #nivel_id, #plan_nacional').on('change', function () {
                let curso_lectivo_id=$("#curso_lectivo_id").val();
                let nivel_id=$("#nivel_id").val();
                let planNacional=$("#plan_nacional").val();
                $('#seccion_id').empty();
                $('#materia_id').empty();

                if(nivel_id!==""){
                    let url="{{ route('admin::secciones.nivel',["nivel"=>':nivel',"planNacional"=>":planNacional"]) }}".replace(":nivel",nivel_id).replace(":planNacional",planNacional);
                    $.ajax({
                        url: url,
                        type: 'GET',
                        data: {curso_lectivo_id: curso_lectivo_id},
                        success: function (response) {
                            $('#seccion_id').append('<option value="">-</option>');
                            $.each(response, function (index, seccion) {
                                $('#seccion_id').append('<option value="' + seccion.id + '">' + seccion.seccion + '</option>');
                            });
                        },
                        error: function (error) {
                            console.log(error);
                        }
                    });
                }
            })

            $('#seccion_id').on('change', function () {
                let seccion_id=$(this).val();
                $('#materia_id').empty();

                if(seccion_id!==""){
                    let url="{{ route('admin::seccion.getMaterias',["seccion"=>":seccion"]) }}".replace(":seccion",seccion_id);
                    $.ajax({
                        url: url,
                        type: 'GET',
                        success: function (response) {
                            $.each(response, function (index, materia) {
                                $('#materia_id').append('<option value="' + materia.id+ '">' + materia.materia + '</option>');
                            });
                        },
                        error: function (error) {
                            console.log(error);
                        }
                    });
                }
            })
        });
    </script>
@endsection