使用 Yii2 中的关系在 GridView 列中搜索

问题描述

我有一个带有外键 city_id 的模型，它引用了表 Cities (id).在 GridView 中，我显示城市标题而不是 id，并且我知道如何添加搜索带有外键的列，即在视图中:

I have a model with foreign key city_id that references table Cities (id). In the GridView I show city title instead of id, and I know how to add searching for column with foreign key, i.e, in view:

GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
       //some columns
        [ 
            'attribute' => 'city_id',
            'value'=>'city.title
        ],
]);

并在搜索模型(search() 函数)中添加:

And in search model (search() function) I add:

$query->joinWith('city');
$query->andFilterWhere(['like', 'cities.title', $this->city_id]);

而且它工作正常.但我也想在我的网格中显示 region，我的表 Cities 有一个外键 region_id 引用 Regions(id).我在网格中添加了区域标题:

 GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
       //some columns
        [ 
            'attribute' => 'city_id',
            'value'=>'city.title
        ],
        'city.region.title_en',
]);