Yii2 gridview sort custom column

Question

I have a poll in my project.In grid I have show the count.

echo GridView::widget([
'dataProvider' => $dataProvider,
'columns' => [
    ['class' => 'yii\grid\SerialColumn'],
    [
        'label' =>"Constituency",
        'attribute' => 'constituency',
        'value'=>function($data){
            return $data["constituency"];
        }
    ],
    [
        'class' => 'yii\grid\DataColumn',
        'label' =>"Count",
        'attribute' => 'count',
       'value'=>function($data){
            return $data->getCount($data["constituency"]);
        },
        'enableSorting'=>TRUE ,

    ],

],

My Model
for get count

    public static  function  getCount($constituency){
    $cat = Polls::find()->where(['poll_place'=>$constituency])->count();
    // $cat = ArrayHelper::map($cat, 'id', 'name');
    return $cat;
}

The count column is a custom column.
Can anyone help to sort that column.
I have tried This and this.
Both are failed because my count attribute is not in my DB.
Showing the following error

I can help you here but need some more information. Can you please show the code for getCount()? — ajmedway
– ajmedway, Commented Apr 5, 2018 at 13:54
update your question and add the code related to count .. model or searchModel .. — ScaisEdge
– ScaisEdge, Commented Apr 5, 2018 at 16:52

rob006 · Accepted Answer · 2018-04-15 20:59:55Z

Sorting is done at SQL level, you cannot blindly allow sorting on virtual attribute, you need to adapt your query to handle such sorting.

First, you need to add proper relation between two models. In your Constituency model add something like:

public function getPools()
{
    return $this->hasMany(Pools::className(), ['pool_place' => 'constituency']);
}

Then join two tables in query and enable grouping, so you can be able to calculate count for each Constituency.

$query = Constituency::find()->joinWith('pools')->groupBy('constituency');

Then configure sorting:

$sort = new Sort([
    'attributes' => [
        'constituency',
        'count' => [
            'asc' => 'COUNT(pools.poll_place) ASC',
            'desc' => 'COUNT(pools.poll_place) DESC',
        ],
    ],
]);

You may also create count attribute in your Constituency and add ->addSelect(['count' => Expression('COUNT(pools.poll_place)')]) to your query, to avoid excessive queries for polls count for each Constituency.

Collectives™ on Stack Overflow

Yii2 gridview sort custom column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related