import { NextResponse } from "next/server";
import { db } from "@/lib/db";

export async function GET() {
  try {
    const [status]: any = await db.query(`
      SELECT 
        u.full_name as leader, 
        t.is_read, 
        t.read_at, 
        t.is_disseminated 
      FROM campaign_tracking t
      JOIN users u ON t.user_id = u.id
      WHERE t.campaign_id = (SELECT MAX(id) FROM digital_campaigns)
    `);
    return NextResponse.json(status);
  } catch (error) {
    return NextResponse.json({ error: "Error" }, { status: 500 });
  }
}