import { NextResponse } from 'next/server';
import { query } from '@/lib/db';
import { getAdminSession } from '@/lib/auth';

// GET /api/admin/conversations/[id]/messages — Get all messages for a conversation
export async function GET(_request: Request, { params }: { params: Promise<{ id: string }> }) {
  const session = await getAdminSession();
  if (!session) {
    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 });
  }

  const { id } = await params;

  try {
    const messages = await query(
      `SELECT id, conversation_id, sender_type, content, ai_draft, status, created_at
       FROM ConversationMessage
       WHERE conversation_id = ?
       ORDER BY created_at ASC`,
      [id]
    ) as any[];

    const convRows = await query(
      'SELECT id, visitor_email, visitor_name, subject, status, created_at, updated_at FROM Conversation WHERE id = ?',
      [id]
    ) as any[];

    const conversation = convRows.length > 0 ? convRows[0] : null;

    return NextResponse.json({ messages, conversation });
  } catch (err: any) {
    console.error('[conversation-messages] GET error:', err?.message ?? err);
    return NextResponse.json({ error: 'Failed to load messages.' }, { status: 500 });
  }
}