from fastapi import APIRouter, HTTPException, Depends
from fastapi.responses import FileResponse
from sqlmodel import Session, select
from typing import List
import os
from datetime import datetime
from app.models.unifiedcommercialinsurance import Unifiedcommercial
from app.schemas.unifiedcommercialinsuranceschema import UnifiedcommercialCreate, UnifiedcommercialUpdate
from app.services.pdf_generator import generate_pdf
from app.utils.transaction_generator import generate_transaction_number
from db import get_session  # your DB session dependency
from app.core.security import get_current_user_info, verify_owner_or_admin

router = APIRouter(prefix="/api/v1/unifiedcommercial", tags=["Unified Commercial Insurance"])

NOT_FOUND_MSG = "Unified commercial not found"

@router.post("/", response_model=Unifiedcommercial)
def create_unified_commercial_product(
    product: UnifiedcommercialCreate, 
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    obj_data = product.model_dump()
    obj_data['transaction_no'] = generate_transaction_number('unified_commercial')
    obj_data['user_id'] = current_user["user_id"]
    if current_user.get("role") == "customer":
        obj_data['email_address'] = current_user["email"]
    db_product = Unifiedcommercial(**obj_data)
    session.add(db_product)
    session.commit()
    session.refresh(db_product)
    return db_product

@router.get("/", response_model=List[Unifiedcommercial])
def get_all_unified_commercial_products(
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    if current_user.get("role") == "admin":
        products = session.exec(select(Unifiedcommercial)).all()
    else:
        products = session.exec(select(Unifiedcommercial).where(Unifiedcommercial.user_id == current_user["user_id"])).all()
    return products

@router.get("/{product_id}", response_model=Unifiedcommercial)
def get_unified_commercial_product(
    product_id: int, 
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    product = session.get(Unifiedcommercial, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    verify_owner_or_admin(product, current_user)
    return product

@router.put("/{product_id}", response_model=Unifiedcommercial)
def update_unified_commercial_product(
    product_id: int, 
    updated: UnifiedcommercialUpdate, 
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    product = session.get(Unifiedcommercial, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    verify_owner_or_admin(product, current_user)

    for field, value in updated.model_dump(exclude_unset=True).items():
        setattr(product, field, value)

    session.add(product)
    session.commit()
    session.refresh(product)
    
    return product

@router.delete("/{product_id}")
def delete_unified_commercial_product(
    product_id: int, 
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    product = session.get(Unifiedcommercial, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    verify_owner_or_admin(product, current_user)

    session.delete(product)
    session.commit()
    return {"message": "Unified commercial deleted successfully"}

@router.get("/{product_id}/download-pdf")
def download_unified_commercial_pdf(
    product_id: int, 
    current_user: dict = Depends(get_current_user_info),
    session: Session = Depends(get_session)
):
    """Download Unified Commercial quote as PDF"""
    product = session.get(Unifiedcommercial, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    verify_owner_or_admin(product, current_user)
    
    context = {
        "quote": product,
        "current_time": datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
        "base_url": "http://localhost:8000/"
    }
    
    pdf_filename = f"unified_commercial_{product_id}.pdf"
    pdf_path = os.path.join("uploads", pdf_filename)
    
    os.makedirs("uploads", exist_ok=True)
    
    if generate_pdf("pdf_unified_commercial.html", context, pdf_path):
        return FileResponse(
            path=pdf_path,
            filename=pdf_filename,
            media_type="application/pdf"
        )
    else:
        raise HTTPException(status_code=500, detail="Failed to generate PDF")

UnifiedcommercialRouter = router