/**
*
* @param Game $oGame
*/
public static function updatePenaltyMinutes(TeamPerson $oTeamPerson = null)
{
$query = 'UPDATE TeamPerson
SET Game.actions_retrieved = 1
WHERE
(
SELECT COUNT(GameAction.ID)
FROM GameAction
LEFT JOIN GameActionType ON GameActionType.id = GameAction.type_id
WHERE
GameActionType.is_goal = 1
AND
Game.nefub_id = GameAction.game_nefub_id
) >= Game.team1_score + Game.team2_score';
if ($oGame) {
$query .= " AND TeamPerson.id = '" . $oTeamPerson->getId() . "'";
}
Database::query($query);
}
/**
*
* @return array
*/
public function getTeamPersons($includeTransferedFrom = true, $includeTransferedTo = true)
{
$where = '';
if (!$includeTransferedTo) {
$where .= " AND TeamPerson.transfered != 1";
}
if (!$includeTransferedFrom) {
$where .= " AND TeamPerson.transfered != -1";
}
$query = "SELECT TeamPerson.id\n\t\t\t\t\tFROM TeamPerson\n\t\t\t\t\tLEFT JOIN Team ON Team.nefub_id = TeamPerson.team_nefub_id\n\t\t\t\t\tWHERE\n\t\t\t\t\tTeamPerson.person_nefub_id = '" . $this->nefub_id . "'\n\t\t\t\t\tAND Team.season_nefub_id = '" . Season::getInstance()->nefub_id . "'\n\t\t\t\t\t{$where}\n\t\t\t\t\tGROUP BY TeamPerson.team_nefub_id\n\t\t\t\t\tORDER BY TeamPerson.team_nefub_id ASC";
return TeamPerson::getAllFromQuery($query);
}
/**
* @return array()
*/
public function getTeamPersons()
{
$return = array();
$players = TeamPerson::getAll(array('team_nefub_id' => $this->nefub_id));
foreach ($players as $player) {
$key = strtolower($player->getPerson()->name);
if ($player->added) {
$key = "'" . $key;
} elseif ($player->removed) {
$key = "zzzz" . $key;
}
$return[$key] = $player;
}
ksort($return);
return $return;
}
/**
*
* @param stdClass $teamPerson
* @param Team $oTeam
*/
private function convertTeamPerson(stdClass $teamPerson, Team $oTeam)
{
$oTeamPerson = TeamPerson::getByNefubID($teamPerson->Player->ID, $oTeam->nefub_id);
if (!$oTeamPerson) {
$oTeamPerson = new TeamPerson();
$oTeamPerson->team_nefub_id = $oTeam->nefub_id;
$oTeamPerson->person_nefub_id = $teamPerson->Player->ID;
$this->addedNefubObject($oTeamPerson);
self::put('Speler ' . $teamPerson->Player->Name . ' aan team ' . $oTeam->name . ' toegevoegd');
} else {
self::put('Update statistieken van speler ' . $teamPerson->Player->Name . ' in team ' . $oTeam->name);
}
$oTeamPerson->shirt_number = $teamPerson->Number;
$oTeamPerson->games_played = $teamPerson->Statistics->{'Number of Games'};
$oTeamPerson->goals = $teamPerson->Statistics->Goals;
$oTeamPerson->assists = $teamPerson->Statistics->Assists;
$oTeamPerson->penalty_minutes = $teamPerson->Statistics->{'Penalty Time'};
if ($teamPerson->Transfer == "Joined") {
$oTeamPerson->transfered = 1;
} elseif ($teamPerson->Transfer == "Left") {
$oTeamPerson->transfered = -1;
}
$oTeamPerson->save();
}
protected function showTeamPersons()
{
switch ($this->mode) {
case 'bewerken':
$oTeamPerson = new TeamPerson($this->editId);
$this->editObject($oTeamPerson);
break;
default:
$aTeamPersons = TeamPerson::getAll(array(), 'id', 'asc');
$this->assign('aTeamPersons', $aTeamPersons);
$this->template = '/personen.tpl';
$this->showOutput();
}
}
