How to Build Escrow service with V0

1// Paste this prompt into V0's AI chat:
2// Build an escrow service platform. Create a Supabase schema with:
3// 1. users_profiles: id (uuid PK FK to auth.users), full_name (text), role (text check in 'buyer','seller','both'), stripe_account_id (text), onboarded (boolean default false)
4// 2. contracts: id (uuid PK), buyer_id (uuid FK to auth.users), seller_id (uuid FK to auth.users), title (text), description (text), amount_cents (int), currency (text default 'usd'), status (text default 'draft' check in 'draft','funded','in_progress','delivered','disputed','completed','refunded'), funded_at (timestamptz), delivered_at (timestamptz), completed_at (timestamptz), created_at (timestamptz)
5// 3. milestones: id (uuid PK), contract_id (uuid FK to contracts), title (text), amount_cents (int), status (text default 'pending' check in 'pending','funded','released','refunded'), position (int)
6// 4. disputes: id (uuid PK), contract_id (uuid FK to contracts), raised_by (uuid FK to auth.users), reason (text), resolution (text), status (text default 'open'), created_at (timestamptz)
7// 5. transactions: id (uuid PK), contract_id (uuid FK to contracts), type (text check in 'fund','release','refund'), amount_cents (int), stripe_transfer_id (text), created_at (timestamptz)
8// Add RLS policies: buyers and sellers can access their own contracts.

1import { NextRequest, NextResponse } from 'next/server'
2import Stripe from 'stripe'
3import { createClient } from '@/lib/supabase/server'
4
5const stripe = new Stripe(process.env.STRIPE_SECRET_KEY!)
6
7export async function POST(req: NextRequest) {
8  const supabase = await createClient()
9  const { data: { user } } = await supabase.auth.getUser()
10
11  if (!user) {
12    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 })
13  }
14
15  const { data: profile } = await supabase
16    .from('users_profiles')
17    .select('stripe_account_id')
18    .eq('id', user.id)
19    .single()
20
21  let accountId = profile?.stripe_account_id
22
23  if (!accountId) {
24    const account = await stripe.accounts.create({
25      type: 'express',
26      email: user.email,
27      metadata: { userId: user.id },
28    })
29    accountId = account.id
30
31    await supabase
32      .from('users_profiles')
33      .update({ stripe_account_id: accountId })
34      .eq('id', user.id)
35  }
36
37  const accountLink = await stripe.accountLinks.create({
38    account: accountId,
39    refresh_url: `${req.nextUrl.origin}/dashboard`,
40    return_url: `${req.nextUrl.origin}/dashboard?onboarded=true`,
41    type: 'account_onboarding',
42  })
43
44  return NextResponse.json({ url: accountLink.url })
45}

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 { contractId } = await req.json()
13
14  const { data: contract } = await supabase
15    .from('contracts')
16    .select('*, users_profiles!contracts_seller_id_fkey(stripe_account_id)')
17    .eq('id', contractId)
18    .single()
19
20  if (!contract || contract.status !== 'draft') {
21    return NextResponse.json({ error: 'Invalid contract' }, { status: 400 })
22  }
23
24  const paymentIntent = await stripe.paymentIntents.create({
25    amount: contract.amount_cents,
26    currency: contract.currency,
27    capture_method: 'manual',
28    metadata: { contractId: contract.id },
29    transfer_data: {
30      destination: contract.users_profiles.stripe_account_id,
31    },
32  })
33
34  await supabase
35    .from('contracts')
36    .update({ status: 'funded', funded_at: new Date().toISOString() })
37    .eq('id', contractId)
38
39  await supabase.from('transactions').insert({
40    contract_id: contractId,
41    type: 'fund',
42    amount_cents: contract.amount_cents,
43  })
44
45  return NextResponse.json({ clientSecret: paymentIntent.client_secret })
46}

1// Paste this prompt into V0's AI chat:
2// Build a contract detail page at app/contracts/[id]/page.tsx.
3// Requirements:
4// - Server Component that fetches the contract with milestones, transactions, and disputes
5// - Show contract status as a Stepper/progress component with stages: Draft, Funded, In Progress, Delivered, Completed
6// - Display contract details in a Card: title, description, amount, buyer name, seller name
7// - Show milestones as a list of Card components with title, amount, and status Badge (pending/funded/released)
8// - Action buttons change based on status and user role:
9//   - Buyer on 'draft': "Fund Contract" Button
10//   - Seller on 'funded': "Mark as Delivered" Button
11//   - Buyer on 'delivered': "Release Payment" Button (green) and "Dispute" Button (red)
12//   - Both users: "Raise Dispute" Button when status is funded or delivered
13// - Use AlertDialog for confirming release and refund actions
14// - Show transaction history in a timeline below the contract using custom vertical timeline with Badge for type
15// - Use Separator between the contract details and the timeline sections

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,
19      sig,
20      process.env.STRIPE_WEBHOOK_SECRET!
21    )
22  } catch {
23    return NextResponse.json({ error: 'Invalid signature' }, { status: 400 })
24  }
25
26  if (event.type === 'payment_intent.amount_capturable_updated') {
27    const pi = event.data.object as Stripe.PaymentIntent
28    const contractId = pi.metadata.contractId
29
30    await supabase
31      .from('contracts')
32      .update({ status: 'funded', funded_at: new Date().toISOString() })
33      .eq('id', contractId)
34  }
35
36  if (event.type === 'transfer.created') {
37    const transfer = event.data.object as Stripe.Transfer
38    const contractId = transfer.metadata?.contractId
39
40    if (contractId) {
41      await supabase.from('transactions').insert({
42        contract_id: contractId,
43        type: 'release',
44        amount_cents: transfer.amount,
45        stripe_transfer_id: transfer.id,
46      })
47
48      await supabase
49        .from('contracts')
50        .update({ status: 'completed', completed_at: new Date().toISOString() })
51        .eq('id', contractId)
52    }
53  }
54
55  return NextResponse.json({ received: true })
56}

1// Paste this prompt into V0's AI chat:
2// Build a dispute resolution page at app/disputes/[id]/page.tsx.
3// Requirements:
4// - Server Component that fetches the dispute with its contract details and both parties' info
5// - Show dispute status Badge (open/resolved), reason text, raised by user with Avatar
6// - Display the contract summary Card with amount, title, and current status
7// - Admin actions: "Release to Seller" Button and "Refund to Buyer" Button in an AlertDialog with confirmation
8// - Release calls /api/escrow/release to capture payment and transfer to seller
9// - Refund calls /api/escrow/refund to cancel the PaymentIntent
10// - A Textarea for admin to add resolution notes
11// - Timeline showing dispute events (raised, notes added, resolved) with timestamps
12// - Both parties can add comments to the dispute via a Textarea and Button
13// - Use Separator between the dispute details and the comment thread