public function getLatestBattleResultImage() { return $this->hasOne(BattleImage::className(), ['battle_id' => 'id'])->viaTable('battle', ['user_id' => 'id'], function ($query) { $query->innerJoin('battle_image', 'battle.id = battle_image.battle_id AND battle_image.type_id = :type', [':type' => BattleImageType::ID_RESULT]); $query->orderBy('{{battle}}.[[id]] DESC'); $query->limit(1); })->andWhere(['battle_image.type_id' => BattleImageType::ID_RESULT]); }
public function getBattleImageResult() { return $this->hasOne(BattleImage::className(), ['battle_id' => 'id'])->andWhere(['type_id' => BattleImageType::ID_RESULT]); }
/** * @return \yii\db\ActiveQuery */ public function getBattleImages() { return $this->hasMany(BattleImage::className(), ['type_id' => 'id']); }