yii实现分页的两种方法,一种是用dao实现,另外一种是在widget实现.
各有优点吧,第一种效率会高一点, 第二种可以使用自带的表格,方便一些.
一. dao实现分页.
[controller层]
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));
?>
优点: dao效率高; 缺点: view层需要自己写一些样式,稍显麻烦一点
二. widget实现分页
[model层]
/**
* @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',
),
),
)); ?>
优点: 可以使用自带的样式; 缺点: 效率略低.
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持硕编程。
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！