コード例 #1
0
 public function actionOutbox()
 {
     $this->setPageTitle('发件箱');
     $msgs = array();
     $user = new User();
     $uid = Yii::app()->user->id;
     $model = new Msg();
     //初始化
     $criteria = new CDbCriteria();
     $criteria->order = 'ctime';
     $criteria->condition = "t.fromUserId =:uid AND is_del = 0";
     $criteria->params = array(':uid' => $uid);
     $criteria->order = 'ctime DESC';
     //取得数据总数,分页显示
     $total = $model->count($criteria);
     $pages = new CPagination($total);
     $pages->pageSize = 20;
     $pages->applyLimit($criteria);
     //获取数据集
     $msgs = $model->findAll($criteria);
     $data = array('msgs' => $msgs, 'user' => $user, 'pages' => $pages);
     $this->render('inbox', $data);
 }