Django模型多条件筛选失效求助：灵活房产搜索无匹配结果

我正在开发一个Django房产项目，需要实现支持房产类型、州、最小卧室数、浴室类型、价格区间的灵活搜索，用户可选择填写部分字段而非全部。但现在没有报错，却搜不到匹配结果——哪怕搜索条件完全符合数据库里的Model记录，也显示不出结果。以下是我的代码：

Property Model代码 #

class Property(models.Model):
    PROPERTY_TYPE_CHOICES = [
        ('Complete House', 'Complete House'),
        ('Apartment', 'Apartment'),
        ('Self-Contained', 'Self-Contained'),
    ]

    BEDROOM_CHOICES = [
        ('1', '1'),
        ('2', '2'),
        ('3', '3'),
        ('4', '4'),
        ('5', '5+'),
    ]

    BATHROOM_CHOICES = [
        ('Self-contained', 'Self-contained'),
        ('General', 'General'),
        ('Private Detached', 'Private Detached'),
    ]

    COUNTRY_CHOICES = [
        ('Nigeria', 'Nigeria'),
    ]

    STATE_CHOICES = [
        ('Abia', 'Abia'),
        ('Adamawa', 'Adamawa'),
        ('Akwa Ibom', 'Akwa Ibom'),
        ('Anambra ', 'Anambra '),  # 存在末尾空格
        ('Bauchi', 'Bauchi'),
        ('Bayelsa', 'Bayelsa'),
        ('Benue ', 'Benue '),  # 存在末尾空格
        ('Borno', 'Borno'),
        ('Cross River', 'Cross River'),
        ('Delta', 'Delta'),
        ('Ebonyi', 'Ebonyi'),
        ('Edo', 'Edo'),
        ('Ekiti', 'Ekiti'),
        ('Enugu', 'Enugu'),
        ('Gombe', 'Gombe'),
        ('Imo', 'Imo'),
        ('Jigawa', 'Jigawa'),
        ('Kaduna', 'Kaduna'),
        ('Kano', 'Kano'),
        ('Katsina', 'Katsina'),
        ('Kebbi', 'Kebbi'),
        ('Kogi', 'Kogi'),
        ('Kwara', 'Kwara'),
        ('Lagos', 'Lagos'),
    ]

    agent = models.ForeignKey(Agent, on_delete=models.SET_NULL, blank=True, null=True)
    landlord = models.ForeignKey(Landlord, on_delete=models.SET_NULL, blank=True, null=True)
    description = models.CharField(max_length=60, blank=True, null=True)
    property_type = models.CharField(max_length=20, choices=PROPERTY_TYPE_CHOICES)
    bedrooms = models.CharField(max_length=2, blank=True, null=True, choices=BEDROOM_CHOICES)
    bathroom_type = models.CharField(max_length=20, choices=BATHROOM_CHOICES)
    country = models.CharField(max_length=20, choices=COUNTRY_CHOICES)
    state = models.CharField(max_length=20, choices=STATE_CHOICES)
    state_lga = models.CharField(max_length=12, blank=True, null=True)
    address = models.CharField(max_length=60, null=True, blank=True)
    latitude = models.FloatField(null=True, blank=True)
    longitude = models.FloatField(null=True, blank=True)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    is_available = models.BooleanField(default=True)
    image = models.ImageField(default='avatar.jpg', blank=False, null=False, upload_to='profile_images')
    last_updated = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.description

SearchForm代码 #

class SearchForm(forms.Form):
    property_type = forms.ChoiceField(choices=Property.PROPERTY_TYPE_CHOICES, required=False)
    state = forms.ChoiceField(choices=Property.STATE_CHOICES, required=False)
    min_beds = forms.CharField(max_length=10, required=False, widget=forms.TextInput(attrs={'placeholder': "Min Bedrooms"}))
    bathroom_type = forms.ChoiceField(choices=Property.BATHROOM_CHOICES, required=False)
    min_price = forms.DecimalField(max_digits=10, decimal_places=2, required=False, widget=forms.TextInput(attrs={'placeholder': "Min Price"}))
    max_price = forms.DecimalField(max_digits=10, decimal_places=2, required=False, widget=forms.TextInput(attrs={'placeholder': "Max Price"}))

View代码 #

