| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164 |
- """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)
|