Function GET

web/src/app/api/admin/traces/client/[clientId]/sessions/route.ts:41–125

(req: NextRequest, { params }: RouteParams)

}

export async function GET(req: NextRequest, { params }: RouteParams) {
  // Check admin authentication
  const authResult = await checkAdminAuth()
  if (authResult instanceof NextResponse) {
    return authResult
  }

  const { clientId } = await params

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

  try {
    // Query all messages for this client_id
    const messages = await db
      .select({
        id: schema.message.id,
        client_request_id: schema.message.client_request_id,
        finished_at: schema.message.finished_at,
        model: schema.message.model,
        request: schema.message.request,
        response: schema.message.response,
        credits: schema.message.credits,
      })
      .from(schema.message)
      .where(eq(schema.message.client_id, clientId))
      .orderBy(schema.message.finished_at)

    if (messages.length === 0) {
      return NextResponse.json(
        { error: 'No messages found for this client ID' },
        { status: 404 },
      )
    }

    // Transform messages into client messages
    const clientMessages: ClientMessage[] = messages.map((msg) => ({
      id: msg.id,
      client_request_id: msg.client_request_id ?? 'NULL',
      timestamp: msg.finished_at,
      user_prompt: extractUserPromptFromRequest(msg.request),
      assistant_response: extractAssistantResponseFromResponse(msg.response),
      model: msg.model,
      credits_used: msg.credits,
    }))

    // Calculate total credits
    const totalCredits = messages.reduce((sum, msg) => sum + msg.credits, 0)

    // Get date range
    const dateRange = {
      start: messages[0].finished_at,
      end: messages[messages.length - 1].finished_at,
    }