/**
*
* @return array
*/
public function getPoules()
{
return Poule::getAll(array('competition_nefub_id' => $this->nefub_id), 'sorting');
}
public function updateTeams()
{
$aPoules = Poule::getAll(array('season_nefub_id' => Season::getInstance()->nefub_id), 'competition_nefub_id');
foreach ($aPoules as $oPoule) {
$aPouleTeams = $oPoule->getPouleTeams();
foreach ($aPouleTeams as $oPouleTeam) {
$team = $this->getAPITeamDetails($oPouleTeam->team_nefub_id);
$oTeam = Team::getByNefubId($team->ID);
if (!$oTeam) {
$oTeam = new Team();
$oTeam->nefub_id = $team->ID;
$oTeam->name = $team->Name;
$oTeam->competition_nefub_id = $oPoule->competition_nefub_id;
$oTeam->season_nefub_id = $oPoule->getCompetition()->season_nefub_id;
$oTeam->club_nefub_id = $team->Club->ID;
$oTeam->color_shirt = $team->Dress->Shirt;
$oTeam->color_shorts = $team->Dress->Short;
self::put('Team ' . $team->Name . ' toegevoegd');
$oTeam->save();
}
if (isset($team->Players) && is_array($team->Players)) {
foreach ($team->Players as $teamPlayer) {
$this->convertTeamPerson($teamPlayer, $oTeam);
}
} else {
self::put('Geen spelers gevonden voor ' . $team->Name);
}
$this->retrieveClub($team->Club);
$this->retrieveTeamGames($team, 'schedule');
$query = "SELECT COUNT(Game.nefub_id) as countGames\n\t\t\t\t\t\t\tFROM Game\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t(team1_nefub_id = '" . $team->ID . "'\n\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\tteam2_nefub_id = '" . $team->ID . "')\n\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tGame.date <= CURDATE()";
$rows = Database::select_rows_by_query($query);
$playedGames = $rows[0]['countGames'];
$bRetrieveResults = false;
if ($playedGames) {
// Als er geen oude wedstrijden in de DB staan, vermoedelijk zijn ze dan niet eerder opgehaald.
$query .= " AND Game.actions_retrieved = 0";
$rows = Database::select_rows_by_query($query);
$gamesToRetrieve = $rows[0]['countGames'];
$bRetrieveResults = $gamesToRetrieve != 0;
}
if ($bRetrieveResults) {
$this->retrieveTeamGames($team, 'results');
} else {
self::put('Resultaten voor ' . $oTeam->name . ' hoeven niet vernieuwd te worden');
}
$oTeam->save();
$this->retrievedTeamNefubIds[$oPouleTeam->team_nefub_id] = true;
}
}
}
protected function showPoules()
{
switch ($this->mode) {
case 'bewerken':
$oPoule = Poule::getByNefubId($this->editId);
$this->editObject($oPoule);
break;
default:
$this->assign('aPoules', Poule::getAll(array('season_nefub_id' => Season::getInstance()->nefub_id), 'name'));
$this->showCompetitionDependentView('/poules.tpl');
}
}
