/** * 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')); // } }
$callback = function ($menu) { $data1 = $menu['data']; $data2 = str_replace("'", '', $data1); $data3 = str_replace(";", '', $data2); $data1 = $menu['data']; $data = eval($menu['data']); //echo $data; return ['label' => Icon::show($data3) . $menu['name'], 'url' => [$menu['route']], 'items' => $menu['children']]; }; /** * Validasi database Default EMP_ID =0 * note error : lost left join Field unn\known attribute properties * Author: -ptr.nov-, */ if (!Yii::$app->user->isGuest) { $ModelUserAttr = UserloginSearch::findUserAttr(Yii::$app->user->id)->one(); //print_r($ModelUserAttr); //echo $ModelUserAttr->emp->EMP_IMG; $MainAvatar = $ModelUserAttr->emp->EMP_IMG; $MainUserProfile = $ModelUserAttr->emp->EMP_NM; // . ' '. $ModelUserAttr->emp->EMP_NM_BLK; } $corp = "<p class='pull-left'>© LukisonGroup <?= date('Y') ?></p>"; ?> <! - NOT LOGIN- Author : -ptr.nov- > <?php if (Yii::$app->user->isGuest) { ?> <?php include '_front.php';
public function actionValidasi() { /* Author: -wawan- :validasi salesman-order*/ if (\Yii::$app->user->isGuest) { $model = new LoginForm(); return $this->render('index_nologin', ['model' => $model]); } else { $ModelUser = UserloginSearch::findUserAttr(Yii::$app->user->id)->one(); $model = $this->findModel1($ModelUser->emp->EMP_ID); $searchModel1 = new EmployeSearch(); $dataProvider = $searchModel1->search_empid($ModelUser->emp->EMP_ID); $js = '$("#confirm-permission-alert").modal("show")'; $this->getView()->registerJs($js); // echo \yii\helpers\Json::encode($dataProvider); //print_r($dataProvider->getModels()); return $this->render('index', ['model' => $model, 'dataProvider' => $dataProvider->getModels()]); } }
/** * GetDEP_ID from UserID UserloginSearch() * @author ptrnov <*****@*****.**> * @since 1.1 */ protected function getOptUser() { $UserloginSearch = new UserloginSearch(); $ModelUser = UserloginSearch::findUserAttr(Yii::$app->user->identity->id)->one(); if (count($ModelUser) != 0) { /*RECORD TIDAK ADA*/ //$deptid=$ModelUser->user->id; //$deptid=$ModelUser->emp->DEP_ID; return $ModelUser; } else { return 0; } }
public function actionGetTabIsi($tab) { // if ($tab==1){ // $searchModelMaintain = new DraftPlanDetailSearch(); // $dataProviderMaintain = $searchModelMaintain->search(Yii::$app->request->queryParams); // echo json_encode($dataProviderMaintain); // }; if ($tab == 0) { $searchModelPlan = new DraftPlanSearch(); $dataProviderPlan = $searchModelPlan->search(Yii::$app->request->queryParams); return $dataProviderPlan; } elseif ($tab == 1) { $searchModelMaintain = new DraftPlanDetailSearch(); $dataProviderMaintain = $searchModelMaintain->search(Yii::$app->request->queryParams); return Json::encode($dataProviderMaintain); } elseif ($tab == 4) { $searchModelGrp = new DraftPlanGroupSearch(); $searchModelUser = new UserloginSearch(); $dataProviderGrp = $searchModelGrp->search(Yii::$app->request->queryParams); $dataProviderUser = $searchModelUser->searchgroupplan(Yii::$app->request->queryParams); return $dataProviderGrp->getTotalCount() + $dataProviderUser->getTotalCount(); } else { return 0; } }
/** * ACTION CREATE note | $id=PrimaryKey -> TRIGER FROM VIEW -ptr.nov- */ public function actionCreate() { $model = new SignupForm(); if ($model->load(Yii::$app->request->post())) { if ($user = $model->signup()) { //if (Yii::$app->getUser()->login($user)) { // user save signup return langsung login // return $this->goHome(); //} $searchModel_Userlogin = new UserloginSearch(); $dataProvider_Userlogin = $searchModel_Userlogin->search(Yii::$app->request->queryParams); return $this->render('index', ['searchModel_Userlogin' => $searchModel_Userlogin, 'dataProvider_Userlogin' => $dataProvider_Userlogin]); } } return $this->render('signup', ['model' => $model]); }
/** * Lists all Mdlpermission models and Modul Erp models. * @return mixed */ public function actionIndex() { if (self::getPermission()->BTN_VIEW) { $searchModel = new UserloginSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $searchModelpermision = new MdlpermissionSearch(['USER_ID' => 1]); $dataProviderpermision = $searchModelpermision->search(Yii::$app->request->queryParams); $params = Yii::$app->request->queryParams; $baris = Modulerp::find()->count(); if (count($params) == 0) { } else { # code... if (count($params) < $baris) { $user_id = $params['MdlpermissionSearch']["USER_ID"]; $modul = Mdlpermission::find()->select('MODUL_ID')->where(['USER_ID' => $user_id])->asArray()->all(); $erp = Modulerp::find()->where(['not in', 'MODUL_ID', $modul])->all(); foreach ($erp as $key => $value) { # code... $connection = Yii::$app->db; $connection->createCommand()->batchInsert('modul_permission', ['USER_ID', 'MODUL_ID'], [[$user_id, $value['MODUL_ID']]])->execute(); } } } // print_r(count($params)); // die(); if (Yii::$app->request->post('hasEditable')) { $id = Yii::$app->request->post('editableKey'); Yii::$app->response->format = Response::FORMAT_JSON; $model = Mdlpermission::findOne($id); $out = Json::encode(['output' => '', 'message' => '']); $post = []; $posted = current($_POST['Mdlpermission']); $post['Mdlpermission'] = $posted; if ($model->load($post)) { $output = ''; if (isset($posted['BTN_CREATE'])) { $model->save(); $output = $model->BTN_CREATE; } if (isset($posted['BTN_EDIT'])) { $model->save(); $output = $model->BTN_EDIT; } if (isset($posted['BTN_DELETE'])) { $model->save(); $output = $model->BTN_DELETE; } if (isset($posted['BTN_VIEW'])) { $model->save(); $output = $model->BTN_VIEW; } if (isset($posted['BTN_REVIEW'])) { $model->save(); $output = $model->BTN_REVIEW; } if (isset($posted['BTN_PROCESS1'])) { $model->save(); $output = $model->BTN_PROCESS1; } if (isset($posted['BTN_PROCESS2'])) { $model->save(); $output = $model->BTN_PROCESS2; } if (isset($posted['BTN_PROCESS3'])) { $model->save(); $output = $model->BTN_PROCESS3; } if (isset($posted['BTN_PROCESS4'])) { $model->save(); $output = $model->BTN_PROCESS4; } if (isset($posted['BTN_PROCESS5'])) { $model->save(); $output = $model->BTN_PROCESS5; } if (isset($posted['BTN_SIGN1'])) { $model->save(); $output = $model->BTN_SIGN1; } if (isset($posted['BTN_SIGN2'])) { $model->save(); $output = $model->BTN_SIGN2; } if (isset($posted['BTN_SIGN3'])) { $model->save(); $output = $model->BTN_SIGN3; } if (isset($posted['BTN_SIGN4'])) { $model->save(); $output = $model->BTN_SIGN4; } if (isset($posted['BTN_SIGN5'])) { $model->save(); $output = $model->BTN_SIGN5; } $out = Json::encode(['output' => $output, 'message' => '']); } echo $out; return; } //SCENARIO MESSAGE PERMMISSION -ptr.nov-- $paramMsg = Yii::$app->getRequest()->getQueryParam('msg'); if ($paramMsg == 'alert') { $jsMsg = '$("#msg-alert").modal("show")'; $this->getView()->registerJs($jsMsg); } $profile = Yii::$app->getUserOpt->profile_user(); //componen $userId = $profile->id; return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'searchModelpermision' => $searchModelpermision, 'dataProviderpermision' => $dataProviderpermision, 'userPrmission' => $userId]); } else { $this->redirect(array('/site/validasi')); // } }
/** * Lists all DraftPlan models. * @return mixed */ public function actionIndex() { $tab = Yii::$app->getRequest()->getQueryParam('tab'); $SCL_NM = Yii::$app->getRequest()->getQueryParam('SCL_NM'); $aryStt = [['STATUS' => 0, 'STT_NM' => 'Draft'], ['STATUS' => 1, 'STT_NM' => 'Approve']]; $valStt = ArrayHelper::map($aryStt, 'STATUS', 'STT_NM'); $arySttAct = [['STATUS' => 10, 'STT_NM' => 'Active'], ['STATUS' => 1, 'STT_NM' => 'InActive']]; $Stt = ArrayHelper::map($arySttAct, 'STATUS', 'STT_NM'); /*PLAN DRAFT*/ $searchModel = new DraftPlanSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); /*PLAN MAINTAIN*/ $searchModelMaintain = new DraftPlanDetailSearch(); $dataProviderMaintain = $searchModelMaintain->search(Yii::$app->request->queryParams); /*GROUP SETTING*/ $searchModelGrp = new DraftPlanGroupSearch(); $dataProviderGrp = $searchModelGrp->search(Yii::$app->request->queryParams); /*GROUP USER*/ $searchModelUser = new UserloginSearch(); $dataProviderUser = $searchModelUser->searchgroupplan(Yii::$app->request->queryParams); return $this->render('index', ['tab' => $tab, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'valStt' => $valStt, 'searchModelMaintain' => $searchModelMaintain, 'dataProviderMaintain' => $dataProviderMaintain, 'searchModelGrp' => $searchModelGrp, 'dataProviderGrp' => $dataProviderGrp, 'searchModelUser' => $searchModelUser, 'dataProviderUser' => $dataProviderUser, 'dropcus' => self::ary_customers(), 'drop' => self::get_arygeo(), 'SCL_NM' => $SCL_NM, 'pekan' => self::getPekan(), 'layer' => self::ary_layer(), 'layer_nm' => self::layer_nm(), 'Stt' => $Stt, 'user' => self::get_aryUserCrmSales(), 'scdl_group' => self::get_arygeoplandetail2()]); }