public static function exerciseNames()
{
$exercises = Exercise::all(['name', 'id']);
$exerciseNames = [];
foreach ($exercises as $exercise) {
$exerciseNames[$exercise->id] = $exercise->name;
}
return $exerciseNames;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// Truncate the Table First
DB::table('exercises')->truncate();
// Names
$names = ['Sit Stay', 'Crate Hold', 'Situps', 'Rollover', 'Heel', 'Touch'];
foreach ($names as $name) {
Exercise::create(['name' => $name]);
}
}
public function actionData($id)
{
if (isset($_GET['del'])) {
return $this->render('data', ['id' => $id, 'forms' => Forms::find()->where(['id' => $id])->one()->delete(), 'exercises' => Exercise::deleteAll(['p_id' => $id])]);
} elseif (isset($_GET['edit']) && isset($_POST['Forms'])) {
$f = Forms::find()->where(['id' => $id])->one();
$f->load(Yii::$app->request->post());
$f->save();
echo "<script>location.href = '/';</script>";
} elseif (isset($_GET['edit'])) {
return $this->render('data', ['id' => $id, 'forms' => Forms::find()->where(['id' => $id])->one()]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// Exercise IDs
$squatID = Exercise::where('name', 'Barbell Squat')->first()->id;
$overheadPressID = Exercise::where('name', 'Overhead Press')->first()->id;
$deadliftID = Exercise::where('name', 'Deadlift')->first()->id;
$pullUpID = Exercise::where('name', 'Pull-up')->first()->id;
$runningID = Exercise::where('name', 'Running')->first()->id;
DB::table('exercise_groups')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'workout_id' => 1, 'exercise_id' => $squatID, 'group_order' => 1]);
DB::table('exercise_groups')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'workout_id' => 1, 'exercise_id' => $overheadPressID, 'group_order' => 2]);
DB::table('exercise_groups')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'workout_id' => 1, 'exercise_id' => $deadliftID, 'group_order' => 3]);
DB::table('exercise_groups')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'workout_id' => 1, 'exercise_id' => $pullUpID, 'group_order' => 4]);
DB::table('exercise_groups')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'workout_id' => 2, 'exercise_id' => $runningID, 'group_order' => 1]);
}
/**
* Responds to GET::/workouts requests
*
* @return workouts.create view with exercises and units data
*/
public function create()
{
$exercises = Exercise::orderBy('name')->get(['id', 'name', 'description', 'exercise_type']);
$units = Unit::filteredUnits(['weight' => Unit::$unitMassType, 'distance' => Unit::$unitDistanceType]);
return view('workouts.create')->with('exercises', $exercises)->with('units', $units);
}
public function actionData($id)
{
return $this->render('data', ['id' => $id, 'exercises' => Exercise::find()->where(['id' => $id])->one()->delete()]);
}
