PHP Employe::find方法代码示例

 /**
  * 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  <piter@lukison.com>
  * @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;
 }

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

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

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 actionUploadSignatureFile()
 {
     $model = new FileManage();
     if ($model->load(Yii::$app->request->post())) {
         //if($model->validate()){
         $model->USER_ID = Yii::$app->user->identity->username;
         $model->FILE_PATH = 'signature';
         $exportFile = $model->uploadFile();
         //$base64File = \yii\web\UploadedFile::getInstance($model, 'uploadDataFile');
         // $dateFile=\yii\web\UploadedFile::getInstanceByName($fileName);
         $exportFile64 = $this->saveimage(file_get_contents($exportFile->tempName));
         $exportFile64Image = 'data:image/jpg;charset=utf-8;base64,' . $exportFile64;
         $model->FILE_NM64 = $exportFile64Image;
         //print_r($exportFile64);
         //die();
         if ($model->save()) {
             //upload only if valid uploaded file instance found
             if ($exportFile !== false) {
                 $path = $model->getImageFile();
                 $exportFile->saveAs($path);
                 $employeUpdate = Employe::find()->where(['EMP_ID' => Yii::$app->user->identity->EMP_ID])->one();
                 $employeUpdate->SIGSVGBASE64 = $exportFile64Image;
                 $employeUpdate->save();
                 return $this->redirect(['index']);
             }
         }
         //}
     }
 }

 /**
  * 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  <piter@lukison.com>
  * @since 1.1
  */
 public function getEmpid($empIdIdentity)
 {
     if ($this->_empid === false) {
         $this->_empid = Employe::find()->where(['EMP_ID' => $empIdIdentity])->one();
     }
     return $this->_empid;
 }

 /**
  * Creates a new Mdlpermission model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  * @return mixed
  */
 public function actionCreate()
 {
     if (!self::getPermission()->BTN_CREATE) {
         //PERMISSION CHECK - RETURN INDEX -ptr.nov--
         $this->redirect(['/sistem/modul-permission', 'msg' => 'alert']);
     } else {
         $model = new Userlogin();
         $model->scenario = 'createuser';
         $data = ArrayHelper::map(Employe::find()->orderBy('EMP_NM')->asArray()->all(), 'EMP_ID', 'EMP_NM');
         if ($model->load(Yii::$app->request->post())) {
             $hash = Yii::$app->getSecurity()->generatePasswordHash($model->password_hash);
             $model->password_hash = $hash;
             $model->created_at = strtotime(date('Y-m-d'));
             if ($model->save()) {
                 $data = Modulerp::find()->asArray()->all();
                 foreach ($data as $hasil) {
                     $connection = Yii::$app->db;
                     $connection->createCommand()->batchInsert('modul_permission', ['USER_ID', 'MODUL_ID'], [[$model->id, $hasil['MODUL_ID']]])->execute();
                 }
             }
             return $this->redirect('index');
         } else {
             return $this->renderAjax('create', ['model' => $model, 'data' => $data]);
         }
     }
 }

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>

 /**
  * Finds the Pilotproject model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $id
  * @return Pilotproject the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findAtasan($emp_id, $dep_id)
 {
     $dep_id1 = Yii::$app->getUserOpt->Profile_user()->emp->DEP_ID;
     if ($dep_id1 == $dep_id) {
         $emp = Employe::find()->where('EMP_ID="' . $emp_id . '" AND DEP_ID="' . $dep_id . '" AND GF_ID<=4')->one();
         if (count($emp) != 0) {
             return 'Atasan';
         } else {
             return 'Bukan Atasan';
         }
     } else {
         return 'Bukan Atasan';
     }
 }

<?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');
/* @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');
?>
	<?php 
echo $form->field($model, 'FingerPrintID')->textInput(['value' => $modelView->FingerPrintID, 'maxlength' => true, 'readonly' => true])->label('Finger');

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

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

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();

        $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="" />