/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Deptsub::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['DEP_SUB_STS' => $this->DEP_SUB_STS, 'SORT' => $this->SORT]); $query->andFilterWhere(['like', 'DEP_SUB_ID', $this->DEP_SUB_ID])->andFilterWhere(['like', 'DEP_ID', $this->DEP_ID])->andFilterWhere(['like', 'DEP_SUB_NM', $this->DEP_SUB_NM])->andFilterWhere(['like', 'DEP_SUB_AVATAR', $this->DEP_SUB_AVATAR])->andFilterWhere(['like', 'DEP_SUB_DCRP', $this->DEP_SUB_DCRP]); return $dataProvider; }
public function actionSubdept() { $out = []; if (isset($_POST['depdrop_parents'])) { $parents = $_POST['depdrop_parents']; if ($parents != null) { $DEP_ID = $parents[0]; $param1 = null; if (!empty($_POST['depdrop_params'])) { $params = $_POST['depdrop_params']; $param1 = $params[0]; // get the value of sub dept =js value/html } $model = Deptsub::find()->asArray()->where(['DEP_ID' => $DEP_ID])->all(); foreach ($model as $key => $value) { $out[] = ['id' => $value['DEP_SUB_ID'], 'name' => $value['DEP_SUB_NM']]; } echo json_encode(['output' => $out, 'selected' => $param1]); return; } } echo Json::encode(['output' => '', 'selected' => '']); }
public function getDeptsub() { return $this->hasOne(Deptsub::className(), ['DEP_SUB_ID' => 'DEP_SUB_ID']); }
//use kartik\date\DatePicker; use kartik\builder\Form; use kartik\sidenav\SideNav; //use backend\assets\AppAsset; /* CLASS ASSET CSS/JS/THEME Author: -ptr.nov-*/ //AppAsset::register($this); /* INDEPENDENT CSS/JS/THEME FOR PAGE Author: -ptr.nov-*/ /*Title page Modul*/ $this->sideCorp = 'HRM - Data Employee'; /* Title Select Company pada header pasa sidemenu/menu samping kiri */ $this->sideMenu = 'hrd_personalia'; /* kd_menu untuk list menu pada sidemenu, get from table of database */ $this->title = Yii::t('app', 'Personalia - List Data Employee'); /* title pada header page */ /*variable Dropdown*/ $Combo_Corp = ArrayHelper::map(Corp::find()->orderBy('SORT')->asArray()->all(), 'CORP_NM', 'CORP_NM'); $Combo_Dept = ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_NM', 'DEP_NM'); $Combo_SubDept = ArrayHelper::map(Deptsub::find()->orderBy('SORT')->asArray()->all(), 'DEP_SUB_NM', 'DEP_SUB_NM'); $Combo_GrpFnc = ArrayHelper::map(Groupfunction::find()->orderBy('SORT')->asArray()->all(), 'GF_NM', 'GF_NM'); $Combo_Seq = ArrayHelper::map(Groupseqmen::find()->orderBy('SEQ_NM')->asArray()->all(), 'SEQ_NM', 'SEQ_NM'); $Combo_Jab = ArrayHelper::map(Jobgrade::find()->orderBy('SORT')->asArray()->all(), 'JOBGRADE_NM', 'JOBGRADE_NM'); $Combo_Status = ArrayHelper::map(Status::find()->orderBy('SORT')->asArray()->all(), 'STS_NM', 'STS_NM'); //--EMPLOYE ACTIVED-- $tab_employe = GridView::widget(['id' => 'active', 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'PIC', 'format' => 'html', 'value' => function ($data) { return Html::img(Yii::getAlias('@HRD_EMP_UploadUrl') . '/' . $data->EMP_IMG, ['width' => '40']); }], 'EMP_ID', ['attribute' => 'EMP_NM'], 'EMP_NM_BLK', ['attribute' => 'corpOne.CORP_NM', 'filter' => $Combo_Corp], ['attribute' => 'deptOne.DEP_NM', 'filter' => $Combo_Dept], ['attribute' => 'deptsub.DEP_SUB_NM', 'filter' => $Combo_SubDept], ['attribute' => 'groupfunction.GF_NM', 'filter' => $Combo_GrpFnc], ['attribute' => 'groupseqmen.SEQ_NM', 'filter' => $Combo_Seq], ['attribute' => 'jobgrade.JOBGRADE_NM', 'filter' => $Combo_Jab], ['attribute' => 'sttOne.STS_NM', 'filter' => $Combo_Status], ['attribute' => 'EMP_JOIN_DATE', 'filterType' => \kartik\grid\GridView::FILTER_DATE_RANGE, 'filterWidgetOptions' => ['attribute' => 'EMP_JOIN_DATE', 'presetDropdown' => TRUE, 'convertFormat' => true, 'pluginOptions' => ['format' => 'Y-m-d', 'separator' => ' TO ', 'opens' => 'left']]], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{view}{edit}', 'header' => 'Action', 'buttons' => ['view' => function ($url, $model, $key) { return Html::a('<button type="button" class="btn btn-primary btn-xs" style="width:50px; height:50px">View </button>', ['/hrd/employe/view', 'id' => $model->EMP_ID], ['data-toggle' => "modal", 'data-target' => "#activity-emp", 'data-title' => $model->EMP_ID]); }]]], 'panel' => ['type' => GridView::TYPE_SUCCESS, 'before' => Html::a('<i class="glyphicon glyphicon-plus"></i> ' . Yii::t('app', 'Create ', ['modelClass' => 'Employe']), '/hrd/employe/create', ['data-toggle' => "modal", 'data-target' => "#activity-emp", 'class' => 'btn btn-success'])], 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'active'], 'hover' => true, 'responsive' => true, 'responsiveWrap' => true, 'bordered' => true, 'striped' => '4px', 'autoXlFormat' => true, 'export' => ['fontAwesome' => true, 'showConfirmAlert' => false, 'target' => GridView::TARGET_BLANK]]]); //---EMPLOYE RESIGN -- $tab_employe_resign = GridView::widget(['id' => 'resign', 'dataProvider' => $dataProvider1, 'filterModel' => $searchModel1, 'columns' => [['class' => 'yii\\grid\\ActionColumn', 'template' => '{view}', 'header' => 'Action', 'buttons' => ['view' => function ($url, $model, $key) { return Html::a('<button type="button" class="btn btn-danger btn-xs" style="width:50px; height:50px">View </button>', ['view', 'id' => $model->EMP_ID], ['data-toggle' => "modal", 'data-target' => "#activity-emp", 'data-title' => $model->EMP_ID]); }]], ['attribute' => 'PIC', 'format' => 'html', 'value' => function ($data) { return Html::img(Yii::getAlias('@HRD_EMP_UploadUrl') . '/' . $data->EMP_IMG, ['width' => '40']);
use kartik\widgets\FileInput; use yii\helpers\Url; use kartik\widgets\DepDrop; $this->sideCorp = 'HRM - Data Employee'; /* Title Select Company pada header pasa sidemenu/menu samping kiri */ $this->sideMenu = 'hrd_personalia'; /* kd_menu untuk list menu pada sidemenu, get from table of database */ $this->title = Yii::t('app', 'Personalia - Detail & Edit Employee'); /* title pada header page */ ?> <?php $Corp_MDL = Corp::find()->where(['CORP_ID' => $model->EMP_CORP_ID])->orderBy('SORT')->one(); $Dept_MDL = Dept::find()->where(['DEP_ID' => $model->DEP_ID])->orderBy('SORT')->one(); $DeptSub_MDL = Deptsub::find()->where(['DEP_SUB_ID' => $model->DEP_SUB_ID])->orderBy('SORT')->one(); $Gf_MDL = Groupfunction::find()->where(['GF_ID' => $model->GF_ID])->orderBy('SORT')->one(); $GSeqmen_MDL = Groupseqmen::find()->where(['SEQ_ID' => $model->SEQ_ID])->one(); $Jabatan_MDL = Jobgrade::find()->where(['JOBGRADE_ID' => $model->JOBGRADE_ID])->orderBy('SORT')->one(); $Status_MDL = Status::find()->where(['STS_ID' => $model->EMP_STS])->orderBy('SORT')->one(); /*COORPORATE*/ if (count($Corp_MDL) == 0) { $Val_Corp = 'none'; } else { $Val_Corp = $Corp_MDL->CORP_NM; } /*DEPARTMENT*/ if (count($Dept_MDL) == 0) { $Val_Dept = 'none'; } else { $Val_Dept = $Dept_MDL->DEP_NM;
/** * Finds the Deptsub model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Deptsub the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Deptsub::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }