/**
* 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'));
//
}
}
