// app/api/admin/users/check-email/route.ts
import { prisma } from '@/lib/prisma'
import { NextResponse } from 'next/server'

export async function GET(request: Request) {
  try {
    const { searchParams } = new URL(request.url)
    const email = searchParams.get('email')
    
    if (!email) {
      return NextResponse.json({ error: 'Email required' }, { status: 400 })
    }
    
    // Check both User and Employee tables
    const user = await prisma.user.findFirst({
      where: { email }
    })
    
    const employee = await prisma.employee.findFirst({
      where: { email }
    })
    
    if (user || employee) {
      return NextResponse.json({ 
        exists: true, 
        message: `❌ Email "${email}" is already registered in the system.`
      })
    }
    
    return NextResponse.json({ exists: false, message: '✅ Email is available' })
  } catch (error) {
    console.error('Error checking email:', error)
    return NextResponse.json({ error: 'Failed to check email' }, { status: 500 })
  }
}