verursacher.py 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. """Change the manual invoice assignee independently of the workflow form."""
  2. import json
  3. import logging
  4. from urllib.parse import quote, urlencode
  5. from fastapi import APIRouter, Depends, Form, HTTPException, Request
  6. from fastapi.responses import HTMLResponse, RedirectResponse
  7. from sqlalchemy import text
  8. from sqlalchemy.orm import Session
  9. from .db import get_session
  10. from .jinja_templates import templates
  11. from .navigation import DETAIL_PREFIX, list_return_url, valid_focus
  12. from .permissions import current_principal, ensure_forderung_access
  13. router = APIRouter()
  14. logger = logging.getLogger(__name__)
  15. USERS_SQL = text("""
  16. SELECT DISTINCT Benutzer_ID,
  17. MAX(NULLIF(Name, '')) OVER (PARTITION BY Benutzer_ID) AS Name,
  18. Rolle_Name
  19. FROM dbo.Benutzer_Rolle
  20. WHERE NULLIF(LTRIM(RTRIM(Benutzer_ID)), '') IS NOT NULL
  21. ORDER BY Name, Benutzer_ID, Rolle_Name
  22. """)
  23. STATE_SQL = text("""
  24. SELECT F.Client_DB, F.Beleg_Nr, F.Verursacher_Text AS Original_Verursacher_Text,
  25. F.Verursacher_Benutzer_ID AS Original_Verursacher_Benutzer_ID,
  26. FD.Verursacher_Benutzer_ID AS Override_Verursacher_Benutzer_ID,
  27. COALESCE(B.Name, FD.Verursacher_Benutzer_ID, F.Verursacher_Text) AS Verursacher_Text
  28. FROM dbo.Forderungen_Kopf F
  29. LEFT JOIN dbo.Forderungen_Details FD ON FD.Client_DB = F.Client_DB AND FD.Beleg_Nr = F.Beleg_Nr
  30. LEFT JOIN (
  31. SELECT Benutzer_ID, MAX(NULLIF(Name, '')) AS Name
  32. FROM dbo.Benutzer_Rolle GROUP BY Benutzer_ID
  33. ) B ON B.Benutzer_ID = FD.Verursacher_Benutzer_ID
  34. WHERE F.Client_DB = :Client_DB AND F.Beleg_Nr = :Beleg_Nr
  35. """)
  36. def _context(request, primary_key, db):
  37. if not valid_focus(primary_key):
  38. raise HTTPException(400, "Ungültiger Primärschlüssel")
  39. tenant, number = primary_key.split("_", 1)
  40. pkey = {"Client_DB": tenant, "Beleg_Nr": number}
  41. ensure_forderung_access(db, current_principal(request), tenant, number)
  42. state = db.execute(STATE_SQL, pkey).mappings().first()
  43. if state is None:
  44. raise HTTPException(404, "Forderung nicht gefunden")
  45. users = {}
  46. for row in db.execute(USERS_SQL).mappings().all():
  47. identity = row["Benutzer_ID"]
  48. user = users.setdefault(identity, {"id": identity, "name": row["Name"] or identity, "roles": []})
  49. if row["Rolle_Name"] and row["Rolle_Name"] not in user["roles"]:
  50. user["roles"].append(row["Rolle_Name"])
  51. users = sorted(users.values(), key=lambda user: (user["name"].casefold(), user["id"]))
  52. roles = sorted({role for user in users for role in user["roles"]}, key=str.casefold)
  53. detail = request.url.path.startswith(DETAIL_PREFIX)
  54. return_url = list_return_url(request.query_params.get("return_to"), primary_key)
  55. page_url = (
  56. DETAIL_PREFIX + quote(primary_key, safe="") + "?" + urlencode({"return_to": return_url})
  57. if detail
  58. else return_url
  59. )
  60. selected = state["Override_Verursacher_Benutzer_ID"] or state["Original_Verursacher_Benutzer_ID"] or ""
  61. return dict(
  62. pkey=pkey,
  63. state=state,
  64. users=users,
  65. roles=roles,
  66. selected=selected,
  67. detail=detail,
  68. primary_key=primary_key,
  69. page_url=page_url,
  70. return_url=return_url,
  71. modal_url=request.url.path + "?" + urlencode({"return_to": return_url}),
  72. role_filter="",
  73. error="",
  74. )
  75. def _render(request, context, status_code=200):
  76. return templates.TemplateResponse(
  77. request,
  78. "forderungen/verursacher/modal.html",
  79. context,
  80. status_code=status_code,
  81. headers={"Cache-Control": "no-store"},
  82. )
  83. @router.get("/app/forderungen/liste/{primary_key}/verursacher", response_class=HTMLResponse)
  84. @router.get("/app/forderungen/details/{primary_key}/verursacher", response_class=HTMLResponse)
  85. def edit_verursacher(request: Request, primary_key: str, db: Session = Depends(get_session)):
  86. context = _context(request, primary_key, db)
  87. if request.headers.get("HX-Request", "").lower() != "true":
  88. return RedirectResponse(context["page_url"], status_code=303)
  89. return _render(request, context)
  90. @router.post("/app/forderungen/liste/{primary_key}/verursacher", response_class=HTMLResponse)
  91. @router.post("/app/forderungen/details/{primary_key}/verursacher", response_class=HTMLResponse)
  92. def save_verursacher(
  93. request: Request,
  94. primary_key: str,
  95. action: str = Form("assign"),
  96. benutzer_id: str = Form(""),
  97. rolle: str = Form(""),
  98. db: Session = Depends(get_session),
  99. ):
  100. context = _context(request, primary_key, db)
  101. context["selected"] = benutzer_id
  102. context["role_filter"] = rolle if rolle in context["roles"] else ""
  103. user = next((user for user in context["users"] if user["id"] == benutzer_id), None)
  104. if action not in {"assign", "reset"} or (action == "assign" and user is None):
  105. context["error"] = "Bitte einen gültigen Benutzer auswählen."
  106. return _render(request, context, 422)
  107. value = None if action == "reset" else benutzer_id
  108. values = dict(context["pkey"], Verursacher_Benutzer_ID=value)
  109. try:
  110. # Serializable key-range lock prevents concurrent creation of the same detail record.
  111. existing = db.execute(
  112. text("""
  113. SELECT Verursacher_Benutzer_ID FROM dbo.Forderungen_Details WITH (UPDLOCK, HOLDLOCK)
  114. WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
  115. """),
  116. context["pkey"],
  117. ).first()
  118. if existing is None:
  119. if value is not None:
  120. db.execute(
  121. text("""
  122. INSERT INTO dbo.Forderungen_Details (Client_DB, Beleg_Nr, Verursacher_Benutzer_ID)
  123. VALUES (:Client_DB, :Beleg_Nr, :Verursacher_Benutzer_ID)
  124. """),
  125. values,
  126. )
  127. else:
  128. db.execute(
  129. text("""
  130. UPDATE dbo.Forderungen_Details SET Verursacher_Benutzer_ID = :Verursacher_Benutzer_ID
  131. WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
  132. """),
  133. values,
  134. )
  135. db.commit()
  136. except Exception:
  137. db.rollback()
  138. logger.exception("Verursacher konnte für %s nicht gespeichert werden", primary_key)
  139. context["error"] = "Der Verursacher konnte nicht gespeichert werden. Bitte erneut versuchen."
  140. return _render(request, context, 503)
  141. if request.headers.get("HX-Request", "").lower() != "true":
  142. return RedirectResponse(context["page_url"], status_code=303)
  143. if not context["detail"]:
  144. return HTMLResponse("", headers={"HX-Redirect": context["return_url"], "Cache-Control": "no-store"})
  145. context["effective_name"] = context["state"]["Original_Verursacher_Text"] if value is None else user["name"]
  146. context["oob"] = True
  147. return templates.TemplateResponse(
  148. request,
  149. "forderungen/verursacher/detail_field.html",
  150. context,
  151. headers={"HX-Trigger-After-Swap": json.dumps({"gc:verursacherSaved": {}}), "Cache-Control": "no-store"},
  152. )