/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/BranchReviewSearch.php (3272B)
alias('BR')
->select([
'BR.*',
"CONCAT_WS(' ', U.first_name, U.last_name) AS customer_name",
'BL.branch_name',
'VL.vendor_name',
])
->leftJoin(['BL' => BranchLang::tableName()], 'BL.branch_id = BR.branch_id')
->leftJoin(['U' => User::tableName()], 'U.user_id = BR.user_id')
->leftJoin(['VL' => VendorLang::tableName()], 'VL.vendor_id = BR.vendor_id')
->groupBy('BR.branch_review_id');
// echo yii::$app->user->getId();die;
if(\backend\models\AdminUser::isVendor()){
$query->where(['BR.vendor_id' => yii::$app->user->getId()]);
}
if(\backend\models\AdminUser::isBranch()){
$query->where(['BR.branch_id' => yii::$app->user->getId()]);
}
$query->orderBy(['BR.branch_review_id' => SORT_DESC]);
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'defaultPageSize' => Com::postPerPage()
],
'sort' => [
'attributes' => [
'customer_name',
'rating',
'review',
'vendor_name',
'branch_name',
'created_at',
],
'defaultOrder' => [
'customer_name' => SORT_ASC,
'rating' => SORT_DESC,
'review' => SORT_DESC,
'vendor_name' => SORT_ASC,
'branch_name' => SORT_ASC,
'created_at' => SORT_DESC,
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'rating', $this->rating])
->andFilterWhere(['like', 'review', $this->review])
->andFilterWhere(['like', 'first_name', $this->customer_name])
->andFilterWhere(['like', 'BR.status', $this->status])
->andFilterWhere(['like', 'vendor_name', $this->vendor_name])
->andFilterWhere(['like', 'branch_name', $this->branch_name])
->andFilterWhere(['like', 'created_at', $this->created_at]);
return $dataProvider;
}
}