# Home Page View.
def index(request):
    listings = Property.objects.filter(is_available=True).order_by('-last_updated')[:6]
    form = SearchForm(request.GET or None)

    if request.method == 'GET' and form.is_bound:
        if form.is_valid():
            cleaned_data = form.cleaned_data
            property = cleaned_data.get('property_type')
            state = cleaned_data.get('state')
            min_beds = cleaned_data.get('min_beds') or 0
            bathroom = cleaned_data.get('bathroom_type')
            min_price = cleaned_data.get('min_price')
            max_price = cleaned_data.get('max_price')

            # Filter properties based on search parameters
            properties = Property.objects.filter(is_available=True)
            if property:
                properties = properties.filter(property_type=property)
            if state:
                properties = properties.filter(state=state)
            if min_beds:
                properties = properties.filter(bedrooms__gte=min_beds)
            if bathroom:
                properties = properties.filter(bathroom_type=bathroom)
            if min_price:
                properties = properties.filter(price__gte=min_price)
            if max_price:
                properties = properties.filter(price__lte=max_price)

            # Apply sorting
            properties = properties.order_by('-last_updated')[:6]

            context = {
                'listings': properties,
                'page_title': 'Ease to Locate Ease to Rent... | UyaProp',
                'form': form,
            }
            return render(request, 'pages/index.html', context)

    context = {
        'listings': listings,
        'form': form,
    }
    return render(request, 'pages/index.html', context)

HTML代码 #

<div class="search-property">
    <form method="GET" action="{% url 'pages-index' %}">
       {% csrf_token %}
        <div class="row">
            <div class="col-md-3">
                <div class="single-search-property">
                   <div class="intro">
                      {{ form.property_type }}
                  </div>
                    
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property">
                    <div class="intro">
                        {{ form.state }}
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property">
                    {{ form.min_beds }}
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property">
                   <div class="intro">
                      {{ form.bathroom_type }}
                  </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property">
                    {{ form.min_price }}
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property">
                    {{ form.max_price }}
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-search-property button">
                    <button type="submit">Search</button>
                </div>
            </div>
        </div>
    </form>
</div>

问题排查与修复方案 #

1. 州选项的空格问题

STATE_CHOICES里的'Anambra '和'Benue '带有末尾空格，而数据库中存储的state值通常不会包含这些空格，直接导致匹配失败。必须去掉选项的末尾空格：

STATE_CHOICES = [
    # ... 其他选项保持不变
    ('Anambra', 'Anambra'),  # 移除末尾空格
    # ...
    ('Benue', 'Benue'),  # 移除末尾空格
    # ...
]

同时需要更新数据库中已有的对应记录，将state字段的空格去掉。

2. 卧室数字段的类型匹配问题

bedrooms是CharField，用__gte做字符串比较会不符合预期（比如字符串'3'和'5'比较时，'3' > '5'为False，因为ASCII码顺序）。推荐两种修复方式：

• 方案一（推荐）：将bedrooms字段改为IntegerField，同时调整选项的value为数字：

  bedrooms = models.IntegerField(blank=True, null=True, choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5+')])
  

• 方案二：在View中把min_beds转成整数后再处理过滤逻辑，兼容现有CharField：

  if min_beds:
      try:
          min_beds_int = int(min_beds)
          # 处理'5+'的情况：如果输入的最小卧室数<=5，包含所有bedrooms>=输入值的记录
          properties = properties.filter(
              Q(bedrooms__gte=str(min_beds_int)) | 
              (Q(bedrooms='5') & (min_beds_int <=5))
          )
      except ValueError:
          # 输入不是有效数字，跳过该条件
          pass
  

3. min_beds的默认值处理

当前代码中min_beds = cleaned_data.get('min_beds') or 0会导致用户未输入时，过滤条件变为bedrooms__gte=0，但bedrooms是CharField，和整数0比较会引发查询错误。应改为仅当min_beds有有效值时才添加过滤：

min_beds = cleaned_data.get('min_beds')
# 移除or 0的逻辑
# ...
if min_beds:
    # 这里添加类型转换和过滤逻辑

4. GET请求中的csrf_token

GET请求不需要csrf_token，可从HTML表单中删除{% csrf_token %}，避免不必要的参数传递。

5. Form中min_beds字段优化

将min_beds从CharField改为IntegerField，减少前端输入后的类型转换问题：

min_beds = forms.IntegerField(required=False, widget=forms.NumberInput(attrs={'placeholder': "Min Bedrooms"}))

内容的提问来源于stack exchange，提问作者apollos