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