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 LifeInsuranceModel(BaseInsuranceModel, table=True):
    __tablename__ = "life_insurance"
    
    # Personal Information (Encrypted)
    full_name: str = Field(description="Full legal name")
    date_of_birth: date = Field(description="Date of birth")
    gender: str = Field(description="Gender")
    email_address: str = Field(description="Email address")
    phone_number: str = Field(description="Phone number")
    state: str = Field(description="State of residence")
    zip_code: str = Field(description="ZIP code")
    
    # Personal Details
    marital_status: Optional[str] = Field(default=None, description="Marital status")
    ssn_last4: Optional[str] = Field(default=None, description="Last 4 digits of SSN")
    address_line1: str = Field(description="Primary address")
    address_line2: Optional[str] = Field(default=None, description="Secondary address")
    city: str = Field(description="City")
    
    # Employment & Financial
    employment_status: str = Field(description="Employment status")
    occupation: Optional[str] = Field(default=None, description="Occupation")
    annual_income: Optional[float] = Field(default=None, description="Annual income")
    
    # Health Information
    height: str = Field(description="Height")
    weight: float = Field(description="Weight in pounds")
    tobacco_use: bool = Field(description="Tobacco use")
    alcohol_consumption: Optional[str] = Field(default=None, description="Alcohol consumption level")
    existing_conditions: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Existing medical conditions as JSON")
    medications: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Current medications as JSON")
    family_history: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Family medical history as JSON")
    
    # Policy Details
    coverage_amount: float = Field(description="Coverage amount")
    coverage_term: str = Field(description="Coverage term")
    product_type: str = Field(description="Product type")
    premium_budget: Optional[float] = Field(default=None, description="Premium budget")
    payment_frequency: Optional[str] = Field(default=None, description="Payment frequency")
    riders: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Policy riders as JSON")
    
    # Beneficiaries
    primary_beneficiary_name: str = Field(description="Primary beneficiary name")
    primary_beneficiary_relationship: str = Field(description="Primary beneficiary relationship")
    beneficiary_percentage: float = Field(description="Beneficiary percentage")
    contingent_beneficiary_name: Optional[str] = Field(default=None, description="Contingent beneficiary name")
    contingent_beneficiary_relationship: Optional[str] = Field(default=None, description="Contingent beneficiary relationship")
    
    # Citizenship & Legal
    citizenship_status: str = Field(description="Citizenship status")
    country_of_citizenship: Optional[str] = Field(default=None, description="Country of citizenship")
    us_citizen: bool = Field(description="US citizen status")
    criminal_record: Optional[bool] = Field(default=None, description="Criminal record")
    bankruptcy_history: Optional[bool] = Field(default=None, description="Bankruptcy history")
    
    # Consent & Signature
    consent_to_contact: bool = Field(description="Consent to contact")
    consent_to_share_data: bool = Field(description="Consent to share data")
    signature: str = Field(description="Digital signature")
    lead_source: Optional[str] = Field(default=None, description="Where did you hear about us?")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")

    def get_encrypted_fields(self) -> List[str]:
        return [
            "full_name", "email_address", "phone_number", "ssn_last4",
            "primary_beneficiary_name", "contingent_beneficiary_name", "signature"
        ]

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