from fastapi import APIRouter, Request, Form, Depends
from fastapi.responses import HTMLResponse, RedirectResponse
from fastapi.templating import Jinja2Templates
from sqlalchemy.ext.asyncio import AsyncSession
from sqlalchemy import select, func
from app.core.database import get_db
from app.models.models import OperationalExpense, Site
from app.core.security import require_roles
import os

router = APIRouter(dependencies=[Depends(require_roles("super_admin", "admin_cs"))])
BASE_DIR = os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
templates = Jinja2Templates(directory=os.path.join(BASE_DIR, "app/templates"))

@router.get("/expenses", response_class=HTMLResponse)
async def expenses_page(request: Request, db: AsyncSession = Depends(get_db)):
    sites = (await db.execute(select(Site).where(Site.is_active == True))).scalars().all()
    expenses = (await db.execute(select(OperationalExpense).order_by(OperationalExpense.created_at.desc()))).scalars().all()
    total_expense = sum(e.amount for e in expenses)
    return templates.TemplateResponse(request=request, name="expenses.html", context={
        "sites": sites,
        "expenses": expenses,
        "total_expense": total_expense
    })

@router.post("/expenses")
async def add_expense(
    title: str = Form(...),
    category: str = Form(...),
    amount: int = Form(...),
    period: str = Form(...),
    site_id: int | None = Form(None),
    description: str | None = Form(None),
    db: AsyncSession = Depends(get_db)
):
    db.add(OperationalExpense(
        title=title.strip(),
        category=category,
        amount=amount,
        period=period.strip(),
        site_id=site_id,
        description=description.strip() if description else None
    ))
    await db.commit()
    return RedirectResponse(url="/expenses", status_code=303)

@router.post("/expenses/{expense_id}/delete")
async def delete_expense(expense_id: int, db: AsyncSession = Depends(get_db)):
    exp = await db.get(OperationalExpense, expense_id)
    if exp:
        await db.delete(exp)
        await db.commit()
    return RedirectResponse(url="/expenses", status_code=303)
