[V0_FILE]sql:file="scripts/001-create-tables.sql" isMerged="true" -- Create service providers table CREATE TABLE IF NOT EXISTS service_providers ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, full_name VARCHAR(255) NOT NULL, business_name VARCHAR(255) NOT NULL, email VARCHAR(255) UNIQUE NOT NULL, phone VARCHAR(50) NOT NULL, password_hash VARCHAR(255) NOT NULL, service_category VARCHAR(100) NOT NULL, business_website VARCHAR(255), status VARCHAR(50) DEFAULT 'pending' CHECK (status IN ('pending', 'approved', 'rejected', 'changes_requested')), rejection_reason TEXT, terms_agreed BOOLEAN DEFAULT false, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), approved_at TIMESTAMP WITH TIME ZONE, approved_by UUID ); -- Create documents table CREATE TABLE IF NOT EXISTS sp_documents ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, service_provider_id UUID REFERENCES service_providers(id) ON DELETE CASCADE, document_type VARCHAR(100) NOT NULL, file_name VARCHAR(255) NOT NULL, file_path VARCHAR(500) NOT NULL, file_size INTEGER, mime_type VARCHAR(100), is_mandatory BOOLEAN DEFAULT false, uploaded_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Create admin users table CREATE TABLE IF NOT EXISTS admin_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 VARCHAR(50) DEFAULT 'admin', created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Create email logs table CREATE TABLE IF NOT EXISTS email_logs ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, service_provider_id UUID REFERENCES service_providers(id) ON DELETE CASCADE, email_type VARCHAR(100) NOT NULL, recipient_email VARCHAR(255) NOT NULL, subject VARCHAR(255), sent_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), status VARCHAR(50) DEFAULT 'sent' ); -- Insert default admin user (password: admin123) INSERT INTO admin_users (email, password_hash, full_name) VALUES ('admin@company.com', '$2a$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'System Admin') ON CONFLICT (email) DO NOTHING; [V0_FILE]typescriptreact:file="app/register/page.tsx" isMerged="true" import { RegistrationForm } from "@/components/registration-form" export default function RegisterPage() { return (

Service Provider Registration

Complete the form below to start your onboarding process

) } [V0_FILE]typescriptreact:file="app/admin/page.tsx" isMerged="true" import { AdminLogin } from "@/components/admin-login" export default function AdminPage() { return (

) } [V0_FILE]typescriptreact:file="app/admin/dashboard/page.tsx" isMerged="true" import { AdminDashboard } from "@/components/admin-dashboard" export default function AdminDashboardPage() { return } [V0_FILE]typescriptreact:file="app/success/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 { CheckCircle, Mail } from "lucide-react" export default function SuccessPage() { return (

Application Submitted! Your service provider application has been successfully submitted

Confirmation Email Sent

Check your email for confirmation and next steps

What happens next?

