/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/BranchSearch.php (2804B)
alias('B')
->select([
'B.*',
'BL.*',
'VL.vendor_name'
])
->where(['<>', 'B.branch_status', Branch::DELETE]);
//Branch::selectTranslation($query);
$query->leftJoin(['BL' => BranchLang::tableName()], 'BL.branch_id = B.branch_id and BL.language_code = "'.Yii::$app->language.'" ');
$query->leftJoin(['VL' => VendorLang::tableName()], 'VL.vendor_id = B.vendor_id and VL.language_code = "'.Yii::$app->language.'" ');
if(AdminUser::isVendor()){
$query->andWhere( 'VL.vendor_id ='.yii::$app->user->getId() );
}
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'PageSize' => Com::postPerPage(),
],
'sort' => [
'defaultOrder' => [
// 'branch_name' => SORT_ASC,
// 'vendor_name' => SORT_ASC,
// 'contact_email' => SORT_ASC
]
,
'attributes' => [
'branch_name',
'vendor_name ',
'contact_email'
]
]
]);
$this->load($params);
if(!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['like', 'BL.branch_name', strtolower($this->branch_name)])
->andFilterWhere(['like', 'VL.vendor_name', strtolower($this->vendor_name)])
->andFilterWhere(['like', 'B.contact_email', strtolower($this->contact_email)])
->andFilterWhere(['like', 'B.contact_number', strtolower($this->contact_number)])
->andFilterWhere(['like', 'B.branch_status', $this->branch_status])
->andFilterWhere(['like', 'BL.area', $this->area])
->andFilterWhere(['like', 'BL.city', $this->city])
->andFilterWhere(['like', 'B.branch_availability_status', $this->branch_availability_status]);
return $dataProvider;
}
}