Yii分页实例使用详解

public function actionAjax() { 

        $criteria = new CDbCriteria(); 

        //$criteria->order = 'news_id DESC'; 

        $criteria->condition = 'user_id = 1'; 

        $dataProvider = new CActiveDataProvider('News', array( 

                    'pagination' => array( 

                        'pageSize' => Yii::app()->params['pagesize'], 

                        'pageVar' => Yii::app()->params['pagevar'], 

                    ), 

                    'criteria' => $criteria, 

                )); 

        $this->render('view', array( 

            'dataProvider' => $dataProvider, 

        )); 

    }
[View]

<!--?php 

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

                    'dataProvider' => $dataProvider, //数据 

                    'itemView' => '_view', //显示的模版 

                    'id' => Yii::app()->controller->id, 

                    'itemsTagName' => 'ul', 

                    'ajaxVar' => '', //默认为page或ajax 去掉后url更简洁 

                    'htmlOptions' => array('class' => Yii::app()->controller->id), 

                    'loadingCssClass' => 'loading', //默认为list-view-loading 

                    //'template' => '{summary}{sorter}{items}{pager}',//显示的顺序 

                    //'ajaxUpdate' => false, //是否ajax分页  false或分页显示的容器id 

                    //'beforeAjaxUpdate' => 'before_ajax_update',   //回调函数 在common.js里完成 

                    //'afterAjaxUpdate' => 'after_ajax_update',   

                    'emptyText' => ' 

<DIV class="alert alert-waning"> 

    暂无数据！ 

</DIV> 

', //无数据时显示内容 

                    'pagerCssClass' => 'pagination', //分页的class 

                    'pager' => array( 

                        'selectedPageCssClass' => 'active', //当前页的class 

                        'hiddenPageCssClass' => 'disabled', //禁用页的class 

                        'header' => '', //分页前显示的内容 

                        'maxButtonCount' => 10, //显示分页数量 

                        'htmlOptions' => array('class' => ''), 

                        'firstPageLabel' => '首页', 

                        'nextPageLabel' => '下一页', 

                        'prevPageLabel' => '上一页', 

                        'lastPageLabel' => '末页', 

                    ), 

                )); 

?>

public function actionIndex() { 

        $criteria = new CDbCriteria(); 

        $criteria->order = 'news_id DESC'; 

        $criteria->condition = 'user_id = 1'; 

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

        $pages = new CPagination($count); 

        $pages->pageSize = 10; 

        $pages->applyLimit($criteria); 

        $list = News::model()->findAll($criteria); 

        $this->render('index', array('list' => $list, 'pages' => $pages)); 

    }

[View]

<UL> 

    <!--?php foreach ($list as $item): ?--> 

    <LI> 

        <DIV class=page-header> 

            <!--?php echo $item--->news_title; ?> 

        </DIV> 

        <DIV class=content> 

            <!--?php echo $item--->news_intro; ?> 

        </DIV> 

    </LI> 

<!--?php endforeach; ?--> 

</UL> 

<DIV class=pagination> 

    <!--?php 

    $this--->widget('CLinkPager', array( 

        'pages' => $pages, 

        'selectedPageCssClass' => 'active', //当前页的class 

        'hiddenPageCssClass' => 'disabled', //禁用页的class 

        'header' => '', //分页前显示的内容 

        'maxButtonCount' => 10, //显示分页数量 

        'htmlOptions' => array('class' => ''), 

        'firstPageLabel' => '首页', 

        'nextPageLabel' => '下一页', 

        'prevPageLabel' => '上一页', 

        'lastPageLabel' => '末页', 

            ) 

    ); 

    ?> 

</DIV>

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',
),
),
)); ?>

$criteria = new CDbCriteria();
$criteria->order = '`create_time` DESC';

$dataProvider = new CActiveDataProvider('Comments', array(
    'pagination'=>array(
      'pageSize'=>Yii::app()->params['commentsPerPage'],//设置分页条数以确定取出数据的条数
  ),
  'criteria'=>$criteria,
  ));
$this->render('comments',array(
         'model' => $model,
         'dataProvider' => $dataProvider,
));