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.grouplifeinsurance import GroupLife
from app.services.pdf_generator import generate_pdf
from db import get_session  # your DB session dependency

NOT_FOUND_MSG = "Group Life Insurance not found"

router = APIRouter(prefix="/api/v1/grouplife", tags=["Group Life Insurance"])

@router.post("/", response_model=GroupLife)
def create_grouplife_product(product: GroupLife, session: Session = Depends(get_session)):
    session.add(product)
    session.commit()
    
    return product

@router.get("/", response_model=List[GroupLife])
def get_all_grouplife_products(session: Session = Depends(get_session)):
    products = session.exec(select(GroupLife)).all()
    return products

@router.get("/{product_id}", response_model=GroupLife)
def get_grouplife_product(product_id: int, session: Session = Depends(get_session)):
    product = session.get(GroupLife, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    return product

@router.put("/{product_id}", response_model=GroupLife)
def update_grouplife_product(product_id: int, updated: GroupLife, session: Session = Depends(get_session)):
    product = session.get(GroupLife, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)

    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_grouplife_product(product_id: int, session: Session = Depends(get_session)):
    product = session.get(GroupLife, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)

    session.delete(product)
    session.commit()
    return {"message": "Group Life Insurance deleted successfully"}

@router.get("/{product_id}/download-pdf")
def download_group_life_pdf(
    product_id: int, 
    session: Session = Depends(get_session)
):
    """Download Group Life quote as PDF"""
    product = session.get(GroupLife, product_id)
    if not product:
        raise HTTPException(status_code=404, detail=NOT_FOUND_MSG)
    
    context = {
        "quote": product,
        "current_time": datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
        "base_url": "http://localhost:8000/"
    }
    
    pdf_filename = f"group_life_{product_id}.pdf"
    pdf_path = os.path.join("uploads", pdf_filename)
    
    os.makedirs("uploads", exist_ok=True)
    
    if generate_pdf("pdf_group_life.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")

GroupLifeRouter = router