from sqlmodel import SQLModel, Field, Column, JSON
from typing import Optional, List, Dict, Any
from datetime import date, datetime
from app.core.base_model import BaseInsuranceModel

class AgricultureInsuranceModel(BaseInsuranceModel, table=True):
    __tablename__ = "agriculture_insurance"
    
    # Basic Applicant Information (Encrypted)
    full_name: str = Field(description="Full legal name")
    entity_type: str = Field(description="Legal structure of farm")
    email_address: str = Field(description="Email address")
    phone_number: str = Field(description="Phone number")
    state: str = Field(description="State where farm is located")
    county: str = Field(description="County where farm is located")
    zip_code: str = Field(description="ZIP code")
    
    # Farm Details
    farm_name: Optional[str] = Field(default=None, description="Name of registered farm")
    total_acres_owned: int = Field(ge=0, description="Acres legally owned")
    total_acres_leased: Optional[int] = Field(default=None, ge=0, description="Rented or leased land")
    farm_type: str = Field(sa_column=Column(JSON), description="Types of farming as JSON")
    annual_revenue: Optional[float] = Field(default=None, ge=0, description="Total farm revenue")
    
    # Crop Insurance Details
    crop_type: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Types of crops as JSON")
    planted_acres: Optional[int] = Field(default=None, ge=0, description="Acres planted")
    expected_yield_per_acre: Optional[float] = Field(default=None, ge=0, description="Expected yield per acre")
    coverage_level: Optional[str] = Field(default=None, description="Coverage percentage")
    insurance_plan: Optional[str] = Field(default=None, description="Type of crop insurance")
    irrigation_used: Optional[bool] = Field(default=None, description="Using irrigation")
    gps_field_map_uploaded: Optional[bool] = Field(default=None, description="GPS field map uploaded")
    gps_field_map_path: Optional[str] = Field(default=None, max_length=500, description="Stored path of GPS field map file")
    
    # Livestock Insurance Details
    animal_type: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Livestock types as JSON")
    number_of_head: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Number of animals by type as JSON")
    average_weight_per_head: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Average weight by type as JSON")
    livestock_value_per_head: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Value per animal by type as JSON")
    coverage_type: Optional[str] = Field(default=None, description="Livestock insurance program")
    animal_housing: Optional[str] = Field(default=None, description="Housing system")
    vet_records_uploaded: Optional[bool] = Field(default=None, description="Vet records uploaded")
    vet_records_path: Optional[str] = Field(default=None, max_length=500, description="Stored path of vet records file")
    
    # Farm Asset Coverage
    barns_sheds_count: Optional[int] = Field(default=None, ge=0, description="Number of farm structures")
    equipment_value: Optional[float] = Field(default=None, ge=0, description="Value of equipment")
    storage_units: Optional[int] = Field(default=None, ge=0, description="Number of storage units")
    liability_coverage_needed: Optional[bool] = Field(default=None, description="Liability coverage needed")
    business_interruption_insurance: Optional[bool] = Field(default=None, description="Business interruption needed")
    perils_to_cover: str = Field(sa_column=Column(JSON), description="Selected perils as JSON")
    
    # Claims History
    previous_insurance_carrier: Optional[str] = Field(default=None, description="Previous carrier")
    total_number_of_claims: Optional[int] = Field(default=None, ge=0, description="Number of claims in last 5 years")
    type_of_loss: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Types of losses as JSON")
    year_of_most_recent_claim: Optional[int] = Field(default=None, description="Year of most recent claim")
    
    # Quote Delivery Options
    preferred_contact_method: str = Field(description="Preferred contact method")
    best_time_to_reach: Optional[str] = Field(default=None, description="Best time to contact")
    agent_assistance_needed: Optional[bool] = Field(default=None, description="Agent assistance needed")
    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", "farm_name",
            "previous_insurance_carrier"
        ]

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