yii 中使用排序

使用原理类似于pagination

            $sort = new Sort([
                'attributes' => [
                    'age' => [
                        'asc' => ['age' => SORT_ASC],
                        'desc' => ['age' => SORT_DESC],
                        'default' => SORT_ASC,
                        'label' => '年龄'
                        /*'label' => Inflector::camel2words('age'),*/
                    ],
                    'name'=>[
                        'asc' => ['name' => SORT_ASC],
                        'desc' => ['name' => SORT_DESC],
                        'default' => SORT_ASC,
                        'label' => '姓名'
                    ],
                ],
                //默认按id排序，现在改成按name排序
                /*'defaultOrder' => ['name' => SORT_ASC],*/
            ]);
                //创建name和age排序链接, 类似LinkPager::widget(['pagination' => $pages]);
                //生成<a href="/index.php?r=site%2Flogin&amp;page=1&amp;sort=name" data-sort="name">姓名</a>
            $data['name'] = $sort->link('name');
            $data['age'] = $sort->link('age');

            $data['person']  = Person::find() -> andWhere(['deleted' => '-1']);;
            //分页
            $data['pagination'] = new Pagination([
                'defaultPageSize' => 4,
　　　　　　　　　　//count()是Query类中的方法
                'totalCount' => $data['person']->count(),
            ]);

            //***$data['person']必须是一个Query对象，才可以调用orderBy(),offset(),limit()等方法
            //$sort生成数组['field_name' => ORDER_DESC]填充orderby方法
            $data['person'] = $data['person']->orderBy($sort->orders)
                ->offset($data['pagination']->offset)
                ->limit($data['pagination']->limit)
                ->all();

            return $this->render("show", $data);