/** * Lists all Post models. * @return mixed */ public function actionIndex() { $kategory_forum = Yii::$app->session['forum_id']; $posting = Post::find()->where(['kategory_forum' => $kategory_forum])->all(); $forum = Forum::find()->where(['id' => $kategory_forum])->one(); $nama = ""; foreach ($posting as $postings) { $nama = $postings->nama; } $usr = new \common\models\User(); $fotoPost = $usr->find()->where(['nama' => $nama])->all(); return $this->render('index', ['posting' => $posting, 'forum' => $forum, 'fotoPost' => $fotoPost]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Post::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', '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 = Post::find(); $query->select('{{%post}}.*,{{%user}}.username'); $query->joinWith(['author']); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['attributes' => ['id' => ['asc' => ['{{%post}}.id' => SORT_ASC], 'desc' => ['{{%post}}.id' => SORT_DESC], 'label' => 'Id'], 'author_id' => ['asc' => ['{{%post}}.author_id' => SORT_ASC], 'desc' => ['{{%post}}.author_id' => SORT_DESC], 'label' => 'Author Id'], 'created_at' => ['asc' => ['{{%post}}.created_at' => SORT_ASC], 'desc' => ['{{%post}}.created_at' => SORT_DESC], 'label' => 'Created At'], 'title' => ['asc' => ['{{%post}}.title' => SORT_ASC], 'desc' => ['{{%post}}.title' => SORT_DESC], 'label' => 'Title'], 'username' => ['asc' => ['{{%user}}.username' => SORT_ASC], 'desc' => ['{{%user}}.username' => SORT_DESC], 'label' => 'UserName']]]); $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(['{{%post}}.id' => $this->id, '{{%post}}.author_id' => $this->author_id, '{{%post}}.created_at' => $this->created_at]); $query->andFilterWhere(['like', '{{%post}}.title', $this->title]); $query->andFilterWhere(['like', '{{%user}}.username', $this->username]); return $dataProvider; }
<?php $current = 0; ?> <div class="pane latest-ads-holder"> <?php echo \yii\widgets\ListView::widget(['dataProvider' => new \yii\data\ActiveDataProvider(['query' => \frontend\models\Post::find()->where(['category' => $category])->orderBy('created DESC'), 'pagination' => ['pageSize' => 9]]), 'itemView' => function ($model) use(&$current) { return $this->render('_post_item_grid', ['item' => $model, 'current' => $current]); }, 'itemOptions' => ['class' => 'ad-box col-xs-3 latest-posts-grid' . ($current % 3 == 0 ? ' ' : '')], 'options' => ['class' => 'latest-ads-grid-holder'], 'summary' => '']); ?> </div>
/** * Возвращает опубликованные посты * @return ActiveDataProvider */ function getPublishedPosts() { return new ActiveDataProvider(['query' => Post::find()->where(['publish_status' => self::STATUS_PUBLISH])]); }
/** * Displays homepage. * * @return mixed */ public function actionIndex() { return $this->render('index', ['posts' => Post::find()->all(), 'categories' => Category::find()->where(['parent' => 0])->all(), 'postsDataProvider' => new ActiveDataProvider(['query' => Post::find()])]); }
public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Post::find(), 'pagination' => ['pageSize' => 10]]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function getCare() { $result = Post::find()->where(['group_post' => 3, 'status' => 1])->all(); return $result; }
/** * Lists all Post models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Post::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }