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(); }