| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 |
- """List follow-up editing, with its audit comment committed atomically."""
- from datetime import date, datetime, timedelta
- import logging
- import re
- from urllib.parse import urlencode
- from zoneinfo import ZoneInfo
- 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 list_return_url, valid_focus
- from .permissions import current_principal, ensure_forderung_access
- router = APIRouter()
- logger = logging.getLogger(__name__)
- BERLIN = ZoneInfo('Europe/Berlin')
- def _now_berlin():
- return datetime.now(BERLIN)
- def _as_date(value):
- if value is None:
- return None
- if isinstance(value, datetime):
- return value.date()
- if isinstance(value, date):
- return value
- return date.fromisoformat(str(value)[:10])
- 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(text("""
- SELECT F.Beleg_Nr, F.Beleg_Faellig_Datum,
- COALESCE(FD.Wiedervorlage, F.Beleg_Faellig_Datum) AS Wiedervorlage
- 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
- WHERE F.Client_DB = :Client_DB AND F.Beleg_Nr = :Beleg_Nr
- """), pkey).mappings().first()
- if state is None:
- raise HTTPException(404, 'Forderung nicht gefunden')
- today = _now_berlin().date()
- current = _as_date(state['Wiedervorlage'])
- return_url = list_return_url(request.query_params.get('return_to'), primary_key)
- return dict(pkey=pkey, state=state, today=today.isoformat(),
- next_week=(today + timedelta(days=7)).isoformat(),
- selected=current.isoformat() if current else '', error='',
- return_url=return_url,
- modal_url=request.url.path + '?' + urlencode({'return_to': return_url}))
- def _render(request, context, status_code=200):
- return templates.TemplateResponse(request, 'forderungen/wiedervorlage/modal.html', context,
- status_code=status_code, headers={'Cache-Control': 'no-store'})
- @router.get('/app/forderungen/liste/{primary_key}/wiedervorlage', response_class=HTMLResponse)
- def edit_wiedervorlage(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['return_url'], status_code=303)
- return _render(request, context)
- @router.post('/app/forderungen/liste/{primary_key}/wiedervorlage', response_class=HTMLResponse)
- def save_wiedervorlage(request: Request, primary_key: str, wiedervorlage: str = Form(''),
- db: Session = Depends(get_session)):
- context = _context(request, primary_key, db)
- context['selected'] = wiedervorlage
- try:
- if not re.fullmatch(r'\d{4}-\d{2}-\d{2}', wiedervorlage):
- raise ValueError
- selected = date.fromisoformat(wiedervorlage)
- except ValueError:
- context['error'] = 'Bitte ein gültiges Wiedervorlagedatum auswählen.'
- return _render(request, context, 422)
- try:
- existing = db.execute(text("""
- SELECT Wiedervorlage FROM dbo.Forderungen_Details WITH (UPDLOCK, HOLDLOCK)
- WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
- """), context['pkey']).mappings().first()
- current = _as_date(existing['Wiedervorlage'] if existing and existing['Wiedervorlage'] is not None
- else context['state']['Beleg_Faellig_Datum'])
- # Repeated submissions of an unchanged date must not duplicate the audit comment.
- if selected != current:
- values = dict(context['pkey'], Wiedervorlage=selected)
- if existing is None:
- db.execute(text("""
- INSERT INTO dbo.Forderungen_Details (Client_DB, Beleg_Nr, Wiedervorlage)
- VALUES (:Client_DB, :Beleg_Nr, :Wiedervorlage)
- """), values)
- else:
- db.execute(text("""
- UPDATE dbo.Forderungen_Details SET Wiedervorlage = :Wiedervorlage
- WHERE Client_DB = :Client_DB AND Beleg_Nr = :Beleg_Nr
- """), values)
- db.execute(text("""
- INSERT INTO dbo.Forderungen_Kommentar (Client_DB, Beleg_Nr, [Timestamp], Benutzer_ID, Kommentar)
- VALUES (:Client_DB, :Beleg_Nr, :Timestamp, :Benutzer_ID, :Kommentar)
- """), dict(context['pkey'], Timestamp=_now_berlin().replace(tzinfo=None),
- Benutzer_ID=current_principal(request).username,
- Kommentar=f'WV auf {selected.strftime("%d.%m.%Y")} angepasst'))
- db.commit()
- except Exception:
- db.rollback()
- logger.exception('Wiedervorlage konnte für %s nicht gespeichert werden', primary_key)
- context['error'] = 'Datum und Kommentar konnten nicht gespeichert werden. Bitte erneut versuchen.'
- return _render(request, context, 503)
- if request.headers.get('HX-Request', '').lower() == 'true':
- return HTMLResponse('', headers={'HX-Redirect': context['return_url'], 'Cache-Control': 'no-store'})
- return RedirectResponse(context['return_url'], status_code=303)
|