"""List follow-up editing, with its audit comment committed atomically.""" import logging import re from datetime import date, datetime, timedelta from urllib.parse import urlencode from zoneinfo import ZoneInfo from fastapi import APIRouter, Depends, Form, HTTPException, Request from fastapi.responses import HTMLResponse, RedirectResponse from sqlalchemy import text from sqlalchemy.orm import Session from .comments import lock_comment_invoice, save_comment from .db import get_session from .jinja_templates import templates from .navigation import list_return_url, valid_focus from .permissions import current_principal, ensure_forderung_access router = APIRouter() logger = logging.getLogger(__name__) BERLIN = ZoneInfo("Europe/Berlin") def _now_berlin(): return datetime.now(BERLIN) def _as_date(value): if value is None: return None if isinstance(value, datetime): return value.date() if isinstance(value, date): return value return date.fromisoformat(str(value)[:10]) def _context(request, primary_key, db): if not valid_focus(primary_key): raise HTTPException(400, "Ungültiger Primärschlüssel") tenant, number = primary_key.split("_", 1) pkey = {"Client_DB": tenant, "Beleg_Nr": number} ensure_forderung_access(db, current_principal(request), tenant, number) state = ( db.execute( text(""" SELECT F.Beleg_Nr, F.Beleg_Faellig_Datum, COALESCE(FD.Wiedervorlage, F.Beleg_Faellig_Datum) AS Wiedervorlage FROM dbo.Forderungen_Kopf F LEFT JOIN dbo.Forderungen_Details FD ON FD.Client_DB = F.Client_DB AND FD.Beleg_Nr = F.Beleg_Nr WHERE F.Client_DB = :Client_DB AND F.Beleg_Nr = :Beleg_Nr """), pkey, ) .mappings() .first() ) if state is None: raise HTTPException(404, "Forderung nicht gefunden") today = _now_berlin().date() current = _as_date(state["Wiedervorlage"]) return_url = list_return_url(request.query_params.get("return_to"), primary_key) return dict( pkey=pkey, state=state, today=today.isoformat(), next_week=(today + timedelta(days=7)).isoformat(), selected=current.isoformat() if current else "", error="", begruendung="", return_url=return_url, modal_url=request.url.path + "?" + urlencode({"return_to": return_url}), ) def _render(request, context, status_code=200): return templates.TemplateResponse( request, "forderungen/wiedervorlage/modal.html", context, status_code=status_code, headers={"Cache-Control": "no-store"}, ) @router.get("/app/forderungen/liste/{primary_key}/wiedervorlage", response_class=HTMLResponse) def edit_wiedervorlage(request: Request, primary_key: str, db: Session = Depends(get_session)): context = _context(request, primary_key, db) if request.headers.get("HX-Request", "").lower() != "true": return RedirectResponse(context["return_url"], status_code=303) return _render(request, context) @router.post("/app/forderungen/liste/{primary_key}/wiedervorlage", response_class=HTMLResponse) def save_wiedervorlage( request: Request, primary_key: str, wiedervorlage: str = Form(""), begruendung: str = Form(""), db: Session = Depends(get_session), ): context = _context(request, primary_key, db) context["selected"] = wiedervorlage context["begruendung"] = begruendung.strip() try: if not re.fullmatch(r"\d{4}-\d{2}-\d{2}", wiedervorlage): raise ValueError selected = date.fromisoformat(wiedervorlage) except ValueError: context["error"] = "Bitte ein gültiges Wiedervorlagedatum auswählen." return _render(request, context, 422) try: lock_comment_invoice(db, context["pkey"]) existing = ( db.execute( text(""" SELECT Wiedervorlage FROM dbo.Forderungen_Details WITH (UPDLOCK, HOLDLOCK) WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr """), context["pkey"], ) .mappings() .first() ) current = _as_date( existing["Wiedervorlage"] if existing and existing["Wiedervorlage"] is not None else context["state"]["Beleg_Faellig_Datum"] ) # Repeated submissions of an unchanged date must not duplicate the audit comment. if selected != current: values = dict(context["pkey"], Wiedervorlage=selected) if existing is None: db.execute( text(""" INSERT INTO dbo.Forderungen_Details (Client_DB, Beleg_Nr, Wiedervorlage) VALUES (:Client_DB, :Beleg_Nr, :Wiedervorlage) """), values, ) else: db.execute( text(""" UPDATE dbo.Forderungen_Details SET Wiedervorlage = :Wiedervorlage WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr """), values, ) comment = f'WV auf {selected.strftime("%d.%m.%Y")} angepasst' if context["begruendung"]: comment += ": " + context["begruendung"] save_comment( db, context["pkey"], username=current_principal(request).username, timestamp=_now_berlin().replace(tzinfo=None), comment=comment, ) db.commit() except Exception: db.rollback() logger.exception("Wiedervorlage konnte für %s nicht gespeichert werden", primary_key) context["error"] = "Datum und Kommentar konnten nicht gespeichert werden. Bitte erneut versuchen." return _render(request, context, 503) if request.headers.get("HX-Request", "").lower() == "true": return HTMLResponse("", headers={"HX-Redirect": context["return_url"], "Cache-Control": "no-store"}) return RedirectResponse(context["return_url"], status_code=303)