"""Business Insurance model for comprehensive business insurance coverage."""
from datetime import datetime
from typing import Optional
from sqlmodel import SQLModel, Field, Column, Text, JSON


class BusinessInsuranceModel(SQLModel, table=True):
    """Model for business insurance with all coverage types."""
    
    __tablename__ = "business_insurance"
    
    # Primary key
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)
    
    # Business Information
    business_name: str = Field(max_length=255)
    est_year: str = Field(max_length=4)
    tax_id: str = Field(sa_column=Column(Text))  # Encrypted: stored as Fernet token, requires Text column
    business_type: str = Field(max_length=50)
    industry: str = Field(max_length=100)
    employees: str = Field(max_length=50)
    annual_revenue: str = Field(max_length=50)
    street: str = Field(max_length=255)
    city: str = Field(max_length=100)
    state: str = Field(max_length=2)
    zip_code: str = Field(max_length=10, alias="zip")
    owner_name: str = Field(max_length=255)
    title: str = Field(max_length=100)
    owner_mobile: str = Field(sa_column=Column(Text))  # Encrypted: stored as Fernet token, requires Text column
    owner_email: str = Field(sa_column=Column(Text))  # Encrypted: stored as Fernet token, requires Text column
    
    # Insurance History
    reason: str = Field(max_length=100)
    has_insurance: str = Field(max_length=10)
    has_claims_5y: str = Field(max_length=10)
    current_provider: Optional[str] = Field(default=None, max_length=255)
    policy_expiry: Optional[str] = Field(default=None, max_length=20)
    
    # Selected Coverages
    coverages: str = Field(sa_column=Column(Text))
    coverage_types: str = Field(sa_column=Column(Text))
    
    # Coverage Data (JSON fields)
    bop_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    auto_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    property_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    cyber_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    gl_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    group_health_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    group_life_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    ocean_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    eando_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    umbrella_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    workers_data: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    
    # Risk Factors
    risk_factors: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    
    # Coverage Preferences
    coverage_preferences: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    
    # Additional Information
    additional_info: Optional[dict] = Field(default=None, sa_column=Column(JSON))
    
    # Consent
    consent_accepted: bool = Field(default=False)
    hipaa_accepted: bool = Field(default=False)
    
    # System fields
    transaction_no: Optional[str] = Field(index=True, default=None, max_length=50)
    quote_status: str = Field(default="Draft", max_length=20)
    created_at: datetime = Field(default_factory=datetime.now)
    updated_at: Optional[datetime] = Field(default=None)
    
    def get_encrypted_fields(self) -> list:
        """Return list of fields that should be encrypted."""
        return ["owner_email", "owner_mobile", "tax_id"]
