/** * 我的心情 */ public function actionAll() { $uid = Yii::app()->user->id; $model = new Mini(); //初始化 $criteria = new CDbCriteria(); $criteria->order = 't.ctime DESC'; $criteria->condition = "1 AND t.status != -1"; $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('first','last','count'))->findAll($criteria); $mini_list = $model->findAll($criteria); $data = array('mini_list' => $mini_list, 'pages' => $pages, 'mini' => $mini, 'icon_list' => $icon_list); $this->render('my', $data); }
/** * 获得用户心情 */ public function getUserMini() { $model = new Mini(); $uid = $this->id; $criteria = new CDbCriteria(); $criteria->order = 'ctime DESC'; $criteria->condition = "uid=:uid"; $criteria->params = array(':uid' => $uid); $mini = $model->find($criteria); return $mini['content']; }