<?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;
}
}
}
分享到:
相关推荐
MvcPager分页示例MVC2.0源码 MvcPager分页示例MVC2.0 开发环境:VS2008SP1+MVC2.0+MSSQL2005 ASP.NET MvcPager 1.3版发布(2010-3-30) MvcPager分页控件是在ASP.NET MVC Web应用程序中实现分页功能的一系列扩展...
Ajax无刷新分页示例源码 程序介绍: 程序使用jquery方法提交请求,处理后将数据库绑定到页面中。 Ajax无刷新分页示例源码 程序介绍: 程序使用jquery方法提交请求,处理后将数据库绑定到页面中。 Ajax无...
js分页示例,前台分页,客户端分页,分页机制,js分页
八套静态页数字分页示例.rar八套静态页数字分页示例.rar八套静态页数字分页示例.rar八套静态页数字分页示例.rar八套静态页数字分页示例.rar
jsp 分页示例完整版
ACCESS高效分页示例, 测试数据50万
dwr 分页示例(jsp) dwr 分页示例(jsp) dwr 分页示例(jsp)
mysql分页示例mysql分页示例mysql分页示例
asp.net中GridView高效分页示例,非使用存储过程,简单易用,效率高。
分页示例.zip
JSP环境下的AJAX分页示例,实现的分页技术
SpringMVC3.0+MyIbatis3.0(分页示例
SQL2008查询分页示例,用临时表,通过ROW_NUMBER()来分页
主要介绍了利用js制作html table的分页示例(js实现分页),需要的朋友可以参考下
三层Gridview分页示例源码 功能介绍: 引用简单的三层架构,并在Gridview控件上显示, 利用AspNetPager控件实现分页功能。
jQuery漂亮滚动分页示例插件(jPaginate)
pagination 分页示例 简洁版 注释 最新
利用jQuery拓展的分页插件,无刷新分页,资源包中有示例