/**
* Creates players for a new team to represent types of extras conceded
* @param int $team_id
*/
public function CreateExtrasPlayersForTeam($team_id)
{
$player = new Player($this->GetSettings());
$player->Team()->SetId($team_id);
$player->SetPlayerRole(Player::NO_BALLS);
$this->SavePlayer($player);
$player = new Player($this->GetSettings());
$player->Team()->SetId($team_id);
$player->SetPlayerRole(Player::WIDES);
$this->SavePlayer($player);
$player = new Player($this->GetSettings());
$player->Team()->SetId($team_id);
$player->SetPlayerRole(Player::BYES);
$this->SavePlayer($player);
$player = new Player($this->GetSettings());
$player->Team()->SetId($team_id);
$player->SetPlayerRole(Player::BONUS_RUNS);
$this->SavePlayer($player);
}
/**
* Read when and how often a player has played
*/
public function ReadPlayerSummary()
{
$from = $this->FromFilteredPlayerStatistics() . " INNER JOIN nsa_team AS team ON nsa_player_match.team_id = team.team_id ";
$where = "";
$where = $this->ApplyFilters($where);
if ($where) {
$where = "WHERE " . substr($where, 3, strlen($where) - 3);
}
$sql = "SELECT player_id, player_name, player_role, player_url,\r\n\t\tteam.team_id, team.team_name, team.short_url AS team_short_url,\r\n\t\tCOUNT(nsa_player_match.match_id) AS total_matches, MIN(nsa_player_match.match_time) AS first_played, MAX(nsa_player_match.match_time) AS last_played\r\n\t\t{$from}\r\n\t\t{$where}\r\n\t\tGROUP BY nsa_player_match.player_id\r\n\t\tORDER BY player_name ASC";
$data = array();
$result = $this->GetDataConnection()->query($sql);
if (!$this->GetDataConnection()->isError()) {
while ($row = $result->fetch()) {
$player = new Player($this->GetSettings());
$player->SetId($row->player_id);
$player->SetName($row->player_name);
if (isset($row->total_matches)) {
$player->SetTotalMatches($row->total_matches);
}
if (isset($row->first_played)) {
$player->SetFirstPlayedDate($row->first_played);
}
if (isset($row->last_played)) {
$player->SetLastPlayedDate($row->last_played);
}
if (isset($row->player_role)) {
$player->SetPlayerRole($row->player_role);
}
if (isset($row->player_url)) {
$player->SetShortUrl($row->player_url);
}
$player->Team()->SetId($row->team_id);
$player->Team()->SetName($row->team_name);
if (isset($row->team_short_url)) {
$player->Team()->SetShortUrl($row->team_short_url);
}
$data[] = $player;
}
}
$result->closeCursor();
unset($result);
return $data;
}
/**
* Add full scorecard data to the currently selected matches
*/
public function ExpandMatchScorecards()
{
$a_ids = array();
foreach ($this->GetItems() as $match) {
$a_ids[] = $match->GetId();
}
# Select batting and bowling separately because when selecting it all together they create so many duplicate rows that
# it would significantly increase the amount of data sent across the wire
$s_sql = "SELECT mt.match_id, mt.team_role,\r\n\t\tbat.player_id, bat.how_out, bat.dismissed_by_id, bat.bowler_id, bat.runs, bat.balls_faced,\r\n\t\tbatter.player_name AS batter_name, batter.player_role AS batter_role, batter.short_url AS batter_url,\r\n\t\tdismissed_by.player_name AS dismissed_by_name, dismissed_by.player_role AS dismissed_by_role, dismissed_by.short_url AS dismissed_by_url,\r\n\t\tbowler.player_name AS bowler_name, bowler.player_role AS bowler_role, bowler.short_url AS bowler_url\r\n\t\tFROM nsa_match_team mt\r\n\t\tINNER JOIN nsa_batting bat ON mt.match_team_id = bat.match_team_id\r\n\t\tINNER JOIN nsa_player batter ON bat.player_id = batter.player_id\r\n\t\tLEFT JOIN nsa_player dismissed_by ON bat.dismissed_by_id = dismissed_by.player_id\r\n\t\tLEFT JOIN nsa_player bowler ON bat.bowler_id = bowler.player_id\r\n\t\tWHERE mt.team_role IN (" . TeamRole::Home() . "," . TeamRole::Away() . ") ";
if (count($a_ids)) {
$s_sql .= "AND mt.match_id IN (" . join(', ', $a_ids) . ') ';
}
$s_sql .= "ORDER BY mt.match_id, mt.match_team_id, bat.position";
$result = $this->GetDataConnection()->query($s_sql);
while ($row = $result->fetch()) {
$match = $this->GetItemByProperty('GetId', $row->match_id);
if (!$match instanceof Match) {
continue;
}
# shouldn't ever happen
$batter = new Player($this->GetSettings());
$batter->SetId($row->player_id);
$batter->SetName($row->batter_name);
$batter->SetPlayerRole($row->batter_role);
$batter->SetShortUrl($row->batter_url);
if (!is_null($row->dismissed_by_id)) {
$dismissed_by = new Player($this->GetSettings());
$dismissed_by->SetId($row->dismissed_by_id);
$dismissed_by->SetName($row->dismissed_by_name);
$dismissed_by->SetPlayerRole($row->dismissed_by_role);
$dismissed_by->SetShortUrl($row->dismissed_by_url);
} else {
$dismissed_by = null;
}
if (!is_null($row->bowler_id)) {
$bowler = new Player($this->GetSettings());
$bowler->SetId($row->bowler_id);
$bowler->SetName($row->bowler_name);
$bowler->SetPlayerRole($row->bowler_role);
$bowler->SetShortUrl($row->bowler_url);
} else {
$bowler = null;
}
$batting = new Batting($batter, $row->how_out, $dismissed_by, $bowler, $row->runs, $row->balls_faced);
if (intval($row->team_role) == TeamRole::Home()) {
$match->Result()->HomeBatting()->Add($batting);
} else {
if (intval($row->team_role) == TeamRole::Away()) {
$match->Result()->AwayBatting()->Add($batting);
}
}
}
$result->closeCursor();
# select over-by-over bowling figures
$s_sql = "SELECT mt.match_id, mt.team_role,\r\n\t\tp.player_name, p.player_role, p.short_url,\r\n\t\tb.player_id, b.position, b.balls_bowled, b.no_balls, b.wides, b.runs_in_over\r\n\t\tFROM nsa_match_team mt\r\n\t\tINNER JOIN nsa_bowling b ON mt.match_team_id = b.match_team_id\r\n\t\tINNER JOIN nsa_player p ON p.player_id = b.player_id\r\n\t\tWHERE mt.team_role IN (" . TeamRole::Home() . "," . TeamRole::Away() . ") ";
if (count($a_ids)) {
$s_sql .= "AND mt.match_id IN (" . join(', ', $a_ids) . ') ';
}
$s_sql .= "ORDER BY mt.match_id, mt.match_team_id, ISNULL(b.position), b.position";
# null positions sorted last
$result = $this->GetDataConnection()->query($s_sql);
while ($row = $result->fetch()) {
$match = $this->GetItemByProperty('GetId', $row->match_id);
if (!$match instanceof Match) {
continue;
}
# shouldn't ever happen
$bowler = new Player($this->GetSettings());
$bowler->SetId($row->player_id);
$bowler->SetName($row->player_name);
$bowler->SetPlayerRole($row->player_role);
$bowler->SetShortUrl($row->short_url);
$bowling = new Over($bowler);
if (!is_null($row->position)) {
$bowling->SetOverNumber($row->position);
}
if (!is_null($row->balls_bowled)) {
$bowling->SetBalls($row->balls_bowled);
}
if (!is_null($row->no_balls)) {
$bowling->SetNoBalls($row->no_balls);
}
if (!is_null($row->wides)) {
$bowling->SetWides($row->wides);
}
if (!is_null($row->runs_in_over)) {
$bowling->SetRunsInOver($row->runs_in_over);
}
if (intval($row->team_role) == TeamRole::Home()) {
$match->Result()->HomeOvers()->Add($bowling);
} else {
if (intval($row->team_role) == TeamRole::Away()) {
$match->Result()->AwayOvers()->Add($bowling);
}
}
}
$result->closeCursor();
unset($result);
# select overall bowling figures for each bowler
$s_sql = "SELECT mt.match_id, mt.team_role,\r\n\t\tp.player_name, p.player_role, p.short_url,\r\n\t\tb.player_id, b.overs, b.maidens, b.runs_conceded, b.wickets\r\n\t\tFROM nsa_match_team mt\r\n\t\tINNER JOIN nsa_player_match b ON mt.match_team_id = b.match_team_id\r\n\t\tINNER JOIN nsa_player p ON p.player_id = b.player_id\r\n\t\tWHERE mt.team_role IN (" . TeamRole::Home() . "," . TeamRole::Away() . ")\r\n\t\tAND b.wickets IS NOT NULL ";
if (count($a_ids)) {
$s_sql .= "AND mt.match_id IN (" . join(', ', $a_ids) . ') ';
}
$s_sql .= "ORDER BY mt.match_id, mt.match_team_id, b.first_over";
$result = $this->GetDataConnection()->query($s_sql);
while ($row = $result->fetch()) {
$match = $this->GetItemByProperty('GetId', $row->match_id);
if (!$match instanceof Match) {
continue;
}
# shouldn't ever happen
$bowler = new Player($this->GetSettings());
$bowler->SetId($row->player_id);
$bowler->SetName($row->player_name);
$bowler->SetPlayerRole($row->player_role);
$bowler->SetShortUrl($row->short_url);
$figures = new Bowling($bowler);
if (!is_null($row->overs)) {
$figures->SetOvers($row->overs);
}
if (!is_null($row->maidens)) {
$figures->SetMaidens($row->maidens);
}
if (!is_null($row->runs_conceded)) {
$figures->SetRunsConceded($row->runs_conceded);
}
if (!is_null($row->wickets)) {
$figures->SetWickets($row->wickets);
}
if (intval($row->team_role) == TeamRole::Home()) {
$match->Result()->HomeBowling()->Add($figures);
} else {
if (intval($row->team_role) == TeamRole::Away()) {
$match->Result()->AwayBowling()->Add($figures);
}
}
}
$result->closeCursor();
unset($result);
}
/**
* Builds data posted on pages 2/3 back into a match object
* @return Match
*/
private function BuildPostedScorecard()
{
$match = new Match($this->GetSettings());
$match->SetId($this->GetDataObjectId());
# Must have data on which team is which, otherwise none of the rest makes sense
# Team ids are essential for saving data, while team names and match title are
# purely so they can be redisplayed if the page is invalid
$key = "teams";
if (!isset($_POST[$key]) or strpos($_POST[$key], ScorecardEditControl::DATA_SEPARATOR) === false) {
return $match;
}
$teams = explode(ScorecardEditControl::DATA_SEPARATOR, $_POST[$key], 6);
if (count($teams) != 6) {
return $match;
}
switch ($teams[0]) {
case "0":
$match->Result()->SetHomeBattedFirst(false);
$home_batting = $this->GetCurrentPage() == 3;
break;
case "1":
$match->Result()->SetHomeBattedFirst(true);
$home_batting = $this->GetCurrentPage() == 2;
break;
default:
$home_batting = $this->GetCurrentPage() == 2;
}
$home_team = new Team($this->GetSettings());
$home_team->SetId($teams[1]);
$home_team->SetName($teams[2]);
$match->SetHomeTeam($home_team);
$away_team = new Team($this->GetSettings());
$away_team->SetId($teams[3]);
$away_team->SetName($teams[4]);
$match->SetAwayTeam($away_team);
$match->SetTitle($teams[5]);
# Read posted batting data
$key = "batRows";
if (isset($_POST[$key])) {
# This controls not only which fields are read, but also which are redisplayed on an invalid postback or for the next innings.
$match->SetMaximumPlayersPerTeam(intval($_POST[$key]));
}
for ($i = 1; $i <= $match->GetMaximumPlayersPerTeam(); $i++) {
$key = "batName{$i}";
if (isset($_POST[$key])) {
# The row exists - has it been filled in?
if (trim($_POST[$key])) {
# Read the batter data in this row
$player = new Player($this->GetSettings());
$player->SetName($_POST[$key]);
$player->Team()->SetId($home_batting ? $home_team->GetId() : $away_team->GetId());
$key = "batHowOut{$i}";
$how_out = (isset($_POST[$key]) and is_numeric($_POST[$key])) ? (int) $_POST[$key] : null;
$key = "batOutBy{$i}";
$dismissed_by = null;
if (isset($_POST[$key]) and trim($_POST[$key])) {
$dismissed_by = new Player($this->GetSettings());
$dismissed_by->SetName($_POST[$key]);
$dismissed_by->Team()->SetId($home_batting ? $away_team->GetId() : $home_team->GetId());
}
$key = "batBowledBy{$i}";
$bowler = null;
if (isset($_POST[$key]) and trim($_POST[$key])) {
$bowler = new Player($this->GetSettings());
$bowler->SetName($_POST[$key]);
$bowler->Team()->SetId($home_batting ? $away_team->GetId() : $home_team->GetId());
}
# Correct caught and bowled if marked as caught
if ($how_out == Batting::CAUGHT and !is_null($dismissed_by) and !is_null($bowler) and trim($dismissed_by->GetName()) == trim($bowler->GetName())) {
$how_out = Batting::CAUGHT_AND_BOWLED;
$dismissed_by = null;
}
$key = "batRuns{$i}";
$runs = (isset($_POST[$key]) and is_numeric($_POST[$key])) ? (int) $_POST[$key] : null;
$key = "batBalls{$i}";
$balls = (isset($_POST[$key]) and is_numeric($_POST[$key])) ? (int) $_POST[$key] : null;
# Add that batting performance to the match result
$batting = new Batting($player, $how_out, $dismissed_by, $bowler, $runs, $balls);
if ($home_batting) {
$match->Result()->HomeBatting()->Add($batting);
} else {
$match->Result()->AwayBatting()->Add($batting);
}
}
}
}
$key = "batByes";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
$player = new Player($this->GetSettings());
$player->SetPlayerRole(Player::BYES);
$player->Team()->SetId($home_batting ? $home_team->GetId() : $away_team->GetId());
$batting = new Batting($player, null, null, null, (int) $_POST[$key]);
if ($home_batting) {
$match->Result()->HomeBatting()->Add($batting);
} else {
$match->Result()->AwayBatting()->Add($batting);
}
}
$key = "batWides";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
$player = new Player($this->GetSettings());
$player->SetPlayerRole(Player::WIDES);
$player->Team()->SetId($home_batting ? $home_team->GetId() : $away_team->GetId());
$batting = new Batting($player, null, null, null, (int) $_POST[$key]);
if ($home_batting) {
$match->Result()->HomeBatting()->Add($batting);
} else {
$match->Result()->AwayBatting()->Add($batting);
}
}
$key = "batNoBalls";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
$player = new Player($this->GetSettings());
$player->SetPlayerRole(Player::NO_BALLS);
$player->Team()->SetId($home_batting ? $home_team->GetId() : $away_team->GetId());
$batting = new Batting($player, null, null, null, (int) $_POST[$key]);
if ($home_batting) {
$match->Result()->HomeBatting()->Add($batting);
} else {
$match->Result()->AwayBatting()->Add($batting);
}
}
$key = "batBonus";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
$player = new Player($this->GetSettings());
$player->SetPlayerRole(Player::BONUS_RUNS);
$player->Team()->SetId($home_batting ? $home_team->GetId() : $away_team->GetId());
$batting = new Batting($player, null, null, null, (int) $_POST[$key]);
if ($home_batting) {
$match->Result()->HomeBatting()->Add($batting);
} else {
$match->Result()->AwayBatting()->Add($batting);
}
}
$key = "batTotal";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
if ($home_batting) {
$match->Result()->SetHomeRuns($_POST[$key]);
} else {
$match->Result()->SetAwayRuns($_POST[$key]);
}
}
$key = "batWickets";
if (isset($_POST[$key]) and is_numeric($_POST[$key])) {
if ($home_batting) {
$match->Result()->SetHomeWickets($_POST[$key]);
} else {
$match->Result()->SetAwayWickets($_POST[$key]);
}
}
# Read posted bowling data
$key = "bowlerRows";
if (isset($_POST[$key])) {
# This controls not only which fields are read, but also which are redisplayed on an invalid postback or for the next innings.
$match->SetOvers(intval($_POST[$key]));
}
for ($i = 1; $i <= $match->GetOvers(); $i++) {
$key = "bowlerName{$i}";
if (isset($_POST[$key])) {
# The row exists - has it been filled in?
if (trim($_POST[$key])) {
# Read the bowler data in this row
# strlen test allows 0 but not empty string, because is_numeric allows empty string
$player = new Player($this->GetSettings());
$player->SetName($_POST[$key]);
$player->Team()->SetId($home_batting ? $away_team->GetId() : $home_team->GetId());
$key = "bowlerBalls{$i}";
$balls = (isset($_POST[$key]) and is_numeric($_POST[$key]) and strlen(trim($_POST[$key]))) ? (int) $_POST[$key] : null;
$key = "bowlerNoBalls{$i}";
$no_balls = (isset($_POST[$key]) and is_numeric($_POST[$key]) and strlen(trim($_POST[$key]))) ? (int) $_POST[$key] : null;
$key = "bowlerWides{$i}";
$wides = (isset($_POST[$key]) and is_numeric($_POST[$key]) and strlen(trim($_POST[$key]))) ? (int) $_POST[$key] : null;
$key = "bowlerRuns{$i}";
$runs = (isset($_POST[$key]) and is_numeric($_POST[$key]) and strlen(trim($_POST[$key]))) ? (int) $_POST[$key] : null;
# Add that over to the match result
$bowling = new Over($player);
$bowling->SetBalls($balls);
$bowling->SetNoBalls($no_balls);
$bowling->SetWides($wides);
$bowling->SetRunsInOver($runs);
if ($home_batting) {
$match->Result()->AwayOvers()->Add($bowling);
} else {
$match->Result()->HomeOvers()->Add($bowling);
}
}
}
}
return $match;
}