[V0_FILE]sql:file="scripts/setup-database.sql" -- Create users table (extends Supabase auth.users) CREATE TABLE public.user_profiles ( id UUID PRIMARY KEY REFERENCES auth.users(id) ON DELETE CASCADE, email TEXT NOT NULL UNIQUE, full_name TEXT, role TEXT DEFAULT 'student' CHECK (role IN ('student', 'admin')), phone TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create menu categories table CREATE TABLE public.categories ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name TEXT NOT NULL UNIQUE, description TEXT, display_order INT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create menu items table CREATE TABLE public.menu_items ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name TEXT NOT NULL, description TEXT, price DECIMAL(10, 2) NOT NULL, category_id UUID NOT NULL REFERENCES public.categories(id) ON DELETE CASCADE, image_url TEXT, is_available BOOLEAN DEFAULT true, display_order INT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create orders table CREATE TABLE public.orders ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID NOT NULL REFERENCES public.user_profiles(id) ON DELETE CASCADE, total_amount DECIMAL(10, 2) NOT NULL, status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'preparing', 'ready', 'completed', 'cancelled')), notes TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create order items table CREATE TABLE public.order_items ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), order_id UUID NOT NULL REFERENCES public.orders(id) ON DELETE CASCADE, menu_item_id UUID NOT NULL REFERENCES public.menu_items(id), quantity INT NOT NULL DEFAULT 1, price_at_time DECIMAL(10, 2) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create indexes for better query performance CREATE INDEX idx_user_profiles_role ON public.user_profiles(role); CREATE INDEX idx_menu_items_category ON public.menu_items(category_id); CREATE INDEX idx_menu_items_available ON public.menu_items(is_available); CREATE INDEX idx_orders_user ON public.orders(user_id); CREATE INDEX idx_orders_status ON public.orders(status); CREATE INDEX idx_orders_created_at ON public.orders(created_at DESC); CREATE INDEX idx_order_items_order ON public.order_items(order_id); CREATE INDEX idx_order_items_menu_item ON public.order_items(menu_item_id); -- Enable Row Level Security ALTER TABLE public.user_profiles ENABLE ROW LEVEL SECURITY; ALTER TABLE public.menu_items ENABLE ROW LEVEL SECURITY; ALTER TABLE public.orders ENABLE ROW LEVEL SECURITY; ALTER TABLE public.order_items ENABLE ROW LEVEL SECURITY; -- Helper function to check if user is admin CREATE OR REPLACE FUNCTION public.is_admin() RETURNS BOOLEAN AS $$ DECLARE user_role TEXT; BEGIN SELECT role INTO user_role FROM public.user_profiles WHERE id = auth.uid(); RETURN user_role = 'admin'; END; $$ LANGUAGE plpgsql SECURITY DEFINER; -- Create RLS Policies for user_profiles CREATE POLICY "Users can view their own profile" ON public.user_profiles FOR SELECT USING (auth.uid() = id); CREATE POLICY "Users can update their own profile" ON public.user_profiles FOR UPDATE USING (auth.uid() = id); CREATE POLICY "Admins can view all profiles" ON public.user_profiles FOR SELECT USING (public.is_admin()); -- Create RLS Policies for menu_items CREATE POLICY "Everyone can view available menu items" ON public.menu_items FOR SELECT USING (is_available = true); CREATE POLICY "Admins can manage menu items" ON public.menu_items FOR ALL USING (public.is_admin()); -- Create RLS Policies for orders CREATE POLICY "Users can view their own orders" ON public.orders FOR SELECT USING (auth.uid() = user_id); CREATE POLICY "Users can create their own orders" ON public.orders FOR INSERT WITH CHECK (auth.uid() = user_id); CREATE POLICY "Users can update their own pending orders" ON public.orders FOR UPDATE USING (auth.uid() = user_id AND status = 'pending'); CREATE POLICY "Admins can view all orders" ON public.orders FOR SELECT USING (public.is_admin()); CREATE POLICY "Admins can update order status" ON public.orders FOR UPDATE USING (public.is_admin()); -- Create RLS Policies for order_items CREATE POLICY "Users can view items in their orders" ON public.order_items FOR SELECT USING ( order_id IN ( SELECT id FROM public.orders WHERE user_id = auth.uid() ) ); CREATE POLICY "Users can add items to their orders" ON public.order_items FOR INSERT WITH CHECK ( order_id IN ( SELECT id FROM public.orders WHERE user_id = auth.uid() ) ); CREATE POLICY "Admins can view all order items" ON public.order_items FOR SELECT USING (public.is_admin()); [V0_FILE]json:file="package.json" { "name": "my-v0-project", "version": "0.1.0", "private": true, "scripts": { "dev": "next dev", "build": "next build", "start": "next start", "lint": "eslint ." }, "dependencies": { "@hookform/resolvers": "^3.10.0", "@radix-ui/react-accordion": "1.2.2", "@radix-ui/react-alert-dialog": "1.1.4", "@radix-ui/react-aspect-ratio": "1.1.1", "@radix-ui/react-avatar": "1.1.2", "@radix-ui/react-checkbox": "1.1.3", "@radix-ui/react-collapsible": "1.1.2", "@radix-ui/react-context-menu": "2.2.4", "@radix-ui/react-dialog": "1.1.4", "@radix-ui/react-dropdown-menu": "2.1.4", "@radix-ui/react-hover-card": "1.1.4", "@radix-ui/react-label": "2.1.1", "@radix-ui/react-menubar": "1.1.4", "@radix-ui/react-navigation-menu": "1.2.3", "@radix-ui/react-popover": "1.1.4", "@radix-ui/react-progress": "1.1.1", "@radix-ui/react-radio-group": "1.2.2", "@radix-ui/react-scroll-area": "1.2.2", "@radix-ui/react-select": "2.1.4", "@radix-ui/react-separator": "1.1.1", "@radix-ui/react-slider": "1.2.2", "@radix-ui/react-slot": "1.1.1", "@radix-ui/react-switch": "1.1.2", "@radix-ui/react-tabs": "1.1.2", "@radix-ui/react-toast": "1.2.4", "@radix-ui/react-toggle": "1.1.1", "@radix-ui/react-toggle-group": "1.1.1", "@radix-ui/react-tooltip": "1.1.6", "@vercel/analytics": "1.3.1", "autoprefixer": "^10.4.20", "class-variance-authority": "^0.7.1", "clsx": "^2.1.1", "cmdk": "1.0.4", "date-fns": "4.1.0", "embla-carousel-react": "8.5.1", "input-otp": "1.4.1", "lucide-react": "^0.454.0", "next": "16.0.10", "next-themes": "^0.4.6", "react": "19.2.0", "react-day-picker": "9.8.0", "react-dom": "19.2.0", "react-hook-form": "^7.60.0", "react-resizable-panels": "^2.1.7", "recharts": "2.15.4", "sonner": "^1.7.4", "tailwind-merge": "^3.3.1", "tailwindcss-animate": "^1.0.7", "vaul": "^1.1.2", "zod": "3.25.76", "@supabase/ssr": "0.8.0", "@supabase/supabase-js": "2.91.1" }, "devDependencies": { "@tailwindcss/postcss": "^4.1.9", "@types/node": "^22", "@types/react": "^19", "@types/react-dom": "^19", "postcss": "^8.5", "tailwindcss": "^4.1.9", "tw-animate-css": "1.3.3", "typescript": "^5" } } [V0_FILE]typescript:file="lib/supabase/server.ts" import { createServerClient } from '@supabase/ssr' import { cookies } from 'next/headers' /** * Especially important if using Fluid compute: Don't put this client in a * global variable. Always create a new client within each function when using * it. */ export async function createClient() { const cookieStore = await cookies() return createServerClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!, { cookies: { getAll() { return cookieStore.getAll() }, setAll(cookiesToSet) { try { cookiesToSet.forEach(({ name, value, options }) => cookieStore.set(name, value, options), ) } catch { // The "setAll" method was called from a Server Component. // This can be ignored if you have proxy refreshing // user sessions. } }, }, }, ) } [V0_FILE]typescript:file="lib/supabase/proxy.ts" import { createServerClient } from '@supabase/ssr' import { NextResponse, type NextRequest } from 'next/server' export async function updateSession(request: NextRequest) { let supabaseResponse = NextResponse.next({ request, }) // With Fluid compute, don't put this client in a global environment // variable. Always create a new one on each request. const supabase = createServerClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!, { cookies: { getAll() { return request.cookies.getAll() }, setAll(cookiesToSet) { cookiesToSet.forEach(({ name, value }) => request.cookies.set(name, value), ) supabaseResponse = NextResponse.next({ request, }) cookiesToSet.forEach(({ name, value, options }) => supabaseResponse.cookies.set(name, value, options), ) }, }, }, ) // Do not run code between createServerClient and // supabase.auth.getUser(). A simple mistake could make it very hard to debug // issues with users being randomly logged out. // IMPORTANT: If you remove getUser() and you use server-side rendering // with the Supabase client, your users may be randomly logged out. const { data: { user }, } = await supabase.auth.getUser() if ( // if the user is not logged in and the app path, in this case, /protected, is accessed, redirect to the login page request.nextUrl.pathname.startsWith('/protected') && !user ) { // no user, potentially respond by redirecting the user to the login page const url = request.nextUrl.clone() url.pathname = '/auth/login' return NextResponse.redirect(url) } // IMPORTANT: You *must* return the supabaseResponse object as it is. // If you're creating a new response object with NextResponse.next() make sure to: // 1. Pass the request in it, like so: // const myNewResponse = NextResponse.next({ request }) // 2. Copy over the cookies, like so: // myNewResponse.cookies.setAll(supabaseResponse.cookies.getAll()) // 3. Change the myNewResponse object to fit your needs, but avoid changing // the cookies! // 4. Finally: // return myNewResponse // If this is not done, you may be causing the browser and server to go out // of sync and terminate the user's session prematurely! return supabaseResponse } [V0_FILE]typescript:file="middleware.ts" import { updateSession } from '@/lib/supabase/proxy' import { type NextRequest } from 'next/server' export async function middleware(request: NextRequest) { return await updateSession(request) } export const config = { matcher: [ /* * Match all request paths except: * - _next/static (static files) * - _next/image (image optimization files) * - favicon.ico (favicon file) * - images - .svg, .png, .jpg, .jpeg, .gif, .webp * Feel free to modify this pattern to include more paths. */ '/((?!_next/static|_next/image|favicon.ico|.*\\.(?:svg|png|jpg|jpeg|gif|webp)$).*)', ], } [V0_FILE]typescriptreact:file="app/auth/login/page.tsx" 'use client' import React from "react" import { createClient } from '@supabase/supabase-js' import { useSupabase } from '@/hooks/use-supabase' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import { Input } from '@/components/ui/input' import { Label } from '@/components/ui/label' import Link from 'next/link' import { useRouter } from 'next/navigation' import { useState } from 'react' export default function LoginPage() { const [email, setEmail] = useState('') const [password, setPassword] = useState('') const [error, setError] = useState(null) const [isLoading, setIsLoading] = useState(false) const router = useRouter() const supabase = useSupabase() const handleLogin = async (e: React.FormEvent) => { e.preventDefault() setIsLoading(true) setError(null) try { const { error } = await supabase.auth.signInWithPassword({ email, password, }) if (error) throw error router.push('/dashboard') } catch (error: unknown) { setError(error instanceof Error ? error.message : 'An error occurred') } finally { setIsLoading(false) } } return (

Welcome to QuickBite Order delicious food from your canteen

) } [V0_FILE]typescriptreact:file="app/auth/sign-up/page.tsx" 'use client' import React from "react" import { createClient } from '@supabase/supabase-js' // Import createClient from supabase-js import { useSupabase } from '@/hooks/use-supabase' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import { Input } from '@/components/ui/input' import { Label } from '@/components/ui/label' import Link from 'next/link' import { useRouter } from 'next/navigation' import { useState } from 'react' export default function SignUpPage() { const [email, setEmail] = useState('') const [password, setPassword] = useState('') const [repeatPassword, setRepeatPassword] = useState('') const [fullName, setFullName] = useState('') const [error, setError] = useState(null) const [isLoading, setIsLoading] = useState(false) const router = useRouter() const supabase = useSupabase() const handleSignUp = async (e: React.FormEvent) => { e.preventDefault() setIsLoading(true) setError(null) if (password !== repeatPassword) { setError('Passwords do not match') setIsLoading(false) return } if (password.length < 6) { setError('Password must be at least 6 characters') setIsLoading(false) return } try { const { error } = await supabase.auth.signUp({ email, password, options: { data: { full_name: fullName, }, }, }) if (error) throw error router.push('/auth/sign-up-success') } catch (error: unknown) { setError(error instanceof Error ? error.message : 'An error occurred') } finally { setIsLoading(false) } } return (

Join QuickBite Create your account to start ordering

Full Name setFullName(e.target.value)} />

Email setEmail(e.target.value)} />

Password setPassword(e.target.value)} />

