from typing import List, Optional
from sqlmodel import Session, select
from datetime import datetime, timezone
from app.models.Commercialautomodel import CommercialAutoModel
from app.schemas.Commercialautoschema import CommercialAutoCreate, CommercialAutoUpdate
from app.utils.transaction_generator import generate_transaction_number

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

    def create(self, commercial_auto_data: CommercialAutoCreate) -> CommercialAutoModel:
        """Create a new commercial auto quote"""
        obj_data = commercial_auto_data.model_dump()
        obj_data['transaction_no'] = generate_transaction_number('commercial_auto')
        
        from app.core.security import current_user_var
        user = current_user_var.get()
        if user:
            obj_data['user_id'] = user.get("user_id")
            
        db_commercial_auto = CommercialAutoModel(**obj_data)
        db_commercial_auto.encrypt_sensitive_data()
        self.session.add(db_commercial_auto)
        self.session.commit()
        self.session.refresh(db_commercial_auto)
        db_commercial_auto.decrypt_sensitive_data()
        return db_commercial_auto

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

    def get_all(self, skip: int = 0, limit: int = 100) -> List[CommercialAutoModel]:
        """Get all commercial auto quotes with pagination and customer filtration"""
        from app.core.security import current_user_var
        user = current_user_var.get()
        
        statement = select(CommercialAutoModel)
        if user and user.get("role") == "customer":
            statement = statement.where(CommercialAutoModel.user_id == user["user_id"])
        elif user and user.get("role") == "admin":
            pass
        else:
            statement = statement.where(CommercialAutoModel.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[CommercialAutoModel]:
        """Get commercial auto quotes by business name"""
        statement = select(CommercialAutoModel).where(
            CommercialAutoModel.business_name.ilike(f"%{business_name}%")
        )
        return self.session.exec(statement).all()

    def get_by_email(self, email: str) -> List[CommercialAutoModel]:
        """Get commercial auto quotes by email address"""
        statement = select(CommercialAutoModel).where(
            CommercialAutoModel.email_address == email
        )
        return self.session.exec(statement).all()

    def get_by_status(self, status: str) -> List[CommercialAutoModel]:
        """Get commercial auto quotes by status"""
        statement = select(CommercialAutoModel).where(
            CommercialAutoModel.quote_status == status
        )
        return self.session.exec(statement).all()

    def update(self, quote_id: int, update_data: CommercialAutoUpdate) -> Optional[CommercialAutoModel]:
        """Update commercial auto quote"""
        db_commercial_auto = self.session.get(CommercialAutoModel, quote_id)
        if not db_commercial_auto:
            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_commercial_auto, field, value)
            
            db_commercial_auto.encrypt_sensitive_data()
            self.session.add(db_commercial_auto)
            self.session.commit()
            self.session.refresh(db_commercial_auto)
            db_commercial_auto.decrypt_sensitive_data()
        
        return db_commercial_auto

    def delete(self, quote_id: int) -> bool:
        """Delete commercial auto quote"""
        db_commercial_auto = self.session.get(CommercialAutoModel, quote_id)
        if not db_commercial_auto:
            return False
        
        self.session.delete(db_commercial_auto)
        self.session.commit()
        return True

    def count(self) -> int:
        """Get total count of commercial auto quotes"""
        statement = select(CommercialAutoModel)
        return len(self.session.exec(statement).all())

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