Back to Projects

BookPilot Scheduling Cockpit

Operator dashboard plus branded guest flow with Stripe deposits and Google Calendar sync.

Next.jsPrismaStripeGoogle CalendarTailwindlibSQL
Operator + guest flow in one repo
Stripe deposits auto-confirm even without webhook
Encrypted PII and audit log

Overview

Single repo showcasing auth, operator workspace, guest booking flow, Stripe Checkout, and Google Calendar integrations reviewers can run end to end.

Approach

Built with Next.js 16 App Router, Prisma 7 on SQLite/libSQL, iron-session auth, Stripe Checkout, Google Calendar webhooks, encrypted PII, and audit logging.

Architecture

Next.js `/app` workspace + public `/book/[teamSlug]` routes backed by Prisma (SQLite/libSQL), Stripe, and Google Calendar integrations.

Challenges

Implemented pending-payment expiry, idempotent booking mutations, encrypted PII, and webhook fallbacks so paid bookings never get stuck.

Results & Metrics

Reviewers can log in with demo credentials, confirm/cancel bookings, edit availability, and run the guest Stripe flow entirely from this repo.

Tech Stack

Next.jsPrismaStripeGoogle CalendarTailwindlibSQL