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);
}
}
