@extends('layouts.template')
@section('nom', 'Statistiques: Année Universitaire:' . (session('year') - 1) . '-' . session('year')) 
@section('name', 'Validation Inscriptions')
@section('bottom-header')
    @include('partials.bottom-header')
@endsection
@section('css')
     <style>
        #container {
            /* height: 350px;
              width:  1800px;
             */

        }

        /*
        .highcharts-figure,
        .highcharts-data-table table {
            min-width: 310px;
            max-width: 800px;
            margin: 1emauto;
        } */
    </style>
@endsection
@section('contenu')

    <div class="" style=" background:#fff;">

        <div class="card-group py-3 mb-0 ">

            <div class=" col-lg-3 col-sm-12 " style="border-right:1px solid rgba(120,130,140,.13);">
                <div class="p-lg-4 p-2">
                    <div class="d-flex align-items-center">
                        <div class="col-2 p-2">
                            <h3 class="mb-2 display-6"><i class="icon-people text-pulpe"></i></h3>
                        </div>
                        <div class="col-5  ">
                            <h2 class=" display-8 mb-1 ">Effectif Total</h2>
                            <div class="progress">
                                <div class="progress-bar bg-cyan" role="progressbar" style="width: 40%" aria-valuenow="40"
                                    aria-valuemin="0" aria-valuemax="40"></div>
                            </div>
                        </div>
                        <div class=" col text-end ">
                            <h2 class="display-6 mb-0">{{ session('effectTotal') }}</h2>
                        </div>
                    </div>
                </div>
            </div>
            <div class=" col-lg-4 col-sm-12 " style="border-right:1px solid rgba(120,130,140,.13);">
                <div class="p-lg-4 p-2">
                    <div class="d-flex align-items-center">
                        <div class="col-2 p-2">
                            <h3 class="mb-2 display-6"><i class="icon-people text-pulpe"></i></h3>
                        </div>

                        <div class="col-5">
                            <h2 class="display-8 mb-1 ">Inscription Validée</h2>
                            <div class="progress">
                                <div class="progress-bar bg-succes" role="progressbar" style="width: 40%" aria-valuenow="40"
                                    aria-valuemin="0" aria-valuemax="40"></div>
                            </div>
                        </div>
                        <div class="col text-end">
                            <h2 class="display-6 mb-0"> {{ $statiValider }} </h2>
                        </div>
                    </div>
                </div>
            </div>
            <div class=" col-lg-4 col-sm-12 " style="border-right:1px solid rgba(120,130,140,.13);">
                <div class="p-lg-4 p-2">
                    <div class="d-flex align-items-center">
                        <div class="col-2 p-2">
                            <h3 class="mb-2 display-6"><i class="icon-people text-pulpe"></i></h3>
                        </div>

                        <div class="col-5">
                            <h2 class="display-8 mb-1">Inscription nonValidée</h2>
                            <div class="progress">
                                <div class="progress-bar bg-danger" role="progressbar" style="width: 40%" aria-valuenow="40"
                                    aria-valuemin="0" aria-valuemax="40"></div>
                            </div>
                        </div>
                        <div class="col text-end">
                            <h2 class="display-6 mb-0"> {{ session('effectTotal') - $statiValider }} </h2>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
    <div class="mt-5 ms-4">
        <h3>Statistiques Générales</h3>
        <div style="display: flex; flex-direction:column">

            <h4>Pourcentage de validation</h4>

            <div class="progress mt-2 fs-4" style="height: 40px;">
                <div class="progress-bar bg-success"
                    style="width: {{ ($statiValider * 100) / session('effectTotal') . '%' }};" role="progressbar">
                    {{ ($statiValider * 100) / session('effectTotal') }}%</div>
            </div>
        </div>

        <div style="display: flex; flex-direction:column">
            <div class="mt-3">
                <h4>Pourcentage de non validation</h4>
            </div>

            <div class="progress mt-2 fs-4" style="height: 40px; ">
                <div class="progress-bar bg-danger"
                    style="width: {{ ((session('effectTotal') - $statiValider) * 100) / session('effectTotal') . '%' }};"
                    role="progressbar"> {{ ((session('effectTotal') - $statiValider) * 100) / session('effectTotal') }}%
                </div>
            </div>
        </div>


    </div>

    <div class="col-12 mt-5">


        <div class="row">
            <div class="col-sm-12 fs-5">
                <div class="">
                    <div class="card-body">

                        <h2>Option d'exportation</h2>

                        <div class="card-body">

                            <div class="table-responsive fs-5">
                                <table id="table-list"
                                    class="table table-striped table-bordered display"style="width: 100%">
                                    <thead style="border-bottom:3px">
                                        <tr style="">
                                            <th>Filière</th>
                                            <th>Validée</th>
                                            <th>Non validée</th>
                                            <th>Effectif filière</th>

                                        </tr>
                                    </thead>

                                    <tbody>
                                        @php
                                        use App\Models\TabEtudiant;
                                        use App\Models\Filieres;
                                        use Illuminate\Support\Facades\DB;
                                        @endphp
                                        @if (!empty($filiereValider))
                                        @foreach ($filiereValider as $filiere)
                                        @php
                                            $statFiliereNValider = DB::connection('tenant')
                                            ->table('tabetudiant')
                                            ->selectRaw('matricule')
                                            ->join('tabinscription', 'tabetudiant.matricule', '=', 'tabinscription.matricule')
                                            ->where('tabinscription.dateValidation', '=', '0001-01-01 00:00:00')
                                            ->where('tabinscription.annee_acad', session('year'))
                                            ->where('tabinscription.idFiliere', $filiere->idFiliere)
                                            ->where('tabinscription.annee', $filiere->annee)
                                            ->where('tabinscription.niveauFormation', $niveau)
                                            ->count();

                                            $statFiliereValider = DB::connection('tenant')
                                            ->table('tabetudiant')
                                            ->selectRaw('matricule')
                                            ->join('tabinscription', 'tabetudiant.matricule', '=', 'tabinscription.matricule')
                                            ->where('tabinscription.dateValidation', '!=', '0001-01-01 00:00:00')
                                            ->where('tabinscription.annee_acad', session('year'))
                                            ->where('tabinscription.idFiliere', $filiere->idFiliere)
                                            ->where('tabinscription.annee', $filiere->annee)
                                            ->where('tabinscription.niveauFormation', $niveau)
                                            ->count();

                                            $sigleFilieres= DB::connection('tenant')
                                            ->table('filieres')
                                            
                                            ->where('idFiliere',$filiere->idFiliere)
                                            ->first()->sigleFilieres;

                                            
                                        @endphp      

                                         <tr role="row" class="odd">
                                            <td class="sorting_1">
                                                  </td>
                                            <td>{{ $statFiliereValider }}</td>
                                            <td>{{ $statFiliereNValider }}</td>
                                            <td>{{ $statFiliereValider + $statFiliereNValider }}</td>
                                        </tr>   
                                        @endforeach
                                        @else

                                        <tr role="row" class="odd text-center">
                                            <td colspan="4">
                                                {{ 'Aucune donnée disponible dans cet tableau' }}
                                            </td>

                                        </tr>
                                        @endif

                                    </tbody>
                                </table>
                            </div>
                          
                            {{-- Ce tableau est caché et est utiliser pour la representation --}}
            
                            <div class="card-body" style="display:none">
                                <div class="table-responsive fs-5">
                                    <table id="graphe"

                                        class="table table-striped table-bordered display"style="width: 100%">
                                        <thead style="border-bottom:3px">
                                            <tr style="">
                                                <th>Filière</th>
                                                <th>Validée</th>
                                                <th>Non validée</th>
                              
    
                                            </tr>
                                        </thead>
    
                                        <tbody>
                                                    
                                            @if (!empty($filiereValider))
                                            @foreach ($filiereValider as $filiere)
                                            @php
                                                $statFiliereNValider = DB::connection('tenant')
                                                ->table('tabetudiant')
                                                ->selectRaw('matricule')
                                                ->join('tabinscription', 'tabetudiant.matricule', '=', 'tabinscription.matricule')
                                                ->where('tabinscription.dateValidation', '=', '0001-01-01 00:00:00')
                                                ->where('tabinscription.annee_acad', session('year'))
                                                ->where('tabinscription.idFiliere', $filiere->idFiliere)
                                                ->where('tabinscription.annee', $filiere->annee)
                                                ->where('tabinscription.niveauFormation', $niveau)
                                                ->count();
    
                                                $statFiliereValider = DB::connection('tenant')
                                                ->table('tabetudiant')
                                                ->selectRaw('matricule')
                                                ->join('tabinscription', 'tabetudiant.matricule', '=', 'tabinscription.matricule')
                                                ->where('tabinscription.dateValidation', '!=', '0001-01-01 00:00:00')
                                                ->where('tabinscription.annee_acad', session('year'))
                                                ->where('tabinscription.idFiliere', $filiere->idFiliere)
                                                ->where('tabinscription.annee', $filiere->annee)
                                                ->where('tabinscription.niveauFormation', $niveau)
                                                ->count();
    
                                                $sigleFilieres= DB::connection('tenant')
                                                ->table('filieres')
                                                
                                                ->where('idFiliere',$filiere->idFiliere)
                                                ->first()->sigleFilieres;
    
                                                
                                            @endphp      
    
                                             <tr role="row" class="odd">
                                                <td class="sorting_1">
                                                      </td>
                                                <td>{{ $statFiliereValider }}</td>
                                                <td>{{ $statFiliereNValider }}</td>
                                                
                                            </tr>   
                                            @endforeach
                                            @else
    
                                            <tr role="row" class="odd ">
                                                
                                                <td></td>
                                                <td></td>
                                                <td></td>
    
                                            </tr>
                                            @endif
    
                                        </tbody>
                                    </table>
                                </div>
                                {{-- <div class="table-responsive fs-5">
                                    <table id="graphe"
                                        class="table table-striped table-bordered display"style="width: 100%">
                                        <thead style="border-bottom:3px">
                                            <tr style="">
                                                <th>Filière</th>
                                                <th>Validée</th>
                                                <th>Non validée</th>


                                            </tr>
                                        </thead>

                                        <tbody>
                                            @if (empty($filiereValider))
                                                <tr role="row" class="odd ">
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>

                                                </tr>
                                            @else
                                                <tr role="row" class="odd">
                                                    <td>{{ $filiereValider->sigleFilieres }}{{ $filiereValider->annee }}
                                                    </td>
                                                    <td> {{ $statFiliereValider }} </td>
                                                    <td>{{ $statFiliereNValider }}</td>
                                                </tr>
                                            @endif




                                        </tbody>
                                    </table>
                                </div> --}}


                            </div>

                            <div class="col-lg-12">
                                <div class="card mt-5 ">
                                    <script src="js/highcharts.js"></script>
                                    <script src="js/data.js"></script>
                                    <script src="js/exporting.js"></script>
                                    <script src="js/accessibility.js"></script>

                                    <figure class="highcharts-figure">
                                        <div id="container" class="fs-lg-4"></div>
                                    </figure>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>
            </div>



        </div>

    @endsection

    @section('script')


        <script>
            Highcharts.chart('container', {
                colors: [
                    '#5cd65c',
                    '#ff0000'
                ],
                data: {
                    table: 'graphe'
                },
                chart: {
                    type: 'column'
                },
                title: {
                    text: 'GRAPHIQUE'
                },
                subtitle: {
                    text: 'Statistique de validation par filière'
                },
                xAxis: {
                    type: 'category'
                },
                yAxis: {
                    allowDecimals: false,
                    title: {
                        text: 'Statistique de validation'
                    }
                },
                tooltip: {
                    formatter: function() {
                        return '<b>' + this.series.name + '</b><br/>' +
                            this.point.y + ' ' + this.point.name.toLowerCase();
                    }
                }
            });
        </script>
      
    @endsection