yii使用dataProvider生成数据列表和筛选

conrtoller

$search = new UserAccount();$provider = $search->search(Yii::$app->request->get());return $this->render('search', [    'provider' => $provider,    'searchModel' => $search,]);

model

 public function search($param){    $query = self::find()->alias('user')->joinWith(['type','status']);    $provider = new ActiveDataProvider([        'query' => $query,        'pagination' => [            'pageSize' => 10,        ],        'sort' => [            'defaultOrder' => [                'RegTime' => SORT_ASC,            ]        ]    ]);    //不通过就不增加条件，直接返回    if(!($this->load($param) && $this->validate())){        return $provider;    }    $query->andFilterWhere(['user.Type' => $this->Type]);    $query->andFilterWhere(['user.Account' => $this->Account]);    $query->andFilterWhere(['like', 'user.PhoneAddress', $this->PhoneAddress]);    return $provider;}

view

<?phpuse yii\grid\GridView;use yii\helpers\Html;use app\models\UserAccount;?><?= GridView::widget([   'dataProvider' => $provider,   'filterModel' => $searchModel,   'columns' => [       [           'class' => 'yii\grid\SerialColumn',       ],       'Account',       'UIN',       [           'attribute' => 'Type',           'value' => function($data){               return $data->type->name;           },           'filter' => UserAccount::getDictionaryDatas(UserAccount::DICTIONARY_USER_TYPE),       ],       'Status',       'RegTime',       'RegSrc',       'PhoneAddress',   ]]) ?>

---

需要注意的：

• 筛选的字段必须是safeAttribute，即在rules中有定义规则的，如果没有，则load()是无法加载数据的

• 如果type和status等这种固定值的筛选，想要创建下拉，则可以给column列中定义filter，对应一个数组键值对。