← back to index

U10 — Session History filteringLOCAL

Notion test-run #3 doc item #6 ("To add more filtering controls for Session History"). Adds preset chips (Today / This Week / This Month / Last 3 Months / This Year / All) + Custom date range + Shop multi-select to /cafe/pos/sessions. Default preset = "All" preserves the prior no-date-filter UX. Matches Odoo 17's POS Sessions list filter pattern.

Summary

Status: 6/6 local · typecheck clean · awaiting Gate 1 approval
Repo: nix-cafe only — no migration, no backend, no schema
Files: 4 modified · ~250 LOC net
URL state: ?preset=&from=&to=&shop=id1,id2®ister=&page= — paste-friendly, deep-linkable, page resets on filter change

What ships

MOD lib/reports/period.ts — PresetKey gains 3 entries (last_3_months, this_year, all); resolveReportPeriod handles each. New isUnfilteredPreset() helper lets callers skip the date constraint server-side when preset = "all".
MOD lib/db/cafe_sessions.ts — listSessions DAO gains optional fromUtc + toUtc params applied via gte/lte on opened_at. Tenant scope + existing shop/config filters unchanged.
MOD app/(authed)/pos/sessions/page.tsx — reads shop/preset/from/to URL params, scopes shopIds via multi-select (out-of-scope IDs dropped server-side), resolves the period in tenant timezone, skips the date filter when preset = "all".
MOD app/(authed)/pos/sessions/sessions-client.tsx — FilterBar with 7 preset chips (6 from spec + Custom), custom from/to date inputs shown only when preset = "custom", Shop multi-select (hidden on single-shop tenants), Register dropdown stays, Reset filters button. New inline ShopMultiSelect with outside-click + Escape close.

Behavior notes

Default preset = "All" — first-load shows everything (no surprise vs current UX).
"All" preset skips the date filter at the SQL layer — not a wide-window query; isUnfilteredPreset() returns true and the page passes undefined to the DAO.
Shop multi-select hidden on single-shop tenants — out of 3 prod tenants, all 3 are currently single-shop ([[project_prod_tenants_all_single_shop]]); UI tested on local lumiere with synthetic 2nd shop or visually hidden as expected.
Filter changes reset page to 1 — pagination href preserves all other filter params via the unified buildQs() helper.
Out-of-scope shop IDs in URL are dropped server-side — admin can't escalate via URL hacking.

6/6 local checks ✓

✓	period.ts: 3 new presets in PresetKey + PRESET_LABELS + PRESET_ORDER; isUnfilteredPreset helper exported
✓	period.ts runtime: resolveReportPeriod("last_3_months") on 2026-05-27 → 2026-02-27 → 2026-05-27 (calendar-month math via Date arithmetic); "this_year" → 2026-01-01; "all" → 1970-01-01 sentinel; isUnfilteredPreset only true for "all"
✓	listSessions: signature gains fromUtc + toUtc; applied via gte/lte on cafeSessions.openedAt
✓	page.tsx: reads searchParams.{shop,preset,from,to}; calls resolveReportPeriod + isUnfilteredPreset; skipDateFilter ternary on DAO call; scopedShopIds derived from URL ∩ accessible shops
✓	sessions-client.tsx: 11 literal FilterBar testids + 7 preset chip slugs in SESSION_PRESETS + ShopMultiSelect component with outside-click + Escape close
✓	DAO probe on local lumiere: future-window (2099-01-01 → 2099-12-31) returns 0 sessions; wide-window (1970 → 2099) equals unfiltered count — confirms the filter clause is real, not a no-op

Typecheck: npx tsc --noEmit on nix-cafe → 0 errors.

Out of scope (followups)

Custom-range preset persistence across navigations — once admin picks Custom, the from/to inputs persist via URL but switching to another preset and back clears them. Acceptable for v1; can be improved with localStorage if asked.
Cashier/employee filter — Narong's spec didn't include it; mirror the same pattern when it's asked for.
State filter (open / reconciling / closed) — same.

Gate 2 plan

Commit nix-cafe (single-line message).
Push to karouna-dev → CF auto-deploy.
test-u10-prod.mjs on lumiere: SSO → /cafe/pos/sessions → preset chips fire correctly (click each, assert URL param + result subset) → Custom range → Shop dropdown opens + closes outside-click + selections survive reload → Reset clears all.
Regression sweep 51/51 (phase2-cafe-multishop solo).
Publish prod gallery.