from sqlmodel import SQLModel, Field, Column, JSON
from typing import Optional, List, Dict, Any
from datetime import date, datetime
from app.core.base_model import BaseInsuranceModel

class BusinessOwnerPolicyModel(BaseInsuranceModel, table=True):
    __tablename__ = "business_owner_policies"
    

    
    # Business Information (Encrypted)
    business_name: str = Field(description="Business name")
    contact_name: str = Field(description="Contact person name")
    email_address: str = Field(description="Email address")
    phone_number: str = Field(description="Phone number in format (123) 456-7890")
    business_address: str = Field(description="Business address")
    
    # Business Details
    type_of_business: str = Field(description="Type of business/industry")
    business_entity_type: Optional[str] = Field(default=None, description="Business entity type")
    years_in_business: int = Field(ge=0, description="Years in business")
    annual_revenue: float = Field(gt=0, description="Annual revenue")
    number_of_employees: int = Field(ge=1, description="Number of employees")
    
    # Property Information
    property_owned_or_leased: str = Field(description="Property owned or leased")
    property_addresses: str = Field(sa_column=Column(JSON), description="Property addresses as JSON")
    square_footage: int = Field(gt=0, description="Square footage")
    building_construction_type: str = Field(description="Building construction type")
    year_built: int = Field(description="Year building was built")
    business_personal_property_value: float = Field(gt=0, description="Business personal property value")
    building_value: Optional[float] = Field(default=None, description="Building value if owned")
    
    # Coverage Options
    business_interruption_coverage: Optional[bool] = Field(default=None, description="Business interruption coverage needed")
    cyber_liability_coverage: Optional[bool] = Field(default=None, description="Cyber liability coverage needed")
    hired_non_owned_auto_coverage: Optional[bool] = Field(default=None, description="Hired/non-owned auto coverage needed")
    crime_coverage: Optional[bool] = Field(default=None, description="Crime coverage needed")
    
    # Insurance History
    past_insurance_coverage: Optional[bool] = Field(default=None, description="Past insurance coverage")
    current_carrier: Optional[str] = Field(default=None, description="Current insurance carrier")
    current_policy_expiration_date: Optional[date] = Field(default=None, description="Current policy expiration date")
    
    # Claims History
    prior_claims_last_5_years: bool = Field(description="Any prior claims in last 5 years")
    description_of_past_claims: Optional[str] = Field(default=None, description="Description of past claims")
    
    # Coverage Requirements
    desired_coverage_start_date: date = Field(description="Desired coverage start date")
    desired_property_coverage_limit: float = Field(gt=0, description="Desired property coverage limit")
    desired_general_liability_coverage_limit: float = Field(gt=0, description="Desired general liability coverage limit")
    deductible_preference: Optional[float] = Field(default=None, description="Deductible preference")
    
    # Additional Information
    security_safety_features: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Security and safety features as JSON")
    additional_insured_parties: Optional[str] = Field(default=None, description="Additional insured parties")
    special_coverage_needs: Optional[str] = Field(default=None, description="Special coverage needs or notes")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")
    lead_source: Optional[str] = Field(default=None, description="Where the user heard about us")

    def get_encrypted_fields(self) -> List[str]:
        return [
            "business_name", "contact_name", "email_address", 
            "phone_number", "business_address", "current_carrier",
            "description_of_past_claims", "additional_insured_parties",
            "special_coverage_needs"
        ]

    def get_searchable_fields(self) -> List[str]:
        return ["business_name", "contact_name", "email_address", "type_of_business"]