public function actionTopic()
{
$this->title = '关注的建议' . ' - ' . Yii::$app->name;
$this->description = '';
if (Yii::$app->user->isGuest) {
return $this->redirect('/account/login?next=/account/topic');
}
$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.id', Follow::Topic()]);
$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('topic', ['model' => $model, 'pagination' => $pagination]);
}
