$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; } if($product_id){ $query->andFilterWhere([ 'product_id' => $product_id, ]); } // grid filtering conditions $query->andFilterWhere([ 'product_variant_id' => $this->product_variant_id, 'price' => $this->price, 'price_old' => $this->price_old, 'stock' => $this->stock, 'product_unit_id' => $this->product_unit_id, 'product_variant_type_id' => $this->product_variant_type_id, ]); $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'sku', $this->sku]) ->andFilterWhere(['like', 'remote_id', $this->remote_id]); return $dataProvider; } }