public function getArticles() { $articles = ArticleRecord::find()->select('article.seourl as url, article.name, structure.seourl as s_url, structure.label')->leftJoin('structure', '`structure`.`id` = `article`.`parent_id`')->where(['article.active' => ArticleRecord::STATUS_IS_ACTIVE])->andWhere(['<', 'article.active_from', time()])->with('structure')->asArray()->all(); $menu = Yii::$app->mainMenu->getMainMenu(); $arts = []; foreach ($articles as $art) { if (!isset($arts[$art['s_url']])) { $arts[$art['s_url']] = []; } $arts[$art['s_url']][] = $art; } foreach ($menu as $k => $first_level) { if (isset($arts[$first_level['url']])) { $menu[$k]['articles'] = $arts[$first_level['url']]; } $cnt = 0; if ($first_level['children']) { foreach ($first_level['children'] as $l => $second_level) { if (isset($arts[$second_level['url']])) { $menu[$k]['children'][$l]['articles'] = $arts[$second_level['url']]; $cnt++; } } } if (!$cnt) { unset($menu[$k]); } } return $menu; }
/** * Finds the ArticleRecord model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return ArticleRecord the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = ArticleRecord::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
protected function _tryToGetContent($seourl) { $seourl = htmlspecialchars($seourl); if (!$seourl) { return ['type' => 'homepage', 'model' => null]; } // find in static pages $structureModel = new StructureRecord(); $page = $structureModel->find()->where(['seourl' => $seourl])->one(); if ($page) { $allowed = Yii::$app->mainMenu->checkContentPageCode($page->code); if ($allowed) { return ['type' => 'page', 'model' => $page]; } } // find in static articles $articleModel = new ArticleRecord(); $article = $articleModel->find()->where(['seourl' => $seourl, 'active' => ArticleRecord::STATUS_IS_ACTIVE])->andWhere('active_from < ' . time())->one(); if ($article) { return ['type' => 'article', 'model' => $article]; } return false; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { if (!isset($params['parent_id'])) { throw new \Exception('Property parent_id must be setted'); } $query = ArticleRecord::find()->where(['parent_id' => $params['parent_id']]); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]], 'pagination' => ['pageSize' => 10]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'parent_id' => $this->parent_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'active_from' => $this->active_from, 'sort' => $this->sort, 'active' => $this->active]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'preview_text', $this->preview_text])->andFilterWhere(['like', 'detail_text', $this->detail_text])->andFilterWhere(['like', 'soc_text', $this->soc_text])->andFilterWhere(['like', 'keywords', $this->keywords])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'seourl', $this->seourl])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'file', $this->file]); return $dataProvider; }
protected function _initItems() { $this->_items = ArticleRecord::find()->where(['active' => ArticleRecord::STATUS_IS_ACTIVE])->andWhere(['<', 'active_from', time()])->orderBy(['active_from' => SORT_DESC])->limit(5)->all(); }
protected function _initItems() { $this->_items = ArticleRecord::find()->select('article.*')->leftJoin('structure', '`structure`.`id` = `article`.`parent_id`')->where(['article.active' => ArticleRecord::STATUS_IS_ACTIVE])->andWhere(['<', 'article.active_from', time()])->andWhere(['structure.code' => $this->parentCode])->orderBy(['article.active_from' => SORT_DESC])->with('structure')->limit($this->count)->all(); }