| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166 |
- """Change the manual invoice assignee independently of the workflow form."""
- import json
- import logging
- from urllib.parse import quote, urlencode
- from fastapi import APIRouter, Depends, Form, HTTPException, Request
- from fastapi.responses import HTMLResponse, RedirectResponse
- from sqlalchemy import text
- from sqlalchemy.orm import Session
- from .db import get_session
- from .jinja_templates import templates
- from .navigation import DETAIL_PREFIX, list_return_url, valid_focus
- from .permissions import current_principal, ensure_forderung_access
- router = APIRouter()
- logger = logging.getLogger(__name__)
- USERS_SQL = text("""
- SELECT DISTINCT Benutzer_ID,
- MAX(NULLIF(Name, '')) OVER (PARTITION BY Benutzer_ID) AS Name,
- Rolle_Name
- FROM dbo.Benutzer_Rolle
- WHERE NULLIF(LTRIM(RTRIM(Benutzer_ID)), '') IS NOT NULL
- ORDER BY Name, Benutzer_ID, Rolle_Name
- """)
- STATE_SQL = text("""
- SELECT F.Client_DB, F.Beleg_Nr, F.Verursacher_Text AS Original_Verursacher_Text,
- F.Verursacher_Benutzer_ID AS Original_Verursacher_Benutzer_ID,
- FD.Verursacher_Benutzer_ID AS Override_Verursacher_Benutzer_ID,
- COALESCE(B.Name, FD.Verursacher_Benutzer_ID, F.Verursacher_Text) AS Verursacher_Text
- 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
- LEFT JOIN (
- SELECT Benutzer_ID, MAX(NULLIF(Name, '')) AS Name
- FROM dbo.Benutzer_Rolle GROUP BY Benutzer_ID
- ) B ON B.Benutzer_ID = FD.Verursacher_Benutzer_ID
- WHERE F.Client_DB = :Client_DB AND F.Beleg_Nr = :Beleg_Nr
- """)
- 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(STATE_SQL, pkey).mappings().first()
- if state is None:
- raise HTTPException(404, "Forderung nicht gefunden")
- users = {}
- for row in db.execute(USERS_SQL).mappings().all():
- identity = row["Benutzer_ID"]
- user = users.setdefault(identity, {"id": identity, "name": row["Name"] or identity, "roles": []})
- if row["Rolle_Name"] and row["Rolle_Name"] not in user["roles"]:
- user["roles"].append(row["Rolle_Name"])
- users = sorted(users.values(), key=lambda user: (user["name"].casefold(), user["id"]))
- roles = sorted({role for user in users for role in user["roles"]}, key=str.casefold)
- detail = request.url.path.startswith(DETAIL_PREFIX)
- return_url = list_return_url(request.query_params.get("return_to"), primary_key)
- page_url = (
- DETAIL_PREFIX + quote(primary_key, safe="") + "?" + urlencode({"return_to": return_url})
- if detail
- else return_url
- )
- selected = state["Override_Verursacher_Benutzer_ID"] or state["Original_Verursacher_Benutzer_ID"] or ""
- return dict(
- pkey=pkey,
- state=state,
- users=users,
- roles=roles,
- selected=selected,
- detail=detail,
- primary_key=primary_key,
- page_url=page_url,
- return_url=return_url,
- modal_url=request.url.path + "?" + urlencode({"return_to": return_url}),
- role_filter="",
- error="",
- )
- def _render(request, context, status_code=200):
- return templates.TemplateResponse(
- request,
- "forderungen/verursacher/modal.html",
- context,
- status_code=status_code,
- headers={"Cache-Control": "no-store"},
- )
- @router.get("/app/forderungen/liste/{primary_key}/verursacher", response_class=HTMLResponse)
- @router.get("/app/forderungen/details/{primary_key}/verursacher", response_class=HTMLResponse)
- def edit_verursacher(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["page_url"], status_code=303)
- return _render(request, context)
- @router.post("/app/forderungen/liste/{primary_key}/verursacher", response_class=HTMLResponse)
- @router.post("/app/forderungen/details/{primary_key}/verursacher", response_class=HTMLResponse)
- def save_verursacher(
- request: Request,
- primary_key: str,
- action: str = Form("assign"),
- benutzer_id: str = Form(""),
- rolle: str = Form(""),
- db: Session = Depends(get_session),
- ):
- context = _context(request, primary_key, db)
- context["selected"] = benutzer_id
- context["role_filter"] = rolle if rolle in context["roles"] else ""
- user = next((user for user in context["users"] if user["id"] == benutzer_id), None)
- if action not in {"assign", "reset"} or (action == "assign" and user is None):
- context["error"] = "Bitte einen gültigen Benutzer auswählen."
- return _render(request, context, 422)
- value = None if action == "reset" else benutzer_id
- values = dict(context["pkey"], Verursacher_Benutzer_ID=value)
- try:
- # Serializable key-range lock prevents concurrent creation of the same detail record.
- existing = db.execute(
- text("""
- SELECT Verursacher_Benutzer_ID FROM dbo.Forderungen_Details WITH (UPDLOCK, HOLDLOCK)
- WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
- """),
- context["pkey"],
- ).first()
- if existing is None:
- if value is not None:
- db.execute(
- text("""
- INSERT INTO dbo.Forderungen_Details (Client_DB, Beleg_Nr, Verursacher_Benutzer_ID)
- VALUES (:Client_DB, :Beleg_Nr, :Verursacher_Benutzer_ID)
- """),
- values,
- )
- else:
- db.execute(
- text("""
- UPDATE dbo.Forderungen_Details SET Verursacher_Benutzer_ID = :Verursacher_Benutzer_ID
- WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
- """),
- values,
- )
- db.commit()
- except Exception:
- db.rollback()
- logger.exception("Verursacher konnte für %s nicht gespeichert werden", primary_key)
- context["error"] = "Der Verursacher konnte nicht gespeichert werden. Bitte erneut versuchen."
- return _render(request, context, 503)
- if request.headers.get("HX-Request", "").lower() != "true":
- return RedirectResponse(context["page_url"], status_code=303)
- if not context["detail"]:
- return HTMLResponse("", headers={"HX-Redirect": context["return_url"], "Cache-Control": "no-store"})
- context["effective_name"] = context["state"]["Original_Verursacher_Text"] if value is None else user["name"]
- context["oob"] = True
- return templates.TemplateResponse(
- request,
- "forderungen/verursacher/detail_field.html",
- context,
- headers={"HX-Trigger-After-Swap": json.dumps({"gc:verursacherSaved": {}}), "Cache-Control": "no-store"},
- )
|