public function searchRegistrationByTeamId($teamId)
{
// the SQL query to be executed on the database
$query = "SELECT REGISTRATION_ID, CONVERT(VARCHAR(10),REGISTRATION_ACTIVITY_DATE, 101) AS REGISTRATION_ACTIVITY_DATE,\r\n TOURNAMENT_ID, TOURNAMENT_NAME, CONVERT(VARCHAR(10), TOURNAMENT_DATE, 101) AS TOURNAMENT_DATE, \r\n Right(IsNull(Convert(Varchar,TOURNAMENT_BEGIN_TIME,100),''),7) AS TOURNAMENT_BEGIN_TIME, \r\n Right(IsNull(Convert(Varchar,TOURNAMENT_END_TIME,100),''),7) AS TOURNAMENT_END_TIME, \r\n TOURNAMENT_STREET, \r\n TOURNAMENT_CITY, \r\n TOURNAMENT_STATE_CODE, \r\n TOURNAMENT_ZIP,\r\n TEAM_ID, TEAM_NAME,\r\n SPORT_TYPE_ID, SPORT_TYPE_NAME\r\n FROM dbo.REGISTRATION reg JOIN dbo.TEAM t on (reg.REGISTRATION_TEAM_ID = t.TEAM_ID) \r\n JOIN dbo.TOURNAMENT tour on(reg.REGISTRATION_TEAM_TOURNAMENT_ID = tour.TOURNAMENT_ID)\r\n join dbo.SPORT_TYPE sp ON (sp.SPORT_TYPE_ID = tour.TOURNAMENT_SPORT_TYPE_ID) WHERE t.TEAM_ID =" . $teamId;
$results = executeQuery($query);
$regList = new ArrayObject();
foreach ($results as $result) {
$regVO = new RegistrationVO();
$regVO->set_registrationId($result['REGISTRATION_ID']);
$regVO->set_activityDate($result['REGISTRATION_ACTIVITY_DATE']);
$tournament = new Tournament();
$tournament->set_tournamentName($result['TOURNAMENT_NAME']);
$tournament->set_tournamentDate($result['TOURNAMENT_DATE']);
$tournament->set_tournamentBeginTime($result['TOURNAMENT_BEGIN_TIME']);
$tournament->set_tournamentEndTime($result['TOURNAMENT_END_TIME']);
$tournament->set_sportTypeId($result['SPORT_TYPE_ID']);
$tournament->set_sportTypeName($result['SPORT_TYPE_NAME']);
$tournament->set_tournamentStreet($result['TOURNAMENT_STREET']);
$tournament->set_tourcenameCity($result['TOURNAMENT_CITY']);
$tournament->set_tournamentState($result['TOURNAMENT_STATE_CODE']);
$tournament->set_tournamentZip($result['TOURNAMENT_ZIP']);
$team = new TeamVO();
$team->set_teamId($result['TEAM_ID']);
$team->set_teamName($result['TEAM_NAME']);
$regVO->set_tournament($tournament);
$regVO->set_team($team);
$regList->append($regVO);
}
return $regList;
}
