import { NextResponse, type NextRequest } from "next/server";

import { safeAll, parsePaging, type ItemList } from "@/lib/db";

export const dynamic = "force-dynamic";

export async function GET(req: NextRequest) {

  const sp = req.nextUrl.searchParams;

  const { limit, offset } = parsePaging(sp);

  const bill = sp.get("bill");

  const items = safeAll(

    `SELECT rowid, registrant, client, amount_range, period, source_url

     FROM lobbying

     ${bill ? "WHERE covered_bill_id = :bill" : ""}

     ORDER BY period DESC`,

    bill ? { bill } : {},

    (r) => ({

      id: `lda:${r.rowid}`,

      registrant: String(r.registrant ?? ""),

      client: String(r.client ?? ""),

      amountRange: String(r.amount_range ?? ""),

      period: String(r.period ?? ""),

      sourceUrl: String(r.source_url ?? "https://lda.gov/"),

      href: "/who-pays",

    })

  );

  const total = items.length;

  const body: ItemList<typeof items[number]> = {

    items: items.slice(offset, offset + limit),

    total,

    limit,

    offset,

  };

  return NextResponse.json(body);

}