public function attachToMuscle($muscles)
{
foreach ($muscles as $muscle) {
$muscle_id = Muscle::where('name', $muscle[0])->first();
$this->muscles()->attach($muscle_id, ['muscle_intensity' => $muscle[1]]);
}
}
public function addMuscles($muscles)
{
foreach ($muscles as $muscle) {
$muscle_id = Muscle::where('name', $muscle)->first();
$this->muscles()->attach($muscle_id);
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
Muscle::create(['name' => 'Adductors']);
Muscle::create(['name' => 'Biceps Brachii']);
Muscle::create(['name' => 'Brachialis']);
Muscle::create(['name' => 'Brachioradialis']);
Muscle::create(['name' => 'Deltoid Anterior']);
Muscle::create(['name' => 'Deltoid Lateral']);
Muscle::create(['name' => 'Deltoid Posterior']);
Muscle::create(['name' => 'Deep Hip External Rotators']);
Muscle::create(['name' => 'Erector Spinae']);
Muscle::create(['name' => 'Gastrocnemius']);
Muscle::create(['name' => 'Gluteus Maximus']);
Muscle::create(['name' => 'Gluteus Medius']);
Muscle::create(['name' => 'Gluteus Minimus']);
Muscle::create(['name' => 'Gracilis']);
Muscle::create(['name' => 'Hamstrings']);
Muscle::create(['name' => 'Iliopsoas']);
Muscle::create(['name' => 'Infraspinatus']);
Muscle::create(['name' => 'Latissimus Dorsi']);
Muscle::create(['name' => 'Levator Scapulae']);
Muscle::create(['name' => 'Obliques']);
Muscle::create(['name' => 'Pectineous']);
Muscle::create(['name' => 'Pectoralis Major Clavicular Head']);
Muscle::create(['name' => 'Pectoralis Major Sternal Head']);
Muscle::create(['name' => 'Pectoralis Minor']);
Muscle::create(['name' => 'Popliteus']);
Muscle::create(['name' => 'Quadratus Lumborum']);
Muscle::create(['name' => 'Quadriceps']);
Muscle::create(['name' => 'Rectus Abdominis']);
Muscle::create(['name' => 'Rhomboids']);
Muscle::create(['name' => 'Sartorius']);
Muscle::create(['name' => 'Serratus Anterior']);
Muscle::create(['name' => 'Soleus']);
Muscle::create(['name' => 'Splenius']);
Muscle::create(['name' => 'Sternocleidomastoid']);
Muscle::create(['name' => 'Subscapularis']);
Muscle::create(['name' => 'Supraspinatus']);
Muscle::create(['name' => 'Tensor Fasciae Latae']);
Muscle::create(['name' => 'Teres Major']);
Muscle::create(['name' => 'Teres Minor']);
Muscle::create(['name' => 'Tibialis Anterior']);
Muscle::create(['name' => 'Transverse Abdominus']);
Muscle::create(['name' => 'Trapezius Lower Fibers']);
Muscle::create(['name' => 'Trapezius Middle Fibers']);
Muscle::create(['name' => 'Trapezius Upper Fibers']);
Muscle::create(['name' => 'Triceps Brachii']);
Muscle::create(['name' => 'Wrist Extensors']);
Muscle::create(['name' => 'Wrist Flexors']);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
return Response::json(Muscle::with('muscleAlias') . 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");
MuscleAlias::truncate();
DB::statement("TRUNCATE TABLE `muscle_aliases`");
DB::statement("SET foreign_key_checks=1");
$muscle_id = Muscle::where('name', 'Adductors')->first()->id;
MuscleAlias::create(['name' => 'Inner Thigh', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Biceps Brachii')->first()->id;
MuscleAlias::create(['name' => 'Biceps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Brachialis')->first()->id;
MuscleAlias::create(['name' => 'Lower Biceps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Brachioradialis')->first()->id;
MuscleAlias::create(['name' => 'Upper Forearm', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Deltoid Anterior')->first()->id;
MuscleAlias::create(['name' => 'Front delts', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Front shoulders', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Deltoid Lateral')->first()->id;
MuscleAlias::create(['name' => 'Side Delts', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Side shoulders', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Deltoid Posterior')->first()->id;
MuscleAlias::create(['name' => 'Rear Delts', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Rear shoulders', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Deep Hip External Rotators')->first()->id;
MuscleAlias::create(['name' => 'Hip rotators', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Erector Spinae')->first()->id;
MuscleAlias::create(['name' => 'Lower Back', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Gastrocnemius')->first()->id;
MuscleAlias::create(['name' => 'Calf', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Gluteus Maximus')->first()->id;
MuscleAlias::create(['name' => 'Butt', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Glutes', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Gluteus Medius')->first()->id;
MuscleAlias::create(['name' => 'Hip', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Hip abductor', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Gluteus Minimus')->first()->id;
MuscleAlias::create(['name' => 'Small hip', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Gracilis')->first()->id;
MuscleAlias::create(['name' => 'Hip Adductor', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Hamstrings')->first()->id;
MuscleAlias::create(['name' => 'Rear thigh', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Iliopsoas')->first()->id;
MuscleAlias::create(['name' => 'Hip flexors', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Infraspinatus')->first()->id;
MuscleAlias::create(['name' => 'Rotatory cuff', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Latissimus Dorsi')->first()->id;
MuscleAlias::create(['name' => 'Lats', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Levator Scapulae')->first()->id;
MuscleAlias::create(['name' => 'Upper shoulders', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Rear neck', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Obliques')->first()->id;
MuscleAlias::create(['name' => 'Side waist', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Side core', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Pectoralis Major Clavicular Head')->first()->id;
MuscleAlias::create(['name' => 'Upper chest', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Upper pecs', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Pectoralis Major Sternal Head')->first()->id;
MuscleAlias::create(['name' => 'Chest', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Lower pecs', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Pectoralis Minor')->first()->id;
MuscleAlias::create(['name' => 'Minor pecs', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Popliteus')->first()->id;
MuscleAlias::create(['name' => 'Knee flexor', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Quadriceps')->first()->id;
MuscleAlias::create(['name' => 'Front thigh', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Quads', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Rectus Abdominis')->first()->id;
MuscleAlias::create(['name' => 'Abs', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Abdominal', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Belly', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Subscapularis')->first()->id;
MuscleAlias::create(['name' => 'Rotator cuff', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Tibialis Anterior')->first()->id;
MuscleAlias::create(['name' => 'Shin', 'muscle_id' => $muscle_id]);
MuscleAlias::create(['name' => 'Tibias', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Trapezius Lower Fibers')->first()->id;
MuscleAlias::create(['name' => 'Lower traps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Trapezius Middle Fibers')->first()->id;
MuscleAlias::create(['name' => 'Traps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Trapezius Upper Fibers')->first()->id;
MuscleAlias::create(['name' => 'Upper Traps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Triceps Brachii')->first()->id;
MuscleAlias::create(['name' => 'Triceps', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Wrist Extensors')->first()->id;
MuscleAlias::create(['name' => 'Lower forearm', 'muscle_id' => $muscle_id]);
$muscle_id = Muscle::where('name', 'Triceps Brachii')->first()->id;
MuscleAlias::create(['name' => 'Inner forearm', 'muscle_id' => $muscle_id]);
}
