R1.5 — POSID-NNNNN daily sequence (prod)

pos_config_id | business_date          | next_seq | updated_at
--------------+------------------------+----------+---------------------------
           6  | 2026-04-22 (local PNH) |    3     | 2026-04-22T13:21:17.862Z

next_seq=3 means two orders were issued (1 and 2) with atomic advance. Each order's pos.order.name and pos_reference in Odoo carry the NIX-issued POS06-0001 / POS06-0002 — receipts print it, audit has it.

Loading…

Loading…

The order path was long-cold-code before R1.5 forced end-to-end exercise. Several fires revealed themselves during Gate 2 (in order of discovery):

• Raw db.execute shape mismatch — original advanceSequence returned different shapes via pg vs Hyperdrive. Switched to drizzle's typed insert().onConflictDoUpdate().returning(). Commit f33453c.
• Hyperdrive prepared-statement cache — the UPSERT silently returned no rows on the Worker path. Wrapped in db.transaction() to bypass the cache (same trick that fixed M3 and R1.1). Commit d1d5de1.
• Intl sv-SE locale — Cloudflare Workers only bundle a minimal Intl locale set. Switched businessDateForTimezone to en-US + formatToParts. Commit 886995a.
• Empty response body crashing client — res.json() was throwing on empty body with a cryptic parse error. Added outer try/catch on the route (always returns JSON) + safer client-side text() + parse(). Commit a7580f1, 0063238.
• ⭐ /api/... missing basePath (the real 405 root cause) — fetch("/api/odoo/order") resolves to host root, bypassing the Cafe Worker entirely and hitting the nix-router. Added /cafe prefix to all 6 client-side API fetches (register, team x3, customer-picker x2, pos-selector x2, order-actions). Commit dde4c60.
• Landing page showing "Closed" for open sessions — silent Odoo summary failure made every card default to state="none". Added per-config fallback using current_session_state already returned by fetchPosConfigs. Commit 886995a.
• Landing page showing $0 cash opening / sold today — NIX's cafe.sessions.beginning_cash wasn't being overlaid onto Odoo's stale cashbox value; Odoo's read_group was flaky through Hyperdrive. Switched sold-today to plain searchRead + client-side sum and added the NIX cash overlay. Commit 68688e9.

Takeaway: the Cafe production path through Hyperdrive is rich with surprises compared to local dev. Every new surface that touches DB-via-Hyperdrive now gets a transaction-wrap audit and a safer client JSON parser by default.