****************

FICHE Imprimée le {{ $date_imprime }}

@foreach ($filieres as $filiereID) @php $max = 0; $min = 0; $filiere = App\Models\Filieres::where('idFiliere', $filiereID->idFiliere)->first(); $stat = App\Models\TabInscription::selectRaw('COUNT(matricule) AS nb, MIN(moyennePonderee) AS mini, MAX(moyennePonderee) AS maxi') ->where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00']]) ->first(); $count = $stat->nb; $min = $stat->mini; $max = $stat->maxi; $interv1 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[5]], ['moyennePonderee', '<=', $interValue[6]]])->count(); $interv2 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[4]], ['moyennePonderee', '<', $interValue[5]]])->count(); $interv3 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[3]], ['moyennePonderee', '<', $interValue[4]]])->count(); $interv4 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[2]], ['moyennePonderee', '<', $interValue[3]]])->count(); $interv5 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[1]], ['moyennePonderee', '<', $interValue[2]]])->count(); $interv6 = App\Models\TabInscription::where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00'], ['moyennePonderee', '>=', $interValue[0]], ['moyennePonderee', '<', $interValue[1]]])->count(); $majors = App\Models\TabInscription::selectRaw('moyennePonderee, matricule') ->where([['annee', $etudeYear], ['niveauFormation', $formation], ['annee_acad', $acadYear], ['idFiliere', $filiereID->idFiliere], ['dateValidation', '!=', '0001-01-01 00:00:00']]) ->orderBy('moyennePonderee', 'desc') ->limit(2) ->get(); $nb = 0; @endphp @endforeach

FILIERE

EFFECTIF

PLUS FORTE MOYENNE

PLUS FAIBLE MOYENNE

MAJORS DE LA CLASSE

@foreach ($majors as $major) @php $nb++; $majorDetails = App\Models\TabEtudiant::selectRaw('CONCAT(nom,\' \',prenom) AS nomPrenom, sexe') ->where('matricule', $major->matricule) ->first(); if ($majorDetails->sexe == 'F') { $f = $nb == 1 ? 'ère' : 'ème'; } else { $f = $nb == 1 ? 'er' : 'ème'; } @endphp @endforeach

{{ $universite->descruni }}

{{ $etablissement->descreta }}

{{ $titre }}