Yii框架实现数据分页及排序的例子

class PostController extends Controller
{
    function actionIndex()
    {
        $criteria = new CDbCriteria();
        $count=Post::model()->count($criteria);
        $pages=new CPagination($count);
 
        // elements per page
        $pages->pageSize=5;
        $pages->applyLimit($criteria);
 
        // sorting
        $sort = new CSort('Post');
        $sort->attributes = array('id', 'title',);
        $sort->applyOrder($criteria);
 
        $models = Post::model()->findAll($criteria);
 
        $this->render('index', array(
            'models' => $models,
            'pages' => $pages,
            'sort' => $sort,
        ));
    }
}

<p><?php echo $sort->link('id')?></p>
<p><?php echo $sort->link('title')?></p>
<ol>
<?php foreach($models as $model):?>
    <li>
        <h2><?php echo $model->id?> - <?php echo $model->title?></h2>
    </li>
<?php endforeach?>
</ol>
 
<?php $this->widget('CLinkPager', array(
    'pages' => $pages,
))?>

public function actionReport()
    {
        $sql = "select remitdate, sum(rate) sumrate from td_delivery
            group by remitdate
            order by remitdate desc";
        $criteria=new CDbCriteria();
        $result = Yii::app()->db->createCommand($sql)->query();
        $pages=new CPagination($result->rowCount);
        $pages->pageSize=2;
        $pages->applyLimit($criteria);
        $result=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");
        $result->bindValue(':offset', $pages->currentPage*$pages->pageSize);
        $result->bindValue(':limit', $pages->pageSize);
        $posts=$result->query();
        $this->render('report',array(
                'posts'=>$posts,
                'pages'=>$pages,
        ));
    }

[View层]

<?php foreach($posts as $row):?>
 <?php echo CHtml::link($row["remitdate"],array('delivery/view','remitdate'=>$row["sumrate"]));?>
 <?php echo $row["sumrate"]."<br />" ?>
 <?php endforeach;?>
 <?php
 //分页widget代码:
 $this->widget('CLinkPager',array('pages'=>$pages));
 ?>

/**
     * @var string attribute : 日运费 (统计用)
     * 需要对新增加的字段做个声明
     */
    public $dayrate;

    /*
     * 统计功能: 统计每日的运费
     */
    public function statistics()
    {
        $criteria = new CDbCriteria;
        $criteria->select = 'remitdate, sum(rate) AS dayrate';
        $criteria->group = 'remitdate';
       
        return new CActiveDataProvider(get_class($this), array(
            'criteria'=>$criteria,
            'sort'=>array(
                // 表头设置点击排序的字段
                'attributes'=>array(
                    'remitdate',
                    'dayrate'=>array(
                        'asc'=>'dayrate',
                        'desc'=>'dayrate DESC',
                    )
                ),
                'defaultOrder'=>'remitdate desc',
            ),
        ));   
    }

[Controller层]

/**
     * 运单统计功能:
     * 按日期统计
     */
    public function actionReport()
    {
        $model=new Delivery('statistics');
        $model->unsetAttributes();  // clear any default values
        
        $this->render('report',array(
            'model'=>$model,
        ));
    }

[View层]

<?php $this->widget('zii.widgets.grid.CGridView', array(
    'id'=>'delivery-grid',
    'dataProvider'=>$model->statistics(),
    'filter'=>$model,
    'columns'=>array(
        'remitdate',
        'dayrate',
        array(
            'class'=>'CButtonColumn',
        ),
    ),
)); ?>