"""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"}, )