一、
- class LinkPage extends CLinkPager
- {
- public function run()
- {
- $pageLinks = $this->createPagePreAndNext();
- $topPage = CHtml::tag('div', array('class'=>'topPage'), $pageLinks);
- $form = $this->createForm();
- $toPage = CHtml::tag('div', array('class'=>'toPage'), $form);
- echo CHtml::tag('div', array('class'=>'page'), $topPage.$toPage);
- }
- /**
- * @desc 创建向前和向后的链接
- * @return string a标签和span标签的html代码
- */
- private function createPagePreAndNext()
- {
- $links = '';
- if ($this->pages->getCurrentPage()>=1) {
- $links .= CHtml::link($this->prevPageLabel, $this->createPageUrl($this->pages->getCurrentPage()-1), array('class'=>'prePage'));
- } elseif (0 == $this->pages->getCurrentPage()) {
- $links .= CHtml::tag('span', array('class'=>'prePage'), $this->prevPageLabel);
- }
- $links .= CHtml::tag('span', array('class'=>'pageNum'), $this->pages->getCurrentPage()+1 . '/' . ($this->pages->getPageCount()?$this->pages->getPageCount():1));
- if ($this->pages->getCurrentPage()+1 < $this->pages->getPageCount()) {
- $links .= CHtml::link($this->nextPageLabel, $this->createPageUrl($this->pages->getCurrentPage()+1), array('class'=>'pgNxt'));
- } elseif($this->pages->getCurrentPage()+1 >= $this->pages->getPageCount()) {
- $links .= CHtml::tag('span', array('class'=>'pgNxt'), $this->nextPageLabel);
- }
- return $links;
- }
- /**
- * @desc 创建跳转表单
- * @return string form的html代码
- */
- private function createForm()
- {
- $form = '';
- $url = $this->createPageUrl(0);
- $form .= CHtml::beginForm($url, 'get');
- $form .= CHtml::tag('span', array(), '跳转到');
- $form .= CHtml::textField('page', '', array('class'=>'pageIn'));
- $form .= CHtml::tag('span', array(), '页');
- $form .= CHtml::tag('input', array('type'=>'submit', 'class'=>'pageSubBtn', 'value'=>'确定'));
- $form .= CHtml::endForm();
- return $form;
- }
- /**
- * @desc 创建分页url链接
- * @param int $page 链接指向的页数
- * @return string url链接
- */
- public function createPageUrl($page)
- {
- if (is_null($this->pages->params)) {
- $this->pages->params = $_GET;
- foreach($this->pages->params as $key=>$value){
- if (stripos($key, '/') || stripos($key, '\\')) {//去掉键中包含有 / 或者 \ 的param
- unset($this->pages->params[$key]);
- }
- }
- }
- return $this->pages->createPageUrl($this->getController(), $page);
- }
- }
- class ListLinkPage extends CLinkPager
- {
- public $listNum = 8;
- public $pageArr = array();
- public $startPage;
- public $endPage;
- public function run()
- {
- $this->listArr();
- $code = $this->makeListHtml();
- $code .= $this->makePrevAndNext();
- echo $code;
- }
- public function getListNum()
- {
- return $this->listNum;
- }
- public function setListNum($num)
- {
- is_numeric($num) && $this->listNum = intval($num);
- }
- /**
- * 计算链接的起始和结束位置
- */
- private function listArr()
- {
- //计算数字下标,当前页标之前需要显示多少个下标 和 当前页标之后需要显示多少个下标
- $back = ceil(($this->listNum - 1)/2);
- $pageNow = $this->pages->getCurrentPage() + 1;
- $count = $this->pages->getPageCount();
- $this->endPage = ($pageNow+$back>$count)?$count:$pageNow+$back;
- $this->startPage = ($pageNow+$back>$count)?(($count-$this->listNum)<1?1:($count-$this->listNum+1)):(($pageNow-$back+(($this->listNum%2)^1))<1?1:($pageNow-$back+(($this->listNum%2)^1)));
- ($this->endPage-$this->startPage < $this->listNum - 1) && $this->endPage = $this->listNum - $this->startPage + 1;
- }
- /**
- * 生成上一页和下一页的html代码
- */
- private function makePrevAndNext()
- {
- $htmlcode = '';
- (($this->pages->getCurrentPage()<=0) && ($htmlcode .= CHtml::tag('span', array(), $this->prevPageLabel))) || ($htmlcode .= CHtml::link($this->prevPageLabel, '', array()));
- (($this->pages->getCurrentPage()+1 < $this->pages->getPageCount()) && ($htmlcode .= CHtml::link($this->nextPageLabel, '', array()))) || ($htmlcode .= CHtml::tag('span', array(), $this->nextPageLabel));
- return $htmlcode;
- }
- /**
- * 生成列表链接的html代码
- * @return string
- */
- private function makeListHtml()
- {
- $htmlCode = '';
- for($step=$this->startPage;$step<=$this->endPage;$step++){
- (($step == $this->pages->getCurrentPage()+1) && ($htmlCode .= CHtml::tag('strong', array(), $step))) || ($htmlCode .= CHtml::link($step, '', array()));
- }
- return $htmlCode;
- }
- }
- class pageList extends CLinkPager
- {
- private $signEmBefore= false;
- private $signEmAfter = false;
- private $pageStart;
- private $pageEnd;
- private $pageNow;
- private $pageCount;
- private $pageShowCount=7;
- private $pagePosition=3;
- public function run()
- {
- $this->pageNow = $this->pages->getCurrentPage()+1;
- $this->pageCount = $this->pages->getPageCount();
- 0==$this->pagePosition && $this->pagePosition = 1;
- if ($this->pagePosition >= $this->pageShowCount) {
- echo '参数设置不合理';
- return ;
- }
- $this->makeSign();
- echo $this->makeHtml();
- }
- /**
- * 计算标记位置
- */
- public function makeSign()
- {
- if ($this->pageCount>$this->pageShowCount) {
- $this->pageStart = $this->pageNow-$this->pagePosition+1;
- ($this->pageStart < 2 && $this->pageStart = 2) || $this->signEmBefore = true;
- $this->pageEnd = $this->pageShowCount+$this->pageStart-3;
- ($this->pageEnd >= $this->pageCount-1 && $this->pageEnd = $this->pageCount-1) || $this->signEmAfter = true;
- ($this->pageEnd-$this->pageShowCount+3 >= 2) && $this->pageStart = $this->pageEnd-$this->pageShowCount+3;
- } else {
- $this->pageEnd = $this->pageCount-1;
- $this->pageStart = 2;
- }
- }
- /**
- * 生成分页代码
- * @return [type] [description]
- */
- private function makeHtml()
- {
- $html = '';
- $html .= CHtml::tag('div', array('class'=>'page'), false);
- $html .= CHtml::tag('div', array('class'=>'topPage'), false);
- $html .= $this->makeLinkHtml();
- $html .= CHtml::closeTag('div');
- $html .= CHtml::tag('div', array('class'=>'toPage'), false);
- $html .= $this->createForm();
- $html .= CHtml::closeTag('div');
- $html .= CHtml::closeTag('div');
- return $html;
- }
- /**
- * 生成html代码
- * @return string 分页代码
- */
- public function makeLinkHtml()
- {
- $htmlCode = '';
- if (1==$this->pageNow) {
- $htmlCode .= CHtml::tag('span', array('class'=>'prePage'), $this->prevPageLabel);
- $htmlCode .= CHtml::tag('div', array('class'=>'pagaNumBox'), false);
- $htmlCode .= CHtml::tag('strong', array(), 1);
- } else {
- $htmlCode .= CHtml::link($this->prevPageLabel, $this->createPageUrl($this->pageNow-1), array('class'=>'prePage'));
- $htmlCode .= CHtml::tag('div', array('class'=>'pagaNumBox'), false);
- $htmlCode .= CHtml::link(1, $this->createPageUrl(1), array());
- }
- if ($this->signEmBefore) {
- $htmlCode .= CHtml::tag('em', array(), '...');
- }
- for($step=$this->pageStart;$step<=$this->pageEnd;$step++){
- if ($step==$this->pageNow) {
- $htmlCode .= CHtml::tag('strong', array(), $step);
- } else {
- $htmlCode .= CHtml::link($step, $this->createPageUrl($step), array());
- }
- }
- if ($this->signEmAfter) {
- $htmlCode .= CHtml::tag('em', array(), '...');
- }
- if ($this->pageCount==$this->pageNow) {
- $this->pageEnd>0 && $htmlCode .= CHtml::tag('strong', array(), $this->pageCount);
- $htmlCode .= CHtml::closeTag('div');
- $htmlCode .= CHtml::tag('span', array('class'=>'pgNxt'), $this->nextPageLabel);
- } else {
- $this->pageEnd>0 && $htmlCode .= CHtml::link($this->pageCount, $this->createPageUrl($this->pageCount), array());
- $htmlCode .= CHtml::closeTag('div');
- $htmlCode .= CHtml::link($this->nextPageLabel, $this->createPageUrl($this->pageNow+1), array('class'=>'pgNxt'));
- }
- return $htmlCode;
- }
- /**
- * @desc 创建跳转表单
- * @return string form的html代码
- */
- private function createForm()
- {
- $form = '';
- $url = $this->createPageUrl(0);
- $form .= CHtml::beginForm($url, 'get');
- $form .= CHtml::tag('span', array(), '跳转到');
- $form .= CHtml::textField('page', '', array('class'=>'pageIn'));
- $form .= CHtml::tag('span', array(), '页');
- $form .= CHtml::tag('input', array('type'=>'submit', 'class'=>'pageSubBtn', 'value'=>'确定'));
- $form .= CHtml::endForm();
- return $form;
- }
- /**
- * @desc 创建分页url链接
- * @param int $page 链接指向的页数
- * @return string url链接
- */
- protected function createPageUrl($page)
- {
- if (is_null($this->pages->params)) {
- $this->pages->params = $_GET;
- foreach($this->pages->params as $key=>$value){
- if (stripos($key, '/') || stripos($key, '\\')) {//去掉键中包含有 / 或者 \ 的param
- unset($this->pages->params[$key]);
- }
- }
- }
- return $this->pages->createPageUrl($this->getController(), --$page);
- }
- }
第一种:CListView分页 针对对象形式的数据分页
Controller:
代码如下:
- 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' => '末页',
- ),
- ));
- ?>
复制
第二种:CLinkPager 针对数组形式的数据分页
Controller:
代码如下:
- 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>
复制
第三种: 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',
- ),
- ),
- ));
- ?>
复制
优点: 可以使用自带的样式; 缺点: 效率略低.
第五种:Ajax分页
YII中ajax分页有多种实现方法,比较传统的就是在view中写JS来实现,大概的就是这样:
在view中js大概逻辑是这样
代码如下:
- $('#listview .yiiPager a').live('click',function(){
- $.ajax({
- url:$(this).attr('href'),
- success:function(html){
- $('#listview').html(html);
- }
- });
- return false;//阻止a标签
- });
- 然后在controller中判断ajax请求,再使用renderPartial方法渲染局部List视图,然后局部视图会被view中的ajax方法填充到局部刷新的div中。controller的大概逻辑是:
- 代码如下:
- if (Yii::app()->request->isAjaxRequest) {
- $this->renderPartial('_comments',array(
- 'model' => $model,
- 'comments' => $comments,//在局部视图中foreach得到每条数据
- 'pages' => $pages,
- ));
- Yii::app()->end();
- }
复制
后来发现YII中的CListview更方便,封装了分页,foreach显示list,还支持数据排序。具体的可以在YII的API手册中发掘。使用CListview是默认ajax分页的,使用方法如下:
controller中:
代码如下:
- $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,
- ));
复制
然后在view中:
代码如下:
- <?php $this->widget('zii.widgets.CListView', array(
- 'dataProvider'=>$dataProvider,
- 'itemView'=>'_comments',
- //'ajaxUpdate'=> false,//这样就不会AJAX翻页
- 'pager' => array(//pager 的配置信息。默认为<CODE>array('class'=>'CLinkPager')</CODE>.也可以自己配置
- 'nextPageLabel' => '下一页 »',
- 'prevPageLabel' => '« 上一页'
- ),
- //在这里还可以配置一些排序规则,具体可以查阅手册
- ));
- ?>
复制
第六种:自定义分页实现
视图文件调用cgridview,clistview时候调用自定义的分页方法
view
- <?php $this->widget('zii.widgets.grid.CGridView', array(
- 'id'=>'news-grid',
- 'dataProvider'=>$model->search(),
- 'filter'=>$model,
- 'template'=>'{items}{summary}{pager}',
- 'selectableRows'=>2,
- 'pager'=>'ZPager',
- 'summaryText'=>'页数:{pages}/{page}页',
- 'columns'=>array(
- array(
- 'class'=>'CCheckBoxColumn',
- 'footer'=>'<button onclink="deleteAll()">button</button>
- <button onclink="refashAll()">button</button>',
- 'footerHtmlOptions'=>array('colspan'=>5),
- 'selectableRows'=>2,
- ),
- 'id',
- array('name'=>'title',
- 'htmlOptions'=>array('width'=>'20%'),
- 'value'=>'mb_substr($data->title,0,10,"utf-8")',
- ),
- array('name'=>'content',
- 'htmlOptions'=>array('width'=>'20%'),
- 'value'=>'mb_substr(strip_tags($data->content),0,10,"utf-8")',
- ),
- array('name'=>'type',
- 'value'=>'News::model()->getNewsType($data->type)',
- ),
- 'user',
- array('name'=>'status',
- 'value'=>'News::model()->getNewsStatus($data->status)',
- ),
- array(
- 'class'=>'CButtonColumn',
- 'buttons'=>array(
- 'view'=>array('visible'=>'false'),
- //'delete'=>array('click'=>'true'),
- ),
- ),
- ),
- ));
复制
复制基类分页类文件,做修改成为自己的分页方法
- framework/web/widgets/pagers/CListPager.php复制并生命名到protected/components/zpager.php修改类名称
- framework/web/widgets/pagers/pager.css复制对应样式文件到protected/components/css/pager.css
复制
修改zpager.php的css加载目录
- public static function registerCssFile($url=null)
- {
- if($url===null)
- $url=CHtml::asset(Yii::getPathOfAlias('application.components.css.pager').'.css');
- Yii::app()->getClientScript()->registerCssFile($url);
- }
复制
通过修改Css样式文件,也可以修改生成列表的程序,达到修改分类的目的。
第七种:Yii-列表- 定义分页,分页方法
方法一:控制器定义
- function actionIndex(){
- $criteria = new CDbCriteria();
- $count=Article::model()->count($criteria);
- $pages=new CPagination($count);
-
- // 返回前一页
- $pages->pageSize=10;
- $pages->applyLimit($criteria);
- $models = Post::model()->findAll($criteria);
-
- $this->render('index', array(
- 'models' => $models,
- 'pages' => $pages
- ));
- }
复制
视图定义
- <?php foreach($models as $model): ?>
- // 显示一个模型
- <?php endforeach; ?>
-
- // 显示分页
- <?php $this->widget('CLinkPager', array(
- 'pages' => $pages,
- )) ?>
复制
方法二:控制器定义
- public function actionIndex()
- {
- $dataProvider=new CActiveDataProvider('News',array(
- 'criteria'=>array(
- 'condition'=>'status=1',
- 'order'=>'create_time DESC',
- 'with'=>array('author'),
- ),
- 'pagination'=>array(
- 'pageSize'=>20,
- ),
- ));
- $this->render('index',array(
- 'dataProvider'=>$dataProvider,
- ));
- }
复制
视图文件
- <?php $this->widget('zii.widgets.CListView', array(
- 'dataProvider'=>$dataProvider,
- 'itemView'=>'_view',
- )); ?>
复制
方法三:视图文件
- <?php $this->widget('zii.widgets.grid.CGridView', array(
- 'id'=>'news-grid',
- 'dataProvider'=>$model->search(),
- 'filter'=>$model,
- 'template'=>'{items}{summary}{pager}',
- <span style="white-space:pre"> </span> 'pager'=>array(
- 'class'=>'CLinkPager',
- 'header'=>'分页:',
- 'prevPageLabel'=>'上一页',
- 'nextPageLabel'=>'下一页',
- ),
- <span style="white-space:pre"> </span> 'summaryText'=>'页数:{pages}/{page}页',
- <span style="white-space:pre"> </span>'columns'=>array(
- 'id',
- array('name'=>'title',
- 'htmlOptions'=>array('width'=>'20%'),
- 'value'=>'mb_substr($data->title,0,10,"utf-8")',
- ),
- array('name'=>'content',
- 'htmlOptions'=>array('width'=>'20%'),
- 'value'=>'mb_substr(strip_tags($data->content),0,10,"utf-8")',
- ),
- array('name'=>'type',
- 'value'=>'News::model()->getNewsType($data->type)',
- ),
- 'user',
- array('name'=>'status',
- 'value'=>'News::model()->getNewsStatus($data->status)',
- ),
- array(
- 'class'=>'CButtonColumn',
- ),
- ),
- ));
复制
数据模型类
- public function search()
- {
- $criteria=new CDbCriteria;
-
- $criteria->compare('id',$this->id);
- $criteria->compare('title',$this->title,true);
- $criteria->compare('content',$this->content,true);
- $criteria->compare('type',$this->type);
- $criteria->compare('user',$this->user,true);
- $criteria->compare('status',$this->status);
- $criteria->compare('create_data',$this->create_data,true);
-
- return new CActiveDataProvider($this, array(
- 'criteria'=>$criteria,
- 'pagination'=>array(
- 'pageSize'=>50,
- ),
- ));
- }
复制
第八种:Yii 中使用分页
方法中写法:
- public function actionIndex(){
- $categoryModel = Category::model();
- $criteria = new CDbCriteria();
- $criteria->order = 'id ASC';
- $criteria->addCondition('status=1'); //根据条件查询
- $count = Category::model()->count($criteria);
- $pager = new CPagination($count);
- $pager->pageSize=2;
- $pager->applyLimit($criteria);
- $categoryInfo = Category::model()->findAll($criteria);
- $this->render('index',array('pages'=>$pager,'categoryInfo'=>$categoryInfo));
- }
复制
view视图中的调用:
- <?php $this->widget('CLinkPager',array(
- 'header' => '',
- 'firstPageLabel' => '首页',
- 'lastPageLabel' => '最后一页',
- 'prevPageLabel' => '上一页',
- 'nextPageLabel' => '下一页',
- 'pages' => $pages,
- 'maxButtonCount'=>3,
- ));?>
复制
第八种:Yii 中分页设置
yii自己是带有自动分页功能的。只要在对应的controller里面,类似下面这样鞋代码,就会实现的
- $dataProvider=new CActiveDataProvider(
- 'Blog',
- array(
- 'pagination'=>array('pageSize'=>10),
- 'criteria'=>array('order'=>'create_date DESC')
- )
- );
复制
但是样式还是yii中已经写好的,那么对于我,我要改掉这个样式,使用我提供的样式,可以像我下面这样写
- <?php
- $this->widget('zii.widgets.CListView', array(
- 'dataProvider'=>$dataProvider,
- 'itemView'=>'_view',
- 'summaryCssClass'=>'hide',
- 'pagerCssClass'=>'pagination',
- 'pager'=>array(
- 'class'=>'CLinkPager',
- 'nextPageLabel'=>'»',
- 'prevPageLabel'=>'«',
- 'firstPageLabel'=>'最前',
- 'lastPageLabel'=>'最后',
- 'htmlOptions'=>array('class'=>''),
- 'header'=>'',
- 'hiddenPageCssClass'=>'disabled',
- 'selectedPageCssClass'=>'active',
- 'previousPageCssClass'=>'',
- 'nextPageCssClass'=>'',
- )
- ));
- ?>
复制
第九种:yii的CListView和CGridView之分页
1,提供的dataProvider里面配置pagenation属性,例如
- return new CActiveDataProvider($this, array(
- 'criteria'=>$criteria,
- 'pagination'=>array('pageSize'=>3,),
- ));
复制
或者在自己定义的CArrayDataProvider里面加上这些参数
2,在CListView的属性里面配置pager(不配置的话,是默认的分页,也可以自己配置)
- $this->widget('zii.widgets.CListView', array(
- 'dataProvider'=>$dataProvider,
- 'itemView'=>'_view',
- 'pager'=>array(
- 'class'=>'CLinkPager',//定义要调用的分页器类,默认是CLinkPager,需要完全自定义,还可以重写一个,参考我的另一篇博文:http://blog.sina.com.cn/s/blog_71d4414d0100yu6k.html
- // 'cssFile'=>false,//定义分页器的要调用的css文件,false为不调用,不调用则需要亲自己css文件里写这些样式
- 'header'=>'转往分页:',//定义的文字将显示在pager的最前面
- // 'footer'=>'',//定义的文字将显示在pager的最后面
- 'firstPageLabel'=>'首页',//定义首页按钮的显示文字
- 'lastPageLabel'=>'尾页',//定义末页按钮的显示文字
- 'nextPageLabel'=>'下一页',//定义下一页按钮的显示文字
- 'prevPageLabel'=>'前一页',//定义上一页按钮的显示文字
- //关于分页器这个array,具体还有很多属性,可参考CLinkPager的API
- ),
- ));
复制
CGridView也是一模一样
- $this->widget('zii.widgets.grid.CGridView', array(
- 'id'=>'yii-test-user-info-grid',
- 'dataProvider'=>$model->search(),
- 'filter'=>$model,
- 'pager'=>array(
- 'class'=>'CLinkPager',//定义要调用的分页器类,默认是CLinkPager,需要完全自定义,还可以重写一个,参考我的另一篇博文:http://blog.sina.com.cn/s/blog_71d4414d0100yu6k.html
- // 'cssFile'=>false,//定义分页器的要调用的css文件,false为不调用,不调用则需要亲自己css文件里写这些样式
- 'header'=>'转往分页:',//定义的文字将显示在pager的最前面
- // 'footer'=>'',//定义的文字将显示在pager的最后面
- 'firstPageLabel'=>'首页',//定义首页按钮的显示文字
- 'lastPageLabel'=>'尾页',//定义末页按钮的显示文字
- 'nextPageLabel'=>'下一页',//定义下一页按钮的显示文字
- 'prevPageLabel'=>'前一页',//定义上一页按钮的显示文字
- //关于分页器这个array,具体还有很多属性,可参考CLinkPager的API
- ),
- 'columns'=>array(
- 'id',
- // 'sex',
- array(
- 'name'=>'sex',
- 'filter'=> YiiTestUserInfo::model()->getUserSex(),
- ),
- 'name',
- 'passwd',
- 'typeinfo',
- 'tel',
- 'xxxx',
- array(
- 'class'=>'CButtonColumn',
- ),
- ),
- ));
复制
第十种:Yii实现分页的两种方法
一. 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));
- ?>
复制
二. 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,
- ));
- }