import type { AuditLogQuery } from '@admin/actions/audit/types' import { auditLog } from '@admin/db/schema' import { asc, desc } from 'drizzle-orm' export function getAuditLogOrderBy(query: AuditLogQuery) { const sortFn = query.dir === 'asc' ? asc : desc switch (query.sort) { case 'event': return [sortFn(auditLog.category), sortFn(auditLog.action), desc(auditLog.createdAt)] case 'target': return [ sortFn(auditLog.targetType), sortFn(auditLog.targetLabel), sortFn(auditLog.targetId), desc(auditLog.createdAt) ] case 'actor': return [sortFn(auditLog.actorEmail), sortFn(auditLog.actorName), desc(auditLog.createdAt)] case 'sourceType': return [sortFn(auditLog.sourceType), desc(auditLog.createdAt)] default: return [sortFn(auditLog.createdAt)] } }