/**
*
* @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);
}
