php - Yii2如何在搜索模型中添加价格范围过滤器

Question

我在 yii2 中创建了一个搜索模型。我想在其中添加一个价格起始和价格结束文本字段和过滤条件。现在下面给出的过滤选项

$query->andFilterWhere([
            'id' => $this->id,
            'city_id' => $this->city_id,
            'price' => $this->price, <====Here i want to add price range
            'age_id' => $this->age_id,
            'usage_id' => $this->usage_id,
            'condition_id' => $this->condition_id,
            'seller_type_id' => $this->seller_type_id,
            'warranty_id' => $this->warranty_id,
            'flag' => $this->flag,
        ]);

我怎样才能做到这一点

标签： phpsearchfilteryii

Answer 1

I just done like this

$query->andFilterWhere(['between','price',$this->price_start,$this->price_end])