[V0_FILE]sql:file="scripts/01-create-tables.sql" type="script" isMerged="true" -- Enable RLS ALTER DATABASE postgres SET "app.jwt_secret" TO 'your-jwt-secret'; -- Create enum types CREATE TYPE user_role AS ENUM ('admin', 'student', 'agent'); CREATE TYPE application_status AS ENUM ('pending', 'approved', 'rejected'); CREATE TYPE payment_status AS ENUM ('pending', 'completed', 'failed'); -- Users table CREATE TABLE users ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, email VARCHAR(255) UNIQUE NOT NULL, password_hash VARCHAR(255) NOT NULL, full_name VARCHAR(255) NOT NULL, role user_role NOT NULL DEFAULT 'student', phone VARCHAR(20), created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Universities table CREATE TABLE universities ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, name VARCHAR(255) NOT NULL, country VARCHAR(100) NOT NULL, city VARCHAR(100) NOT NULL, description TEXT, tuition_fee DECIMAL(10,2), created_by UUID REFERENCES users(id), created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Student applications table CREATE TABLE applications ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, student_id UUID REFERENCES users(id), agent_id UUID REFERENCES users(id), university_id UUID REFERENCES universities(id), status application_status DEFAULT 'pending', -- Student details first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, date_of_birth DATE, nationality VARCHAR(100), passport_number VARCHAR(50), -- Academic details previous_education VARCHAR(255), gpa DECIMAL(3,2), english_score VARCHAR(50), -- Program details program_name VARCHAR(255), intake_year INTEGER, intake_month VARCHAR(20), -- Additional info personal_statement TEXT, documents_uploaded BOOLEAN DEFAULT FALSE, approved_by UUID REFERENCES users(id), approved_at TIMESTAMP WITH TIME ZONE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Payments table CREATE TABLE payments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, application_id UUID REFERENCES applications(id), student_id UUID REFERENCES users(id), amount DECIMAL(10,2) NOT NULL, currency VARCHAR(3) DEFAULT 'USD', status payment_status DEFAULT 'pending', payment_method VARCHAR(50), transaction_id VARCHAR(255), payment_date TIMESTAMP WITH TIME ZONE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Agent assignments table CREATE TABLE agent_assignments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, agent_id UUID REFERENCES users(id), assigned_by UUID REFERENCES users(id), created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable Row Level Security ALTER TABLE users ENABLE ROW LEVEL SECURITY; ALTER TABLE universities ENABLE ROW LEVEL SECURITY; ALTER TABLE applications ENABLE ROW LEVEL SECURITY; ALTER TABLE payments ENABLE ROW LEVEL SECURITY; ALTER TABLE agent_assignments ENABLE ROW LEVEL SECURITY; -- RLS Policies -- Users can see their own data CREATE POLICY "Users can view own data" ON users FOR SELECT USING (auth.uid() = id); CREATE POLICY "Users can update own data" ON users FOR UPDATE USING (auth.uid() = id); -- Applications policies CREATE POLICY "Students can view own applications" ON applications FOR SELECT USING (student_id = auth.uid()); CREATE POLICY "Agents can view assigned applications" ON applications FOR SELECT USING (agent_id = auth.uid()); CREATE POLICY "Agents can insert applications" ON applications FOR INSERT WITH CHECK (agent_id = auth.uid()); CREATE POLICY "Agents can update applications" ON applications FOR UPDATE USING (agent_id = auth.uid()); -- Admin can see everything (will be handled in application logic) [V0_FILE]sql:file="scripts/02-seed-data.sql" type="script" isMerged="true" -- Insert sample admin user INSERT INTO users (id, email, password_hash, full_name, role, phone) VALUES ('550e8400-e29b-41d4-a716-446655440000', 'admin@university.com', '$2b$10$hash', 'System Administrator', 'admin', '+1234567890'); -- Insert sample universities INSERT INTO universities (id, name, country, city, description, tuition_fee, created_by) VALUES ('660e8400-e29b-41d4-a716-446655440001', 'Harvard University', 'USA', 'Cambridge', 'Prestigious Ivy League university', 55000.00, '550e8400-e29b-41d4-a716-446655440000'), ('660e8400-e29b-41d4-a716-446655440002', 'Oxford University', 'UK', 'Oxford', 'Historic university in England', 45000.00, '550e8400-e29b-41d4-a716-446655440000'), ('660e8400-e29b-41d4-a716-446655440003', 'University of Toronto', 'Canada', 'Toronto', 'Top Canadian research university', 35000.00, '550e8400-e29b-41d4-a716-446655440000'), ('660e8400-e29b-41d4-a716-446655440004', 'MIT', 'USA', 'Cambridge', 'Leading technology institute', 58000.00, '550e8400-e29b-41d4-a716-446655440000'), ('660e8400-e29b-41d4-a716-446655440005', 'Stanford University', 'USA', 'Stanford', 'Premier research university', 56000.00, '550e8400-e29b-41d4-a716-446655440000'); -- Insert sample agents INSERT INTO users (id, email, password_hash, full_name, role, phone) VALUES ('770e8400-e29b-41d4-a716-446655440001', 'agent1@university.com', '$2b$10$hash', 'John Agent', 'agent', '+1234567891'), ('770e8400-e29b-41d4-a716-446655440002', 'agent2@university.com', '$2b$10$hash', 'Sarah Agent', 'agent', '+1234567892'); -- Insert sample students INSERT INTO users (id, email, password_hash, full_name, role, phone) VALUES ('880e8400-e29b-41d4-a716-446655440001', 'student1@university.com', '$2b$10$hash', 'Alice Student', 'student', '+1234567893'), ('880e8400-e29b-41d4-a716-446655440002', 'student2@university.com', '$2b$10$hash', 'Bob Student', 'student', '+1234567894'); -- Insert sample applications INSERT INTO applications ( id, student_id, agent_id, university_id, status, first_name, last_name, date_of_birth, nationality, passport_number, previous_education, gpa, english_score, program_name, intake_year, intake_month, personal_statement, documents_uploaded ) VALUES ('990e8400-e29b-41d4-a716-446655440001', '880e8400-e29b-41d4-a716-446655440001', '770e8400-e29b-41d4-a716-446655440001', '660e8400-e29b-41d4-a716-446655440001', 'pending', 'Alice', 'Student', '2000-05-15', 'Indian', 'P1234567', 'Bachelor of Science', 3.8, 'IELTS 7.5', 'Master of Computer Science', 2024, 'September', 'I am passionate about computer science and want to pursue advanced studies.', true), ('990e8400-e29b-41d4-a716-446655440002', '880e8400-e29b-41d4-a716-446655440002', '770e8400-e29b-41d4-a716-446655440002', '660e8400-e29b-41d4-a716-446655440002', 'approved', 'Bob', 'Student', '1999-08-20', 'Chinese', 'P7654321', 'Bachelor of Engineering', 3.6, 'TOEFL 105', 'Master of Business Administration', 2024, 'January', 'I want to develop my business skills and leadership capabilities.', true); -- Insert sample payments INSERT INTO payments (id, application_id, student_id, amount, status, payment_method, transaction_id, payment_date) VALUES ('aa0e8400-e29b-41d4-a716-446655440001', '990e8400-e29b-41d4-a716-446655440002', '880e8400-e29b-41d4-a716-446655440002', 500.00, 'completed', 'credit_card', 'TXN123456', NOW()); [V0_FILE]typescriptreact:file="lib/session.ts" isMerged="true" import { cookies } from "next/headers" export type User = { id: string email: string full_name: string role: "admin" | "student" | "agent" } export async function getSession(): Promise { const cookieStore = await cookies() const sessionCookie = cookieStore.get("session") if (!sessionCookie) { return null } try { return JSON.parse(sessionCookie.value) } catch { return null } } export async function createSession(user: User) { const cookieStore = await cookies() cookieStore.set("session", JSON.stringify(user), { httpOnly: true, secure: process.env.NODE_ENV === "production", sameSite: "lax", maxAge: 60 * 60 * 24 * 7, // 1 week }) } export async function destroySession() { const cookieStore = await cookies() cookieStore.delete("session") } [V0_FILE]typescriptreact:file="middleware.ts" isMerged="true" import { NextResponse } from "next/server" import type { NextRequest } from "next/server" export function middleware(request: NextRequest) { const session = request.cookies.get("session") const { pathname } = request.nextUrl // Public routes if (pathname === "/login" || pathname === "/") { if (session) { // Redirect authenticated users away from login const user = JSON.parse(session.value) return NextResponse.redirect(new URL(`/${user.role}`, request.url)) } return NextResponse.next() } // Protected routes if (!session) { return NextResponse.redirect(new URL("/login", request.url)) } const user = JSON.parse(session.value) // Role-based access control if (pathname.startsWith("/admin") && user.role !== "admin") { return NextResponse.redirect(new URL("/unauthorized", request.url)) } if (pathname.startsWith("/student") && user.role !== "student") { return NextResponse.redirect(new URL("/unauthorized", request.url)) } if (pathname.startsWith("/agent") && user.role !== "agent") { return NextResponse.redirect(new URL("/unauthorized", request.url)) } return NextResponse.next() } export const config = { matcher: ["/((?!api|_next/static|_next/image|favicon.ico).*)"], } [V0_FILE]typescriptreact:file="app/login/page.tsx" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { useRouter } from "next/navigation" import { Button } from "@/components/ui/button" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Alert, AlertDescription } from "@/components/ui/alert" import { GraduationCap } from "lucide-react" export default function LoginPage() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [error, setError] = useState("") const [loading, setLoading] = useState(false) const router = useRouter() const handleSubmit = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setError("") try { const response = await fetch("/api/auth/login", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ email, password }), }) const data = await response.json() if (!response.ok) { throw new Error(data.error || "Login failed") } // Redirect based on role router.push(`/${data.user.role}`) } catch (err) { setError(err instanceof Error ? err.message : "Login failed") } finally { setLoading(false) } } return (

University Management Sign in to your account

Demo Accounts:

Admin: admin@university.com

Agent: agent1@university.com

Student: student1@university.com

Password: password123

) } [V0_FILE]typescriptreact:file="app/api/auth/login/route.ts" isMerged="true" import { type NextRequest, NextResponse } from "next/server" import { signIn } from "@/lib/auth" import { createSession } from "@/lib/session" export async function POST(request: NextRequest) { try { const { email, password } = await request.json() const { user, error } = await signIn(email, password) if (error || !user) { return NextResponse.json({ error: error || "Login failed" }, { status: 401 }) } await createSession(user) return NextResponse.json({ user }) } catch (error) { return NextResponse.json({ error: "Internal server error" }, { status: 500 }) } } [V0_FILE]typescriptreact:file="app/api/auth/logout/route.ts" isMerged="true" import { NextResponse } from "next/server" import { destroySession } from "@/lib/session" export async function POST() { await destroySession() return NextResponse.json({ success: true }) } [V0_FILE]typescriptreact:file="components/dashboard-stats.tsx" isMerged="true" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { GraduationCap, Users, FileText, TrendingUp } from "lucide-react" interface DashboardStatsProps { totalUniversities: number totalStudents: number totalApplications: number acceptanceRate: number } export function DashboardStats({ totalUniversities, totalStudents, totalApplications, acceptanceRate, }: DashboardStatsProps) { const stats = [ { title: "Total Universities", value: totalUniversities, icon: GraduationCap, color: "text-blue-600", }, { title: "Total Students", value: totalStudents, icon: Users, color: "text-green-600", }, { title: "Total Applications", value: totalApplications, icon: FileText, color: "text-purple-600", }, { title: "Acceptance Rate", value: `${acceptanceRate}%`, icon: TrendingUp, color: "text-orange-600", }, ] return (

{stats.map((stat) => ( {stat.title}

{stat.value}

))}

) } [V0_FILE]typescriptreact:file="components/application-chart.tsx" isMerged="true" "use client" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { ChartContainer, ChartTooltip, ChartTooltipContent } from "@/components/ui/chart" import { BarChart, Bar, XAxis, YAxis, ResponsiveContainer } from "recharts" interface ApplicationChartProps { data: Array<{ month: string applications: number approved: number rejected: number }> } const chartConfig = { applications: { label: "Applications", color: "hsl(var(--chart-1))", }, approved: { label: "Approved", color: "hsl(var(--chart-2))", }, rejected: { label: "Rejected", color: "hsl(var(--chart-3))", }, } export function ApplicationChart({ data }: ApplicationChartProps) { return ( Application Overview Monthly application statistics } /> ) } [V0_FILE]typescriptreact:file="components/layout/sidebar.tsx" isMerged="true" "use client" import { useState } from "react" import Link from "next/link" import { usePathname, useRouter } from "next/navigation" import { Button } from "@/components/ui/button" import { cn } from "@/lib/utils" import { LayoutDashboard, Users, GraduationCap, FileText, CreditCard, BarChart3, LogOut, Menu, X } from "lucide-react" interface SidebarProps { role: "admin" | "student" | "agent" } const menuItems = { admin: [ { href: "/admin", label: "Dashboard", icon: LayoutDashboard }, { href: "/admin/universities", label: "Universities", icon: GraduationCap }, { href: "/admin/agents", label: "Agents", icon: Users }, { href: "/admin/applications", label: "Applications", icon: FileText }, { href: "/admin/payments", label: "Payments", icon: CreditCard }, { href: "/admin/reports", label: "Reports", icon: BarChart3 }, ], student: [ { href: "/student", label: "Dashboard", icon: LayoutDashboard }, { href: "/student/applications", label: "My Applications", icon: FileText }, { href: "/student/payments", label: "Payments", icon: CreditCard }, ], agent: [ { href: "/agent", label: "Dashboard", icon: LayoutDashboard }, { href: "/agent/applications", label: "Applications", icon: FileText }, { href: "/agent/students", label: "Students", icon: Users }, ], } export function Sidebar({ role }: SidebarProps) { const [isOpen, setIsOpen] = useState(false) const pathname = usePathname() const router = useRouter() const handleLogout = async () => { await fetch("/api/auth/logout", { method: "POST" }) router.push("/login") } const items = menuItems[role] return ( <> {/* Mobile menu button */} {/* Sidebar */}

{role.charAt(0).toUpperCase() + role.slice(1)} Panel

{/* Overlay for mobile */} {isOpen && (

setIsOpen(false)} /> )} ) } [V0_FILE]typescriptreact:file="app/student/page.tsx" isMerged="true" import { getSession } from "@/lib/session" import { supabase } from "@/lib/supabase" import { DashboardStats } from "@/components/dashboard-stats" import { ApplicationChart } from "@/components/application-chart" import { Sidebar } from "@/components/layout/sidebar" import { redirect } from "next/navigation" async function getStudentDashboardData(studentId: string) { // Get student's applications const { data: applications, count: totalApplications } = await supabase .from("applications") .select("*", { count: "exact" }) .eq("student_id", studentId) // Get approved applications const { count: approvedApplications } = await supabase .from("applications") .select("*", { count: "exact", head: true }) .eq("student_id", studentId) .eq("status", "approved") // Get total universities (for reference) const { count: totalUniversities } = await supabase.from("universities").select("*", { count: "exact", head: true }) const acceptanceRate = totalApplications ? Math.round(((approvedApplications || 0) / totalApplications) * 100) : 0 // Mock chart data for student const chartData = [ { month: "Jan", applications: 1, approved: 0, rejected: 0 }, { month: "Feb", applications: 2, approved: 1, rejected: 0 }, { month: "Mar", applications: 1, approved: 1, rejected: 0 }, { month: "Apr", applications: 0, approved: 0, rejected: 0 }, { month: "May", applications: 1, approved: 0, rejected: 1 }, { month: "Jun", applications: 0, approved: 0, rejected: 0 }, ] return { totalUniversities: totalUniversities || 0, totalStudents: 1, // Current student totalApplications: totalApplications || 0, acceptanceRate, chartData, } } export default async function StudentDashboard() { const session = await getSession() if (!session || session.role !== "student") { redirect("/login") } const dashboardData = await getStudentDashboardData(session.id) return (

Student Dashboard

Welcome back, {session.full_name}

) } [V0_FILE]typescriptreact:file="app/agent/page.tsx" isMerged="true" import { getSession } from "@/lib/session" import { supabase } from "@/lib/supabase" import { DashboardStats } from "@/components/dashboard-stats" import { ApplicationChart } from "@/components/application-chart" import { Sidebar } from "@/components/layout/sidebar" import { redirect } from "next/navigation" async function getAgentDashboardData(agentId: string) { // Get agent's applications const { data: applications, count: totalApplications } = await supabase .from("applications") .select("*", { count: "exact" }) .eq("agent_id", agentId) // Get approved applications const { count: approvedApplications } = await supabase .from("applications") .select("*", { count: "exact", head: true }) .eq("agent_id", agentId) .eq("status", "approved") // Get unique students handled by this agent const { data: uniqueStudents } = await supabase.from("applications").select("student_id").eq("agent_id", agentId) const totalStudents = uniqueStudents ? new Set(uniqueStudents.map((app) => app.student_id)).size : 0 // Get total universities const { count: totalUniversities } = await supabase.from("universities").select("*", { count: "exact", head: true }) const acceptanceRate = totalApplications ? Math.round(((approvedApplications || 0) / totalApplications) * 100) : 0 // Mock chart data for agent const chartData = [ { month: "Jan", applications: 12, approved: 8, rejected: 2 }, { month: "Feb", applications: 15, approved: 11, rejected: 3 }, { month: "Mar", applications: 18, approved: 13, rejected: 4 }, { month: "Apr", applications: 22, approved: 16, rejected: 5 }, { month: "May", applications: 19, approved: 14, rejected: 4 }, { month: "Jun", applications: 25, approved: 18, rejected: 6 }, ] return { totalUniversities: totalUniversities || 0, totalStudents, totalApplications: totalApplications || 0, acceptanceRate, chartData, } } export default async function AgentDashboard() { const session = await getSession() if (!session || session.role !== "agent") { redirect("/login") } const dashboardData = await getAgentDashboardData(session.id) return (

Agent Dashboard

Welcome back, {session.full_name}

) } [V0_FILE]typescriptreact:file="app/page.tsx" isMerged="true" import { redirect } from "next/navigation" import { getSession } from "@/lib/session" export default async function HomePage() { const session = await getSession() if (session) { redirect(`/${session.role}`) } else { redirect("/login") } } [V0_FILE]typescriptreact:file="app/unauthorized/page.tsx" isMerged="true" import Link from "next/link" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { AlertTriangle } from "lucide-react" export default function UnauthorizedPage() { return (

Access Denied You don't have permission to access this page.

) } [V0_FILE]typescriptreact:file="lib/supabase.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { createClient } from "@supabase/supabase-js" const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL || "https://placeholder.supabase.co" const supabaseAnonKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY || "placeholder-key" export const supabase = createClient(supabaseUrl, supabaseAnonKey) export type Database = { public: { Tables: { users: { Row: { id: string email: string password_hash: string full_name: string role: "admin" | "student" | "agent" phone: string | null created_at: string updated_at: string } Insert: { id?: string email: string password_hash: string full_name: string role?: "admin" | "student" | "agent" phone?: string | null created_at?: string updated_at?: string } Update: { id?: string email?: string password_hash?: string full_name?: string role?: "admin" | "student" | "agent" phone?: string | null created_at?: string updated_at?: string } } universities: { Row: { id: string name: string country: string city: string description: string | null tuition_fee: number | null created_by: string | null created_at: string updated_at: string } Insert: { id?: string name: string country: string city: string description?: string | null tuition_fee?: number | null created_by?: string | null created_at?: string updated_at?: string } Update: { id?: string name?: string country?: string city?: string description?: string | null tuition_fee?: number | null created_by?: string | null created_at?: string updated_at?: string } } applications: { Row: { id: string student_id: string | null agent_id: string | null university_id: string | null status: "pending" | "approved" | "rejected" first_name: string last_name: string date_of_birth: string | null nationality: string | null passport_number: string | null previous_education: string | null gpa: number | null english_score: string | null program_name: string | null intake_year: number | null intake_month: string | null personal_statement: string | null documents_uploaded: boolean | null approved_by: string | null approved_at: string | null created_at: string updated_at: string } Insert: { id?: string student_id?: string | null agent_id?: string | null university_id?: string | null status?: "pending" | "approved" | "rejected" first_name: string last_name: string date_of_birth?: string | null nationality?: string | null passport_number?: string | null previous_education?: string | null gpa?: number | null english_score?: string | null program_name?: string | null intake_year?: number | null intake_month?: string | null personal_statement?: string | null documents_uploaded?: boolean | null approved_by?: string | null approved_at?: string | null created_at?: string updated_at?: string } Update: { id?: string student_id?: string | null agent_id?: string | null university_id?: string | null status?: "pending" | "approved" | "rejected" first_name?: string last_name?: string date_of_birth?: string | null nationality?: string | null passport_number?: string | null previous_education?: string | null gpa?: number | null english_score?: string | null program_name?: string | null intake_year?: number | null intake_month?: string | null personal_statement?: string | null documents_uploaded?: boolean | null approved_by?: string | null approved_at?: string | null created_at?: string updated_at?: string } } payments: { Row: { id: string application_id: string | null student_id: string | null amount: number currency: string | null status: "pending" | "completed" | "failed" payment_method: string | null transaction_id: string | null payment_date: string | null created_at: string updated_at: string } Insert: { id?: string application_id?: string | null student_id?: string | null amount: number currency?: string | null status?: "pending" | "completed" | "failed" payment_method?: string | null transaction_id?: string | null payment_date?: string | null created_at?: string updated_at?: string } Update: { id?: string application_id?: string | null student_id?: string | null amount?: number currency?: string | null status?: "pending" | "completed" | "failed" payment_method?: string | null transaction_id?: string | null payment_date?: string | null created_at?: string updated_at?: string } } } } } [V0_FILE]typescriptreact:file="lib/auth.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { supabase } from "./supabase" // Mock authentication for demo purposes export async function signIn(email: string, password: string) { try { // Check if we're in a build environment if ( !process.env.NEXT_PUBLIC_SUPABASE_URL || process.env.NEXT_PUBLIC_SUPABASE_URL === "https://placeholder.supabase.co" ) { // Return mock user for demo const mockUsers = { "admin@university.com": { id: "550e8400-e29b-41d4-a716-446655440000", email: "admin@university.com", full_name: "System Administrator", role: "admin" as const, }, "agent1@university.com": { id: "770e8400-e29b-41d4-a716-446655440001", email: "agent1@university.com", full_name: "John Agent", role: "agent" as const, }, "student1@university.com": { id: "880e8400-e29b-41d4-a716-446655440001", email: "student1@university.com", full_name: "Alice Student", role: "student" as const, }, } const user = mockUsers[email as keyof typeof mockUsers] if (user && password === "password123") { return { user, error: null } } else { return { user: null, error: "Invalid credentials" } } } // Real Supabase authentication const { data: user, error } = await supabase.from("users").select("*").eq("email", email).single() if (error || !user) { throw new Error("Invalid credentials") } // In a real app, you would verify the password with bcrypt // For demo purposes, we'll accept any password const sessionData = { id: user.id, email: user.email, full_name: user.full_name, role: user.role, } return { user: sessionData, error: null } } catch (error) { return { user: null, error: error instanceof Error ? error.message : "Sign in failed" } } } export async function signUp(userData: { email: string password: string full_name: string role: "admin" | "student" | "agent" phone?: string }) { try { // Check if we're in a build environment if ( !process.env.NEXT_PUBLIC_SUPABASE_URL || process.env.NEXT_PUBLIC_SUPABASE_URL === "https://placeholder.supabase.co" ) { // Return mock success for demo return { user: { id: "new-user-id", email: userData.email, full_name: userData.full_name, role: userData.role, }, error: null, } } const { data, error } = await supabase .from("users") .insert({ email: userData.email, password_hash: "hashed_password", // In real app, hash the password full_name: userData.full_name, role: userData.role, phone: userData.phone, }) .select() .single() if (error) { throw new Error(error.message) } return { user: data, error: null } } catch (error) { return { user: null, error: error instanceof Error ? error.message : "Sign up failed" } } } [V0_FILE]typescriptreact:file=".env.example" isMerged="true" # Supabase Configuration NEXT_PUBLIC_SUPABASE_URL=your_supabase_project_url NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key # Example: # NEXT_PUBLIC_SUPABASE_URL=https://your-project.supabase.co # NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key-here [V0_FILE]typescriptreact:file="lib/mock-data.ts" isMerged="true" // Mock data for demo purposes when Supabase is not configured export const mockUniversities = [ { id: "660e8400-e29b-41d4-a716-446655440001", name: "Harvard University", country: "USA", city: "Cambridge", description: "Prestigious Ivy League university", tuition_fee: 55000, created_at: "2024-01-01T00:00:00Z", updated_at: "2024-01-01T00:00:00Z", }, { id: "660e8400-e29b-41d4-a716-446655440002", name: "Oxford University", country: "UK", city: "Oxford", description: "Historic university in England", tuition_fee: 45000, created_at: "2024-01-01T00:00:00Z", updated_at: "2024-01-01T00:00:00Z", }, { id: "660e8400-e29b-41d4-a716-446655440003", name: "University of Toronto", country: "Canada", city: "Toronto", description: "Top Canadian research university", tuition_fee: 35000, created_at: "2024-01-01T00:00:00Z", updated_at: "2024-01-01T00:00:00Z", }, ] export const mockApplications = [ { id: "990e8400-e29b-41d4-a716-446655440001", student_id: "880e8400-e29b-41d4-a716-446655440001", agent_id: "770e8400-e29b-41d4-a716-446655440001", university_id: "660e8400-e29b-41d4-a716-446655440001", status: "pending" as const, first_name: "Alice", last_name: "Student", date_of_birth: "2000-05-15", nationality: "Indian", passport_number: "P1234567", previous_education: "Bachelor of Science", gpa: 3.8, english_score: "IELTS 7.5", program_name: "Master of Computer Science", intake_year: 2024, intake_month: "September", personal_statement: "I am passionate about computer science and want to pursue advanced studies.", documents_uploaded: true, approved_by: null, approved_at: null, created_at: "2024-01-01T00:00:00Z", updated_at: "2024-01-01T00:00:00Z", }, ] export const mockStats = { totalUniversities: 5, totalStudents: 150, totalApplications: 320, acceptanceRate: 75, } [V0_FILE]typescriptreact:file="app/admin/page.tsx" isEdit="true" isQuickEdit="true" isMerged="true" import { getSession } from "@/lib/session" import { supabase } from "@/lib/supabase" import { DashboardStats } from "@/components/dashboard-stats" import { ApplicationChart } from "@/components/application-chart" import { Sidebar } from "@/components/layout/sidebar" import { mockStats } from "@/lib/mock-data" import { redirect } from "next/navigation" async function getDashboardData() { try { // Check if we're using real Supabase or mock data if ( !process.env.NEXT_PUBLIC_SUPABASE_URL || process.env.NEXT_PUBLIC_SUPABASE_URL === "https://placeholder.supabase.co" ) { // Return mock data const chartData = [ { month: "Jan", applications: 45, approved: 32, rejected: 8 }, { month: "Feb", applications: 52, approved: 38, rejected: 10 }, { month: "Mar", applications: 48, approved: 35, rejected: 9 }, { month: "Apr", applications: 61, approved: 44, rejected: 12 }, { month: "May", applications: 55, approved: 40, rejected: 11 }, { month: "Jun", applications: 67, approved: 48, rejected: 14 }, ] return { ...mockStats, chartData, } } // Real Supabase queries const { count: totalUniversities } = await supabase.from("universities").select("*", { count: "exact", head: true }) const { count: totalStudents } = await supabase .from("users") .select("*", { count: "exact", head: true }) .eq("role", "student") const { count: totalApplications } = await supabase.from("applications").select("*", { count: "exact", head: true }) const { count: approvedApplications } = await supabase .from("applications") .select("*", { count: "exact", head: true }) .eq("status", "approved") const acceptanceRate = totalApplications ? Math.round(((approvedApplications || 0) / totalApplications) * 100) : 0 const chartData = [ { month: "Jan", applications: 45, approved: 32, rejected: 8 }, { month: "Feb", applications: 52, approved: 38, rejected: 10 }, { month: "Mar", applications: 48, approved: 35, rejected: 9 }, { month: "Apr", applications: 61, approved: 44, rejected: 12 }, { month: "May", applications: 55, approved: 40, rejected: 11 }, { month: "Jun", applications: 67, approved: 48, rejected: 14 }, ] return { totalUniversities: totalUniversities || 0, totalStudents: totalStudents || 0, totalApplications: totalApplications || 0, acceptanceRate, chartData, } } catch (error) { // Fallback to mock data if there's an error const chartData = [ { month: "Jan", applications: 45, approved: 32, rejected: 8 }, { month: "Feb", applications: 52, approved: 38, rejected: 10 }, { month: "Mar", applications: 48, approved: 35, rejected: 9 }, { month: "Apr", applications: 61, approved: 44, rejected: 12 }, { month: "May", applications: 55, approved: 40, rejected: 11 }, { month: "Jun", applications: 67, approved: 48, rejected: 14 }, ] return { ...mockStats, chartData, } } } export default async function AdminDashboard() { const session = await getSession() if (!session || session.role !== "admin") { redirect("/login") } const dashboardData = await getDashboardData() return (

