Skip to content

Add PALKINTOSIJA aggregation table parity to public kokeet listing #313

Description

@asku1990

The old v1 KOKEET kalenterivuosittain page also contains a separate PALKINTOSIJA kpl(%) aggregation table. The current v2 public trials pages do not mirror this section.

Please inspect the old v1 implementation before changing anything:

  • ../beagleAppV1/hallinta/ad_kokeetall.php
  • any helper/query used to build the PALKINTOSIJA breakdown

What to verify in v1:

  • The section title is P A L K I N T O S I J A kpl(%).
  • The table is grouped by Koemuoto.
  • Columns are 1, 2, 3, 0, L, S, Palk, and Yht.
  • The rows include at least Yksipäiväinen and Kahden viikon.
  • The values are percentages and totals derived from the old aggregation logic.

Implementation goal:

  • Add this aggregation table to the v2 public kokeet listing if we want full parity with the old page.
  • Keep the block separate from the per-trial row list and from the YHTEENVETO block.
  • Reuse existing data structures or summary queries if possible.

Suggested acceptance criteria:

  • The public listing renders a PALKINTOSIJA summary table.
  • Grouping by Koemuoto matches the old v1 behavior.
  • The result columns and totals are present and correctly labeled.
  • Add/update tests for the aggregation output and any supporting data computation.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions