/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/EnquirySearch.php (1613B)
alias('E')
->select(['E.*']);
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'PageSize' => Com::postPerPage(),
],
'sort' => [
'attributes' => [
'first_name',
'email',
],
'defaultOrder' => [
'first_name' => SORT_ASC,
'email' => SORT_ASC
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'First_name', $this->first_name])
->andFilterWhere(['like', 'email', $this->email])
->andFilterWhere(['like', 'mobile_number', $this->mobile_number])
->andFilterWhere(['like', 'company_name', $this->company_name]);
return $dataProvider;
}
}