Exemple #1
0
 /**
  * Defines many-to-many relation with player model via table game_has_player
  * @return list of games's players
  */
 public function getPlayers()
 {
     return $this->hasMany(Player::className(), ['id' => 'player_id'])->viaTable('game_has_player', ['game_id' => 'id'])->select('*, (SELECT presence FROM game_has_player WHERE game_id=' . $this->id . ' AND player_id=players.id LIMIT 1) as presence');
 }
Exemple #2
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getRes8Owner()
 {
     return $this->hasOne(Player::className(), ['id' => 'res8OwnerId'])->from(Player::tableName() . ' pro8');
 }
Exemple #3
0
 /**
  * Defines many-to-many relation with player model via table team_has_player
  * @return list of team's players
  */
 public function getPlayers()
 {
     return $this->hasMany(Player::className(), ['id' => 'player_id'])->viaTable('team_has_player', ['team_id' => 'id'])->select('*, (SELECT is_capitan FROM team_has_player WHERE team_id=' . $this->id . ' AND player_id=players.id LIMIT 1) as is_capitan');
 }