//提供查询语句
$query = Goods::find()->asArray();
$provider = new ActiveDataProvider([
//获取使用的查询语句
'query' => $query,
//绑定分页类, 并将分页类生成的limit(), offset()查询子句附加到上面query的查询语句中去
//pagination类读取 $_GET 里的&page= 参数生成数据
'pagination' => [
'pageSize' => 2,
],
//绑定sort类, 并将sort类生成的orderBy()查询子句附加到上面query的查询语句中去
//sort类读取 $_GET 里的&sort= 参数生成数据
'sort' => [
'attributes' => [
'goods_id' => [
'asc' => ['goods_id' => SORT_ASC],
'desc' => ['goods_id' => SORT_DESC],
'default' => SORT_ASC,
'label' => '年龄'
/*'label' => Inflector::camel2words('age'),*/
],
'goods_name'=>[
'asc' => ['goods_name' => SORT_ASC],
'desc' => ['goods_name' => SORT_DESC],
'default' => SORT_ASC,
'label' => '姓名'
],
],
'defaultOrder' => ['goods_name' => SORT_ASC],
]
]);
//运行已拼接好的sql语句生成数据
var_dump($provider->getModels());exit();
yii Provider 分析
最新推荐文章于 2021-10-08 14:27:41 发布