public function getKey_Employe($corp_id)
{
//$ck = Employe::find(min(['EMP_ID']))->where(['EMP_CORP_ID' => $corp_id])->one();
$sql1 = "SELECT max(EMP_ID) as EMP_ID FROM a0001 where EMP_ID like '" . $corp_id . "%'";
$ck = Employe::findBySql($sql1)->one();
$kd = explode('.', $ck['EMP_ID']);
//$nkd_test=$kd[2]+1;
if (count($ck) == 0) {
$nkd = 1;
} else {
$nkd = $kd[2] + 1;
}
$digit = str_pad($nkd, 6, "0", STR_PAD_LEFT);
$emp_id = $corp_id . '.' . date("Y") . '.' . $digit;
return $emp_id;
}
public function cari($params)
{
$empId = Yii::$app->user->identity->EMP_ID;
$dt = Employe::find()->where(['EMP_ID' => $empId])->all();
$crp = $dt[0]['EMP_CORP_ID'];
if ($dt[0]['JAB_ID'] == 'MGR') {
$query = Requestorder::find()->where("r0001.status <> 3 and r0001.status <> 0 and r0001.KD_CORP = '{$crp}' ");
} else {
$query = Requestorder::find()->where("r0001.status <> 3 and r0001.status <> 0 and r0001.KD_CORP = '{$crp}' and r0001.ID_USER = '******' ");
}
$query->joinWith(['employe' => function ($q) {
$q->where('a0001.EMP_NM LIKE "%' . $this->nmemp . '%"');
}]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->setSort(['attributes' => ['KD_RO', 'KD_CORP', 'nmemp' => ['asc' => ['a0001.EMP_NM' => SORT_ASC], 'desc' => ['a0001.EMP_NM' => SORT_DESC], 'label' => 'Pembuat']]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'a0001.EMP_NM', $this->EMP_NM])->andFilterWhere(['like', 'KD_RO', $this->KD_RO])->andFilterWhere(['like', 'KD_CORP', $this->KD_CORP]);
return $dataProvider;
}
protected function findModel1($id)
{
if (($model = Employe::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getEmploye()
{
return $this->hasOne(Employe::className(), ['EMP_ID' => 'ID_USER']);
}
public function actionProses($kd)
{
$empId = Yii::$app->user->identity->EMP_ID;
$dt = Employe::find()->where(['EMP_ID' => $empId])->all();
if ($dt[0]['JAB_ID'] != 'MGR') {
return $this->redirect(['esm/requestorder']);
}
$rostat = Requestorderstatus::find()->where(['KD_RO' => $kd, 'ID_USER' => $empId])->one();
if (count($rostat) == 0) {
return $this->redirect([' ']);
}
$ro = new Requestorder();
$reqro = Requestorder::find()->where(['KD_RO' => $kd])->one();
$detro = $reqro->detro;
$employ = $reqro->employe;
//$ro = new Requestorderstatus();
$rostat->STATUS = 1;
$rostat->save();
return $this->render('proses', ['reqro' => $reqro, 'detro' => $detro, 'employ' => $employ]);
}
} else {
$apprv = Employe::find()->where(['EMP_ID' => $model->APPROVE_BY])->one();
echo $apprv->EMP_NM . ' ' . $apprv->EMP_NM_BLK;
}
?>
</u></b><br/>
F & A
</td>
<td>
<b><u>
<?php
if ($model->APPROVE_DIR == '') {
echo "***************";
} else {
$apprv = Employe::find()->where(['EMP_ID' => $model->APPROVE_DIR])->one();
echo $apprv->EMP_NM . ' ' . $apprv->EMP_NM_BLK;
}
?>
</u></b><br/>
Director
</td>
</tr>
</table>
</div>
<div class="col-xs-4 col-sm-2 col-md-2" >
use yii\widgets\ActiveForm;
use yii\grid\GridView;
use yii\widgets\Pjax;
//use terlebih dahulu
use yii\bootstrap\Modal;
use lukisongroup\models\esm\Barang;
use lukisongroup\models\esm\ro\Requestorder;
use lukisongroup\models\esm\ro\Rodetail;
use lukisongroup\models\esm\ro\RodetailSearch;
use lukisongroup\models\master\Barangumum;
use lukisongroup\models\master\Suplier;
use lukisongroup\models\master\Nmperusahaan;
use lukisongroup\models\esm\po\Podetail;
use lukisongroup\models\hrd\Employe;
$idEmp = Yii::$app->user->identity->EMP_ID;
$emp = Employe::find()->where(['EMP_ID' => $idEmp])->one();
$kr = $emp->DEP_SUB_ID;
?>
<!-- Stack the columns on mobile by making one full-width and the other half-width -->
<div class="row">
<?php
if ($quer->STATUS != 102) {
if ($kr == 'HR-02') {
?>
<div class="col-xs-12 col-md-3">
<?php
Pjax::begin(['id' => 'pjax-users']);
?>
<?php
public function search_empid($Emp_Id)
{
$query = Employe::find()->JoinWith('corpOne', true, 'LEFT JOIN')->JoinWith('deptOne', true, 'left JOIN')->JoinWith('deptsub', true, 'left JOIN')->JoinWith('groupfunction', true, 'left JOIN')->JoinWith('groupseqmen', true, 'left JOIN')->JoinWith('jobgrade', true, 'left JOIN')->JoinWith('sttOne', true, 'left JOIN')->where("a0001.EMP_ID='" . $Emp_Id . "'");
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $dataProvider;
}
use lukisongroup\models\hrd\Employe;
use kartik\detail\DetailView;
use yii\bootstrap\Modal;
use kartik\widgets\ActiveField;
use kartik\widgets\ActiveForm;
use kartik\builder\Form;
use kartik\icons\Icon;
use kartik\widgets\Growl;
$this->sideCorp = 'PT.Lukisongroup';
/* Title Select Company pada header pasa sidemenu/menu samping kiri */
$this->sideMenu = 'admin';
/* kd_menu untuk list menu pada sidemenu, get from table of database */
$this->title = Yii::t('app', 'LG - Administrator');
/* title pada header page */
?>
<div class="panel panel-default" style="margin-top: 0px">
<div class="panel-body">
<?php
$Emp_MDL = Employe::find()->where(['EMP_ID' => $model->EMP_ID])->orderBy('EMP_NM')->one();
if (count($Emp_MDL) == 0) {
$Val_Emp = 'none';
} else {
$Val_Emp = $Emp_MDL->EMP_NM;
}
$attribute = [['attribute' => 'id', 'options' => ['readonly' => true]], ['attribute' => 'username', 'options' => ['readonly' => true]], ['attribute' => 'auth_key'], ['label' => 'Employe Name', 'attribute' => 'EMP_ID', 'format' => 'raw', 'value' => Html::a($Val_Emp, '#', ['class' => 'kv-author-link']), 'type' => DetailView::INPUT_SELECT2, 'widgetOptions' => ['data' => ArrayHelper::map(Employe::find()->orderBy('EMP_NM')->asArray()->all(), 'EMP_ID', 'EMP_NM'), 'options' => ['placeholder' => 'Select ...'], 'pluginOptions' => ['allowClear' => true]]]];
echo DetailView::widget(['model' => $model, 'condensed' => true, 'hover' => true, 'mode' => DetailView::MODE_VIEW, 'panel' => ['heading' => $model->username . '| ' . $model->EMP_ID, 'type' => DetailView::TYPE_INFO], 'attributes' => $attribute, 'deleteOptions' => ['url' => ['delete', 'id' => $model->id], 'data' => ['confirm' => Yii::t('app', 'Apakah Anda yakin menghapus akun :' . $model->username . ' ?'), 'method' => 'post']]]);
?>
</div>
</div>
public function getApprove()
{
return $this->hasOne(Employe::className(), ['EMP_ID' => 'APPROVE_DIR']);
}
public function getRo_permission($empId)
{
//$empId = Yii::$app->user->identity->EMP_ID;
$dt = Employe::find()->where(['EMP_ID' => $empId])->one();
return $KD_BRG;
}
]);
};
?>
</aside -->
<div class="requestorder-index" style="padding:10px;">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<hr/>
<?php
$empId = Yii::$app->user->identity->EMP_ID;
$dt = Employe::find()->where(['EMP_ID' => $empId])->all();
$jbtan = $dt[0]['JOBGRADE_ID'];
$gridColumns = [['class' => 'yii\\grid\\SerialColumn'], 'KD_RO', 'nmemp', 'KD_CORP', ['format' => 'raw', 'value' => function ($model) {
$rodetail = new Rodetail();
$dt = Rodetail::find()->where(['KD_RO' => $model->KD_RO])->andWhere('STATUS <> 3')->count();
$cn = Rodetail::find()->where(['KD_RO' => $model->KD_RO, 'STATUS' => 1])->count();
if ($model->STATUS == 1) {
return Html::a('<i class="fa fa-check"></i> ' . $cn . ' Dari ' . $dt, ['proses', 'kd' => $model->KD_RO], ['class' => 'btn btn-success btn-sm', 'title' => 'Detail']);
} else {
if ($model->STATUS == 0) {
return Html::a('<i class="fa fa-navicon"></i> Proses', ['proses', 'kd' => $model->KD_RO], ['class' => 'btn btn-danger btn-sm', 'title' => 'Detail']);
}
}
}], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{link} {edit} {delete} {cetak}', 'buttons' => ['link' => function ($url, $model) {
return Html::a('', ['view', 'kd' => $model->KD_RO], ['class' => 'fa fa-info-circle fa-lg', 'title' => 'Detail']);
}, 'edit' => function ($url, $model) {
