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 Unifiedcommercial(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(nullable=False, index=True)
    contact_name: str = Field(nullable=False)
    email_address: str = Field(nullable=False, index=True)
    phone_number: str = Field(nullable=False)
    business_address: str = Field(nullable=False)

    type_of_business: str = Field(nullable=False)
    business_entity_type: Optional[str] = None

    years_in_business: int = Field(nullable=False, ge=0)
    annual_revenue: float = Field(nullable=False, ge=0)
    number_of_employees: int = Field(nullable=False, ge=1)

    currently_insured: Optional[bool] = None
    current_carrier: Optional[str] = None
    policy_expiration_date: Optional[date] = None

    past_claims: bool = Field(nullable=False)
    past_claims_description: Optional[str] = None

    insurance_products_requested: List[str] = Field(sa_column=Column(JSON, nullable=False))
    desired_coverage_start_date: date = Field(nullable=False)
    desired_liability_coverage_limit: Optional[float] = Field(default=None, ge=0)
    desired_property_coverage_limit: Optional[float] = Field(default=None, ge=0)
    desired_deductible: Optional[float] = Field(default=None, ge=0)

    business_description: str = Field(nullable=False)
    locations_of_operation: Optional[List[str]] = Field(sa_column=Column(JSON, nullable=True))
    property_owned_or_leased: Optional[str] = None
    vehicles_owned: Optional[int] = Field(default=None, ge=0)
    number_of_locations: Optional[int] = Field(default=None, ge=0)

    cyber_liability_needed: Optional[bool] = None
    stores_sensitive_customer_data: Optional[bool] = None
    security_features: Optional[List[str]] = Field(sa_column=Column(JSON, nullable=True))

    additional_insured_parties: Optional[str] = None
    special_notes: 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)
