wiedervorlage.py 5.6 KB

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