Database: tap2park_sandbox (17 tp2_ tables found) ═══════════════════════════════════════════════════════════ TAP2PARK 2.0 — OFFER ENGINE TEST SUITE Connected to tap2park_sandbox ═══════════════════════════════════════════════════════════ SCENARIO A: Immediate 2:00 PM Tuesday (Premium Zone 30000) ──────────────────────────────────────────────────────────── Cursor: 2026-02-17 14:00:00 | Future: YES | Extension: no Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 20 Minutes $3.00 $3.00 Tue 2:20 PM 2 20 Minutes $3.00 $6.00 Tue 2:40 PM 3 20 Minutes $3.00 $9.00 Tue 3:00 PM 4 20 Minutes $3.00 $12.00 Tue 3:20 PM 5 20 Minutes $3.00 $15.00 Tue 3:40 PM 6 20 Minutes $3.00 $18.00 Tue 4:00 PM 7 20 Minutes $3.00 $21.00 Tue 4:20 PM 8 20 Minutes $3.00 $24.00 Tue 4:40 PM 9 Daily Max Out by 6PM $1.00 $25.00 Tue 6:00 PM Max rate applied 10 20 Minutes $3.00 $28.00 Tue 8:40 PM 11 20 Minutes $3.00 $31.00 Tue 9:00 PM 12 Evening Max - Out by 6AM $2.00 $33.00 Wed 6:00 AM Max rate applied Fee breakdown (final): parking=$33.00 + convenience=$0.58 + tax=$0.00 = total=$33.58 EXPECTED: 8 increments ($3 each → $24), Daily Max ($25), eve increments, Eve Max ($33) SCENARIO B: Immediate 5:45 PM Tuesday (max cutoff) ──────────────────────────────────────────────────────────── Cursor: 2026-02-17 17:45:00 | Future: YES | Extension: no Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 20 Minutes $3.00 $3.00 Tue 6:05 PM 2 20 Minutes $3.00 $6.00 Tue 6:25 PM 3 20 Minutes $3.00 $9.00 Tue 6:45 PM 4 20 Minutes $3.00 $12.00 Tue 7:05 PM 5 20 Minutes $3.00 $15.00 Tue 7:25 PM 6 20 Minutes $3.00 $18.00 Tue 7:45 PM 7 20 Minutes $3.00 $21.00 Tue 8:05 PM 8 20 Minutes $3.00 $24.00 Tue 8:25 PM 9 20 Minutes $3.00 $27.00 Tue 8:45 PM 10 Evening Max - Out by 6AM $1.00 $28.00 Wed 6:00 AM Max rate applied Fee breakdown (final): parking=$28.00 + convenience=$0.50 + tax=$0.00 = total=$28.50 EXPECTED: Increments + Eve Max at $28 (cross-window lookahead, 17:40-18:00 bracket) SCENARIO C: Immediate 8:10 AM Tuesday (early bird) ──────────────────────────────────────────────────────────── Cursor: 2026-02-17 08:10:00 | Future: YES | Extension: no Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 Daily Max Out by 6PM $34.00 $34.00 Tue 6:00 PM Max rate applied Fee breakdown (final): parking=$34.00 + convenience=$0.60 + tax=$0.00 = total=$34.60 EXPECTED: Daily Max $34 (early bird bracket at 08:10), then eve transition SCENARIO D: Immediate 10:00 PM Tuesday ──────────────────────────────────────────────────────────── Cursor: 2026-02-17 22:00:00 | Future: YES | Extension: no Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 20 Minutes $3.00 $3.00 Tue 10:20 PM 2 20 Minutes $3.00 $6.00 Tue 10:40 PM 3 20 Minutes $3.00 $9.00 Tue 11:00 PM 4 Evening Flat - Out by 6AM $1.00 $10.00 Wed 6:00 AM Flat rate applied 5 Daily Max Out by 6PM $24.00 $34.00 Wed 6:00 PM Max rate applied Fee breakdown (final): parking=$34.00 + convenience=$0.60 + tax=$0.00 = total=$34.60 EXPECTED: 3 increments to 11PM ($9), then Eve Flat ($10 until 6AM) SCENARIO E: Extension from 3:00 PM, customer at 2:30 PM ──────────────────────────────────────────────────────────── Cursor: 2026-02-17 15:00:00 | Future: YES | Extension: YES Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 20 Minutes $3.00 $3.00 Tue 3:20 PM 2 20 Minutes $3.00 $6.00 Tue 3:40 PM 3 20 Minutes $3.00 $9.00 Tue 4:00 PM 4 20 Minutes $3.00 $12.00 Tue 4:20 PM 5 20 Minutes $3.00 $15.00 Tue 4:40 PM 6 20 Minutes $3.00 $18.00 Tue 5:00 PM 7 20 Minutes $3.00 $21.00 Tue 5:20 PM 8 20 Minutes $3.00 $24.00 Tue 5:40 PM 9 Daily Max Out by 6PM $1.00 $25.00 Tue 6:00 PM Max rate applied 10 20 Minutes $3.00 $28.00 Tue 8:40 PM 11 20 Minutes $3.00 $31.00 Tue 9:00 PM 12 Evening Max - Out by 6AM $2.00 $33.00 Wed 6:00 AM Max rate applied Fee breakdown (final): parking=$33.00 + convenience=$0.58 + tax=$0.00 = total=$33.58 EXPECTED: cursor=15:00, offers start from 3:20 PM SCENARIO F: Future-dated buy Wed for Sat 9:00 AM ──────────────────────────────────────────────────────────── Cursor: 2026-02-21 09:00:00 | Future: YES | Extension: no Zone: Premium Zone (30000) | Lot: 162 Cumberland Street ────────────────────────────────────────────────────────── Tap Action +Cost Total Park Until Reason ────────────────────────────────────────────────────────── 1 Daily Max Out by 6PM $25.00 $25.00 Sat 6:00 PM Max rate applied 2 Daily Max Out by 6PM $9.00 $34.00 Mon 6:00 PM Max rate applied Fee breakdown (final): parking=$34.00 + convenience=$0.60 + tax=$0.00 = total=$34.60 EXPECTED: Saturday rates, is_future_dated=true SCENARIO G: Event pre-purchase (skipped unless overlay exists) ────────────────────────────────────────────────────────────