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

class RentersInsuranceModel(BaseInsuranceModel, table=True):
    __tablename__ = "renters_insurance"
    
    # Property Information
    property_address: str = Field(description="Full street address including unit/apartment number")
    city: str = Field(description="City (must match USPS standards)")
    state: str = Field(description="US state")
    zip_code: str = Field(description="Valid 5-digit ZIP code")
    property_type: str = Field(description="Property type")
    year_built: Optional[int] = Field(default=None, description="Year property was built (YYYY)")
    number_of_units_in_building: Optional[int] = Field(default=None, description="Number of units in building")
    
    # Personal Information (Encrypted)
    first_name: str = Field(description="Legal first name")
    last_name: str = Field(description="Legal last name")
    date_of_birth: date = Field(description="Date of birth for underwriting")
    email_address: str = Field(description="Email address for communication")
    phone_number: Optional[str] = Field(default=None, description="Phone number for contact")
    occupation: Optional[str] = Field(default=None, description="Occupation for rating adjustments")
    marital_status: Optional[str] = Field(default=None, description="Marital status")
    number_of_occupants: Optional[int] = Field(default=None, description="Number of occupants including children")
    
    # Coverage Information
    personal_property_coverage: float = Field(description="Amount of personal property coverage")
    liability_coverage: float = Field(description="Personal liability coverage amount")
    medical_payments_coverage: Optional[float] = Field(default=None, description="Covers guest medical expenses")
    deductible: float = Field(description="Amount insured pays before coverage kicks in")
    loss_of_use_coverage: Optional[float] = Field(default=None, description="Temporary housing coverage")
    replacement_cost_coverage: Optional[bool] = Field(default=None, description="Replacement cost vs actual cash value")
    scheduled_personal_property: Optional[str] = Field(sa_column=Column(JSON), default=None, description="List of high-value items as JSON")
    
    # Policy Details
    policy_term: str = Field(description="Policy term duration")
    preferred_start_date: date = Field(description="Desired policy effective date")
    payment_plan: Optional[str] = Field(default=None, description="Payment frequency")
    payment_method: Optional[str] = Field(default=None, description="Payment method")
    auto_pay_enrollment: Optional[bool] = Field(default=None, description="Auto pay enrollment for discounts")
    
    # Safety Features
    security_system_present: Optional[bool] = Field(default=None, description="Burglar/fire alarm present")
    sprinkler_system: Optional[bool] = Field(default=None, description="Fire suppression system")
    smoke_detectors: Optional[bool] = Field(default=None, description="Smoke detectors present")
    
    # Insurance History
    claims_in_past_5_years: Optional[int] = Field(default=None, description="Count of prior insurance claims")
    prior_carrier: Optional[str] = Field(default=None, description="Previous insurance company")
    prior_policy_expiration_date: Optional[date] = Field(default=None, description="Previous policy expiration")
    
    # Additional Information
    pet_ownership: Optional[bool] = Field(default=None, description="Dogs or cats ownership")
    dog_breed: Optional[str] = Field(default=None, description="Dog breed if pet ownership is true")
    roommates_present: Optional[bool] = Field(default=None, description="Roommates present")
    landlord_information: Optional[str] = Field(default=None, description="Landlord information for proof of coverage")
    additional_insured: Optional[str] = Field(default=None, description="Landlord or property management company")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")
    lead_source: Optional[str] = Field(default=None, max_length=100, description="Source of the lead")

    def get_encrypted_fields(self) -> List[str]:
        return [
            "first_name", "last_name", "email_address", "phone_number",
            "landlord_information", "additional_insured"
        ]

    def get_searchable_fields(self) -> List[str]:
        return ["first_name", "last_name", "email_address", "state", "city"]