/** * 好友的心情 */ 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); }