/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Gallery::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'table_id' => $this->table_id, 'parent' => $this->parent, 'parent_id' => $this->parent_id, 'status' => $this->status, 'createdby' => $this->createdby, 'createdon' => $this->createdon, 'like' => $this->like, 'dislike' => $this->dislike, 'views' => $this->views, 'rate' => $this->rate, 'rate_num' => $this->rate_num]); $query->andFilterWhere(['like', 'table_name', $this->table_name])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'introtext', $this->introtext])->andFilterWhere(['like', 'content', $this->content]); $query->orderBy('sort'); return $dataProvider; }
/** * Lists all Gallery models. * @return mixed */ public function actionIndex($table_id, $use_layout = true) { if (CatalogProducts::findOne($table_id)->createdby == \Yii::$app->user->getId()) { $query = Gallery::find()->andFilterWhere(['table_id' => $table_id, 'table_name' => 'catalog']); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!$use_layout) { $this->layout = '//blank'; } else { $this->layout = '//main'; } return $this->render('index', ['dataProvider' => $dataProvider, 'table_id' => $table_id]); } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
?> </h1> <div class="lead"> <p><?php echo $model->introtext; ?> </p> </div> <!-- End Text --> <!-- Media Gallery --> <div class="blog-media mt-40 mb-40 mb-xs-30"> <ul class="clearlist content-slider"> <?php foreach (Gallery::find()->where(['table_id' => $model->id, 'table_name' => 'content', 'status' => Gallery::STATUS_PUBLISHED])->orderBy('sort asc')->all() as $element) { ?> <li><?php echo Html::img(Image::thumb($element->image, 945, 532)); ?> </li <?php } ?> </ul> </div> <p><?php echo $model->content; ?>
public function run() { $model = new Gallery(); $elements = $model->find()->where("table_id = {$this->id} AND table_name = '{$this->table_name}'")->all(); return $this->render('getGalleryElements/index', ['elements' => $elements]); }