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

class GroupLifeModel(SQLModel, table=True):
    __tablename__ = "group_life_quotes"
    
    # Primary Key
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)
    
    # Company Information (encrypted fields have larger max_length)
    company_name: str = Field(max_length=500)
    industry_type: str = Field(max_length=100)
    federal_tax_id: str = Field(max_length=255)
    company_address: str = Field(max_length=1000)
    
    # Contact Information (encrypted)
    contact_name: str = Field(max_length=500)
    contact_email: str = Field(max_length=500)
    contact_phone: str = Field(max_length=100)
    
    # Group Information
    type_of_group: str = Field(max_length=50)
    number_of_eligible_employees: int = Field(ge=2)
    number_of_employees_to_be_insured: int = Field(ge=1)
    employee_locations: str = Field(max_length=1000)  # Comma-separated
    
    # Coverage Information
    coverage_type_requested: str = Field(max_length=500)  # Comma-separated
    requested_effective_date: date
    
    # Current Insurance
    current_group_life_carrier: Optional[str] = Field(default=None, max_length=255)
    current_monthly_premium: Optional[Decimal] = Field(default=None)
    current_benefit_design: Optional[str] = Field(default=None, max_length=1000)
    desired_benefit_design: Optional[str] = Field(default=None, max_length=1000)
    
    # Plan Configuration
    employer_contribution_percentage: Optional[float] = Field(default=None, ge=0, le=100)
    waiting_period_eligibility: str = Field(max_length=255)
    class_structure: Optional[str] = Field(default=None, max_length=1000)
    union_non_union_mix: Optional[str] = Field(default=None, max_length=20)
    renewal_month: Optional[str] = Field(default=None, max_length=20)
    
    # Additional Information
    broker_consultant_name: Optional[str] = Field(default=None, max_length=255)
    additional_notes: Optional[str] = Field(default=None, max_length=1000)
    employee_census_file_path: Optional[str] = Field(default=None, max_length=500)
    
    # System Fields
    quote_status: str = Field(default="pending", max_length=50)
    premium_amount: Optional[Decimal] = Field(default=None)
    created_at: datetime = Field(default_factory=lambda: datetime.now(timezone.utc))
    updated_at: Optional[datetime] = Field(default=None)
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")
    
    def encrypt_sensitive_data(self):
        """Encrypt sensitive fields before saving"""
        self.company_name = encryption_service.encrypt_field(self.company_name)
        self.federal_tax_id = encryption_service.encrypt_field(self.federal_tax_id)
        self.company_address = encryption_service.encrypt_field(self.company_address)
        self.contact_name = encryption_service.encrypt_field(self.contact_name)
        self.contact_email = encryption_service.encrypt_field(self.contact_email)
        self.contact_phone = encryption_service.encrypt_field(self.contact_phone)
    
    def decrypt_sensitive_data(self):
        """Decrypt sensitive fields after loading"""
        self.company_name = encryption_service.decrypt_field(self.company_name)
        self.federal_tax_id = encryption_service.decrypt_field(self.federal_tax_id)
        self.company_address = encryption_service.decrypt_field(self.company_address)
        self.contact_name = encryption_service.decrypt_field(self.contact_name)
        self.contact_email = encryption_service.decrypt_field(self.contact_email)
        self.contact_phone = encryption_service.decrypt_field(self.contact_phone)
