Sorting On The Basis Of Attribute

lalitesh · December 17, 2013, 9:10am

I need to sort an attribute like package date, package name, status etc.

Now, I want that when user clicks on their respective title in view file. It should sort the records in ASC and DESC order for their respective attributes

Currently I am generating the list in following manner.

$criteria = new CDbCriteria();

$criteria->order = ‘t.id DESC’;

$count=Standard::model()->count($criteria);

$pages=new CPagination($count);

$pages->pageSize=Yii::app()->params[‘adminPaging’];

$pages->applyLimit($criteria);

$standarddata = Standard::model()->findAll($criteria);

$this->render(‘classes’, array(‘standarddata’ => $standarddata,

			'pages' =&gt; &#036;pages,


			'standard'=&gt;&#036;standard,


			'standard_edit'=&gt;&#036;standard_edit


));

But, this only shows the content on the basis of ID.

I want to make all the heading as links on view file and when user click on link it will sort the records on the basis of attribute in ASC or DESC order(toggle functionality).

I want to know that how can I use widgets or CActiveDataProvider to use this Sort feature of Yii.

chandrantwins · December 17, 2013, 3:54pm

Hi,

If you use cgridview … its default functionality with that component. You can utilize this compent.