/** * Lists all Content models. * @return mixed */ public function actionIndex() { $query = Content::find(); $pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]); $contents = $query->orderBy('id')->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('index', ['contents' => $contents, 'pagination' => $pagination]); }
public function actions() { $ret = []; foreach (Yii::$app->params["languages"] as $lng => $name) { $model = Content::find()->andWhere('name="briefing"')->andWhere('language="' . $lng . '"')->one(); $ret[$lng] = ['class' => BriefingAction::className(), 'model' => $model]; } return $ret; }
public function makeDropDown($langs = null) { global $data; $langs = $langs ? $langs : 'thai'; $data = array(); $parents = Content::find()->where(['langs' => $langs])->all(); foreach ($parents as $parent) { $data[$parent->id] = $parent->title; } return $data; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Content::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, 'user_id' => $this->user_id, 'category_id' => $this->category_id, 'create_time' => $this->create_time]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'summary', $this->summary]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Content::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]); $query->andFilterWhere(['like', 'title_uk', $this->title_uk])->andFilterWhere(['like', 'title_ru', $this->title_ru])->andFilterWhere(['like', 'title_en', $this->title_en])->andFilterWhere(['like', 'content_uk', $this->content_uk])->andFilterWhere(['like', 'content_ru', $this->content_ru])->andFilterWhere(['like', 'content_en', $this->content_en])->andFilterWhere(['like', 'tags_uk', $this->tags_uk])->andFilterWhere(['like', 'tags_ru', $this->tags_ru])->andFilterWhere(['like', 'tags_en', $this->tags_en])->andFilterWhere(['like', 'type', $this->type]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Content::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, 'courses_id' => $this->courses_id]); $query->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
public static function findOneByURL($url) { return Content::find()->select('content.*')->leftJoin('surl', 'surl.content_id = content.id')->where(['surl.name' => $url])->one(); }
public function actionDelete($id) { $model = Content::find($id); $model->delete(); return $this->redirect(array('index')); }
public function actionIndex() { $bl = Content::find()->andWhere('name = "bannerLabel"')->one(); $bd = Content::find()->andWhere('name = "homePage"')->one(); return $this->render('index', ['bl' => $bl, 'bd' => $bd]); }
public function destroy($id) { Content::find($id)->delete(); return Redirect::route('admin.content.index'); }
public function actionAbout() { $model = Content::find()->where(['id' => 1])->one(); \Yii::$app->view->registerMetaTag(['name' => 'description', 'content' => $model->name]); $this->getMetaTagsDefault(); return $this->render('about', ['model' => $model]); }
public function actionPost() { $user = new User(); $user = \Yii::$app->user; if (\Yii::$app->user->isGuest) { return $this->redirect(['login']); } $query = Content::find()->where(['user_id' => $user->id]); $pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]); $contents = $query->orderBy('id')->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('post', ['contents' => $contents, 'user' => $user, 'pagination' => $pagination]); }
public function actionList() { $dataProvider = new ActiveDataProvider(['query' => Content::find(), 'pagination' => ['pageSize' => 2]]); return $this->render('list', ['dataProvider' => $dataProvider]); }