dashboard_segment.py 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. """Validated exact dashboard selections; independent of navigation and authentication."""
  2. from datetime import date, timedelta
  3. import json
  4. VIEWS = ('Altersstaffel', 'Standort', 'Verursacher', 'Wiedervorlage')
  5. DASHBOARD_VIEWS = VIEWS[:-1] # Old Wiedervorlage list selections remain valid.
  6. def _date_key(key):
  7. if key is None:
  8. return
  9. if not isinstance(key, dict) or set(key) != {'from', 'to'} or not any(key.values()):
  10. raise ValueError('Ungültiger Datumsfilter')
  11. for value in key.values():
  12. if value is not None and (not isinstance(value, str) or date.fromisoformat(value).isoformat() != value):
  13. raise ValueError('Ungültiges Datum')
  14. if key['from'] and key['to'] and key['from'] > key['to']:
  15. raise ValueError('Ungültiger Zeitraum')
  16. if key['to'] == '9999-12-31':
  17. raise ValueError('Zeitraum außerhalb des unterstützten Bereichs')
  18. def _value(value):
  19. if value is not None and (not isinstance(value, str) or len(value) > 500
  20. or any(ord(char) < 32 or ord(char) == 127 or 0xd800 <= ord(char) <= 0xdfff for char in value)):
  21. raise ValueError('Ungültiger Gruppenschlüssel')
  22. def parse_segment(raw):
  23. if not raw:
  24. return None
  25. if not isinstance(raw, str) or len(raw) > 4096:
  26. raise ValueError('Ungültiger Dashboardfilter')
  27. try:
  28. segment = json.loads(raw)
  29. except (ValueError, TypeError, RecursionError) as error:
  30. raise ValueError('Ungültiger Dashboardfilter') from error
  31. if (not isinstance(segment, dict) or set(segment) - {'view', 'key', 'department', 'only_invoices', 'follow_up'}
  32. or not {'view', 'key'} <= set(segment) or segment['view'] not in VIEWS):
  33. raise ValueError('Ungültiger Dashboardfilter')
  34. key, view = segment['key'], segment['view']
  35. if 'only_invoices' in segment and type(segment['only_invoices']) is not bool:
  36. raise ValueError('Ungültiger Rechnungsfilter')
  37. if 'department' in segment:
  38. _value(segment['department'])
  39. if 'follow_up' in segment:
  40. _date_key(segment['follow_up'])
  41. if view == 'Altersstaffel':
  42. _value(key)
  43. elif view == 'Standort':
  44. if not isinstance(key, dict) or set(key) != {'client', 'site'} or not key['client']:
  45. raise ValueError('Ungültiger Standortfilter')
  46. _value(key['client']); _value(key['site'])
  47. elif view == 'Verursacher':
  48. if not isinstance(key, dict) or set(key) not in ({'id'}, {'text'}):
  49. raise ValueError('Ungültiger Verursacherfilter')
  50. _value(next(iter(key.values())))
  51. if 'id' in key and not key['id']:
  52. raise ValueError('Benutzer-ID fehlt')
  53. else:
  54. _date_key(key)
  55. return segment
  56. def pack_segment(segment):
  57. return json.dumps(segment, ensure_ascii=False, sort_keys=True, separators=(',', ':'))
  58. def segment_sql(segment):
  59. clauses, values = [], {}
  60. def dates(key, prefix):
  61. if key is None:
  62. clauses.append('F.[Wiedervorlage] IS NULL')
  63. return
  64. if key['from']:
  65. clauses.append(f'F.[Wiedervorlage] >= :{prefix}_from')
  66. values[prefix + '_from'] = key['from']
  67. if key['to']:
  68. clauses.append(f'F.[Wiedervorlage] < :{prefix}_until')
  69. values[prefix + '_until'] = (date.fromisoformat(key['to']) + timedelta(days=1)).isoformat()
  70. def exact(column, value, parameter):
  71. if value is None or value == '':
  72. clauses.append(f"NULLIF(F.[{column}], '') IS NULL")
  73. else:
  74. clauses.append(f'F.[{column}] = :{parameter}')
  75. values[parameter] = value
  76. key, view = segment['key'], segment['view']
  77. if view == 'Altersstaffel':
  78. exact('Staffel_Text', key, 'ds_age')
  79. elif view == 'Standort':
  80. exact('Client_DB', key['client'], 'ds_client')
  81. exact('Standort_ID', key['site'], 'ds_site')
  82. elif view == 'Verursacher':
  83. if 'id' in key:
  84. exact('Verursacher_Benutzer_ID', key['id'], 'ds_person')
  85. else:
  86. exact('Verursacher_Benutzer_ID', None, 'ds_person')
  87. exact('Verursacher_Text', key['text'], 'ds_person_text')
  88. else:
  89. dates(key, 'ds')
  90. if 'follow_up' in segment:
  91. dates(segment['follow_up'], 'ds_follow')
  92. if 'department' in segment:
  93. exact('Abteilung', segment['department'], 'ds_department')
  94. if segment.get('only_invoices'):
  95. exact('Rechnung_Gutschrift', 'Rechnung', 'ds_invoice_type')
  96. return clauses, values
  97. def segment_label(segment, rows=()):
  98. key, view = segment['key'], segment['view']
  99. sample = rows[0] if rows else {}
  100. if view == 'Altersstaffel':
  101. label = key or 'Ohne Altersstaffel'
  102. elif view == 'Standort':
  103. label = f"{sample.get('Standort_Name') or 'Standort'} · {key['site'] or 'ohne ID'} ({sample.get('Hauptbetrieb_Name') or 'Mandant ' + key['client']})"
  104. elif view == 'Verursacher':
  105. label = sample.get('Verursacher_Text') or key.get('id') or key.get('text') or 'Ohne Verursacher'
  106. if key.get('id') and label != key['id']:
  107. label += ' (' + key['id'] + ')'
  108. elif key is None:
  109. label = 'Ohne Datum'
  110. else:
  111. fmt = lambda value: date.fromisoformat(value).strftime('%d.%m.%Y')
  112. if key['from'] == key['to']:
  113. label = 'Am ' + fmt(key['from'])
  114. else:
  115. label = ' / '.join(filter(None, ['Ab ' + fmt(key['from']) if key['from'] else '',
  116. 'Bis ' + fmt(key['to']) if key['to'] else '']))
  117. text = f'{view}: {label}'
  118. if 'department' in segment:
  119. text += ' · Abteilung: ' + (segment['department'] or 'Ohne Abteilung')
  120. if segment.get('only_invoices'):
  121. text += ' · Nur Rechnungen'
  122. if 'follow_up' in segment:
  123. period = segment['follow_up']
  124. if period is None:
  125. text += ' · Wiedervorlage: Ohne Datum'
  126. else:
  127. fmt = lambda value: date.fromisoformat(value).strftime('%d.%m.%Y')
  128. text += ' · Wiedervorlage: ' + ' / '.join(filter(None, [
  129. 'Ab ' + fmt(period['from']) if period['from'] else '',
  130. 'Bis ' + fmt(period['to']) if period['to'] else '']))
  131. return text