/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/old_VendorOrderReportSearch.php (2376B)
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');
$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');
}
}