from sqlmodel import SQLModel, Field
from typing import Optional
from datetime import datetime, date, timezone
from decimal import Decimal
from app.services.encryption_service import encryption_service
from app.core.base_model import BaseInsuranceModel

class WorkersCompensationModel(BaseInsuranceModel, table=True):
    __tablename__ = "workers_compensation_quotes"
    
    # Business Information (encrypted fields have larger max_length)
    business_name: str = Field(max_length=500)
    contact_name: str = Field(max_length=500)
    email_address: str = Field(max_length=500)
    phone_number: str = Field(max_length=100)
    business_address: str = Field(max_length=1000)
    type_of_business: str = Field(max_length=255)
    business_entity_type: Optional[str] = Field(default=None, max_length=100)
    years_in_business: int = Field(ge=0)
    fein: str = Field(max_length=50)  # Encrypted
    
    # Employee Information
    number_of_employees: int = Field(ge=1)
    employee_job_classifications: str = Field(max_length=2000)  # JSON string
    annual_payroll_by_classification: str = Field(max_length=2000)  # JSON string
    states_of_operation: str = Field(max_length=500)  # Comma-separated
    
    # Contractor Information
    independent_contractors: bool
    number_of_contractors: Optional[int] = Field(default=None, ge=0)
    coverage_for_1099s: Optional[bool] = Field(default=None)
    temp_seasonal_volunteer_workers: Optional[bool] = Field(default=None)
    
    # Coverage History
    prior_policy: Optional[bool] = Field(default=None)
    prior_insurance_carrier: Optional[str] = Field(default=None, max_length=255)
    current_policy_expiration_date: Optional[date] = Field(default=None)
    
    # Claims History
    past_workers_comp_claims: bool
    description_of_prior_claims: Optional[str] = Field(default=None, max_length=2000)
    osha_violations_past_3_years: Optional[bool] = Field(default=None)
    safety_program_in_place: Optional[bool] = Field(default=None)
    
    # Policy Information
    desired_effective_date: date
    additional_notes: Optional[str] = Field(default=None, max_length=2000)
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")
    
    def encrypt_sensitive_data(self):
        """Encrypt sensitive fields before saving"""
        self.business_name = encryption_service.encrypt_field(self.business_name)
        self.contact_name = encryption_service.encrypt_field(self.contact_name)
        self.email_address = encryption_service.encrypt_field(self.email_address)
        self.phone_number = encryption_service.encrypt_field(self.phone_number)
        self.business_address = encryption_service.encrypt_field(self.business_address)
        self.fein = encryption_service.encrypt_field(self.fein)
    
    def decrypt_sensitive_data(self):
        """Decrypt sensitive fields after loading"""
        self.business_name = encryption_service.decrypt_field(self.business_name)
        self.contact_name = encryption_service.decrypt_field(self.contact_name)
        self.email_address = encryption_service.decrypt_field(self.email_address)
        self.phone_number = encryption_service.decrypt_field(self.phone_number)
        self.business_address = encryption_service.decrypt_field(self.business_address)
        self.fein = encryption_service.decrypt_field(self.fein)

    def get_encrypted_fields(self):
        return [
            "business_name", "contact_name", "email_address", "phone_number", "business_address"
        ]

    def get_searchable_fields(self):
        return ["business_name", "contact_name", "email_address", "phone_number", "city"]