function OnLoadPageData()
{
/* @var $competition Competition */
# check parameter
if (isset($_GET['competition']) and is_numeric($_GET['competition'])) {
$comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$comp_manager->ReadById(array($_GET['competition']), null);
$this->competition = $comp_manager->GetFirst();
$this->season = $this->competition->GetWorkingSeason();
unset($comp_manager);
} else {
$this->Redirect("/competitions/");
}
# must have found a competition
if (!$this->competition instanceof Competition) {
$this->Redirect("/competitions/");
}
# Get seasons in the competition
$a_comp_ids = array($this->competition->GetId());
$o_season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$o_season_manager->ReadByCompetitionId($a_comp_ids);
$a_seasons = $o_season_manager->GetItems();
$this->competition->SetSeasons($a_seasons);
unset($o_season_manager);
# Get stats highlights
$this->statistics["querystring"] = "?competition=" . $this->competition->GetId();
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterByCompetition(array($this->competition->GetId()));
require_once "_summary-data-query.php";
unset($statistics_manager);
}
public function OnLoadPageData()
{
require_once 'stoolball/competition-manager.class.php';
$manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
if ($this->season_id) {
$manager->ReadById(null, array($this->season_id));
} else {
$manager->ReadById(array($this->competition_id));
}
$this->competition = $manager->GetFirst();
$this->season = $this->competition->GetWorkingSeason();
unset($manager);
# If the competition was requested, redirect to the current season
if ($this->competition_id) {
http_response_code(303);
header("Location: " . $this->season->GetMapUrl());
return;
}
$this->has_map = count($this->season->GetTeams());
# Get other seasons
require_once 'stoolball/season-manager.class.php';
$a_comp_ids = array($this->competition->GetId());
$o_season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$o_season_manager->ReadByCompetitionId($a_comp_ids);
$a_other_seasons = $o_season_manager->GetItems();
$this->competition->SetSeasons(array());
foreach ($a_other_seasons as $season) {
if ($season->GetId() == $this->season->GetId()) {
$this->competition->AddSeason($this->season, true);
} else {
$this->competition->AddSeason($season, false);
}
}
}
function OnLoadPageData()
{
/* @var $o_competition Competition */
# check parameter
if (!isset($_GET['season']) or !is_numeric($_GET['season'])) {
http_response_code(400);
exit;
}
if (isset($_GET['season']) and is_numeric($_GET['season'])) {
$comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$comp_manager->ReadById(null, array($_GET['season']));
$this->competition = $comp_manager->GetFirst();
unset($comp_manager);
}
# must have found a competition
if (!$this->competition instanceof Competition) {
http_response_code(404);
exit;
}
$this->season = $this->competition->GetWorkingSeason();
if (is_object($this->season)) {
# get matches
$o_match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$o_match_manager->ReadBySeasonId(array($this->season->GetId()));
$a_matches = $o_match_manager->GetItems();
$this->season->SetMatches($a_matches);
# Get other seasons
$a_comp_ids = array($this->competition->GetId());
$o_season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$o_season_manager->ReadByCompetitionId($a_comp_ids);
$a_other_seasons = $o_season_manager->GetItems();
$this->competition->SetSeasons(array());
foreach ($a_other_seasons as $season) {
if ($season->GetId() == $this->season->GetId()) {
$this->competition->AddSeason($this->season, true);
} else {
$this->competition->AddSeason($season, false);
}
}
unset($o_season_manager);
} else {
# Must have a season
http_response_code(404);
exit;
}
}
function OnLoadPageData()
{
# get id of season
$i_id = $this->season_manager->GetItemId($this->season);
# read season data when first asked to edit a season
if ($i_id and !$this->IsPostback()) {
$this->season_manager->ReadById(array($i_id));
$this->season = $this->season_manager->GetFirst();
}
# get all teams
$this->team_manager->SetGroupInactiveLast(false);
$this->team_manager->ReadAll();
$this->edit->SetTeams($this->team_manager->GetItems());
# tidy up
unset($this->season_manager);
unset($this->team_manager);
}
function OnLoadPageData()
{
# get item to be deleted
if (!is_object($this->data_object)) {
$id = $this->manager->GetItemId($this->data_object);
$this->manager->ReadById(array($id));
$this->data_object = $this->manager->GetFirst();
# How many seasons in this competition?
if (is_object($this->data_object) and $this->data_object->GetCompetition() instanceof Competition and $this->data_object->GetCompetition()->GetId()) {
$this->manager->Clear();
$this->manager->ReadByCompetitionId(array($this->data_object->GetCompetition()->GetId()));
$this->seasons_in_competition = $this->manager->GetCount();
}
}
# tidy up
unset($this->manager);
}
/**
* If the season parameter is in the query string apply season filter
* @param SiteSettings $settings
* @param MySqlConnection $connection
* @param StatisticsManager $statistics_manager
*/
public static function ApplySeasonFilter(SiteSettings $settings, MySqlConnection $connection, StatisticsManager $statistics_manager)
{
$filter = "";
if (isset($_GET['season']) and is_numeric($_GET['season'])) {
require_once 'stoolball/season-manager.class.php';
$season_manager = new SeasonManager($settings, $connection);
$season_manager->ReadById(array($_GET['season']));
$season = $season_manager->GetFirst();
unset($season_manager);
if (!is_null($season)) {
$statistics_manager->FilterBySeason(array($season->GetId()));
$filter = "in the " . $season->GetCompetitionName() . " ";
}
}
return $filter;
}
function OnLoadPageData()
{
/* @var $match_manager MatchManager */
/* @var $editor TournamentEditControl */
# get id of Match
$i_id = $this->match_manager->GetItemId();
if (!$i_id) {
return;
}
# no need to read if redisplaying invalid form
if ($this->IsValid()) {
$this->match_manager->ReadByMatchId(array($i_id));
$this->tournament = $this->match_manager->GetFirst();
if ($this->tournament instanceof Match) {
$this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->tournament->GetAddedBy()->GetId();
$this->b_is_tournament = $this->tournament->GetMatchType() == MatchType::TOURNAMENT;
} else {
return;
}
}
if ($this->b_user_is_match_admin or $this->b_user_is_match_owner) {
# Get all seasons
# Don't filter by match type at this point because we want to know what other types of match the seasons support.
# If it's tournaments only, they'll be treated differently.
require_once 'stoolball/season-manager.class.php';
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$season_dates = Season::SeasonDates($this->tournament->GetStartTime());
$season_manager->FilterByDateStart($season_dates[0]);
$season_manager->FilterByDateEnd($season_dates[1]);
$season_manager->ReadSeasonSummaries(array($this->tournament->GetPlayerType()));
$this->editor->Seasons()->SetItems($season_manager->GetItems());
unset($season_manager);
}
}
/**
* Saves the seasons a match is in
*
* @param Match $match
* @param bool $b_is_new_match
*/
public function SaveSeasons(Match $match, $b_is_new_match)
{
$s_match = $this->GetSettings()->GetTable('Match');
$s_season_match = $this->GetSettings()->GetTable('SeasonMatch');
$season_table = $this->GetSettings()->GetTable('Season');
$comp_table = $this->GetSettings()->GetTable('Competition');
# Get ids of the tournament matches as well as this match, because they must necessarily be in the same season as their tournament
# so we'll update the tournament matches whenever we update the season
$a_matches_in_seasons = array();
# Check GetId() rather than $b_is_new_match because match is being added as a multi-part process. Even though it's
# new, by this point in the process it has an id that we need to use.
if ($match->GetId()) {
$a_matches_in_seasons[] = $match->GetId();
}
if (!$b_is_new_match and $match->GetMatchType() == MatchType::TOURNAMENT) {
$s_sql = "SELECT match_id FROM {$s_match} WHERE tournament_match_id = " . Sql::ProtectNumeric($match->GetId());
$o_result = $this->GetDataConnection()->query($s_sql);
while ($row = $o_result->fetch()) {
$a_matches_in_seasons[] = $row->match_id;
}
$o_result->closeCursor();
}
# All changes to master data from here are logged, because this method can be called from the public interface
# Clear out seasons for this match and its tournament matches, ready to re-insert
if (count($a_matches_in_seasons)) {
$sql = "DELETE FROM {$s_season_match} WHERE match_id IN (" . join(', ', $a_matches_in_seasons) . ')';
$this->LoggedQuery($sql);
}
# Add seasons again with new data
foreach ($match->Seasons() as $season) {
/* @var $season Season */
foreach ($a_matches_in_seasons as $i_match_id) {
$sql = "INSERT INTO {$s_season_match} (season_id, match_id) VALUES (" . Sql::ProtectNumeric($season->GetId()) . ', ' . Sql::ProtectNumeric($i_match_id) . ') ';
$this->LoggedQuery($sql);
}
# If participation in this match implies the team is part of the whole season (ie not practice or tournament or friendly),
# make sure the team is in the season
if ($match->GetMatchType() == MatchType::CUP or $match->GetMatchType() == MatchType::LEAGUE) {
require_once 'stoolball/season-manager.class.php';
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
if ($match->GetHomeTeamId()) {
$season_manager->EnsureTeamIsInSeason($match->GetHomeTeamId(), $season->GetId());
}
$a_away = $match->GetAwayTeams();
if (is_array($a_away) and count($a_away)) {
foreach ($a_away as $o_away_team) {
if (is_null($o_away_team)) {
continue;
}
$season_manager->EnsureTeamIsInSeason($o_away_team->GetId(), $season->GetId());
}
}
unset($season_manager);
}
}
# The number of players in the match is derived from the competitions it's in. It's never entered directly even
# by admins or displayed. Done to save extra queries when rendering scorecard editing interfaces. If people want to
# display the number of players per match they can enter the results with the players' names.
# Get the max number of players who may play based on the competitions the match is in, so long as this isn't a tournament or friendly.
# For a tournament we'll ask the user instead, so just ignore this code and keep the existing value. Even in a season different
# tournaments may have different rules, so really can't automate. Friendlies are just as flexible so, again, can't predict.
if ($match->GetId() and $match->GetMatchType() != MatchType::TOURNAMENT and $match->GetMatchType() != MatchType::TOURNAMENT_MATCH and $match->GetMatchType() != MatchType::FRIENDLY) {
$season_ids = array();
foreach ($match->Seasons() as $season) {
$season_ids[] = $season->GetId();
}
if (count($season_ids)) {
$s_sql = "SELECT MAX({$comp_table}.players_per_team) AS players_per_team, MAX({$comp_table}.overs) AS overs\r\n\t\t\t\tFROM {$season_table} INNER JOIN {$comp_table} ON {$season_table}.competition_id = {$comp_table}.competition_id\r\n\t\t\t\tWHERE {$season_table}.season_id IN (" . implode(',', $season_ids) . ")";
$result = $this->GetDataConnection()->query($s_sql);
if (!$this->GetDataConnection()->isError()) {
$row = $result->fetch();
$match->SetMaximumPlayersPerTeam($row->players_per_team);
$match->SetOvers($row->overs);
}
$result->closeCursor();
}
# Update the match. Using the GetMaximumPlayersPerTeam property because it will give us the existing value
# (possibly the default value if the code above didn't run because there were no seasons).
$sql = "UPDATE {$s_match} SET\r\n\t\t\t\t\t\tplayers_per_team = " . Sql::ProtectNumeric($match->GetMaximumPlayersPerTeam()) . ",\r\n\t\t\t\t\t\tovers = " . Sql::ProtectNumeric($match->GetOvers()) . "\r\n\t\t\t\t\t\tWHERE match_id = " . Sql::ProtectNumeric($match->GetId());
$this->LoggedQuery($sql);
}
# This season is mentioned in search results for a match, so request an update,
# and note for auditing that the match has been changed
$sql = "UPDATE nsa_match SET \r\n\t update_search = 1, \r\n\t date_changed = " . gmdate("U") . ", \r\n modified_by_id = " . Sql::ProtectNumeric(AuthenticationManager::GetUser()->GetId()) . "\r\n\t WHERE match_id = " . Sql::ProtectNumeric($match->GetId(), false);
$this->LoggedQuery($sql);
# Match data has changed so notify moderator
$this->QueueForNotification($match->GetId(), $b_is_new_match);
}
function OnLoadPageData()
{
/* @var $o_competition Competition */
# check parameter
if (!isset($_GET['item']) or !is_numeric($_GET['item'])) {
http_response_code(400);
exit;
}
# new data managers
$o_comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
# get competition
$latest = (isset($_GET['latest']) and $_GET['latest'] == '1');
if ($latest) {
$o_comp_manager->ReadById(array($_GET['item']), null);
} else {
$o_comp_manager->ReadById(null, array($_GET['item']));
}
$this->competition = $o_comp_manager->GetFirst();
$this->season = $this->competition->GetWorkingSeason();
# must have found a competition
if (!$this->competition instanceof Competition or !$this->season instanceof Season) {
http_response_code(404);
exit;
}
# If the competition was requested, redirect to the current season
if ($latest) {
http_response_code(303);
header("Location: " . $this->season->GetNavigateUrl());
return;
}
# Update search engine. Only do this for the latest season as then we have the right teams already.
if ($this->competition->GetSearchUpdateRequired() and $latest) {
$this->SearchIndexer()->DeleteFromIndexById("competition" . $this->competition->GetId());
require_once "search/competition-search-adapter.class.php";
$adapter = new CompetitionSearchAdapter($this->competition);
$this->SearchIndexer()->Index($adapter->GetSearchableItem());
$this->SearchIndexer()->CommitChanges();
$o_comp_manager->SearchUpdated($this->competition->GetId());
}
unset($o_comp_manager);
# get matches
$o_match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$o_match_manager->ReadBySeasonId(array($this->season->GetId()));
$a_matches = $o_match_manager->GetItems();
$this->season->SetMatches($a_matches);
# While we're here, check if there are any outstanding notifications to be sent
$o_match_manager->NotifyMatchModerator();
unset($o_match_manager);
# Get stats highlights
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterBySeason(array($this->season->GetId()));
$statistics_manager->FilterMaxResults(1);
$this->best_batting = $statistics_manager->ReadBestBattingPerformance();
$this->best_bowling = $statistics_manager->ReadBestBowlingPerformance();
$this->most_runs = $statistics_manager->ReadBestPlayerAggregate("runs_scored");
$this->most_wickets = $statistics_manager->ReadBestPlayerAggregate("wickets");
$this->most_catches = $statistics_manager->ReadBestPlayerAggregate("catches");
# See what stats we've got available
$best_batting_count = count($this->best_batting);
$best_bowling_count = count($this->best_bowling);
$best_batters = count($this->most_runs);
$best_bowlers = count($this->most_wickets);
$best_catchers = count($this->most_catches);
$this->has_player_stats = ($best_batting_count or $best_batters or $best_bowling_count or $best_bowlers or $best_catchers);
if (!$this->has_player_stats) {
$player_of_match = $statistics_manager->ReadBestPlayerAggregate("player_of_match");
$this->has_player_stats = (bool) count($player_of_match);
}
unset($statistics_manager);
# Get other seasons
$a_comp_ids = array($this->competition->GetId());
$o_season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$o_season_manager->ReadByCompetitionId($a_comp_ids);
$a_other_seasons = $o_season_manager->GetItems();
$this->competition->SetSeasons(array());
foreach ($a_other_seasons as $season) {
if ($season->GetId() == $this->season->GetId()) {
$this->competition->AddSeason($this->season, true);
} else {
$this->competition->AddSeason($season, false);
}
}
unset($o_season_manager);
}
function OnLoadPageData()
{
/* @var $o_last_match Match */
/* @var $season Season */
/* @var $team Team */
# First best guess at where user came from is the page field posted back,
# second best is tournaments page. Either can be tampered with, so there will be
# a check later before they're used for redirection. If there's a context
# season or team its URL will be read from the db and overwrite this later.
if (isset($_POST['page'])) {
$this->destination_url_if_cancelled = $_POST['page'];
} else {
$this->destination_url_if_cancelled = "/tournaments";
}
# new data manager
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->FilterByMatchType(array(MatchType::TOURNAMENT));
# Check whether cancel was clicked
if ($this->IsPostback() and $this->editor->CancelClicked()) {
# new tournament, nothing saved yet, so just send user back where they came from
$this->Cancel();
}
# Save match
if ($this->IsPostback() and $this->IsValid()) {
# Get posted match
$this->tournament = $this->editor->GetDataObject();
# Save match
$match_manager->SaveFixture($this->tournament);
if (count($this->tournament->GetAwayTeams())) {
$match_manager->SaveTeams($this->tournament);
}
if ($this->season instanceof Season) {
$this->tournament->Seasons()->Add($this->season);
$match_manager->SaveSeasons($this->tournament, true);
}
http_response_code(303);
$this->Redirect($this->tournament->AddTournamentTeamsUrl());
}
if (isset($this->season)) {
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$season_manager->ReadById(array($this->season->GetId()));
$this->season = $season_manager->GetFirst();
$this->editor->SetContextSeason($this->season);
$this->destination_url_if_cancelled = $this->season->GetNavigateUrl();
unset($season_manager);
# If we're adding a match to a season, get last game in season for its date
$match_manager->ReadLastInSeason($this->season->GetId());
}
if (isset($this->team)) {
# Get more information about the team itself
require_once 'stoolball/team-manager.class.php';
$team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
$team_manager->ReadById(array($this->team->GetId()));
$this->team = $team_manager->GetFirst();
$this->editor->SetContextTeam($this->team);
$this->destination_url_if_cancelled = $this->team->GetNavigateUrl();
# Get the last game already scheduled for the team to use its date
$match_manager->ReadLastForTeam($this->team->GetId());
# Read teams played in the last year in order to get their grounds, which will be put at the top of the select list
$team_manager->ReadRecentOpponents(array($this->team->GetId()), 12);
$this->editor->ProbableTeams()->SetItems($team_manager->GetItems());
unset($team_manager);
}
# Use the date of the most recent tournament if it was this year, otherwise just use the default of today
$o_last_match = $match_manager->GetFirst();
if (is_object($o_last_match) and gmdate('Y', $o_last_match->GetStartTime()) == gmdate('Y')) {
if ($o_last_match->GetIsStartTimeKnown()) {
# If the last match has a time, use it
$this->editor->SetDefaultTime($o_last_match->GetStartTime());
} else {
# If the last match has no time, use 11am BST
$this->editor->SetDefaultTime(gmmktime(10, 0, 0, gmdate('m', $o_last_match->GetStartTime()), gmdate('d', $o_last_match->GetStartTime()), gmdate('Y', $o_last_match->GetStartTime())));
}
}
unset($match_manager);
# Get grounds
$o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
$o_ground_manager->ReadAll();
$a_grounds = $o_ground_manager->GetItems();
$this->editor->Grounds()->SetItems($a_grounds);
unset($o_ground_manager);
}
function OnLoadPageData()
{
/* @var Team $team */
# check parameter
if (!isset($_GET['item']) or !is_numeric($_GET['item'])) {
$this->Redirect();
}
# new data manager
$team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# get teams
$team_manager->FilterByTeamType(array());
$team_manager->ReadById(array($_GET['item']));
$this->team = $team_manager->GetFirst();
# must have found a team
if (!$this->team instanceof Team) {
$this->Redirect('/teams/');
}
# Update search engine
if ($this->team->GetSearchUpdateRequired()) {
require_once "search/team-search-adapter.class.php";
$this->SearchIndexer()->DeleteFromIndexById("team" . $this->team->GetId());
$adapter = new TeamSearchAdapter($this->team);
$this->SearchIndexer()->Index($adapter->GetSearchableItem());
$this->SearchIndexer()->CommitChanges();
$team_manager->SearchUpdated($this->team->GetId());
}
unset($team_manager);
$this->is_one_time_team = $this->team->GetTeamType() == Team::ONCE;
# get matches and match stats
if (!$this->is_one_time_team) {
$a_season_dates = Season::SeasonDates();
$this->season_key = date('Y', $a_season_dates[0]);
if ($this->season_key != date('Y', $a_season_dates[1])) {
$this->season_key .= "/" . date('y', $a_season_dates[1]);
}
$match_manager->FilterByDateStart($a_season_dates[0]);
}
$match_manager->FilterByTeam(array($this->team->GetId()));
$match_manager->ReadMatchSummaries();
$this->a_matches = $match_manager->GetItems();
unset($match_manager);
$club = $this->team->GetClub();
$this->has_facebook_group_url = ($club->GetFacebookUrl() and strpos($club->GetFacebookUrl(), '/groups/') !== false);
$this->has_facebook_page_url = ($club->GetFacebookUrl() and !$this->has_facebook_group_url);
if (!$this->has_facebook_page_url) {
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterByTeam(array($this->team->GetId()));
$statistics_manager->FilterMaxResults(1);
$this->best_batting = $statistics_manager->ReadBestBattingPerformance();
$this->best_bowling = $statistics_manager->ReadBestBowlingPerformance();
$this->most_runs = $statistics_manager->ReadBestPlayerAggregate("runs_scored");
$this->most_wickets = $statistics_manager->ReadBestPlayerAggregate("wickets");
$this->most_catches = $statistics_manager->ReadBestPlayerAggregate("catches");
# See what stats we've got available
$best_batting_count = count($this->best_batting);
$best_bowling_count = count($this->best_bowling);
$best_batters = count($this->most_runs);
$best_bowlers = count($this->most_wickets);
$best_catchers = count($this->most_catches);
$this->has_player_stats = ($best_batting_count or $best_batters or $best_bowling_count or $best_bowlers or $best_catchers);
if (!$this->has_player_stats) {
$player_of_match = $statistics_manager->ReadBestPlayerAggregate("player_of_match");
$this->has_player_stats = (bool) count($player_of_match);
}
unset($statistics_manager);
}
# Get whether to show add league/cup links
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$season_manager->ReadCurrentSeasonsByTeamId(array($this->team->GetId()), array(MatchType::CUP, MatchType::LEAGUE));
$this->seasons = $season_manager->GetItems();
unset($season_manager);
}
function OnLoadPageData()
{
/* @var $o_last_match Match */
/* @var $season Season */
/* @var $team Team */
# new data manager
$o_match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# Collect season to add this match to, starting with the URL
# get season and teams (was at this stage because editor needed teams to build its
# posted data object, but that's no longer the case so probably could be later if needed)
if (isset($this->i_season_id)) {
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$season_manager->ReadById(array($this->i_season_id));
$this->season = $season_manager->GetFirst();
unset($season_manager);
$this->edit->Seasons()->Add($this->season);
# If there are at least 2 teams in the season, show only those teams, otherwise show all teams of the relevant player type
if (count($this->season->GetTeams()) > 1) {
$this->edit->SetTeams(array($this->season->GetTeams()));
} else {
require_once 'stoolball/team-manager.class.php';
$team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
$team_manager->FilterByPlayerType(array($this->season->GetCompetition()->GetPlayerType()));
$team_manager->ReadTeamSummaries();
$this->edit->SetTeams(array($team_manager->GetItems()));
unset($team_manager);
}
}
# Not elseif, because when you've added a match there's a season, but we still need this to run to populate
# the choices for the next match to be added
if ($this->team instanceof Team) {
# Otherwise it should be a team.
# Get more information about the team itself
require_once 'stoolball/team-manager.class.php';
$team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
$team_manager->ReadById(array($this->team->GetId()));
$this->team = $team_manager->GetFirst();
if (!is_null($this->team)) {
$this->edit->SetContextTeam($this->team);
$season_ids = array();
$team_groups = array();
$a_exclude_team_ids = array();
$team_manager->FilterByActive(true);
# Add the home team first
$team_groups[] = array($this->team);
$a_exclude_team_ids[] = $this->team->GetId();
# Get the seasons this team is in...
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
if ($this->i_match_type == MatchType::FRIENDLY) {
# For a friendly, any group of teams they play with is fine
$season_manager->ReadCurrentSeasonsByTeamId(array($this->team->GetId()));
} else {
# For anything else, get the seasons *for this type of match*
$season_manager->ReadCurrentSeasonsByTeamId(array($this->team->GetId()), array($this->i_match_type));
}
$seasons = $season_manager->GetItems();
unset($season_manager);
$this->edit->Seasons()->Clear();
# on postback, the season just added is already there, so clear to prevent a duplicate
foreach ($seasons as $season) {
$this->edit->Seasons()->Add($season);
$season_ids[] = $season->GetId();
}
#... and their opponent teams in those seasons
if (count($season_ids)) {
$team_manager->FilterExceptTeams($a_exclude_team_ids);
$team_manager->ReadBySeasonId($season_ids);
$season_teams = $team_manager->GetItems();
if (count($season_teams)) {
$team_groups['This season\'s teams'] = $season_teams;
}
foreach ($season_teams as $team) {
$a_exclude_team_ids[] = $team->GetId();
}
}
# ...and if this is a friendly it could be any other team
if ($this->i_match_type == MatchType::FRIENDLY) {
# get any other teams they played in the last 2 years, and combine with existing results
$team_manager->FilterExceptTeams($a_exclude_team_ids);
$team_manager->ReadRecentOpponents(array($this->team->GetId()), 24);
$recent_opponents = $team_manager->GetItems();
if (count($recent_opponents)) {
$team_groups['Recent opponents'] = $recent_opponents;
}
foreach ($recent_opponents as $team) {
$a_exclude_team_ids[] = $team->GetId();
}
# get any other teams they might play, and combine with existing results
$team_manager->FilterExceptTeams($a_exclude_team_ids);
$team_manager->ReadAll();
$team_groups['Other teams'] = $team_manager->GetItems();
}
# What if there are still no opponents to choose from? In that case select all teams.
if (count($team_groups) == 1) {
$team_manager->FilterExceptTeams($a_exclude_team_ids);
$team_manager->ReadAll();
$team_groups[] = $team_manager->GetItems();
}
# Offer those teams to select from
if ($total_groups = count($team_groups)) {
# If only two groups (home team + 1 group), don't group teams. Remove the only key from the array.
if ($total_groups == 2) {
$keys = array_keys($team_groups);
$team_groups = array($team_groups[$keys[0]], $team_groups[$keys[1]]);
}
$this->edit->SetTeams($team_groups);
}
}
unset($team_manager);
}
# Save match
if ($this->IsPostback() and $this->IsValid()) {
# Get posted match
$this->match = $this->edit->GetDataObject();
if (!$this->IsRefresh()) {
# Save match
$o_match_manager->SaveFixture($this->match);
$o_match_manager->SaveSeasons($this->match, true);
$o_match_manager->NotifyMatchModerator($this->match->GetId());
# Update 'next 5 matches'
$o_match_manager->ReadNext();
$this->a_next_matches = $o_match_manager->GetItems();
}
# Reset control for new match
$this->edit->SetDataObject(new Match($this->GetSettings()));
}
$o_match_manager->FilterByMatchType(array($this->i_match_type));
if (isset($this->i_season_id)) {
# If we're adding a match to a season, get last game in season for its date
$o_match_manager->ReadLastInSeason($this->season->GetId());
} else {
if ($this->team instanceof Team) {
# Get the last game already scheduled for the team to use its date
$o_match_manager->ReadLastForTeam($this->team->GetId());
}
}
$o_last_match = $o_match_manager->GetFirst();
if (is_object($o_last_match)) {
$current_season = Season::SeasonDates();
if (gmdate('Y', $o_last_match->GetStartTime()) < gmdate('Y', $current_season[0])) {
# If the last match this team played was last season, use the time but not the date
$this->edit->SetDefaultTime(gmmktime(gmdate('H', $o_last_match->GetStartTime()), gmdate('i', $o_last_match->GetStartTime()), 0, gmdate('m'), gmdate('d'), gmdate('Y')));
} else {
# If the last match was this season and has a time, use it
if ($o_last_match->GetIsStartTimeKnown()) {
$this->edit->SetDefaultTime($o_last_match->GetStartTime());
} else {
# If the last match has no time, use 6.30pm BST
$this->edit->SetDefaultTime(gmmktime(17, 30, 0, gmdate('m', $o_last_match->GetStartTime()), gmdate('d', $o_last_match->GetStartTime()), gmdate('Y', $o_last_match->GetStartTime())));
}
}
}
unset($o_match_manager);
# Get grounds
$o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
$o_ground_manager->ReadAll();
$a_grounds = $o_ground_manager->GetItems();
$this->edit->SetGrounds($a_grounds);
unset($o_ground_manager);
}
/**
* @access public
* @return void
* @param int[] $a_ids
* @desc Delete from the db the Competitions matching the supplied ids
*/
function Delete($a_ids)
{
# check paramter
if (!is_array($a_ids)) {
die('No Competitions to delete');
}
# build query
$s_comp = $this->o_settings->GetTable('Competition');
$s_season = $this->o_settings->GetTable('Season');
$s_ids = join(', ', $a_ids);
# get the seasons and use SeasonManager to deal with them
$season_ids = array();
$s_sql = 'SELECT season_id FROM ' . $s_season . ' WHERE competition_id IN (' . $s_ids . ') ';
$result = $this->GetDataConnection()->query($s_sql);
while ($row = $result->fetch()) {
$season_ids[] = $row->season_id;
}
$result->closeCursor();
require_once 'stoolball/season-manager.class.php';
$season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
$season_manager->Delete($season_ids);
unset($season_manager);
# delete from short URL cache
require_once 'http/short-url-manager.class.php';
$o_url_manager = new ShortUrlManager($this->GetSettings(), $this->GetDataConnection());
$s_sql = "SELECT short_url FROM {$s_comp} WHERE competition_id IN ({$s_ids})";
$result = $this->GetDataConnection()->query($s_sql);
while ($row = $result->fetch()) {
$o_url_manager->Delete($row->short_url);
}
$result->closeCursor();
unset($o_url_manager);
# delete competition(s)
$s_sql = 'DELETE FROM ' . $s_comp . ' WHERE competition_id IN (' . $s_ids . ') ';
$o_result = $this->GetDataConnection()->query($s_sql);
return $this->GetDataConnection()->GetAffectedRows();
}
