How to Build Recruitment platform with V0

1// Paste this prompt into V0's AI chat:
2// Build a recruitment platform. Create a Supabase schema with:
3// 1. jobs: id (uuid PK), company_id (uuid FK), title (text), department (text), location (text), type (text check full-time/part-time/contract/remote), description (text), requirements (text[]), salary_min (integer), salary_max (integer), status (text check draft/open/closed), created_at (timestamptz)
4// 2. candidates: id (uuid PK), user_id (uuid nullable), first_name (text), last_name (text), email (text unique), phone (text), linkedin_url (text), created_at (timestamptz)
5// 3. applications: id (uuid PK), job_id (uuid FK), candidate_id (uuid FK), stage (text check applied/screening/interview/offer/hired/rejected), resume_url (text), cover_letter (text), applied_at (timestamptz), updated_at (timestamptz)
6// 4. interview_notes: id (uuid PK), application_id (uuid FK), interviewer_id (uuid FK), notes (text), rating (integer check 1-5), created_at (timestamptz)
7// 5. pipeline_stages: id (uuid PK), company_id (uuid FK), name (text), position (integer), color (text)
8// Create a private Supabase Storage bucket 'resumes' for resume files.
9// RLS: public can read open jobs and submit applications. Only company members can read applications and notes.
10// Generate SQL migration and TypeScript types.

1// Paste this prompt into V0's AI chat:
2// Build a public job board at app/jobs/page.tsx.
3// Requirements:
4// - Fetch all jobs with status='open' from Supabase
5// - Search Input for job title search
6// - Filter: Select for department, Select for type (all/full-time/part-time/contract/remote), Select for location
7// - Grid of job Cards showing: title, department, location, type Badge, salary range, posted date
8// - Each Card links to /jobs/[id] detail page
9// - Detail page at app/jobs/[id]/page.tsx with full description, requirements list, salary range, and prominent "Apply Now" Button linking to /jobs/[id]/apply
10// - Server Components for SEO optimization
11// - Use shadcn/ui Card, Badge, Input, Select, Separator

1'use server'
2
3import { createClient } from '@/lib/supabase/server'
4import { redirect } from 'next/navigation'
5
6export async function submitApplication(formData: FormData) {
7  const supabase = await createClient()
8
9  const email = formData.get('email') as string
10  const resumeFile = formData.get('resume') as File
11
12  // Find or create candidate
13  let { data: candidate } = await supabase
14    .from('candidates')
15    .select('id')
16    .eq('email', email)
17    .single()
18
19  if (!candidate) {
20    const { data: newCandidate } = await supabase
21      .from('candidates')
22      .insert({
23        first_name: formData.get('first_name') as string,
24        last_name: formData.get('last_name') as string,
25        email,
26        phone: formData.get('phone') as string,
27        linkedin_url: formData.get('linkedin') as string,
28      })
29      .select()
30      .single()
31    candidate = newCandidate
32  }
33
34  // Upload resume to private bucket
35  const filePath = `${candidate!.id}/${Date.now()}-${resumeFile.name}`
36  await supabase.storage
37    .from('resumes')
38    .upload(filePath, resumeFile)
39
40  // Create application
41  await supabase.from('applications').insert({
42    job_id: formData.get('job_id') as string,
43    candidate_id: candidate!.id,
44    stage: 'applied',
45    resume_url: filePath,
46    cover_letter: formData.get('cover_letter') as string,
47  })
48
49  redirect(`/jobs/${formData.get('job_id')}?applied=true`)
50}

1// Paste this prompt into V0's AI chat:
2// Build a recruiter pipeline dashboard at app/dashboard/page.tsx.
3// Requirements:
4// - Protected by auth (only company recruiters)
5// - Fetch all applications for the company's jobs, grouped by stage
6// - Display as kanban columns: Applied, Screening, Interview, Offer, Hired, Rejected
7// - Each candidate Card shows: Avatar with initials, full name, job title applied for, applied date, rating average from interview_notes
8// - Clicking a Card opens a Sheet (right sidebar) showing:
9//   - Candidate details: name, email, phone, LinkedIn link
10//   - Resume download Button (generates signed URL valid 1 hour)
11//   - Cover letter text
12//   - Interview notes list with interviewer name, rating (stars), notes text, date
13//   - "Add Note" form: Textarea for notes, Select for rating 1-5, Button to submit
14//   - Stage transition: Select for new stage, Button to move
15// - Pipeline stage headers show candidate count
16// - Use shadcn/ui Card, Avatar, Sheet, Badge, Select, Textarea, Progress for pipeline visualization
17// - Server Actions: moveStage(), addInterviewNote(), generateResumeUrl()

1'use server'
2
3import { createClient } from '@/lib/supabase/server'
4
5export async function generateResumeUrl(resumePath: string) {
6  const supabase = await createClient()
7
8  const { data: { user } } = await supabase.auth.getUser()
9  if (!user) throw new Error('Unauthorized')
10
11  const { data, error } = await supabase.storage
12    .from('resumes')
13    .createSignedUrl(resumePath, 3600)
14
15  if (error) throw new Error('Failed to generate resume URL')
16
17  return data.signedUrl
18}
19
20export async function moveStage(
21  applicationId: string,
22  newStage: string
23) {
24  const supabase = await createClient()
25
26  await supabase
27    .from('applications')
28    .update({
29      stage: newStage,
30      updated_at: new Date().toISOString(),
31    })
32    .eq('id', applicationId)
33}
34
35export async function addInterviewNote(input: {
36  application_id: string
37  notes: string
38  rating: number
39}) {
40  const supabase = await createClient()
41  const { data: { user } } = await supabase.auth.getUser()
42
43  await supabase.from('interview_notes').insert({
44    application_id: input.application_id,
45    interviewer_id: user?.id,
46    notes: input.notes,
47    rating: input.rating,
48  })
49}