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;
}
public function getEmp()
{
return $this->hasOne(Employe::className(), ['EMP_ID' => 'EMP_ID']);
}
