public function search($params)
{
/*[5.1] JOIN TABLE */
$query = Dept::find()->Where('u0002a.DEP_STS<>3');
$dataProvider_Dept = new ActiveDataProvider(['query' => $query]);
/*[5.3] LOAD VALIDATION PARAMS */
/*LOAD FARM VER 1*/
$this->load($params);
if (!$this->validate()) {
return $dataProvider_Dept;
}
/*[5.4] FILTER WHERE LIKE (string/integer)*/
/* FILTER COLUMN Author -ptr.nov-*/
$query->andFilterWhere(['like', 'DEP_ID', $this->DEP_ID])->andFilterWhere(['like', 'DEP_NM', $this->DEP_NM]);
return $dataProvider_Dept;
}
return Html::a('<i class="glyphicon glyphicon-retweet"></i> PROCESS', '#', ['class' => 'btn btn-warning btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} elseif ($model->STATUS == 1) {
return Html::a('<i class="glyphicon glyphicon-time"></i> PENDING', '#', ['class' => 'btn btn-warning btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} elseif ($model->STATUS == 101) {
return Html::a('<i class="glyphicon glyphicon-ok"></i> APPROVED', '#', ['class' => 'btn btn-success btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} elseif ($model->STATUS == 10) {
return Html::a('<i class="glyphicon glyphicon-ok"></i> COMPLETED', '#', ['class' => 'btn btn-info btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} elseif ($model->STATUS == 3) {
return Html::a('<i class="glyphicon glyphicon-remove"></i> DELETE', '#', ['class' => 'btn btn-danger btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} elseif ($model->STATUS == 4) {
return Html::a('<i class="glyphicon glyphicon-thumbs-down"></i> REJECT', '#', ['class' => 'btn btn-danger btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
} else {
return Html::a('<i class="glyphicon glyphicon-question-sign"></i> UNKNOWN', '#', ['class' => 'btn btn-danger btn-xs', 'style' => ['width' => '100px'], 'title' => 'Detail']);
}
}
$Combo_Dept = ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_NM', 'DEP_NM');
?>
<div style="padding:10px;">
<?php
echo GridView::widget(['id' => 'ro-grd-index', 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'kartik\\grid\\SerialColumn', 'contentOptions' => ['class' => 'kartik-sheet-style'], 'width' => '20px', 'header' => 'No.', 'headerOptions' => ['class' => 'kartik-sheet-style']], ['attribute' => 'KD_SA', 'hAlign' => 'left', 'vAlign' => 'middle', 'group' => true], ['label' => 'Tanggal Pembuatan', 'attribute' => 'CREATED_AT', 'hAlign' => 'left', 'vAlign' => 'middle', 'group' => true, 'filterType' => \kartik\grid\GridView::FILTER_DATE_RANGE, 'filterWidgetOptions' => ['attribute' => 'parentro.CREATED_AT', 'presetDropdown' => TRUE, 'convertFormat' => true, 'pluginOptions' => ['id' => 'tglro', 'format' => 'Y/m/d', 'separator' => 'TO', 'opens' => 'left']]], ['label' => 'Pengajuan', 'group' => true, 'attribute' => 'EMP_NM', 'hAlign' => 'left', 'vAlign' => 'middle'], ['label' => 'Department', 'group' => true, 'attribute' => 'dept.DEP_NM', 'hAlign' => 'left', 'vAlign' => 'middle', 'filter' => $Combo_Dept], ['class' => 'kartik\\grid\\ActionColumn', 'dropdown' => true, 'template' => '{view}{tambahEdit}{delete}{approved}', 'dropdownOptions' => ['class' => 'pull-right dropup'], 'buttons' => ['view' => function ($url, $model) {
return tombolView($url, $model);
}, 'tambahEdit' => function ($url, $model) {
return tombolEdit($url, $model);
}, 'delete' => function ($url, $model) {
return tombolDelete($url, $model);
}, 'approved' => function ($url, $model) {
return tombolApproval($url, $model);
}]], ['label' => 'Notification', 'mergeHeader' => true, 'format' => 'raw', 'hAlign' => 'center', 'value' => function ($model) {
return statusProcessRo($model);
}]], 'pjax' => true, 'pjaxSettings' => ['options' => ['enablePushState' => false, 'id' => 'sa-grd-index']], 'hover' => true, 'responsive' => true, 'responsiveWrap' => true, 'bordered' => true, 'striped' => '4px', 'autoXlFormat' => true, 'export' => false, 'toolbar' => [['content' => tombolCreate() . tombolBarang() . tombolKategori()], '{toggleData}'], 'panel' => ['type' => GridView::TYPE_INFO, 'heading' => "List Sales Order"]]);
<?php
use yii\helpers\Html;
use lukisongroup\hrd\models\Dept;
use kartik\widgets\ActiveForm;
use kartik\builder\Form;
use kartik\builder\FormGrid;
use kartik\widgets\FileInput;
use yii\helpers\ArrayHelper;
$this->sideMenu = 'hrd';
$form = ActiveForm::begin(['type' => ActiveForm::TYPE_VERTICAL]);
$nlDigit = Dept::find()->count() + 1;
$nl = 'LG' . $nlDigit;
?>
<?php
echo FormGrid::widget(['model' => $model, 'form' => $form, 'autoGenerateColumns' => true, 'rows' => [['contentBefore' => '<legend class="text-info"><small>DEPARTMENT IDENTITY</small></legend>', 'columns' => 1, 'autoGenerateColumns' => false, 'attributes' => ['employe_identity' => ['label' => 'Dept.ID', 'columns' => 5, 'attributes' => ['DEP_ID' => ['type' => Form::INPUT_TEXT, 'Form::SIZE_LARGE', 'options' => [], 'columnOptions' => ['colspan' => 3]], 'DEP_NM' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Department Name...'], 'columnOptions' => ['colspan' => 4]], 'DEP_DCRP' => ['type' => Form::INPUT_TEXTAREA, 'options' => ['placeholder' => 'Department Description ...'], 'columnOptions' => ['colspan' => 4]], 'SORT' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'SORT...'], 'columnOptions' => ['colspan' => 4]]]]]], ['attributes' => ['actions' => ['type' => Form::INPUT_RAW, 'value' => '<div style="text-align: right; margin-top: 20px">' . Html::resetButton('Reset', ['class' => 'btn btn-default']) . ' ' . Html::submitButton('Submit', ['class' => 'btn btn-primary']) . '</div>']]]]]);
ActiveForm::end();
public function getDept()
{
return $this->hasOne(Dept::className(), ['DEP_ID' => 'KD_DEP']);
}
public function actionEditTitel($id)
{
$model = $this->findModel($id);
$datacorp = ArrayHelper::map(Corp::find()->orderBy('SORT')->asArray()->all(), 'CORP_ID', 'CORP_NM');
$datadep = ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_ID', 'DEP_NM');
$aryGrpFnc = ArrayHelper::map(Groupfunction::find()->orderBy('SORT')->asArray()->all(), 'GF_ID', 'GF_NM');
$arySeqID = ArrayHelper::map(Groupseqmen::find()->orderBy('SEQ_NM')->asArray()->all(), 'SEQ_ID', 'SEQ_NM');
$emp_sts = ArrayHelper::map(Status::find()->orderBy('SORT')->asArray()->all(), 'STS_ID', 'STS_NM');
if (!$model->load(Yii::$app->request->post())) {
return $this->renderAjax('_form_edit_title', ['model' => $model, 'datacorp' => $datacorp, 'datadep' => $datadep, 'aryGrpFnc' => $aryGrpFnc, 'arySeqID' => $arySeqID, 'emp_sts' => $emp_sts]);
} else {
if (Yii::$app->request->isAjax) {
$model->load(Yii::$app->request->post());
return Json::encode(\yii\widgets\ActiveForm::validate($model));
} else {
if ($model->load(Yii::$app->request->post())) {
//$model->save();
$image = $model->uploadImage();
if ($model->save()) {
// upload only if valid uploaded file instance found
if ($image !== false) {
$path = $model->getImageFile();
$image->saveAs($path);
}
}
return $this->redirect(['index', 'id' => $model->EMP_ID]);
}
}
}
}
protected function findModel($id)
{
if (($model = Dept::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Creates a new Berita model.
*if save successful,then save on bt0001notify
* If creation is successful, the browser will be redirected to the 'detail-berita' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Berita();
/* image berita*/
$beritaimage = new BeritaImage();
/* data departement using select 2 */
$datadep = ArrayHelper::map(Dept::find()->where('DEP_STS <>3')->asArray()->all(), 'DEP_ID', 'DEP_NM');
/* data Employe using select 2 */
$dataemploye = ArrayHelper::map(Employe::find()->where('EMP_STS <>3')->asArray()->all(), 'EMP_ID', 'EMP_NM');
/* componen user */
$profile = Yii::$app->getUserOpt->profile_user()->emp;
$emp_img = $profile->EMP_IMG;
$emp_img_base64 = $profile->IMG_BASE64;
/* foto profile */
if ($emp_img_base64 == '') {
$foto_profile = Html::img(Yii::getAlias('@web') . '/upload/hrd/Employee/default.jpg', ['width' => '130', 'height' => '130', 'align' => 'center', 'class' => 'img-thumbnail']);
} else {
$foto_profile = Html::img('data:image/jpg;base64,' . $emp_img_base64, ['width' => '130', 'height' => '130', 'align' => 'center', 'class' => 'img-thumbnail']);
}
/* proses save */
if ($model->load(Yii::$app->request->post())) {
/* not usage
*checkbox using filter author : wawan
*if checkbox equal 1 then kd_dep result 0
*/
// $post = Yii::$app->request->post();
// $checkbox = $post['Berita']['alluser'];
// if($checkbox == 1)
// {
// $model->KD_DEP = '0';
// }
/* generate kode berita*/
$GneratekodeBerita = \Yii::$app->ambilkonci->getBeritaCode();
$model->KD_BERITA = $GneratekodeBerita;
//componen
$model->KD_CORP = Yii::$app->getUserOpt->Profile_user()->emp->EMP_CORP_ID;
$model->CREATED_BY = Yii::$app->user->identity->EMP_ID;
$model->CREATED_ATCREATED_BY = date('Y-m-d H:i:s');
if ($model->save()) {
$update_image_upload = BeritaImage::updateAll(['KD_BERITA' => $model->KD_BERITA], 'ID_USER="******"AND KD_BERITA = ""');
/* connection db widget */
$connection = Yii::$app->db_widget;
/* date for field CREATED_AT */
$date = date('Y-m-d');
/* search employee */
$search_depemploye = Employe::find()->where(['DEP_ID' => $model->KD_DEP])->asArray()->all();
/* batch insert for many value*/
foreach ($search_depemploye as $key => $value) {
# code...
$connection->createCommand()->batchInsert('bt0001notify', ['KD_BERITA', 'ID_USER', 'CREATED_BY', 'CREATED_AT'], [[$model->KD_BERITA, $value['EMP_ID'], $profile->EMP_ID, $date]])->execute();
}
/*explode string to array using function explode php*/
$emp_id = explode(",", $model->USER_CC);
/* foreach array using save Bt001notify */
foreach ($emp_id as $value) {
$notifusercc = new BeritaNotify();
# code...
$notifusercc->KD_BERITA = $model->KD_BERITA;
$notifusercc->ID_USER = $value;
$notifusercc->CREATED_BY = $profile->EMP_ID;
$notifusercc->CREATED_AT = $date;
$notifusercc->save();
}
}
return $this->redirect(['detail-berita', 'KD_BERITA' => $model->KD_BERITA]);
} else {
/* delete image if KD_BERITA equal null */
$deleteupload = BeritaImage::deleteAll(['KD_BERITA' => '', 'ID_USER' => $profile->EMP_ID]);
return $this->renderAjax('create', ['model' => $model, 'datadep' => $datadep, 'beritaimage' => $beritaimage, 'emp_img' => $emp_img, 'foto_profile' => $foto_profile, 'dataemploye' => $dataemploye]);
}
}
/**
* Index
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionIndex()
{
//Check componen generate kode RO
//print_r(\Yii::$app->ambilkonci->getRoCode());
//function getPermission(){
//return Yii::$app->getUserOpt->Modul_akses(1);
//}
//$getPermission=Yii::$app->getUserOpt->Modul_akses(1);
$searchModel = new RequestorderSearch();
/* if (isset($_GET['param'])){
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams,$_GET['param']);
}else{
$dataProvider = $searchModel->searchChildRo(Yii::$app->request->queryParams);
} */
//$searchModel->KD_RO ='2015.12.04.RO.0070';
$dataProvider = $searchModel->searchRo(Yii::$app->request->queryParams);
$dataProviderInbox = $searchModel->searchRoInbox(Yii::$app->request->queryParams);
$dataProviderOutbox = $searchModel->searchRoOutbox(Yii::$app->request->queryParams);
$profile = Yii::$app->getUserOpt->Profile_user();
// data for search index RO//
$AryCorp = ArrayHelper::map(Corp::find()->all(), 'CORP_ID', 'CORP_NM');
$Combo_Dept = ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_NM', 'DEP_NM');
// ** //
$datachecked = Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS = 101 AND STATUS <> 3 AND USER_CC='" . $profile->emp->EMP_ID . "'")->count();
$datacreate = Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'")->count();
$dataapprove = Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS = 102 AND STATUS <>3 AND KD_DEP='" . $profile->emp->DEP_ID . "' OR STATUS = 5")->count();
$dataAprrove = new ActiveDataProvider(['query' => Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS = 102 AND STATUS<>3 AND KD_DEP='" . $profile->emp->DEP_ID . "'OR STATUS = 5"), 'pagination' => ['pageSize' => 5]]);
$dataChecked = new ActiveDataProvider(['query' => Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS = 101 AND USER_CC='" . $profile->emp->EMP_ID . "'"), 'pagination' => ['pageSize' => 5]]);
$dataCreate = new ActiveDataProvider(['query' => Requestorder::find()->where("PARENT_ROSO = 0 AND STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'"), 'pagination' => ['pageSize' => 5]]);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'dataProviderInbox' => $dataProviderInbox, 'dataProviderOutbox' => $dataProviderOutbox, 'datachecked' => $datachecked, 'datacreate' => $datacreate, 'dataCreate' => $dataCreate, 'dataapprove' => $dataapprove, 'dataAprrove' => $dataAprrove, 'dataChecked' => $dataChecked, 'Combo_Dept' => $Combo_Dept, 'AryCorp' => $AryCorp]);
}
/*GROUP-FUNCTION*/
if (count($Gf_MDL) == 0) {
$Val_GF = 'none';
} else {
$Val_GF = $Gf_MDL->GF_NM;
}
/*GROUP-SEQUEN*/
if (count($GSeqmen_MDL) == 0) {
$Val_SQMEN = 'none';
} else {
$Val_SQMEN = $GSeqmen_MDL->SEQ_NM;
}
/*JOBGRADE*/
if (count($Jabatan_MDL) == 0) {
$Val_Jabatan = 'none';
} else {
$Val_Jabatan = $Jabatan_MDL->JOBGRADE_NM;
}
/*STATUS*/
if (count($Status_MDL) == 0) {
$Val_Status = 'none';
} else {
$Val_Status = $Status_MDL->STS_NM;
}
/*ADDITIONAL SELECTED DEPDOWN VALUE HTML FOR JS -Auth ptr.nov*/
echo Html::hiddenInput('selected-subdept', $model->DEP_SUB_ID, ['id' => 'selected-subdept']);
echo Html::hiddenInput('selected-grading', $model->JOBGRADE_ID, ['id' => 'selected-grading']);
$attribute = [['group' => true, 'label' => 'Employee Identification', 'rowOptions' => ['class' => 'info']], ['attribute' => 'upload_file', 'label' => '', 'value' => Yii::getAlias('@HRD_EMP_UploadUrl') . '/' . $model->EMP_IMG, 'format' => ['image', ['width' => '100', 'height' => '120']], 'type' => DetailView::INPUT_FILEINPUT, 'widgetOptions' => ['pluginOptions' => ['showPreview' => true, 'showCaption' => false, 'showRemove' => false, 'showUpload' => false]]], ['attribute' => 'EMP_ID', 'options' => ['readonly' => true]], ['attribute' => 'EMP_NM'], ['attribute' => 'EMP_NM_BLK'], ['group' => true, 'label' => 'Coorporate Information', 'rowOptions' => ['class' => 'info']], ['label' => 'Coorporate', 'attribute' => 'EMP_CORP_ID', 'format' => 'raw', 'value' => Html::a($Val_Corp, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Corp::find()->orderBy('SORT')->asArray()->all(), 'CORP_ID', 'CORP_NM'), 'options' => ['placeholder' => 'Select ...'], 'pluginOptions' => ['allowClear' => true]]], ['label' => 'Department', 'attribute' => 'DEP_ID', 'format' => 'raw', 'value' => Html::a($Val_Dept, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_ID', 'DEP_NM'), 'options' => ['id' => 'dept-id']]], ['label' => 'Department Sub', 'attribute' => 'DEP_SUB_ID', 'format' => 'raw', 'value' => Html::a($Val_DeptSub, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_DEPDROP, 'widgetOptions' => ['options' => ['id' => 'subdept-id'], 'pluginOptions' => ['depends' => ['dept-id'], 'url' => Url::to(['/hrd/employe/subdept']), 'initialize' => true, 'params' => ['selected-subdept'], 'loadingText' => 'Sub Department ...']]], ['label' => 'Group Function', 'attribute' => 'GF_ID', 'format' => 'raw', 'value' => Html::a($Val_GF, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Groupfunction::find()->orderBy('SORT')->asArray()->all(), 'GF_ID', 'GF_NM'), 'options' => ['id' => 'Groupfnc-id']]], ['label' => 'Group Seqmen', 'attribute' => 'SEQ_ID', 'format' => 'raw', 'value' => Html::a($Val_SQMEN, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Groupseqmen::find()->orderBy('SEQ_NM')->asArray()->all(), 'SEQ_ID', 'SEQ_NM'), 'options' => ['id' => 'Groupseq-id']]], ['label' => 'Grading', 'attribute' => 'JOBGRADE_ID', 'format' => 'raw', 'value' => Html::a($Val_Jabatan, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_DEPDROP, 'widgetOptions' => ['options' => ['id' => 'grading-id'], 'pluginOptions' => ['depends' => ['Groupfnc-id', 'Groupseq-id'], 'url' => Url::to(['/hrd/employe/grading']), 'initialize' => true, 'params' => ['selected-grading'], 'loadingText' => 'Sub Department ...']]], ['attribute' => 'EMP_STS', 'format' => 'raw', 'value' => Html::a($Val_Status, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Status::find()->orderBy('SORT')->asArray()->all(), 'STS_ID', 'STS_NM'), 'options' => ['placeholder' => 'Select ...'], 'pluginOptions' => ['allowClear' => true]]], ['id' => 'my_datepicker', 'attribute' => 'EMP_JOIN_DATE', 'format' => 'date', 'type' => DetailView::INPUT_DATE, 'widgetOptions' => ['pluginOptions' => ['format' => 'yyyy-mm-dd'], 'pluginEvents' => ['show' => "function(e) {show}"]]], ['attribute' => 'EMP_RESIGN_DATE', 'format' => 'date', 'type' => DetailView::INPUT_DATE, 'widgetOptions' => ['pluginOptions' => ['format' => 'yyyy-mm-dd'], 'pluginEvents' => ['show' => "function(e) {show}"]]], ['group' => true, 'label' => 'Employee Data Information', 'rowOptions' => ['class' => 'info']], ['attribute' => 'EMP_KTP'], ['attribute' => 'EMP_ALAMAT'], ['attribute' => 'EMP_ZIP'], ['attribute' => 'EMP_TLP'], ['attribute' => 'EMP_HP'], ['attribute' => 'EMP_GENDER'], ['attribute' => 'EMP_TGL_LAHIR', 'format' => 'date', 'type' => DetailView::INPUT_DATE, 'widgetOptions' => ['pluginOptions' => ['format' => 'yyyy-mm-dd'], 'pluginEvents' => ['show' => "function(e) {show}"]], 'inputWidth' => '40%'], ['attribute' => 'EMP_EMAIL']];
$form = ActiveForm::begin(['type' => ActiveForm::TYPE_VERTICAL, 'id' => 'viewedit', 'enableClientValidation' => true, 'options' => ['enctype' => 'multipart/form-data']]);
echo DetailView::widget(['id' => 'dv-view-emp', 'model' => $model, 'condensed' => true, 'hover' => true, 'mode' => DetailView::MODE_VIEW, 'panel' => ['heading' => $model->EMP_NM . ' ' . $model->EMP_NM_BLK, 'type' => DetailView::TYPE_INFO], 'attributes' => $attribute, 'deleteOptions' => ['url' => ['delete', 'id' => $model->EMP_ID], 'data' => ['confirm' => Yii::t('app', 'Are you sure to deleted this record Name =' . $model->EMP_NM . '?'), 'method' => 'post']]]);
ActiveForm::end();
use lukisongroup\hrd\models\Groupfunction;
use lukisongroup\hrd\models\Groupseqmen;
use lukisongroup\hrd\models\Jobgrade;
use lukisongroup\hrd\models\Status;
use lukisongroup\hrd\models\Employe;
use yii\helpers\Url;
use kartik\widgets\DepDrop;
//use lukisongroup\models\system\side_menu\M1000;
//use kartik\sidenav\SideNav;
$form = ActiveForm::begin(['type' => ActiveForm::TYPE_VERTICAL, 'options' => ['enctype' => 'multipart/form-data'], 'id' => 'emp-form1-create', 'enableClientValidation' => true]);
//$form = ActiveForm::begin(['type'=>ActiveForm::TYPE_HORIZONTAL]);
//$form = ActiveForm::begin(['type'=>ActiveForm::TYPE_VERTICAL]);
/*Author: -ptr.nov- Generate digit EMP_ID */
/*Get Id count Author:-ptr.nov-*/
//$cnt= (Employe::find()->count())+1;
/*get ID Sparator Array , Author: -ptr.nov-*/
//$sql = 'SELECT max(EMP_ID) as EMP_ID FROM a0001';
//$cnt= Employe::findBySql($sql)->one();
///$arySplit=explode('.',$cnt->EMP_ID);
//$str_id_cnt=trim($arySplit[2]);
//print_r($str_id_cnt+1);
//$id_cnt=$str_id_cnt+1;
/*Combine String and Digit Author: -ptr.nov- */
//$digit=str_pad($id_cnt,4,"0",STR_PAD_LEFT);
//$thn=date("Y");
//$nl='LG'.'.'.$thn.'.'.$digit;
/*Author: Eka Side Menu */
//$side_menu=\yii\helpers\Json::decode(M1000::find()->findMenu('hrd')->one()->jval);
$EmployeeInput = FormGrid::widget(['model' => $model, 'form' => $form, 'autoGenerateColumns' => true, 'rows' => [['columns' => 1, 'attributes' => ['employe_identity' => ['label' => 'GENERATE CODE BY COORPORATE :', 'attributes' => ['EMP_CORP_ID' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Corp::find()->orderBy('SORT')->asArray()->all(), 'CORP_ID', 'CORP_NM'), 'options' => ['id' => 'cat-id'], 'columnOptions' => ['colspan' => 1]]]]]], ['contentBefore' => '<legend class="text-info"><small>EMPLOYEE IDENTITY</small></legend>', 'columns' => 1, 'autoGenerateColumns' => false, 'attributes' => ['employe_identity' => ['label' => 'Employee.ID', 'attributes' => ['EMP_ID' => ['disabled' => true, 'type' => Form::INPUT_WIDGET, 'widgetClass' => 'kartik\\widgets\\DepDrop', 'options' => ['options' => ['id' => 'subcat-id', 'readonly' => true, 'selected' => false], 'pluginOptions' => ['depends' => ['cat-id'], 'url' => Url::to(['/hrd/employe/subcat']), 'initialize' => true, 'placeholder' => false]], 'columnOptions' => ['colspan' => 3]], 'EMP_NM' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Enter First Name...'], 'columnOptions' => ['colspan' => 1]], 'EMP_NM_BLK' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Enter Last Name...'], 'columnOptions' => ['colspan' => 1]]]]]], ['contentBefore' => '<legend class="text-info"><small>COORPORATE IDENTITY</small></legend>', 'columns' => 1, 'autoGenerateColumns' => false, 'attributes' => ['employe_identity' => ['attributes' => ['EMP_CORP_ID' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Corp::find()->orderBy('SORT')->asArray()->all(), 'CORP_ID', 'CORP_NM'), 'options' => ['placeholder' => 'Select Coorporate...'], 'hint' => 'Pilih Perusahaan', 'columnOptions' => ['colspan' => 12]], 'DEP_ID' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_ID', 'DEP_NM'), 'options' => ['id' => 'dept-id'], 'hint' => 'Pilih Department', 'columnOptions' => ['colspan' => 12]], 'DEP_SUB_ID' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\DepDrop', 'options' => ['id' => 'subdept-id', 'pluginOptions' => ['depends' => ['dept-id'], 'url' => Url::to(['/hrd/employe/subdept']), 'initialize' => true, 'params' => [''], 'loadingText' => 'Sub Department ...']], 'hint' => 'Pilih Sub Department', 'columnOptions' => ['colspan' => 12]], 'GF_ID' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Groupfunction::find()->orderBy('SORT')->asArray()->all(), 'GF_ID', 'GF_NM'), 'options' => ['id' => 'Groupfnc-id'], 'hint' => 'Pilih Group Function', 'columnOptions' => ['colspan' => 12]], 'SEQ_ID' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Groupseqmen::find()->orderBy('SEQ_NM')->asArray()->all(), 'SEQ_ID', 'SEQ_NM'), 'options' => ['id' => 'Groupseq-id'], 'hint' => 'Pilih Group Sequen', 'columnOptions' => ['colspan' => 12]], 'JOBGRADE_ID' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\DepDrop', 'options' => ['id' => 'grading-id', 'pluginOptions' => ['depends' => ['Groupfnc-id', 'Groupseq-id'], 'url' => Url::to(['/hrd/employe/grading']), 'initialize' => true, 'params' => [''], 'loadingText' => 'Sub Department ...']], 'hint' => 'Pilih Grading Karyawan ', 'columnOptions' => ['colspan' => 12]], 'EMP_STS' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => ArrayHelper::map(Status::find()->orderBy('SORT')->asArray()->all(), 'STS_ID', 'STS_NM'), 'hint' => 'Pilih Status Karyawan', 'columnOptions' => ['colspan' => 12]], 'EMP_JOIN_DATE' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\DatePicker', 'options' => ['pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-mm-dd', 'enableonreadonly' => false, 'todayHighlight' => true], 'pluginEvents' => ['show' => "function(e) {show}"]], 'hint' => 'Enter Join Date (yyyy-mm-dd)', 'columnOptions' => ['colspan' => 12]], 'EMP_RESIGN_DATE' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\DatePicker', 'options' => ['pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-mm-dd', 'todayHighlight' => true], 'pluginEvents' => ['show' => "function(e) {show}"]], 'hint' => 'Enter Resign Date (yyyy-mm-dd)', 'columnOptions' => ['colspan' => 12]]]]]], ['contentBefore' => '<legend class="text-info"><small>EMPLOYEE PROFILE</small></legend>', 'columns' => 1, 'autoGenerateColumns' => false, 'attributes' => ['address_detail' => ['label' => 'Address', 'attributes' => ['EMP_KTP' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Enter NO KTP...'], 'columnOptions' => ['colspan' => 12]], 'EMP_ALAMAT' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => 'kartik\\markdown\\MarkdownEditor', 'value' => '<span class="text-justify"><em>' . $model->EMP_ALAMAT . '</em></span>', 'columnOptions' => ['colspan' => 12]], 'EMP_ZIP' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Zip...'], 'columnOptions' => ['colspan' => 6]], 'EMP_HP' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Phone...'], 'columnOptions' => ['colspan' => 6]], 'EMP_TGL_LAHIR' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\DatePicker', 'options' => ['pluginOptions' => ['autoclose' => true, 'format' => 'yyyy-mm-dd', 'startView' => true], 'pluginEvents' => ['show' => "function(e) {show}"]], 'hint' => 'Enter birthday (yyyy-mm-dd)', 'columnOptions' => ['colspan' => 6]], 'EMP_GENDER' => ['type' => Form::INPUT_RADIO_LIST, 'items' => ['Male' => 'Male', 'Female' => 'Female'], 'options' => ['inline' => 'Male'], 'columnOptions' => ['colspan' => 6]], 'EMP_EMAIL' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => '*****@*****.**', 'addon' => ['prepend' => ['content' => '@']]], 'columnOptions' => ['colspan' => 6]]]]]], ['columns' => 3, 'attributes' => ['address_detail' => ['label' => 'Picture', 'columns' => 6, 'attributes' => ['upload_file' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\FileInput', 'options' => ['pluginOptions' => ['showPreview' => true, 'showCaption' => false, 'showRemove' => false, 'showUpload' => false]], 'columnOptions' => ['colspan' => 2]]]]]], ['attributes' => ['actions' => ['type' => Form::INPUT_RAW, 'value' => '<div style="text-align: right; margin-top: 20px">' . Html::resetButton('Reset', ['class' => 'btn btn-default']) . ' ' . Html::submitButton('Submit', ['class' => 'btn btn-primary']) . '</div>']]]]]);
echo Html::listGroup([['content' => 'IINPUT DATA KARYAWAN', 'url' => '#', 'badge' => '', 'active' => true], ['content' => $EmployeeInput]]);
ActiveForm::end();
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use kartik\select2\Select2;
use lukisongroup\hrd\models\Seq;
use kartik\widgets\DateTimePicker;
use kartik\label\LabelInPlace;
/* @var $this yii\web\View */
/* @var $model lukisongroup\hrd\models\Regulasi */
/* @var $form yii\widgets\ActiveForm */
$array = Seq::find()->all();
$arraygf = lukisongroup\hrd\models\Groupfunction::find()->all();
$arraydep = \lukisongroup\hrd\models\Dept::find()->all();
$arraysub = lukisongroup\hrd\models\Deptsub::find()->all();
$arraycorp = lukisongroup\hrd\models\Corp::find()->all();
$arrayjob = lukisongroup\hrd\models\Jobgrade::find()->all();
//data
$datadep = yii\helpers\ArrayHelper::map($arraydep, 'DEP_ID', 'DEP_NM');
$datagf = yii\helpers\ArrayHelper::map($arraygf, 'GF_ID', 'GF_NM');
$datasqid = yii\helpers\ArrayHelper::map($array, 'SEQ_ID', 'SEQ_NM');
$datasub = yii\helpers\ArrayHelper::map($arraysub, 'DEP_SUB_ID', 'DEP_ID');
$datacorp = yii\helpers\ArrayHelper::map($arraycorp, 'CORP_ID', 'CORP_NM');
$datajob = yii\helpers\ArrayHelper::map($arrayjob, 'JOBGRADE_ID', 'JOBGRADE_NM');
$datastatus = ['0' => 'Tidak aktif', '1' => 'aktif'];
?>
<!--<div class="regulasi-form">-->
<?php
$form = ActiveForm::begin(['id' => 'form', 'enableClientValidation' => true]);
/**
* Index
* @author ptrnov <*****@*****.**>
* @since 1.1
*/
public function actionIndex()
{
// component user
$profile = Yii::$app->getUserOpt->Profile_user();
/*inbox tab ||index*/
$searchModel = new RequesttermheaderSearch();
$dataProviderInbox = $searchModel->searchRtInbox(Yii::$app->request->queryParams);
/*outbox tab ||index*/
$searchmodel = new RequesttermheaderSearch();
$dataProviderOutbox = $searchmodel->searchRtOutbox(Yii::$app->request->queryParams);
/*history tab ||index*/
$searchmodelHistory = new RequesttermheaderSearch();
$dataproviderHistory = $searchmodelHistory->searchRthistory(Yii::$app->request->queryParams);
// data for search index Rt//
$AryCorp = ArrayHelper::map(Corp::find()->all(), 'CORP_ID', 'CORP_NM');
$Combo_Dept = ArrayHelper::map(Dept::find()->orderBy('SORT')->asArray()->all(), 'DEP_NM', 'DEP_NM');
// ** //
$datachecked = Requesttermheader::find()->where("STATUS = 101 AND STATUS <> 3 AND USER_CC='" . $profile->emp->EMP_ID . "'")->count();
$datacreate = Requesttermheader::find()->where("STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'")->count();
$dataapprove = Requesttermheader::find()->where("STATUS = 102 AND STATUS <>3 AND KD_DEP='" . $profile->emp->DEP_ID . "' OR STATUS = 5")->count();
$dataAprrove = new ActiveDataProvider(['query' => Requesttermheader::find()->where("STATUS = 102 AND STATUS<>3 AND KD_DEP='" . $profile->emp->DEP_ID . "'OR STATUS = 5"), 'pagination' => ['pageSize' => 5]]);
$dataChecked = new ActiveDataProvider(['query' => Requesttermheader::find()->where("STATUS = 101 AND USER_CC='" . $profile->emp->EMP_ID . "'"), 'pagination' => ['pageSize' => 5]]);
$dataCreate = new ActiveDataProvider(['query' => Requesttermheader::find()->where("STATUS <> 3 AND STATUS = 0 AND ID_USER = '******'"), 'pagination' => ['pageSize' => 5]]);
return $this->render('index', ['searchModel' => $searchModel, 'dataProviderInbox' => $dataProviderInbox, 'searchmodel' => $searchmodel, 'dataProviderOutbox' => $dataProviderOutbox, 'searchmodelHistory' => $searchmodelHistory, 'dataproviderHistory' => $dataproviderHistory, 'datachecked' => $datachecked, 'datacreate' => $datacreate, 'dataCreate' => $dataCreate, 'dataapprove' => $dataapprove, 'dataAprrove' => $dataAprrove, 'dataChecked' => $dataChecked, 'Combo_Dept' => $Combo_Dept, 'AryCorp' => $AryCorp]);
}
