public function run()
 {
     DB::table('specialites')->delete();
     Specialite::create(['nom' => 'AL'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'IHM'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'GMD'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'IMAFA'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'CASPAR'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'WEB'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::create(['nom' => 'IAM'])->promotion()->attach(\App\Promotion::where('nom', 'SI5')->first());
     Specialite::where('nom', 'GMD')->first()->promotion()->attach(\App\Promotion::where('nom', 'MAM5')->first());
     Specialite::where('nom', 'IMAFA')->first()->promotion()->attach(\App\Promotion::where('nom', 'MAM5')->first());
 }
 /**
  * Afficher une offre de stage
  * @param $id
  */
 public function show($id)
 {
     $array['offre'] = OffreStage::where('offre_stages.id', $id)->with('entreprise')->first();
     if ($array['offre']->promotion_id != null) {
         $array['offre']['promotion'] = Promotion::find($array['offre']->promotion_id);
     }
     if ($array['offre']->specialite_id != null) {
         $array['offre']['specialite'] = Specialite::find($array['offre']->specialite_id);
     }
     $array['feedbacks'] = $this->getFeedbacks($id);
     //dd($array['feedbacks']);
     //les candidatures sur l'offre de stage
     $array['candidatures'] = $this->getCandidatures($id);
     return $array;
 }
 public function post_Update(ParcoursRequest $request, $id)
 {
     if (!Helpers::isAdmin()) {
         return redirect('/');
     }
     $parcours = Parcours::findOrFail($id);
     $specialite = Specialite::findOrFail($request->input('specialite'));
     $parcours->intitule = $request->input('intitule');
     $parcours->description = $request->input('description');
     $parcours->annee = $request->input('annee');
     $parcours->nb_opt_s1 = $request->input('nb_opt_s1');
     $parcours->deb_choix_s1 = $request->input('deb_choix_s1');
     $parcours->fin_choix_s1 = $request->input('fin_choix_s1');
     $parcours->nb_opt_s2 = $request->input('nb_opt_s2');
     $parcours->deb_choix_s2 = $request->input('deb_choix_s2');
     $parcours->fin_choix_s2 = $request->input('fin_choix_s2');
     $parcours->specialite_id = $specialite->id;
     $parcours->save();
     $text = "Le parcours: " . $request->input('intitule') . " à été modifiée";
     return view("confirmation", ['text' => $text]);
 }
 public function post_DeleteConfirm($id)
 {
     if (!Helpers::isAdmin()) {
         return redirect('/');
     }
     $text = Specialite::findOrFail($id)->intitule . " à été supprimé";
     Specialite::destroy($id);
     return view("confirmation", ['text' => $text]);
 }