"""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