function __construct($name, $value) { parent::__construct($name, (int) $value); $query = "SELECT Team.nefub_id, CONCAT(Team.name, ' (', Competition.name, ')') as name\r\n\t\t\t\t\tFROM Team\r\n\t\t\t\t\tLEFT JOIN Competition ON Team.competition_nefub_id = Competition.nefub_id\r\n\t\t\t\t\tORDER BY Team.name ASC, Competition.name ASC"; $rows = Database::select_rows_by_query($query); $this->addOption('Geen', 0); foreach ($rows as $row) { $this->addOption($row['name'], $row['nefub_id']); } }
function __construct($name, $value) { parent::__construct($name, (int) $value); $query = "SELECT Location.nefub_id, CONCAT(Location.name, ', ', Location.city) as name\r\n\t\t\t\t\tFROM Location\r\n\t\t\t\t\tORDER BY Location.name ASC, Location.city ASC"; $rows = Database::select_rows_by_query($query); $this->addOption('Geen', 0); foreach ($rows as $row) { $this->addOption($row['name'], $row['nefub_id']); } }
public function updateMissingPersons() { $query = "\tSELECT DISTINCT(TeamPerson.person_nefub_id)\n\t\t\t\t\tFROM TeamPerson\n\t\t\t\t\tWHERE TeamPerson.person_nefub_id NOT IN\n\t\t\t\t\t(\t\t\t\t\t\n\t\t\t\t\t\tSELECT DISTINCT(Person.nefub_id)\n\t\t\t\t\t\tFROM Person\n\t\t\t\t\t)"; $missingTeamPersons = Database::select_rows_by_query($query); self::put(count($missingTeamPersons) . ' ontbrekende teamspelers gevonden'); $query = "\tSELECT DISTINCT(GamePerson.person_nefub_id)\n\t\t\t\t\tFROM GamePerson\n\t\t\t\t\tWHERE GamePerson.person_nefub_id NOT IN\n\t\t\t\t\t(\t\t\t\t\t\n\t\t\t\t\t\tSELECT DISTINCT(Person.nefub_id)\n\t\t\t\t\t\tFROM Person\n\t\t\t\t\t)"; $missingGamePersons = Database::select_rows_by_query($query); self::put(count($missingGamePersons) . ' ontbrekende wedstrijdspelers gevonden'); $missingPersons = array_merge($missingTeamPersons, $missingGamePersons); foreach ($missingPersons as $missingPerson) { $nefubId = $missingPerson['person_nefub_id']; if ($this->retrievedPersonNefubIds[$nefubId] !== true) { $this->retrievePerson($nefubId); $this->retrievedPersonNefubIds[$nefubId] = true; } } }
protected function showLocations() { switch ($this->mode) { case 'bewerken': $oLocation = Location::getByNefubId($this->editId); $this->editObject($oLocation, '/bewerken.tpl'); break; default: $query = 'SELECT DISTINCT(`city`) FROM `Location` ORDER BY `city` ASC'; $cityRows = Database::select_rows_by_query($query); $cities = array(); foreach ($cityRows as $cityRow) { $name = $cityRow['city']; if (!is_array($cities[$name])) { $cities[$name] = array(); } $cities[$name] = Location::getAll(array('city' => $name), 'name'); } $this->assign('cities', $cities); $this->template = '/locaties.tpl'; $this->showOutput(); } }
public function hasRanking() { $query = "SELECT\n\t\t\t\t\t(COUNT(DISTINCT(ranking)) = COUNT(team_nefub_id) AND COUNT(team_nefub_id) !=0 ) AS hasRanking \n\t\t\t\t\tFROM PouleTeam\n\t\t\t\t\tWHERE poule_nefub_id = '" . $this->nefub_id . "'"; $rows = Database::select_rows_by_query($query); return (bool) $rows[0]['hasRanking']; }
/** * * @return array */ public static function getPlannedGamesSorted(Season $oSeason, $limitDays = null) { $plannedGames = array(); $query = "SELECT DISTINCT(Game.date)\n\t\t\t\t\tFROM Game\n\t\t\t\t\tWHERE Game.date >= CURDATE()\n\t\t\t\t\tAND Game.date IS NOT NULL\n\t\t\t\t\tAND Game.season_nefub_id = '" . $oSeason->nefub_id . "'"; if ($limitDays) { $query .= " LIMIT " . $limitDays; } // $dateRows = Database::select_rows_by_query($query); if ($dateRows) { $dates = array(); foreach ($dateRows as $dateRow) { $dates[] = "'" . $dateRow['date'] . "'"; } $dates = implode(', ', $dates); $query = "SELECT Game.id\n\t\t\t\t\t\tFROM Game\n\t\t\t\t\t\tWHERE Game.date IN\n\t\t\t\t\t\t(" . $dates . ")\n\t\t\t\t\t\tAND Game.season_nefub_id = '" . $oSeason->nefub_id . "'\n\t\t\t\t\t\tGROUP BY\n\t\t\t\t\t\t\tGame.location_nefub_id,\n\t\t\t\t\t\t\tGame.competition_nefub_id\n\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\tGame.date ASC,\t\t\t\t\t\t\n\t\t\t\t\t\t\tGame.location_nefub_id ASC,\n\t\t\t\t\t\t\tGame.competition_nefub_id ASC\n\t\t\t\t\t\t"; $plannedGames = self::getAllFromQuery($query); } return $plannedGames; }