private function getAllSeasonTeamPlayers()
{
$players = array();
$query = db_select('season_team_player', 'stp');
$query->innerJoin('player', 'p', 'p.playerid = stp.playerid');
$query->fields('p');
$query->addField('stp', 'number');
$query->addField('stp', 'season_team_playerid');
$query->addField('stp', 'season_teamid');
$query->condition('season_teamid', $this->getSeasonTeamId());
$query->orderBy('p.last_name');
$query->orderBy('p.first_name');
$result = $query->execute();
while ($record = $result->fetchAssoc()) {
$seasonTeamPlayer = new SeasonTeamPlayer($record['season_team_playerid'], $record['season_teamid'], $record['playerid'], $record['number'], $record['first_name'], $record['last_name']);
$seasonTeamPlayer->setSavedDateTimeAndUser($record['saved_datetime'], $record['saved_userid']);
array_push($players, $seasonTeamPlayer);
}
return $players;
}
private function history()
{
$current = new SeasonTeamPlayer($this->getSeasonTeamPlayerId());
$current->build();
db_insert('season_team_player_history')->fields(array('season_team_playerid' => $current->getSeasonTeamPlayerId(), 'season_teamid' => $current->getSeasonTeamId(), 'playerid' => $current->getPlayerId(), 'number' => $current->getNumber(), 'saved_userid' => $current->getSavedUserID(), 'saved_datetime' => $current->getSavedDateTime(), 'history_userid' => $this->getSavedUserID(), 'history_datetime' => $this->getSavedDateTime()))->execute();
}
