@extends('layouts.admin')
@section('title')
    <title>{{ config('app.name', 'SMS') }} | Résultats</title>
@endsection
@section('header')
@endsection
@section('content')
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1><i class="nav-icon fas fa-edit text-primary"></i> Consulter les Résultats</h1>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="/">Accueil</a></li>
                            <li class="breadcrumb-item active">Maquette/Notes/Résultats</li>
                        </ol>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-3">
                        <form action="{{ route('rechercher.resultat') }}" method="POST" >
                            @csrf
                            <input type="hidden" name="user_id" value="{{ Auth::user()->id }}">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="card card-primary card-outline shadow-lg">
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-sm-12">
                                                    <!-- text input -->
                                                    <div class="form-group">
                                                        <label>Année Académique</label>
                                                        <select name = "annee_id" id="selectAnnee" style="width: 100%;" class="form-control select2" required  onchange="populateFiliere(this.id, 'selectFiliere')">
                                                            <option selected disabled>-- Choisissez d'abord l'année --</option>
                                                            @foreach ($annees as $key => $annee)
                                                                <option value="{{ $annee->id }}">
                                                                    {{ $annee->nom_params }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <!-- text input -->
                                                    <div class="form-group">
                                                        <label>Filière</label>
                                                        <select name = "filiere_id" id="selectFiliere"  style="width: 100%;" required class="form-control select2"  onchange="populateOption(this.id, 'selectOption')" >
                                                            <option  disabled>-- Choisissez d'abord l'année --</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <!-- text input -->
                                                    <div class="form-group">
                                                        <label>Option</label>
                                                        <select name = "option_id" id="selectOption" style="width: 100%;" required class="form-control select2"  onchange="populateClasse(this.id, 'selectClasse')" >
                                                            <option  disabled>-- Choisissez d'abord la filière --</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <!-- text input -->
                                                    <div class="form-group">
                                                        <label>Classe</label>
                                                        <select name = "classe_id" id="selectClasse" style="width: 100%;" required class="form-control select2" >
                                                            <option  disabled>-- Choisissez d'abord l'option --</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <button type="submit" class="btn btn-success btn-block">
                                                        <span class="fas fa-list"></span> &nbsp; &nbsp; &nbsp; Consulter les Résultats
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>

                    </div>
                    <div class="col-md-9">
                        <div class="card card-primary card-outline shadow-lg">
                            <div class="card-header">
                                @if ($eleveSelection==true)
                                    <div class="row">
                                        <div class="col-md-6">
                                            <blockquote>
                                                Année: {{$classe->option->filiere->annee->nom_params}} <br>
                                                Departement: {{$classe->option->filiere->departement->libelle}}<br>
                                                Filière: {{$classe->option->filiere->libelle}}
                                            </blockquote>
                                        </div>
                                        <div class="col-md-6">
                                            <blockquote>
                                                Option: {{$classe->option->libelle}}<br>
                                                Classe: {{$classe->libelle}}<br>
                                            </blockquote>
                                        </div>
                                        <div class="col-md-12">
                                            <center>
                                                <div class="btn-group">
                                                    <a href="/Releves/Proces/{{$classe->id}}/Annuel" class="btn btn-primary" target="_blank">
                                                        <i class="fas fa-print"></i>  Imprimer le procès verbal Annuel
                                                    </a>
                                                    @foreach ($semestres as $semestre)
                                                        <a href="/Releves/Proces/{{$classe->id}}/Semestre/{{$semestre->id}}" class="btn btn-primary" target="_blank">
                                                            <i class="fas fa-print"></i>  Imprimer le procès verbal du {{$semestre->nom_params}}
                                                        </a>
                                                    @endforeach
                                                </div>
                                            </center>
                                        </div>
                                    </div>
                                @endif
                            </div>
                            <!-- /.card-header -->
                            <div class="card-body">
                                @if ($eleveSelection==true)
                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="card card-primary card-outline shadow-lg">
                                                <div class="card-header p-2">
                                                    <ul class="nav nav-pills">
                                                        <li class="nav-item"><a class="nav-link active" href="#annuel" data-toggle="tab">Bilan Annuel</a></li>
                                                        @foreach ($semestres as $semestre)
                                                            <li class="nav-item">
                                                                <a class="nav-link" href="#semestre{{$semestre->id}}" data-toggle="tab">
                                                                   Procès verbal du {{$semestre->nom_params}}
                                                                </a>
                                                            </li>
                                                        @endforeach
                                                    </ul>
                                                </div><!-- /.card-header -->
                                                <div class="card-body  p-0">
                                                    <div class="tab-content">
                                                        <div class="tab-pane show active" id="annuel">
                                                            <div class="p-2">
                                                                <center>
                                                                    <h1>Résultats Annuel</h1>
                                                                </center>
                                                                <hr>

                                                                <div class="table-responsive p-0">
                                                                    <table id="example1" class="table table-hover table-bordered table-sm table-striped">
                                                                        <thead style="text-align: center; align-items:center;">
                                                                            <tr>
                                                                                <th rowspan="2"><center>N° Matricule</center></th>
                                                                                <th rowspan="2"><center>Nom(s) & Prénom(s)</center></th>
                                                                                @foreach ($semestres as $semestre)
                                                                                    <th  colspan="4">
                                                                                        {{$semestre->nom_params}}
                                                                                    </th>
                                                                                @endforeach
                                                                                <th colspan="4">Annuel</th>
                                                                            </tr>
                                                                            <tr>
                                                                                @foreach ($semestres as $semestre)
                                                                                    <th>Moy.</th>
                                                                                    <th>Rang</th>
                                                                                    <th>Abs</th>
                                                                                    <th>Decision</th>
                                                                                @endforeach

                                                                                <th>Moy.</th>
                                                                                <th>Rang</th>
                                                                                <th>Abs</th>
                                                                                <th>Decision</th>
                                                                            </tr>

                                                                        </thead>
                                                                        <tbody style="text-align: center; align-items:center;">
                                                                            @foreach ($etudiants as $kt => $etudiant)
                                                                                <tr>
                                                                                    <th>{{$kt+1}}</th>
                                                                                    <td style="text-align: left; align-items:center;">{{$etudiant->nom}} {{$etudiant->prenom}}</td>

                                                                                    @foreach ($semestres as $semestre)
                                                                                        <th class="bg-{{$semestre->appreciation($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['couleur']}}">
                                                                                            {{$semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id)}}
                                                                                        </th>
                                                                                        <td>{{$semestre->rang_etudiant_semestre($etudiant->id, $semestre->id, $classe->id)}}</td>
                                                                                        <td>{{$semestre->absences_etudiant_semestre($etudiant->id)}} h</td>
                                                                                        <td class="bg-{{$semestre->decision($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['couleur']}}">
                                                                                            {{$semestre->decision($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['mention']}}
                                                                                        </td>
                                                                                    @endforeach
                                                                                    <td></td>
                                                                                    <td></td>
                                                                                    <td></td>
                                                                                    <td></td>
                                                                                </tr>
                                                                            @endforeach
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        @foreach ($semestres as $semestre)
                                                            <div class="tab-pane show" id="semestre{{$semestre->id}}">
                                                                <div class="p-2">
                                                                    <center>
                                                                        <h1>Résultats du {{$semestre->nom_params}}</h1>
                                                                    </center>
                                                                    <hr>
                                                                    <div class="table-responsive p-0">
                                                                        <table id="example1" class="table table-hover table-bordered table-sm table-striped">
                                                                            <thead style="text-align: center; align-items:center;">
                                                                                <tr>
                                                                                    <th rowspan="4"><center>N° Matricule</center></th>
                                                                                    <th rowspan="4"><center>Nom(s) & Prénom(s)</center></th>
                                                                                    @foreach ($disciplines as $discipline)
                                                                                        @if(count($discipline->modules()->where('semestre_id',$semestre->id)->where('classe_id',$classe->id)->get())!=0)
                                                                                            <th colspan="{{count($discipline->cours()->where('modules.semestre_id',$semestre->id)->where('modules.classe_id',$classe->id)->get())+1}}">
                                                                                                <center>{{$discipline->nom_params}}</center>
                                                                                            </th>
                                                                                        @endif
                                                                                    @endforeach
                                                                                    <th rowspan="4">Moyenne</th>
                                                                                    <th rowspan="4">Rang</th>
                                                                                    <th rowspan="4">Abs</th>
                                                                                    <th rowspan="4">Descision</th>
                                                                                    <th rowspan="4"><i class="fas fa-print"></i></th>
                                                                                </tr>
                                                                                <tr>
                                                                                    @foreach ($disciplines as $discipline)
                                                                                        @if(count($discipline->modules()->where('semestre_id',$semestre->id)->where('classe_id',$classe->id)->get())!=0)
                                                                                            @foreach ($discipline->cours()->where('modules.semestre_id',$semestre->id)->where('modules.classe_id',$classe->id)->orderBy('modules.code')->get() as $cour)
                                                                                                <th>{{$cour->coef}}</th>
                                                                                            @endforeach
                                                                                            <th>{{$discipline->cours()->where('modules.semestre_id',$semestre->id)->where('modules.classe_id',$classe->id)->sum('cours.coef')}}</th>
                                                                                        @endif
                                                                                    @endforeach
                                                                                </tr>
                                                                                <tr>
                                                                                    @foreach ($disciplines as $discipline)
                                                                                        @if(count($discipline->modules()->where('semestre_id',$semestre->id)->where('classe_id',$classe->id)->get())!=0)
                                                                                            @foreach ($discipline->cours()->where('modules.semestre_id',$semestre->id)->where('modules.classe_id',$classe->id)->orderBy('modules.code')->get() as $cour)
                                                                                                <th>{{$cour->module->code}}</th>
                                                                                            @endforeach
                                                                                            <th>Moy. {{$discipline->cd_params}}</th>
                                                                                        @endif
                                                                                    @endforeach
                                                                                </tr>
                                                                            </thead>
                                                                            <tbody style="text-align: center; align-items:center;">
                                                                                @foreach ($etudiants as $kt => $etudiant)
                                                                                <tr>
                                                                                    <th>{{$kt+1}}</th>
                                                                                    <td style="text-align: left; align-items:center;">{{$etudiant->nom}} {{$etudiant->prenom}}</td>

                                                                                    @foreach ($disciplines as $discipline)
                                                                                        @if(count($discipline->modules()->where('semestre_id',$semestre->id)->where('classe_id',$classe->id)->get())!=0)
                                                                                            @foreach ($discipline->cours()->where('modules.semestre_id',$semestre->id)->where('modules.classe_id',$classe->id)->orderBy('modules.code')->get() as $cour)
                                                                                                <th>
                                                                                                    {{$cour->moyenne_etudiant($etudiant->id)}}
                                                                                                    <small>/ <small>{{$cour->rang_etudiant($etudiant->id,$classe->id)}}</small> </small>
                                                                                                </th>
                                                                                            @endforeach
                                                                                            <th class="bg-{{$discipline->appreciation($discipline->moyenne_etudiant_discipline($etudiant->id, $semestre->id, $classe->id))['couleur']}}">
                                                                                                {{$discipline->moyenne_etudiant_discipline($etudiant->id, $semestre->id, $classe->id)}}
                                                                                                <small><small>{{$discipline->rang_etudiant_discipline($etudiant->id, $semestre->id, $classe->id)}}</small></small>
                                                                                            </th>
                                                                                        @endif
                                                                                    @endforeach
                                                                                    <th class="bg-{{$semestre->appreciation($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['couleur']}}">
                                                                                        {{$semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id)}}
                                                                                    </th>
                                                                                    <td>{{$semestre->rang_etudiant_semestre($etudiant->id, $semestre->id, $classe->id)}}</td>
                                                                                    <td>{{$semestre->absences_etudiant_semestre($etudiant->id)}} h</td>
                                                                                    <td class="bg-{{$semestre->decision($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['couleur']}}">
                                                                                        {{$semestre->decision($semestre->moyenne_etudiant_semestre($etudiant->id, $semestre->id, $classe->id))['mention']}}
                                                                                    </td>
                                                                                    <td>
                                                                                        <a href="/Bulletin/Eleve/{{$etudiant->id}}/Semestre/{{$semestre->id}}" class="btn btn-primary btn-xs" target="_blank">
                                                                                            <i class="fas fa-print"></i> Imprimer
                                                                                        </a>
                                                                                    </td>
                                                                                </tr>
                                                                                @endforeach
                                                                            </tbody>
                                                                        </table>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        @endforeach
                                                    </div>
                                                </div>
                                        </div>
                                    </div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>
    <!-- /.content-wrapper -->

