/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Dealers::find(); $dataProvider = new ActiveDataProvider([ 'query' => $query, ]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere([ 'id' => $this->id, 'user' => $this->user, ]); $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'city', $this->city]) ->andFilterWhere(['like', 'contact', $this->contact]) ->andFilterWhere(['like', 'address', $this->address]); return $dataProvider; }
/** * Displays a single Dealers model. * @param integer $id * @return mixed */ public function actionView($id) { $_model = Dealers::find() ->with(['user0']) ->where('id=:id',[':id' => $id]) ->one(); if($_model === null){ Auction::infoLog('No Dealer Found' , ['id' => $id]); throw new NotFoundHttpException('No Dealer Found'); } return $this->render('view', [ 'model' => $_model ]); }
/** * Get Dealer Info */ protected function loadModel(){ /** * Load All Related Models Of Users * having userId is logged in dealer user Id */ $query= Dealers::find()->joinWith([ 'user0', ])->where([ 'user' => Auction::$app->user->id ]); $model=$query->one(); if($model === null){ throw new HttpException(400, 'Not a Valid Dealer'); } return $model; }
protected function loadProfile(){ $model = Dealers::find()->joinWith([ 'user0', 'dealerPreferences' => function($query){ $query->with([ 'category0', 'brand0' ]); } ])->where([ 'dealers.id' => Auction::$app->session->get('user.dealer', 0) ])->one(); if($model === null){ Auction::error('No Valid Dealer Found with userid '.Auction::$app->user->id); throw new HttpException(404, 'No user found'); } return $model; }