Django Q objects for complex queries

                  from django.db.models import Q
from django.views.generic import ListView
from .models import Product


class ProductSearchView(ListView):
    model = Product
    template_name = 'products/search.html'
    context_object_name = 'products'

    def get_queryset(self):
        query = self.request.GET.get('q', '')

        if not query:
            return Product.objects.none()

        # Search in multiple fields with OR
        search_query = Q(name__icontains=query) | \
                       Q(description__icontains=query) | \
                       Q(category__name__icontains=query)

        # Filter active products only
        active_query = Q(is_active=True)

        # Combine with AND
        return Product.objects.filter(search_query & active_query).distinct()


def filter_products(request):
    """Dynamic filtering based on request params."""
    filters = Q()

    # Add filters conditionally
    if min_price := request.GET.get('min_price'):
        filters &= Q(price__gte=min_price)

    if max_price := request.GET.get('max_price'):
        filters &= Q(price__lte=max_price)

    if category := request.GET.get('category'):
        filters &= Q(category__slug=category)

    # Exclude out of stock
    filters &= ~Q(stock=0)

    return Product.objects.filter(filters)