Ok, here’s my controller:
public function actionIndex()
{
$query = ChildParent::find();
$searchModel = new ChildParentSearch();
if(isset($_GET['ChildParentSearch']))
{
$searchModel->load(Yii::$app->request->get());
$query->joinWith(['child']);
$query->joinWith(['parent']);
$query->andFilterWhere(['LIKE', 'child.id', $searchModel->getAttribute('child_id')]);
$query->andFilterWhere(['LIKE', 'parent.id', $searchModel->getAttribute('parent_id')]);
}
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'pageSize' => 50
]
]);
The child table is (id, name, sport_id), so I want to add a column in my view to search childs for sport too. Here’s my view:
$childFilterData = \yii\helpers\ArrayHelper::map(\common\models\Child::find()->all(),'id','name');
$parentFilterData = \yii\helpers\ArrayHelper::map(\common\models\Parent::find()->all(), 'id', 'name');
?>
<div class="child-parent-index">
<h1><?= Html::encode($this->title) ?></h1>
<?php // echo $this->render('_search', ['model' => $searchModel]); ?>
<p>
<?= Html::a('Create', ['create'], ['class' => 'btn btn-success']) ?>
</p>
<?= GridView::widget([
'dataProvider' => $dataProvider,
'filterModel' => $searchModel,
'columns' => [
['class' => 'yii\grid\SerialColumn'],
[
'header' => 'Child',
'attribute' => 'child.name',
'filter' => Html::activeDropDownList($searchModel, 'child_id', $childFilterData, ['prompt' => '-- All', 'class' => 'form-control']), 'content' => function($model) { return $model->child->name; }
],
[
'header' => 'Parent',
'attribute' => 'parent.name',
'filter' => Html::activeDropDownList($searchModel, 'parent_id', $parentFilterData, ['prompt' => '-- All', 'class' => 'form-control']), 'content' => function($model) { return $model->parent->name; }
],
['class' => 'yii\grid\ActionColumn'],
],
]); ?>
</div>