public function run()
{
$this->registerClientAssets();
$query = new TaggingQuery();
$this->tags = $query->select('tags')->from('{{%posts}}')->getTags();
return $this->render('tag_cloud_widget', ['widget' => $this]);
}
public function run()
{
$query = new TaggingQuery();
$tags = $query->select('tags')->from(Article::tableName())->delimiter(', ')->getTags();
if (empty($tags)) {
return false;
}
return $this->render('default', ['tags' => $tags]);
}
public function actionPosts()
{
$query = new Query();
$query->select('e.id, title, content, e.created_at, u.username, u.avatar')->from('{{%home_post}} as e')->join('LEFT JOIN', '{{%user}} as u', 'u.id=e.user_id')->where('e.explore_status=1')->orderBy('e.id DESC');
//按标签查询出文章
if (Yii::$app->request->isGet) {
$tag = Yii::$app->request->get('tag');
$query->where('tags LIKE :tag', [':tag' => '%' . $tag . '%'])->andWhere('explore_status=1');
}
$posts = Yii::$app->tools->Pagination($query, 10);
//标签列表
$query = new TaggingQuery();
$tags = $query->select('tags')->from('{{%home_post}}')->where('explore_status=1')->limit(10)->displaySort(['freq' => SORT_DESC])->getTags();
return $this->render('posts', ['posts' => $posts, 'tags' => $tags]);
}
public function actionIndex()
{
$query = new Query();
$query = $query->select('*')->from('{{%home_post}}')->where('user_id=:user_id', [':user_id' => Yii::$app->user->id])->orderBy('created_at DESC');
//按标签查询出文章
if (Yii::$app->request->isGet) {
$tag = Yii::$app->request->get('tag');
$query->andWhere('tags LIKE :tag', [':tag' => '%' . $tag . '%']);
}
$posts = Yii::$app->tools->Pagination($query);
//标签列表
$query = new TaggingQuery();
$tags = $query->select('tags')->from('{{%home_post}}')->where('user_id=:user_id', [':user_id' => Yii::$app->user->id])->displaySort(['freq' => SORT_DESC])->getTags();
return $this->render('index', ['tags' => $tags, 'posts' => $posts['result'], 'pages' => $posts['pages']]);
}