/**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('gym_locations')->delete();
     GymLocation::create(['id' => '1', 'name' => 'L.A. Fitness Carrollton', 'address1' => '4220 Midway Rd', 'address2' => '', 'city' => 'Carrollton', 'state' => 'TX', 'zip' => '75007', 'map' => '', 'website' => '']);
     GymLocation::create(['id' => '2', 'name' => 'L.A. Fitness Plano South @ W Pres GWB Hwy', 'address1' => '3701 W. Pres. George Bush Hwy', 'address2' => '', 'city' => 'Plano', 'state' => 'TX', 'zip' => '75075', 'map' => '', 'website' => '']);
     GymLocation::create(['id' => '3', 'name' => 'L.A. Dallas LBJ @ Webb Chapel', 'address1' => '3029 Forest Lane', 'address2' => '', 'city' => 'Dallas', 'state' => 'TX', 'zip' => '75234', 'map' => '', 'website' => '']);
 }
 /**
  * Show the form for editing the League.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($league_id)
 {
     $league = new League();
     $league = $league->find($league_id);
     $players = $league->getPlayers($league_id)->orderby('last_name')->orderby('first_name')->get();
     //dropdown lists
     $players_list = $this->listPlayers();
     $gyms = GymLocation::orderby('name')->get();
     $gyms = $gyms->lists('name', 'id');
     $formats = new GameFormat();
     $formats = $formats->lists('format', 'format_id');
     //dropdown list
     $directors = Player::orderby('last_name')->orderby('first_name')->get();
     $directors = $directors->lists('last_first_name', 'player_id');
     return view('pages/tools.league.edit', compact('league', 'players', 'players_list', 'gyms', 'formats', 'directors'));
 }