from typing import List, Optional
from sqlmodel import Session, select
from datetime import datetime, timezone
from app.models.WorkersCompensationModel import WorkersCompensationModel
from app.schemas.WorkersCompensationSchema import WorkersCompensationCreate, WorkersCompensationUpdate
from app.utils.transaction_generator import generate_transaction_number

class WorkersCompensationRepository:
    def __init__(self, session: Session):
        self.session = session

    def create(self, workers_comp_data: WorkersCompensationCreate) -> WorkersCompensationModel:
        """Create a new workers compensation quote"""
        obj_data = workers_comp_data.model_dump()
        obj_data['transaction_no'] = generate_transaction_number('workers_comp')
        
        from app.core.security import current_user_var
        user = current_user_var.get()
        if user:
            obj_data['user_id'] = user.get("user_id")
            
        db_workers_comp = WorkersCompensationModel(**obj_data)
        db_workers_comp.encrypt_sensitive_data()
        self.session.add(db_workers_comp)
        self.session.commit()
        self.session.refresh(db_workers_comp)
        db_workers_comp.decrypt_sensitive_data()
        return db_workers_comp

    def get_by_id(self, quote_id: int) -> Optional[WorkersCompensationModel]:
        """Get workers compensation quote by ID"""
        quote = self.session.get(WorkersCompensationModel, quote_id)
        if quote:
            quote.decrypt_sensitive_data()
        return quote

    def get_all(self, skip: int = 0, limit: int = 100) -> List[WorkersCompensationModel]:
        """Get all workers compensation quotes with pagination and customer filtration"""
        from app.core.security import current_user_var
        user = current_user_var.get()
        
        statement = select(WorkersCompensationModel)
        if user and user.get("role") == "customer":
            statement = statement.where(WorkersCompensationModel.user_id == user["user_id"])
        elif user and user.get("role") == "admin":
            pass
        else:
            statement = statement.where(WorkersCompensationModel.user_id == -1)
            
        statement = statement.offset(skip).limit(limit)
        quotes = self.session.exec(statement).all()
        for quote in quotes:
            quote.decrypt_sensitive_data()
        return quotes

    def get_by_business_name(self, business_name: str) -> List[WorkersCompensationModel]:
        """Get workers compensation quotes by business name"""
        statement = select(WorkersCompensationModel).where(
            WorkersCompensationModel.business_name.ilike(f"%{business_name}%")
        )
        quotes = self.session.exec(statement).all()
        for quote in quotes:
            quote.decrypt_sensitive_data()
        return quotes

    def get_by_email(self, email: str) -> List[WorkersCompensationModel]:
        """Get workers compensation quotes by email address"""
        statement = select(WorkersCompensationModel).where(
            WorkersCompensationModel.email_address == email
        )
        quotes = self.session.exec(statement).all()
        for quote in quotes:
            quote.decrypt_sensitive_data()
        return quotes

    def get_by_status(self, status: str) -> List[WorkersCompensationModel]:
        """Get workers compensation quotes by status"""
        statement = select(WorkersCompensationModel).where(
            WorkersCompensationModel.quote_status == status
        )
        quotes = self.session.exec(statement).all()
        for quote in quotes:
            quote.decrypt_sensitive_data()
        return quotes

    def update(self, quote_id: int, update_data: WorkersCompensationUpdate) -> Optional[WorkersCompensationModel]:
        """Update workers compensation quote"""
        db_workers_comp = self.session.get(WorkersCompensationModel, quote_id)
        if not db_workers_comp:
            return None
        
        update_dict = update_data.model_dump(exclude_unset=True)
        if update_dict:
            update_dict["updated_at"] = datetime.now(timezone.utc)
            for field, value in update_dict.items():
                setattr(db_workers_comp, field, value)
            
            db_workers_comp.encrypt_sensitive_data()
            self.session.add(db_workers_comp)
            self.session.commit()
            self.session.refresh(db_workers_comp)
            db_workers_comp.decrypt_sensitive_data()
        
        return db_workers_comp

    def delete(self, quote_id: int) -> bool:
        """Delete workers compensation quote"""
        db_workers_comp = self.session.get(WorkersCompensationModel, quote_id)
        if not db_workers_comp:
            return False
        
        self.session.delete(db_workers_comp)
        self.session.commit()
        return True

    def count(self) -> int:
        """Get total count of workers compensation quotes"""
        statement = select(WorkersCompensationModel)
        return len(self.session.exec(statement).all())

    def search(self, query: str, skip: int = 0, limit: int = 100) -> List[WorkersCompensationModel]:
        """Search workers compensation quotes by business name, contact name, or email"""
        statement = select(WorkersCompensationModel).where(
            (WorkersCompensationModel.business_name.ilike(f"%{query}%")) |
            (WorkersCompensationModel.contact_name.ilike(f"%{query}%")) |
            (WorkersCompensationModel.email_address.ilike(f"%{query}%"))
        ).offset(skip).limit(limit)
        quotes = self.session.exec(statement).all()
        for quote in quotes:
            quote.decrypt_sensitive_data()
        return quotes