import { NextRequest, NextResponse } from 'next/server';
import { prisma } from '@/lib/prisma';

export async function GET(request: NextRequest) {
  try {
    const { searchParams } = new URL(request.url);
    const employeeId = searchParams.get('employeeId');
    
    let where: any = {};
    if (employeeId) {
      where.employeeId = employeeId;
    }
    
    const appraisals = await prisma.appraisal.findMany({
      where,
      orderBy: { period: 'desc' }
    });
    
    return NextResponse.json(appraisals);
  } catch (error) {
    console.error('Error fetching appraisals:', error);
    return NextResponse.json({ error: 'Failed to fetch appraisals' }, { status: 500 });
  }
}