How to Build Vehicle rentals backend with V0

1-- Enable btree_gist for EXCLUDE constraints
2CREATE EXTENSION IF NOT EXISTS btree_gist;
3
4CREATE TABLE vehicles (
5  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
6  make text NOT NULL,
7  model text NOT NULL,
8  year int NOT NULL,
9  type text NOT NULL CHECK (type IN ('sedan','suv','truck','van','luxury')),
10  daily_rate_cents int NOT NULL,
11  image_url text,
12  plate_number text UNIQUE NOT NULL,
13  mileage int DEFAULT 0,
14  status text DEFAULT 'available' CHECK (status IN ('available','rented','maintenance')),
15  features jsonb DEFAULT '[]',
16  created_at timestamptz DEFAULT now()
17);
18
19CREATE TABLE bookings (
20  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
21  vehicle_id uuid REFERENCES vehicles(id) ON DELETE CASCADE,
22  customer_id uuid NOT NULL,
23  start_date date NOT NULL,
24  end_date date NOT NULL,
25  total_cents int NOT NULL,
26  status text DEFAULT 'pending' CHECK (status IN ('pending','confirmed','active','completed','cancelled')),
27  stripe_payment_intent_id text,
28  created_at timestamptz DEFAULT now(),
29  CONSTRAINT no_overlap EXCLUDE USING gist (
30    vehicle_id WITH =,
31    daterange(start_date, end_date) WITH &&
32  ) WHERE (status NOT IN ('cancelled'))
33);
34
35CREATE TABLE reviews (
36  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
37  booking_id uuid REFERENCES bookings(id) UNIQUE,
38  rating int CHECK (rating >= 1 AND rating <= 5),
39  comment text,
40  created_at timestamptz DEFAULT now()
41);

1-- Supabase RPC function for availability checking
2CREATE OR REPLACE FUNCTION available_vehicles(p_start date, p_end date)
3RETURNS SETOF vehicles AS $$
4  SELECT v.*
5  FROM vehicles v
6  WHERE v.status = 'available'
7    AND NOT EXISTS (
8      SELECT 1 FROM bookings b
9      WHERE b.vehicle_id = v.id
10        AND b.status NOT IN ('cancelled')
11        AND daterange(b.start_date, b.end_date) && daterange(p_start, p_end)
12    )
13  ORDER BY v.daily_rate_cents ASC;
14$$ LANGUAGE sql STABLE;

1import { NextRequest, NextResponse } from 'next/server'
2import { createClient } from '@/lib/supabase/server'
3import Stripe from 'stripe'
4
5const stripe = new Stripe(process.env.STRIPE_SECRET_KEY!)
6
7export async function POST(req: NextRequest) {
8  const supabase = await createClient()
9  const { vehicleId, startDate, endDate } = await req.json()
10
11  const { data: vehicle } = await supabase
12    .from('vehicles')
13    .select('daily_rate_cents, make, model')
14    .eq('id', vehicleId)
15    .single()
16
17  if (!vehicle) {
18    return NextResponse.json({ error: 'Vehicle not found' }, { status: 404 })
19  }
20
21  const days = Math.ceil(
22    (new Date(endDate).getTime() - new Date(startDate).getTime()) / 86400000
23  )
24  const totalCents = vehicle.daily_rate_cents * days
25
26  const paymentIntent = await stripe.paymentIntents.create({
27    amount: totalCents,
28    currency: 'usd',
29    metadata: { vehicleId, startDate, endDate },
30  })
31
32  const { data: booking, error } = await supabase
33    .from('bookings')
34    .insert({
35      vehicle_id: vehicleId,
36      customer_id: (await supabase.auth.getUser()).data.user?.id,
37      start_date: startDate,
38      end_date: endDate,
39      total_cents: totalCents,
40      stripe_payment_intent_id: paymentIntent.id,
41    })
42    .select()
43    .single()
44
45  if (error?.code === '23P01') {
46    return NextResponse.json(
47      { error: 'Vehicle is not available for these dates' },
48      { status: 409 }
49    )
50  }
51
52  return NextResponse.json({
53    bookingId: booking?.id,
54    clientSecret: paymentIntent.client_secret,
55  })
56}

1// Paste this prompt into V0's AI chat:
2// Build an admin fleet management page at app/admin/fleet/page.tsx with:
3// 1. Server Component fetching all vehicles with their active booking count
4// 2. shadcn/ui Table with columns: Vehicle (make + model + year), Plate, Type Badge, Daily Rate, Mileage, Status Badge, Actions
5// 3. Status Badge: 'available' = default, 'rented' = secondary, 'maintenance' = destructive
6// 4. Action buttons: Edit (Dialog with Form), Toggle Maintenance, View Bookings
7// 5. Summary Cards at top: total fleet size, currently rented, in maintenance, revenue this month
8// 6. Server Actions for updateVehicleStatus and updateVehicleDetails
9// 7. Filter by vehicle type using Select dropdown
10// Use Supabase for all data fetching and mutations.

1// Paste this prompt into V0's AI chat:
2// Build a customer bookings page at app/bookings/page.tsx with:
3// 1. Server Component fetching all bookings for the current user with vehicle details
4// 2. shadcn/ui Card for each booking showing vehicle image, make/model, dates, total price
5// 3. Badge for status: pending = outline, confirmed = default, active = secondary, completed = default, cancelled = destructive
6// 4. Cancel button (AlertDialog confirmation) for pending bookings using Server Action
7// 5. Review button (Dialog with star rating + textarea) for completed bookings
8// 6. Tabs for Active, Upcoming, and Past bookings
9// 7. Empty state with illustration when no bookings exist
10// Cancel action should update booking status and the EXCLUDE constraint will free up those dates.