import { NextRequest, NextResponse } from 'next/server';
import { getSession } from '@/lib/auth';
import { hasEmployeePermission } from '@/lib/employee-permissions';
import { pgGetSettings } from '@/lib/postgres/data-access';
import { pgListScheduleJobs } from '@/lib/postgres/scheduler';

export async function GET(request: NextRequest) {
  const session = await getSession();
  const settings = await pgGetSettings();

  if (
    !session?.user ||
    (!hasEmployeePermission(session.user, settings, 'admin.accounting') &&
      !hasEmployeePermission(session.user, settings, 'admin.expense-recurring'))
  ) {
    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 });
  }

  try {
    const { searchParams } = new URL(request.url);
    const status = searchParams.get('status') as 'active' | 'paused' | 'completed' | 'cancelled' | null;
    const templateId = searchParams.get('templateId') || undefined;
    const limitParam = Number(searchParams.get('limit') || '100');
    const limit = Number.isFinite(limitParam) ? limitParam : 100;

    const jobs = await pgListScheduleJobs({
      status: status || undefined,
      templateId,
      limit,
    });

    return NextResponse.json({ items: jobs, total: jobs.length }, { status: 200 });
  } catch (error) {
    console.error('Error fetching schedule jobs:', error);
    return NextResponse.json(
      { error: error instanceof Error ? error.message : 'Internal Server Error' },
      { status: 500 }
    );
  }
}
