from typing import List, Optional
from sqlmodel import Session, select
from app.core.base_repository import BaseRepository
from app.models.BusinessOwnerPolicyModel import BusinessOwnerPolicyModel
from app.schemas.BusinessOwnerPolicySchema import BusinessOwnerPolicyCreate, BusinessOwnerPolicyUpdate
from app.utils.transaction_generator import generate_transaction_number
import json

class BusinessOwnerPolicyRepository(BaseRepository[BusinessOwnerPolicyModel, BusinessOwnerPolicyCreate, BusinessOwnerPolicyUpdate]):
    def __init__(self, session: Session):
        super().__init__(BusinessOwnerPolicyModel, session)

    def create(self, obj_in: BusinessOwnerPolicyCreate) -> BusinessOwnerPolicyModel:
        obj_data = obj_in.model_dump()
        obj_data['transaction_no'] = generate_transaction_number('bop')
        
        # Convert lists to JSON strings for storage
        if obj_data.get('property_addresses'):
            obj_data['property_addresses'] = json.dumps(obj_data['property_addresses'])
        if obj_data.get('security_safety_features'):
            obj_data['security_safety_features'] = json.dumps(obj_data['security_safety_features'])
        
        # Encrypt sensitive fields
        obj_data = self._encrypt_fields(obj_data)
        
        db_obj = self.model(**obj_data)
        created_obj = super().create_db_object(db_obj)
        
        # Convert JSON fields back to lists for response
        self._convert_json_fields_to_lists(created_obj)
        return created_obj

    def update(self, db_obj: BusinessOwnerPolicyModel, obj_in: BusinessOwnerPolicyUpdate) -> BusinessOwnerPolicyModel:
        obj_data = obj_in.model_dump(exclude_unset=True)
        
        # Convert lists to JSON strings for storage
        if 'property_addresses' in obj_data and obj_data['property_addresses']:
            obj_data['property_addresses'] = json.dumps(obj_data['property_addresses'])
        if 'security_safety_features' in obj_data and obj_data['security_safety_features']:
            obj_data['security_safety_features'] = json.dumps(obj_data['security_safety_features'])
        
        updated_obj = super().update(db_obj, obj_data)
        
        # Convert JSON fields back to lists for response
        self._convert_json_fields_to_lists(updated_obj)
        return updated_obj

    def get(self, id: int) -> Optional[BusinessOwnerPolicyModel]:
        db_obj = super().get(id)
        if db_obj:
            self._convert_json_fields_to_lists(db_obj)
        return db_obj

    def get_multi(self, skip: int = 0, limit: int = 100) -> List[BusinessOwnerPolicyModel]:
        db_objs = super().get_multi(skip=skip, limit=limit)
        for db_obj in db_objs:
            self._convert_json_fields_to_lists(db_obj)
        return db_objs

    def _convert_json_fields_to_lists(self, db_obj: BusinessOwnerPolicyModel):
        """Convert JSON string fields back to Python lists"""
        if db_obj.property_addresses and isinstance(db_obj.property_addresses, str):
            try:
                db_obj.property_addresses = json.loads(db_obj.property_addresses)
            except (json.JSONDecodeError, TypeError):
                db_obj.property_addresses = []
        
        if db_obj.security_safety_features and isinstance(db_obj.security_safety_features, str):
            try:
                db_obj.security_safety_features = json.loads(db_obj.security_safety_features)
            except (json.JSONDecodeError, TypeError):
                db_obj.security_safety_features = []

    def search_by_business_name(self, business_name: str) -> List[BusinessOwnerPolicyModel]:
        results = self.search_by_field("business_name", business_name)
        for result in results:
            self._convert_json_fields_to_lists(result)
        return results

    def search_by_email(self, email: str) -> List[BusinessOwnerPolicyModel]:
        results = self.search_by_field("email_address", email)
        for result in results:
            self._convert_json_fields_to_lists(result)
        return results

    def get_by_status(self, status: str) -> List[BusinessOwnerPolicyModel]:
        stmt = select(self.model).where(self.model.quote_status == status)
        results = self.session.exec(stmt).all()
        for result in results:
            self._convert_json_fields_to_lists(result)
        return results