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