How johnathanmcphilbin/expedition works
Expedition is a participant program portal for logging project hours, submitting work for review, earning rewards, and pursuing travel support, with an operator-facing review and administration area. The visible review workflow loads queued work and supporting project/fraud details, lets authorized reviewers decide, and records the decision through a database function. The tree also shows distinct checkpoint, claims, Ireland travel, referrals, and fulfilment capabilities. Source excerpts directly support only a subset of route-to-service relationships, so other branches are represented without speculative edges.
Main entry points: +page.server.ts Submission review · db.ts PostgREST client · review-stats.ts Review statistics · review.ts Review decisions
Components 22
Participant experience
- Participant pages
src/routes - Program content
src/lib/data.ts
Review operations
- Admin pages
src/routes/admin - Submission review
src/routes/admin/reviews/+page.server.ts - Review decisions
src/lib/server/review.ts - Review statistics
src/lib/server/review-stats.ts - Queue operations
src/lib/server/queue.ts
Program services
- Checkpoint tracking
src/lib/server/checkpoints.ts - Claims and grants
src/lib/server/claims.ts - Travel planning
src/lib/server/travel-claims.ts - Referral attribution
src/lib/server/referrals.ts - Rewards fulfilment
src/lib/server/payouts.ts
Data platform
- Sessions and access
src/lib/server/session.ts - Role guards
src/lib/server/guards.ts - PostgREST client
src/lib/server/db.ts - Database types
src/lib/server/database.types.ts
Other components
- Participant
- Reviewer
- PostgreSQL via PostgREST
- Hack Club
- Hackatime
- Airtable
Connections 15
- Participant → Participant pages: uses
- Reviewer → Submission review: reviews submissions
- Submission review → Queue operations: loads queue details
src/routes/admin/reviews/+page.server.ts - Submission review → Review decisions: records decision
- Submission review → Hackatime: fetches project times
src/routes/admin/reviews/+page.server.ts - Submission review → Airtable: syncs submissions
src/routes/admin/reviews/+page.server.ts - Submission review → Hack Club: loads submission data
src/routes/admin/reviews/+page.server.ts - Submission review → Review statistics: uses reviewer metrics
- Review decisions → PostgREST client: calls RPC
src/lib/server/review.ts - Review statistics → PostgREST client: queries review data
src/lib/server/review-stats.ts - Review statistics → Role guards: uses reviewer names
src/lib/server/review-stats.ts - Sessions and access → PostgREST client: reads and writes sessions
src/lib/server/session.ts - PostgREST client → PostgreSQL via PostgREST: queries PostgREST
src/lib/server/db.ts - PostgREST client → Database types: types queries
src/lib/server/db.ts - Submission review → Role guards: checks reviewer access