from typing import Optional, List
from datetime import date
from sqlmodel import SQLModel, Field, Column, JSON
from sqlalchemy import String, Boolean, Date, Float, Text
from datetime import datetime, timezone, date


class ProfessionalLiability(SQLModel, table=True):
    
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)

    business_name: str = Field(..., max_length=255)
    contact_name: str = Field(..., max_length=100)
    email_address: str = Field(..., max_length=255)
    phone_number: str = Field(..., max_length=20, description="Format: (123) 456-7890")
    business_address: str = Field(..., max_length=255)
    business_type: str = Field(..., description="Type of Business/Profession")
    description_of_services: str = Field(nullable=False)
    number_of_employees: int = Field(..., ge=1)
    years_in_business: int = Field(..., ge=0)
    annual_revenue: float = Field(..., gt=0)

    states_of_operation: List[str] = Field(
        ..., sa_column=Column(JSON), description="Multi-select states"
    )

    current_insurance_carrier: Optional[str] = Field(default=None, max_length=255)
    current_policy_expiration: Optional[date] = Field(default=None)
    requested_coverage_limit: float = Field(..., gt=0)
    requested_deductible: Optional[float] = Field(default=None, ge=0)
    coverage_basis: str = Field(..., description="Claims-Made or Occurrence")
    retroactive_needed: Optional[bool] = None
    retroactive_date: Optional[date] = None

    prior_claims: bool
    prior_claims_details: Optional[str] = Field(default=None, sa_column=Column(Text))

    subcontracted_services: bool
    subcontracted_percentage: Optional[float] = Field(default=None, ge=0, le=100)

    coverage_for_contractors: Optional[bool] = None
    contracts_reviewed_legal: Optional[bool] = None
    professional_licenses: Optional[str] = Field(default=None, sa_column=Column(Text))

    desired_policy_start: date
    additional_insured: Optional[str] = Field(default=None, sa_column=Column(Text))
    special_coverage_needs: Optional[str] = Field(default=None, sa_column=Column(Text))
    quote_status: str = Field(default="Draft", max_length=20, description="Quote status")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")

    created_at: datetime = Field(default_factory=lambda: datetime.now(timezone.utc))
    updated_at: Optional[datetime] = None
