/** * * @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'); } }