Django房产搜索：排除GET空参数并实现按需过滤

问题现状 #

当前房产搜索存在两个核心问题：

1. 仅填写全部搜索条件时搜索才生效，部分条件或无条件无法正确返回结果
2. 搜索后的GET请求包含空值参数（如district=），导致URL冗余

现有代码 #

search.html 代码 #

<h1>Property Search</h1>
<hr>
<form method="GET" action="/search/results/?{{ query_params }}" class="form-inline" style="display: flex; justify-content: center; align-items: center; ">
    <div class="form-group mx-sm-3 mb-2">
        <label for="inputSaleRent" class="mr-2" style="margin-right: 10px; font-weight: bold;">Sale/Rent:</label>
        <select id="inputSaleRent" name="sale_rent" class="form-control" style="width: 150px; margin-right: 10px;">
            <option value="">Choose...</option>
            <option value="sale">For Sale</option>
            <option value="rent">For Rent</option>
        </select>
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputDistrict" class="mr-2" style="margin-right: 10px; font-weight: bold;">District:</label>
        <select id="inputDistrict" name="district" class="form-control" style="width: 150px; margin-right: 10px;">
            <option value="">Choose...</option>
            <option value="District 1">District 1</option>
            <option value="District 2">District 2</option>
            <!-- Add more district options -->
        </select>
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputMunicipality" class="mr-2" style="margin-right: 10px; font-weight: bold;">Municipality/Community:</label>
        <select id="inputMunicipality" name="municipality" class="form-control" style="width: 150px; margin-right: 10px;">
            <option value="">Choose...</option>
            <option value="Municipality 1">Municipality 1</option>
            <option value="Municipality 2">Municipality 2</option>
            <!-- Add more municipality options -->
        </select>
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputParish" class="mr-2" style="margin-right: 10px; font-weight: bold;">Parish:</label>
        <select id="inputParish" name="parish" class="form-control" style="width: 150px; margin-right: 10px;">
            <option value="">Choose...</option>
            <option value="Parish 1">Parish 1</option>
            <option value="Parish 2">Parish 2</option>
            <!-- Add more parish options -->
        </select>
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputPropertyType" class="mr-2" style="margin-right: 10px; font-weight: bold;">Property Type:</label>
        <select id="inputPropertyType" name="property_type" class="form-control" style="width: 150px; margin-right: 10px;">
            <option value="">Choose...</option>
            <option value="Apartment">Apartment</option>
            <option value="Studio">Studio</option>
            <!-- Add more property type options -->
        </select>
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputMinPrice" class="mr-2" style="margin-right: 10px; font-weight: bold;">Min Price:</label>
        <input type="text" name="min_price" class="form-control" id="inputMinPrice" style="width: 150px; margin-right: 10px;">
    </div>
    <div class="form-group mx-sm-3 mb-2" style="display: flex; align-items: center;">
        <label for="inputMaxPrice" class="mr-2" style="margin-right: 10px; font-weight: bold;">Max Price:</label>
        <input type="text" name="max_price" class="form-control" id="inputMaxPrice" style="width: 150px; margin-right: 10px;">
    </div>
    <button type="submit" class="btn btn-primary mb-2" style="display: flex; align-items: center; margin-left: 10px;">Search</button>
</form>
<hr>

views.py 代码 #

def property_search(request):
    if request.method == 'GET':
        return render(request, 'search.html')

    if request.method == 'POST':
        sale_rent = request.POST.get('sale_rent')
        district = request.POST.get('district')
        municipality = request.POST.get('municipality')
        parish = request.POST.get('parish')
        property_type = request.POST.get('property_type')
        min_price = request.POST.get('min_price')
        max_price = request.POST.get('max_price')
    
        query_params = {}
    
        # Set the query parameters based on the provided values
        if sale_rent:
            query_params['sale_rent'] = sale_rent
        if district:
            query_params['district'] = district
        if municipality:
            query_params['municipality'] = municipality
        if parish:
            query_params['parish'] = parish
        if property_type:
            query_params['property_type'] = property_type
        if min_price:
            query_params['min_price'] = min_price
        if max_price:
            query_params['max_price'] = max_price
    
        properties = Property.objects.all()
    
        # Apply filters based on the search criteria
        if sale_rent:
            properties = properties.filter(sale_rent=sale_rent)
        if district:
            properties = properties.filter(district=district)
        if municipality:
            properties = properties.filter(municipality=municipality)
        if parish:
            properties = properties.filter(parish=parish)
        if property_type:
            properties = properties.filter(property_type=property_type)
        if min_price:
            properties = properties.filter(price__gte=min_price)
        if max_price:
            properties = properties.filter(price__lte=max_price)
    
        # Generate the URL query string without empty parameters
        encoded_query_params = urlencode(query_params)
    
        context = {'properties': properties, 'query_params': encoded_query_params}
        return render(request, 'property_search_results.html', context)
    
    return render(request, 'search.html')

当前搜索请求示例 #

GET /search/results/?sale_rent=sale&district=&municipality=&parish=&property_type=&min_price=1000&max_price=1000000000

修复方案 #

1. 统一请求方式（推荐使用GET） #

当前表单用method="GET"，但视图只处理POST请求，这是功能失效的核心原因。修改视图为处理GET请求：

from urllib.parse import urlencode

def property_search(request):
    if request.method == 'GET':
        # 获取参数并去除首尾空格，空值设为''
        sale_rent = request.GET.get('sale_rent', '').strip()
        district = request.GET.get('district', '').strip()
        municipality = request.GET.get('municipality', '').strip()
        parish = request.GET.get('parish', '').strip()
        property_type = request.GET.get('property_type', '').strip()
        min_price = request.GET.get('min_price', '').strip()
        max_price = request.GET.get('max_price', '').strip()
    
        query_params = {}
        # 仅收集非空参数
        for key, value in locals().items():
            if value and key != 'request':
                query_params[key] = value
    
        # 初始查询所有房产
        properties = Property.objects.all()
    
        # 逐个应用过滤条件
        if sale_rent:
            properties = properties.filter(sale_rent=sale_rent)
        if district:
            properties = properties.filter(district=district)
        if municipality:
            properties = properties.filter(municipality=municipality)
        if parish:
            properties = properties.filter(parish=parish)
        if property_type:
            properties = properties.filter(property_type=property_type)
        # 价格过滤添加格式验证，避免非数字输入报错
        if min_price:
            try:
                properties = properties.filter(price__gte=float(min_price))
            except ValueError:
                pass
        if max_price:
            try:
                properties = properties.filter(price__lte=float(max_price))
            except ValueError:
                pass
    
        # 生成无空值的查询字符串
        encoded_query_params = urlencode(query_params)
    
        # 返回结果页，空参数时展示全部房产
        context = {'properties': properties, 'query_params': encoded_query_params}
        return render(request, 'property_search_results.html', context)
    
    return render(request, 'search.html')

同时修改search.html的form标签，移除冗余的?{{ query_params }}：

<form method="GET" action="/search/results/" class="form-inline" style="display: flex; justify-content: center; align-items: center; ">
    <!-- 表单内容保持不变 -->
</form>

2. 确保空参数被排除 #

通过在视图中仅收集非空参数，再用urlencode生成查询字符串，最终URL将只包含有效参数。例如仅选择sale_rent=sale时，请求变为：

GET /search/results/?sale_rent=sale

3. 空条件返回全部房产 #

视图初始查询为Property.objects.all()，当无有效参数时，自然返回全部房产列表，无需额外判断。

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