/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Documents::find();
$query->joinWith(['from', 'to']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
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(['ID' => $this->ID, 'Document' => $this->Document, 'Company' => $this->Company, 'Type' => $this->Type])->andFilterWhere(['like', 'WarehousesFrom.Warehouse', $this->From])->andFilterWhere(['like', 'WarehousesTo.Warehouse', $this->To])->andFilterWhere(['like', 'Date', $this->Date]);
$query->andFilterWhere(['like', 'Comment', $this->Comment]);
return $dataProvider;
}
