Platform-wide CRM dashboard

The window the range-scoped counters were actually computed over.

Echoed back rather than assumed, so the card can label itself ("oggi", "ultimo mese") from the response instead of from what the caller believed it asked for. Both ends are inclusive dates in Europe/Rome.

The headline counters — the top stat row of the dashboard.

Two kinds of counter live here and they answer different questions. The range-scoped ones count appointments whose datetime falls in the dashboard's period (today by default, or the from/to window the caller asked for). The point-in-time ones are a snapshot of the current state of the platform and ignore the period entirely — "patients at risk in March" is not a question the history can answer, so the period is not pretended to apply. Each field says which it is.

Work waiting on someone — the 'Da gestire' block.

Only the counters with an unambiguous source are here. The design also calls for reports gravi, comunicazioni, richieste BIA, fatture/rimborsi and mini équipe; each needs a state the schema does not currently carry (severity and a reviewed flag live inside multidisciplinary_reports.*_answers JSONB, and there is no "to verify" state on invoices or refunds), so they are left out rather than guessed at.

These are backlogs, not period counts: they answer "what is waiting right now", so from/to does not narrow them.

Open alerts platform-wide, newest first, capped by the route's alert_limit.