public function addExercises($exercises) { foreach ($exercises as $exercise) { $exercise_id = Exercise::where('name', $exercise[0])->first(); $this->exercises()->attach($exercise_id, ['position' => $exercise[1]]); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit(Request $request, $id) { $exercise = Exercise::where('id', $id)->first(); if ($exercise && ($request->user()->id == $exercise->user_id || $request->user()->is_admin())) { return view('exercises.edit')->with('exercise', $exercise); } return redirect('/exercise/index')->withErrors('You have not sufficient permissions'); }
/** * Execute the console command. * * @return mixed */ public function handle() { DB::enableQueryLog(); // Delete all data in the database, TODO: remove before production DB::statement("SET foreign_key_checks=0"); ExerciseAlias::truncate(); DB::statement("TRUNCATE TABLE `exercise_aliases`"); DB::statement("SET foreign_key_checks=1"); $exercise_id = Exercise::where('name', 'Bicep curl')->first()->id; ExerciseAlias::create(['name' => 'Curls', 'exercise_id' => $exercise_id]); $exercise_id = Exercise::where('name', 'Skull-crusher')->first()->id; ExerciseAlias::create(['name' => 'Triceps extension', 'exercise_id' => $exercise_id]); $exercise_id = Exercise::where('name', 'Overhead press')->first()->id; ExerciseAlias::create(['name' => 'Military press', 'exercise_id' => $exercise_id]); }
public function allFromUser($user) { $exercises = Exercise::where('user_id', '>', $user)->get(); return view('exercises.index', compact('exercises')); }