public function getCemetery()
{
return $this->hasOne(Cemeteries::class, ['id' => 'cemetery_id']);
}
public function getCemeteriesList()
{
$query = Cemeteries::find()->alias('c')->select(['c.id', 'c.name_ru']);
if(!Yii::$app->user->can('admin')){
$query->joinWith(['graves g' => function(ActiveQuery $query){
return $query->andWhere(['g.user_id' => Yii::$app->user->identity->getId()]);
}]);
}
$query = $query->all();
return ArrayHelper::map($query, 'id', 'name_ru');
}
[
'attribute' => 'cemetery_id',
'filter' => $searchModel->getCemeteriesList(),
'headerOptions' => ['class' => 'code-column'],
'value' => 'cemetery.name_ru'
],
Используйте createCommand();