pas.views.abschlussliste

Classes

BookingRowData

dict() -> new empty dictionary

Functions

get_party_lookup(→ dict[str, ...)	Bulk fetch party information for parliamentarians during a period.
get_abschlussliste_data(→ list[dict[str, Any]])
generate_abschlussliste_xlsx(→ io.BytesIO)
generate_buchungen_abrechnungslauf_xlsx(→ io.BytesIO)	Generate XLSX export for 'Buchungen Abrechnungslauf' with individual

Module Contents

class pas.views.abschlussliste.BookingRowData

Bases: TypedDict

dict() -> new empty dictionary dict(mapping) -> new dictionary initialized from a mapping object’s

(key, value) pairs

dict(iterable) -> new dictionary initialized as if via:

d = {} for k, v in iterable:

d[k] = v

dict(**kwargs) -> new dictionary initialized with the name=value pairs

in the keyword argument list. For example: dict(one=1, two=2)

date: BookingRowData.date

person: str

party: str

wahlkreis: str

booking_type: str

value: decimal.Decimal

chf: decimal.Decimal

chf_with_cola: decimal.Decimal

pas.views.abschlussliste.get_party_lookup(session: sqlalchemy.orm.Session, parliamentarian_ids: set[str], start_date: datetime.date, end_date: datetime.date) → dict[str, onegov.pas.models.party.Party | None]

Bulk fetch party information for parliamentarians during a period. Returns a lookup dictionary to avoid N+1 queries.

pas.views.abschlussliste.get_abschlussliste_data(settlement_run: onegov.pas.models.settlement_run.SettlementRun, request: onegov.town6.request.TownRequest) → list[dict[str, Any]]

pas.views.abschlussliste.generate_abschlussliste_xlsx(settlement_run: onegov.pas.models.settlement_run.SettlementRun, request: onegov.town6.request.TownRequest) → io.BytesIO

pas.views.abschlussliste.generate_buchungen_abrechnungslauf_xlsx(settlement_run: onegov.pas.models.settlement_run.SettlementRun, request: onegov.town6.request.TownRequest) → io.BytesIO

Generate XLSX export for ‘Buchungen Abrechnungslauf’ with individual booking entries.

Creates an Excel file with columns: - Datum: Date of attendance - Person: Full name of parliamentarian - Partei: Party name - Wahlkreis: Electoral district (TODO: determine data source) - BuchungsTyp: Type of attendance/booking - Wert: Duration/value in hours - CHF: Base rate in CHF - CHF + TZ: Rate with cost-of-living adjustment in CHF

Data is sorted by date then person name.