Confirm Password setRepeatPassword(e.target.value)} />

{error &&

{error}

}

Already have an account?{' '} Login

) } [V0_FILE]typescriptreact:file="app/auth/sign-up-success/page.tsx" import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import Link from 'next/link' export default function SignUpSuccessPage() { return (

Account Created! Check your email to confirm your account

We've sent a confirmation email to your inbox. Click the link to verify your account and start ordering from QuickBite.

) } [V0_FILE]typescriptreact:file="app/layout.tsx" import React from "react" import type { Metadata } from 'next' import { Geist, Geist_Mono } from 'next/font/google' import { Analytics } from '@vercel/analytics/next' import './globals.css' const _geist = Geist({ subsets: ["latin"] }); const _geistMono = Geist_Mono({ subsets: ["latin"] }); export const metadata: Metadata = { title: 'QuickBite - Canteen Ordering', description: 'Digital canteen ordering platform for students. Browse menu, add to cart, and place orders online.', icons: { icon: [ { url: '/icon-light-32x32.png', media: '(prefers-color-scheme: light)', }, { url: '/icon-dark-32x32.png', media: '(prefers-color-scheme: dark)', }, { url: '/icon.svg', type: 'image/svg+xml', }, ], apple: '/apple-icon.png', }, } export default function RootLayout({ children, }: Readonly<{ children: React.ReactNode }>) { return ( {children} ) } [V0_FILE]typescript:file="app/api/menu/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse } from 'next/server' export async function GET() { try { const supabase = await createClient() // Get all menu items with their categories const { data: menuItems, error } = await supabase .from('menu_items') .select('*, categories(name)') .eq('is_available', true) .order('category_id') if (error) { throw error } return NextResponse.json(menuItems) } catch (error) { console.error('Menu API error:', error) return NextResponse.json( { error: 'Failed to fetch menu items' }, { status: 500 } ) } } [V0_FILE]typescript:file="app/api/categories/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse } from 'next/server' export async function GET() { try { const supabase = await createClient() const { data: categories, error } = await supabase .from('categories') .select('*') .order('name') if (error) { throw error } return NextResponse.json(categories) } catch (error) { console.error('Categories API error:', error) return NextResponse.json( { error: 'Failed to fetch categories' }, { status: 500 } ) } } [V0_FILE]typescriptreact:file="components/menu-item-card.tsx" 'use client' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardFooter, CardHeader, CardTitle, } from '@/components/ui/card' import Image from 'next/image' import { useState } from 'react' import { ShoppingCart, Star, Check } from 'lucide-react' interface MenuItem { id: string name: string description: string price: number image_url: string | null is_available: boolean } interface MenuItemCardProps { item: MenuItem onAddToCart: (item: MenuItem, quantity: number) => void } export function MenuItemCard({ item, onAddToCart }: MenuItemCardProps) { const [quantity, setQuantity] = useState(1) const handleAddToCart = () => { onAddToCart(item, quantity) setQuantity(1) } return ( {item.image_url ? (

{!item.is_available && (

Sold Out

)} {item.is_available && (

)}

) : (

)}

{item.name} {item.description}

₹

{item.price.toFixed(0)}

{quantity}

) } [V0_FILE]typescriptreact:file="app/dashboard/page.tsx" 'use client' import { MenuItemCard } from '@/components/menu-item-card' import { CartSidebar, type CartItem } from '@/components/cart-sidebar' import { SpecialOffersBanner } from '@/components/special-offers-banner' import { Button } from '@/components/ui/button' import { Select, SelectContent, SelectItem, SelectTrigger, SelectValue, } from '@/components/ui/select' import { useRouter } from 'next/navigation' import { useEffect, useState } from 'react' import { useToast } from '@/hooks/use-toast' import { useSupabase } from '@/hooks/use-supabase' import { LogOut, UtensilsCrossed, Clock, Zap, TrendingUp, Trophy } from 'lucide-react' import { createClient } from '@supabase/supabase-js' interface MenuItem { id: string name: string description: string price: number image_url: string | null is_available: boolean category_id: string } interface Category { id: string name: string } export default function DashboardPage() { const [menuItems, setMenuItems] = useState([]) const [categories, setCategories] = useState([]) const [cart, setCart] = useState([]) const [selectedCategory, setSelectedCategory] = useState('all') const [isLoading, setIsLoading] = useState(true) const [isCheckingOut, setIsCheckingOut] = useState(false) const router = useRouter() const { toast } = useToast() const supabase = useSupabase() useEffect(() => { fetchMenu() fetchCategories() }, []) const fetchMenu = async () => { try { const response = await fetch('/api/menu') if (!response.ok) throw new Error('Failed to fetch menu') const data = await response.json() setMenuItems(data) } catch (error) { console.error('Error fetching menu:', error) toast({ title: 'Error', description: 'Failed to load menu items', variant: 'destructive', }) } finally { setIsLoading(false) } } const fetchCategories = async () => { try { const response = await fetch('/api/categories') if (!response.ok) throw new Error('Failed to fetch categories') const data = await response.json() setCategories(data) } catch (error) { console.error('Error fetching categories:', error) } } const handleAddToCart = (item: MenuItem, quantity: number) => { const existingItem = cart.find((ci) => ci.menu_item_id === item.id) if (existingItem) { setCart( cart.map((ci) => ci.menu_item_id === item.id ? { ...ci, quantity: ci.quantity + quantity } : ci ) ) } else { setCart([ ...cart, { id: Math.random().toString(), name: item.name, price: item.price, quantity, menu_item_id: item.id, }, ]) } toast({ title: 'Added to cart', description: `${item.name} added to your cart`, }) } const handleRemoveFromCart = (itemId: string) => { setCart(cart.filter((ci) => ci.id !== itemId)) } const handleCheckout = async () => { setIsCheckingOut(true) try { const totalAmount = cart.reduce((sum, item) => sum + item.price * item.quantity, 0) if (totalAmount <= 0) { throw new Error('Invalid cart total') } const orderData = { items: cart.map((item) => ({ menu_item_id: item.menu_item_id, quantity: item.quantity, price_at_time: item.price, name: item.name, })), total_amount: totalAmount, } // Store order data in sessionStorage and redirect to payment page if (typeof window !== 'undefined') { sessionStorage.setItem('pending_order', JSON.stringify(orderData)) } router.push('/payment') } catch (error) { console.error('[v0] Checkout error:', error) toast({ title: 'Error', description: error instanceof Error ? error.message : 'Failed to proceed to payment', variant: 'destructive', }) } finally { setIsCheckingOut(false) } } const handleLogout = async () => { await supabase.auth.signOut() router.push('/auth/login') } const filteredItems = selectedCategory === 'all' ? menuItems : menuItems.filter((item) => item.category_id === selectedCategory) return (

{/* Header */}

QuickBite

Fresh Food, Fast Delivery

{/* Main Content */}

{/* Special Offers Banner */}

{/* Stats Cards */}

Available Items

{filteredItems.length}

Items in Cart

{cart.length}

Estimated Wait

~15 min

{/* Section Header */}

Browse Menu

Discover our fresh and delicious offerings

Filter by Category:

{/* Menu Grid */} {isLoading ? (

Loading delicious menu...

Hold tight, we're preparing something tasty!

) : filteredItems.length === 0 ? (

No items available

Try selecting a different category

) : (

{filteredItems.map((item, idx) => (

))}

)}

{/* Cart Sidebar */}

) } [V0_FILE]typescriptreact:file="app/orders/page.tsx" 'use client' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import { Badge } from '@/components/ui/badge' import { useSupabase } from '@/hooks/use-supabase' import Link from 'next/link' import { useRouter } from 'next/navigation' import { useEffect, useState } from 'react' import { LogOut, Package } from 'lucide-react' import { createClient } from '@supabase/supabase-js' // Import createClient interface OrderItem { menu_item_id: string quantity: number price: number menu_items: { name: string } } interface Order { id: string status: string total_amount: number created_at: string order_items: OrderItem[] } export default function OrdersPage() { const [orders, setOrders] = useState([]) const [isLoading, setIsLoading] = useState(true) const router = useRouter() const supabase = useSupabase() useEffect(() => { fetchOrders() }, []) const fetchOrders = async () => { try { const response = await fetch('/api/orders') if (response.status === 401) { router.push('/auth/login') return } if (!response.ok) throw new Error('Failed to fetch orders') const data = await response.json() setOrders(data) } catch (error) { console.error('Error fetching orders:', error) } finally { setIsLoading(false) } } const handleLogout = async () => { await supabase.auth.signOut() router.push('/auth/login') } const getStatusColor = (status: string) => { switch (status.toLowerCase()) { case 'pending': return 'bg-yellow-100 text-yellow-800' case 'ready': return 'bg-green-100 text-green-800' case 'completed': return 'bg-blue-100 text-blue-800' case 'cancelled': return 'bg-red-100 text-red-800' default: return 'bg-gray-100 text-gray-800' } } const formatDate = (dateString: string) => { return new Date(dateString).toLocaleDateString('en-IN', { year: 'numeric', month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit', }) } return (

{/* Header */}

My Orders

Track your canteen orders

{/* Main Content */}

{isLoading ? (

Loading orders...

) : orders.length === 0 ? (

No orders yet

Start ordering from the menu to see your orders here

) : (

{orders.map((order) => (

Order #{order.id.slice(0, 8)} {formatDate(order.created_at)}

{order.status.charAt(0).toUpperCase() + order.status.slice(1)}

Items

{item.quantity}x {item.menu_items.name} - ₹ {(item.price * item.quantity).toFixed(2)}

Total Amount ₹{order.total_amount.toFixed(2)}

))}

)}

) } [V0_FILE]typescriptreact:file="app/orders/[id]/page.tsx" 'use client' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import { Badge } from '@/components/ui/badge' import { useSupabase } from '@/hooks/use-supabase' import Link from 'next/link' import { useRouter } from 'next/navigation' import { useEffect, useState } from 'react' import { CheckCircle, Clock, Flame, Package } from 'lucide-react' interface OrderItem { menu_item_id: string quantity: number price: number menu_items: { name: string } } interface Order { id: string status: string total_amount: number created_at: string order_items: OrderItem[] } export default function OrderDetailPage({ params }: { params: { id: string } }) { const [order, setOrder] = useState(null) const [isLoading, setIsLoading] = useState(true) const router = useRouter() const supabase = useSupabase() useEffect(() => { fetchOrder() // Auto-refresh order status every 3 seconds const interval = setInterval(fetchOrder, 3000) return () => clearInterval(interval) }, [params.id]) const fetchOrder = async () => { try { const { data: { user }, } = await supabase.auth.getUser() if (!user) { router.push('/auth/login') return } const { data, error } = await supabase .from('orders') .select('*, order_items(*, menu_items(name))') .eq('id', params.id) .eq('user_id', user.id) .single() if (error) throw error setOrder(data) } catch (error) { console.error('Error fetching order:', error) } finally { setIsLoading(false) } } const getStatusIcon = (status: string) => { switch (status) { case 'pending': return case 'preparing': return case 'ready': return case 'completed': return default: return } } const getStatusColor = (status: string) => { switch (status) { case 'pending': return 'bg-yellow-50 border-yellow-200' case 'preparing': return 'bg-orange-50 border-orange-200' case 'ready': return 'bg-green-50 border-green-200' case 'completed': return 'bg-blue-50 border-blue-200' default: return 'bg-muted' } } const getStatusLabel = (status: string) => { const labels: { [key: string]: string } = { pending: 'Order Confirmed', preparing: 'Being Prepared', ready: 'Ready for Pickup', completed: 'Order Completed', } return labels[status] || status } const statuses = ['pending', 'preparing', 'ready', 'completed'] const currentStatusIndex = statuses.indexOf(order?.status || 'pending') const formatDate = (dateString: string) => { return new Date(dateString).toLocaleDateString('en-IN', { year: 'numeric', month: 'long', day: 'numeric', hour: '2-digit', minute: '2-digit', }) } return (

{/* Header */}

Order Details

{/* Main Content */}

{isLoading ? (

Loading order...

) : !order ? (

Order not found

) : (

{/* Status Card with Timeline */} Order Tracking {/* Current Status */}

{getStatusIcon(order.status)}

Current Status

{getStatusLabel(order.status)}

{order.status === 'pending' && 'Your order has been confirmed. Preparation starting soon.'} {order.status === 'preparing' && 'Our team is preparing your delicious order!'} {order.status === 'ready' && '✓ Your order is ready! Please pick it up at the counter.'} {order.status === 'completed' && 'Thank you for your order!'}

{/* Status Timeline */}

Order Timeline

{statuses.map((status, idx) => (

{idx < currentStatusIndex ? ( ) : ( {idx + 1} )}

{getStatusLabel(status)}

))}

{/* Order Details */} Order #{order.id.slice(0, 8)} Placed on {formatDate(order.created_at)}

Items

{order.order_items.map((item, idx) => (

{item.menu_items.name}

Quantity: {item.quantity}

₹{(item.price * item.quantity).toFixed(2)}

))}

Subtotal ₹{order.total_amount.toFixed(2)}

Total ₹{order.total_amount.toFixed(2)}

{/* Action Buttons */}

)}

) } [V0_FILE]typescript:file="app/api/admin/menu-items/[id]/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse, type NextRequest } from 'next/server' // Check admin authorization async function isAdmin(supabase: any) { const { data: { user }, } = await supabase.auth.getUser() if (!user) return false const { data: profile } = await supabase .from('user_profiles') .select('is_admin') .eq('user_id', user.id) .single() return profile?.is_admin || false } export async function PATCH( request: NextRequest, { params }: { params: { id: string } } ) { try { const supabase = await createClient() if (!(await isAdmin(supabase))) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } const body = await request.json() const { name, description, price, category_id, is_available } = body const { data: item, error } = await supabase .from('menu_items') .update({ name, description, price, category_id, is_available, }) .eq('id', params.id) .select() .single() if (error) throw error return NextResponse.json(item) } catch (error) { console.error('Update menu item error:', error) return NextResponse.json( { error: 'Failed to update menu item' }, { status: 500 } ) } } export async function DELETE( request: NextRequest, { params }: { params: { id: string } } ) { try { const supabase = await createClient() if (!(await isAdmin(supabase))) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } const { error } = await supabase .from('menu_items') .delete() .eq('id', params.id) if (error) throw error return NextResponse.json({ success: true }) } catch (error) { console.error('Delete menu item error:', error) return NextResponse.json( { error: 'Failed to delete menu item' }, { status: 500 } ) } } [V0_FILE]typescript:file="app/api/admin/orders/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse } from 'next/server' export async function GET() { try { const supabase = await createClient() const { data: { user }, } = await supabase.auth.getUser() if (!user) { return NextResponse.json({ error: 'Unauthorized' }, { status: 401 }) } // Check if user is admin const { data: profile } = await supabase .from('user_profiles') .select('is_admin') .eq('user_id', user.id) .single() if (!profile?.is_admin) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } // Get all orders with user info const { data: orders, error } = await supabase .from('orders') .select('*, user_profiles(full_name, user_id), order_items(*, menu_items(name, price))') .order('created_at', { ascending: false }) if (error) { throw error } return NextResponse.json(orders) } catch (error) { console.error('Admin orders API error:', error) return NextResponse.json( { error: 'Failed to fetch orders' }, { status: 500 } ) } } [V0_FILE]typescript:file="app/api/admin/orders/[id]/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse, type NextRequest } from 'next/server' // Check admin authorization async function isAdmin(supabase: any) { const { data: { user }, } = await supabase.auth.getUser() if (!user) return false const { data: profile } = await supabase .from('user_profiles') .select('is_admin') .eq('user_id', user.id) .single() return profile?.is_admin || false } export async function PATCH( request: NextRequest, { params }: { params: { id: string } } ) { try { const supabase = await createClient() if (!(await isAdmin(supabase))) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } const body = await request.json() const { status } = body if (!status) { return NextResponse.json( { error: 'Status is required' }, { status: 400 } ) } const { data: order, error } = await supabase .from('orders') .update({ status }) .eq('id', params.id) .select() .single() if (error) throw error return NextResponse.json(order) } catch (error) { console.error('Update order status error:', error) return NextResponse.json( { error: 'Failed to update order status' }, { status: 500 } ) } } [V0_FILE]typescript:file="app/api/admin/menu-items/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse, type NextRequest } from 'next/server' // Check admin authorization async function isAdmin(supabase: any) { const { data: { user }, } = await supabase.auth.getUser() if (!user) return false const { data: profile } = await supabase .from('user_profiles') .select('is_admin') .eq('user_id', user.id) .single() return profile?.is_admin || false } export async function GET() { try { const supabase = await createClient() if (!(await isAdmin(supabase))) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } const { data: items, error } = await supabase .from('menu_items') .select('*, categories(name)') .order('name') if (error) throw error return NextResponse.json(items) } catch (error) { console.error('Menu items admin API error:', error) return NextResponse.json( { error: 'Failed to fetch menu items' }, { status: 500 } ) } } export async function POST(request: NextRequest) { try { const supabase = await createClient() if (!(await isAdmin(supabase))) { return NextResponse.json({ error: 'Forbidden' }, { status: 403 }) } const body = await request.json() const { name, description, price, category_id, is_available } = body if (!name || !price || !category_id) { return NextResponse.json( { error: 'Missing required fields' }, { status: 400 } ) } const { data: item, error } = await supabase .from('menu_items') .insert({ name, description, price, category_id, is_available: is_available ?? true, }) .select() .single() if (error) throw error return NextResponse.json(item, { status: 201 }) } catch (error) { console.error('Create menu item error:', error) return NextResponse.json( { error: 'Failed to create menu item' }, { status: 500 } ) } } [V0_FILE]typescriptreact:file="app/page.tsx" import { Button } from '@/components/ui/button' import Link from 'next/link' import { ShoppingCart, UtensilsCrossed, Clock } from 'lucide-react' export default function Home() { return (

{/* Hero Section */}

QuickBite

{/* Hero Content */}

Order Food From Your Canteen

Skip the queues, save time. Browse our menu, customize your order, and get it ready when you need it.

{/* Features Section */}

Why Choose QuickBite?

{/* Feature 1 */}

Easy Ordering

Browse through our extensive menu, add items to your cart, and checkout in just a few clicks.

{/* Feature 2 */}

Real-Time Updates

Track your order status in real-time and get notified when it's ready for pickup.

{/* Feature 3 */}

Fresh & Varied

Enjoy a wide variety of fresh food options updated daily by the canteen management.

{/* How It Works */}

How It Works

Create Your Account

Browse the Menu

Explore our daily menu, filter by category, and check prices.

Place Your Order

Add items to your cart, review, and checkout securely.

Pick Up Your Order

Get notified when your order is ready and pick it up from the counter.

{/* CTA Section */}

Ready to Order?

Join our community and enjoy faster, easier canteen ordering.

{/* Footer */}

) } [V0_FILE]sql:file="scripts/fix-rls-policies.sql" -- Drop all RLS policies that cause infinite recursion DROP POLICY IF EXISTS "Admins can view all profiles" ON public.user_profiles; DROP POLICY IF EXISTS "Admins can manage menu items" ON public.menu_items; DROP POLICY IF EXISTS "Admins can view all orders" ON public.orders; DROP POLICY IF EXISTS "Admins can update order status" ON public.orders; DROP POLICY IF EXISTS "Admins can view all order items" ON public.order_items; -- Drop existing function if it exists DROP FUNCTION IF EXISTS public.is_admin(); -- Create helper function to check if user is admin CREATE OR REPLACE FUNCTION public.is_admin() RETURNS BOOLEAN AS $$ DECLARE user_role TEXT; BEGIN SELECT role INTO user_role FROM public.user_profiles WHERE id = auth.uid(); RETURN user_role = 'admin'; END; $$ LANGUAGE plpgsql SECURITY DEFINER; -- Recreate RLS policies using the helper function CREATE POLICY "Admins can view all profiles" ON public.user_profiles FOR SELECT USING (public.is_admin()); CREATE POLICY "Admins can manage menu items" ON public.menu_items FOR ALL USING (public.is_admin()); CREATE POLICY "Admins can view all orders" ON public.orders FOR SELECT USING (public.is_admin()); CREATE POLICY "Admins can update order status" ON public.orders FOR UPDATE USING (public.is_admin()); CREATE POLICY "Admins can view all order items" ON public.order_items FOR SELECT USING (public.is_admin()); [V0_FILE]typescript:file="lib/supabase/client.ts" import { createBrowserClient } from '@supabase/ssr' declare global { var __supabaseClient: ReturnType | undefined } export function createClient() { if (!globalThis.__supabaseClient) { globalThis.__supabaseClient = createBrowserClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!, ) } return globalThis.__supabaseClient } [V0_FILE]css:file="app/globals.css" @import 'tailwindcss'; @import 'tw-animate-css'; @custom-variant dark (&:is(.dark *)); :root { --background: oklch(0.98 0 0); --foreground: oklch(0.12 0.01 280); --card: oklch(0.99 0 0); --card-foreground: oklch(0.12 0.01 280); --popover: oklch(0.99 0 0); --popover-foreground: oklch(0.12 0.01 280); --primary: oklch(0.65 0.25 280); --primary-foreground: oklch(0.98 0 0); --secondary: oklch(0.72 0.22 35); --secondary-foreground: oklch(0.98 0 0); --muted: oklch(0.92 0.01 0); --muted-foreground: oklch(0.52 0.01 0); --accent: oklch(0.68 0.24 45); --accent-foreground: oklch(0.98 0 0); --destructive: oklch(0.63 0.25 29); --destructive-foreground: oklch(0.98 0 0); --border: oklch(0.89 0.015 0); --input: oklch(0.95 0.01 0); --ring: oklch(0.65 0.25 280); --chart-1: oklch(0.65 0.25 280); --chart-2: oklch(0.72 0.22 35); --chart-3: oklch(0.68 0.24 45); --chart-4: oklch(0.75 0.2 90); --chart-5: oklch(0.62 0.22 320); --radius: 0.75rem; --sidebar: oklch(0.98 0 0); --sidebar-foreground: oklch(0.12 0.01 280); --sidebar-primary: oklch(0.65 0.25 280); --sidebar-primary-foreground: oklch(0.98 0 0); --sidebar-accent: oklch(0.72 0.22 35); --sidebar-accent-foreground: oklch(0.12 0.01 280); --sidebar-border: oklch(0.89 0.015 0); --sidebar-ring: oklch(0.65 0.25 280); } .dark { --background: oklch(0.12 0.01 280); --foreground: oklch(0.96 0.01 0); --card: oklch(0.18 0.01 280); --card-foreground: oklch(0.96 0.01 0); --popover: oklch(0.18 0.01 280); --popover-foreground: oklch(0.96 0.01 0); --primary: oklch(0.75 0.22 280); --primary-foreground: oklch(0.12 0.01 280); --secondary: oklch(0.76 0.2 35); --secondary-foreground: oklch(0.12 0.01 280); --muted: oklch(0.28 0.01 0); --muted-foreground: oklch(0.62 0.01 0); --accent: oklch(0.75 0.22 45); --accent-foreground: oklch(0.12 0.01 280); --destructive: oklch(0.63 0.25 29); --destructive-foreground: oklch(0.96 0.01 0); --border: oklch(0.26 0.015 0); --input: oklch(0.22 0.01 0); --ring: oklch(0.75 0.22 280); --chart-1: oklch(0.75 0.22 280); --chart-2: oklch(0.76 0.2 35); --chart-3: oklch(0.75 0.22 45); --chart-4: oklch(0.78 0.18 90); --chart-5: oklch(0.72 0.2 320); --sidebar: oklch(0.18 0.01 280); --sidebar-foreground: oklch(0.96 0.01 0); --sidebar-primary: oklch(0.75 0.22 280); --sidebar-primary-foreground: oklch(0.12 0.01 280); --sidebar-accent: oklch(0.76 0.2 35); --sidebar-accent-foreground: oklch(0.12 0.01 280); --sidebar-border: oklch(0.26 0.015 0); --sidebar-ring: oklch(0.75 0.22 280); } @theme inline { --font-sans: 'Geist', 'Geist Fallback'; --font-mono: 'Geist Mono', 'Geist Mono Fallback'; --color-background: var(--background); --color-foreground: var(--foreground); --color-card: var(--card); --color-card-foreground: var(--card-foreground); --color-popover: var(--popover); --color-popover-foreground: var(--popover-foreground); --color-primary: var(--primary); --color-primary-foreground: var(--primary-foreground); --color-secondary: var(--secondary); --color-secondary-foreground: var(--secondary-foreground); --color-muted: var(--muted); --color-muted-foreground: var(--muted-foreground); --color-accent: var(--accent); --color-accent-foreground: var(--accent-foreground); --color-destructive: var(--destructive); --color-destructive-foreground: var(--destructive-foreground); --color-border: var(--border); --color-input: var(--input); --color-ring: var(--ring); --color-chart-1: var(--chart-1); --color-chart-2: var(--chart-2); --color-chart-3: var(--chart-3); --color-chart-4: var(--chart-4); --color-chart-5: var(--chart-5); --radius-sm: calc(var(--radius) - 4px); --radius-md: calc(var(--radius) - 2px); --radius-lg: var(--radius); --radius-xl: calc(var(--radius) + 4px); --color-sidebar: var(--sidebar); --color-sidebar-foreground: var(--sidebar-foreground); --color-sidebar-primary: var(--sidebar-primary); --color-sidebar-primary-foreground: var(--sidebar-primary-foreground); --color-sidebar-accent: var(--sidebar-accent); --color-sidebar-accent-foreground: var(--sidebar-accent-foreground); --color-sidebar-border: var(--sidebar-border); --color-sidebar-ring: var(--sidebar-ring); } @layer base { * { @apply border-border outline-ring/50; } body { @apply bg-background text-foreground; } } [V0_FILE]sql:file="scripts/fix-menu-rls.sql" -- Disable RLS on menu_items (it's public data that doesn't need RLS) ALTER TABLE public.menu_items DISABLE ROW LEVEL SECURITY; -- Disable RLS on categories (it's public reference data) ALTER TABLE public.categories DISABLE ROW LEVEL SECURITY; -- Drop all problematic policies from menu_items if they exist DROP POLICY IF EXISTS "Everyone can view available menu items" ON public.menu_items; DROP POLICY IF EXISTS "Admins can manage menu items" ON public.menu_items; [V0_FILE]typescriptreact:file="app/admin/page.tsx" 'use client' import { Button } from '@/components/ui/button' import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '@/components/ui/card' import { Badge } from '@/components/ui/badge' import { Tabs, TabsContent, TabsList, TabsTrigger } from '@/components/ui/tabs' import { useSupabase } from '@/hooks/use-supabase' import { useRouter } from 'next/navigation' import { useEffect, useState } from 'react' import { LogOut, Plus, Trash2, Clock, Flame, Package, CheckCircle } from 'lucide-react' import { useToast } from '@/hooks/use-toast' import { createClient } from '@supabase/supabase-js' // Import createClient interface MenuItem { id: string name: string description: string price: number is_available: boolean category_id: string categories: { name: string } } interface OrderItem { menu_item_id: string quantity: number price: number menu_items: { name: string } } interface Order { id: string status: string total_amount: number created_at: string user_profiles: { full_name: string } order_items: OrderItem[] } export default function AdminDashboard() { const [menuItems, setMenuItems] = useState([]) const [orders, setOrders] = useState([]) const [isLoading, setIsLoading] = useState(true) const [activeTab, setActiveTab] = useState('orders') const router = useRouter() const { toast } = useToast() const supabase = useSupabase() // Use the imported createClient useEffect(() => { checkAdmin() }, []) const checkAdmin = async () => { const { data: { user }, } = await supabase.auth.getUser() if (!user) { router.push('/auth/login') return } // Note: In production, verify admin status from user metadata or profiles table fetchData() } const fetchData = async () => { try { const [ordersRes, menuRes] = await Promise.all([ fetch('/api/admin/orders'), fetch('/api/admin/menu-items'), ]) if (ordersRes.status === 403 || menuRes.status === 403) { toast({ title: 'Access Denied', description: 'You do not have admin privileges', variant: 'destructive', }) router.push('/dashboard') return } if (ordersRes.ok) { const ordersData = await ordersRes.json() setOrders(ordersData) } if (menuRes.ok) { const menuData = await menuRes.json() setMenuItems(menuData) } } catch (error) { console.error('Error fetching data:', error) toast({ title: 'Error', description: 'Failed to load dashboard data', variant: 'destructive', }) } finally { setIsLoading(false) } } const handleUpdateOrderStatus = async (orderId: string, newStatus: string) => { try { const response = await fetch(`/api/admin/orders/${orderId}`, { method: 'PATCH', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ status: newStatus }), }) if (!response.ok) throw new Error('Failed to update order') const updatedOrder = await response.json() setOrders(orders.map((o) => (o.id === orderId ? updatedOrder : o))) toast({ title: 'Success', description: 'Order status updated', }) } catch (error) { console.error('Error updating order:', error) toast({ title: 'Error', description: 'Failed to update order status', variant: 'destructive', }) } } const handleDeleteMenuItem = async (itemId: string) => { if (!window.confirm('Are you sure you want to delete this item?')) return try { const response = await fetch(`/api/admin/menu-items/${itemId}`, { method: 'DELETE', }) if (!response.ok) throw new Error('Failed to delete item') setMenuItems(menuItems.filter((item) => item.id !== itemId)) toast({ title: 'Success', description: 'Menu item deleted', }) } catch (error) { console.error('Error deleting item:', error) toast({ title: 'Error', description: 'Failed to delete menu item', variant: 'destructive', }) } } const handleLogout = async () => { await supabase.auth.signOut() router.push('/auth/login') } const getStatusColor = (status: string) => { switch (status.toLowerCase()) { case 'pending': return 'bg-yellow-100 text-yellow-800' case 'ready': return 'bg-green-100 text-green-800' case 'completed': return 'bg-blue-100 text-blue-800' case 'cancelled': return 'bg-red-100 text-red-800' default: return 'bg-gray-100 text-gray-800' } } const formatDate = (dateString: string) => { return new Date(dateString).toLocaleDateString('en-IN', { year: 'numeric', month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit', }) } return (

{/* Header */}

Admin Dashboard

Manage menu and orders

{/* Main Content */}

{isLoading ? (

Loading dashboard...

) : ( Kitchen Display Orders Menu Items {/* Kitchen Display Tab */}

{/* Kitchen Status Overview */}

Pending Orders

{orders.filter(o => o.status === 'pending').length}

Preparing

{orders.filter(o => o.status === 'preparing').length}

Ready

{orders.filter(o => o.status === 'ready').length}

Completed

{orders.filter(o => o.status === 'completed').length}

{/* Kitchen Kanban Board */}

{['pending', 'preparing', 'ready', 'completed'].map((status) => (

{status === 'pending' && } {status === 'preparing' && } {status === 'ready' && } {status === 'completed' && }

{status}

{orders.filter(o => o.status === status).map((order) => (

Order #{order.id.slice(0, 8)} {order.user_profiles.full_name}

{new Date(order.created_at).toLocaleTimeString()}

{order.order_items.map((item, idx) => (

{item.quantity}x {item.menu_items.name} ₹{(item.price * item.quantity).toFixed(0)}

))}

{status !== 'completed' && ( )}

))} {orders.filter(o => o.status === status).length === 0 && (

No orders

)}

))}

{/* Orders Tab */} {orders.length === 0 ? ( No Orders No orders have been placed yet ) : (

{orders.map((order) => (

Order #{order.id.slice(0, 8)} {order.user_profiles.full_name} • {formatDate(order.created_at)}

{order.status.charAt(0).toUpperCase() + order.status.slice(1)}

Items

{item.quantity}x {item.menu_items.name} - ₹ {(item.price * item.quantity).toFixed(2)}

Total ₹{order.total_amount.toFixed(2)}

))}

)} {/* Menu Items Tab */}

Menu Items

{menuItems.length === 0 ? ( No Items Add menu items to get started ) : (

{menuItems.map((item) => (

{item.name} {item.categories?.name}

{item.is_available ? 'Available' : 'Unavailable'} ₹{item.price.toFixed(2)}

{item.description}

))}

)} )}

) } [V0_FILE]typescript:file="hooks/use-supabase.ts" 'use client' import { createClient } from '@/lib/supabase/client' export function useSupabase() { return createClient() } [V0_FILE]jpg:file="public/menu/pizza.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/pizza-lkK79I8NWbQ5UM8XlsU2YEoNzvZGvy.jpg" [V0_FILE]jpg:file="public/menu/samosa.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/samosa-BcFWIUq93wKQgK5rbi3Hxdl0D24v54.jpg" [V0_FILE]jpg:file="public/menu/burger.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/burger-cgTl4zYgIUsjYUO4TifiPBQVpzrKxw.jpg" [V0_FILE]jpg:file="public/menu/biryani.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/biryani-IIjTalpyheWvNWi1w0l3JtYCvZbK1y.jpg" [V0_FILE]jpg:file="public/menu/pasta.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/pasta-t5Lx72ff5LL59f4bzwHuc3wyF1bVRT.jpg" [V0_FILE]jpg:file="public/menu/ice-cream.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/ice-cream-sy7Ao7s2PaacnK4fzJp7JLe0sbzmXJ.jpg" [V0_FILE]jpg:file="public/menu/coffee.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/coffee-3mWB7AYfA4dpGcNhtW4rim2XESIaLN.jpg" [V0_FILE]jpg:file="public/menu/paneer-tikka.jpg" url="https://hebbkx1anhila5yf.public.blob.vercel-storage.com/attachments/gen-images/public/menu/paneer-tikka-aEJavgkSE5UNHchPnmOfqAY0xmtqq0.jpg" [V0_FILE]sql:file="scripts/seed-menu.sql" -- Delete existing menu items and categories to start fresh DELETE FROM public.order_items; DELETE FROM public.orders; DELETE FROM public.menu_items; DELETE FROM public.categories; -- Seed Categories INSERT INTO public.categories (name, description) VALUES ('Breakfast', 'Morning specials to start your day'), ('Lunch', 'Hearty lunch options'), ('Snacks', 'Light bites and snacks'), ('Beverages', 'Drinks and beverages'), ('Desserts', 'Sweet treats') ON CONFLICT DO NOTHING; -- Seed Menu Items - BREAKFAST (5 items) INSERT INTO public.menu_items (name, description, price, category_id, is_available, image_url) VALUES ('Masala Dosa', 'Crispy dosa with potato and vegetable filling', 80.00, (SELECT id FROM public.categories WHERE name = 'Breakfast'), true, NULL), ('Idli with Sambar', 'Fluffy steamed rice cakes with lentil stew', 60.00, (SELECT id FROM public.categories WHERE name = 'Breakfast'), true, NULL), ('Aloo Paratha', 'Layered bread with spiced potato filling', 75.00, (SELECT id FROM public.categories WHERE name = 'Breakfast'), true, NULL), ('Poha', 'Flattened rice with vegetables and peanuts', 50.00, (SELECT id FROM public.categories WHERE name = 'Breakfast'), true, NULL), ('Omelette with Toast', 'Three-egg omelette with buttered toast', 55.00, (SELECT id FROM public.categories WHERE name = 'Breakfast'), true, NULL) ON CONFLICT DO NOTHING; -- Seed Menu Items - LUNCH (5 items) INSERT INTO public.menu_items (name, description, price, category_id, is_available, image_url) VALUES ('Chicken Biryani', 'Fragrant basmati rice with marinated chicken and spices', 180.00, (SELECT id FROM public.categories WHERE name = 'Lunch'), true, '/menu/biryani.jpg'), ('Margherita Pizza', 'Fresh mozzarella, tomato sauce, and basil on crispy dough', 200.00, (SELECT id FROM public.categories WHERE name = 'Lunch'), true, '/menu/pizza.jpg'), ('Deluxe Burger', 'Juicy beef patty with lettuce, tomato, and cheese', 120.00, (SELECT id FROM public.categories WHERE name = 'Lunch'), true, '/menu/burger.jpg'), ('Pasta Carbonara', 'Creamy Italian pasta with bacon and parmesan cheese', 160.00, (SELECT id FROM public.categories WHERE name = 'Lunch'), true, '/menu/pasta.jpg'), ('Vegetable Biryani', 'Fragrant basmati rice with mixed vegetables and herbs', 140.00, (SELECT id FROM public.categories WHERE name = 'Lunch'), true, NULL) ON CONFLICT DO NOTHING; -- Seed Menu Items - SNACKS (5 items) INSERT INTO public.menu_items (name, description, price, category_id, is_available, image_url) VALUES ('Samosa', 'Crispy triangular pastry with spiced potato and peas filling', 30.00, (SELECT id FROM public.categories WHERE name = 'Snacks'), true, '/menu/samosa.jpg'), ('Paneer Tikka', 'Grilled cottage cheese cubes marinated in yogurt and spices', 85.00, (SELECT id FROM public.categories WHERE name = 'Snacks'), true, '/menu/paneer-tikka.jpg'), ('Spring Rolls', 'Crispy rolls with mixed vegetables and sweet dipping sauce', 45.00, (SELECT id FROM public.categories WHERE name = 'Snacks'), true, NULL), ('Vegetable Pakora', 'Battered and fried vegetable fritters with mint chutney', 40.00, (SELECT id FROM public.categories WHERE name = 'Snacks'), true, NULL), ('Garlic Bread', 'Toasted bread with garlic butter and herbs', 70.00, (SELECT id FROM public.categories WHERE name = 'Snacks'), true, NULL) ON CONFLICT DO NOTHING; -- Seed Menu Items - BEVERAGES (5 items) INSERT INTO public.menu_items (name, description, price, category_id, is_available, image_url) VALUES ('Masala Chai', 'Spiced milk tea with ginger and cardamom', 25.00, (SELECT id FROM public.categories WHERE name = 'Beverages'), true, NULL), ('Fresh Orange Juice', 'Freshly squeezed orange juice without pulp', 50.00, (SELECT id FROM public.categories WHERE name = 'Beverages'), true, NULL), ('Cappuccino', 'Creamy coffee with milk foam and chocolate powder', 80.00, (SELECT id FROM public.categories WHERE name = 'Beverages'), true, '/menu/coffee.jpg'), ('Mango Lassi', 'Thick yogurt-based mango smoothie', 60.00, (SELECT id FROM public.categories WHERE name = 'Beverages'), true, NULL), ('Cold Lemonade', 'Refreshing lemon juice with mint and ice', 30.00, (SELECT id FROM public.categories WHERE name = 'Beverages'), true, NULL) ON CONFLICT DO NOTHING; -- Seed Menu Items - DESSERTS (5 items) INSERT INTO public.menu_items (name, description, price, category_id, is_available, image_url) VALUES ('Gulab Jamun', 'Soft milk solids soaked in aromatic sugar syrup', 45.00, (SELECT id FROM public.categories WHERE name = 'Desserts'), true, NULL), ('Kheer', 'Creamy rice pudding with condensed milk and dry nuts', 50.00, (SELECT id FROM public.categories WHERE name = 'Desserts'), true, NULL), ('Jalebi', 'Spiraled sweet fried dough in orange sugar syrup', 35.00, (SELECT id FROM public.categories WHERE name = 'Desserts'), true, NULL), ('Ice Cream Sundae', 'Vanilla ice cream with chocolate sauce and whipped cream', 60.00, (SELECT id FROM public.categories WHERE name = 'Desserts'), true, '/menu/ice-cream.jpg'), ('Chocolate Brownie', 'Rich chocolate brownie with walnuts and fudge', 65.00, (SELECT id FROM public.categories WHERE name = 'Desserts'), true, NULL) ON CONFLICT DO NOTHING; [V0_FILE]sql:file="scripts/create-profile-trigger.sql" -- Create a function to automatically create user_profile when auth.user signs up CREATE OR REPLACE FUNCTION public.handle_new_user() RETURNS TRIGGER LANGUAGE plpgsql SECURITY DEFINER SET search_path = public AS $$ BEGIN INSERT INTO public.user_profiles (id, email, full_name, role) VALUES ( new.id, new.email, new.raw_user_meta_data ->> 'full_name', 'student' ) ON CONFLICT (id) DO NOTHING; RETURN new; END; $$; -- Drop the trigger if it exists DROP TRIGGER IF EXISTS on_auth_user_created ON auth.users; -- Create the trigger to fire after a new user is created CREATE TRIGGER on_auth_user_created AFTER INSERT ON auth.users FOR EACH ROW EXECUTE FUNCTION public.handle_new_user(); -- Migrate existing auth users to user_profiles if they don't have a profile INSERT INTO public.user_profiles (id, email, full_name, role) SELECT id, email, raw_user_meta_data ->> 'full_name', 'student' FROM auth.users WHERE id NOT IN (SELECT id FROM public.user_profiles) ON CONFLICT (id) DO NOTHING; [V0_FILE]sql:file="scripts/create-missing-profiles.sql" -- Insert missing user profiles for existing auth users -- This handles users who signed up before the trigger was created INSERT INTO public.user_profiles (id, role) SELECT id, 'student' FROM auth.users WHERE id NOT IN (SELECT id FROM public.user_profiles) ON CONFLICT (id) DO NOTHING; [V0_FILE]typescript:file="app/api/orders/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse, type NextRequest } from 'next/server' export async function GET(request: NextRequest) { try { const supabase = await createClient() const { data: { user }, } = await supabase.auth.getUser() if (!user) { return NextResponse.json({ error: 'Unauthorized' }, { status: 401 }) } const { data: orders, error } = await supabase .from('orders') .select('*, order_items(*, menu_items(name, price))') .eq('user_id', user.id) .order('created_at', { ascending: false }) if (error) { throw error } return NextResponse.json(orders) } catch (error) { console.error('Orders API error:', error) return NextResponse.json( { error: 'Failed to fetch orders' }, { status: 500 } ) } } export async function POST(request: NextRequest) { try { const supabase = await createClient() const { data: { user }, } = await supabase.auth.getUser() if (!user) { return NextResponse.json({ error: 'Unauthorized' }, { status: 401 }) } const body = await request.json() const { items, total_amount } = body if (!items || items.length === 0) { return NextResponse.json( { error: 'Cart cannot be empty' }, { status: 400 } ) } // Validate total_amount if (!total_amount || total_amount <= 0) { return NextResponse.json( { error: 'Invalid total amount' }, { status: 400 } ) } console.log('[v0] Creating order for user:', user.id, 'Items:', items) // Create order const { data: order, error: orderError } = await supabase .from('orders') .insert({ user_id: user.id, total_amount, status: 'pending', }) .select() .single() if (orderError) { console.error('[v0] Order creation error:', orderError) throw orderError } console.log('[v0] Order created with ID:', order.id) // Create order items const orderItems = items.map((item: any) => ({ order_id: order.id, menu_item_id: item.menu_item_id, quantity: item.quantity, price_at_time: item.price, })) console.log('[v0] Creating order items:', orderItems) const { error: itemsError } = await supabase .from('order_items') .insert(orderItems) if (itemsError) { console.error('[v0] Order items creation error:', itemsError) throw itemsError } console.log('[v0] Order completed successfully') return NextResponse.json(order, { status: 201 }) } catch (error) { console.error('[v0] Create order error:', error) const errorMessage = error instanceof Error ? error.message : 'Unknown error' return NextResponse.json( { error: 'Failed to create order', details: errorMessage }, { status: 500 } ) } } [V0_FILE]typescriptreact:file="app/payment/page.tsx" 'use client' import { Button } from '@/components/ui/button' import { useRouter } from 'next/navigation' import { useEffect, useState } from 'react' import { useToast } from '@/hooks/use-toast' import { useSupabase } from '@/hooks/use-supabase' import { QrCode, Zap, CheckCircle, ArrowLeft } from 'lucide-react' interface OrderData { items: Array<{ menu_item_id: string quantity: number price_at_time: number name: string }> total_amount: number } export default function PaymentPage() { const router = useRouter() const { toast } = useToast() const supabase = useSupabase() const [orderData, setOrderData] = useState(null) const [userPoints, setUserPoints] = useState(0) const [isProcessing, setIsProcessing] = useState(false) const [paymentSuccess, setPaymentSuccess] = useState(false) const [qrScanned, setQrScanned] = useState(false) useEffect(() => { const fetchUserData = async () => { try { const stored = sessionStorage.getItem('pending_order') if (stored) { const parsed = JSON.parse(stored) setOrderData(parsed) } const { data: { user }, } = await supabase.auth.getUser() if (user) { const { data: profile } = await supabase .from('user_profiles') .select('points') .eq('id', user.id) .single() setUserPoints(profile?.points || 0) } } catch (error) { console.error('[v0] Failed to load payment data:', error) } } fetchUserData() }, []) const handleQRScan = async () => { if (!orderData) return setQrScanned(true) setIsProcessing(true) try { // Simulate QR scan processing await new Promise((resolve) => setTimeout(resolve, 1500)) const { data: { user }, } = await supabase.auth.getUser() if (!user) throw new Error('User not authenticated') // Deduct points from user const pointsToDeduct = Math.ceil(orderData.total_amount) const { error: updateError } = await supabase .from('user_profiles') .update({ points: Math.max(0, userPoints - pointsToDeduct) }) .eq('id', user.id) if (updateError) throw updateError // Create the order const { data: order, error: orderError } = await supabase .from('orders') .insert({ user_id: user.id, total_amount: orderData.total_amount, status: 'pending', }) .select() .single() if (orderError) throw orderError // Create order items const orderItems = orderData.items.map((item) => ({ order_id: order.id, menu_item_id: item.menu_item_id, quantity: item.quantity, price_at_time: item.price_at_time, })) const { error: itemsError } = await supabase.from('order_items').insert(orderItems) if (itemsError) throw itemsError setPaymentSuccess(true) sessionStorage.removeItem('pending_order') setTimeout(() => { router.push(`/orders/${order.id}`) }, 2000) } catch (error) { console.error('[v0] Payment error:', error) toast({ title: 'Payment Failed', description: error instanceof Error ? error.message : 'Failed to process payment', variant: 'destructive', }) setQrScanned(false) } finally { setIsProcessing(false) } } if (!orderData) { return (

