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