/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/OrderMallProductSearch.php (2452B)
alias('OMP')
->select([
'OMP.*',
'U.first_name',
'U.last_name'
]);
OrderMallProduct::selectTranslation($query);
$query ->leftJoin(['U' => User::tableName()], 'U.user_id = OMP.user_id');
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'PageSize' => 10,
],
'sort' => [
'attributes' => [
'product_name',
'price',
'order_product_number',
'first_name',
'order_date_time'
],
'defaultOrder' => [
'order_product_number' => SORT_DESC,
'product_name' => SORT_ASC,
'price' => SORT_DESC,
'first_name' => SORT_ASC,
'order_date_time' => SORT_DESC
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'product_name', strtolower($this->product_name)])
->andFilterWhere(['like', 'first_name', strtolower($this->first_name)])
->andFilterWhere(['like', 'order_product_number', $this->order_product_number])
->andFilterWhere(['like', 'order_status', $this->order_status]);
return $dataProvider;
}
}