Search & Filters

# Filter user's jerseys only
items = BaseItem.objects.filter(
    user=user,
    item_type="jersey"
)

# Get all Real Madrid items
items = item_service.get_items_by_club(user).filter(
    club__name__icontains="Real Madrid"
)

# Get items ordered by season
items = item_service.get_items_by_season(user)

# Find all Nike items
items = items.filter(brand__name="Nike")

# Find mint condition items (9-10 rating)
items = items.filter(condition__gte=9)

# Find BNWT items
items = items.filter(detailed_condition="BNWT")

# Public items only
public_items = BaseItem.objects.public()

# Private items only
private_items = BaseItem.objects.private()

# Draft items only
drafts = BaseItem.objects.drafts()

class ItemService:
    def search_items_advanced(
        self,
        query: str,
        user: User = None,
        filters: dict[str, Any] | None = None,
    ) -> QuerySet[Jersey]:
        # Start with user's items or public items
        items = (
            self.item_repository.get_user_items(user) 
            if user 
            else self.item_repository.get_public_items()
        )
        
        # Apply text search
        if query:
            items = self.item_repository.search_items(query, user)
        
        # Apply additional filters
        if filters:
            items = self._apply_filters(items, filters)
        
        return items

filters = {
    "brand": "Nike",
    "club": "Barcelona",
    "condition": 10,
    "is_draft": False,
    "is_private": False,
}

results = item_service.search_items_advanced(
    query="Messi",
    user=request.user,
    filters=filters
)

class Meta:
    indexes = [
        models.Index(fields=["user"]),
        models.Index(fields=["item_type"]),
        models.Index(fields=["club"]),
        models.Index(fields=["brand"]),
        models.Index(fields=["created_at"]),
        # Composite indexes for common query patterns
        models.Index(
            fields=["user", "item_type"], 
            name="baseitem_user_item_type_idx"
        ),
        models.Index(
            fields=["user", "is_private", "is_draft"],
            name="baseitem_user_visibility_idx"
        ),
        models.Index(
            fields=["user", "created_at"],
            name="baseitem_user_created_idx"
        ),
        models.Index(
            fields=["club", "season"],
            name="baseitem_club_season_idx"
        ),
    ]

class BaseItemManager(models.Manager):
    def public(self):
        return self.filter(is_private=False, is_draft=False)
    
    def private(self):
        return self.filter(is_private=True)
    
    def drafts(self):
        return self.filter(is_draft=True)

# Usage:
BaseItem.objects.public()  # All public items
BaseItem.objects.private()  # All private items
BaseItem.objects.drafts()  # All drafts

class MTIManager(models.Manager):
    def public(self):
        return self.filter(
            base_item__is_private=False,
            base_item__is_draft=False
        )
    
    def private(self):
        return self.filter(base_item__is_private=True)
    
    def drafts(self):
        return self.filter(base_item__is_draft=True)

# Usage:
Jersey.objects.public()  # All public jerseys
Shorts.objects.private()  # All private shorts

# Add tags to items
item.tags.add("match-worn", "signed", "rare")

# Search by tag
items = BaseItem.objects.filter(tags__name__in=["signed"])

# Find items with multiple tags
items = BaseItem.objects.filter(
    tags__name="signed"
).filter(
    tags__name="rare"
)

items = items.order_by("-created_at")  # Newest first

items = items.order_by("club__name", "-created_at")

items = items.order_by("season__year", "-created_at")

items = items.order_by("-condition")  # Best condition first

items = items.order_by("brand__name", "-created_at")

summary = item_service.get_user_collection_summary(user)

# Returns:
{
    "total_items": 150,
    "by_type": {
        "jersey": 120,
        "shorts": 15,
        "outerwear": 10,
        "tracksuit": 5
    },
    "by_condition": {
        10: 30,  # Mint condition
        9: 45,
        8: 50,
        7: 25
    },
    "by_brand": {
        "Nike": 60,
        "Adidas": 50,
        "Puma": 30,
        "Umbro": 10
    },
    "by_club": {
        "Real Madrid": 20,
        "Barcelona": 18,
        "Manchester United": 15
    },
    "recent_items": [<QuerySet>]
}

# Fetch items with related data in a single query
items = BaseItem.objects.select_related(
    "club",
    "brand",
    "season"
).prefetch_related(
    "competitions",
    "tags",
    "photos"
).filter(user=user)

from django.core.paginator import Paginator

paginator = Paginator(items, 20)  # 20 items per page
page_obj = paginator.get_page(page_number)