Build a booking app

Build a consulting booking platform called "BookPro" using Next.js and
TypeScript. Include these pages: landing page with hero section and
featured consultants, consultant directory with search and filters,
individual consultant profile page with bio and booking widget,
client dashboard showing upcoming and past bookings, consultant
dashboard for managing availability and viewing bookings, login page,
and signup page. Use a clean, professional design with a blue and
white color scheme. Add a responsive navbar with logo, navigation
links, and login/signup buttons.

Connect Supabase and create the following database tables:

1. "profiles" - id (uuid, references auth.users), display_name (text),
   email (text), avatar_url (text), role (text, either 'client' or
   'consultant'), created_at (timestamp)
2. "consultants" - id (uuid, references profiles), specialty (text),
   bio (text), hourly_rate (integer, in cents), is_featured (boolean),
   calendar_link (text), years_experience (integer), rating (decimal)
3. "bookings" - id (uuid), client_id (uuid, references profiles),
   consultant_id (uuid, references consultants), scheduled_at (timestamp
   with timezone), duration_minutes (integer, default 60), status (text,
   either 'confirmed', 'completed', 'canceled'), notes (text),
   stripe_payment_id (text), created_at (timestamp)
4. "reviews" - id (uuid), booking_id (uuid, references bookings),
   client_id (uuid, references profiles), consultant_id (uuid,
   references consultants), rating (integer, 1 to 5), comment (text),
   created_at (timestamp)

Add row-level security policies so clients can only access their own
bookings and consultants can only see bookings assigned to them.
Create a trigger that automatically inserts a profile row when a new
user signs up.

Implement user authentication and profiles using Supabase Auth:

- On the signup page, add email/password registration with a role
  selector (client or consultant). After signup, redirect to the
  appropriate dashboard.
- On the login page, add email/password login with a "Remember me"
  checkbox. Redirect to the correct dashboard based on role.
- Add Google sign-in as a social login option on both pages.
- For consultants, build a profile editor where they can set their
  display name, avatar, specialty, bio, hourly rate, years of
  experience, and calendar link.
- For clients, build a simpler profile page with display name, avatar,
  and email.
- Protect dashboard pages so only logged-in users can access them.
  Redirect unauthenticated visitors to the login page.

Integrate Cal.com (or Calendly) for scheduling:

- On each consultant's profile page, embed the Cal.com scheduling
  widget using the consultant's calendar_link from the database.
- The widget should show available time slots based on the
  consultant's configured availability.
- When a client selects a time slot, capture the booking details
  (date, time, duration) and create a booking record in the
  Supabase bookings table with status 'confirmed'.
- Add a Cal.com webhook handler that listens for booking.created
  and booking.canceled events to keep the Supabase bookings table
  in sync.
- Show a confirmation screen after booking with the date, time,
  consultant name, and session details.

Build booking management dashboards:

- Client dashboard: show a list of upcoming bookings sorted by date
  with consultant name, date and time, duration, and status badge.
  Add a "Past Bookings" tab showing completed sessions. Include a
  "Cancel Booking" button that sets the status to 'canceled' (only
  allowed more than 24 hours before the session).
- Consultant dashboard: show all upcoming bookings with client name,
  date and time, duration, and any notes. Add a calendar view that
  displays bookings visually across the week. Include a "Past Sessions"
  tab with completed bookings.
- Add a booking detail page that both the client and consultant can
  access, showing full session information and a notes field.

Connect Stripe and set up payment for bookings:

- When a client books a paid session, redirect them to a Stripe
  Checkout page before confirming the booking. The checkout should
  show the consultant's name, session duration, and the hourly rate.
- Add a webhook handler that listens for checkout.session.completed.
  When payment succeeds, update the booking status to 'confirmed'
  and store the Stripe payment ID in the bookings table.
- If the client cancels a booking more than 24 hours before the
  session, issue an automatic refund through Stripe and update
  the booking status.
- Add a billing history page in the client dashboard showing all
  past payments with date, consultant, amount, and receipt link.
- For consultants, show an earnings summary with total revenue,
  completed sessions, and a payout history section.

Connect Resend and add email notifications:

- Send a booking confirmation email to both the client and consultant
  when a session is booked. Include the date, time, duration,
  consultant/client name, and a calendar invite (.ics) attachment.
- Send a reminder email 24 hours before the scheduled session to
  both parties with the meeting details and any join link.
- Send a cancellation email when a booking is canceled, including
  refund details if a payment was made.
- Send a follow-up email to the client 1 hour after the session
  ends, asking them to leave a review for the consultant.
- Use a clean, professional email template with the BookPro logo,
  a white background, and blue accent buttons.

Deploy the app to Netlify:

- Set up the build configuration for Next.js with the correct build
  command and output directory.
- Add all required environment variables: Supabase URL, Supabase
  anon key, Stripe publishable key, Stripe secret key, Stripe
  webhook secret, Resend API key, and Cal.com API key.
- Enable automatic deploys so the app redeploys when you push changes.
- Set up a custom subdomain like bookpro.netlify.app.