from sqlmodel import SQLModel, Field
from typing import Optional, List
from datetime import datetime, timezone, date
from sqlmodel import SQLModel, Field, Column, JSON
from sqlalchemy import Column, Integer, String, Boolean, Date, Numeric, Text

class GroupLife(SQLModel, table=True):

    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)

    company_name: str = Field(nullable=False, max_length=100, index=True)
    industry_type: str = Field(nullable=False, max_length=100)
    federal_tax_id: str = Field(nullable=False, max_length=9, index=True)  # EIN

    company_address: str = Field(nullable=False, max_length=255)

    contact_name: str = Field(nullable=False, max_length=100)
    contact_email: str = Field(nullable=False, index=True)
    contact_phone: str = Field(nullable=False, max_length=20)

    group_type: str = Field(nullable=False, max_length=50)  # LLC, Corporation, etc.

    eligible_employees: int = Field(nullable=False, ge=2)
    insured_employees: int = Field(nullable=False, ge=1)

    employee_locations: List[str] = Field(
        sa_column=Column(JSON, nullable=False)
    )
    coverage_types: List[str] = Field(
        sa_column=Column(JSON, nullable=False)
    )

    effective_date: date = Field(nullable=False)

    current_carrier: Optional[str] = Field(default=None, max_length=100)
    current_premium: Optional[float] = Field(default=None, ge=0)
    current_benefit_design: Optional[str] = None
    desired_benefit_design: Optional[str] = None

    employer_contribution: Optional[float] = Field(default=None, ge=0, le=100)
    waiting_period: str = Field(nullable=False, max_length=50)

    class_structure: Optional[str] = None
    union_mix: Optional[str] = Field(default=None, max_length=50)
    renewal_month: Optional[str] = Field(default=None, max_length=20)
    broker_name: Optional[str] = Field(default=None, max_length=100)
    notes: Optional[str] = Field(default=None, max_length=1000)

    census_file_path: str = Field(nullable=False, max_length=255)  # uploaded CSV/XLSX
    quote_status: str = Field(default="Draft", max_length=20, description="Quote status")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")

    created_at: datetime = Field(default_factory=lambda: datetime.now(timezone.utc))
    updated_at: Optional[datetime] = None
