$query, 'sort' => [ 'defaultOrder' => ['id' => SORT_DESC], ] ]); $this->load($params); if (!$this->validate()) { return $dataProvider; } $query->joinWith(['lot', 'user']); $query->andFilterWhere([ 'date_start' => $this->date_start, 'bidding_date' => $this->date_stop, 'last_price' => $this->last_price, 'last_user' => $this->last_user, 'last_date' => $this->last_date, ]); $query->andFilterWhere(['like', 'lots.name', $this->lot]); $query->andFilterWhere(['like', 'auctions.name', $this->name]); //$query->andFilterWhere(['like','lots.start_price',$this->lot]); return $dataProvider; } }