from fastapi import APIRouter, Depends, HTTPException, Query
from fastapi.responses import FileResponse
from sqlmodel import Session
from typing import List
from datetime import datetime
import os
from db import get_session
from app.repository.commercial_property_repository import CommercialPropertyRepository
from app.schemas.CommercialPropertySchema import (
    CommercialPropertyCreate,
    CommercialPropertyUpdate,
    CommercialPropertyResponse
)
from app.services.pdf_generator import generate_pdf

router = APIRouter(prefix="/api/v1/commercial-property", tags=["Commercial Property"])

def get_repository(session: Session = Depends(get_session)) -> CommercialPropertyRepository:
    return CommercialPropertyRepository(session)

@router.post("/quotes", response_model=CommercialPropertyResponse, status_code=201)
async def create_commercial_property_quote(
    quote_data: CommercialPropertyCreate,
    repository: CommercialPropertyRepository = Depends(get_repository)
):
    """Create a new commercial property insurance quote"""
    try:
        return repository.create(quote_data)
    except Exception as e:
        raise HTTPException(status_code=400, detail=str(e))

@router.get("/quotes/{quote_id}", response_model=CommercialPropertyResponse)
async def get_quote(
    quote_id: int,
    repository: CommercialPropertyRepository = Depends(get_repository)
):
    """Get a specific commercial property quote by ID"""
    quote = repository.get_by_id(quote_id)
    if not quote:
        raise HTTPException(status_code=404, detail="Quote not found")
    return quote

@router.get("/quotes/{quote_id}/download-pdf")
async def download_commercial_property_pdf(
    quote_id: int,
    repository: CommercialPropertyRepository = Depends(get_repository)
):
    """Download commercial property quote as PDF"""
    quote = repository.get_by_id(quote_id)
    if not quote:
        raise HTTPException(status_code=404, detail="Quote not found")
    
    context = {
        "quote": quote,
        "current_time": datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
        "base_url": "https://insuranceexchange.com/"
    }
    
    pdf_filename = f"commercial_property_{quote_id}.pdf"
    pdf_path = os.path.join("uploads", pdf_filename)
    
    os.makedirs("uploads", exist_ok=True)
    
    if generate_pdf("pdf_commercial_property.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")

@router.get("/quotes", response_model=List[CommercialPropertyResponse])
async def get_quotes(
    skip: int = Query(0, ge=0),
    limit: int = Query(100, ge=1, le=1000),
    repository: CommercialPropertyRepository = Depends(get_repository)
):
    """Get all commercial property quotes with pagination"""
    return repository.get_all(skip=skip, limit=limit)

# @router.get("/quotes/{quote_id}", response_model=CommercialPropertyResponse)
# async def get_quote(
#     quote_id: int,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Get a specific commercial property quote by ID"""
#     quote = repository.get_by_id(quote_id)
#     if not quote:
#         raise HTTPException(status_code=404, detail="Quote not found")
#     return quote

# @router.put("/quotes/{quote_id}", response_model=CommercialPropertyResponse)
# async def update_quote(
#     quote_id: int,
#     update_data: CommercialPropertyUpdate,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Update a commercial property quote"""
#     quote = repository.update(quote_id, update_data)
#     if not quote:
#         raise HTTPException(status_code=404, detail="Quote not found")
#     return quote

# @router.delete("/quotes/{quote_id}", status_code=204)
# async def delete_quote(
#     quote_id: int,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Delete a commercial property quote"""
#     if not repository.delete(quote_id):
#         raise HTTPException(status_code=404, detail="Quote not found")

# @router.get("/quotes/search/{query}", response_model=List[CommercialPropertyResponse])
# async def search_quotes(
#     query: str,
#     skip: int = Query(0, ge=0),
#     limit: int = Query(100, ge=1, le=1000),
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Search commercial property quotes by business name, contact name, or email"""
#     return repository.search(query, skip=skip, limit=limit)

# @router.get("/quotes/business/{business_name}", response_model=List[CommercialPropertyResponse])
# async def get_quotes_by_business(
#     business_name: str,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Get commercial property quotes by business name"""
#     return repository.get_by_business_name(business_name)

# @router.get("/quotes/email/{email}", response_model=List[CommercialPropertyResponse])
# async def get_quotes_by_email(
#     email: str,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Get commercial property quotes by email address"""
#     return repository.get_by_email(email)

# @router.get("/quotes/status/{status}", response_model=List[CommercialPropertyResponse])
# async def get_quotes_by_status(
#     status: str,
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Get commercial property quotes by status"""
#     return repository.get_by_status(status)

# @router.get("/stats/count")
# async def get_quotes_count(
#     repository: CommercialPropertyRepository = Depends(get_repository)
# ):
#     """Get total count of commercial property quotes"""
#     return {"total_quotes": repository.count()}