/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/ItemBottleRefundHistorySearch.php (2219B)
alias('Ebottle')
->select([
'U.first_name',
'U.last_name',
'U.mobile_number',
'Ebottle.*',
])
->leftJoin(['U' => User::tableName()], 'U.user_id = Ebottle.user_id');
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'PageSize' => Com::postPerPage(),
],
'sort' => [
'attributes' => [
//'first_name',
//'email',
],
'defaultOrder' => [
//'customer_name' => SORT_ASC,
//'email' => SORT_ASC
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'U.first_name', $this->first_name])
->andFilterWhere(['like', 'U.last_name', $this->last_name])
->andFilterWhere(['like', 'U.mobile_number', $this->mobile_number])
->andFilterWhere(['like', 'Ebottle.refund_bottle_qty', $this->refund_bottle_qty])
->andFilterWhere(['like', 'Ebottle.refund_status', $this->refund_status]);
return $dataProvider;
}
}