| Noms et Prénoms |
: |
{{ $etudiant->nom }} {{ $etudiant->prenom }} |
Sexe |
: |
{{ $etudiant->sexe }} |
| Date et lieu de naissance |
: |
{{ $etudiant->date_nais }} à {{ $etudiant->lieu_nais }} |
N° d'inscription |
: |
{{ $etudiant->matricule }} |
| Domaine |
: |
{{ $mentionDomaine->sigleDomaine }} |
Diplôme préparé |
: |
@php
$dip = ($diplome == 'Master' || $diplome == 'Doctorat') ? $diplome : session('formationbase');
@endphp
{{ $dip }}
|
| Mention |
: |
{{ $mentionDomaine->sigleMention }} |
| Spécialité |
: |
{{ $filiere->intituleFilieres }} |
|
: |
|
@if ($idSemestre[2] == 0)
{{ $idSemestre[1] }}
@else
{{ $idSemestre[1] }} & {{ $idSemestre[2] }}
@endif
|
|
| Code |
Unités
d'Enseignement (UE) |
Année Académique |
Crédits affectés |
Crédits obtenus |
Fré* |
Note |
Grade ECTS |
Décision du Jury |
@if ($idSemestre[2] != 0)
| SEMESTRE {{ $idSemestre[1] }} |
@endif
@php
$l = 0;
$sommeMoyenne = 0;
$sommeCredit1 = 0;
$sommeCredit2 = 0;
$couleur = '';
@endphp
@foreach ($ues1 as $ue)
@php
$sommeCredit1 += $ue->credit;
$moyenne = 0;
$compte = 0;
$ra = 0;
$notes = DB::connection('tenant')
->table('noteEcu')
->where([['matricule', $etudiant->matricule], ['idFiliere', $etudiant->idFiliere], ['code_unite', $ue->code_unite], ['annee', $etudiant->annee], ['niveauFormation', $etudiant->niveauFormation], ['annee_acad', $ue->annee_acad]])
->get();
foreach ($notes as $note) {
if ($note->modifRa == 'YES') {
$ra = 1;
}
if ($ue->moy_pondere == 'NO') {
$moyenne += $note->noteEcu;
$compte++;
} else {
$moyenne +=
$note->noteEcu *
DB::connection('tenant')
->table('ecu')
->where([['insertion', 'NO'], ['code_unite', $note->code_unite], ['code_ecu', $note->code_ecu], ['annee', $note->annee], ['niveauFormation', $note->niveauFormation], ['annee_acad', $note->annee_acad]])
->first()->credit;
$compte += DB::connection('tenant')
->table('ecu')
->where([['insertion', 'NO'], ['code_unite', $note->code_unite], ['code_ecu', $note->code_ecu], ['annee', $note->annee], ['niveauFormation', $note->niveauFormation], ['annee_acad', $note->annee_acad]])
->first()->credit;
}
}
if ($compte == 0) {
$compte = 1;
}
$moyenne /= $compte;
$moyenne = sprintf('%.2f', $moyenne);
$sommeMoyenne += $moyenne;
if ($ue->type_ue == 0) {
$couleur = '#000000';
} elseif ($ue->type_ue == 1) {
$couleur = '#ff0000';
} elseif ($ue->type_ue == 2) {
$couleur = '#0000ff';
} elseif ($ue->type_ue == 3) {
$couleur = '#008100';
}
$creditCapitalise += $creditValide[$j][$l];
@endphp
|
{{ $ue->code_unite }} |
{{ $ue->intituleUnite }} |
{{ Illuminate\Support\Facades\DB::connection('tenant')->table('academique')->where('annee_acad', $ue->annee_acad)->first()->periode }}
|
{{ $ue->credit }} |
{{ $creditValide[$j][$l] }} |
{{ $frequence[$j][$l] }} |
{{ $moyenne }} |
{{ App\Http\Helpers\GradeHelpers::grade($moyenne) }} |
@if ($creditValide[$j][$l] == 0)
Non Validé
@else
Validé
@endif
|
@php
$l++;
@endphp
@endforeach
@if ($idSemestre[2] != 0)
| SEMESTRE {{ $idSemestre[2] }} |
@foreach ($ues2 as $ue)
@php
$sommeCredit2 += $ue->credit;
$moyenne = 0;
$compte = 0;
$ra = 0;
$notes = DB::connection('tenant')
->table('noteEcu')
->where([['matricule', $etudiant->matricule], ['idFiliere', $etudiant->idFiliere], ['code_unite', $ue->code_unite], ['annee', $etudiant->annee], ['niveauFormation', $etudiant->niveauFormation], ['annee_acad', $ue->annee_acad]])
->get();
foreach ($notes as $note) {
if ($note->modifRa == 'YES') {
$ra = 1;
}
if ($ue->moy_pondere == 'NO') {
$moyenne += $note->noteEcu;
$compte++;
} else {
$moyenne +=
$note->noteEcu *
DB::connection('tenant')
->table('ecu')
->where([['insertion', 'NO'], ['code_unite', $note->code_unite], ['code_ecu', $note->code_ecu], ['annee', $note->annee], ['niveauFormation', $note->niveauFormation], ['annee_acad', $note->annee_acad]])
->first()->credit;
$compte += DB::connection('tenant')
->table('ecu')
->where([['insertion', 'NO'], ['code_unite', $note->code_unite], ['code_ecu', $note->code_ecu], ['annee', $note->annee], ['niveauFormation', $note->niveauFormation], ['annee_acad', $note->annee_acad]])
->first()->credit;
}
}
if ($compte == 0) {
$compte = 1;
}
$moyenne /= $compte;
$moyenne = sprintf('%.2f', $moyenne);
$sommeMoyenne += $moyenne;
if ($ue->type_ue == 0) {
$couleur = '#000000';
} elseif ($ue->type_ue == 1) {
$couleur = '#ff0000';
} elseif ($ue->type_ue == 2) {
$couleur = '#0000ff';
} elseif ($ue->type_ue == 3) {
$couleur = '#008100';
}
$creditCapitalise += $creditValide[$j][$l];
@endphp
|
{{ $ue->code_unite }} |
{{ $ue->intituleUnite }} |
{{ Illuminate\Support\Facades\DB::connection('tenant')->table('academique')->where('annee_acad', $ue->annee_acad)->first()->periode }}
|
{{ $ue->credit }} |
{{ $creditValide[$j][$l] }} |
{{ $frequence[$j][$l] }} |
{{ $moyenne }} |
{{ App\Http\Helpers\GradeHelpers::grade($moyenne) }} |
@if ($creditValide[$j][$l] == 0)
Non Validé
@else
Validé
@endif
|
@php
$l++;
@endphp
@endforeach
@endif