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