Loading payment page...

) } const pointsRequired = Math.ceil(orderData.total_amount) const hasEnoughPoints = userPoints >= pointsRequired const pointsShortage = Math.max(0, pointsRequired - userPoints) return (

{/* Header */}

Points Payment

{/* Order Summary */}

Order Summary

{orderData.items.map((item, idx) => (

{item.name}

Qty: {item.quantity}

{(item.price_at_time * item.quantity).toFixed(0)} pts

))}

Total

{Math.ceil(orderData.total_amount)} pts

{/* Points Info */}

Your Points

{userPoints}

{hasEnoughPoints ? (

You have enough points to complete this order

) : (

You need {pointsShortage} more points to complete this order

)}

{/* QR Code Section */}

{!paymentSuccess ? (

Scan the QR code at the counter to complete payment

{!hasEnoughPoints && (

Insufficient Points

You need {pointsShortage} more points. Please try again later.

)}

) : (

Payment Successful!

Your order has been placed and will be ready soon.

Points deducted: {Math.ceil(orderData.total_amount)}

)}

) } [V0_FILE]sql:file="scripts/add-points-to-profiles.sql" -- Add points column to user_profiles if it doesn't exist ALTER TABLE public.user_profiles ADD COLUMN IF NOT EXISTS points INTEGER DEFAULT 500; -- Update existing profiles to have 500 points if they don't have any UPDATE public.user_profiles SET points = 500 WHERE points IS NULL OR points = 0; [V0_FILE]sql:file="scripts/add-features-schema.sql" -- Add loyalty tiers tracking to user_profiles (points column already exists) ALTER TABLE public.user_profiles ADD COLUMN IF NOT EXISTS loyalty_tier TEXT DEFAULT 'bronze' CHECK (loyalty_tier IN ('bronze', 'silver', 'gold', 'platinum')), ADD COLUMN IF NOT EXISTS total_orders INT DEFAULT 0; -- Create loyalty tiers configuration table CREATE TABLE IF NOT EXISTS public.loyalty_tiers ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name TEXT NOT NULL UNIQUE, min_points INT NOT NULL, max_points INT, benefits TEXT, discount_percentage DECIMAL(5, 2) DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create special offers table CREATE TABLE IF NOT EXISTS public.special_offers ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title TEXT NOT NULL, description TEXT, discount_type TEXT CHECK (discount_type IN ('percentage', 'fixed')), discount_value DECIMAL(10, 2) NOT NULL, start_date TIMESTAMP NOT NULL, end_date TIMESTAMP NOT NULL, is_active BOOLEAN DEFAULT true, created_by UUID REFERENCES public.user_profiles(id), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create combo/bundle meals table CREATE TABLE IF NOT EXISTS public.combo_meals ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), name TEXT NOT NULL, description TEXT, original_price DECIMAL(10, 2) NOT NULL, combo_price DECIMAL(10, 2) NOT NULL, image_url TEXT, is_active BOOLEAN DEFAULT true, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create combo items junction table CREATE TABLE IF NOT EXISTS public.combo_items ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), combo_id UUID NOT NULL REFERENCES public.combo_meals(id) ON DELETE CASCADE, menu_item_id UUID NOT NULL REFERENCES public.menu_items(id) ON DELETE CASCADE, quantity INT DEFAULT 1 ); -- Create scheduled orders table CREATE TABLE IF NOT EXISTS public.scheduled_orders ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID NOT NULL REFERENCES public.user_profiles(id) ON DELETE CASCADE, scheduled_time TIMESTAMP NOT NULL, status TEXT DEFAULT 'scheduled' CHECK (status IN ('scheduled', 'confirmed', 'completed', 'cancelled')), notes TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create group orders table CREATE TABLE IF NOT EXISTS public.group_orders ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), creator_id UUID NOT NULL REFERENCES public.user_profiles(id) ON DELETE CASCADE, group_code TEXT NOT NULL UNIQUE, group_name TEXT, total_cost DECIMAL(10, 2) DEFAULT 0, status TEXT DEFAULT 'open' CHECK (status IN ('open', 'locked', 'completed', 'cancelled')), deadline TIMESTAMP, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Create group order members table CREATE TABLE IF NOT EXISTS public.group_order_members ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), group_order_id UUID NOT NULL REFERENCES public.group_orders(id) ON DELETE CASCADE, user_id UUID NOT NULL REFERENCES public.user_profiles(id) ON DELETE CASCADE, items_cost DECIMAL(10, 2) DEFAULT 0, status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'paid')) ); -- Create leaderboard view (for points ranking) CREATE OR REPLACE VIEW public.points_leaderboard AS SELECT id, email, full_name, points, loyalty_tier, total_orders, ROW_NUMBER() OVER (ORDER BY points DESC) as rank FROM public.user_profiles WHERE role = 'student' ORDER BY points DESC; -- Create indexes for performance CREATE INDEX idx_orders_user_status ON public.orders(user_id, status); CREATE INDEX idx_orders_created ON public.orders(created_at DESC); CREATE INDEX idx_special_offers_active ON public.special_offers(is_active, end_date); CREATE INDEX idx_combo_meals_active ON public.combo_meals(is_active); CREATE INDEX idx_scheduled_orders_user ON public.scheduled_orders(user_id, scheduled_time); CREATE INDEX idx_group_orders_creator ON public.group_orders(creator_id); CREATE INDEX idx_user_points ON public.user_profiles(points DESC); [V0_FILE]typescriptreact:file="app/leaderboard/page.tsx" 'use client' import { useEffect, useState } from 'react' import { Card, CardContent, CardDescription, CardHeader, CardTitle } from '@/components/ui/card' import { Badge } from '@/components/ui/badge' import { Button } from '@/components/ui/button' import { useSupabase } from '@/hooks/use-supabase' import Link from 'next/link' import { Trophy, Star, Zap } from 'lucide-react' interface LeaderboardEntry { id: string email: string full_name: string points: number loyalty_tier: string total_orders: number rank: number } export default function LeaderboardPage() { const [leaderboard, setLeaderboard] = useState([]) const [userRank, setUserRank] = useState(null) const [isLoading, setIsLoading] = useState(true) const supabase = useSupabase() useEffect(() => { fetchLeaderboard() }, []) const fetchLeaderboard = async () => { try { const { data: { user } } = await supabase.auth.getUser() // Fetch leaderboard from view const { data, error } = await supabase .from('points_leaderboard') .select('*') .limit(50) if (error) throw error const entries = data?.map((item: any) => ({ ...item, email: item.email || 'Student', full_name: item.full_name || item.email || 'Anonymous', })) || [] setLeaderboard(entries) // Find current user's rank if (user && entries.length > 0) { const userEntry = entries.find((e: any) => e.id === user.id) setUserRank(userEntry || null) } } catch (error) { console.error('[v0] Error fetching leaderboard:', error) } finally { setIsLoading(false) } } const getTierBadgeColor = (tier: string) => { switch (tier) { case 'bronze': return 'bg-orange-100 text-orange-800' case 'silver': return 'bg-gray-100 text-gray-800' case 'gold': return 'bg-yellow-100 text-yellow-800' case 'platinum': return 'bg-blue-100 text-blue-800' default: return 'bg-muted text-muted-foreground' } } const getRankIcon = (rank: number) => { if (rank === 1) return if (rank === 2) return if (rank === 3) return return } return (

{/* Header */}

Leaderboard

Top point holders

{/* Main Content */}

{isLoading ? (

Loading leaderboard...

) : (

{/* User's Rank Card */} {userRank && (

Your Rank

#{userRank.rank}

Points

{userRank.points}

)} {/* Leaderboard Table */} Top Performers Points collected by students

{leaderboard.length === 0 ? (

No leaderboard data available

) : ( leaderboard.map((entry) => (

{/* Rank */}

{getRankIcon(entry.rank)} #{entry.rank}

{/* User Info */}

{entry.full_name}

{entry.email}

{/* Tier */} {entry.loyalty_tier.charAt(0).toUpperCase() + entry.loyalty_tier.slice(1)} {/* Stats */}

Orders

{entry.total_orders}

Points

{entry.points}

)) )}

{/* Loyalty Tiers Info */} Loyalty Tiers

{['Bronze', 'Silver', 'Gold', 'Platinum'].map((tier) => (

{tier}

Earn more points to level up!

))}

)}

) } [V0_FILE]typescript:file="app/api/special-offers/route.ts" import { createClient } from '@/lib/supabase/server' import { NextResponse } from 'next/server' export async function GET() { try { const supabase = await createClient() const { data, error } = await supabase .from('special_offers') .select('*') .eq('is_active', true) .gt('end_date', new Date().toISOString()) .order('end_date', { ascending: true }) if (error) throw error return NextResponse.json(data) } catch (error) { console.error('[v0] Error fetching offers:', error) return NextResponse.json({ error: 'Failed to fetch offers' }, { status: 500 }) } } [V0_FILE]sql:file="scripts/seed-offers-combos.sql" -- Seed Special Offers INSERT INTO public.special_offers (title, description, discount_type, discount_value, start_date, end_date, is_active) VALUES ('Lunch Hour Special', '20% off on all lunch items between 12-2 PM', 'percentage', 20, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '30 days', true), ('Breakfast Deal', 'Get 50 points bonus on breakfast orders', 'fixed', 50, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '30 days', true), ('Friday Feast', '₹100 discount on orders above ₹500', 'fixed', 100, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '7 days', true), ('Happy Hour', '15% off on beverages and desserts', 'percentage', 15, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '15 days', true) ON CONFLICT DO NOTHING; -- Seed Combo Meals INSERT INTO public.combo_meals (name, description, original_price, combo_price, is_active) VALUES ('Biryani Combo', 'Chicken Biryani + Lassi + Dessert', 350, 299, true), ('Pizza Combo', 'Margherita Pizza + Cold Drink + Garlic Bread', 400, 329, true), ('Breakfast Combo', 'Masala Dosa + Idli + Sambar + Tea', 220, 179, true), ('Student Pack', 'Burger + Fries + Juice', 250, 199, true), ('Premium Lunch', 'Chicken Biryani + Paneer Tikka + Lassi + Brownie', 500, 399, true) ON CONFLICT DO NOTHING; -- Seed Combo Items (linking menu items to combos) -- Biryani Combo items INSERT INTO public.combo_items (combo_id, menu_item_id, quantity) SELECT (SELECT id FROM public.combo_meals WHERE name = 'Biryani Combo'), (SELECT id FROM public.menu_items WHERE name = 'Chicken Biryani'), 1 WHERE NOT EXISTS ( SELECT 1 FROM public.combo_items WHERE combo_id = (SELECT id FROM public.combo_meals WHERE name = 'Biryani Combo') ); -- Pizza Combo items INSERT INTO public.combo_items (combo_id, menu_item_id, quantity) SELECT (SELECT id FROM public.combo_meals WHERE name = 'Pizza Combo'), (SELECT id FROM public.menu_items WHERE name = 'Margherita Pizza'), 1 WHERE NOT EXISTS ( SELECT 1 FROM public.combo_items WHERE combo_id = (SELECT id FROM public.combo_meals WHERE name = 'Pizza Combo') ); -- Breakfast Combo items INSERT INTO public.combo_items (combo_id, menu_item_id, quantity) SELECT (SELECT id FROM public.combo_meals WHERE name = 'Breakfast Combo'), (SELECT id FROM public.menu_items WHERE name = 'Masala Dosa'), 1 WHERE NOT EXISTS ( SELECT 1 FROM public.combo_items WHERE combo_id = (SELECT id FROM public.combo_meals WHERE name = 'Breakfast Combo') ); -- Student Pack items INSERT INTO public.combo_items (combo_id, menu_item_id, quantity) SELECT (SELECT id FROM public.combo_meals WHERE name = 'Student Pack'), (SELECT id FROM public.menu_items WHERE name = 'Deluxe Burger'), 1 WHERE NOT EXISTS ( SELECT 1 FROM public.combo_items WHERE combo_id = (SELECT id FROM public.combo_meals WHERE name = 'Student Pack') ); -- Premium Lunch items INSERT INTO public.combo_items (combo_id, menu_item_id, quantity) SELECT (SELECT id FROM public.combo_meals WHERE name = 'Premium Lunch'), (SELECT id FROM public.menu_items WHERE name = 'Chicken Biryani'), 1 WHERE NOT EXISTS ( SELECT 1 FROM public.combo_items WHERE combo_id = (SELECT id FROM public.combo_meals WHERE name = 'Premium Lunch') ); [V0_FILE]typescriptreact:file="components/cart-sidebar.tsx" 'use client' import { Button } from '@/components/ui/button' import { Sheet, SheetContent, SheetDescription, SheetHeader, SheetTitle, SheetTrigger, } from '@/components/ui/sheet' import { ScrollArea } from '@/components/ui/scroll-area' import { ShoppingCart, Trash2, Package, Clock, Users } from 'lucide-react' import { useState } from 'react' import { Dialog, DialogContent, DialogDescription, DialogHeader, DialogTitle, DialogTrigger, } from '@/components/ui/dialog' import { Input } from '@/components/ui/input' import { Label } from '@/components/ui/label' export interface CartItem { id: string name: string price: number quantity: number menu_item_id: string } interface CartSidebarProps { items: CartItem[] onRemoveItem: (itemId: string) => void onCheckout: () => void isLoading?: boolean } export function CartSidebar({ items, onRemoveItem, onCheckout, isLoading, }: CartSidebarProps) { const [isOpen, setIsOpen] = useState(false) const [showScheduleDialog, setShowScheduleDialog] = useState(false) const [showGroupDialog, setShowGroupDialog] = useState(false) const [scheduledTime, setScheduledTime] = useState('') const [groupCode, setGroupCode] = useState('') const totalAmount = items.reduce((sum, item) => sum + item.price * item.quantity, 0) const itemCount = items.reduce((sum, item) => sum + item.quantity, 0) return ( Your Order {itemCount} {itemCount === 1 ? 'item' : 'items'} ready to order {items.length === 0 ? (

Your cart is empty

Add items from the menu to get started

) : ( <>

{items.map((item) => (

{item.name}

{item.quantity} × ₹{item.price.toFixed(2)}

₹{(item.price * item.quantity).toFixed(2)}

))}

Estimated delivery

~15 min

Total Amount ₹{totalAmount.toFixed(2)}

{/* Order Type Options */}

)} ) } [V0_FILE]typescriptreact:file="components/special-offers-banner.tsx" 'use client' import { useEffect, useState } from 'react' import { Card, CardContent } from '@/components/ui/card' import { Badge } from '@/components/ui/badge' import { Zap, X } from 'lucide-react' interface SpecialOffer { id: string title: string description: string discount_type: 'percentage' | 'fixed' discount_value: number end_date: string } export function SpecialOffersBanner() { const [offers, setOffers] = useState([]) const [currentOfferIndex, setCurrentOfferIndex] = useState(0) const [isLoading, setIsLoading] = useState(true) const [dismissed, setDismissed] = useState(false) useEffect(() => { fetchOffers() }, []) const fetchOffers = async () => { try { const response = await fetch('/api/special-offers') const data = await response.json() setOffers(data || []) } catch (error) { console.error('[v0] Error fetching offers:', error) } finally { setIsLoading(false) } } useEffect(() => { if (offers.length > 1) { const interval = setInterval(() => { setCurrentOfferIndex((prev) => (prev + 1) % offers.length) }, 5000) return () => clearInterval(interval) } }, [offers]) if (isLoading || offers.length === 0 || dismissed) return null const offer = offers[currentOfferIndex] const discountDisplay = offer.discount_type === 'percentage' ? `${offer.discount_value}% OFF` : `₹${offer.discount_value} OFF` return (

{offer.title}

{offer.description}

{discountDisplay}

) }