"""Aggregate authorized invoices by rubric and selectable stack dimension.""" import hashlib from collections import Counter from datetime import datetime from decimal import Decimal from zoneinfo import ZoneInfo from .dashboard_segment import DASHBOARD_VIEWS, pack_segment from .forderung_data import read_invoices from .jinja_templates import number_format from .navigation import list_url from .query_filter import EMPTY_FILTER_VALUE, encode_filter_values BERLIN = ZoneInfo("Europe/Berlin") STACKS = ("abteilung", "wiedervorlage") def _key(value): return None if value is None or str(value) == "" else str(value) def color(department): hue = int.from_bytes(hashlib.sha256((department or "").encode()).digest()[:2], "big") % 360 return f"hsl({hue}, 23%, 70%)" FOLLOW_UP_COLORS = { "überfällig": "#d4aaaa", "in 3 tagen fällig": "#e0cd9c", "noch nicht fällig": "#b4c5b5", "zurückgestellt": "#b2bccd", } def _url(view, key, segment=..., only_invoices=False, stack="abteilung"): filters = {} def select(name, value): filters[name] = encode_filter_values([EMPTY_FILTER_VALUE if value is None or value == "" else value]) if view == "Standort": select("Mandant", key["client"]) select("Filiale", key["site"]) elif view == "Altersstaffel": select("Staffel", key) elif view == "Verursacher": select("Verursacher", key["text"]) if segment is not ... and stack == "abteilung": select("Abteilung", segment) if segment is not ... and stack == "wiedervorlage": select("WVStaffel", segment) if only_invoices: select("RechnungGutschrift", "Rechnung") return list_url(filters) def build_dashboard(db, username, now=None, only_invoices=False, stack="abteilung"): if stack not in STACKS: raise ValueError("Ungültige Stapelung") now = now or datetime.now(BERLIN) if only_invoices: columns, source = read_invoices( db, username, ["F.[Rechnung_Gutschrift] = :dashboard_invoice_type"], {"dashboard_invoice_type": "Rechnung"} ) else: columns, source = read_invoices(db, username) groups = {view: {} for view in DASHBOARD_VIEWS} total, departments, stages = Decimal(0), set(), {} for values in source: row = dict(zip(columns, values)) department = _key(row.get("Abteilung")) departments.add(department) if stack == "abteilung": segment_id = department else: # The shared list projection owns the classification, including the # 21-day deferred boundary. Use its key for an exact WVStaffel link. segment_id = _key(row["Wiedervorlage_Staffel_Nr"]) label = _key(row["Wiedervorlage_Staffel_Text"]) stages.setdefault(segment_id, dict( id=segment_id, label=label or (f"WV-Staffel {segment_id}" if segment_id is not None else "Ohne WV-Staffel"), color=FOLLOW_UP_COLORS.get((label or "").casefold(), color(segment_id)) if segment_id is not None else "#c5c5c5", key=segment_id, )) amount = Decimal(str(row["Beleg_Offen"] or 0)) total += amount age = _key(row.get("Staffel_Text")) site = {"client": str(row["Client_DB"]), "site": _key(row.get("Standort_ID"))} person_name = _key(row.get("Verursacher_Text")) person = {"text": person_name} definitions = [ ( "Altersstaffel", age, age or "Ohne Altersstaffel", int(row["Beleg_Tage_offen"]) if age and row.get("Beleg_Tage_offen") is not None else 10**12, ), ( "Standort", site, f"{row.get('Standort_Name') or site['site'] or 'Ohne Standort'} ({row.get('Hauptbetrieb_Name') or 'Mandant ' + site['client']})", 0, ), ("Verursacher", person, person_name or "Ohne Verursacher", 0), ] for view, key, label, order in definitions: identity = pack_segment(key) group = groups[view].setdefault( identity, dict(key=key, label=label, order=order, count=0, amount=Decimal(0), segments={}) ) group["order"] = min(group["order"], order) group["count"] += 1 group["amount"] += amount segment = group["segments"].setdefault(segment_id, dict(count=0, amount=Decimal(0))) segment["count"] += 1 segment["amount"] += amount items = ( [ dict(id=dep, label=dep or "Ohne Abteilung", color=color(dep), key=dep) for dep in sorted(departments, key=lambda value: (value is None, value or "")) ] if stack == "abteilung" else sorted(stages.values(), key=lambda item: (item["key"] is None, Decimal(item["key"] or "0"))) ) def serialized(amount): return str(amount.quantize(Decimal("0.01"))) output = {} for view, mapping in groups.items(): result = [] labels = Counter(group["label"].casefold() for group in mapping.values()) for group in mapping.values(): label = group["label"] if labels[label.casefold()] > 1: if view == "Standort": label += " · Standort-ID " + (group["key"]["site"] or "ohne ID") segments = [ dict( id=item["id"], department=item["id"] if stack == "abteilung" else None, label=item["label"], count=group["segments"][item["id"]]["count"], amount=serialized(group["segments"][item["id"]]["amount"]), color=item["color"], url=_url(view, group["key"], item["key"], only_invoices, stack), ) for item in items if item["id"] in group["segments"] ] result.append( dict( label=label, order=group["order"], count=group["count"], amount=serialized(group["amount"]), segments=segments, url=_url(view, group["key"], only_invoices=only_invoices), ) ) output[view] = result return dict( count=len(source), amount=serialized(total), amount_display=number_format(total), views=output, only_invoices=only_invoices, stack=stack, stack_label="Abteilung" if stack == "abteilung" else "Wiedervorlage", stack_items=[{name: value for name, value in item.items() if name != "key"} for item in items], generated=now.astimezone(BERLIN).strftime("%d.%m.%Y %H:%M"), )