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() { $models = Article::find()->joinWith(['titleImage'])->isPublished()->orderBy('views DESC')->limit(3)->all(); if (empty($models)) { return false; } return $this->render('default', ['models' => $models]); }
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]); }
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')]); }