分页示例来自开源SNS

<?php

class MiniController extends Controller
{
const PAGE_SIZE=20;

public $is_me;

public function actionIndex()
{
$uid = Yii::app()->user->id;

$model = new Mini();
//初始化
$criteria=new CDbCriteria;
$criteria->select = "{{friend}}.fuid as uid,t.*";
$criteria->order='id';
$criteria->join = "left join {{friend}} on {{friend}}.fuid = t.uid ";
$criteria->condition="{{friend}}.uid=:uid";
$criteria->params=array(':uid'=>$uid);

$gid = Yii::app()->request->getQuery('gid');
if(!empty($gid))
{
$criteria->join .= " left join {{friend_belong_group}} on {{friend_belong_group}}.uid = {{friend}}.uid ";
$criteria->addCondition('gid='.$gid);
}

//取得数据总数,分页显示
$total = $model->count($criteria);
$pages=new CPagination($total);
$pages->pageSize=self::PAGE_SIZE;
$pages->applyLimit($criteria);
//获取数据集
$mini_list = $model->findAll($criteria);

$data = array(
'mini_list'=> $mini_list,
'pages'=> $pages,
);


$this->render('index',$data);
}

/**
* 我的心情
*/
public function actionMy()
{
$uid = Yii::app()->user->id;

$model = new Mini();
//初始化
$criteria=new CDbCriteria;
$criteria->order='ctime DESC';
$criteria->condition="uid=:uid";
$criteria->params=array(':uid'=>$uid);

$mini = $model->find($criteria);

$smile = new Smile();
$icon_list = $smile->getIconList();

$date = Yii::app()->request->getQuery('date');
if(!empty($date))
{
$criteria = $model->fileaway($date,$criteria);
}

//取得数据总数,分页显示
$total = $model->count($criteria);
$pages=new CPagination($total);
$pages->pageSize=self::PAGE_SIZE;
$pages->applyLimit($criteria);
//获取数据集
$mini_list = $model->with(array('reply'))->findAll($criteria);

$data = array(
'mini_list'=> $mini_list,
'pages'=> $pages,
'mini'=> $mini,
'icon_list' =>$icon_list,
);

$this->render('my',$data);
}

/**
* 我的心情
*/
public function actionAll()
{
$uid = Yii::app()->user->id;

$model = new Mini();
//初始化
$criteria=new CDbCriteria;
$criteria->order='ctime DESC';
$date = Yii::app()->request->getQuery('date');
if(!empty($date))
{
$criteria = $model->fileaway($date,$criteria);
}

//取得数据总数,分页显示
$total = $model->count($criteria);
$pages=new CPagination($total);
$pages->pageSize=self::PAGE_SIZE;
$pages->applyLimit($criteria);
//获取数据集
$mini_list = $model->findAll($criteria);

$data = array(
'mini_list'=> $mini_list,
'pages'=> $pages,
);

$this->render('my',$data);
}

/**
* 好友的心情
*/
public function actionFriends()
{
$uid = Yii::app()->request->getQuery('uid');
$mid = Yii::app()->user->id;

if($uid == $mid)
{
$this->redirect(array('my'));
}

$model = new Mini();
//初始化
$criteria=new CDbCriteria;
$criteria->order='ctime DESC';
$criteria->condition="uid=:uid";
$criteria->params=array(':uid'=>$uid);

$date = Yii::app()->request->getQuery('date');
if(!empty($date))
{
$year = $date[0].$date[1].$date[2].$date[3];
$month = $date[4].$date[5];
$start = mktime(0,0,0,$month,1,$year);
$end = mktime(0,0,0,$month+1,1,$year);
$condition = "$start < ctime AND ctime < $end";
$criteria->addCondition($condition);
}

//取得数据总数,分页显示
$total = $model->count($criteria);
$pages=new CPagination($total);
$pages->pageSize=self::PAGE_SIZE;
$pages->applyLimit($criteria);
//获取数据集
$mini_list = $model->findAll($criteria);

$data = array(
'mini_list'=> $mini_list,
'pages'=> $pages,
);


$this->render('my',$data);
}

public function actionDoAddMini(){
$content = Yii::app()->request->getPost('content');
if( empty($content) ){
echo -1;
return false;
}
$model = new Mini();
//TODO 检测空白输入
$model->content = $content;
$add = $model->save();

if( $add ){
echo $model->replaceContent($content);
}else{
echo -1;
}
}

/**
* doDeleteMini
* 删除mini
* @access public
* @return void
*/
public function doDeleteMini( ){
$id = Yii::app()->request->getPost('id');
$model = new Mini();
//TODO 检测空白输入
$mini = $model->findByPk($id);

if( $mini->delete()){
echo 1;
}else{
echo -1;
}
}
}