/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Classified::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, 'category_id' => $this->category_id, 'country_id' => $this->country_id, 'region_id' => $this->region_id, 'city_id' => $this->city_id, 'price' => $this->price, 'create_at' => $this->create_at, 'update_at' => $this->update_at, 'user_id' => $this->user_id, 'is_status' => $this->is_status, 'type' => $this->type]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
public function actionClassified($id) { $modelCover = new Profile(); $modelCover = $this->findModel($id); //Sort data $sort = new \yii\data\Sort(['attributes' => ['create_at' => ['asc' => ['create_at' => SORT_ASC], 'desc' => ['create_at' => SORT_DESC], 'default' => SORT_DESC]]]); //pagination $queryPage = Classified::find()->where(['user_id' => $id]); $countQueryPage = clone $queryPage; $pagination = new \yii\data\Pagination(['totalCount' => $countQueryPage->count(), 'pageSize' => 2]); //Search $mainCategory = \common\models\MainCategory::find()->all(); $searchModel = new \common\models\search\GSearch(); $dataProvider = $searchModel->search(\Yii::$app->request->queryParams); //query model $query = new \yii\db\Query(); $query->select(['classified.id', 'classified.title', 'classified.description', 'classified.price', 'classified.create_at', 'classified.type', 'classified.user_id', 'classified.is_status', 'main_category.main_category', 'category.category', 'country.country', 'region.region', 'city.city', 'user.username'])->from('classified')->join('JOIN', 'category', 'category.id = classified.category_id')->join('JOIN', 'main_category', 'main_category.id = classified.main_category_id')->join('JOIN', 'country', 'country.id = classified.country_id')->join('JOIN', 'region', 'region.id = classified.region_id')->join('JOIN', 'city', 'city.id = classified.city_id')->join('JOIN', 'user', 'user.id = classified.user_id')->where(['user_id' => $id])->offset($pagination->offset)->limit($pagination->limit)->orderBy($sort->orders)->all(); $command = $query->createCommand(); $data = $command->queryAll(); return $this->render('classified', ['data' => $data, 'sort' => $sort, 'pagination' => $pagination, 'maincategory' => $mainCategory, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'modelCover' => $modelCover]); }
</span> <span class="diadoo-botton-link"><a href="<?php echo \yii\helpers\Url::to(['/statistic-classified/']); ?> "><i class="fa fa-search-plus"></i> Details</a></span> </div><!-- /.info-box-content --> </div><!-- /.info-box --> </div><!-- /.col --> <!-- fix for small devices only --> <div class="clearfix visible-sm-block"></div> <div class="col-md-4 col-sm-6 col-xs-12"> <div class="info-box"> <span class="info-box-icon bg-red"><i class="fa fa-remove"></i></span> <div class="info-box-content"> <span class="info-box-text">Inactive Classified</span> <span class="info-box-number"> <?php echo $queryInactive = \common\models\Classified::find()->where(['is_status' => 0])->count(); ?> </span> <span class="diadoo-botton-link"><a href="<?php echo \yii\helpers\Url::to(['/statistic-classified/']); ?> "><i class="fa fa-search-plus"></i> Details</a></span> </div><!-- /.info-box-content --> </div><!-- /.info-box --> </div><!-- /.col --> </div>
/** * MyList * Status : Oke * @return mixed */ public function actionMyList() { $query = Classified::find()->join('JOIN', 'category', 'category.id = classified.category_id')->where(['user_id' => Yii::$app->user->identity->id]); $dataProvider = new \yii\data\ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20]]); return $this->render('my-list', ['dataProvider' => $dataProvider]); }
} ?> </ul> </section> </li> <?php } // } ?> </ul> <div style="text-align: center;"> <h3>Total data</h3> <p style="font-size: 20px"><?php echo $countAll = \common\models\Classified::find()->count(); ?> </p> </div> </div> </div> </div> <div style="text-align: center; padding-bottom: 15px"> <img src="banner/image/digitalocean-banner.jpg"> </div> </div> <div class="col-lg-3"> <div class="panel"> <div class="panel-heading"> </div>