public function actionTab($tab) { $searchModel = new RequestSearch(); $html = null; switch ($tab) { case 1: $query = Request::find()->where(['user_id' => Yii::$app->user->id]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); $html = $this->renderPartial('GridViewMyRequest', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); break; case 2: $query = Request::find()->joinWith('usersRequests')->where(['users_request.user_id' => Yii::$app->user->id]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); $html = $this->renderPartial('GridViewRequestAssigned', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); break; case 3: $area = Area::find()->where(['id_responsable' => Yii::$app->user->id])->one(); $query = Request::find()->joinWith('areasRequests')->where(['areas_request.area_id' => $area->id]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); $html = $this->renderPartial('GridViewRequestForArea', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); break; case 4: $dataProvider = $searchModel->search(Yii::$app->request->queryParams, null); $html = $this->renderPartial('GridViewAllRequest', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); break; case 5: $query = Request::find()->where(['status' => 'Calendarizada']); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); $html = $this->renderPartial('GridViewRequestScheduled', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); break; } return JSON::encode($html); }
/** * Lists all Request models. * @return mixed */ public function actionIndex() { $searchModel = new RequestSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }