public function enregistrer() { if (\Request::ajax()) { $salle_id = \Input::get('salle_id'); $color = \Input::get('color'); $time = \Input::get('time'); $dayname = \Input::get('dayname'); $cr_id = \Input::get('cr_id'); $mat = \Input::get('matiere'); $matiere_id = \Input::get('matiere_id'); $ts = Timesheet::where('time', $time)->where('dayname', $dayname)->where('classroom_id', $cr_id)->where('user_id', \Auth::user()->id)->where('matter_id', '!=', 0)->first(); if (isset($salle_id) && !empty($salle_id)) { if ($ts) { $room = Room::find($salle_id); $yes = DB::table('matter_room')->where('matter_id', $ts->matter_id)->where('room_id', $salle_id)->first(); if (!$yes) { $room->matters()->attach([$ts->matter_id]); } } } $livingDaylights = ['lundi', 'mardi', 'mercredi', 'jeudi', 'vendredi', 'samedi']; $times = ['08:00:00', '09:00:00', '10:00:00', '11:00:00', '12:00:00', '13:00:00', '14:00:00', '15:00:00', '16:00:00', '17:00:00']; if ($dayname == 'lundi') { $ts = new Timesheet(); $ts->lundi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'mardi') { $ts = new Timesheet(); $ts->mardi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'mercredi') { $ts = new Timesheet(); $ts->mercredi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'jeudi') { $ts = new Timesheet(); $ts->jeudi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'vendredi') { $ts = new Timesheet(); $ts->vendredi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } elseif ($dayname == 'samedi') { $ts = new Timesheet(); $ts->samedi = $dayname; $ts->classroom_id = $cr_id; $ts->user_id = \Auth::user()->id; $ts->time = $time; $ts->matiere = $mat; $ts->matter_id = $matiere_id; $ts->color = $color; $ts->dayname = $dayname; $ts->room_id = $salle_id ?: 0; $ts->school_year_id = SchoolYear::getSchoolYearId(); $ts->save(); } } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $validator = Validator::make([$request->all(), 'nom_classe' => $request->nom_classe, 'capacite_classe' => $request->capacite_classe, 'niveau' => $request->niveau, 'branche' => $request->branche, 'grade' => $request->grade], ['nom_classe' => 'required', 'capacite_classe' => 'required|integer', 'grade' => 'required|integer'], ['nom_classe.required' => "le nom de la classe est requis", 'capacite_classe.required' => "la capacité de la classe est requis", 'capacite_classe.integer' => "la capacité de la classe doit etre un nombre entier", 'niveau.integer' => "Le Niveau est requis", 'grade.integer' => "Le Niveau Global est requis"]); if ($validator->passes()) { $niveau_global = \Auth::user()->grades()->where('id', $request->grade)->first()->name; $cr = new Classroom(); $cr->nom_classe = $request->nom_classe; $cr->code_classe = $request->code_classe; $cr->capacite_classe = $request->capacite_classe; $cr->niveau = $request->niveau; $cr->school_year_id = $request->ann_scol; if ($niveau_global == 'Lycée') { $cr->branche = $request->branche; } else { $cr->branche = ''; } $cr->user_id = \Auth::user()->id; $cr->save(); $ts = new Timesheet(); $ts->user_id = \Auth::user()->id; $ts->classroom_id = $cr->id; $ts->school_year_id = $request->ann_scol; $ts->save(); $level = Level::find($request->niveau); if ($niveau_global == 'Lycée') { DB::table('branch_classroom_level')->insert(['classroom_id' => $cr->id, 'branch_id' => $request->branche, 'level_id' => $level->id]); } else { $level->lesClasses()->attach([$cr->id]); } if ($cr) { if (isset($request->select)) { $classe = Classroom::where('user_id', \Auth::user()->id)->where('id', $cr->id)->first(); $classe->matters()->attach($request->select); } } return redirect()->action('StatisticsController@gestion')->with('success', 'Informations bien enregistrées'); } else { return redirect()->back()->withErrors($validator); } }