from django.core.management.base import BaseCommand
from tickets.models import Ticket

class Command(BaseCommand):
    help = "List all open tickets"

    def handle(self, *args, **kwargs):
        tickets = Ticket.objects.filter(status="open").order_by("created_at")
        if not tickets.exists():
            self.stdout.write("No open tickets.")
            return

        for ticket in tickets:
            self.stdout.write(
                f"#{ticket.id} | Subject: {ticket.subject} | Reporter: {ticket.reporter} | Assignee: {ticket.assignee or 'Unassigned'} | Created: {ticket.created_at.strftime('%Y-%m-%d %H:%M')}"
            )