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']);
}
