How to Build Food delivery backend with V0

1// Paste this prompt into V0's AI chat:
2// Build a food delivery backend. Create a Supabase schema with:
3// 1. restaurants: id (uuid PK), owner_id (uuid FK to auth.users), name (text), description (text), address (text), lat (decimal), lng (decimal), cuisine_type (text), is_active (boolean default true), avg_prep_minutes (int), created_at (timestamptz)
4// 2. menu_items: id (uuid PK), restaurant_id (uuid FK), name (text), description (text), price_cents (int), category (text), image_url (text), is_available (boolean default true)
5// 3. orders: id (uuid PK), customer_id (uuid FK), restaurant_id (uuid FK), driver_id (uuid FK nullable), status (text default 'pending' check in 'pending','confirmed','preparing','ready','picked_up','delivering','delivered','cancelled'), items_json (jsonb), subtotal_cents (int), delivery_fee_cents (int), total_cents (int), delivery_address (text), delivery_lat (decimal), delivery_lng (decimal), stripe_payment_intent_id (text), created_at (timestamptz), updated_at (timestamptz)
6// 4. drivers: id (uuid PK), user_id (uuid FK), is_available (boolean default true), current_lat (decimal), current_lng (decimal), vehicle_type (text), updated_at (timestamptz)
7// 5. order_status_log: id (uuid PK), order_id (uuid FK), status (text), changed_by (uuid FK), created_at (timestamptz)
8// Enable PostGIS extension. Enable Realtime on orders table.
9// Add RLS for role-based access.

1// Paste this prompt into V0's AI chat:
2// Build the customer ordering flow:
3// 1. app/page.tsx — restaurant listing with Card components, cuisine Select filter, and distance sort
4// 2. app/restaurant/[id]/page.tsx — menu with category Tabs, menu item Cards with "Add to Cart" Button, cart summary in Sheet sidebar
5// 3. app/checkout/page.tsx — 'use client' cart review with item list, subtotal, delivery fee, total, and "Pay" Button that POSTs to /api/orders
6// 4. app/orders/[id]/page.tsx — 'use client' real-time order tracking:
7//    - Subscribe to Supabase Realtime .on('postgres_changes', { event: 'UPDATE', filter: `id=eq.${orderId}` })
8//    - Show status Stepper: Pending > Confirmed > Preparing > Ready > Picked Up > Delivering > Delivered
9//    - Estimated delivery time, driver info when assigned
10// API route: app/api/orders/route.ts — POST validates items, calculates totals, creates Stripe PaymentIntent, inserts order
11// Use shadcn/ui Card, Badge, Sheet, Stepper pattern

1import { NextRequest, NextResponse } from 'next/server'
2import { createClient } from '@supabase/supabase-js'
3
4const supabase = createClient(
5  process.env.SUPABASE_URL!,
6  process.env.SUPABASE_SERVICE_ROLE_KEY!
7)
8
9const validTransitions: Record<string, string[]> = {
10  pending: ['confirmed', 'cancelled'],
11  confirmed: ['preparing', 'cancelled'],
12  preparing: ['ready'],
13  ready: ['picked_up'],
14  picked_up: ['delivering'],
15  delivering: ['delivered'],
16}
17
18export async function PATCH(
19  req: NextRequest,
20  { params }: { params: Promise<{ id: string }> }
21) {
22  const { id } = await params
23  const { status, changedBy } = await req.json()
24
25  const { data: order } = await supabase
26    .from('orders')
27    .select('status')
28    .eq('id', id)
29    .single()
30
31  if (!order) {
32    return NextResponse.json({ error: 'Order not found' }, { status: 404 })
33  }
34
35  const allowed = validTransitions[order.status]
36  if (!allowed?.includes(status)) {
37    return NextResponse.json(
38      { error: `Cannot transition from ${order.status} to ${status}` },
39      { status: 400 }
40    )
41  }
42
43  await supabase
44    .from('orders')
45    .update({ status, updated_at: new Date().toISOString() })
46    .eq('id', id)
47
48  await supabase.from('order_status_log').insert({
49    order_id: id,
50    status,
51    changed_by: changedBy,
52  })
53
54  return NextResponse.json({ success: true })
55}

1// Paste this prompt into V0's AI chat:
2// Build the restaurant dashboard at app/restaurant/dashboard/page.tsx.
3// Requirements:
4// - 'use client' page that subscribes to orders Realtime for this restaurant
5// - Three columns (Kanban-style): New Orders, Preparing, Ready for Pickup
6// - Each order as a Card with: order ID, items list, total, customer address, time since ordered
7// - New Orders: "Confirm" Button (transitions pending > confirmed > preparing)
8// - Preparing: "Mark Ready" Button (transitions to ready)
9// - Audio notification sound when new order arrives
10// - Stats bar at top: total orders today, average prep time, revenue today
11// - Use Badge for order status, Card for order items, Button for actions

1// Paste this prompt into V0's AI chat:
2// Build two things:
3// 1. app/driver/page.tsx — driver dashboard ('use client'):
4//    - Toggle Switch: Available / Unavailable (updates drivers.is_available)
5//    - Subscribe to orders Realtime filtered by driver_id = current user
6//    - Available orders list (status = 'ready', no driver assigned): Card with restaurant name, pickup address, delivery address, payment amount
7//    - "Accept" Button that assigns the driver to the order
8//    - Active delivery Card (when assigned): order details + status action Buttons:
9//      - "Picked Up" (sets status to picked_up)
10//      - "Delivered" (sets status to delivered)
11//    - Delivery history Table below
12// 2. app/api/drivers/assign/route.ts — POST that finds the nearest available driver:
13//    - Query: SELECT * FROM drivers WHERE is_available = true ORDER BY point(current_lng, current_lat) <-> point($lng, $lat) LIMIT 1
14//    - Update the order's driver_id and set driver is_available = false
15//    - Return the assigned driver info

1import { NextRequest, NextResponse } from 'next/server'
2import Stripe from 'stripe'
3import { createClient } from '@supabase/supabase-js'
4
5const stripe = new Stripe(process.env.STRIPE_SECRET_KEY!)
6const supabase = createClient(
7  process.env.SUPABASE_URL!,
8  process.env.SUPABASE_SERVICE_ROLE_KEY!
9)
10
11export async function POST(req: NextRequest) {
12  const body = await req.text()
13  const sig = req.headers.get('stripe-signature')!
14
15  let event: Stripe.Event
16  try {
17    event = stripe.webhooks.constructEvent(
18      body, sig, process.env.STRIPE_WEBHOOK_SECRET!
19    )
20  } catch {
21    return NextResponse.json({ error: 'Invalid signature' }, { status: 400 })
22  }
23
24  if (event.type === 'payment_intent.succeeded') {
25    const pi = event.data.object as Stripe.PaymentIntent
26    const orderId = pi.metadata.orderId
27
28    await supabase
29      .from('orders')
30      .update({ status: 'confirmed' })
31      .eq('id', orderId)
32
33    await supabase.from('order_status_log').insert({
34      order_id: orderId,
35      status: 'confirmed',
36      changed_by: pi.metadata.customerId,
37    })
38  }
39
40  return NextResponse.json({ received: true })
41}