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