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


class Businessumbrella(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(index=True, nullable=False)
    contact_name: str = Field(nullable=False)
    email_address: str = Field(index=True, nullable=False)
    phone_number: str = Field(nullable=False)  # (123) 456-7890
    business_address: str = Field(nullable=False)
    type_of_business: str = Field(nullable=False)
    business_entity_type: Optional[str] = None
    number_of_employees: int = Field(nullable=False, ge=1)
    years_in_operation: int = Field(nullable=False, ge=0)
    annual_revenue: float = Field(nullable=False, ge=0)
    annual_payroll: Optional[float] = Field(default=None, ge=0)
    total_assets: Optional[float] = Field(default=None, ge=0)
    existing_liability_policies: List[str] = Field(sa_column=Column(JSON, nullable=False))
    total_liability_limits: float = Field(nullable=False, ge=0)
    desired_umbrella_coverage: float = Field(nullable=False, ge=0)
    high_risk_operations: bool = Field(nullable=False)
    high_risk_details: Optional[str] = None
    prior_umbrella_coverage: Optional[bool] = None
    past_liability_claims: bool = Field(nullable=False)
    past_claims_description: Optional[str] = None
    pending_lawsuits: bool = Field(nullable=False)
    locations_of_operations: List[str] = Field(sa_column=Column(JSON, nullable=False))
    vehicles_owned: Optional[int] = Field(default=None, ge=0)
    third_party_contracts: Optional[bool] = None
    desired_policy_start_date: date = Field(nullable=False)
    broker_agent_name: Optional[str] = None
    additional_insured_parties: Optional[str] = None
    special_coverage_needs: Optional[str] = None
    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] = Field(default=None)
