public function post($id, Request $request)
{
$idEvaluation = Evaluation::join('type_evaluations', 'type_evaluations.id', '=', 'evaluations.type_evaluation_id')->where('evaluations.id', $id)->first();
$criteres = CritereTypeEvaluation::join('criteres', 'criteres.id', '=', 'critere_type_evaluation.critere_id')->where('type_evaluation_id', $idEvaluation->type_evaluation_id)->get();
$etudiants = Etudiant::where('groupe_projet_id', $idEvaluation->groupe_projet_id)->get();
$roles = EnseignantEvaluationRole::join('roles', 'roles.id', '=', 'enseignant_evaluation_role.role_id')->join('enseignants', 'enseignants.id', '=', 'enseignant_evaluation_role.enseignant_id')->where('evaluation_id', $id)->get();
foreach ($etudiants as $key => $etudiant) {
EtudiantEvaluation::insert([['noteIndividuelle' => $request->input('note' . $etudiant->id), 'remarqueIndividuelle' => '', 'etudiant_id' => $etudiant->id, 'evaluation_id' => $id]]);
}
foreach ($criteres as $key => $critere) {
foreach ($roles as $key => $role) {
CritereEnseignantEvaluation::where('enseignant_id', $role->enseignant_id)->where('evaluation_id', $id)->where('critere_id', $critere->critere_id)->update(['noteCritere' => $request->input('critere' . $critere->critere_id . $role->enseignant_id)]);
}
}
Evaluation::where('evaluations.id', $id)->update(['noteGroupe' => $request->input('noteMoyGroupe')]);
return redirect()->action('GroupeProjetController@index');
}
