public function actionIndex()
{
$query = Article::find()->from(['t' => Article::tableName()])->joinWith(['category', 'titleImage'])->andWhere(['t.published' => 1])->groupBy('id')->orderBy('position DESC, date DESC');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Article::PAGE_SIZE, 'pageSizeParam' => false]]);
PageSeo::registerSeo(PageSeo::ID_HOME_PAGE);
return $this->render('../modules/article/views/default/index', ['dataProvider' => $dataProvider]);
}
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 actionView($alias)
{
/** @var Article $model */
$model = Article::find()->from(['t' => Article::tableName()])->joinWith(['titleImage', 'category'])->andWhere(['t.alias' => $alias, 't.published' => 1])->one();
if (!$model) {
throw new NotFoundHttpException(\Yii::t('app', 'Page not found'));
}
$model->views = $model->views + 1;
$model->save(false);
MetaTagRegister::register($model);
if (\Yii::$app->request->isAjax) {
return $this->renderAjax('view', ['model' => $model]);
}
return $this->render('view', ['model' => $model]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getArticles()
{
return $this->hasMany(Article::className(), ['category_id' => 'id'])->from(['t1' => Article::tableName()])->andOnCondition(['t1.published' => 1]);
}
public function actionIndex($query)
{
$queryData = Article::find()->from(['t' => Article::tableName()])->joinWith(['category', 'titleImage'])->andWhere(['t.published' => 1])->andWhere('t.label LIKE :query OR t.content LIKE :query OR t.tags LIKE :query', [':query' => "%{$query}%"])->groupBy('id')->orderBy('t.position DESC, t.date DESC');
$dataProvider = new ActiveDataProvider(['query' => $queryData, 'pagination' => ['pageSize' => Article::PAGE_SIZE, 'pageSizeParam' => false]]);
return $this->render('../default/index', ['dataProvider' => $dataProvider, 'query' => $query, 'categoryLabel' => \Yii::t('app', 'Search')]);
}
