root
e0a7479c3e
Wahab can now enter historical tickets that keep their true reported date: - Add nullable tickets.reported_at (DateTime) via alembic d5e0f2a1c3b4; backfill existing rows from created_at so nothing shows empty. - TicketCreate.reported_at (optional) is persisted by create_ticket and defaults to now when omitted, so existing create behavior is unchanged. - New-issue form gains a 'Reported Date' date picker (defaults to today, past dates allowed, future blocked) and sends reported_at in the payload. - List and detail pages show 'Reported' next to 'Created' (date-only, labeled) so backdated tickets are obvious; SLA deadline is unchanged and still runs from creation time so backfilling never instantly breaches. - Tests: backdated create persists + is exposed on list/detail; omitted reported_at defaults to now; SLA window unchanged; full datetime round trip.
140 lines
4.2 KiB
Python
140 lines
4.2 KiB
Python
"""Pydantic schemas for ticket CRUD, timeline, photos, and SLA."""
|
|
|
|
from __future__ import annotations
|
|
|
|
from datetime import datetime
|
|
from decimal import Decimal
|
|
|
|
from pydantic import BaseModel
|
|
|
|
|
|
# ── Unit ─────────────────────────────────────────────────────────────
|
|
class UnitOut(BaseModel):
|
|
id: int
|
|
property: str
|
|
apartment_code: str
|
|
building: str | None = None
|
|
floor: int | None = None
|
|
|
|
model_config = {"from_attributes": True}
|
|
|
|
|
|
# ── Category ─────────────────────────────────────────────────────────
|
|
class CategoryOut(BaseModel):
|
|
id: int
|
|
type: str
|
|
name: str
|
|
parent_id: int | None = None
|
|
sla_urgency: str | None = None
|
|
show_in_form: bool = True
|
|
|
|
model_config = {"from_attributes": True}
|
|
|
|
|
|
class CategoryTreeOut(CategoryOut):
|
|
children: list[CategoryTreeOut] = []
|
|
|
|
|
|
# ── Ticket ───────────────────────────────────────────────────────────
|
|
class TicketCreate(BaseModel):
|
|
unit_id: int | None = None
|
|
category_id: int | None = None
|
|
priority: str | None = None # urgent, high, medium, low
|
|
reporter: str | None = None
|
|
reported_via: str | None = None # whatsapp, phone, walk-in, qr, agent
|
|
description: str | None = None
|
|
assigned_to: int | None = None
|
|
customer_name: str | None = None
|
|
phone: str | None = None
|
|
reported_at: datetime | None = None # original report date for backdated/backfilled tickets; defaults to now when omitted
|
|
|
|
|
|
class TicketUpdate(BaseModel):
|
|
status: str | None = None
|
|
unit_id: int | None = None
|
|
category_id: int | None = None
|
|
priority: str | None = None
|
|
reporter: str | None = None
|
|
phone: str | None = None
|
|
reported_via: str | None = None
|
|
description: str | None = None
|
|
assigned_to: int | None = None
|
|
eta: datetime | None = None
|
|
cost: Decimal | None = None
|
|
parts_used: str | None = None
|
|
note: str | None = None
|
|
|
|
|
|
class TicketTimelineOut(BaseModel):
|
|
id: int
|
|
ticket_id: int
|
|
from_status: str | None = None
|
|
to_status: str | None = None
|
|
note: str | None = None
|
|
user_id: int | None = None
|
|
created_at: datetime
|
|
|
|
model_config = {"from_attributes": True}
|
|
|
|
|
|
class TicketPhotoOut(BaseModel):
|
|
id: int
|
|
ticket_id: int
|
|
photo_url: str
|
|
is_before: bool
|
|
|
|
model_config = {"from_attributes": True}
|
|
|
|
|
|
class TicketBrief(BaseModel):
|
|
"""Summary view for list endpoints."""
|
|
id: int
|
|
ticket_number: str
|
|
status: str
|
|
priority: str | None = None
|
|
unit_id: int | None = None
|
|
category_id: int | None = None
|
|
assigned_to: int | None = None
|
|
assigned_technician_name: str | None = None
|
|
reporter: str | None = None
|
|
phone: str | None = None
|
|
description: str | None = None
|
|
sla_deadline: datetime | None = None
|
|
reopen_count: int = 0
|
|
reported_at: datetime | None = None
|
|
created_at: datetime
|
|
updated_at: datetime
|
|
|
|
model_config = {"from_attributes": True}
|
|
|
|
|
|
class TicketOut(TicketBrief):
|
|
"""Full ticket detail with relations."""
|
|
closed_at: datetime | None = None
|
|
eta: datetime | None = None
|
|
cost: Decimal | None = None
|
|
parts_used: str | None = None
|
|
customer_rating: int | None = None
|
|
timeline: list[TicketTimelineOut] = []
|
|
photos: list[TicketPhotoOut] = []
|
|
unit: UnitOut | None = None
|
|
category: CategoryOut | None = None
|
|
sla_status: dict | None = None
|
|
|
|
|
|
class TicketListResponse(BaseModel):
|
|
items: list[TicketBrief]
|
|
total: int
|
|
page: int
|
|
page_size: int
|
|
|
|
|
|
# ── SLA ──────────────────────────────────────────────────────────────
|
|
class SLAStatusOut(BaseModel):
|
|
priority: str | None = None
|
|
response_deadline: str | None = None
|
|
resolution_deadline: str | None = None
|
|
response_breached: bool = False
|
|
resolution_breached: bool = False
|
|
current_status: str | None = None
|