/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/AdminOrderReportSearch.php (2621B)
'php:Y-m-d H:i:s'],
['to_date', 'compare', 'compareAttribute' => 'from_date', 'operator' => '>'],
];
}
/**
* @param $params
* @return ActiveDataProvider
* @throws \Throwable
*/
public function search($params)
{
$query = Order::find()
->alias('O')
->select([
'O.*',
'VL.vendor_name',
'O.coupon_offer_value as total_discount_value'
])
->leftJoin(['VL' => VendorLang::tableName()], 'VL.vendor_id = O.vendor_id')
->groupBy('O.order_id')
->where(['order_status' => Order::ORDER_STATUS_DELIVERED]);
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'defaultPageSize' => Com::postPerPage()
],
'sort' => [
'defaultOrder' => [
'order_date_time' => SORT_DESC
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['>=', 'order_date_time', $this->from_date])
->andFilterWhere(['<=', 'order_date_time', $this->to_date])
->andFilterWhere(['O.vendor_id' => $this->vendor_id]);
return $dataProvider;
}
/**
* @return array
*/
public function getVendors()
{
$query = Vendor::find()->alias('V')
->select(['V.vendor_id']);
Vendor::selectTranslation($query);
return ArrayHelper::map($query->all(), 'vendor_id', 'vendor_name');
}
}