wiedervorlage.py 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164
  1. """List follow-up editing, with its audit comment committed atomically."""
  2. import logging
  3. import re
  4. from datetime import date, datetime, timedelta
  5. from urllib.parse import urlencode
  6. from zoneinfo import ZoneInfo
  7. from fastapi import APIRouter, Depends, Form, HTTPException, Request
  8. from fastapi.responses import HTMLResponse, RedirectResponse
  9. from sqlalchemy import text
  10. from sqlalchemy.orm import Session
  11. from .comments import lock_comment_invoice, save_comment
  12. from .db import get_session
  13. from .jinja_templates import templates
  14. from .navigation import list_return_url, valid_focus
  15. from .permissions import current_principal, ensure_forderung_access
  16. router = APIRouter()
  17. logger = logging.getLogger(__name__)
  18. BERLIN = ZoneInfo("Europe/Berlin")
  19. def _now_berlin():
  20. return datetime.now(BERLIN)
  21. def _as_date(value):
  22. if value is None:
  23. return None
  24. if isinstance(value, datetime):
  25. return value.date()
  26. if isinstance(value, date):
  27. return value
  28. return date.fromisoformat(str(value)[:10])
  29. def _context(request, primary_key, db):
  30. if not valid_focus(primary_key):
  31. raise HTTPException(400, "Ungültiger Primärschlüssel")
  32. tenant, number = primary_key.split("_", 1)
  33. pkey = {"Client_DB": tenant, "Beleg_Nr": number}
  34. ensure_forderung_access(db, current_principal(request), tenant, number)
  35. state = (
  36. db.execute(
  37. text("""
  38. SELECT F.Beleg_Nr, F.Beleg_Faellig_Datum,
  39. COALESCE(FD.Wiedervorlage, F.Beleg_Faellig_Datum) AS Wiedervorlage
  40. FROM dbo.Forderungen_Kopf F
  41. LEFT JOIN dbo.Forderungen_Details FD ON FD.Client_DB = F.Client_DB AND FD.Beleg_Nr = F.Beleg_Nr
  42. WHERE F.Client_DB = :Client_DB AND F.Beleg_Nr = :Beleg_Nr
  43. """),
  44. pkey,
  45. )
  46. .mappings()
  47. .first()
  48. )
  49. if state is None:
  50. raise HTTPException(404, "Forderung nicht gefunden")
  51. today = _now_berlin().date()
  52. current = _as_date(state["Wiedervorlage"])
  53. return_url = list_return_url(request.query_params.get("return_to"), primary_key)
  54. return dict(
  55. pkey=pkey,
  56. state=state,
  57. today=today.isoformat(),
  58. next_week=(today + timedelta(days=7)).isoformat(),
  59. selected=current.isoformat() if current else "",
  60. error="",
  61. begruendung="",
  62. return_url=return_url,
  63. modal_url=request.url.path + "?" + urlencode({"return_to": return_url}),
  64. )
  65. def _render(request, context, status_code=200):
  66. return templates.TemplateResponse(
  67. request,
  68. "forderungen/wiedervorlage/modal.html",
  69. context,
  70. status_code=status_code,
  71. headers={"Cache-Control": "no-store"},
  72. )
  73. @router.get("/app/forderungen/liste/{primary_key}/wiedervorlage", response_class=HTMLResponse)
  74. def edit_wiedervorlage(request: Request, primary_key: str, db: Session = Depends(get_session)):
  75. context = _context(request, primary_key, db)
  76. if request.headers.get("HX-Request", "").lower() != "true":
  77. return RedirectResponse(context["return_url"], status_code=303)
  78. return _render(request, context)
  79. @router.post("/app/forderungen/liste/{primary_key}/wiedervorlage", response_class=HTMLResponse)
  80. def save_wiedervorlage(
  81. request: Request, primary_key: str, wiedervorlage: str = Form(""), begruendung: str = Form(""),
  82. db: Session = Depends(get_session),
  83. ):
  84. context = _context(request, primary_key, db)
  85. context["selected"] = wiedervorlage
  86. context["begruendung"] = begruendung.strip()
  87. try:
  88. if not re.fullmatch(r"\d{4}-\d{2}-\d{2}", wiedervorlage):
  89. raise ValueError
  90. selected = date.fromisoformat(wiedervorlage)
  91. except ValueError:
  92. context["error"] = "Bitte ein gültiges Wiedervorlagedatum auswählen."
  93. return _render(request, context, 422)
  94. try:
  95. lock_comment_invoice(db, context["pkey"])
  96. existing = (
  97. db.execute(
  98. text("""
  99. SELECT Wiedervorlage FROM dbo.Forderungen_Details WITH (UPDLOCK, HOLDLOCK)
  100. WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
  101. """),
  102. context["pkey"],
  103. )
  104. .mappings()
  105. .first()
  106. )
  107. current = _as_date(
  108. existing["Wiedervorlage"]
  109. if existing and existing["Wiedervorlage"] is not None
  110. else context["state"]["Beleg_Faellig_Datum"]
  111. )
  112. # Repeated submissions of an unchanged date must not duplicate the audit comment.
  113. if selected != current:
  114. values = dict(context["pkey"], Wiedervorlage=selected)
  115. if existing is None:
  116. db.execute(
  117. text("""
  118. INSERT INTO dbo.Forderungen_Details (Client_DB, Beleg_Nr, Wiedervorlage)
  119. VALUES (:Client_DB, :Beleg_Nr, :Wiedervorlage)
  120. """),
  121. values,
  122. )
  123. else:
  124. db.execute(
  125. text("""
  126. UPDATE dbo.Forderungen_Details SET Wiedervorlage = :Wiedervorlage
  127. WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
  128. """),
  129. values,
  130. )
  131. comment = f'WV auf {selected.strftime("%d.%m.%Y")} angepasst'
  132. if context["begruendung"]:
  133. comment += ": " + context["begruendung"]
  134. save_comment(
  135. db, context["pkey"], username=current_principal(request).username,
  136. timestamp=_now_berlin().replace(tzinfo=None), comment=comment,
  137. )
  138. db.commit()
  139. except Exception:
  140. db.rollback()
  141. logger.exception("Wiedervorlage konnte für %s nicht gespeichert werden", primary_key)
  142. context["error"] = "Datum und Kommentar konnten nicht gespeichert werden. Bitte erneut versuchen."
  143. return _render(request, context, 503)
  144. if request.headers.get("HX-Request", "").lower() == "true":
  145. return HTMLResponse("", headers={"HX-Redirect": context["return_url"], "Cache-Control": "no-store"})
  146. return RedirectResponse(context["return_url"], status_code=303)