20-modules/trip-planner/overview.md

Module: Trip Planner (`trip_planner` / —)

Status: 🟡 Partially implemented (built; zero throughput) · Last validated: 2026-09-06 · Priority: P2

A wizard that plans trips and matches stays/experiences (integrates with StayGo tripPlannerMatch). Validated against triplanner.php, trip_wizard.php + schema.

A. Purpose

Users plan multi-stop trips (itinerary + preferences) and get matched supply. No commission model defined; not on the dashboard command center.

C. Entry points

/trip_wizard.php, /tripmanager.php, /triplanner.php.

E. Feature registry (prefix `TRIP-`)

ID	Feature	Tables	Status
TRIP-001	Trip wizard	`trip_wizard_submissions`	🟢
TRIP-002	Trip plan + items	`trip_plans` (0), `trip_plan_items`	🟡
TRIP-003	Preferences	`trip_plan_preferences`	🟡
TRIP-004	Collaborators / share	`trip_plan_collaborators`, `trip_shares`	🟡
TRIP-005	Stay match	StayGo `HotelModule::tripPlannerMatch` `:2712`	🟢

G. Data model (2026-09-06)

Table	Rows	Note
`trip_plans`	0	zero plans exist right now
`trip_plan_items`	0
`trip_plan_preferences`	6	orphaned — see note below
`trip_plan_collaborators`	0
`trip_shares`	0
`trip_wizard_submissions`	0

Correction (2026-09-06): trip_plan_preferences is not empty — it holds 6 rows (trip_plan_id 69, 70, 76, 77, 78, 79; datecreated 2026-08-26) referencing trip_plan_id values that no longer exist in trip_plans (which is 0 rows). This means the feature was exercised on 2026-08-26 (at least ~79 trip plans were created up to that point) and trip_plans / trip_plan_items were since wiped (QA reset or similar) without clearing the dependent trip_plan_preferences rows. "Zero throughput" below describes the current DB snapshot, not the feature's history — flag this orphan-row / missing-cascade pattern for engineering if a clean reset is expected (trip_plan_preferences has no FK enforcing cleanup here).

Status note

trip_plans = 0 right now — no live plans — but the orphaned trip_plan_preferences rows above show the wizard has been used at least once (2026-08-26) before a reset cleared trip_plans. Absent from the dashboard command center: confirmed via incfiles/dashboard/_cc_config.php (KV_CC_TILES/KV_CC_TILE_MODULE, 2026-09-06) — no tile with key trip/triplanner exists in that registry (36 tiles checked), unlike startup_passport which does have one ('startup' tile, programs band).

Dependencies / change-impact

Depends on StayGo (tripPlannerMatch), location/search. Change-impact: low (unused); wiring a booking handoff to StayGo would activate it.

Module: Trip Planner (trip_planner / —)