/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/1.jpg', 'exercise_id' => 1, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/2.jpg', 'exercise_id' => 1, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/3.jpg', 'exercise_id' => 2, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/4.jpg', 'exercise_id' => 2, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/5.jpg', 'exercise_id' => 3, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/6.jpg', 'exercise_id' => 3, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/7.jpg', 'exercise_id' => 4, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/8.jpg', 'exercise_id' => 4, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/9.jpg', 'exercise_id' => 5, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/10.jpg', 'exercise_id' => 5, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/11.jpg', 'exercise_id' => 6, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/12.jpg', 'exercise_id' => 6, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/13.jpg', 'exercise_id' => 7, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/14.jpg', 'exercise_id' => 7, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/15.jpg', 'exercise_id' => 8, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/16.jpg', 'exercise_id' => 8, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/17.jpg', 'exercise_id' => 9, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/18.jpg', 'exercise_id' => 9, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/19.jpg', 'exercise_id' => 9, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/20.jpg', 'exercise_id' => 9, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/21.jpg', 'exercise_id' => 10, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/22.jpg', 'exercise_id' => 10, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/23.jpg', 'exercise_id' => 11, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
DB::table('exercise_images')->insert(['url' => ExerciseImage::getUrlAppend() . 'exercises/normal/24.jpg', 'exercise_id' => 11, 'created_at' => Carbon::now()->format('Y-m-d H:i:s')]);
}
public static function boot()
{
parent::boot();
// cause a delete of a exercise to cascade to children so they are also deleted
static::deleting(function ($exercise) {
$images = $exercise->images()->get(['url']);
ExerciseImage::deleteImages($images);
ExerciseImage::deleteThumbnail($exercise->thumbnail_url);
});
}
/**
* Responds to requests to GET /exercises/edit/{id}/images/delete/{imageId}
*/
public function getDeleteImages($id, $imageId)
{
$exercise = Exercise::find($id);
$user = Auth::user();
if ($exercise->created_by_id != $user->id || !$user->hasRole('administrator')) {
return view('errors.403');
}
$exercise_image = ExerciseImage::find($imageId);
$exercise_image->delete();
return redirect('exercises/edit/' . $id . '/images');
}
