public function run() { $controller = $this->getController(); $controller->layout = 'main'; $controller->_seoTitle = Yii::t('common', 'User Center') . ' - ' . $controller->_setting['site_name']; //我的好友 $uid = Yii::app()->user->id; $friend_mod = new Friend(); $criteria = new CDbCriteria(); $criteria->condition = 't.user_id=' . $uid; $criteria->order = 't.id DESC'; //分页 $count = $friend_mod->count($criteria); $pages = new CPagination($count); $pages->pageSize = 15; $pages->applyLimit($criteria); $datalist = $friend_mod->findAll($criteria); foreach ((array) $datalist as $k => $v) { $user = User::model()->findByPk($v->friend_user_id); $datalist[$k]['friend_name'] = $user->username; } $controller->render('my_friends', array('datalist' => $datalist, 'pages' => $pages)); }
public function run() { $controller = $this->getController(); $controller->layout = 'main'; $this->_setting = $controller->_setting; $this->_stylePath = $controller->_stylePath; $this->_static_public = $controller->_static_public; $this->_seoTitle = Yii::t('common', 'User Center') . ' - ' . $this->_setting['site_name']; //加载css,js Yii::app()->clientScript->registerCssFile($this->_stylePath . "/css/user.css"); Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.js"); //我的好友 $uid = Yii::app()->user->id; $friend_mod = new Friend(); $uid = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->condition = 't.uid1=' . $uid . ' OR t.uid2=' . $uid; $criteria->order = 't.id DESC'; //分页 $count = $friend_mod->count($criteria); $pages = new CPagination($count); $pages->pageSize = 15; $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $datalist = $friend_mod->findAll($criteria); foreach ((array) $datalist as $k => $v) { if ($v->uid1 == $uid) { $user = User::model()->findByPk($v->uid2); } else { $user = User::model()->findByPk($v->uid1); } $datalist[$k]['friend_name'] = $user->username; $datalist[$k]['friend_id'] = $user->uid; } $controller->render('my_friends', array('datalist' => $datalist, 'pages' => $pages)); }
public function actionAjax() { $model = new Friend(); $name = Yii::app()->request->getParam('name'); $out = ''; //初始化 $criteria = new CDbCriteria(); $criteria->condition = "uid=:uid AND status = 1"; $criteria->params = array(':uid' => Yii::app()->user->id); //用户名前匹配 $likecd = "fusername LIKE '" . $name . "%'"; $criteria->addCondition($likecd); $friends = $model->findAll($criteria); foreach ($friends as $key => $value) { $out[$key]["fUid"] = $value["fuid"]; $out[$key]["friendUserName"] = $value["fusername"]; $out[$key]["friendHeadPic"] = ''; } echo '(' . CJSON::encode($out) . ')'; }
public function actionGetAllFriends() { $model = new Friend(); $uid = Yii::app()->user->id; $gid = Yii::app()->request->getParam('type'); $page = Yii::app()->request->getParam('pageSize'); $_GET["page"] = $page; $out = ''; //初始化 $criteria = new CDbCriteria(); $criteria->order = 'dateline'; $criteria->condition = "t.uid=:uid AND status = 1"; $criteria->params = array(':uid' => Yii::app()->user->id); $withOption = array('user'); //取得数据总数,分页显示 if (!empty($gid)) { //去除AR,手动LEFT JOIN $tablename = FriendBelongGroup::model()->tableName(); $modelname = Friend::model()->tableName(); $criteria->join = "LEFT JOIN {$tablename} ON {$tablename}.uid = t.uid AND {$tablename}.fuid = t.fuid"; $criteria->addCondition('gid=' . $gid); } $total = $model->count($criteria); $pages = new CPagination($total); $pages->pageSize = self::PAGE_SIZE; $pages->applyLimit($criteria); //获取数据集 $friends = $model->findAll($criteria); foreach ($friends as $key => $value) { $user = $value->user; $out[$key]["fUid"] = $value["fuid"]; $out[$key]["friendUserName"] = $value["fusername"]; $user = $value->user; if (!empty($user)) { $out[$key]["friendHeadPic"] = $user->getUserFace(); } } echo '(' . CJSON::encode($out) . ')'; }