在 GridView Yii Framework 2.0 中按相关模型属性排序


Sort by related model attributes in GridView Yii Framework 2.0

我有Post模型和两个相关的模型,UserComments

与模型中定义的UserComment模型的关系Post

public function getUser()
{
    return $this->hasOne(User::className(), ['id' => 'user_id']);
}
public function getUserName()
{
    return $this->user->name;
}
public function getComments(){
    return $this->hasMany(Comment::className(), ['comment_id' => 'id']);;
}
public function countCommentPoints() {
    return $this->hasMany(Comment::className(), ['comment_id' => 'id'])->sum('point');
}

我的PostSearch模型如下所示。我省略了代码和 FilterWhere(),因为它超出了范围:

class PostSearch extends Post {
    public $userName;
    public function rules()
    {
         return ['userName', 'safe'];
    }
    public function search($params) {
         $query = Post::find();
         $dataProvider = new ActiveDataProvider([
             'query' => $query,
         ]);
         $dataProvider->setSort([
             'attributes' => [
                  'userName' => [
                      'asc' => ['user.name' => SORT_ASC],
                      'desc' => ['user.name' => SORT_DESC],
                  ],
             ],
         ]);
         if (!($this->load($params) && $this->validate())) {
             $query->joinWith(['user']);            
             return $dataProvider;
         }
    }
    return $dataProvider;
}

查看代码:

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        'id',
        'title',
        [
             'attribute' => 'userName',
             'value' => 'userName',
             'label' => 'User Name'
        ],
        [
             'attribute' => 'comment',
             'value' => function($model){
                  return $model->countCommentPoints();
             },
             'label' => 'Points',
        ],
     ],
]);

使用上面的所有代码,我可以按idtitle以及userName对记录进行排序,这是相关User模型的属性。但是我无法按列Points排序,因为它不是Comment模型的属性,而是从getLeadEarningPerWebmaster()方法返回的总和值。我试图在这里阅读 Yii 2.0 文档 http://www.yiiframework.com/doc-2.0/guide-output-data-widgets.html 但排序数据部分仍在开发中。如何使GridViewPoints列排序?

您可以按不一定在原始 ActiveRecord 中的相关列对 GridView 列进行排序。

echo GridView::widget([
'dataProvider' => new ActiveDataProvider([
    'query' => $model->joinWith([
            'comment' => function ($query) {
                    $query->select('SUM(point) AS sum')->from(['comment' => '{{%comment}}']);
            }
    ]),
    'sort' => [
            'attributes' => [
                    'comment.sum' => [
                            'asc' => ['comment.sum' => SORT_ASC],
                            'desc' => ['comment.sum' => SORT_DESC],
                    ]
            ],
            'sortParam' => 'post-sort',
            'defaultOrder' => ['comment.sum' => SORT_ASC]
    ],
]),

这应该让你开始。