public function run() { Series::truncate(); $users = User::all(); foreach ($users as $user) { DB::table('exercise_series')->insert(['name' => 'pushup', 'user_id' => $user->id, 'priority' => 1]); DB::table('exercise_series')->insert(['name' => 'pullup', 'user_id' => $user->id, 'priority' => 1]); DB::table('exercise_series')->insert(['name' => 'squat', 'user_id' => $user->id, 'priority' => 2]); DB::table('exercise_series')->insert(['name' => 'gymnastic rings', 'user_id' => $user->id, 'priority' => 1]); DB::table('exercise_series')->insert(['name' => 'flexibility', 'user_id' => $user->id, 'priority' => 1]); } }
public function run() { Workout::truncate(); DB::table('series_workout')->truncate(); $users = User::all(); foreach ($users as $user) { $this->user = $user; $seriesIds = ExerciseSeries::where('user_id', $this->user->id)->lists('id')->all(); $this->createWorkout('day one', [$seriesIds[0], $seriesIds[1]]); $this->createWorkout('day two', $seriesIds[2]); } }
public function run() { Exercise::truncate(); $this->faker = Faker::create(); $pushups = [['name' => 'kneeling pushups', 'defaultQuantity' => 20, 'description' => '', 'priority' => 2, 'frequency' => 7], ['name' => 'pushups', 'defaultQuantity' => 10, 'description' => 'hands shoulder width', 'priority' => 1], ['name' => 'one-arm pushups', 'defaultQuantity' => 2, 'description' => 'free hand behind back', 'priority' => 1]]; $squats = [['name' => 'assisted squats', 'defaultQuantity' => 50, 'description' => 'hold onto something', 'priority' => 3, 'frequency' => 3], ['name' => 'squats', 'defaultQuantity' => 30, 'description' => 'feet shoulder width', 'priority' => 2], ['name' => 'one-legged-squats', 'defaultQuantity' => 5, 'description' => '', 'priority' => 1]]; $gymnasticRings = [['name' => 'back lever', 'defaultQuantity' => 30, 'description' => '', 'priority' => 1, 'frequency' => 4]]; $flexibility = [['name' => 'hamstrings', 'defaultQuantity' => 20, 'description' => '', 'priority' => 2, 'stretch' => 1, 'frequency' => 7], ['name' => 'calves', 'defaultQuantity' => 10, 'description' => 'great stretch', 'priority' => 1, 'stretch' => 1]]; $users = User::all(); foreach ($users as $user) { $this->user = $user; $exercise_unit_ids = Unit::where('user_id', $this->user->id)->where('for', 'exercise')->lists('id')->all(); $this->insertExercisesInSeries($pushups, Unit::find($exercise_unit_ids[0]), Series::where('user_id', $this->user->id)->where('name', 'pushup')->first()); $this->insertExercisesInSeries($squats, Unit::find($exercise_unit_ids[1]), Series::where('user_id', $this->user->id)->where('name', 'squat')->first()); $this->insertExercisesInSeries($gymnasticRings, Unit::find($exercise_unit_ids[1]), Series::where('user_id', $this->user->id)->where('name', 'gymnastic rings')->first()); $this->insertExercisesInSeries($flexibility, Unit::find($exercise_unit_ids[1]), Series::where('user_id', $this->user->id)->where('name', 'flexibility')->first()); } }
/** * Get all the exercise series that belong to the user * @return mixed */ public function getExerciseSeries() { $series = Series::forCurrentUser('exercise_series')->orderBy('name', 'asc')->get(); return $series; }
/** * @return array */ public function transform(Series $series) { $array = ['id' => $series->id, 'name' => $series->name, 'priority' => $series->priority, 'workout_ids' => $series->workouts()->lists('id'), 'lastDone' => $series->lastDone]; return $array; }
/** * Get all the user's entries for an exercise series. * This could be expressed two ways: * 1: $series->entries * 2: $entry->where('series_id', $series->id) * @param Request $request * @return array */ public function show($series_id) { //Fetch the series (singular-the series that was clicked on) $series = Series::find($series_id); return transform(createCollection($this->exerciseSeriesRepository->getExerciseSeriesHistory($series), new ExerciseEntryTransformer()))['data']; }
/** * * @param Series $series * @return \Illuminate\Http\Response * @throws \Exception */ public function destroy(Series $series) { try { $series->delete(); return $this->responseNoContent(); } catch (\Exception $e) { //Integrity constraint violation if ($e->getCode() === '23000') { $message = 'Series could not be deleted. It is in use.'; } else { $message = 'There was an error'; } return response(['error' => $message, 'status' => Response::HTTP_BAD_REQUEST], Response::HTTP_BAD_REQUEST); } }
/** * @test * @return void */ public function it_can_delete_a_series() { $this->logInUser(); $series = new Series(['name' => 'echidna']); $series->user()->associate($this->user); $series->save(); // $series->workouts()->sync([1,2]); $this->seeInDatabase('exercise_series', ['name' => 'echidna']); // $this->seeInDatabase('series_workout', ['series_id' => $series->id, 'workout_id' => 1]); // $this->seeInDatabase('series_workout', ['series_id' => $series->id, 'workout_id' => 2]); $response = $this->call('DELETE', '/api/exerciseSeries/' . $series->id); $this->assertEquals(204, $response->getStatusCode()); $this->missingFromDatabase('exercise_series', ['name' => 'echidna']); //Check the rows were deleted in the series_workout pivot table // $this->missingFromDatabase('series_workout', ['series_id' => $series->id, 'workout_id' => 1]); // $this->missingFromDatabase('series_workout', ['series_id' => $series->id, 'workout_id' => 2]); $response = $this->call('DELETE', '/api/exerciseSeries/' . $series->id); $this->assertEquals(404, $response->getStatusCode()); }
/** * * @param Request $request * @param Exercise $exercise * @return mixed */ public function update(Request $request, Exercise $exercise) { // Create an array with the new fields merged $data = array_compare($exercise->toArray(), $request->only(['name', 'step_number', 'default_quantity', 'description', 'target', 'priority', 'frequency'])); $exercise->update($data); if ($request->has('stretch')) { $exercise->stretch = $request->get('stretch'); $exercise->save(); } if ($request->has('series_id')) { $series = Series::findOrFail($request->get('series_id')); $exercise->series()->associate($series); $exercise->save(); } if ($request->has('program_id')) { $program = ExerciseProgram::findOrFail($request->get('program_id')); $exercise->program()->associate($program); $exercise->save(); } if ($request->has('default_unit_id')) { $unit = Unit::where('for', 'exercise')->findOrFail($request->get('default_unit_id')); $exercise->defaultUnit()->associate($unit); $exercise->save(); } return $this->responseOkWithTransformer($exercise, new ExerciseTransformer()); }
/** * Define your route model bindings, pattern filters, etc. * * @param \Illuminate\Routing\Router $router * @return void */ public function boot(Router $router) { parent::boot($router); Route::bind('exercises', function ($id) { return Exercise::forCurrentUser()->findOrFail($id); }); Route::bind('exerciseEntries', function ($id) { return ExerciseEntry::forCurrentUser()->findOrFail($id); }); Route::bind('menuEntries', function ($id) { return MenuEntry::forCurrentUser()->findOrFail($id); }); Route::bind('exerciseSeries', function ($id) { return ExerciseSeries::forCurrentUser()->findOrFail($id); }); Route::bind('foods', function ($id) { return Food::forCurrentUser()->findOrFail($id); }); Route::bind('recipes', function ($id) { return Recipe::forCurrentUser()->findOrFail($id); }); Route::bind('exerciseTags', function ($id) { return Tag::forCurrentUser()->where('for', 'exercise')->findOrFail($id); }); Route::bind('recipeTags', function ($id) { return Tag::forCurrentUser()->where('for', 'recipe')->findOrFail($id); }); Route::bind('foodUnits', function ($id) { return Unit::forCurrentUser()->where('for', 'food')->findOrFail($id); }); Route::bind('exerciseUnits', function ($id) { return Unit::forCurrentUser()->where('for', 'exercise')->findOrFail($id); }); Route::bind('timers', function ($id) { return Timer::forCurrentUser()->findOrFail($id); }); Route::bind('activities', function ($id) { return Activity::forCurrentUser()->findOrFail($id); }); Route::bind('weights', function ($idOrDate) { if (strrpos($idOrDate, '-')) { //parameter is the date of the entry $weight = Weight::forCurrentUser()->where('date', $idOrDate)->first(); } else { //parameter is the id of the entry $weight = Weight::forCurrentUser()->findOrFail($idOrDate); } return $weight; }); /** * $parameter is either the id or the date */ Route::bind('journal', function ($parameter) { /** * @VP: * Is there a better way to check if the $parameter is an * id or a date? When I tried using Carbon to create an object from * the parameter, it threw an exception when the $parameter was the id, * whereas I just wanted a boolean. */ if (strrpos($parameter, '-')) { //$parameter is the date of the entry $journal = Journal::forCurrentUser()->where('date', $parameter)->first(); } else { //$parameter is the id of the entry $journal = Journal::forCurrentUser()->findOrFail($parameter); } return $journal; }); }