Sort In Grid View

Sort In Grid View Rate Topic:

#1 Aadhira

Junior Member

Group: Members
Posts: 28
Joined: 06-February 13

Posted 06 February 2013 - 04:49 AM

hi all,is there any way to sort the content displayed in grid view?if so kindly help me.

Thanks in advance

<?php

$duplicateData = Yii::app()->db->createCommand()
->select('*')
->from('mail')
->queryAll();
$dataProvider = new CArrayDataProvider($duplicateData, array(
'pagination' => array(
'pageSize' => 10,
),
));

$this->widget('zii.widgets.grid.CGridView', array(

'dataProvider' => $dataProvider->search(),

array(
'name' => 'E_Id',
'header' => 'Email Id'
),
array(
'name' => 'Receiver',
'header' => 'Receiver'
),
)
));

?>

#2 gv0zd

Junior Member

Group: Members
Posts: 39
Joined: 06-April 12

Posted 06 February 2013 - 05:38 AM

In my code I use this

    public function search()
    {
        $criteria=new CDbCriteria;

        $criteria->compare('t.id',$this->id);
        $criteria->compare('typeId',$this->typeId);
        $criteria->compare('countryId',$this->countryId);
        $criteria->compare('t.title',$this->title,true);
        $criteria->compare('content',$this->content,true);
        $criteria->compare('created',$this->created,true);
        $criteria->compare('deleted',$this->deleted,true);

        $criteria->with=array('type', 'country');

        return new CActiveDataProvider(
            $this,
            array(
                'criteria'=>$criteria,
                'sort'=>array(
                    'defaultOrder'=>'type.id ASC, country.title ASC, t.title ASC',
                    'attributes'=>array(
                        'type.title'=>array(
                            'asc'=>$expr='type.title',
                            'desc'=>$expr.' DESC',
                        ),
                        'country.title'=>array(
                            'asc'=>$expr='country.title',
                            'desc'=>$expr.' DESC',
                        ),
                        '*'
                    )
                ),
                'pagination'=>array(
                    'pageSize'=>Yii::app()->params['pagination']['backoffice'],
                ),
            )
        );
    }

#3 Aadhira

Junior Member

Group: Members
Posts: 28
Joined: 06-February 13

Posted 07 February 2013 - 03:52 AM

gv0zd, on 06 February 2013 - 05:38 AM, said:

In my code I use this

    public function search()
    {
        $criteria=new CDbCriteria;

        $criteria->compare('t.id',$this->id);
        $criteria->compare('typeId',$this->typeId);
        $criteria->compare('countryId',$this->countryId);
        $criteria->compare('t.title',$this->title,true);
        $criteria->compare('content',$this->content,true);
        $criteria->compare('created',$this->created,true);
        $criteria->compare('deleted',$this->deleted,true);

        $criteria->with=array('type', 'country');

        return new CActiveDataProvider(
            $this,
            array(
                'criteria'=>$criteria,
                'sort'=>array(
                    'defaultOrder'=>'type.id ASC, country.title ASC, t.title ASC',
                    'attributes'=>array(
                        'type.title'=>array(
                            'asc'=>$expr='type.title',
                            'desc'=>$expr.' DESC',
                        ),
                        'country.title'=>array(
                            'asc'=>$expr='country.title',
                            'desc'=>$expr.' DESC',
                        ),
                        '*'
                    )
                ),
                'pagination'=>array(
                    'pageSize'=>Yii::app()->params['pagination']['backoffice'],
                ),
            )
        );
    }

i dono for what $criteria->with=array('type', 'country'); is used .kindly explain it