/** * Run the database seeds. * * @return void */ public function run() { DB::table('seasons')->delete(); Season::create(['country' => 'England', 'league' => 'Barclays Premier League', 'year' => 2014, 'number_of_teams' => 20, 'number_of_teams_to_cl' => 4, 'number_of_teams_to_el' => 2, 'number_of_teams_to_ld' => 3]); Season::create(['country' => 'Germany', 'league' => 'Bundesliga', 'year' => 2015, 'number_of_teams' => 18, 'number_of_teams_to_cl' => 3, 'number_of_teams_to_el' => 3, 'number_of_teams_to_ld' => 3]); Season::create(['country' => 'Russia', 'league' => 'Premier League', 'year' => 2015, 'number_of_teams' => 16, 'number_of_teams_to_cl' => 1, 'number_of_teams_to_el' => 3, 'number_of_teams_to_ld' => 2]); }
/** * Store a newly created resource in storage. * * @param Request $request * * @return mixed */ public function store(Request $request) { $this->validate($request, ['season' => 'required|unique:seasons']); Season::create($request->all()); \Flash::success('Season added!'); return redirect('admin/data-management/seasons'); }
/** * Store a newly created season. * * @param Request $request * @return Response */ public function store(Request $request) { $season = Season::create(['country' => $request->input('country'), 'league' => $request->input('league'), 'year' => $request->input('year'), 'number_of_teams' => $request->input('number_of_teams'), 'number_of_teams_to_cl' => $request->input('number_of_teams_to_cl'), 'number_of_teams_to_el' => $request->input('number_of_teams_to_el'), 'number_of_teams_to_ld' => $request->input('number_of_teams_to_ld')]); if ($request->has('link')) { // Example from football-data.org // England - Barclays Premier League - 2015 // http://api.football-data.org/alpha/soccerseasons/398 $link = $request->input('link'); // Read data from link // $tmpTeamsFile = json_decode(file_get_contents($link."/teams")); // $tmpFixturesFile = json_decode(file_get_contents($link."/fixtures")); $base = base_path(); $tmpTeamsFile = json_decode(file_get_contents($base . "/public/files/teams.json")); $tmpFixturesFile = json_decode(file_get_contents($base . "/public/files/fixtures.json")); $tmpTeams = $tmpTeamsFile->teams; $tmpFixtures = $tmpFixturesFile->fixtures; // Create teams foreach ($tmpTeams as $tmpTeam) { $team = Team::create(['name' => $tmpTeam->name, 'short_name' => $tmpTeam->code, 'season_id' => $season->id]); // Array of all teams from season $teams[] = $team; } // Create fixtures foreach ($tmpFixtures as $tmpFixture) { $home_team_name = $tmpFixture->homeTeamName; $away_team_name = $tmpFixture->awayTeamName; $home_team_index = $this->searchTeamIdByName($home_team_name, $teams); $away_team_index = $this->searchTeamIdByName($away_team_name, $teams); Fixture::create(['season_id' => $season->id, 'matchday' => $tmpFixture->matchday, 'home_team_id' => $teams[$home_team_index]->id, 'away_team_id' => $teams[$away_team_index]->id]); } } else { // Create teams for ($i = 1; $i <= $season->number_of_teams; $i++) { $team = Team::create(['name' => 'Team ' . sprintf("%02d", $i), 'short_name' => 'TN' . sprintf("%02d", $i), 'season_id' => $season->id]); $teams[] = $team; } // Create matchdays $tour = 1; $fixtures_in_tour = $season->number_of_teams / 2; for ($i = 1; $i <= $season->number_of_teams * ($season->number_of_teams - 1); $i++) { Fixture::create(['season_id' => $season->id, 'matchday' => $tour]); $tour = $i % $fixtures_in_tour == 0 ? ++$tour : $tour; } } // Create base league tables (tour #0) foreach ($teams as $team) { LeagueTable::create(['season_id' => $season->id, 'team_id' => $team->id]); } return response()->json(['success' => true]); }