/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/TodaySpecialSearch.php (1842B)
alias('TS')
->select('*')
->where(['<>', 'TS.today_special_status', TodaySpecial::DELETE]);
TodaySpecial::selectTranslation($query);
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'PageSize' => 10,
],
'sort' => [
'attributes' => [
'today_special_name',
'from_date',
'to_date'
],
'defaultOrder' => [
'today_special_name' => SORT_ASC,
'from_date' => SORT_DESC,
'to_date' => SORT_DESC
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query-> andFilterWhere(['like', 'today_special_name', strtolower($this->today_special_name)])
->andFilterWhere(['like', 'today_special_status', $this->today_special_status])
->andFilterWhere(['>=', 'DATE(from_date)', $this->from_date])
->andFilterWhere(['<=', 'DATE(to_date)',$this->to_date]);
return $dataProvider;
}
}