public function loginform_saved()
{
if ($this->validate()) {
$roHeader = Requestterm::find()->where(['KD_RO' => $this->kdro])->one();
$profile = Yii::$app->getUserOpt->Profile_user();
$roHeader->STATUS = $this->status;
$roHeader->SIG2_SVGBASE64 = $profile->emp->SIGSVGBASE64;
$roHeader->SIG2_SVGBASE30 = $profile->emp->SIGSVGBASE30;
$roHeader->SIG2_NM = $profile->emp->EMP_NM . ' ' . $profile->emp->EMP_NM_BLK;
$roHeader->SIG2_TGL = date('Y-m-d');
if ($roHeader->save()) {
return $roHeader;
}
return $roHeader;
}
return null;
}
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 = Requestterm::find()->where("r0001.status <> 3 and r0001.status <> 0 and r0001.KD_CORP = '{$crp}' ");
} else {
$query = Requestterm::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;
}