/**
  * ACTION INDEX
  */
 public function actionIndex()
 {
     /*CNT Active Employe*/
     $cntAktifEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <> 3 AND EMP_STS<>3";
     $cntAktifEmp = Employe::findBySql($cntAktifEmploye)->one();
     /*CNT Probation Employe*/
     $cntProbationEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS=0";
     $cntProbaEmp = Employe::findBySql($cntProbationEmploye)->one();
     /*CNT Kontrak Employe*/
     $cntContrakEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS=2";
     $cntContrak = Employe::findBySql($cntContrakEmploye)->one();
     /*CNT Tetap Employe*/
     $cntTetapEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS=1";
     $cntTetapEmp = Employe::findBySql($cntTetapEmploye)->one();
     /*CNT Support Employe*/
     $cntSupportEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS<>3 AND SEQ_ID=1";
     $cntSptEmp = Employe::findBySql($cntSupportEmploye)->one();
     /*CNT Bisnis Employe*/
     $cntBisnisEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS<>3 AND SEQ_ID=2";
     $cntBisnisEmp = Employe::findBySql($cntBisnisEmploye)->one();
     /*CNT GenderM Employe*/
     $cntGenderMEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS<>3 AND EMP_GENDER='Male'";
     $cntGenderMEmp = Employe::findBySql($cntGenderMEmploye)->one();
     /*CNT GenderF Employe*/
     $cntGenderFmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE STATUS <>3 AND EMP_STS<>3 AND EMP_GENDER='Female'";
     $cntGenderFEmp = Employe::findBySql($cntGenderFmploye)->one();
     /*CNT Resign Employe*/
     $cntResignEmploye = "SELECT COUNT(EMP_ID) as EMP_ID FROM a0001 WHERE EMP_STS=3";
     $cntResignEmp = Employe::findBySql($cntResignEmploye)->one();
     return $this->render('index', ['cntAktifEmp' => $cntAktifEmp->EMP_ID, 'cntProbaEmp' => $cntProbaEmp->EMP_ID, 'cntContrak' => $cntContrak->EMP_ID, 'cntTetapEmp' => $cntTetapEmp->EMP_ID, 'cntSptEmp' => $cntSptEmp->EMP_ID, 'cntBisnisEmp' => $cntBisnisEmp->EMP_ID, 'cntGenderMEmp' => $cntGenderMEmp->EMP_ID, 'cntGenderFEmp' => $cntGenderFEmp->EMP_ID, 'cntResignEmp' => $cntResignEmp->EMP_ID]);
 }

 /**
  * Finds record by EMP_ID
  * @return EMP_ID|null
  * Also can use | $model = Employe::find()->where(['EMP_ID' => Yii::$app->user->identity->EMP_ID])->one();
  * @author ptrnov  <[email protected]>
  * @since 1.1
  */
 public function getEmpid()
 {
     if ($this->_empid === false) {
         $this->_empid = Employe::find()->where(['EMP_ID' => Yii::$app->user->identity->EMP_ID])->one();
     }
     return $this->_empid;
 }

 /**
  * CLASS TABLE FIND PrimaryKey
  * Example:  Employe::find()
  */
 protected function findModel($id)
 {
     if (($model = Employe::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }

 /**
  *array employe
  **/
 public function get_aryPerson()
 {
     $emp = \lukisongroup\hrd\models\Employe::find()->where('STATUS<>3')->all();
     // $sql = 'SELECT  EMP_NM,EMP_NM_BLK  FROM dbm002.`a0001`
     //         WHERE NOT EXISTS
     //         (SELECT PERSON_NAME FROM m0003 WHERE PERSON_NAME = EMP_NM);';
     // $exec = Yii::$app->db_widget->createCommand($sql)->queryAll();
     return $dropemploy = ArrayHelper::map($emp, 'EMP_NM', function ($emp, $defaultValue) {
         return $emp['EMP_NM'] . ' ' . $emp['EMP_NM_BLK'];
     });
 }

 /**
  * Finds record by EMP_ID
  * @return EMP_ID|null
  * Also can use | $model = Employe::find()->where(['EMP_ID' => Yii::$app->user->identity->EMP_ID])->one();
  * @author ptrnov  <[email protected]>
  * @since 1.1
  */
 public function getEmpid($empIdIdentity)
 {
     if ($this->_empid === false) {
         $this->_empid = Employe::find()->where(['EMP_ID' => $empIdIdentity])->one();
     }
     return $this->_empid;
 }

use kartik\grid\GridView;
use yii\helpers\Url;
use yii\helpers\ArrayHelper;
use yii\bootstrap\Modal;
use kartik\form\ActiveForm;
use kartik\tabs\TabsX;
/* namespace models */
use lukisongroup\master\models\Suplier;
use lukisongroup\hrd\models\Employe;
use lukisongroup\hrd\models\Corp;
/* array*/
$selectCorp = ArrayHelper::map(Corp::find()->where('CORP_STS<>3')->all(), 'CORP_ID', 'CORP_NM');
$poParentArray = [['ID' => 'POA', 'DESCRIP' => 'PO Plus'], ['ID' => 'POB', 'DESCRIP' => 'PO General'], ['ID' => 'POC', 'DESCRIP' => 'PO Product']];
$poParent = ArrayHelper::map($poParentArray, 'ID', 'DESCRIP');
$idEmp = Yii::$app->user->identity->EMP_ID;
$emp = Employe::find()->where(['EMP_ID' => $idEmp])->one();
$kr = $emp->DEP_SUB_ID;
$this->title = 'Purchaseorder';
$this->params['breadcrumbs'][] = $this->title;
?>

<?php 
/*
 * Declaration Componen User Permission
 * Function getPermission
 * Modul Name[3=PO]
 */
function getPermission()
{
    if (Yii::$app->getUserOpt->Modul_akses('3')) {
        return Yii::$app->getUserOpt->Modul_akses('3');

 public function getEmployee()
 {
     return $this->hasOne(Employe::className(), ['EMP_ID' => 'CREATED_BY']);
 }

 /**
  * 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="' . $profile->EMP_ID . '"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]);
     }
 }

echo Html::a('<i class="fa fa-check"></i> Konfirmasi', ['confirmdir', 'kdpo' => $model->KD_PO], ['class' => 'btn btn-success btn-xs']);
?>
                    &nbsp;
                    <!-- button class="btn btn-danger  btn-xs"><i class="fa fa-times"></i> Tolak</button -->
                    <?php 
//} }
//}
?>
                    
                </td>
            </tr>

            <tr>
                <td>
                    <?php 
$crte = Employe::find()->where(['EMP_ID' => $model->CREATE_BY])->one();
?>
                     <b><u><?php 
echo $crte->EMP_NM . ' ' . $crte->EMP_NM_BLK;
?>
</u></b><br/>
                     Purchaser
                </td>

                <td>
                    <b><u>
                    <?php 
/*   if($model->APPROVE_BY == ''){
         echo "***************";
     } else {
         $apprv = Employe::find()->where(['EMP_ID'=>$model->APPROVE_BY])->one();

<?php

use yii\helpers\Html;
use kartik\form\ActiveForm;
use yii\helpers\ArrayHelper;
use kartik\widgets\Select2;
use kartik\widgets\FileInput;
use kartik\widgets\DepDrop;
use yii\helpers\Url;
use lukisongroup\hrd\models\Employe;
#$aryEmployee = ArrayHelper::map(Employe::find()->all(),'EMP_ID','EMP_NM');
$aryEmployee = ArrayHelper::map(Employe::find()->all(), 'EMP_ID', function ($model, $defaultValue) {
    return $model->EMP_NM . '-' . $model->EMP_NM_BLK;
});
/* @var $this yii\web\View */
/* @var $model lukisongroup\hrd\models\Kar_finger */
/* @var $form yii\widgets\ActiveForm */
?>

<div class="kar-finger-form">

    <?php 
$form = ActiveForm::begin(['id' => 'finger-employe', 'enableClientValidation' => true, 'method' => 'post', 'action' => ['/hrd/absen-maintain/finger-emp-save']]);
?>

    <?php 
echo $form->field($model, 'TerminalID')->hiddenInput(['value' => $modelView->TerminalID, 'maxlength' => true])->label(false);
?>
	  
	<?php 
echo $form->field($model, 'mesinNm')->textInput(['value' => $modelView->Machine_nm, 'maxlength' => true, 'readonly' => true])->label('Machine ID');

function SIGN_1($acara)
{
    $data = Employe::find()->where(['EMP_ID' => $acara[0]->SIG1_ID])->one();
    return $data->SIGSVGBASE64;
}

 public function getApprove()
 {
     return $this->hasOne(Employe::className(), ['EMP_ID' => 'APPROVE_DIR']);
 }

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

 public function getAgendaTbl2()
 {
     return $this->hasOne(Employe::className(), ['EMP_ID' => 'PIC']);
 }

} 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" >

 public function getEmpTbl()
 {
     return $this->hasOne(Employe::className(), ['EMP_ID' => 'EMP_ID'])->via('userTbl');
 }

 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;
 }

        $gambaravatar = '/img_setting/noimage/df.jpg';
        $nama = $useavatar->EMP_NM;
    } else {
        # code...
        $nama = $useavatar->EMP_NM;
        $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMG_BASE64;
    }
} elseif ($params['chat'] == 'group') {
    # code...
    $group_id = $params['ChatSearch']['GROUP'];
    $useavatar = Chatroom::find()->where(['GROUP_ID' => $group_id])->one();
    $nama = $useavatar->GROUP_NM;
    $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMAGE64;
} else {
    $emp_chat_id = $params['ChatSearch']['GROUP'];
    $useavatar = Employe::find()->where(['EMP_ID' => $emp_chat_id])->one();
    if ($useavatar->IMG_BASE64 == '') {
        $nama = $useavatar->EMP_NM;
        $gambaravatar = '/img_setting/noimage/df.jpg';
    } else {
        # code...
        $nama = $useavatar->EMP_NM;
        $gambaravatar = 'data:image/jpg;charset=utf-8;base64,' . $useavatar->IMG_BASE64;
    }
}
?>

