/**
* @test
*/
public function testRoll()
{
$bowling = new Bowling();
for ($i = 0; $i < 50; $i++) {
$score = $bowling->roll();
$this->assertThat($score, $this->greaterThanOrEqual(0), 'スコアは0以上');
$this->assertThat($score, $this->lessThanOrEqual(Bowling::MAX_PINS_PER_ROLL), 'スコアは10以内');
$this->assertThat($score, $this->logicalAnd($this->greaterThanOrEqual(0), $this->lessThanOrEqual(Bowling::MAX_PINS_PER_ROLL)), 'スコアは0以上10以内');
}
}
public function test_TwoSpare_42()
{
$game = new Bowling();
$game->frame(8, 2);
$game->frame(8, 2);
$game->frame(6, 2);
//spare
$result = $game->result();
$this->assertEquals(42, $result);
}
/**
* 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);
}
public function OnLoadPageData()
{
# Now get statistics for the player
$filter_by_player = array($this->player->GetId());
$statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
$statistics_manager->FilterByPlayer($filter_by_player);
# Apply filters common to all statistics
StatisticsFilter::SupportMatchTypeFilter($statistics_manager);
StatisticsFilter::SupportOppositionFilter($statistics_manager);
StatisticsFilter::SupportCompetitionFilter($statistics_manager);
StatisticsFilter::ApplySeasonFilter($this->GetSettings(), $this->GetDataConnection(), $statistics_manager);
StatisticsFilter::SupportGroundFilter($statistics_manager);
StatisticsFilter::SupportDateFilter($statistics_manager);
StatisticsFilter::SupportBattingPositionFilter($statistics_manager);
StatisticsFilter::SupportInningsFilter($statistics_manager);
StatisticsFilter::SupportMatchResultFilter($statistics_manager);
# Now get the statistics for the player
$this->player = new Player($this->GetSettings());
$data = $statistics_manager->ReadBestBowlingPerformance(true);
foreach ($data as $performance) {
# Not useful for either average or economy
if (is_null($performance["runs_conceded"])) {
continue;
}
$bowling = new Bowling($this->player);
$bowling->SetWickets($performance["wickets"]);
$bowling->SetRunsConceded($performance["runs_conceded"]);
$bowling->SetOvers($performance["overs"]);
$match = new Match($this->GetSettings());
$match->SetStartTime($performance["match_time"]);
$bowling->SetMatch($match);
$this->player->Bowling()->Add($bowling);
}
$statistics_manager->FilterByPlayer(null);
$statistics_manager->FilterByBowler($filter_by_player);
$statistics_manager->FilterByHowOut(array(Batting::BODY_BEFORE_WICKET, Batting::BOWLED, Batting::CAUGHT, Batting::CAUGHT_AND_BOWLED, Batting::HIT_BALL_TWICE));
$this->player->SetHowWicketsTaken($statistics_manager->ReadHowWicketsFall());
unset($statistics_manager);
# How dismissed
?>
{
<?php
if ($this->player->Bowling()->GetCount()) {
?>
"economy": {
"labels": [<?php
echo $this->BuildBowlingTimeline($this->player->Bowling()->GetItems());
?>
],
"datasets": [
{
"label": "Economy in each match",
"data": [<?php
echo $this->BuildMatchEconomyData($this->player->Bowling()->GetItems());
?>
]
},
{
"label": "Economy overall",
"data": [<?php
echo $this->BuildEconomyData($this->player->Bowling()->GetItems());
?>
]
}
]
},
"bowlingAverage": {
"labels": [<?php
echo $this->BuildBowlingTimeline($this->player->Bowling()->GetItems());
?>
],
"datasets": [
{
"label": "Average in each match",
"data": [<?php
echo $this->BuildMatchBowlingAverageData($this->player->Bowling()->GetItems());
?>
]
},
{
"label": "Average overall",
"data": [<?php
echo $this->BuildBowlingAverageData($this->player->Bowling()->GetItems());
?>
]
}
]
},
<?php
}
?>
"wickets": [
<?php
$how_out = $this->player->GetHowWicketsTaken();
$len = count($how_out);
$count = 0;
foreach ($how_out as $key => $value) {
$label = ucfirst(html_entity_decode(Batting::Text($key)));
echo '{ "label":"' . $label . '","value":' . $value . "}";
$count++;
if ($count < $len) {
echo ',';
}
}
?>
]
}
<?php
exit;
}
/**
* @dataProvider testProvidergetGameScore
*/
public function testGameScore($sequence, $expected)
{
$b = new Bowling();
$this->assertEquals($expected, $b->getGameScore($sequence));
}
/**
* @dataProvider dataProvider
*/
public function testGames($score, $rolls)
{
$bowling = new Bowling();
$this->assertEquals($score, $bowling->score($rolls));
}
public function testScore()
{
$game = new Bowling();
$game->roll(5, 5);
$this->assertEquals(10, $game->score());
}
public function testAllStrikesButTheLastOne()
{
$game = new Bowling('XXXXXXXXXX11');
$this->assertEquals(8 * 30 + 22 + 12, $game->score());
}
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 or $this->player_unfiltered->GetPlayerRole() !== Player::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_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->ReadBestPlayerAggregate("catches");
$this->player->SetCatches(count($data) ? $data[0]["statistic"] : 0);
$data = $statistics_manager->ReadBestPlayerAggregate("run_outs");
$this->player->SetRunOuts(count($data) ? $data[0]["statistic"] : 0);
if ($this->player->GetPlayerRole() == Player::PLAYER) {
$data = $statistics_manager->ReadBestPlayerAggregate("player_of_match");
$this->player->SetTotalPlayerOfTheMatchNominations(count($data) ? $data[0]["statistic"] : 0);
}
$data = $statistics_manager->ReadBestBowlingPerformance();
foreach ($data as $performance) {
$bowling = new Bowling($this->player);
$bowling->SetOvers($performance["overs"]);
$bowling->SetMaidens($performance["maidens"]);
$bowling->SetRunsConceded($performance["runs_conceded"]);
$bowling->SetWickets($performance["wickets"]);
$this->player->Bowling()->Add($bowling);
}
unset($statistics_manager);
}
}