Admin Dashboard

Welcome back, {session.full_name}

) } [V0_FILE]typescriptreact:file="app/admin/universities/page.tsx" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import type React from "react" import { useState, useEffect } from "react" import { Sidebar } from "@/components/layout/sidebar" import { Button } from "@/components/ui/button" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Dialog, DialogContent, DialogDescription, DialogHeader, DialogTitle, DialogTrigger, } from "@/components/ui/dialog" import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table" import { Plus, Edit, Trash2 } from "lucide-react" import { supabase } from "@/lib/supabase" import { mockUniversities } from "@/lib/mock-data" interface University { id: string name: string country: string city: string description: string | null tuition_fee: number | null created_at: string } export default function UniversitiesPage() { const [universities, setUniversities] = useState([]) const [isDialogOpen, setIsDialogOpen] = useState(false) const [editingUniversity, setEditingUniversity] = useState(null) const [isUsingMockData, setIsUsingMockData] = useState(false) const [formData, setFormData] = useState({ name: "", country: "", city: "", description: "", tuition_fee: "", }) useEffect(() => { fetchUniversities() }, []) const fetchUniversities = async () => { try { // Check if we're using real Supabase or mock data if ( !process.env.NEXT_PUBLIC_SUPABASE_URL || process.env.NEXT_PUBLIC_SUPABASE_URL === "https://placeholder.supabase.co" ) { setUniversities(mockUniversities) setIsUsingMockData(true) return } const { data, error } = await supabase.from("universities").select("*").order("created_at", { ascending: false }) if (!error && data) { setUniversities(data) setIsUsingMockData(false) } else { // Fallback to mock data setUniversities(mockUniversities) setIsUsingMockData(true) } } catch (error) { // Fallback to mock data setUniversities(mockUniversities) setIsUsingMockData(true) } } const handleSubmit = async (e: React.FormEvent) => { e.preventDefault() if (isUsingMockData) { // For demo purposes, just add to local state const newUniversity = { id: `new-${Date.now()}`, name: formData.name, country: formData.country, city: formData.city, description: formData.description || null, tuition_fee: formData.tuition_fee ? Number.parseFloat(formData.tuition_fee) : null, created_at: new Date().toISOString(), } if (editingUniversity) { setUniversities((prev) => prev.map((u) => (u.id === editingUniversity.id ? { ...newUniversity, id: editingUniversity.id } : u)), ) } else { setUniversities((prev) => [newUniversity, ...prev]) } resetForm() return } const universityData = { name: formData.name, country: formData.country, city: formData.city, description: formData.description || null, tuition_fee: formData.tuition_fee ? Number.parseFloat(formData.tuition_fee) : null, } try { if (editingUniversity) { const { error } = await supabase.from("universities").update(universityData).eq("id", editingUniversity.id) if (!error) { fetchUniversities() resetForm() } } else { const { error } = await supabase.from("universities").insert(universityData) if (!error) { fetchUniversities() resetForm() } } } catch (error) { console.error("Error saving university:", error) } } const handleEdit = (university: University) => { setEditingUniversity(university) setFormData({ name: university.name, country: university.country, city: university.city, description: university.description || "", tuition_fee: university.tuition_fee?.toString() || "", }) setIsDialogOpen(true) } const handleDelete = async (id: string) => { if (confirm("Are you sure you want to delete this university?")) { if (isUsingMockData) { setUniversities((prev) => prev.filter((u) => u.id !== id)) return } try { const { error } = await supabase.from("universities").delete().eq("id", id) if (!error) { fetchUniversities() } } catch (error) { console.error("Error deleting university:", error) } } } const resetForm = () => { setFormData({ name: "", country: "", city: "", description: "", tuition_fee: "", }) setEditingUniversity(null) setIsDialogOpen(false) } return (

