public function actionIndex()
{
$this->title = Yii::$app->name;
$this->description = 'V2SEX，一个很实在的技术宅的专属社区。在这里交流技术，各种创意点子，聊妹子，聊男人，同性恋，各种兴趣爱好，提问，甚至可以交流AV。';
$tab = Yii::$app->request->get('tab');
$sessionTab = Yii::$app->session->get('tab');
if (Yii::$app->request->get('tab') === null) {
if (empty($sessionTab)) {
Yii::$app->session->set('tab', 'tech');
$tab = 'tech';
} else {
$tab = $sessionTab;
}
} else {
if (Tab::findOne(['enname' => $tab]) !== null) {
Yii::$app->session->set('tab', $tab);
} else {
Yii::$app->session->set('tab', 'tech');
$tab = 'tech';
}
}
$tabModel = Tab::find()->where(['enname' => $tab])->one();
if (!empty($tabModel->bg) && $tabModel->use_bg == 1) {
$this->bg = $tabModel->bg;
}
if (!empty($tabModel->bg_color)) {
$this->bg_color = $tabModel->bg_color;
}
if ($tab == 'new') {
$topic = (new Query())->select('topic.*, node.enname, node.name, user.username, user.avatar')->from(Topic::tableName() . ' topic')->leftJoin(Node::tableName() . ' node', 'node.id = topic.node_id')->leftJoin(User::tableName() . ' user', 'user.id = topic.user_id')->where('node.is_hidden = 0')->orderBy(['topic.updated_at' => SORT_DESC])->limit(20)->all();
} else {
$topic = (new Query())->select('topic.*, node.enname, node.name, user.username, user.avatar')->from(Topic::tableName() . ' topic')->leftJoin(Node::tableName() . ' node', 'node.id = topic.node_id')->leftJoin(User::tableName() . ' user', 'user.id = topic.user_id')->where('node.is_hidden = 0')->andWhere(['in', 'topic.node_id', Tab::SubNodeId($tab)])->orderBy(['topic.updated_at' => SORT_DESC])->limit(20)->all();
}
return $this->render('index', ['topic' => $topic]);
}
public function actionIndex()
{
$this->title = Yii::$app->name;
$this->description = '云建议，一个收集建议的地方。';
$tab = Yii::$app->request->get('tab');
$sessionTab = Yii::$app->session->get('tab');
if (Yii::$app->request->get('tab') === null) {
if (empty($sessionTab)) {
Yii::$app->session->set('tab', 'new');
$tab = 'new';
} else {
$tab = $sessionTab;
}
} else {
if (Tab::Info($tab) !== null) {
Yii::$app->session->set('tab', $tab);
} else {
Yii::$app->session->set('tab', 'new');
$tab = 'new';
}
}
$tabModel = Tab::Info($tab);
if (!empty($tabModel['bg']) && $tabModel['use_bg'] == 1) {
$this->bg = $tabModel['bg'];
}
if (!empty($tabModel['bg_color'])) {
$this->bg_color = $tabModel['bg_color'];
}
$this->canonical = Yii::$app->params['domain'] . '?tab=' . $tab;
if ($tab == 'new') {
$topic = (new Query())->select('topic.*, node.enname, node.name, user.username, user.avatar')->from(Topic::tableName() . ' topic')->leftJoin(Node::tableName() . ' node', 'node.id = topic.node_id')->leftJoin(User::tableName() . ' user', 'user.id = topic.user_id')->where(['node.is_hidden' => 0])->orderBy(['topic.updated_at' => SORT_DESC])->limit(Yii::$app->params['pageSize'])->all();
} else {
$topic = (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.node_id', Tab::SubNodeId($tab)])->orderBy(['topic.updated_at' => SORT_DESC])->limit(Yii::$app->params['pageSize'])->all();
}
return $this->render('index', ['topic' => $topic]);
}
