如何在Django中高效整合多条件排序与筛选逻辑？

我正在开发一个支持搜索、排序与筛选功能的站点，目前用if/elif逻辑实现了需求，但代码重复多、修改效率极低——每新增一个筛选器，就得重新梳理所有参数组合的判断逻辑，非常繁琐。作为Django新手，我知道这种实现方式不对，求更优方案。

原核心代码 #

class ResultsView(LoginRequiredMixin, ListView):
    model = Ads
    paginate_by = 9
    template_name = 'library.html'

    #GET SEARCH
    def get_queryset(self):
        query_search = self.request.GET.get('search')
        query_sort = self.request.GET.get('sort_by')
        query_filter = self.request.GET.get('filter_by_language')
        query_search_username = self.request.GET.get('search_username')

        #search=YES, sort=NO, filter=NO
        if query_search and not query_sort and not query_filter:
            object_list = self.model.objects.filter(Q(headline__icontains=query_search) or Q(promoted_url__icontains=query_search))
        
        elif query_search_username: #and not query_sort and not query_filter:
            object_list = self.model.objects.filter(Q(username__iexact=query_search_username))

        #search=YES, sort=NO, filter=YES
        elif query_search and not query_sort and query_filter:
            object_list = self.model.objects.filter(Q(headline__icontains=query_search) or Q(promoted_url__icontains=query_search))
            object_list = object_list.filter(language__iexact=query_filter)

        #search=YES, sort=YES, filter=NO
        elif query_search and query_sort and not query_filter:
            object_list = self.model.objects.filter(Q(headline__icontains=query_search) or Q(promoted_url__icontains=query_search)).order_by(query_sort)
        
        #search=YES, sort=YES, filter=NO
        elif query_search and query_sort and query_filter:
            object_list = self.model.objects.filter(Q(headline__icontains=query_search) or Q(promoted_url__icontains=query_search))
            object_list = object_list.filter(language__iexact=query_filter).order_by(query_sort)

        #search=NO, sort=YES, filter=NO
        elif not query_search and query_sort and not query_filter:
            object_list = self.model.objects.all().order_by(query_sort)

        #search=NO, sort=YES, filter=YES
        elif not query_search and query_sort and query_filter:
            object_list = self.model.objects.filter(language__iexact=query_filter).order_by(query_sort)

        #search=NO, sort=NO, filter=YES
        elif not query_search and not query_sort and query_filter:
            object_list = self.model.objects.filter(language__iexact=query_filter)

        #ELSE
        else:
            object_list = self.model.objects.order_by('?')
        return object_list

优化后的代码 #

from django.db.models import Q

class ResultsView(LoginRequiredMixin, ListView):
    model = Ads
    paginate_by = 9
    template_name = 'library.html'

    def get_queryset(self):
        # 获取所有请求参数
        query_search = self.request.GET.get('search')
        query_sort = self.request.GET.get('sort_by')
        query_filter = self.request.GET.get('filter_by_language')
        query_search_username = self.request.GET.get('search_username')

        # 初始化基础查询集（Django QuerySet是惰性的，不会立即执行SQL）
        queryset = self.model.objects.all()

        # 优先处理用户名搜索（和原逻辑保持一致，优先级高于普通搜索）
        if query_search_username:
            queryset = queryset.filter(Q(username__iexact=query_search_username))
        # 处理普通搜索（修复原代码OR查询的错误写法）
        elif query_search:
            queryset = queryset.filter(Q(headline__icontains=query_search) | Q(promoted_url__icontains=query_search))

        # 处理语言筛选
        if query_filter:
            queryset = queryset.filter(language__iexact=query_filter)

        # 处理排序
        if query_sort:
            queryset = queryset.order_by(query_sort)
        # 无任何参数时随机排序（和原逻辑一致）
        elif not any([query_search, query_search_username, query_filter, query_sort]):
            queryset = queryset.order_by('?')

        return queryset

优化说明 #

• 彻底消除代码重复：通过链式调用QuerySet，将搜索、筛选、排序拆分为独立的判断逻辑，无需枚举所有参数组合
• 扩展性拉满：新增筛选器/搜索条件时，只需添加一段if 参数: queryset = queryset.filter(...)，完全不用修改现有逻辑
• 逻辑清晰易维护：每个功能模块独立，可读性远高于嵌套的if/elif
• 修复潜在bug：原代码用Python的or连接Q对象是错误的，Django中需用|运算符实现OR查询，优化后的代码修正了这个问题
• 性能不受影响：Django QuerySet是惰性查询，只有在最终返回时才会执行SQL，和原代码性能一致

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