public function searchForimportemployee($params)
{
$query = Impemployee::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['idemployee.idperson.auth_user_fullname' => SORT_ASC]]]);
$query->joinWith(['idemployee.iddolzh', 'idemployee.idpodraz', 'idemployee.idbuild']);
$this->load($params);
$this->id_importemployee = $params['id'];
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['impemployee_id' => $this->impemployee_id, 'id_importemployee' => $this->id_importemployee, 'id_employee' => $this->id_employee]);
$query->andFilterWhere(['LIKE', 'idemployee.employee_id', $this->getAttribute('idemployee.employee_id')]);
$query->andFilterWhere(['LIKE', 'iddolzh.dolzh_name', $this->getAttribute('idemployee.iddolzh.dolzh_name')]);
$query->andFilterWhere(['LIKE', 'idpodraz.podraz_name', $this->getAttribute('idemployee.idpodraz.podraz_name')]);
$query->andFilterWhere(['LIKE', 'idbuild.build_name', $this->getAttribute('idemployee.idbuild.build_name')]);
Proc::AssignRelatedAttributes($dataProvider, ['idemployee.employee_id', 'idemployee.iddolzh.dolzh_name', 'idemployee.idbuild.build_name', 'idemployee.idpodraz.podraz_name']);
return $dataProvider;
}
