import { NextRequest, NextResponse } from 'next/server';
import { typedQuery } from '@/backend/utils/typedQuery';

type BankRow = {
  description: string;
};

export async function GET(req: NextRequest) {
  const { searchParams } = new URL(req.url);
  const bank = searchParams.get('code');

  if (!bank) {
    return NextResponse.json({ error: 'Missing bank parameter' }, { status: 400 });
  }

  try {
    const [rows] = await typedQuery<BankRow>(`SELECT bankname description FROM banks WHERE lactive=1 AND bankcode = ?`, [bank]);

    if (!rows || rows.length === 0) {
      return NextResponse.json({ error: 'Bank not found' }, { status: 404 });
    }

    return NextResponse.json({ description: rows[0].description });
  } catch (error) {
    console.error('DB error:', error);
    return NextResponse.json({ error: 'Internal Server Error' }, { status: 500 });
  }
}