@endsection

@section('footer')
  <script type="text/javascript">
    function populateFiliere(s1,s2){
        var s1 = document.getElementById(s1);
        var s2 = document.getElementById(s2);
        s2.innerHTML = "";
        @php foreach($annees as $annee): @endphp
            if(s1.value == "{{ $annee->id}}"){
                var optionArray = ["0| Choisir la filière"@forelse ($annee->filieres as $filiere),"{{$filiere->id}}|{{$filiere->libelle}}"@empty @endforelse];
            }
        @php endforeach; @endphp

        for(var option in optionArray){
            var pair = optionArray[option].split("|");
            var newOption = document.createElement("option");
            newOption.value = pair[0];
            newOption.innerHTML = pair[1];
            s2.options.add(newOption);
        }
    }
    function populateOption(s1,s2){
        var s1 = document.getElementById(s1);
        var s2 = document.getElementById(s2);
        s2.innerHTML = "";
        @php foreach($filieres as $filiere): @endphp
            if(s1.value == "{{ $filiere->id}}"){
                var optionArray = ["0| Choisir l'option "@forelse ($filiere->options as $option),"{{$option->id}}|{{$option->libelle}}"@empty @endforelse];
            }
        @php endforeach; @endphp

        for(var option in optionArray){
            var pair = optionArray[option].split("|");
            var newOption = document.createElement("option");
            newOption.value = pair[0];
            newOption.innerHTML = pair[1];
            s2.options.add(newOption);
        }
    }
    function populateClasse(s1,s2){
        var s1 = document.getElementById(s1);
        var s2 = document.getElementById(s2);
        s2.innerHTML = "";
        @php foreach($options as $option): @endphp
            if(s1.value == "{{ $option->id}}"){
                var optionArray = ["0| Choisir la classe "@forelse ($option->classes as $classe),"{{$classe->id}}|{{$classe->libelle}}"@empty @endforelse];
            }
        @php endforeach; @endphp

        for(var option in optionArray){
            var pair = optionArray[option].split("|");
            var newOption = document.createElement("option");
            newOption.value = pair[0];
            newOption.innerHTML = pair[1];
            s2.options.add(newOption);
        }
    }

    function populateModule(s1,s2){
        var s1 = document.getElementById(s1);
        var s2 = document.getElementById(s2);
        s2.innerHTML = "";
        @php foreach($classes as $classe): @endphp
            if(s1.value == "{{ $classe->id}}"){
                var optionArray = ["0| Choisir le module "@forelse ($classe->modules as $module),"{{$module->id}}|{{$module->libelle}}"@empty @endforelse];
            }
        @php endforeach; @endphp

        for(var option in optionArray){
            var pair = optionArray[option].split("|");
            var newOption = document.createElement("option");
            newOption.value = pair[0];
            newOption.innerHTML = pair[1];
            s2.options.add(newOption);
        }
    }
    function populateCours(s1,s2){
        var s1 = document.getElementById(s1);
        var s2 = document.getElementById(s2);
        s2.innerHTML = "";
        @php foreach($modules as $module): @endphp
            if(s1.value == "{{ $module->id}}"){
                var optionArray = ["0| Choisir le cours "@forelse ($module->cours as $cour),"{{$cour->id}}|{{$cour->module->libelle}}.{{$cour->semestre->cd_params}}"@empty @endforelse];
            }
        @php endforeach; @endphp

        for(var option in optionArray){
            var pair = optionArray[option].split("|");
            var newOption = document.createElement("option");
            newOption.value = pair[0];
            newOption.innerHTML = pair[1];
            s2.options.add(newOption);
        }
    }


</script>


  <script>
    $('#OpenImgUploard').click(function(){
        $('#imgupload').trigger('click');
    });
</script>
@endsection