/** * 获取我关注的人 * @param bool $onlyId * @return array|\yii\db\ActiveRecord[] */ static function User($onlyId = true) { if ($onlyId) { if (!($FollowUser = Yii::$app->cache->get('FollowUserId' . Yii::$app->user->id))) { $FollowUser = ArrayHelper::map(Follow::find()->select('follow_id')->where(['user_id' => Yii::$app->user->id, 'type' => 1])->asArray()->all(), 'follow_id', 'follow_id'); Yii::$app->cache->set('FollowUserId' . Yii::$app->user->id, $FollowUser, 0); } } else { if (!($FollowUser = Yii::$app->cache->get('FollowUser' . Yii::$app->user->id))) { $FollowUser = (new Query())->from(User::tableName())->where(['in', 'id', Follow::User()])->all(); Yii::$app->cache->set('FollowUser' . Yii::$app->user->id, $FollowUser, 0); } } return $FollowUser; }
public function actionFollow() { $this->title = '关注的人提的建议' . ' - ' . Yii::$app->name; $this->description = ''; if (Yii::$app->user->isGuest) { return $this->redirect('/account/login?next=/account/follow'); } $query = (new Query())->select('topic.*, node.enname, node.name, user.username, user.avatar')->from(Topic::tableName())->leftJoin(Node::tableName(), 'node.id = topic.node_id')->leftJoin(User::tableName(), 'user.id = topic.user_id')->where(['in', 'topic.user_id', Follow::User()]); $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $model = $query->orderBy(['id' => SORT_DESC])->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('follow', ['model' => $model, 'pagination' => $pagination]); }
<?php $follow = \common\models\Follow::User(false); if (!empty($follow)) { ?> <section> <div class="block-header"><small>我关注的人</small></div> <?php foreach ($follow as $f) { ?> <article class="sidebar block-hot-topic"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <tbody><tr> <td width="24" valign="middle" align="center"> <a href="/member/<?php echo $f['username']; ?> "><img src="<?php echo Yii::$app->params['avatarUrl'] . '/24/' . $f['avatar']; ?> " class="img-rounded"></a> </td> <td width="10"></td> <td width="auto" valign="middle"> <span class="hot_topic"> <a href="/member/<?php echo $f['username']; ?> "><?php echo $f['username']; ?>