308 Commits

This Branch

This Branch

All Branches

Author	SHA1	Message	Date
Flea Flicker	a629331a04	Merge pull request 'Promote dev → uat: GRO-2359 clients-from-auth endpoint' (#213) from promote/GRO-2359-dev-to-uat into uat ... Promote dev → uat: GRO-2359 clients-from-auth endpoint (#213)	2026-06-11 16:44:52 +00:00
Flea Flicker	5363e1d5dc	feat(GRO-2359): add POST /api/portal/clients-from-auth for OOBE (web) ... The OOBE flow on the web portal calls this endpoint to create a fresh `clients` row bound to the Better Auth user's email when the SSO bridge returns 404. Returns 201 on success, 409 if a client with that email already exists (portal-selection case), 401/503 on auth issues, 400 on invalid body. The OOBE success path navigates the user back to `/` and lets the existing `session-from-auth` re-bridge; the new client is now resolvable by email, so the bridge mints a real portal session. Tests cover: 401 (no session), 400 (zod), 201 + persisted values (name trimmed, optional fields normalized to null), 409 (existing client or unique-constraint race), 503 (auth not configured). Paired with the web PR on `feature/2357-p2-sso-to-oobe-routing`. Co-Authored-By: Paperclip <noreply@paperclip.ing> (cherry picked from commit cdeebec021)	2026-06-11 16:35:26 +00:00
Flea Flicker	4cc51b32d3	Merge pull request 'Promote dev → uat: GRO-2342 portal waitlist service {id, name}' (#209) from promote/dev-to-uat-gro-2342 into uat	2026-06-10 09:24:53 +00:00
Flea Flicker	e932050b45	Promote dev → uat: GRO-2342 portal waitlist service {id, name} ... Resolves conflicts in UAT_PLAYBOOK.md, src/routes/portal.ts, and src/__tests__/portal.test.ts (dev side wins — GRO-2342 changes are the only diff in scope). Carries forward GRO-2139 reset.ts advisory lock + GRO-2294 infra mcp trigger that were merged to dev but not yet promoted to uat. - src/routes/portal.ts: GET /portal/appointments now populates service: {id, name} on both the synthetic waitlist card and the appointment card (was {id} only). Same shape, no portal change required. - src/__tests__/portal.test.ts: services mock + TC-API-8.20 GRO-2342 assertions on the synthetic waitlist card service name. - UAT_PLAYBOOK.md: TC-API-8.20 (GRO-2342) appended; TC-API-8.19 (GRO-2319) retained verbatim. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-10 09:17:15 +00:00
Flea Flicker	1d6b906202	Merge pull request 'fix(GRO-2342): portal waitlist card populates service {id, name}' (#208) from feat/GRO-2342-portal-waitlist-servicename into dev	2026-06-10 09:13:55 +00:00
Flea Flicker	277f459237	fix(GRO-2342): portal waitlist card populates service {id, name} ... Cosmetic follow-up to GRO-2319 (Phase 4 review by CTO). The synthetic waitlist card on GET /portal/appointments returned service: {id} only, so the portal fell back to the literal 'Service' label. CMPO spec did not call for a service name on the waitlist card, but populating the real name is non-urgent and closes the cosmetic gap. - src/routes/portal.ts: include a services SELECT (in addition to pets and staff) covering both appointment and waitlist serviceIds. serviceMap feeds a service.name lookup. The synthetic waitlist card's service object is now {id, name} — same shape the appointments join returns — so the portal renders the real name. The appointments join also gains a name (consistent shape, no regression for the existing path). - src/__tests__/portal.test.ts: mock the services table and assert service: {id, name} on both the synthetic waitlist card and the appointment card. - UAT_PLAYBOOK.md: TC-API-8.20 covering the waitlist card service name (TC-API-8.19 retained verbatim for the original GRO-2319 surfacing contract). Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-10 09:11:08 +00:00
Flea Flicker	18640908ed	feat(GRO-2319): dev→uat — portal waitlist surfacing + seed (api) (#205)	2026-06-09 11:04:16 +00:00
Flea Flicker	ef18ed7376	feat(GRO-2319): surface active waitlist entries on portal appointments + seed (#204)	2026-06-09 10:41:08 +00:00
Flea Flicker	807ccb455f	dev → uat: GRO-2311 seed portal StatusBadge appointments (#201) (#202)	2026-06-09 09:56:34 +00:00
Flea Flicker	d61607f4c5	feat(seed): seed upcoming appointments across statuses for UAT portal customer (GRO-2311) (#201)	2026-06-09 09:53:04 +00:00
Flea Flicker	c4385617c6	dev → uat: GRO-2172 extended pet fields (#200)	2026-06-09 09:22:12 +00:00
Flea Flicker	2853ce73a5	GRO-2172: add missing extended pet fields to create/update schemas (#199)	2026-06-09 08:56:22 +00:00
Flea Flicker	1e0747324d	fix(GRO-2139): serialize reset→migrate→seed under the seed advisory lock (#160) ... Serialize the entire db:reset chain (DROP → migrate → seed) inside one withSeedAdvisoryLock callback so a concurrent same-PRNG seeder cannot interleave and collide on invoices_pkey. Pool sized max:6 (1 reserved for the lock + work headroom) to avoid the connection-starvation deadlock the CTO caught. Verified with three end-to-end live db:reset runs against a throwaway Postgres. cc @cpfarhood	2026-06-09 08:44:58 +00:00
Flea Flicker	8cd5a2ef4d	dev → uat: GRO-2299 redact googleMapsApiKey from PATCH /api/admin/settings (#196)	2026-06-09 06:58:39 +00:00
Flea Flicker	b4b48f7b50	fix(GRO-2299): redact googleMapsApiKey from PATCH /api/admin/settings response (#195)	2026-06-09 06:52:48 +00:00
Flea Flicker	2566fb8f20	Promote GRO-2294 to UAT: Route Optimization security hardening (#194)	2026-06-09 06:27:17 +00:00
Flea Flicker	fe412933ea	GRO-2294: Route Optimization security hardening (geocode-batch limit cap + redact settings secret) (#193)	2026-06-09 06:17:42 +00:00
Lint Roller	4868f18dfd	Merge pull request 'Promote dev→uat: GRO-2225 + GRO-2235 + GRO-2157 (atomic)' (#188) from promote/dev-to-uat-gro-2225 into uat ... Promote dev→uat: GRO-2225 + GRO-2235 + GRO-2157 (atomic) QA-approved on 37e42b3. CI green (Test, Lint & Typecheck, Build & Push).	2026-06-09 00:26:18 +00:00
Flea Flicker	37e42b3104	ci: re-trigger checks (transient pnpm/action-setup runner flake) ... Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-09 00:21:03 +00:00
Flea Flicker	d617c69571	Merge remote-tracking branch 'origin/dev' into promote/dev-to-uat-gro-2225	2026-06-09 00:18:24 +00:00
Flea Flicker	cd2f60e282	feat(GRO-2157): navigation export endpoints (Phase 2.3) (#190)	2026-06-09 00:16:42 +00:00
Flea Flicker	6702086c7b	fix(GRO-2235): return 409 on duplicate portal waitlist submit (#189)	2026-06-08 23:50:21 +00:00
Flea Flicker	76d9850464	Promote dev→uat: GRO-2225 UAT seed route cohort + receptionist credential	2026-06-08 23:16:51 +00:00
Flea Flicker	27e6674b9a	feat(GRO-2225): UAT seed route cohort + receptionist credential (#187)	2026-06-08 23:15:51 +00:00
Flea Flicker	96dbb8c41d	Merge pull request 'Promote dev → uat: GRO-2155/2156/2203/2211/2163 + GRO-2234 (cumulative batch)' (#182) from flea/dev-to-uat-gro-2156 into uat	2026-06-08 19:42:25 +00:00
Flea Flicker	636fa713e1	Merge dev into uat: add GRO-2234 portal session sliding TTL + re-mint to dev→uat batch	2026-06-08 19:17:15 +00:00
Flea Flicker	aabedc8152	fix(GRO-2234): bounded sliding expiration for SSO portal sessions (#183)	2026-06-08 18:55:43 +00:00
Flea Flicker	6120b96c7c	Merge dev into uat: promote GRO-2156 route travel buffer + reorder (Phase 2.2) ... Resolves UAT_PLAYBOOK.md conflict by unioning uat-only TC-UAT-2/3 (GRO-2100) with dev's §4.16 update + new §4.17. Code files taken from dev (superset). Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-08 18:11:05 +00:00
Flea Flicker	ca62fb8ef6	feat(GRO-2156): travel buffer + reorder endpoint (Phase 2.2) (#180)	2026-06-08 18:07:54 +00:00
Flea Flicker	eb92f99c4a	dev → uat: GRO-2203 portal pet PATCH malformed-petId 500→404 (#178)	2026-06-08 17:53:01 +00:00
Flea Flicker	29c42e3130	fix(portal): validate waitlist preferredTime/preferredDate, return 400 on bad input (GRO-2211) (#179)	2026-06-08 17:19:39 +00:00
Flea Flicker	b842237425	fix(portal): GRO-2203 validate petId as UUID before PATCH lookup (500→404) (#177)	2026-06-08 17:03:44 +00:00
Flea Flicker	587fd4ec95	dev → uat: GRO-2155 route optimization endpoints (carries GRO-2163) (#176)	2026-06-08 16:45:44 +00:00
Flea Flicker	d0c0b1b646	feat(GRO-2155): route CRUD + optimization endpoint (Phase 2.1) (#175)	2026-06-08 13:57:07 +00:00
Flea Flicker	b9fc688769	fix(db): wait for/retry DB DNS resolution before drizzle-kit migrate (GRO-2163) (#161)	2026-06-08 13:37:30 +00:00
Flea Flicker	8cf72d926d	dev → uat: portal photoKey S3 key-hijack fix (GRO-2187/GRO-2198) (#173)	2026-06-08 12:39:52 +00:00
Flea Flicker	14d7889ec0	fix(portal): drop writable photoKey from PATCH /portal/pets — S3 key-hijack (GRO-2187/GRO-2198) (#172)	2026-06-08 12:39:02 +00:00
Flea Flicker	8721f0b63c	dev → uat: GRO-2154 geocoding endpoints (Phase 1.3) (#171)	2026-06-08 12:06:43 +00:00
Flea Flicker	582c376df9	feat(GRO-2154): geocoding endpoints + auto-geocode on client mutations (#170)	2026-06-08 11:45:08 +00:00
Flea Flicker	eec198a661	fix(ci): GRO-2197 api lint/typecheck/test run root scripts (de-false-green) (#169)	2026-06-08 11:09:33 +00:00
Flea Flicker	027e012a58	Merge pull request 'dev → uat: GRO-2153 abstracted geocoding service' (#168) from dev-to-uat-gro-2153 into uat	2026-06-08 10:51:17 +00:00
Flea Flicker	b3db206588	Merge pull request 'dev → uat: GRO-2187 portal pet PATCH + GET enrichment (carries GRO-2152)' (#166) from dev-to-uat-gro-2187 into uat	2026-06-08 10:02:17 +00:00
Flea Flicker	04b235c861	Merge pull request 'feat(GRO-2153): abstracted geocoding service (Nominatim + Google)' (#167) from feat/gro-2153-geocoding-service-dev into dev	2026-06-08 09:40:52 +00:00
Flea Flicker	21fb1b30d2	ci: retrigger build (registry layer-pull hang on prior run) ... Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-08 09:40:42 +00:00
Flea Flicker	2fa6e3d87b	feat(GRO-2153): abstracted geocoding service (Nominatim + Google) ... Phase 1.2 of Route Optimization. Adds a provider-agnostic geocoding service layer in the deployed src/ tree: - GeocodingProvider interface + GeocodeResult type - NominatimGeocodingProvider (default, free, self-hostable) with an internal rate limiter enforcing the 1 req/sec Nominatim usage policy - GoogleGeocodingProvider (optional fallback) keyed by the encrypted businessSettings.googleMapsApiKey (decrypted via decryptSecret) or GOOGLE_MAPS_API_KEY env fallback - resolveGeocodingProvider() selecting on businessSettings.routeOptimizationProvider, with safe fallback to Nominatim when google is configured but no usable key - geocodeBatch() throttled batch utility (honors provider rate limit, captures per-item errors, optional progress callback) - 20 unit tests covering both providers, selection, throttle spacing, and batch Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-06-08 09:01:36 +00:00
Flea Flicker	6be78cae35	fix(portal): implement PATCH /portal/pets/:petId + enrich GET (GRO-2187) (#165)	2026-06-08 08:18:13 +00:00
Flea Flicker	40bd6dcfea	Merge pull request 'feat(GRO-2152): route optimization schema migration' (#164) from feat/gro-2152-route-optimization-schema-dev into dev	2026-06-08 07:55:35 +00:00
Flea Flicker	4884961c8e	feat(GRO-2152): route optimization schema migration ... Add the database foundation for mobile groomer route optimization: - clients: latitude/longitude (double precision) + geocodedAt - groomer_routes: per-(staff, date) route with route_status enum, totals, optimizedAt; UNIQUE(staff_id, route_date) - route_stops: ordered stops FK->groomer_routes (cascade) + appointments, lat/lng, per-leg travel mins/distance, bufferMins; UNIQUE(route_id, appointment_id) and UNIQUE(route_id, stop_order) - business_settings: defaultTravelBufferMins (default 15), routeOptimizationProvider (default nominatim), googleMapsApiKey (encrypted at rest at the app layer) - Idempotent hand-authored migration 0041 + journal entry (when=max+1) Lands in packages/db (the deployed schema/migration source per the Dockerfile migrate stage); apps/api is the legacy CI-only copy. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>	2026-06-08 07:48:10 +00:00
Flea Flicker	6538406db2	Merge pull request 'chore: delete stale apps/api/src/db/seed.ts duplicate (GRO-2129)' (#158) from dev into uat	2026-06-04 12:45:24 +00:00
Flea Flicker	93be4d8f72	chore: delete stale apps/api/src/db/seed.ts duplicate (GRO-2129) (#158) ... chore: delete stale apps/api/src/db/seed.ts duplicate (GRO-2129) (#158)	2026-06-04 12:44:46 +00:00