import type { AuditLogFilters } from '@admin/actions/audit/types' import type { SQL } from 'drizzle-orm' import { auditLog } from '@admin/db/schema' import { getAuditRangeStart } from '@admin/utils/audit/get-audit-range-start' import { getExclusiveDateUpperBound } from '@admin/utils/date/get-exclusive-date-upper-bound' import { and, eq, gte, ilike, lt, or } from 'drizzle-orm' export function buildAuditLogWhere(query: AuditLogFilters): SQL | undefined { const conditions = [] if (query.category) conditions.push(eq(auditLog.category, query.category)) if (query.action) conditions.push(eq(auditLog.action, query.action)) if (query.targetType) conditions.push(ilike(auditLog.targetType, `%${query.targetType}%`)) if (query.actor) { const actorPattern = `%${query.actor}%` conditions.push( or(ilike(auditLog.actorEmail, actorPattern), ilike(auditLog.actorName, actorPattern)) ) } // The quick range is resolved here, on the server, so client renders never read the clock. const createdAtFrom = query.createdAtFrom || (query.range ? getAuditRangeStart(query.range).toISOString() : undefined) if (createdAtFrom) { conditions.push(gte(auditLog.createdAt, createdAtFrom)) } const createdAtExclusiveTo = getExclusiveDateUpperBound(query.createdAtTo) if (createdAtExclusiveTo) { conditions.push(lt(auditLog.createdAt, createdAtExclusiveTo)) } if (query.search) { const searchPattern = `%${query.search}%` conditions.push( or( ilike(auditLog.targetId, searchPattern), ilike(auditLog.targetLabel, searchPattern), ilike(auditLog.actorEmail, searchPattern), ilike(auditLog.actorName, searchPattern), ilike(auditLog.sourceType, searchPattern), ilike(auditLog.ipAddress, searchPattern), ilike(auditLog.userAgent, searchPattern) ) ) } return conditions.length > 0 ? and(...conditions) : undefined }