'use server' import type { AuditLogActorOption } from '@admin/actions/audit/types' import { requireRole, UserRole } from '@admin/auth/middleware' import db from '@admin/db' import { auditLog } from '@admin/db/schema' import { asc, isNotNull, or } from 'drizzle-orm' export async function getAuditLogActors(): Promise { await requireRole([UserRole.ADMIN]) const rows = await db .selectDistinct({ email: auditLog.actorEmail, name: auditLog.actorName }) .from(auditLog) .where(or(isNotNull(auditLog.actorEmail), isNotNull(auditLog.actorName))) .orderBy(asc(auditLog.actorEmail), asc(auditLog.actorName)) const seen = new Set() const options: AuditLogActorOption[] = [] for (const row of rows) { const value = row.email ?? row.name if (!value || seen.has(value)) continue seen.add(value) options.push({ label: value, value }) } return options }