Our team will review your application
We'll verify your documents
You'll receive an email with the decision
If approved, you can access your dashboard

) } [V0_FILE]typescriptreact:file="components/document-upload.tsx" isMerged="true" "use client" import { useState, useRef } from "react" import { Button } from "@/components/ui/button" import { Card, CardContent } from "@/components/ui/card" import { Label } from "@/components/ui/label" import { Upload, File, X, CheckCircle } from "lucide-react" interface DocumentUploadProps { onDocumentsChange: (documents: File[]) => void } const documentTypes = [ { id: "business_license", label: "Business License", mandatory: true }, { id: "government_id", label: "Government ID", mandatory: false }, { id: "insurance", label: "Insurance Certificate", mandatory: false }, { id: "additional", label: "Additional Documents", mandatory: false }, ] export function DocumentUpload({ onDocumentsChange }: DocumentUploadProps) { const [uploadedFiles, setUploadedFiles] = useState<{ [key: string]: File }>({}) const fileInputRefs = useRef<{ [key: string]: HTMLInputElement | null }>({}) const handleFileUpload = (documentType: string, file: File) => { const newFiles = { ...uploadedFiles, [documentType]: file } setUploadedFiles(newFiles) onDocumentsChange(Object.values(newFiles)) } const removeFile = (documentType: string) => { const newFiles = { ...uploadedFiles } delete newFiles[documentType] setUploadedFiles(newFiles) onDocumentsChange(Object.values(newFiles)) // Reset the file input if (fileInputRefs.current[documentType]) { fileInputRefs.current[documentType]!.value = "" } } const formatFileSize = (bytes: number) => { if (bytes === 0) return "0 Bytes" const k = 1024 const sizes = ["Bytes", "KB", "MB", "GB"] const i = Math.floor(Math.log(bytes) / Math.log(k)) return Number.parseFloat((bytes / Math.pow(k, i)).toFixed(2)) + " " + sizes[i] } return (

Upload the required documents. Accepted formats: PDF, JPG, PNG (Max 10MB each)

{documentTypes.map((docType) => (

{docType.label} {docType.mandatory && *} {uploadedFiles[docType.id] && }

{uploadedFiles[docType.id] ? (

{uploadedFiles[docType.id].name}

{formatFileSize(uploadedFiles[docType.id].size)}

) : (

Click to upload or drag and drop

(fileInputRefs.current[docType.id] = el)} type="file" accept=".pdf,.jpg,.jpeg,.png" onChange={(e) => { const file = e.target.files?.[0] if (file) { if (file.size > 10 * 1024 * 1024) { alert("File size must be less than 10MB") return } handleFileUpload(docType.id, file) } }} className="hidden" id={`file-${docType.id}`} />

)} ))}

) } [V0_FILE]typescriptreact:file="components/admin-dashboard.tsx" isMerged="true" "use client" import { useState, useEffect } from "react" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Textarea } from "@/components/ui/textarea" import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle, DialogTrigger, } from "@/components/ui/dialog" import { Label } from "@/components/ui/label" import { getServiceProviders, updateServiceProviderStatus } from "@/lib/actions" import { CheckCircle, XCircle, Clock, FileText, Mail, Phone, Globe } from "lucide-react" interface ServiceProvider { id: string full_name: string business_name: string email: string phone: string service_category: string business_website?: string status: string created_at: string rejection_reason?: string } export function AdminDashboard() { const [serviceProviders, setServiceProviders] = useState([]) const [isLoading, setIsLoading] = useState(true) const [selectedProvider, setSelectedProvider] = useState(null) const [rejectionReason, setRejectionReason] = useState("") const [isUpdating, setIsUpdating] = useState(false) useEffect(() => { loadServiceProviders() }, []) const loadServiceProviders = async () => { try { const result = await getServiceProviders() if (result.success) { setServiceProviders(result.data || []) } } catch (error) { console.error("Error loading service providers:", error) } finally { setIsLoading(false) } } const handleStatusUpdate = async (providerId: string, status: string, reason?: string) => { setIsUpdating(true) try { const result = await updateServiceProviderStatus(providerId, status, reason) if (result.success) { await loadServiceProviders() setSelectedProvider(null) setRejectionReason("") } else { alert(result.error || "Failed to update status") } } catch (error) { console.error("Error updating status:", error) alert("An error occurred. Please try again.") } finally { setIsUpdating(false) } } const getStatusBadge = (status: string) => { switch (status) { case "pending": return ( Pending ) case "approved": return ( Approved ) case "rejected": return ( Rejected ) case "changes_requested": return ( Changes Requested ) default: return {status} } } const formatDate = (dateString: string) => { return new Date(dateString).toLocaleDateString("en-US", { year: "numeric", month: "short", day: "numeric", hour: "2-digit", minute: "2-digit", }) } if (isLoading) { return (

Loading applications...

) } return (

Admin Dashboard

Manage service provider applications

{serviceProviders.length === 0 ? (

No Applications

No service provider applications found.

) : ( serviceProviders.map((provider) => (

{provider.business_name} {provider.full_name} • {provider.service_category}

{getStatusBadge(provider.status)}

{provider.email}

{provider.phone}

{provider.business_website && (

{provider.business_website}

)}

Applied: {formatDate(provider.created_at)}

Category: {provider.service_category}

{provider.rejection_reason && (

Rejection Reason: {provider.rejection_reason}

)} {provider.status === "pending" && (