/** * Displays homepage. * * @return mixed */ public function actionIndex() { //$mainCategory = new MainCategory(); // $category = new Category(); //Search $mainCategory = MainCategory::find()->all(); $searchModel = new \common\models\search\GSearch(); $dataProvider = $searchModel->search(\Yii::$app->request->queryParams); return $this->render('index', ['maincategory' => $mainCategory, 'searchModel' => $searchModel, 'dataProvider' => $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]); }
public function actionGsearch() { $searchModel = new \common\models\search\GSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('_gsearch', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }