Package su.onno.ui

Class RegisterQueryService

java.lang.Object

su.onno.ui.RegisterQueryService

public class RegisterQueryService
extends Object

Read-side queries for accumulation registers (movements, balance, turnover), shared by the REST API and the DivKit emitters. Pure data access — access control stays with the callers.

Constructor Summary

Constructors

Constructor	Description
RegisterQueryService(MetadataRegistry registry, org.jdbi.v3.core.Jdbi jdbi)

Method Summary

Modifier and Type	Method	Description
List<Map<String,Object>>	balance(AccumulationRegisterDescriptor desc, Map<String,String> filters)
long	balanceCount(AccumulationRegisterDescriptor desc, ListFilter.Result filters)	Balance rows (distinct dimension combinations) matching the filters — for the scroller.
Set<String>	balanceFilterColumns(AccumulationRegisterDescriptor desc)	The columns a balance filter may reference — for ListFilter.parse(java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.Set<java.lang.String>).
List<Map<String,Object>>	balanceWindow(AccumulationRegisterDescriptor desc, ListFilter.Result filters, String sortColumn, boolean descending, int rowPosition, int windowSize)	One window of current balances (the materialized totals table) for the virtualized island, ordered by a validated column (default: the dimension tuple) and bounded by a start position and window size.
Set<String>	movementFilterColumns(AccumulationRegisterDescriptor desc)	The columns a movements filter may reference — for ListFilter.parse(java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.Set<java.lang.String>).
List<Map<String,Object>>	movements(AccumulationRegisterDescriptor desc, String from, String to)
long	movementsCount(AccumulationRegisterDescriptor desc, String from, String to, ListFilter.Result filters)	Total active movements matching the window + filters — for the island's virtual scroller.
List<Map<String,Object>>	movementsWindow(AccumulationRegisterDescriptor desc, String from, String to, ListFilter.Result filters, String sortColumn, boolean descending, int rowPosition, int windowSize)	One window of movements for the virtualized register island — server-side ordered by a validated column (default _period DESC), narrowed by the grid's declarative filters (the same eq/in/like/prefix/ge/le grammar as ListFilter compiles for catalog/document lists) and bounded by a start position and window size, so a packed register never ships its whole movement log.
AccumulationRegisterDescriptor	require(String name)
BigDecimal	total(AccumulationRegisterDescriptor desc, String resourceField, String from, String to, String filter)	A single summed resource across a register — the KPI/metric-card counterpart to turnover(su.onno.metadata.AccumulationRegisterDescriptor, java.lang.String, java.lang.String, java.util.Map<java.lang.String, java.lang.String>).
List<Map<String,Object>>	turnover(AccumulationRegisterDescriptor desc, String from, String to, Map<String,String> filters)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RegisterQueryService

public RegisterQueryService(MetadataRegistry registry,
 org.jdbi.v3.core.Jdbi jdbi)

Method Details

require

public AccumulationRegisterDescriptor require(String name)

movements

public List<Map<String,Object>> movements(AccumulationRegisterDescriptor desc,
 String from,
 String to)

movementsWindow

public List<Map<String,Object>> movementsWindow(AccumulationRegisterDescriptor desc,
 String from,
 String to,
 ListFilter.Result filters,
 String sortColumn,
 boolean descending,
 int rowPosition,
 int windowSize)

One window of movements for the virtualized register island — server-side ordered by a validated column (default _period DESC), narrowed by the grid's declarative filters (the same eq/in/like/prefix/ge/le grammar as ListFilter compiles for catalog/document lists) and bounded by a start position and window size, so a packed register never ships its whole movement log. Refs are resolved like movements(su.onno.metadata.AccumulationRegisterDescriptor, java.lang.String, java.lang.String).

movementsCount

public long movementsCount(AccumulationRegisterDescriptor desc,
 String from,
 String to,
 ListFilter.Result filters)

Total active movements matching the window + filters — for the island's virtual scroller.

movementFilterColumns

public Set<String> movementFilterColumns(AccumulationRegisterDescriptor desc)

The columns a movements filter may reference — for ListFilter.parse(java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.Set<java.lang.String>).

balanceFilterColumns

public Set<String> balanceFilterColumns(AccumulationRegisterDescriptor desc)

The columns a balance filter may reference — for ListFilter.parse(java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.List<java.lang.String>, java.util.Set<java.lang.String>).

balanceWindow

public List<Map<String,Object>> balanceWindow(AccumulationRegisterDescriptor desc,
 ListFilter.Result filters,
 String sortColumn,
 boolean descending,
 int rowPosition,
 int windowSize)

One window of current balances (the materialized totals table) for the virtualized island, ordered by a validated column (default: the dimension tuple) and bounded by a start position and window size. BALANCE registers only.

balanceCount

public long balanceCount(AccumulationRegisterDescriptor desc,
 ListFilter.Result filters)

Balance rows (distinct dimension combinations) matching the filters — for the scroller.

balance

public List<Map<String,Object>> balance(AccumulationRegisterDescriptor desc,
 Map<String,String> filters)

turnover

public List<Map<String,Object>> turnover(AccumulationRegisterDescriptor desc,
 String from,
 String to,
 Map<String,String> filters)

total

public BigDecimal total(AccumulationRegisterDescriptor desc,
 String resourceField,
 String from,
 String to,
 String filter)

A single summed resource across a register — the KPI/metric-card counterpart to turnover(su.onno.metadata.AccumulationRegisterDescriptor, java.lang.String, java.lang.String, java.util.Map<java.lang.String, java.lang.String>). Restricted to active movements, narrowed by an optional period window and a safe filter predicate (see WidgetFilter). The resource field must be one of the register's resources, so it can never carry arbitrary SQL.