/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($encadrantId = null, $stageId = null, $studentId = null)
{
//afficher all student of specifique encadrant of specifique stage of a specifique encadrant
if (is_null($studentId)) {
return Encadrant_Stage_Etudiant::join('Etudiant', 'Etudiant.id_Etudiant', '=', 'Encadrant_Stage_Etudiant.id_Etudiant')->select('Etudiant.*')->where('Encadrant_Stage_Etudiant.id_Enseignant', '=', $encadrantId)->where('Encadrant_Stage_Etudiant.id_Stage', '=', $stageId)->distinct()->get();
} else {
$etudiant = Etudiant::find($studentId);
return is_null($etudiant) ? response()->json(['error' => 'etudiant Note not found'], HttpResponse::HTTP_NOT_FOUND) : $etudiant;
}
}
public function __construct(EtudiantRepository $etudiant_gestion, CvRepository $cv_gestion, FiliereRepository $filiere_gestion)
{
$this->middleware('auth');
if (Auth::check()) {
if (Auth::user()->admin == true) {
return redirect()->route('admin');
} else {
$this->etudiant = Etudiant::find(Auth::user()->etudiant_id);
$this->etudiant_gestion = $etudiant_gestion;
$this->filiere_gestion = $filiere_gestion;
$this->cv_gestion = $cv_gestion;
}
}
return redirect()->guest('login');
}
/**
* Create or update a cv.
*
* @param App\Models\cv $cv
* @param array $inputs
* @param bool $user_id
* @return App\Models\cv
*/
public function save($inputs)
{
if (isset($inputs['nomcv'])) {
$this->model->nom_cv = $inputs['nomcv'];
}
if (isset($inputs['lienVideo'])) {
$this->model->lienVideo = $inputs['lienVideo'];
}
if (isset($inputs['etudiant'])) {
$this->etudiant = Etudiant::find(intval($inputs['etudiant']));
if ($this->etudiant != null) {
$this->model->etudiant_id = $this->etudiant->id;
}
}
$this->model->save();
return $this->model;
}
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');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//$enseignant = EnseignantEvaluationRole::where('enseignant_id', )
// ->where('evaluation_id', $id)
// ->first();
//if ($enseigant->vote==1) {
// if ($enseignant->role_id==1) {
// return redirect()->action('RecapitulationController@show',$id);
// }
// return redirect()->action('GroupeProjetController@index');
//}
$idEvaluation = Evaluation::join('type_evaluations', 'type_evaluations.id', '=', 'evaluations.type_evaluation_id')->where('evaluations.id', $id)->first();
$etudiants = Etudiant::where('groupe_projet_id', $idEvaluation->groupe_projet_id)->get();
$projets = GroupeProjet::with('etudiant', 'enseignant')->whereId($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();
$criteres = CritereTypeEvaluation::join('criteres', 'criteres.id', '=', 'critere_type_evaluation.critere_id')->where('type_evaluation_id', $idEvaluation->type_evaluation_id)->get();
return view('jury.grille', compact('id', 'projets', 'etudiants', 'idEvaluation', 'roles', 'criteres'));
}
public function get($id)
{
return Etudiant::find($id);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Etudiant::destroy($id);
return array('success' => true);
}
public function upload(Request $request)
{
$id = $request->input('id');
$etudiant = Etudiant::find($id);
// getting all of the post data
$file = array('image' => Input::file('file'));
if (!Input::hasFile('file')) {
return $etudiant;
}
// setting up rules
$rules = array('image' => 'required');
//mimes:jpeg,bmp,png and for max size max:10000
// doing the validation, passing post data, rules and the messages
$validator = Validator::make($file, $rules);
if ($validator->fails()) {
// send back to the page with the input data and errors
return $etudiant;
} else {
// checking file is valid.
if (Input::file('file')->isValid()) {
$destinationPath = '../storage/uploads';
// upload path
$extension = Input::file('file')->getClientOriginalExtension();
// getting image extension
$fileName = Input::file('file')->getClientOriginalName();
$fileName = str_replace(" ", "_", $fileName);
$fileName = str_replace($extension, "_", $fileName);
$fileName = $fileName . '_' . rand(11111, 99999) . '.' . $extension;
// renameing image
Input::file('file')->move($destinationPath, $fileName);
// uploading file to given path
// sending back with message
Session::flash('success', 'Upload successfully');
$etudiant->photo = $fileName;
$etudiant->save();
return $etudiant;
} else {
// sending back with error message.
Session::flash('error', 'uploaded file is not valid');
return $etudiant;
}
}
}
public function verif(Request $request, $sessionId)
{
$cin = Input::get('cin');
$email = Input::get('email');
$id_Etudiant = $this->gestSession->verifEtudiant($cin, $email);
if (!$id_Etudiant) {
//Caractéristique fausse ;
return redirect('session/' . $sessionId . '/inscription')->withError("Verifier votre CIN");
} else {
$verif_niveau = $this->gestSession->verifNiveauEtudiant($id_Etudiant, $sessionId);
//echo $verif_niveau;
if (!$verif_niveau) {
return redirect('session/' . $sessionId . '/inscription')->withError("Vous n'avez pas le niveau requis");
} else {
$etudiant = Etudiant::find($id_Etudiant);
if ($etudiant->active == 0) {
$confirmation_code = str_random(80);
$link = $request->root() . "/email/confirmation/" . $sessionId . "/" . $id_Etudiant . "/" . $confirmation_code;
$etudiant->confirmation_code = $confirmation_code;
$etudiant->email = $email;
$etudiant->save();
Mail::send('validationEmail', ['nom' => $etudiant->nom, 'prenom' => $etudiant->prenom, 'CIN' => $etudiant->CIN, 'carte_Etudiant' => $etudiant->carte_Etudiant, 'link' => $link], function ($message) use($email) {
$message->to($email)->subject('Verification');
});
return redirect('session/' . $sessionId . '/inscription')->withOk("Vous recevrez un mail de confirmation sur votre email !");
} else {
return redirect('/session/' . $sessionId . '/inscription/' . $id_Etudiant);
}
}
}
}
public function getEtudiantNInscrit($examenId, $rech)
{
$et = Etudiant_Examen::where('id_Examen', '=', $examenId)->select('Etudiant_Examen.id_Etudiant')->get();
return Etudiant::whereNotIn('id_Etudiant', $et)->where('Etudiant.nom', 'LIKE', $rech . '%')->get();
}
public function show()
{
$etudiants = Etudiant::get();
return view('etudiant-cv.show', compact('etudiants'));
}
public function getEtudiants($rech)
{
return Etudiant::join('Niveau', 'Etudiant.id_Niveau', '=', 'Niveau.id_Niveau')->where('Etudiant.nom', 'LIKE', $rech . '%')->get();
}
