public function OnLoadPageData() { # get player if (!is_object($this->player)) { $id = $this->player_manager->GetItemId($this->player); if ($id) { $this->player_manager->ReadPlayerById($id); $this->player = $this->player_manager->GetFirst(); } } # tidy up unset($this->player_manager); }
public function OnLoadPageData() { # Read the player data if (a) it's not a new player and (b) it's not in the postback data if ($this->player->GetId() and !$this->IsPostback()) { $this->player_manager->ReadPlayerById($this->player->GetId()); $this->player = $this->player_manager->GetFirst(); } unset($this->player_manager); # ensure we have a player if (!$this->player instanceof Player) { $this->Redirect(); } # if it's a new player, get the team details if (!$this->player->GetId() or $this->add_player_already_exists) { if (!$this->team instanceof Team) { require_once "stoolball/team-manager.class.php"; $team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection()); $team_manager->ReadById(array($this->player->Team()->GetId())); $this->team = $team_manager->GetFirst(); unset($team_manager); } $this->player->Team()->SetName($this->team->GetName()); $this->player->Team()->SetShortUrl($this->team->GetShortUrl()); } # ensure we have permission $this->CheckForPermission($this->player->Team()); }
/** * If the player parameter is in the query string apply player filter * @param SiteSettings $settings * @param MySqlConnection $connection * @param StatisticsManager $statistics_manager */ public static function ApplyPlayerFilter(SiteSettings $settings, MySqlConnection $connection, StatisticsManager $statistics_manager) { $filter = ""; if (isset($_GET['player']) and is_numeric($_GET['player'])) { require_once 'stoolball/player-manager.class.php'; $player_manager = new PlayerManager($settings, $connection); $player_manager->ReadPlayerById($_GET['player']); $player = $player_manager->GetFirst(); unset($player_manager); if (!is_null($player)) { $statistics_manager->FilterByPlayer(array($player->GetId())); $filter = "for " . $player->GetName() . " "; } } return $filter; }
private function IndexPlayers() { require_once "data/process-manager.class.php"; $this->process = new ProcessManager("players", 500); if ($this->process->ReadyToDeleteAll()) { $this->SearchIndexer()->DeleteFromIndexByType("player"); } # Get all players, but exclude unused extras $player = $this->GetSettings()->GetTable('Player'); $player_batch = $this->GetDataConnection()->query("SELECT player_id FROM {$player} WHERE total_matches >= 1 ORDER BY player_id" . $this->process->GetQueryLimit()); $player_ids = array(); while ($row = $player_batch->fetch()) { $player_ids[] = $row->player_id; } if (count($player_ids)) { require_once 'stoolball/player-manager.class.php'; require_once 'search/player-search-adapter.class.php'; $manager = new PlayerManager($this->GetSettings(), $this->GetDataConnection()); foreach ($player_ids as $player_id) { $manager->ReadPlayerById($player_id); $players = $manager->GetItems(); foreach ($players as $player) { $adapter = new PlayerSearchAdapter($player); $this->SearchIndexer()->Index($adapter->GetSearchableItem()); $this->process->OneMoreDone(); } } $this->SearchIndexer()->CommitChanges(); unset($manager); } }
/** * @return void * @param Match $match * @param bool $is_first_innings * @desc Saves the batting and bowling scorecards for one innings */ public function SaveScorecard(Match $match, $is_first_innings, ISearchIndexProvider $search) { # To add a scorecard there must always already be a match to update if (!$match->GetId()) { return; } # This isn't for tournaments if ($match->GetMatchType() == MatchType::TOURNAMENT) { return; } # Get tables $batting_table = $this->GetSettings()->GetTable("Batting"); $bowling_table = $this->GetSettings()->GetTable("Bowling"); $match_table = $this->GetSettings()->GetTable('Match'); $mt = $this->GetSettings()->GetTable('MatchTeam'); # Is this scorecard for the home or the away innings? $sql = "SELECT home_bat_first FROM {$match_table} WHERE match_id = " . Sql::ProtectNumeric($match->GetId()); $result = $this->GetDataConnection()->query($sql); $row = $result->fetch(); if (is_null($row->home_bat_first) or (bool) $row->home_bat_first === true) { $is_home_innings = $is_first_innings; } else { $is_home_innings = !$is_first_innings; } $result->closeCursor(); # Prepare data for query if ($is_home_innings) { $bowling_team_id = $match->GetAwayTeamId(); $batting_team_id = $match->GetHomeTeamId(); $team_bowling = $match->Result()->AwayOvers(); $team_batting = $match->Result()->HomeBatting(); } else { $bowling_team_id = $match->GetHomeTeamId(); $batting_team_id = $match->GetAwayTeamId(); $team_bowling = $match->Result()->HomeOvers(); $team_batting = $match->Result()->AwayBatting(); } # Find the match_team_id for the bowling $sql = "SELECT match_team_id FROM {$mt}\r\n\t\t\t\tWHERE match_id " . Sql::ProtectNumeric($match->GetId(), false, true) . "\r\n\t\t\t\tAND team_id " . Sql::ProtectNumeric($bowling_team_id, false, true) . "\r\n\t\t\t\tAND team_role = " . ($is_home_innings ? TeamRole::Away() : TeamRole::Home()); $result = $this->GetDataConnection()->query($sql); $row = $result->fetch(); $bowling_match_team_id = $row->match_team_id; $result->closeCursor(); # Find the match_team_id for the batting $sql = "SELECT match_team_id FROM {$mt}\r\n\t\t\t\tWHERE match_id " . Sql::ProtectNumeric($match->GetId(), false, true) . "\r\n\t\t\t\tAND team_id " . Sql::ProtectNumeric($batting_team_id, false, true) . "\r\n\t\t\t\tAND team_role = " . ($is_home_innings ? TeamRole::Home() : TeamRole::Away()); $result = $this->GetDataConnection()->query($sql); $row = $result->fetch(); $batting_match_team_id = $row->match_team_id; $result->closeCursor(); $affected_players = $this->SaveBattingScorecard($match, $is_home_innings, $batting_match_team_id, $team_batting); $affected_bowlers = $this->SaveBowlingScorecard($match, $is_home_innings, $batting_match_team_id, $bowling_match_team_id, $team_bowling); $affected_players = array_merge($affected_players, $affected_bowlers); $affected_players = array_unique($affected_players); if (count($affected_players)) { require_once 'stoolball/statistics/statistics-manager.class.php'; $statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection()); # generate player statistics from the data entered $statistics_manager->UpdateBattingStatistics($affected_players, array($batting_match_team_id)); $statistics_manager->UpdateFieldingStatistics($affected_players, array($bowling_match_team_id)); $statistics_manager->UpdateBowlingStatistics($affected_players, array($bowling_match_team_id)); $statistics_manager->DeleteObsoleteStatistics($match->GetId()); # update overall stats for players $statistics_manager->UpdatePlayerStatistics($affected_players); unset($statistics_manager); # update search engine require_once "stoolball/player-manager.class.php"; require_once "search/player-search-adapter.class.php"; $player_manager = new PlayerManager($this->GetSettings(), $this->GetDataConnection()); foreach ($affected_players as $player_id) { $player_manager->ReadPlayerById($player_id); $player = $player_manager->GetFirst(); $search->DeleteFromIndexById("player" . $player_id); if ($player instanceof Player) { $adapter = new PlayerSearchAdapter($player); $search->Index($adapter->GetSearchableItem()); } } $search->CommitChanges(); unset($player_manager); } }
public function OnLoadPageData() { # Always get the player's unfiltered profile, because it's needed for the page description require_once "stoolball/player-manager.class.php"; $player_manager = new PlayerManager($this->GetSettings(), $this->GetDataConnection()); $player_manager->ReadPlayerById($this->player->GetId()); $this->player_unfiltered = $player_manager->GetFirst(); if (!$this->player_unfiltered instanceof Player) { http_response_code(404); $this->not_found = true; return; } # Update search engine if ($this->player_unfiltered->GetSearchUpdateRequired()) { require_once "search/player-search-adapter.class.php"; $this->SearchIndexer()->DeleteFromIndexById("player" . $this->player->GetId()); $adapter = new PlayerSearchAdapter($this->player_unfiltered); $this->SearchIndexer()->Index($adapter->GetSearchableItem()); $this->SearchIndexer()->CommitChanges(); $player_manager->SearchUpdated($this->player->GetId()); } unset($player_manager); # Check first for a player created using 'add player', who hasn't played yet if ($this->player_unfiltered->GetTotalMatches() == 0) { $this->player = $this->player_unfiltered; } else { # Now get statistics for the player $statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection()); $statistics_manager->FilterByPlayer(array($this->player->GetId())); # Apply filters common to all statistics $this->filter_control = new StatisticsFilterControl(); $filter_batting_position = StatisticsFilter::SupportBattingPositionFilter($statistics_manager); $this->filter_control->SupportBattingPositionFilter($filter_batting_position); $this->filter .= $filter_batting_position[2]; $filter_match_type = StatisticsFilter::SupportMatchTypeFilter($statistics_manager); $this->filter_control->SupportMatchTypeFilter($filter_match_type); $this->filter .= $filter_match_type[2]; $filter_opposition = StatisticsFilter::SupportOppositionFilter($statistics_manager); $this->filter_control->SupportOppositionFilter($filter_opposition); $this->filter .= $filter_opposition[2]; $filter_competition = StatisticsFilter::SupportCompetitionFilter($statistics_manager); $this->filter_control->SupportCompetitionFilter($filter_competition); $this->filter .= $filter_competition[2]; $this->filter .= StatisticsFilter::ApplySeasonFilter($this->GetSettings(), $this->GetDataConnection(), $statistics_manager); $filter_ground = StatisticsFilter::SupportGroundFilter($statistics_manager); $this->filter_control->SupportGroundFilter($filter_ground); $this->filter .= $filter_ground[2]; $filter_date = StatisticsFilter::SupportDateFilter($statistics_manager); if (!is_null($filter_date[0])) { $this->filter_control->SupportAfterDateFilter($filter_date[0]); } if (!is_null($filter_date[1])) { $this->filter_control->SupportBeforeDateFilter($filter_date[1]); } $this->filter .= $filter_date[2]; $filter_innings = StatisticsFilter::SupportInningsFilter($statistics_manager); $this->filter_control->SupportInningsFilter($filter_innings[1]); $this->filter .= $filter_innings[2]; $filter_won_match = StatisticsFilter::SupportMatchResultFilter($statistics_manager); $this->filter_control->SupportMatchResultFilter($filter_won_match[1]); $this->filter .= $filter_won_match[2]; # Now get the statistics for the player $data = $statistics_manager->ReadPlayerSummary(); if (count($data)) { $this->player = $data[0]; } else { if ($this->filter) { # If no matches matched the filter, ensure we have the player's name and team $this->player = $this->player_unfiltered; $this->filter_matched_nothing = true; } else { $this->regenerating = true; } } $data = $statistics_manager->ReadBestBattingPerformance(false); foreach ($data as $performance) { $batting = new Batting($this->player, $performance["how_out"], null, null, $performance["runs_scored"], $performance["balls_faced"]); $this->player->Batting()->Add($batting); } if ($this->player->GetPlayerRole() == Player::PLAYER) { $data = $statistics_manager->ReadBestPlayerAggregate("player_of_match"); $this->player->SetTotalPlayerOfTheMatchNominations(count($data) ? $data[0]["statistic"] : 0); } unset($statistics_manager); } }