Universities

Manage university listings {isUsingMockData && "(Demo Mode - Using Mock Data)"}

University List All universities in the system Name Location Tuition Fee Actions {universities.map((university) => ( {university.name} {university.city}, {university.country} {university.tuition_fee ? `$${university.tuition_fee.toLocaleString()}` : "N/A"}

))}

) } [V0_FILE]typescriptreact:file="app/preview/page.tsx" "use client" import { useState } from "react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Badge } from "@/components/ui/badge" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table" import { LayoutDashboard, Users, GraduationCap, FileText, CreditCard, BarChart3, TrendingUp, Plus, Eye, CheckCircle, XCircle, Clock, } from "lucide-react" import { ChartContainer, ChartTooltip, ChartTooltipContent } from "@/components/ui/chart" import { BarChart, Bar, XAxis, YAxis, ResponsiveContainer } from "recharts" const chartData = [ { month: "Jan", applications: 45, approved: 32, rejected: 8 }, { month: "Feb", applications: 52, approved: 38, rejected: 10 }, { month: "Mar", applications: 48, approved: 35, rejected: 9 }, { month: "Apr", applications: 61, approved: 44, rejected: 12 }, { month: "May", applications: 55, approved: 40, rejected: 11 }, { month: "Jun", applications: 67, approved: 48, rejected: 14 }, ] const chartConfig = { applications: { label: "Applications", color: "#3b82f6" }, approved: { label: "Approved", color: "#10b981" }, rejected: { label: "Rejected", color: "#ef4444" }, } export default function PreviewPage() { const [activePanel, setActivePanel] = useState("admin") const StatCard = ({ title, value, icon: Icon, color }: any) => ( {title}

{value}

) const Sidebar = ({ role }: { role: string }) => { const menuItems = { admin: [ { label: "Dashboard", icon: LayoutDashboard, active: true }, { label: "Universities", icon: GraduationCap }, { label: "Agents", icon: Users }, { label: "Applications", icon: FileText }, { label: "Payments", icon: CreditCard }, { label: "Reports", icon: BarChart3 }, ], student: [ { label: "Dashboard", icon: LayoutDashboard, active: true }, { label: "My Applications", icon: FileText }, { label: "Payments", icon: CreditCard }, ], agent: [ { label: "Dashboard", icon: LayoutDashboard, active: true }, { label: "Applications", icon: FileText }, { label: "Students", icon: Users }, ], } const items = menuItems[role as keyof typeof menuItems] || [] return (

{role.charAt(0).toUpperCase() + role.slice(1)} Panel

) } const AdminDashboard = () => (

Admin Dashboard

Welcome back, System Administrator

Application Overview Monthly application statistics } /> Recent Applications Latest student applications requiring review Student Name University Program Status Actions Alice Student Harvard University Master of Computer Science Pending

Bob Student Oxford University Master of Business Administration Approved

) const StudentDashboard = () => (

Student Dashboard

Welcome back, Alice Student

My Applications Track your university applications University Program Applied Date Status Payment Harvard University Master of Computer Science 2024-01-15 Pending Oxford University Master of Business Administration 2024-01-10 Approved Paid

) const AgentDashboard = () => (

Agent Dashboard

Welcome back, John Agent

Recent Applications Applications you've submitted

Alice Student

Harvard University

Pending

Bob Student

Oxford University

Approved

Quick Actions Common tasks

) return (

{/* Header */}

University Management System - UI Preview

Admin Panel Student Panel Agent Panel

{/* Main Content */}

) } [V0_FILE]typescriptreact:file="app/preview/login/page.tsx" "use client" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { GraduationCap } from "lucide-react" export default function LoginPreview() { return (

University Management Sign in to your account

Demo Accounts:

Admin: admin@university.com

Agent: agent1@university.com

Student: student1@university.com

Password: password123

) } [V0_FILE]typescriptreact:file="app/preview/universities/page.tsx" "use client" import { useState } from "react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table" import { Dialog, DialogContent, DialogDescription, DialogHeader, DialogTitle, DialogTrigger, } from "@/components/ui/dialog" import { Plus, Edit, Trash2, GraduationCap, Users, FileText, BarChart3, CreditCard, LayoutDashboard, } from "lucide-react" const universities = [ { id: 1, name: "Harvard University", country: "USA", city: "Cambridge", tuition: 55000 }, { id: 2, name: "Oxford University", country: "UK", city: "Oxford", tuition: 45000 }, { id: 3, name: "University of Toronto", country: "Canada", city: "Toronto", tuition: 35000 }, { id: 4, name: "MIT", country: "USA", city: "Cambridge", tuition: 58000 }, { id: 5, name: "Stanford University", country: "USA", city: "Stanford", tuition: 56000 }, ] export default function UniversitiesPreview() { const [isDialogOpen, setIsDialogOpen] = useState(false) const Sidebar = () => { const menuItems = [ { label: "Dashboard", icon: LayoutDashboard }, { label: "Universities", icon: GraduationCap, active: true }, { label: "Agents", icon: Users }, { label: "Applications", icon: FileText }, { label: "Payments", icon: CreditCard }, { label: "Reports", icon: BarChart3 }, ] return (

Admin Panel

) } return (

Universities

Manage university listings

))}

) } [V0_FILE]typescriptreact:file="app/preview/layout.tsx" import type React from "react" export default function PreviewLayout({ children, }: { children: React.ReactNode }) { return (

🎯 UI Preview Mode - This is a static preview of the University Management System interface

{children}

) }