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

FICHE Imprimée le {{ $date_imprime }}

@foreach ($filieres as $fil) @php $j = 0; $nb = App\Models\TabInscription::where(['annee' => $etudeYear, 'niveauFormation' => $formation, 'idFiliere' => $fil->idFiliere, 'annee_acad' => $acadYear]) ->where('dateValidation', '!=', '0001-01-01 00:00:00') ->count(); $filiere = App\Models\Filieres::where('idFiliere', $fil->idFiliere)->first(); $students = DB::connection('tenant') ->table('tabinscription') ->join('tabetudiant', 'tabinscription.matricule', '=', 'tabetudiant.matricule') ->where(['tabinscription.annee_acad' => $acadYear, 'tabinscription.idFiliere' => $fil->idFiliere, 'tabinscription.niveauFormation' => $formation]) ->where('dateValidation', '!=', '0001-01-01 00:00:00') ->get(); $filles = 0; $garcons = 0; foreach ($students as $student) { $creditue = 0; $inscriunites = App\Models\TabInscriUnite::select('code_unite') ->where(['idFiliere' => $fil->idFiliere, 'annee' => $etudeYear, 'niveauFormation' => $formation, 'premiere_inscription' => $acadYear, 'resultat' => 'A', 'matricule' => $student->matricule]) ->get(); foreach ($inscriunites as $inscriunite) { $unites = App\Models\UnitesE::select('credit', 'semestre') ->where(['idFiliere' => $fil->idFiliere, 'annee' => $etudeYear, 'niveauFormation' => $formation, 'annee_acad' => $acadYear, 'code_unite' => $inscriunite->code_unite]) ->get(); foreach ($unites as $unite) { if ($semestre == $unite->semestre) { $creditue += $unite->credit; } } } if ($creditue >= $credit) { $j++; if ($student->sexe == 'F') { $filles++; } else { $garcons++; } } } $percent = App\Http\Helpers\AdditionalHelpers::myround(($j / $nb) * 100, 2); @endphp @endforeach

INTITULE FILIERE	SIGLE FILIERE-ANNEE	EFFECTIF FILIERE	EFFECTIF VALIDATION	POURCENTAGE DE VALIDATION (%)
{{ $filiere->intituleFilieres }}	{{ $filiere->sigleFilieres }}	{{ $nb }}	{{ $j . ' [F : ' . $filles . ' G : ' . $garcons . ']' }}	{{ $percent }}

{{ $universite->descruni }}

{{ $etablissement->descreta }}

{{ $titre }}