/** * Lists all Scheduleheader models. * @return mixed */ public function actionIndex() { $aryDataProviderRptScdl = new ArrayDataProvider(['key' => 'ID', 'allModels' => Yii::$app->db_esm->createCommand("CALL ERP_CUSTOMER_VISIT_SchaduleReport('2016-06-30')")->queryAll(), 'pagination' => ['pageSize' => 50]]); $attributeField = $aryDataProviderRptScdl->allModels[0]; //get label Array 0 $searchModel = new ScheduleheadertempSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $searchModel1 = new ScheduleheadertempSearch(); $dataProvider1 = $searchModel->searchid(Yii::$app->request->queryParams); $searchModelUser = new UserloginSearch(); $dataProviderUser = $searchModelUser->searchCustGroup(Yii::$app->request->queryParams); $model = new Scheduleheader(); // data select2 for SCDL_GROUP $query = Schedulegroup::find()->all(); $datagroup = ArrayHelper::map($query, 'ID', 'SCDL_GROUP_NM'); // data select2 for SCDL_GROUP_NM $query = Schedulegroup::find()->all(); $datagroup_nm = ArrayHelper::map($query, 'SCDL_GROUP_NM', 'SCDL_GROUP_NM'); // data select2 for USER_ID where CRM and STATUS 10(active) $query1 = Userlogin::find()->where('POSITION_SITE = "CRM" AND STATUS = 10')->all(); $datauser = ArrayHelper::map($query1, 'id', 'username'); //componen user option $profile = Yii::$app->getUserOpt->Profile_user()->emp; $id = $profile->EMP_ID; $user_profile = Employe::find()->where(['EMP_ID' => $id])->one(); return $this->render('index', ['dataProviderUser' => $dataProviderUser, 'searchModelUser' => $searchModelUser, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'searchModel1' => $searchModel1, 'dataProvider1' => $dataProvider1, 'model' => $model, 'datagroup' => $datagroup, 'datauser' => $datauser, 'aryDataProviderRptScdl' => $aryDataProviderRptScdl, 'attributeField' => $attributeField, 'user_profile' => $user_profile, 'datagroup_nm' => $datagroup_nm]); }
/** * Lists all Scheduleheader models. * @return mixed */ public function actionIndex() { $searchModel = new ScheduleheaderSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $searchModelUser = new UserloginSearch(); $dataProviderUser = $searchModelUser->searchCustGroup(Yii::$app->request->queryParams); $model = new Scheduleheader(); // data select2 for SCDL_GROUP $query = Schedulegroup::find()->all(); $datagroup = ArrayHelper::map($query, 'ID', 'SCDL_GROUP_NM'); // data select2 for USER_ID where CRM and STATUS 10(active) $query1 = Userlogin::find()->where('POSITION_SITE = "CRM" AND STATUS = 10')->all(); $datauser = ArrayHelper::map($query1, 'id', 'username'); return $this->render('index', ['dataProviderUser' => $dataProviderUser, 'searchModelUser' => $searchModelUser, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'datagroup' => $datagroup, 'datauser' => $datauser]); }
/** * Lists all Scheduleheader models. * @return mixed */ public function actionIndex() { if (Helper::checkRoute('index')) { $searchModel = new ScheduleheaderSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $searchModelUser = new UserloginSearch(); $dataProviderUser = $searchModelUser->searchCustGroup(Yii::$app->request->queryParams); $model = new Scheduleheader(); return $this->render('index', ['dataProviderUser' => $dataProviderUser, 'searchModelUser' => $searchModelUser, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'datagroup' => $datagroup, 'datauser' => $datauser]); } else { Yii::$app->user->logout(); $this->redirect(array('/site/login')); // } }