Files
Shubhankar45 53dbfa976b -
2026-11-13 12:14:55 +00:00

64 lines
2.5 KiB
Python

from decimal import Decimal
from typing import TYPE_CHECKING
from sqlalchemy import CheckConstraint, ForeignKey, Index, Numeric, String, Text
from sqlalchemy.orm import Mapped, mapped_column, relationship
from app.models.base import Base, TimestampMixin
from app.models.enums import EnquiryStatus, PropertyType, db_enum
if TYPE_CHECKING:
from app.models.admin import Admin
class Enquiry(TimestampMixin, Base):
__tablename__ = "enquiries"
__table_args__ = (
CheckConstraint("monthly_bill IS NULL OR monthly_bill >= 0", name="monthly_bill_non_negative"),
CheckConstraint(
"required_capacity_kw IS NULL OR required_capacity_kw > 0", name="capacity_positive"
),
Index("ix_enquiries_status_created_at", "status", "created_at"),
)
id: Mapped[int] = mapped_column(primary_key=True)
name: Mapped[str] = mapped_column(String(150))
phone: Mapped[str | None] = mapped_column(String(20), index=True) # null for calculator leads
email: Mapped[str | None] = mapped_column(String(255), index=True)
city: Mapped[str | None] = mapped_column(String(120))
address: Mapped[str | None] = mapped_column(String(500))
property_type: Mapped[PropertyType | None] = mapped_column(db_enum(PropertyType, "property_type"))
monthly_bill: Mapped[Decimal | None] = mapped_column(Numeric(12, 2))
required_capacity_kw: Mapped[Decimal | None] = mapped_column(Numeric(10, 2))
message: Mapped[str | None] = mapped_column(Text)
source: Mapped[str] = mapped_column(String(50), default="website", server_default="website")
status: Mapped[EnquiryStatus] = mapped_column(
db_enum(EnquiryStatus, "enquiry_status"),
default=EnquiryStatus.NEW,
server_default=EnquiryStatus.NEW.value,
)
notes: Mapped[list["EnquiryNote"]] = relationship(
back_populates="enquiry",
cascade="all, delete-orphan",
passive_deletes=True,
order_by="EnquiryNote.created_at.desc()",
)
class EnquiryNote(TimestampMixin, Base):
"""Internal notes added by admins; never exposed publicly."""
__tablename__ = "enquiry_notes"
id: Mapped[int] = mapped_column(primary_key=True)
enquiry_id: Mapped[int] = mapped_column(
ForeignKey("enquiries.id", ondelete="CASCADE"), index=True
)
author_id: Mapped[int | None] = mapped_column(ForeignKey("admins.id", ondelete="SET NULL"))
content: Mapped[str] = mapped_column(Text)
enquiry: Mapped[Enquiry] = relationship(back_populates="notes")
author: Mapped["Admin | None"] = relationship("Admin", lazy="joined")