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 AnnuityInsuranceModel(BaseInsuranceModel, table=True):
    __tablename__ = "annuity_insurance"
    
    # Personal Information (Encrypted)
    first_name: str = Field(description="Applicant's first name")
    last_name: str = Field(description="Applicant's last name")
    date_of_birth: date = Field(description="Date of birth")
    gender: str = Field(description="Gender")
    marital_status: Optional[str] = Field(default=None, description="Marital status")
    citizenship_status: str = Field(description="Citizenship status")
    
    # Contact Information
    email: str = Field(description="Email address")
    phone_number: str = Field(description="Phone number")
    address: str = Field(description="Residential address")
    city: str = Field(description="City")
    state: str = Field(description="State")
    zip_code: str = Field(description="ZIP code")
    
    # Financial Profile
    annual_income: Optional[float] = Field(default=None, description="Annual income")
    net_worth: Optional[float] = Field(default=None, description="Net worth")
    liquid_assets: Optional[float] = Field(default=None, description="Liquid assets")
    investment_objective: Optional[str] = Field(default=None, description="Investment objective")
    risk_tolerance: Optional[str] = Field(default=None, description="Risk tolerance")
    
    # Annuity Purchase
    initial_investment: float = Field(description="Initial investment amount")
    payment_frequency: str = Field(description="Payment frequency")
    purchase_type: str = Field(description="Purchase type")
    source_of_funds: str = Field(description="Source of funds")
    premium_mode: str = Field(description="Premium mode")
    
    # Contract Options
    payout_start_age: Optional[int] = Field(default=None, description="Payout start age")
    accumulation_period: Optional[int] = Field(default=None, description="Accumulation period")
    payout_option: str = Field(description="Payout option")
    beneficiary_type: Optional[str] = Field(default=None, description="Beneficiary type")
    death_benefit_option: Optional[str] = Field(default=None, description="Death benefit option")
    index_strategy: Optional[str] = Field(default=None, description="Index strategy")
    guaranteed_income_rider: Optional[bool] = Field(default=None, description="Guaranteed income rider")
    enhanced_withdrawal_benefit: Optional[bool] = Field(default=None, description="Enhanced withdrawal benefit")
    
    # Suitability / Disclosure
    replacement_existing_annuity: Optional[bool] = Field(default=None, description="Replacing existing annuity")
    existing_annuity_company: Optional[str] = Field(default=None, description="Existing annuity company")
    replacement_value: Optional[float] = Field(default=None, description="Replacement value")
    financial_objective_statement: Optional[str] = Field(default=None, description="Financial objective statement")
    
    # Digital Acknowledgments
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")
    e_sign_consent: bool = Field(description="E-signature consent")
    data_sharing_consent: bool = Field(description="Data sharing consent")
    privacy_notice_acknowledged: bool = Field(description="Privacy notice acknowledged")
    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", "phone_number", "address"
        ]

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