Skip to content

123 — should export SPP with soupis data

Description

Exports SPP (summary of payments) to Excel; verifies file contains per-soupis columns with correct quantities, prices and a Rekapitulace aggregate.

Preconditions

  • Clean database
  • User logged in with ADMIN and ACCOUNTING roles
  • Excel file with budget data available
  • Project, budget and budget sheet created (from Excel, range B23:G58)

Steps

  1. Create and fill Leden 2025 (Ochrana=1, SDK=1, Penetrace=41.6) — Expected: First soupis filled
  2. Create and fill Únor 2025 (SDK=3, Zaokrouhlení=1) — Expected: Second soupis filled
  3. Export SPP and parse workbook — Expected: Headers include both soupis names + Rekapitulace
  4. Assert per-item cells — Expected: Leden=1/5 000, Únor=3/4 740, Rekapitulace=4/6 320 for SDK; rounding row carries negative price where expected
  • Spec: tests/e2e/tests/budgets.spec.ts