yii Provider 分析

最新推荐文章于 2021-10-08 14:27:41 发布

LiErDan

最新推荐文章于 2021-10-08 14:27:41 发布

阅读量205

点赞数

分类专栏： yii

本文链接：https://blog.csdn.net/LiErDan/article/details/79808303

版权

yii 专栏收录该内容

27 篇文章 1 订阅

订阅专栏

//提供查询语句
        $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();