<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
    <meta name="description" content="" />

use lukisongroup\hrd\models\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 = 'ubudsatu.com';
/* 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', 'UbudSatu');
/* 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 Sendmail3($kd, $empid)
 {
     $roHeader = Salesorder::find()->where(['KD_RO' => $kd])->one();
     /*Noted check by status approval =1 header table | chek error record jika kosong*/
     $detro = $roHeader->detro;
     $employ = $roHeader->employe;
     $dept = $roHeader->dept;
     $roDetail = Sodetail::find()->where(['KD_RO' => $kd])->all();
     // element email author :wawan
     $profile = Yii::$app->getUserOpt->Profile_user();
     // profile
     $user_dephead = $profile->username;
     // email dephead
     $user = Userlogin::find()->where(['EMP_ID' => $roHeader->SIG1_ID])->asArray()->one();
     $usersign1 = $user['username'];
     // send mail user create ro
     $cari = Employe::find()->where(['EMP_ID' => $roHeader->SIG2_ID])->asArray()->one();
     $cari_usercc = Employe::find()->where(['DEP_ID' => $cari['DEP_ID']])->andwhere('GF_ID<=3')->asArray()->one();
     $usercc = $cari_usercc['EMP_EMAIL'];
     // email usercc
     /* PR Filter Status Output to Grid print*/
     $dataProvider = new ArrayDataProvider(['key' => 'ID', 'allModels' => $roDetail, 'pagination' => ['pageSize' => 20]]);
     //PR
     //$dataProviderFilter = $dataProvider->getModels();
     /* $StatusFilter = ["101","10"];
            $test1 = ArrayHelper::where($dataProviderFilter, function($key, $StatusFilter) {
                 return is_string($value);
            });
        print_r($test1); */
     $content = $this->renderPartial('pdfview_tmp', ['roHeader' => $roHeader, 'detro' => $detro, 'employ' => $employ, 'dept' => $dept, 'dataProvider' => $dataProvider]);
     $contentMail = $this->renderPartial('sendmailcontent', ['roHeader' => $roHeader, 'detro' => $detro, 'employ' => $employ, 'dept' => $dept, 'dataProvider' => $dataProvider]);
     /*Body Notify*/
     $contentMailAttachBody = $this->renderPartial('postman_body', ['roHeader' => $roHeader, 'dataProvider' => $dataProvider]);
     $pdf = new Pdf(['mode' => Pdf::MODE_CORE, 'format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'destination' => Pdf::DEST_BROWSER, 'content' => $content, 'cssFile' => '@lukisongroup/web/widget/pdf-asset/kv-mpdf-bootstrap.min.css', 'cssInline' => '.kv-heading-1{font-size:12px}', 'options' => ['title' => 'Form Request Order', 'subject' => 'ro'], 'methods' => ['SetHeader' => ['Copyright@LukisonGroup ' . date("r")], 'SetFooter' => ['{PAGENO}']]]);
     $to = [$usersign1, $usercc, $user_dephead];
     \Yii::$app->kirim_email->pdf($contentMail, 'SO', $to, 'Sales-Order', $contentMailAttachBody);
 }