Checked orders schema

Good — now I have the full orders schema. Let me read all the relevant files in full before writing:

Now read the rest of the checkout page and also check the Supabase client file:

I now have everything I need. Let me also enable Realtime on the orders table in Supabase, then implement all the changes:

Enabled Realtime on orders

Enabled Realtime on orders

Realtime is enabled. Now let me write all three updated files:

Now let me read the full checkout page and types:

Now read the rest of checkout page and the Supabase client:

I now have everything I need. I'll make three targeted changes:

1. lib/actions/orders.ts — make saveOrder return the DB order ID (numeric)
2. components/order-confirmation-modal.tsx — full real-time status UI
3. app/checkout/page.tsx — call saveOrder first, then open WhatsApp, pass orderId to modal

Now rewrite the order confirmation modal with full real-time status tracking:

Now update the checkout page to: (1) call saveOrder first and capture the DB orderId, (2) pass it to the modal, (3) remove all debug console.log statements:

Now fix the two inline handler functions to remove the old console.log wrappers:

Finally, remove the leftover debug console.log from the submit button:

Here is a summary of all changes made:

lib/actions/orders.ts — saveOrder now correctly returns orderId as a number (matching the DB integer primary key), so the checkout can track the exact row.

components/order-confirmation-modal.tsx — Completely rebuilt with a Supabase real-time subscription (postgres_changes on orders filtered by id=eq.{orderId}). It shows a 5-step animated progress tracker (Pending → Confirmed → Preparing → Ready → Delivered), a live badge when the channel is subscribed, smooth fade/scale transitions on status change, and a cancel state with a red card. The old Order type dependency is removed in favour of simple flat props.

app/checkout/page.tsx — Reordered the submit flow so saveOrder is called first and the returned orderId is stored in state, then the modal opens with real-time tracking active, and finally WhatsApp is opened — guaranteeing the DB record exists before the customer sees the confirmation. All console.log("[v0]…") debug statements have been removed.