function OnLoadPageData()
{
/* @var Match $tournament */
# check parameter
if (!isset($_GET['match']) or !is_numeric($_GET['match'])) {
$this->Redirect();
}
# get tournament
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->ReadByMatchId(array($_GET['match']));
$this->tournament = $match_manager->GetFirst();
unset($match_manager);
# must have found a match
if (!$this->tournament instanceof Match) {
$this->page_not_found = true;
return;
}
# Get some stats on the best players
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterByTournament(array($this->tournament->GetId()));
$this->statistics["querystring"] = "?tournament=" . $this->tournament->GetId();
require_once "_summary-data-query.php";
unset($statistics_manager);
}
function OnLoadSiteData()
{
$this->SetCategories($this->GetAllCategories());
$o_match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$o_match_manager->ReadNext();
$this->a_next_matches = $o_match_manager->GetItems();
unset($o_match_manager);
}
function OnLoadPageData()
{
# new data manager
$manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# get matches
$i_one_day = 86400;
$i_start = gmdate('U') - $i_one_day * 1;
# yesterday
$i_end = gmdate('U') + $i_one_day * 365;
# in the next year
# Check for player type
$this->player_type = null;
if (isset($_GET['player'])) {
$this->player_type = PlayerType::Parse($_GET['player']);
}
$a_player_types = is_null($this->player_type) ? null : array($this->player_type);
if ($this->player_type == PlayerType::JUNIOR_MIXED) {
$a_player_types[] = PlayerType::GIRLS;
$a_player_types[] = PlayerType::BOYS;
}
$manager->FilterByMatchType(array(MatchType::TOURNAMENT));
$manager->FilterByPlayerType($a_player_types);
$manager->FilterByDateStart($i_start);
$manager->FilterByDateEnd($i_end);
$manager->ReadMatchSummaries();
$this->a_matches = $manager->GetItems();
unset($manager);
}
public function OnLoadPageData()
{
if (!is_null($this->i_match_id)) {
require_once 'stoolball/match-manager.class.php';
$o_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$o_manager->ReadByMatchId(array($this->i_match_id));
$o_match = $o_manager->GetFirst();
if ($o_match instanceof Match) {
$this->s_cal_title = $o_match->GetTitle() . ' – ' . $o_match->GetStartTimeFormatted();
$this->s_cal_url = $o_match->GetCalendarNavigateUrl();
}
unset($o_manager);
} else {
if (!is_null($this->i_team_id)) {
require_once 'stoolball/team-manager.class.php';
$o_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
$o_manager->ReadById(array($this->i_team_id));
$o_team = $o_manager->GetFirst();
if ($o_team instanceof Team) {
$this->s_cal_title = $o_team->GetName() . '\'s current season';
$this->s_cal_url = $o_team->GetCalendarNavigateUrl();
}
unset($o_manager);
} else {
if (!is_null($this->i_season_id)) {
require_once 'stoolball/competition-manager.class.php';
$o_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$o_manager->ReadById(null, array($this->i_season_id));
$o_comp = $o_manager->GetFirst();
if ($o_comp instanceof Competition) {
$o_season = $o_comp->GetWorkingSeason();
$this->s_cal_title = $o_season->GetCompetitionName();
$this->s_cal_url = $o_season->GetCalendarNavigateUrl();
}
unset($o_manager);
} else {
if ($this->tournament_player_type) {
$this->s_matches = $this->tournament_player_type . " tournaments";
$this->s_cal_url = "/tournaments/" . $this->tournament_player_type . "/calendar";
}
}
}
}
if (is_null($this->s_cal_url)) {
header('Location: /play/');
exit;
}
}
function OnLoadPageData()
{
# get match
if (!is_object($this->match)) {
$i_id = $this->manager->GetItemId($this->match);
if ($i_id) {
$this->manager->ReadByMatchId(array($i_id));
$this->match = $this->manager->GetFirst();
}
}
# tidy up
unset($this->manager);
if (is_object($this->match) and $this->match->GetMatchType() == MatchType::TOURNAMENT) {
$this->match_or_tournament = 'tournament';
}
}
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);
}
}
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()
{
/* @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 grounds
require_once 'stoolball/ground-manager.class.php';
$o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
$o_ground_manager->ReadAll();
$this->editor->Grounds()->SetItems($o_ground_manager->GetItems());
unset($o_ground_manager);
# get teams in seasons, in order to promote home grounds of teams
$season_ids = array();
foreach ($this->tournament->Seasons() as $season) {
$season_ids[] = $season->GetId();
}
require_once 'stoolball/team-manager.class.php';
$team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
if (count($season_ids)) {
$team_manager->ReadBySeasonId($season_ids);
$this->editor->ProbableTeams()->SetItems($team_manager->GetItems());
}
unset($team_manager);
}
}
function OnLoadPageData()
{
/* @var Match $tournament */
# check parameter
if (!isset($_GET['match']) or !is_numeric($_GET['match'])) {
$this->Redirect();
}
# get match
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->ReadByMatchId(array($_GET['match']));
$match_manager->ExpandMatchScorecards();
$this->match = $match_manager->GetFirst();
unset($match_manager);
# must have found a match
if (!$this->match instanceof Match) {
$this->page_not_found = true;
return;
}
$result = $this->match->Result();
$this->has_statistics = $result->HomeOvers()->GetCount() or $result->AwayOvers()->GetCount();
}
function OnLoadPageData()
{
# Require an API key to include personal contact details to avoid spam bots picking them up
$api_keys = $this->GetSettings()->GetApiKeys();
$valid_key = false;
if (isset($_GET['key']) and in_array($_GET['key'], $api_keys)) {
$valid_key = true;
}
$data = array();
$data[] = array("Match id", "Title", "Start time", "Latitude", "Longitude", "Website", "Description");
require_once 'stoolball/match-manager.class.php';
require_once "search/match-search-adapter.class.php";
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->FilterByDateStart(gmdate("U"));
$match_manager->ReadByMatchId();
while ($match_manager->MoveNext()) {
$match = $match_manager->GetItem();
$adapter = new MatchSearchAdapter($match);
/* @var $match Match */
# Add this match to the data array
$data[] = array($match->GetId(), $match->GetTitle(), $match->GetStartTime(), $match->GetGround() instanceof Ground ? $match->GetGround()->GetAddress()->GetLatitude() : "", $match->GetGround() instanceof Ground ? $match->GetGround()->GetAddress()->GetLongitude() : "", "https://" . $this->GetSettings()->GetDomain() . $match->GetNavigateUrl(), $adapter->GetSearchDescription());
}
unset($match_manager);
require_once "data/csv.class.php";
CSV::PublishData($data);
# Test code only. Comment out CSV publish line above to enable display as a table.
require_once "xhtml/tables/xhtml-table.class.php";
$table = new XhtmlTable();
$table->BindArray($data, false, false);
echo $table;
}
private function ReadMatchData($start_date)
{
require_once 'stoolball/match-manager.class.php';
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->FilterByDateStart($start_date);
$match_manager->FilterByMatchType(array(MatchType::CUP, MatchType::FRIENDLY, MatchType::LEAGUE, MatchType::PRACTICE, MatchType::TOURNAMENT));
$match_manager->ReadByMatchId();
$data = $match_manager->GetItems();
unset($match_manager);
return $data;
}
function OnLoadPageData()
{
/* @var $match_manager MatchManager */
/* @var $editor TournamentMatchesControl */
# 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_is_tournament = $this->tournament->GetMatchType() == MatchType::TOURNAMENT;
} else {
return;
}
}
}
function OnLoadPageData()
{
/* @var $match_manager MatchManager */
# get id of Match
$i_id = $this->match_manager->GetItemId();
# Get details of match but, if invalid, don't replace submitted details with saved ones
if ($i_id and $this->IsValid()) {
$this->match_manager->ReadByMatchId(array($i_id));
$this->match_manager->ExpandMatchScorecards();
$this->match = $this->match_manager->GetFirst();
if ($this->match instanceof Match) {
$this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->match->GetAddedBy()->GetId();
$this->b_is_tournament = $this->match->GetMatchType() == MatchType::TOURNAMENT;
}
}
unset($this->match_manager);
# Tournament or match in the future or not played is page not found
$editable_results = array(MatchResult::UNKNOWN, MatchResult::HOME_WIN, MatchResult::AWAY_WIN, MatchResult::TIE, MatchResult::ABANDONED);
if (!$this->match instanceof Match or $this->b_is_tournament or $this->match->GetStartTime() > gmdate('U') or !in_array($this->match->Result()->GetResultType(), $editable_results)) {
http_response_code(404);
$this->page_not_found = true;
}
}
function OnLoadPageData()
{
require_once 'stoolball/competition-manager.class.php';
$comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$comp_manager->ReadCompetitionsInCategories(array(17, 33, 45, 61, 62, 72, 73));
$competitions = $comp_manager->GetItems();
unset($comp_manager);
$season_ids = array();
foreach ($competitions as $competition) {
/*@var $competition Competition */
$season = $competition->GetLatestSeason();
$season_ids[] = $season->GetId();
}
# Fixtures
require_once 'stoolball/match-manager.class.php';
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->FilterByMaximumResults(5);
$match_manager->FilterByDateStart(gmdate('U'));
$match_manager->ReadBySeasonId($season_ids);
$this->matches = $match_manager->GetItems();
unset($match_manager);
# Get stats highlights
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterBySeason($season_ids);
$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);
unset($statistics_manager);
}
ini_set("html_errors", "off");
ini_set("log_errors", "on");
ini_set("ignore_repeated_errors", "off");
ini_set("ignore_repeated_source", "off");
ini_set("report_memleaks", "on");
ini_set("track_errors", "on");
ini_set("docref_root", "0");
ini_set("docref_ext", "0");
ini_set("error_reporting", "-1");
ini_set("log_errors_max_len", "0");
ini_set("error_log", $_SERVER['DOCUMENT_ROOT'] . "/php-errors.log");
}
# set up INI options
date_default_timezone_set('Europe/London');
$database = new MySqlConnection($settings->DatabaseHost(), $settings->DatabaseUser(), $settings->DatabasePassword(), $settings->DatabaseName());
$manager = new MatchManager($settings, $database);
# get matches
$i_one_day = 86400;
# from yesterday
$i_start = gmdate('U') - $i_one_day * 1;
# in the next year, or as specified
$days = isset($_GET['days']) ? (int) $_GET['days'] : 365;
$i_end = gmdate('U') + $i_one_day * $days;
# Check for player type
$player_type = null;
$player_types = null;
if (isset($_GET['player'])) {
$player_type = PlayerType::Parse($_GET['player']);
if (!is_null($player_type)) {
$player_types = array($player_type);
if ($player_type == PlayerType::JUNIOR_MIXED) {
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);
}
private function IndexMatches()
{
require_once "data/process-manager.class.php";
$this->process = new ProcessManager("matches", 200);
if ($this->process->ReadyToDeleteAll()) {
$this->SearchIndexer()->DeleteFromIndexByType("match");
}
$match = $this->GetSettings()->GetTable('Match');
$match_batch = $this->GetDataConnection()->query("SELECT match_id FROM {$match} ORDER BY start_time, match_id" . $this->process->GetQueryLimit());
$match_ids = array();
while ($row = $match_batch->fetch()) {
$match_ids[] = $row->match_id;
}
if (count($match_ids)) {
require_once 'stoolball/match-manager.class.php';
require_once 'search/match-search-adapter.class.php';
$manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$manager->ReadByMatchId($match_ids);
$results = $manager->GetItems();
unset($manager);
foreach ($results as $match) {
$adapter = new MatchSearchAdapter($match);
$this->SearchIndexer()->Index($adapter->GetSearchableItem());
$this->process->OneMoreDone();
}
$this->SearchIndexer()->CommitChanges();
}
}
/**
* If the tournament parameter is in the query string apply tournament filter
* @param SiteSettings $settings
* @param MySqlConnection $connection
* @param StatisticsManager $statistics_manager
*/
public static function ApplyTournamentFilter(SiteSettings $settings, MySqlConnection $connection, StatisticsManager $statistics_manager)
{
$filter = "";
if (isset($_GET['tournament']) and is_numeric($_GET['tournament'])) {
require_once 'stoolball/match-manager.class.php';
$match_manager = new MatchManager($settings, $connection);
$match_manager->ReadByMatchId(array($_GET['tournament']));
$tournament = $match_manager->GetFirst();
unset($match_manager);
if (!is_null($tournament)) {
$statistics_manager->FilterByTournament(array($tournament->GetId()));
$filter = "in the " . $tournament->GetTitle() . " on " . Date::BritishDate($tournament->GetStartTime()) . " ";
}
}
return $filter;
}
/**
* Call this method when a match has changed to update derived match data
*/
public function UpdateMatchDataInStatistics(MatchManager $match_manager, $match_id)
{
$match_manager->ReadByMatchId(array($match_id));
$match = $match_manager->GetFirst();
$sql = "UPDATE nsa_player_match SET \r\n match_title = " . Sql::ProtectString($this->GetDataConnection(), $match->GetTitle()) . ",\r\n won_match = NULL \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId());
$this->GetDataConnection()->query($sql);
$match_result = $match->Result()->GetResultType();
if ($match_result == MatchResult::HOME_WIN) {
$sql = "UPDATE nsa_player_match \r\n SET won_match = 1 \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n AND team_id = " . Sql::ProtectNumeric($match->GetHomeTeamId());
$this->GetDataConnection()->query($sql);
$sql = "UPDATE nsa_player_match \r\n SET won_match = -1 \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n AND team_id = " . Sql::ProtectNumeric($match->GetAwayTeamId());
$this->GetDataConnection()->query($sql);
} else {
if ($match_result == MatchResult::AWAY_WIN) {
$sql = "UPDATE nsa_player_match \r\n SET won_match = 1 \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n AND team_id = " . Sql::ProtectNumeric($match->GetAwayTeamId());
$this->GetDataConnection()->query($sql);
$sql = "UPDATE nsa_player_match \r\n SET won_match = -1 \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n AND team_id = " . Sql::ProtectNumeric($match->GetHomeTeamId());
$this->GetDataConnection()->query($sql);
} else {
if ($match_result == MatchResult::TIE) {
$sql = "UPDATE nsa_player_match \r\n SET won_match = 0 \r\n WHERE match_id = " . Sql::ProtectNumeric($match->GetId());
$this->GetDataConnection()->query($sql);
}
}
}
}
function OnLoadPageData()
{
/* @var $match_manager MatchManager */
/* @var $editor MatchEditControl */
# get id of Match
$i_id = $this->match_manager->GetItemId();
if ($i_id) {
# Get details of match but, if invalid, don't replace submitted details with saved ones
if ($this->IsValid()) {
$this->match_manager->ReadByMatchId(array($i_id));
$this->match_manager->ExpandMatchScorecards();
$this->match = $this->match_manager->GetFirst();
if ($this->match instanceof Match) {
$this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->match->GetAddedBy()->GetId();
$this->b_is_tournament = $this->match->GetMatchType() == MatchType::TOURNAMENT;
}
}
unset($this->match_manager);
# get all competitions if user has permission to change the season
if ($this->b_user_is_match_admin) {
require_once 'stoolball/competition-manager.class.php';
$o_comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$o_comp_manager->ReadAllSummaries();
$this->editor->SetSeasons(CompetitionManager::GetSeasonsFromCompetitions($o_comp_manager->GetItems()));
unset($o_comp_manager);
}
if ($this->b_user_is_match_admin or $this->b_user_is_match_owner) {
# get all teams
$season_ids = array();
if ($this->match instanceof Match) {
foreach ($this->match->Seasons() as $season) {
$season_ids[] = $season->GetId();
}
}
require_once 'stoolball/team-manager.class.php';
$o_team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
if ($this->match instanceof Match and $this->match->GetMatchType() == MatchType::TOURNAMENT_MATCH) {
$o_team_manager->FilterByTournament(array($this->match->GetTournament()->GetId()));
$o_team_manager->FilterByTeamType(array());
# override default to allow all team types
$o_team_manager->ReadTeamSummaries();
} else {
if ($this->b_user_is_match_admin or !count($season_ids) or $this->match->GetMatchType() == MatchType::FRIENDLY) {
$o_team_manager->ReadById();
# we need full data on the teams to get the seasons they are playing in;
} else {
# If the user can't change the season, why let them select a team that's not in the season?
$o_team_manager->ReadBySeasonId($season_ids);
}
}
$this->editor->SetTeams(array($o_team_manager->GetItems()));
unset($o_team_manager);
# get all grounds
require_once 'stoolball/ground-manager.class.php';
$o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
$o_ground_manager->ReadAll();
$this->editor->SetGrounds($o_ground_manager->GetItems());
unset($o_ground_manager);
}
}
# Tournament or match not found is page not found
if (!$this->match instanceof Match or $this->b_is_tournament) {
http_response_code(404);
$this->page_not_found = true;
}
}
public function OnLoadPageData()
{
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$match_manager->ReadByMatchId(array($_GET['match']));
$match_manager->ExpandMatchScorecards();
$this->match = $match_manager->GetFirst();
unset($match_manager);
if ($this->match->GetHomeTeam() instanceof Team and $this->match->GetAwayTeam() instanceof Team) {
?>
{
"worm": {
"labels": [
<?php
$overs = $this->HowManyOversInTheMatch();
echo $this->BuildOversLabels(0, $overs);
?>
],
"datasets": [
<?php
$home_batted_first = $this->match->Result()->GetHomeBattedFirst();
if ($home_batted_first === true || is_null($home_batted_first)) {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
?>
",
"data": [0<?php
echo $this->BuildCumulativeOverTotals($this->match->Result()->AwayOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
?>
",
"data": [0<?php
echo $this->BuildCumulativeOverTotals($this->match->Result()->HomeOvers()->GetItems());
?>
]
}
<?php
} else {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
?>
",
"data": [0<?php
echo $this->BuildCumulativeOverTotals($this->match->Result()->HomeOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
?>
",
"data": [0<?php
echo $this->BuildCumulativeOverTotals($this->match->Result()->AwayOvers()->GetItems());
?>
]
}
<?php
}
?>
]
},
"runRate": {
"labels": [
<?php
echo $this->BuildOversLabels(0, $overs);
?>
],
"datasets": [
<?php
$home_batted_first = $this->match->Result()->GetHomeBattedFirst();
if ($home_batted_first === true || is_null($home_batted_first)) {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " run rate", $home_batted_first === true);
?>
",
"data": [0<?php
echo $this->BuildCumulativeRunRate($this->match->Result()->AwayOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " run rate", null);
?>
",
"data": [0<?php
echo $this->BuildCumulativeRunRate($this->match->Result()->HomeOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " rate required", null);
?>
",
"data": [<?php
echo $this->BuildRunRateRequired($this->match->Result()->AwayOvers()->GetItems(), $this->match->Result()->HomeOvers()->GetItems(), $overs);
?>
]
}
<?php
} else {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " run rate", $home_batted_first === false);
?>
",
"data": [0<?php
echo $this->BuildCumulativeRunRate($this->match->Result()->HomeOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " run rate", null);
?>
",
"data": [0<?php
echo $this->BuildCumulativeRunRate($this->match->Result()->AwayOvers()->GetItems());
?>
]
},
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " rate required", null);
?>
",
"data": [<?php
echo $this->BuildRunRateRequired($this->match->Result()->HomeOvers()->GetItems(), $this->match->Result()->AwayOvers()->GetItems(), $overs);
?>
]
}
<?php
}
?>
]
},
"manhattanFirstInnings": {
"labels": [
<?php
$overs = $this->HowManyOversInTheMatch();
echo $this->BuildOversLabels(1, $overs);
?>
],
"datasets": [
<?php
if ($home_batted_first === true || is_null($home_batted_first)) {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
?>
",
"data": [<?php
echo $this->BuildOverTotals($this->match->Result()->AwayOvers()->GetItems(), $overs);
?>
]
}
<?php
} else {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
?>
",
"data": [<?php
echo $this->BuildOverTotals($this->match->Result()->HomeOvers()->GetItems(), $overs);
?>
]
}
<?php
}
?>
]
},
"manhattanSecondInnings": {
"labels": [
<?php
$overs = $this->HowManyOversInTheMatch();
echo $this->BuildOversLabels(1, $overs);
?>
],
"datasets": [
<?php
if ($home_batted_first === false) {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
?>
",
"data": [<?php
echo $this->BuildOverTotals($this->match->Result()->AwayOvers()->GetItems(), $overs);
?>
]
}
<?php
} else {
?>
{
"label": "<?php
echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
?>
",
"data": [<?php
echo $this->BuildOverTotals($this->match->Result()->HomeOvers()->GetItems(), $overs);
?>
]
}
<?php
}
?>
]
}
<?php
}
?>
}
<?php
exit;
}
function OnLoadPageData()
{
# new data manager
$manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# Check for month value
if (isset($_GET['month']) and is_numeric($_GET['month'])) {
# Make sure it looks real
$i_day = (int) date('d', $_GET['month']);
$i_year = (int) date('Y', $_GET['month']);
$i_month = (int) date('m', $_GET['month']);
if ($i_year >= 2000 and $i_year <= 2050 and $i_month >= 1 and $i_month <= 12 and $i_day == 1) {
# Read start date specified by user, which will be with DST applied because users don't think in UTC
$i_start = $_GET['month'];
$i_end = mktime(11, 59, 59, $i_month, date('t', $_GET['month']), $i_year);
# Convert to UTC, as that's how match dates are stored
$i_end = gmdate('U', $i_end);
$manager->FilterByDateStart($i_start);
$manager->FilterByDateEnd($i_end);
}
} else {
# get next few matches
$i_one_day = 86400;
$i_start = gmdate('U') - $i_one_day * 1;
# yesterday
$manager->FilterByDateStart($i_start);
$manager->FilterByMaximumResults(50);
}
# Check for match type
$i_match_type = null;
if (isset($_GET['type']) and is_numeric($_GET['type'])) {
$i_match_type = (int) $_GET['type'];
if ($i_match_type < 0 or $i_match_type > 50) {
$i_match_type = null;
}
}
$a_match_types = is_null($i_match_type) ? null : array($i_match_type);
$manager->FilterByMatchType($a_match_types);
# Check for player type
$i_player_type = null;
if (isset($_GET['player']) and is_numeric($_GET['player'])) {
$i_player_type = (int) $_GET['player'];
if ($i_player_type < 0 or $i_player_type > 50) {
$i_player_type = null;
}
}
$a_player_types = is_null($i_player_type) ? null : array($i_player_type);
$manager->FilterByPlayerType($a_player_types);
$manager->ReadMatchSummaries();
$this->a_matches = $manager->GetItems();
$this->a_months = $manager->ReadMatchMonths();
# tidy up
unset($manager);
}
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);
}
public function OnLoadPageData()
{
/* @var $topic ForumTopic */
/* @var $match Match */
# new data manager
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# get match
$match_manager->ReadByMatchId(array($_GET['item']));
$match_manager->ExpandMatchScorecards();
$this->match = $match_manager->GetFirst();
# must have found a match
if (!$this->match instanceof Match) {
header('Location: /matches/');
exit;
}
# Update search engine
if ($this->match->GetSearchUpdateRequired()) {
require_once "search/match-search-adapter.class.php";
$this->SearchIndexer()->DeleteFromIndexById("match" . $this->match->GetId());
$adapter = new MatchSearchAdapter($this->match);
$this->SearchIndexer()->Index($adapter->GetSearchableItem());
$this->SearchIndexer()->CommitChanges();
$match_manager->SearchUpdated($this->match->GetId());
}
# tidy up
unset($match_manager);
# Get comments
$this->review_item = new ReviewItem($this->GetSettings());
$this->review_item->SetId($this->match->GetId());
$this->review_item->SetType(ContentType::STOOLBALL_MATCH);
$this->review_item->SetTitle($this->match->GetTitle());
$this->review_item->SetNavigateUrl("https://" . $this->GetSettings()->GetDomain() . $this->review_item->GetNavigateUrl());
$this->review_item->SetLinkedDataUri($this->match->GetLinkedDataUri());
$topic_manager = new TopicManager($this->GetSettings(), $this->GetDataConnection());
if ($this->IsPostback()) {
$this->SavePostedComments($topic_manager);
}
$topic_manager->ReadCommentsForReviewItem($this->review_item);
$this->topic = $topic_manager->GetFirst();
unset($topic_manager);
if ($this->match->GetMatchType() == MatchType::TOURNAMENT or $this->match->GetMatchType() == MatchType::TOURNAMENT_MATCH) {
# Get stats highlights
require_once 'stoolball/statistics/statistics-manager.class.php';
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
if ($this->match->GetMatchType() == MatchType::TOURNAMENT) {
$statistics_manager->FilterByTournament(array($this->match->GetId()));
} else {
$statistics_manager->FilterByTournament(array($this->match->GetTournament()->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);
}
}
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);
}
public function OnLoadPageData()
{
$i_one_day = 86400;
$i_start = gmdate('U') - $i_one_day * 1;
# yesterday
$i_end = gmdate('U') + $i_one_day * 365;
# this year
# Check for player type
$player_type = null;
if (isset($_GET['player']) and is_numeric($_GET['player'])) {
$player_type = (int) $_GET['player'];
}
$a_player_types = is_null($player_type) ? null : array($player_type);
if ($player_type == PlayerType::JUNIOR_MIXED) {
$a_player_types[] = PlayerType::GIRLS;
$a_player_types[] = PlayerType::BOYS;
}
$manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
$manager->FilterByMatchType(array(MatchType::TOURNAMENT));
$manager->FilterByPlayerType($a_player_types);
$manager->FilterByDateStart($i_start);
$manager->FilterByDateEnd($i_end);
$manager->ReadMatchSummaries();
$tournaments = $manager->GetItems();
unset($manager);
?>
$(function()
{
// Make the placeholder big enough for a map
var mapControl = document.getElementById("map");
mapControl.style.width = '100%';
mapControl.style.height = '400px';
// Create the map
var myLatlng = new google.maps.LatLng(51.07064141136184, -0.31114161014556885); // Horsham
var myOptions = {
zoom : $(window).width() > 400 ? 9 : 8,
center : myLatlng,
mapTypeId : google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(mapControl, myOptions);
var markers = [];
var info;
<?php
# There might be multiple tournaments at one ground. Rearrange tournaments so that they're indexed by ground.
$grounds = array();
foreach ($tournaments as $tournament) {
/* @var $tournament Match */
$ground_id = $tournament->GetGroundId();
if (!array_key_exists($ground_id, $grounds)) {
$grounds[$ground_id] = array();
}
$grounds[$ground_id][] = $tournament;
}
foreach ($grounds as $tournaments) {
/* @var $ground Ground */
$ground = $tournaments[0]->GetGround();
if (!is_object($ground) or !$ground->GetAddress()->GetLatitude() or !$ground->GetAddress()->GetLongitude()) {
continue;
}
$content = "'<div class=\"map-info\">' +\n\t'<h2>" . str_replace("'", "\\'", $ground->GetNameAndTown()) . "</h2>";
foreach ($tournaments as $tournament) {
/* @var $tournament Match */
$title = $tournament->GetTitle() . ", " . Date::BritishDate($tournament->GetStartTime(), false, true, false);
$content .= '<p><a href="' . $tournament->GetNavigateUrl() . '">' . str_replace("'", "\\'", $title) . '</a></p>';
}
$content .= "</div>'";
# And marker and click event to trigger info window. Wrap info window in function to isolate marker, otherwise the last marker
# is always used for the position of the info window.
echo "var marker = new google.maps.Marker({\n\t\t\tposition : new google.maps.LatLng(" . $ground->GetAddress()->GetLatitude() . "," . $ground->GetAddress()->GetLongitude() . "),\n\t\t\tshadow: Stoolball.Maps.WicketShadow(),\n\t\t\ticon: Stoolball.Maps.WicketIcon(),\n\t\t\ttitle : '" . str_replace("'", "\\'", $ground->GetNameAndTown()) . "'\n\t\t });\n\t\t markers.push(marker);\n\n\t\t (function(marker){\n\t\t\t google.maps.event.addListener(marker, 'click', function()\n\t\t\t {\n\t\t\t \tvar content = {$content};\n\t\t\t \tif (!info) info = new google.maps.InfoWindow();\n\t\t\t \tinfo.setContent(content);\n\t\t\t \tinfo.open(map, marker);\n\t\t\t });\n\t\t })(marker);\n\t\t ";
}
?>
var style = [{
url: '/images/features/map-markers.gif',
height: 67,
width: 31,
textColor: '#ffffff',
textSize: 10
}];
var clusterer = new MarkerClusterer(map, markers, { 'gridSize': 30, styles: style });
});
<?php
exit;
}
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 $o_match Match */
/* @var $o_team Team */
# new data manager
$match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
# create repeater control, and save any posted data
$this->repeater = new DataEditRepeater($this, 'CreateEditControl');
$this->repeater->SetCssClass('matchResults');
$this->repeater->SetPersistedParameters(array('team', 'season', "tournament"));
$this->repeater->SetButtonText('Save all results');
$this->repeater->SetShowButtonsAtTop(true);
if ($this->IsPostback() and !$this->IsRefresh() and $this->IsValid()) {
require_once 'forums/topic-manager.class.php';
require_once 'forums/review-item.class.php';
require_once 'forums/subscription-manager.class.php';
$topic_manager = new TopicManager($this->GetSettings(), $this->GetDataConnection());
foreach ($this->repeater->GetDataObjects() as $o_current_match) {
/* @var $o_current_match Match */
$match_manager->SaveResult($o_current_match);
$match_manager->ExpandMatchUrl($o_current_match);
$match_manager->NotifyMatchModerator($o_current_match->GetId());
if (trim($o_current_match->GetNewComment())) {
$item_to_comment_on = new ReviewItem($this->GetSettings());
$item_to_comment_on->SetType(ContentType::STOOLBALL_MATCH);
$item_to_comment_on->SetId($o_current_match->GetId());
$item_to_comment_on->SetNavigateUrl("https://" . $this->GetSettings()->GetDomain() . $o_current_match->GetNavigateUrl());
$message = $topic_manager->SaveComment($item_to_comment_on, $o_current_match->GetNewComment());
# send subscription emails - new object each time to reset list of who's already recieved an email
$subs_manager = new SubscriptionManager($this->GetSettings(), $this->GetDataConnection());
$subs_manager->SendCommentsSubscriptions($item_to_comment_on, $message);
unset($subs_manager);
}
}
$this->b_saved = true;
}
# get matches
if (!is_null($this->i_team_id)) {
$a_season_times = Season::SeasonDates();
$match_manager->FilterByTeam(array($this->i_team_id));
$match_manager->FilterByDateStart($a_season_times[0]);
$match_manager->FilterByDateEnd($a_season_times[1]);
$match_manager->ReadMatchSummaries();
} else {
if (!is_null($this->i_season_id)) {
$match_manager->ReadBySeasonId(array($this->i_season_id), true);
} else {
if (!is_null($this->tournament_id)) {
$match_manager->FilterByTournament($this->tournament_id);
$this->a_matches = $match_manager->ReadMatchSummaries();
}
}
}
$this->a_matches = $match_manager->GetItems();
# Make sure we have some matches
if (count($this->a_matches)) {
# If it's matches for a team, get the team
if (!is_null($this->i_team_id)) {
# Should only need to look at the first match, because the team must be a
# part of that match in order for the match to be in this list
$o_match =& $this->a_matches[0];
$o_team = $o_match->GetHomeTeam();
if ($o_team instanceof Team and $o_team->GetId() == $this->i_team_id) {
$this->team = $o_team;
} else {
foreach ($o_match->GetAwayTeams() as $o_team) {
if ($o_team->GetId() == $this->i_team_id) {
$this->team = $o_team;
break;
}
}
}
if (!is_object($this->team)) {
$this->Redirect();
}
# Now that we have short URL data, if data has just been saved for team, redirect back to team
if ($this->b_saved) {
$this->Redirect($this->team->GetNavigateUrl());
}
} else {
if (!is_null($this->i_season_id)) {
# get details of the season
require_once 'stoolball/competition-manager.class.php';
$o_comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
$o_comp_manager->ReadById(null, array($this->i_season_id));
$o_competition = $o_comp_manager->GetFirst();
unset($o_comp_manager);
if ($o_competition instanceof Competition) {
$this->season = $o_competition->GetWorkingSeason();
}
if (!$this->season instanceof Season) {
$this->Redirect();
}
# Now that we have short URL data, if data has just been saved for season, redirect back to season
if ($this->b_saved) {
$this->Redirect($this->season->GetNavigateUrl());
}
} else {
if (!is_null($this->tournament_id)) {
$match_manager->ReadByMatchId(array($this->tournament_id));
$this->tournament = $match_manager->GetFirst();
if (!is_null($this->tournament)) {
# If the tournament has just been saved, now we have its URL so redirect to the thanks page
if ($this->b_saved) {
$this->Redirect($this->tournament->GetNavigateUrl());
}
}
}
}
}
} else {
$this->Redirect();
}
unset($match_manager);
}