| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144 |
- """Validated exact dashboard selections; independent of navigation and authentication."""
- from datetime import date, timedelta
- import json
- VIEWS = ('Altersstaffel', 'Standort', 'Verursacher', 'Wiedervorlage')
- DASHBOARD_VIEWS = VIEWS[:-1] # Old Wiedervorlage list selections remain valid.
- def _date_key(key):
- if key is None:
- return
- if not isinstance(key, dict) or set(key) != {'from', 'to'} or not any(key.values()):
- raise ValueError('Ungültiger Datumsfilter')
- for value in key.values():
- if value is not None and (not isinstance(value, str) or date.fromisoformat(value).isoformat() != value):
- raise ValueError('Ungültiges Datum')
- if key['from'] and key['to'] and key['from'] > key['to']:
- raise ValueError('Ungültiger Zeitraum')
- if key['to'] == '9999-12-31':
- raise ValueError('Zeitraum außerhalb des unterstützten Bereichs')
- def _value(value):
- if value is not None and (not isinstance(value, str) or len(value) > 500
- or any(ord(char) < 32 or ord(char) == 127 or 0xd800 <= ord(char) <= 0xdfff for char in value)):
- raise ValueError('Ungültiger Gruppenschlüssel')
- def parse_segment(raw):
- if not raw:
- return None
- if not isinstance(raw, str) or len(raw) > 4096:
- raise ValueError('Ungültiger Dashboardfilter')
- try:
- segment = json.loads(raw)
- except (ValueError, TypeError, RecursionError) as error:
- raise ValueError('Ungültiger Dashboardfilter') from error
- if (not isinstance(segment, dict) or set(segment) - {'view', 'key', 'department', 'only_invoices', 'follow_up'}
- or not {'view', 'key'} <= set(segment) or segment['view'] not in VIEWS):
- raise ValueError('Ungültiger Dashboardfilter')
- key, view = segment['key'], segment['view']
- if 'only_invoices' in segment and type(segment['only_invoices']) is not bool:
- raise ValueError('Ungültiger Rechnungsfilter')
- if 'department' in segment:
- _value(segment['department'])
- if 'follow_up' in segment:
- _date_key(segment['follow_up'])
- if view == 'Altersstaffel':
- _value(key)
- elif view == 'Standort':
- if not isinstance(key, dict) or set(key) != {'client', 'site'} or not key['client']:
- raise ValueError('Ungültiger Standortfilter')
- _value(key['client']); _value(key['site'])
- elif view == 'Verursacher':
- if not isinstance(key, dict) or set(key) not in ({'id'}, {'text'}):
- raise ValueError('Ungültiger Verursacherfilter')
- _value(next(iter(key.values())))
- if 'id' in key and not key['id']:
- raise ValueError('Benutzer-ID fehlt')
- else:
- _date_key(key)
- return segment
- def pack_segment(segment):
- return json.dumps(segment, ensure_ascii=False, sort_keys=True, separators=(',', ':'))
- def segment_sql(segment):
- clauses, values = [], {}
- def dates(key, prefix):
- if key is None:
- clauses.append('F.[Wiedervorlage] IS NULL')
- return
- if key['from']:
- clauses.append(f'F.[Wiedervorlage] >= :{prefix}_from')
- values[prefix + '_from'] = key['from']
- if key['to']:
- clauses.append(f'F.[Wiedervorlage] < :{prefix}_until')
- values[prefix + '_until'] = (date.fromisoformat(key['to']) + timedelta(days=1)).isoformat()
- def exact(column, value, parameter):
- if value is None or value == '':
- clauses.append(f"NULLIF(F.[{column}], '') IS NULL")
- else:
- clauses.append(f'F.[{column}] = :{parameter}')
- values[parameter] = value
- key, view = segment['key'], segment['view']
- if view == 'Altersstaffel':
- exact('Staffel_Text', key, 'ds_age')
- elif view == 'Standort':
- exact('Client_DB', key['client'], 'ds_client')
- exact('Standort_ID', key['site'], 'ds_site')
- elif view == 'Verursacher':
- if 'id' in key:
- exact('Verursacher_Benutzer_ID', key['id'], 'ds_person')
- else:
- exact('Verursacher_Benutzer_ID', None, 'ds_person')
- exact('Verursacher_Text', key['text'], 'ds_person_text')
- else:
- dates(key, 'ds')
- if 'follow_up' in segment:
- dates(segment['follow_up'], 'ds_follow')
- if 'department' in segment:
- exact('Abteilung', segment['department'], 'ds_department')
- if segment.get('only_invoices'):
- exact('Rechnung_Gutschrift', 'Rechnung', 'ds_invoice_type')
- return clauses, values
- def segment_label(segment, rows=()):
- key, view = segment['key'], segment['view']
- sample = rows[0] if rows else {}
- if view == 'Altersstaffel':
- label = key or 'Ohne Altersstaffel'
- elif view == 'Standort':
- label = f"{sample.get('Standort_Name') or 'Standort'} · {key['site'] or 'ohne ID'} ({sample.get('Hauptbetrieb_Name') or 'Mandant ' + key['client']})"
- elif view == 'Verursacher':
- label = sample.get('Verursacher_Text') or key.get('id') or key.get('text') or 'Ohne Verursacher'
- if key.get('id') and label != key['id']:
- label += ' (' + key['id'] + ')'
- elif key is None:
- label = 'Ohne Datum'
- else:
- fmt = lambda value: date.fromisoformat(value).strftime('%d.%m.%Y')
- if key['from'] == key['to']:
- label = 'Am ' + fmt(key['from'])
- else:
- label = ' / '.join(filter(None, ['Ab ' + fmt(key['from']) if key['from'] else '',
- 'Bis ' + fmt(key['to']) if key['to'] else '']))
- text = f'{view}: {label}'
- if 'department' in segment:
- text += ' · Abteilung: ' + (segment['department'] or 'Ohne Abteilung')
- if segment.get('only_invoices'):
- text += ' · Nur Rechnungen'
- if 'follow_up' in segment:
- period = segment['follow_up']
- if period is None:
- text += ' · Wiedervorlage: Ohne Datum'
- else:
- fmt = lambda value: date.fromisoformat(value).strftime('%d.%m.%Y')
- text += ' · Wiedervorlage: ' + ' / '.join(filter(None, [
- 'Ab ' + fmt(period['from']) if period['from'] else '',
- 'Bis ' + fmt(period['to']) if period['to'] else '']))
- return text
|