import { NextResponse } from 'next/server'
import { getSession } from '@/lib/auth'
import { initializeJobPanelDatabase, checkJobPanelDbExists } from '@/lib/job-panel-db'

export async function POST() {
  try {
    const session = await getSession()
    
    if (!session) {
      return NextResponse.json({ error: 'Unauthorized' }, { status: 401 })
    }
    
    // Only admins can initialize the database
    if (session.role !== 'ADMIN' && session.role !== 'SUPERADMIN') {
      return NextResponse.json({ error: 'Forbidden' }, { status: 403 })
    }

    const result = await initializeJobPanelDatabase()
    
    if (!result.success) {
      return NextResponse.json({ error: result.error }, { status: 500 })
    }

    return NextResponse.json({ 
      success: true, 
      message: 'Job Panel database initialized successfully' 
    })
  } catch (error) {
    console.error('[JobPanelSetup] Error:', error)
    return NextResponse.json(
      { error: 'Failed to initialize Job Panel database' },
      { status: 500 }
    )
  }
}

export async function GET() {
  try {
    const session = await getSession()
    
    if (!session) {
      return NextResponse.json({ error: 'Unauthorized' }, { status: 401 })
    }

    const exists = await checkJobPanelDbExists()

    return NextResponse.json({ 
      initialized: exists,
    })
  } catch (error) {
    console.error('[JobPanelSetup] Check error:', error)
    return NextResponse.json(
      { initialized: false, error: 'Failed to check database status' },
      { status: 500 }
    )
  }
}