public function attachToMuscleGroups($muscleGroups)
{
foreach ($muscleGroups as $muscleGroup) {
$muscle_group_id = MuscleGroup::where('name', $muscleGroup);
$this->muscleGroups()->attach($muscle_group_id);
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
return Response::json(MuscleGroup::with('muscles')->find($id));
}
/**
* 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");
MuscleGroup::truncate();
DB::statement("TRUNCATE TABLE `muscle_muscle_group`");
DB::statement("SET foreign_key_checks=1");
$muscleGroup = MuscleGroup::create(['name' => 'Chest']);
$muscles = [];
$muscles[] = 'Pectoralis Major Sternal Head';
$muscles[] = 'Pectoralis Major Clavicular Head';
$muscles[] = 'Pectoralis Minor';
$muscles[] = 'Serratus Anterior';
$muscleGroup->addMuscles($muscles);
$muscleGroup = MuscleGroup::create(['name' => 'Back']);
$muscles = [];
$muscles[] = 'Latissimus Dorsi';
$muscles[] = 'Rhomboids';
$muscles[] = 'Trapezius Lower Fibers';
$muscles[] = 'Trapezius Middle Fibers';
$muscles[] = 'Erector Spinae';
$muscleGroup->addMuscles($muscles);
$muscleGroup->addMuscles($muscles);
$muscleGroup = MuscleGroup::create(['name' => 'Upper Back']);
$muscles = [];
$muscles[] = 'Latissimus Dorsi';
$muscles[] = 'Rhomboids';
$muscles[] = 'Trapezius Lower Fibers';
$muscles[] = 'Trapezius Middle Fibers';
$muscleGroup->addMuscles($muscles);
$muscleGroup->addMuscles($muscles);
$muscleGroup = MuscleGroup::create(['name' => 'Lower Back']);
$muscles = [];
$muscles[] = 'Erector Spinae';
$muscleGroup->addMuscles($muscles);
$muscleGroup = MuscleGroup::create(['name' => 'Traps']);
$muscles = [];
$muscles[] = 'Trapezius Upper Fibers';
$muscles[] = 'Levator Scapulae';
$muscleGroup->addMuscles($muscles);
$muscleGroup = MuscleGroup::create(['name' => 'Shoulders']);
$muscles = [];
$muscles[] = 'Deltoid Anterior';
$muscles[] = 'Deltoid Lateral';
$muscles[] = 'Deltoid Posterior';
$muscles[] = 'Infraspinatus';
$muscles[] = 'Supraspinatus';
$muscles[] = 'Teres Major';
$muscles[] = 'Teres Minor';
$muscleGroup->addMuscles($muscles);
/*
MuscleGroup::create(['name' => 'Shoulders']);
MuscleGroup::create(['name' => 'Upper Arms']);
MuscleGroup::create(['name' => 'Biceps']);
MuscleGroup::create(['name' => 'Triceps']);
MuscleGroup::create(['name' => 'Forearms']);
MuscleGroup::create(['name' => 'Lower arms']);
MuscleGroup::create(['name' => 'Thighs']);
MuscleGroup::create(['name' => 'Legs']);
MuscleGroup::create(['name' => 'Calf']);
*/
}
