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 GroupHealthModel(SQLModel, table=True):
    __tablename__ = "group_health_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(min_length=2, max_length=500)
    industry_sic_code: str = Field(max_length=50)
    company_address: str = Field(max_length=1000)
    city: str = Field(max_length=200)
    state: str = Field(max_length=10)
    zip_code: str = Field(max_length=50)
    federal_tax_id: Optional[str] = Field(default=None, max_length=50)
    
    # Employee Information
    number_of_employees: int = Field(ge=1)
    number_of_employees_to_be_covered: int = Field(ge=1)
    average_age_of_employees: Optional[float] = Field(default=None, ge=18, le=100)
    employee_census_file_path: Optional[str] = Field(default=None, max_length=500)
    
    # Coverage Information
    type_of_coverage_requested: str = Field(max_length=500)
    desired_coverage_start_date: date
    
    # Current Insurance
    current_insurance_carrier: Optional[str] = Field(default=None, max_length=255)
    current_plan_type: Optional[str] = Field(default=None, max_length=50)
    monthly_premium_current_plan: Optional[Decimal] = Field(default=None)
    
    # Plan Configuration
    contribution_strategy: Optional[str] = Field(default=None, max_length=50)
    waiting_period_new_employees: Optional[str] = Field(default=None, max_length=20)
    
    # Broker Information
    broker_agent_involved: bool
    broker_agent_name: Optional[str] = Field(default=None, max_length=255)
    
    # Contact Information (encrypted fields have larger max_length)
    contact_person_name: str = Field(max_length=500)
    contact_email: str = Field(max_length=500)
    contact_phone: str = Field(max_length=100)
    preferred_contact_method: Optional[str] = Field(default=None, max_length=20)
    notes_special_requirements: Optional[str] = Field(default=None, max_length=2000)
    
    # 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.company_address = encryption_service.encrypt_field(self.company_address)
        self.contact_person_name = encryption_service.encrypt_field(self.contact_person_name)
        self.contact_email = encryption_service.encrypt_field(self.contact_email)
        self.contact_phone = encryption_service.encrypt_field(self.contact_phone)
        if self.federal_tax_id:
            self.federal_tax_id = encryption_service.encrypt_field(self.federal_tax_id)
    
    def decrypt_sensitive_data(self):
        """Decrypt sensitive fields after loading"""
        self.company_name = encryption_service.decrypt_field(self.company_name)
        self.company_address = encryption_service.decrypt_field(self.company_address)
        self.contact_person_name = encryption_service.decrypt_field(self.contact_person_name)
        self.contact_email = encryption_service.decrypt_field(self.contact_email)
        self.contact_phone = encryption_service.decrypt_field(self.contact_phone)
        if self.federal_tax_id:
            self.federal_tax_id = encryption_service.decrypt_field(self.federal_tax_id)
