/**
* Defines many-to-many relation with team model via table team_has_player
* @return list of teams to which belongs player
*/
public function getTeams()
{
return $this->hasMany(Team::className(), ['id' => 'team_id'])->viaTable('team_has_player', ['player_id' => 'id'])->select('*, (SELECT is_capitan FROM team_has_player WHERE player_id=' . $this->id . ' AND team_id=teams.id LIMIT 1) as is_capitan');
}
public function actions()
{
return ['galleryApi' => ['class' => GalleryManagerAction::className(), 'types' => ['team' => Team::className()]]];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getHome()
{
return $this->hasOne(Team::className(), ['TeamID' => 'HomeID']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getTeams()
{
return $this->hasMany(Team::className(), ['id' => 'team_id'])->viaTable('splatfest_team', ['fest_id' => 'id']);
}
/**
* Defines one-to-many relation with Team model
* (return team which has planned game)
* @return \yii\db\ActiveQuery
*/
public function getTeam()
{
return $this->hasOne(Team::className(), ['id' => 'team_id']);
}
public function getTeams()
{
return $this->hasMany(Team::className(), ['user_id' => 'id']);
}
