/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function searchNews($params) { $lang = Lang::getCurrent(); switch ($lang->local) { case Lang::LANG_EN: $category_id = self::NEWS_CATEGORY_EN; break; case Lang::LANG_RU: default: $category_id = self::NEWS_CATEGORY; break; } $query = Page::find()->joinWith('user'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]], 'pagination' => ['pageSize' => Yii::$app->params['items-per-page'], 'pageSizeParam' => false]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category_id' => $category_id, 'published' => 1, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); /* $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'intro', $this->intro]) ->andFilterWhere(['like', 'text', $this->text]) ->andFilterWhere(['like', 'meta_title', $this->meta_title]) ->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords]) ->andFilterWhere(['like', 'meta_descr', $this->meta_descr]); */ return $dataProvider; }
public function actionIndex() { $query = Page::find()->where(['user_id' => Yii::$app->user->identity->id]); $pagination = new Pagination(['defaultPageSize' => 10, 'totalCount' => $query->count()]); $pages = $query->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('index', ['pages' => $pages, 'pagination' => $pagination]); }
public function actionIndex($catid = 0) { $view = LuLu::getView(); $category = null; $query = Page::find()->where(['status' => 1]); if (intval($catid) > 0) { $query->andWhere(['category_id' => $catid]); $category = PageCategory::findOne($catid); if ($category !== null) { $view->setTitle(empty($category['seo_title']) ? $category['name'] : $category['seo_title']); $view->setMetaTag('keywords', $category['seo_keywords']); $view->setMetaTag('description', $category['seo_description']); $view->addBreadcrumb('页面', ['page/index']); $view->addBreadcrumb($category['name']); } } if ($category == null) { $view->setTitle('页面'); $view->addBreadcrumb('页面'); } $locals = LuLu::getPagedRows($query); $locals['catid'] = $catid; $locals['currentCategory'] = $category; return $this->render('index', $locals); }
public function actionView($id) { $model = Page::find()->andWhere(['id' => $id, 'published' => 1])->one(); if (!$model) { throw new NotFoundHttpException(); } return $this->render('view', ['model' => $model]); }
/** * Finds the Page model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Page the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($alias) { if (($model = Page::find()->where(['alias' => $alias])->one()) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function actionPage($slug) { $page = Page::find()->andWhere(['slug' => $slug])->one(); if (!$page) { throw new NotFoundHttpException('页面不存在'); } return $this->render('page', ['page' => $page]); }
public function actionView($slug) { $model = Page::find()->where(['slug' => $slug, 'status' => Page::STATUS_PUBLISHED])->one(); if (!$model) { throw new NotFoundHttpException(Yii::t('frontend', 'Page not found')); } $viewFile = $model->view ?: 'view'; return $this->render($viewFile, ['model' => $model]); }
/** * Displays homepage. * * @return mixed */ public function actionIndex() { $query = Page::find()->where(['live' => 1]); $pagination = new Pagination(['defaultPageSize' => 2, 'totalCount' => $query->count()]); $pages = $query->offset($pagination->offset)->limit($pagination->limit)->all(); $comments = Comment::getRecentComments(); $sidebarCategories = Category::getSidebarCategories(); $tags = Tag::getTagList(); return $this->render('index', ['pages' => $pages, 'pagination' => $pagination, 'comments' => $comments, 'sidebarCategories' => $sidebarCategories, 'tags' => $tags]); }
public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category_id' => $this->category_id, 'publish_time' => $this->publish_time, 'modify_time' => $this->modify_time, 'status' => $this->status, 'sort_num' => $this->sort_num]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'title_format', $this->title_format])->andFilterWhere(['like', 'title_pic', $this->title_pic])->andFilterWhere(['like', 'summary', $this->summary])->andFilterWhere(['like', 'body', $this->body])->andFilterWhere(['like', 'tpl', $this->tpl])->andFilterWhere(['like', 'seo_title', $this->seo_title])->andFilterWhere(['like', 'seo_keywords', $this->seo_keywords])->andFilterWhere(['like', 'seo_description', $this->seo_description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status]); $query->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'body', $this->body]); return $dataProvider; }
/** * Displays a single Page model. * * @param $slug * @return mixed */ public function actionView($slug) { $model = Page::find()->where(['slug' => $slug, 'status' => Page::STATUS_ACTIVE])->one(); if (!$model) { throw new NotFoundHttpException(Yii::t('frontend', 'Page not found.')); } // meta keywords $this->getView()->registerMetaTag(['name' => 'description', 'content' => $model->description]); // meta description $this->getView()->registerMetaTag(['name' => 'keywords', 'content' => $model->keywords]); return $this->render('view', ['model' => $model]); }
public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['like', 'name', $this->name]); $query->andFilterWhere(['like', 'slug', $this->slug]); $query->andFilterWhere(['published' => $this->published]); return $dataProvider; }
public function actionPage($alias) { $result = Page::find()->where(['alias' => $alias, 'project_id' => TFA::$info['id']])->one(); if (!$result) { throw new HttpException(404, 'No Page'); } if ($result->as_theme == 0) { echo $result->content; die; } return $this->render('page', ['result' => $result]); }
public function init() { $pages = Page::find()->selectNoText()->published()->all(); $this->_htmlStr = '<ul class="menu">'; $this->_htmlStr .= '<li role="presentation" ' . ($this->active('site', 'index', '') ? 'class="nav-current"' : '') . '>' . Html::a('首页', Url::home()) . '</li>'; if (!empty($pages)) { foreach ($pages as $page) { $this->_htmlStr .= '<li role="presentation" ' . ($this->active('site', 'page', $page->slug) ? 'class="nav-current"' : '') . '>' . Html::a($page->title, ['site/page', 'slug' => $page->slug, $this->options]) . '</li>'; } } $this->_htmlStr .= '</ul>'; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'parent_id' => $this->parent_id, 'is_url' => $this->is_url, 'is_seo' => $this->is_seo, 'status' => $this->status, 'created_dt' => $this->created_dt]); $query->andFilterWhere(['like', 'page_url', $this->page_url])->andFilterWhere(['like', 'page_name', $this->page_name])->andFilterWhere(['like', 'page_content', $this->page_content])->andFilterWhere(['like', 'page_seo_name', $this->page_seo_name])->andFilterWhere(['like', 'meta_values', $this->meta_values]); return $dataProvider; }
/** * Creates data provider instance with search query applied * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); if (!\Yii::$app->user->can('administrator')) { $query->forDomain(); } $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'domain_id' => $this->domain_id]); $query->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'body', $this->body])->andFilterWhere(['like', 'before_body', $this->before_body])->andFilterWhere(['like', 'after_body', $this->after_body])->andFilterWhere(['like', 'on_scenario', $this->on_scenario]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'route', $this->route])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'project_id' => Yii::$app->request->get('project_id')]); $query->andFilterWhere(['like', 'alias', $this->alias])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'META_TITLE', $this->META_TITLE])->andFilterWhere(['like', 'META_DESC', $this->META_DESC])->andFilterWhere(['like', 'META_KEYS', $this->META_KEYS]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'meta_title', $this->meta_title])->andFilterWhere(['like', 'meta_description', $this->meta_description])->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'pid' => $this->pid, 'order' => $this->order]); $query->andFilterWhere(['like', 'header', $this->header])->andFilterWhere(['like', 'sid', $this->sid])->andFilterWhere(['like', 'text', $this->text])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'desription', $this->desription])->andFilterWhere(['like', 'keywords', $this->keywords]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function searchNews($params, $category_id = 0) { $query = Page::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category_id' => $category_id, 'published' => $this->published, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'intro', $this->intro])->andFilterWhere(['like', 'text', $this->text])->andFilterWhere(['like', 'meta_title', $this->meta_title])->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords])->andFilterWhere(['like', 'meta_descr', $this->meta_descr]); //echo'<pre>';print_r($query);echo'</pre>';die; return $dataProvider; }
public function actionView($sid) { $service = Service::find()->select('*')->innerJoinWith('secs')->where(['service.sid' => $sid])->one(); $page = Page::find()->where(['sid' => Yii::$app->controller->id])->select(['id', 'pid', 'sid', 'header'])->one(); $pages = Page::find()->select(['id', 'pid', 'sid', 'header'])->asArray()->indexBy('id')->all(); $mode = $pages[$page->id]; $branch[] = $mode; while (!is_null($mode['pid'])) { $mode = $pages[$mode['pid']]; $branch[] = $mode; } krsort($branch); $branch[] = ['header' => $service->header]; return $this->render('view', ['service' => $service, 'branch' => $branch]); }
public function actionView($slug) { /** @var Page $model */ $model = Page::find()->where(['slug' => $slug, 'status' => Page::STATUS_PUBLISHED])->one(); if (!$model) { throw new NotFoundHttpException(Yii::t('frontend', 'Page not found')); } //Мета-теги foreach (['description', 'keywords'] as $name) { $attr = 'meta_' . $name; \Yii::$app->view->registerMetaTag(['name' => $name, 'content' => strlen($model->{$attr}) > 0 ? $model->{$attr} : Yii::$app->keyStorage->get('frontend.' . $attr)], $name); } $viewFile = $model->view ?: 'view'; return $this->render($viewFile, ['model' => $model]); }
public function actionView($sid) { $model = Page::find()->where(['sid' => $sid])->one(); $models = Page::find()->select(['id', 'pid', 'sid', 'header'])->asArray()->indexBy('id')->all(); $mode = $models[$model->id]; $branch[] = $mode; while (!is_null($mode['pid'])) { $mode = $models[$mode['pid']]; $branch[] = $mode; } krsort($branch); $db = Yii::$app->db; $current_menu = $db->createCommand('call current_menu(:sid)')->bindValue(':sid', $model->sid)->queryAll(); $current_menu = Tree::level($current_menu, $model->pid); return $this->render('view', ['model' => $model, 'current_menu' => $current_menu, 'branch' => $branch]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = PageModel::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'title_id' => $this->title_id, 'content_id' => $this->content_id, 'meta_title_id' => $this->meta_title_id, 'meta_description_id' => $this->meta_description_id, 'meta_keywords_id' => $this->meta_keywords_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'url_alias', $this->url_alias]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'published' => $this->published, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'meta_title', $this->meta_title])->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords])->andFilterWhere(['like', 'meta_description', $this->meta_description])->andFilterWhere(['like', 'meta_params', $this->meta_params])->andFilterWhere(['like', 'layouts', $this->layouts])->andFilterWhere(['like', 'views', $this->views]); return $dataProvider; }
/** * Creates data provider instance with search query applied. * * @param array $params * @return ActiveDataProvider */ public function search($params) { $query = Page::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => 30]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'keywords', $this->keywords])->andFilterWhere(['like', 'body', $this->body]); return $dataProvider; }
public function actionView($sid, $section) { $news = News::find()->select('*')->where(['sid' => $sid])->one(); $sectionM = SecNews::find()->select(['id', 'sid', 'header'])->where(['sid' => $section])->asArray()->one(); $page = Page::find()->where(['sid' => Yii::$app->controller->id])->select(['id', 'pid', 'sid', 'header'])->one(); $pages = Page::find()->select(['id', 'pid', 'sid', 'header'])->asArray()->indexBy('id')->all(); $mode = $pages[$page->id]; $branch[] = $mode; while (!is_null($mode['pid'])) { $mode = $pages[$mode['pid']]; $branch[] = $mode; } krsort($branch); $branch[] = $sectionM; $branch[] = ['header' => $news->header]; return $this->render('view', ['news' => $news, 'branch' => $branch]); }
/** * Creates a new Page model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { foreach (Yii::$app->params['availableLocales'] as $key => $value) { $currentModel = Page::getLocaleInstance($key); $currentModel->locale = $key; if (Yii::$app->request->get('scenario')) { $currentModel->on_scenario = Yii::$app->request->get('scenario'); } $models[$key] = $currentModel; } //set data from default model if (Yii::$app->request->get('locale_group_id')) { $defaultDomainModels = Page::find()->andFilterWhere(['domain_id' => Yii::getAlias('@defaultDomainId'), 'locale_group_id' => Yii::$app->request->get('locale_group_id')])->all(); foreach ($defaultDomainModels as $key => $value) { if (!in_array($value->locale, array_keys(Yii::$app->params['availableLocales']))) { continue; } $models[$value->locale]->slug = $value->slug; $models[$value->locale]->title = $value->title; $models[$value->locale]->head = $value->head; $models[$value->locale]->body = $value->body; $models[$value->locale]->before_body = $value->before_body; $models[$value->locale]->after_body = $value->after_body; } } $model = new MultiModel(['models' => $models]); if ($model->load(Yii::$app->request->post()) && Page::multiSave($model)) { return $this->redirect(['index']); } else { switch (Yii::$app->request->get('scenario')) { case 'extend': $viewName = 'extend'; break; default: $viewName = 'create'; } return $this->render($viewName, ['model' => $model]); } }
/** * Creates data provider instance with search query applied * @param $params * @return ActiveDataProvider */ public function search($params) { /** @var ActiveQuery $query */ $query = Page::find(); if (!isset($params['sort'])) { $query->orderBy(['updated_at' => SORT_DESC]); } $session = Yii::$app->session; if (!$session['language_id']) { $session['language_id'] = LanguageRecord::getMainLanguageId(); } $query->andWhere(['language_id' => $session['language_id']]); $dataProvider = new ActiveDataProvider(['query' => $query]); $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(['active' => $this->active, 'public' => $this->public]); $query->andFilterWhere(['like', 'title', $this->title]); return $dataProvider; }