/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $result
*/
protected function BuildItems(MySqlRawData $result)
{
# use CollectionBuilder to handle duplicates
$school_builder = new CollectionBuilder();
$school = null;
while ($row = $result->fetch()) {
# check whether this is a new school
if (!$school_builder->IsDone($row->club_id)) {
# store any exisiting school
if ($school != null) {
$this->Add($school);
}
# create the new school
$school = new School($this->GetSettings());
$school->SetId($row->club_id);
$school->SetName($row->club_name);
$school->SetTypeOfClub($row->club_type);
$school->SetHowManyPlayers($row->how_many_players);
$school->SetAgeRangeLower($row->age_range_lower);
$school->SetAgeRangeUpper($row->age_range_upper);
$school->SetPlaysOutdoors($row->plays_outdoors);
$school->SetPlaysIndoors($row->plays_indoors);
$school->SetShortUrl($row->short_url);
$school->SetTwitterAccount($row->twitter);
$school->SetFacebookUrl($row->facebook);
$school->SetInstagramAccount($row->instagram);
$school->SetClubmarkAccredited($row->clubmark);
# Infer partial address from school name
$school_name = $school->GetName();
$comma = strrpos($school_name, ",");
if ($comma !== false) {
$school->Ground()->GetAddress()->SetTown(trim(substr($school_name, $comma + 1)));
$school->Ground()->GetAddress()->SetPaon(substr($school_name, 0, $comma));
}
}
# team the only cause of multiple rows (so far) so add to current school
if ($row->team_id) {
$team = new Team($this->GetSettings());
$team->SetId($row->team_id);
$team->SetName($row->team_name);
$team->SetShortUrl($row->team_short_url);
$school->Add($team);
}
}
# store final club
if ($school != null) {
$this->Add($school);
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
while ($o_row = $o_result->fetch()) {
# create the new category
$o_category = new Category();
$o_category->SetId($o_row->id);
$o_category->SetName($o_row->name);
$o_category->SetParentId((int) $o_row->parent);
$o_category->SetUrl($o_row->code);
$o_category->SetSortOverride($o_row->sort_override);
$o_category->SetNavigateUrl($o_row->navigate_url);
$o_category->SetHierarchyLevel($o_row->hierarchy_level);
$this->Add($o_category);
}
}
/**
* (non-PHPdoc)
* @see data/DataManager#BuildItems($o_result)
*/
public function BuildItems(MySqlRawData $result)
{
$this->Clear();
while ($o_row = $result->fetch()) {
$o_sub = new Subscription($this->GetSettings());
$o_sub->SetType($o_row->item_type);
$o_sub->SetSubscribeDate($o_row->date_changed);
$o_sub->SetSubscribedItemId($o_row->item_id);
switch ($o_sub->GetType()) {
case ContentType::STOOLBALL_MATCH:
$o_sub->SetTitle($o_row->match_title);
$o_sub->SetContentDate(Date::BritishDate($o_row->start_time));
$o_sub->SetSubscribedItemUrl($o_row->short_url);
break;
}
$this->Add($o_sub);
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $result
*/
protected function BuildItems(MySqlRawData $result)
{
# use CollectionBuilder to handle duplicates
$club_builder = new CollectionBuilder();
$club = null;
while ($row = $result->fetch()) {
# check whether this is a new club
if (!$club_builder->IsDone($row->club_id)) {
# store any exisiting club
if ($club != null) {
$this->Add($club);
}
# create the new club
$club = new Club($this->GetSettings());
$club->SetId($row->club_id);
$club->SetName($row->club_name);
$club->SetTypeOfClub($row->club_type);
$club->SetHowManyPlayers($row->how_many_players);
$club->SetAgeRangeLower($row->age_range_lower);
$club->SetAgeRangeUpper($row->age_range_upper);
$club->SetPlaysOutdoors($row->plays_outdoors);
$club->SetPlaysIndoors($row->plays_indoors);
$club->SetShortUrl($row->short_url);
$club->SetTwitterAccount($row->twitter);
$club->SetFacebookUrl($row->facebook);
$club->SetInstagramAccount($row->instagram);
$club->SetClubmarkAccredited($row->clubmark);
}
# team the only cause of multiple rows (so far) so add to current club
if ($row->team_id) {
$team = new Team($this->GetSettings());
$team->SetId($row->team_id);
$team->SetName($row->team_name);
$team->SetShortUrl($row->team_short_url);
$club->Add($team);
}
}
# store final club
if ($club != null) {
$this->Add($club);
}
}
/**
* Populates the collection of players from raw data
*
* @return bool
* @param MySqlRawData $data
*/
protected function BuildItems(MySqlRawData $data)
{
$this->Clear();
while ($row = $data->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->short_url)) {
$player->SetShortUrl($row->short_url);
}
if (isset($row->update_search) and $row->update_search == 1) {
$player->SetSearchUpdateRequired();
}
$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);
}
$this->Add($player);
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
# use CollectionBuilder to handle duplicates
$o_ground_builder = new CollectionBuilder();
$o_ground = null;
while ($row = $o_result->fetch()) {
# check whether this is a new ground
if (!$o_ground_builder->IsDone($row->ground_id)) {
# store any exisiting ground
if ($o_ground != null) {
$this->Add($o_ground);
}
# create the new ground
$o_ground = new Ground($this->o_settings);
$o_ground->SetId($row->ground_id);
$o_ground->SetDirections($row->directions);
$o_ground->SetParking($row->parking);
$o_ground->SetFacilities($row->facilities);
$o_ground->SetShortUrl($row->short_url);
$o_ground->SetDateUpdated($row->date_changed);
if (isset($row->update_search) and $row->update_search == 1) {
$o_ground->SetSearchUpdateRequired();
}
$o_address = $o_ground->GetAddress();
$o_address->SetSaon($row->saon);
$o_address->SetPaon($row->paon);
$o_address->SetStreetDescriptor($row->street_descriptor);
$o_address->SetLocality($row->locality);
$o_address->SetTown($row->town);
$o_address->SetAdministrativeArea($row->administrative_area);
$o_address->SetPostcode($row->postcode);
if (isset($row->latitude)) {
$o_address->SetGeoLocation($row->latitude, $row->longitude, $row->geo_precision);
}
$o_ground->SetAddress($o_address);
}
if (isset($row->team_name)) {
$team = new Team($this->GetSettings());
$team->SetName($row->team_name);
$team->SetShortUrl($row->team_short_url);
$team->SetPlayerType($row->player_type_id);
$o_ground->Teams()->Add($team);
}
}
# store final ground
if ($o_ground != null) {
$this->Add($o_ground);
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
$this->Clear();
$o_match_builder = new CollectionBuilder();
$o_team_builder = new CollectionBuilder();
$o_tournament_match_builder = new CollectionBuilder();
$season_builder = new CollectionBuilder();
while ($o_row = $o_result->fetch()) {
if (!$o_match_builder->IsDone($o_row->match_id)) {
if (isset($o_match)) {
$this->Add($o_match);
$o_team_builder->Reset();
$o_tournament_match_builder->Reset();
$season_builder->Reset();
}
# create new
$o_match = new Match($this->GetSettings());
$this->BuildMatchSummary($o_match, $o_row);
if ($o_match->GetMatchType() == MatchType::TOURNAMENT_MATCH and isset($o_row->tournament_match_id)) {
$o_tourn = new Match($this->o_settings);
$o_tourn->SetMatchType(MatchType::TOURNAMENT);
$o_tourn->SetId($o_row->tournament_match_id);
if (isset($o_row->tournament_title)) {
$o_tourn->SetTitle($o_row->tournament_title);
}
if (isset($o_row->tournament_url)) {
$o_tourn->SetShortUrl($o_row->tournament_url);
}
$o_match->SetTournament($o_tourn);
unset($o_tourn);
}
if (isset($o_row->home_team_id) and !is_null($o_row->home_team_id)) {
$o_home = new Team($this->o_settings);
$o_home->SetId($o_row->home_team_id);
if (isset($o_row->home_team_name)) {
$o_home->SetName($o_row->home_team_name);
}
if (isset($o_row->home_short_url)) {
$o_home->SetShortUrl($o_row->home_short_url);
}
$o_match->SetHomeTeam($o_home);
unset($o_home);
}
$this->BuildGround($o_match, $o_row);
}
# Add away teams
if (isset($o_row->away_team_id) && !$o_team_builder->IsDone($o_row->away_team_id)) {
$o_away = new Team($this->o_settings);
$o_away->SetId($o_row->away_team_id);
if (isset($o_row->away_team_name)) {
$o_away->SetName($o_row->away_team_name);
}
if (isset($o_row->away_short_url)) {
$o_away->SetShortUrl($o_row->away_short_url);
}
$o_match->AddAwayTeam($o_away);
unset($o_away);
}
# Add matches in tournament
if (isset($o_row->match_id_in_tournament) and is_numeric($o_row->match_id_in_tournament) and !$o_tournament_match_builder->IsDone($o_row->match_id_in_tournament)) {
$o_tmatch = new Match($this->o_settings);
$o_tmatch->SetMatchType(MatchType::TOURNAMENT_MATCH);
$o_tmatch->SetId($o_row->match_id_in_tournament);
$o_tmatch->SetTitle($o_row->tournament_match_title);
$o_tmatch->SetShortUrl($o_row->tournament_match_url);
$o_tmatch->SetStartTime($o_row->tournament_match_time);
$o_tmatch->SetIsStartTimeKnown($o_row->tournament_match_start_time_known);
$o_tmatch->SetOrderInTournament($o_row->order_in_tournament);
$o_match->AddMatchInTournament($o_tmatch);
unset($o_tmatch);
}
# Add seasons
$this->BuildSeason($o_match, $o_row, $season_builder);
}
# Add final match
if (isset($o_match)) {
$this->Add($o_match);
}
return true;
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
$this->Clear();
/* @var $o_team Team */
# use CollectionBuilder to handle duplicates
$o_team_builder = new CollectionBuilder();
$o_season_builder = new CollectionBuilder();
$o_team = null;
while ($row = $o_result->fetch()) {
# check whether this is a new team
if (!$o_team_builder->IsDone($row->team_id)) {
# store any exisiting team
if ($o_team != null) {
$this->Add($o_team);
$o_season_builder->Reset();
}
# create the new team
$o_team = new Team($this->o_settings);
$o_team->SetId($row->team_id);
$o_team->SetName($row->team_name);
if (isset($row->website)) {
$o_team->SetWebsiteUrl($row->website);
}
if (isset($row->active)) {
$o_team->SetIsActive($row->active);
}
if (isset($row->team_type)) {
$o_team->SetTeamType($row->team_type);
}
if (isset($row->intro)) {
$o_team->SetIntro($row->intro);
}
if (isset($row->playing_times)) {
$o_team->SetPlayingTimes($row->playing_times);
}
if (isset($row->cost)) {
$o_team->SetCost($row->cost);
}
if (isset($row->contact)) {
$o_team->SetContact($row->contact);
}
if (isset($row->contact_nsa)) {
$o_team->SetPrivateContact($row->contact_nsa);
}
if (isset($row->short_url)) {
$o_team->SetShortUrl($row->short_url);
}
if (isset($row->player_type_id)) {
$o_team->SetPlayerType($row->player_type_id);
}
$o_team->SetSchoolYears(array(1 => isset($row->year1) and $row->year1, 2 => isset($row->year2) and $row->year2, 3 => isset($row->year3) and $row->year3, 4 => isset($row->year4) and $row->year4, 5 => isset($row->year5) and $row->year5, 6 => isset($row->year6) and $row->year6, 7 => isset($row->year7) and $row->year7, 8 => isset($row->year8) and $row->year8, 9 => isset($row->year9) and $row->year9, 10 => isset($row->year10) and $row->year10, 11 => isset($row->year11) and $row->year11, 12 => isset($row->year12) and $row->year12));
if (isset($row->update_search) and $row->update_search == 1) {
$o_team->SetSearchUpdateRequired();
}
if (isset($row->date_changed)) {
$o_team->SetLastAudit(new AuditData($row->modified_by_id, $row->known_as, $row->date_changed));
}
$club = new Club($this->GetSettings());
if (isset($row->club_id)) {
$club->SetId($row->club_id);
if (isset($row->club_name)) {
$club->SetName($row->club_name);
}
if (isset($row->twitter)) {
$club->SetTwitterAccount($row->twitter);
}
if (isset($row->facebook)) {
$club->SetFacebookUrl($row->facebook);
}
if (isset($row->instagram)) {
$club->SetInstagramAccount($row->instagram);
}
if (isset($row->clubmark)) {
$club->SetClubmarkAccredited($row->clubmark);
}
if (isset($row->club_short_url)) {
$club->SetShortUrl($row->club_short_url);
}
}
# If the website is actually a Facebook page, move it, overriding the club Facebook page is necessary
if (strpos($o_team->GetWebsiteUrl(), 'facebook.com/') !== false) {
$club->SetFacebookUrl($o_team->GetWebsiteUrl());
$o_team->SetWebsiteUrl('');
}
$o_team->SetClub($club);
if (isset($row->ground_id) and $row->ground_id) {
$o_ground = new Ground($this->o_settings);
$o_ground->SetId($row->ground_id);
$address = $o_ground->GetAddress();
if (isset($row->saon)) {
$address->SetSaon($row->saon);
}
if (isset($row->town)) {
if (isset($row->paon)) {
$address->SetPaon($row->paon);
}
if (isset($row->street_descriptor)) {
$address->SetStreetDescriptor($row->street_descriptor);
}
if (isset($row->locality)) {
$address->SetLocality($row->locality);
}
$address->SetTown($row->town);
if (isset($row->administrative_area)) {
$address->SetAdministrativeArea($row->administrative_area);
}
if (isset($row->postcode)) {
$address->SetPostcode($row->postcode);
}
if (isset($row->latitude)) {
$address->SetGeoLocation($row->latitude, $row->longitude, null);
}
$o_ground->SetAddress($address);
}
if (isset($row->ground_short_url)) {
$o_ground->SetShortUrl($row->ground_short_url);
}
$o_team->SetGround($o_ground);
}
}
# Competition/Season a cause of multiple rows
if (isset($row->season_id) and !$o_season_builder->IsDone($row->season_id) and isset($row->competition_id)) {
$o_season = new Season($this->o_settings);
$o_season->SetId($row->season_id);
$o_season->SetName($row->season_name);
$o_season->SetIsLatest($row->is_latest);
$o_season->SetStartYear($row->start_year);
$o_season->SetEndYear($row->end_year);
if (isset($row->season_short_url)) {
$o_season->SetShortUrl($row->season_short_url);
}
$o_competition = new Competition($this->o_settings);
$o_competition->SetId($row->competition_id);
$o_competition->SetName($row->competition_name);
$o_season->SetCompetition($o_competition);
$o_team->Seasons()->Add(new TeamInSeason(null, $o_season, isset($row->withdrawn_league) ? $row->withdrawn_league : null));
unset($o_season);
unset($o_competition);
}
}
# store final team
if ($o_team != null) {
$this->Add($o_team);
}
return true;
}
/**
* Builds the short URL data from the database into a collection of short URLs
*
* @param MySqlRawData $o_result
*/
public function BuildItems(MySqlRawData $o_result)
{
if ($this->o_current_format instanceof ShortUrlFormat) {
$s_url_field = $this->o_current_format->GetShortUrlField();
while ($o_row = $o_result->fetch()) {
if (isset($o_row->{$s_url_field})) {
$url = new ShortUrl();
$url->SetFormat($this->o_current_format);
$url->SetShortUrl($o_row->{$s_url_field});
$a_param_values = array();
foreach ($this->o_current_format->GetParameterFields() as $s_param_field) {
$s_param_field = (string) $s_param_field;
if (isset($o_row->{$s_param_field})) {
$a_param_values[] = $o_row->{$s_param_field};
}
}
$url->SetParameterValues($a_param_values);
$this->Add($url);
}
}
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
/* @var $o_season Season */
$this->Clear();
# use CollectionBuilder to handle duplicates
$o_season_builder = new CollectionBuilder();
$o_team_builder = new CollectionBuilder();
$o_rule_builder = new CollectionBuilder();
$o_points_builder = new CollectionBuilder();
$o_type_builder = new CollectionBuilder();
$o_season = null;
while ($o_row = $o_result->fetch()) {
# check whether this is a new season
if (!$o_season_builder->IsDone($o_row->season_id)) {
# store any exisiting season and reset
if ($o_season != null) {
$this->Add($o_season);
$o_team_builder->Reset();
$o_rule_builder->Reset();
$o_points_builder->Reset();
$o_type_builder->Reset();
}
# create the new season
$o_season = new Season($this->GetSettings());
$this->BuildSeason($o_season, $o_row);
}
# Teams the first cause of multiple rows
if (isset($o_row->team_id)) {
if (!$o_team_builder->IsDone($o_row->team_id)) {
if (isset($o_team)) {
unset($o_team);
}
$o_team = new Team($this->GetSettings());
$o_team->SetId($o_row->team_id);
$o_team->SetName($o_row->team_name);
$ground = new Ground($this->GetSettings());
$ground->SetId($o_row->team_ground_id);
$o_team->SetGround($ground);
if (isset($o_row->team_short_url)) {
$o_team->SetShortUrl($o_row->team_short_url);
}
$o_season->AddTeam($o_team);
if (isset($o_row->withdrawn_league) and (bool) $o_row->withdrawn_league) {
$o_season->TeamsWithdrawnFromLeague()->Add($o_team);
}
}
# Points adjustments - should come with team and in order of team
if (isset($o_row->point_id) and !$o_points_builder->IsDone($o_row->point_id)) {
$o_point = new PointsAdjustment($o_row->point_id, $o_row->points, $o_team, $o_row->reason, $o_row->points_date);
$o_season->PointsAdjustments()->Add($o_point);
}
}
# Season rules
if (isset($o_row->season_rule_id) and !$o_rule_builder->IsDone($o_row->season_rule_id)) {
$o_mr = new MatchResult($o_row->match_result_id);
$o_mr->SetHomePoints($o_row->home_points);
$o_mr->SetAwayPoints($o_row->away_points);
$o_season->PossibleResults()->Add($o_mr);
unset($o_mr);
}
# Match types
if (isset($o_row->season_match_type) and !$o_type_builder->IsDone($o_row->season_match_type)) {
$o_season->MatchTypes()->Add((int) $o_row->season_match_type);
}
}
# store final season
if ($o_season != null) {
$this->Add($o_season);
}
return true;
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
$this->Clear();
$o_match_builder = new CollectionBuilder();
$o_team_builder = new CollectionBuilder();
while ($o_row = $o_result->fetch()) {
if (!$o_match_builder->IsDone($o_row->match_id)) {
if (isset($o_match)) {
$this->Add($o_match);
$o_team_builder->Reset();
}
# create new
$o_match = new Match($this->GetSettings());
$o_match->SetId($o_row->match_id);
if (isset($o_row->start_time)) {
$o_match->SetStartTime($o_row->start_time);
}
if (isset($o_row->home_runs)) {
$o_match->Result()->SetHomeRuns($o_row->home_runs);
}
if (isset($o_row->away_runs)) {
$o_match->Result()->SetAwayRuns($o_row->away_runs);
}
if (isset($o_row->match_result_id)) {
$o_match->Result()->SetResultType($o_row->match_result_id);
}
if (isset($o_row->home_team_id) and !is_null($o_row->home_team_id)) {
$o_home = new Team($this->o_settings);
$o_home->SetId($o_row->home_team_id);
if (isset($o_row->home_team_name)) {
$o_home->SetName($o_row->home_team_name);
}
if (isset($o_row->home_short_url)) {
$o_home->SetShortUrl($o_row->home_short_url);
}
$o_match->SetHomeTeam($o_home);
unset($o_home);
}
if (isset($o_row->ground_id)) {
$o_ground = new Ground($this->GetSettings());
$o_ground->SetId($o_row->ground_id);
$o_match->SetGround($o_ground);
unset($o_ground);
}
}
# Add away teams
if (isset($o_row->away_team_id) && !$o_team_builder->IsDone($o_row->away_team_id)) {
$o_away = new Team($this->o_settings);
$o_away->SetId($o_row->away_team_id);
if (isset($o_row->away_team_name)) {
$o_away->SetName($o_row->away_team_name);
}
if (isset($o_row->away_short_url)) {
$o_away->SetShortUrl($o_row->away_short_url);
}
$o_match->AddAwayTeam($o_away);
unset($o_away);
}
}
# Add final match
if (isset($o_match)) {
$this->Add($o_match);
}
return true;
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $result
*/
protected function BuildItems(MySqlRawData $result)
{
$this->Clear();
# use CollectionBuilder to handle duplicates
$user_builder = new CollectionBuilder();
$roles = new CollectionBuilder();
$role_class_loaded = false;
$user = null;
while ($row = $result->fetch()) {
# check whether this is a new person
if (!$user_builder->IsDone($row->user_id)) {
# store any exisiting person
if ($user != null) {
$this->Add($user);
$roles->Reset();
}
# create the new person
$user = new User();
$user->SetId($row->user_id);
$user->SetName($row->known_as);
if (isset($row->name_first)) {
$user->SetFirstName($row->name_first);
}
if (isset($row->name_last)) {
$user->SetLastName($row->name_last);
}
if (isset($row->email)) {
$user->SetEmail($row->email);
}
if (isset($row->gender)) {
$user->SetGender($row->gender);
}
if (isset($row->occupation)) {
$user->SetOccupation($row->occupation);
}
if (isset($row->interests)) {
$user->SetInterests($row->interests);
}
if (isset($row->location)) {
$user->SetLocation($row->location);
}
if (isset($row->sign_up_date)) {
$user->SetSignUpDate($row->sign_up_date);
}
if (isset($row->total_messages)) {
$user->SetTotalMessages($row->total_messages);
}
if (isset($row->disabled)) {
$user->SetAccountDisabled($row->disabled);
}
}
# Add security roles
if (isset($row->role_id) and !$roles->IsDone($row->role_id)) {
if (!$role_class_loaded) {
require_once "authentication/role.class.php";
$role_class_loaded = true;
}
$role = new Role($row->role_id, $row->role);
$user->Roles()->Add($role);
}
}
# store final person
if ($user != null) {
$this->Add($user);
}
}
/**
* Populates the collection of business objects from raw data
*
* @return bool
* @param MySqlRawData $o_result
*/
protected function BuildItems(MySqlRawData $o_result)
{
/* @var $o_competition Competition */
# use CollectionBuilder to handle duplicates
$o_comp_builder = new CollectionBuilder();
$o_season_builder = new CollectionBuilder();
$o_team_builder = new CollectionBuilder();
$o_points_builder = new CollectionBuilder();
$o_matchtype_builder = new CollectionBuilder();
$o_competition = null;
$o_season = null;
while ($o_row = $o_result->fetch()) {
# check whether this is a new competition
if (!$o_comp_builder->IsDone($o_row->competition_id)) {
# store any exisiting competition and reset
if ($o_competition != null) {
if ($o_season != null) {
$o_competition->AddSeason($o_season, true);
}
$o_season = null;
$o_matchtype_builder->Reset();
$this->Add($o_competition);
$o_season_builder->Reset();
}
# create the new competition
$o_competition = new Competition($this->o_settings);
$o_competition->SetId($o_row->competition_id);
$o_competition->SetName($o_row->competition_name);
if (isset($o_row->intro)) {
$o_competition->SetIntro($o_row->intro);
}
if (isset($o_row->contact)) {
$o_competition->SetContact($o_row->contact);
}
if (isset($o_row->notification_email)) {
$o_competition->SetNotificationEmail($o_row->notification_email);
}
if (isset($o_row->website)) {
$o_competition->SetWebsiteUrl($o_row->website);
}
if (isset($o_row->short_url)) {
$o_competition->SetShortUrl($o_row->short_url);
}
if (isset($o_row->active)) {
$o_competition->SetIsActive($o_row->active);
}
if (isset($o_row->players_per_team)) {
$o_competition->SetMaximumPlayersPerTeam($o_row->players_per_team);
}
if (isset($o_row->overs)) {
$o_competition->SetOvers($o_row->overs);
}
$o_competition->SetPlayerType($o_row->player_type_id);
if (isset($o_row->update_search) and $o_row->update_search == 1) {
$o_competition->SetSearchUpdateRequired();
}
if (isset($o_row->category_id) && !is_null($o_row->category_id)) {
$cat = new Category();
$cat->SetId($o_row->category_id);
if (isset($o_row->category_name)) {
$cat->SetName($o_row->category_name);
}
if (isset($o_row->code)) {
$cat->SetUrl($o_row->code);
}
$o_competition->SetCategory($cat);
}
}
# Seasons are the first cause of multiple rows (first in sort order after competition)
if (isset($o_row->season_id)) {
if (!$o_season_builder->IsDone($o_row->season_id)) {
if ($o_season != null) {
$o_competition->AddSeason($o_season, true);
}
$o_season = new Season($this->o_settings);
$o_season->SetId($o_row->season_id);
$o_season->SetName($o_row->season_name);
$o_season->SetIsLatest($o_row->is_latest);
$o_season->SetStartYear($o_row->start_year);
$o_season->SetEndYear($o_row->end_year);
if (isset($o_row->season_intro)) {
$o_season->SetIntro($o_row->season_intro);
}
if (isset($o_row->results)) {
$o_season->SetResults($o_row->results);
}
if (isset($o_row->show_table)) {
$o_season->SetShowTable($o_row->show_table);
}
if (isset($o_row->show_runs_scored)) {
$o_season->SetShowTableRunsScored($o_row->show_runs_scored);
}
if (isset($o_row->show_runs_conceded)) {
$o_season->SetShowTableRunsConceded($o_row->show_runs_conceded);
}
if (isset($o_row->season_short_url)) {
$o_season->SetShortUrl($o_row->season_short_url);
}
}
# Team only present if there is a season
if (isset($o_row->team_id)) {
if (!$o_team_builder->IsDone($o_row->team_id)) {
if (isset($o_team)) {
unset($o_team);
}
$o_team = new Team($this->GetSettings());
$o_team->SetId($o_row->team_id);
$o_team->SetName($o_row->team_name);
$o_team->GetGround()->SetId($o_row->ground_id);
if (isset($o_row->team_short_url)) {
$o_team->SetShortUrl($o_row->team_short_url);
}
$o_season->AddTeam($o_team);
if (isset($o_row->withdrawn_league) and (bool) $o_row->withdrawn_league) {
$o_season->TeamsWithdrawnFromLeague()->Add($o_team);
}
}
# Points adjustments - should come with team and in order of team
if (isset($o_row->point_id) and !$o_points_builder->IsDone($o_row->point_id)) {
$o_point = new PointsAdjustment($o_row->point_id, $o_row->points, $o_team, $o_row->reason, $o_row->points_date);
$o_season->PointsAdjustments()->Add($o_point);
}
}
# Match types come with a season
if (isset($o_row->match_type) and !$o_matchtype_builder->IsDone($o_row->match_type)) {
$o_season->MatchTypes()->Add((int) $o_row->match_type);
}
}
}
# store final competition
if ($o_competition != null) {
if ($o_season != null) {
$o_competition->AddSeason($o_season, true);
}
$this->Add($o_competition);
}
}
