'use server' import type { GetMessagesInput } from './types' import type { MessageListItem, MessageSource, MessagesPage } from '@admin/types/messages' import type { SQL } from 'drizzle-orm' import { requireRole, UserRole } from '@admin/auth/middleware' import db from '@admin/db' import { countMessageRows } from '@admin/lib/messages/count-message-rows' import { messageSources } from '@admin/lib/messages/sources' import { DEFAULT_MESSAGES_PAGE_SIZE } from '@admin/types/messages' import { fromDatabaseTimestamp } from '@admin/utils/messages/from-database-timestamp' import { messageTextColumn } from '@admin/utils/messages/message-text-column' import { and, desc, ilike, isNotNull, isNull, or, sql } from 'drizzle-orm' import { unionAll } from 'drizzle-orm/pg-core' import { cacheLife, cacheTag } from 'next/cache' const MAX_PAGE_SIZE = 100 function buildWhere(source: MessageSource, input: GetMessagesInput): SQL | undefined { const conditions: (SQL | undefined)[] = [ input.tab === 'archive' ? isNotNull(source.table.archivedAt) : isNull(source.table.archivedAt) ] const search = input.search?.trim() if (search && source.searchColumns.length > 0) { const term = `%${search}%` conditions.push(or(...source.searchColumns.map((column) => ilike(column, term)))) } return and(...conditions) } function buildSelect(source: MessageSource, where: SQL | undefined) { return db .select({ id: sql`${source.table.id}::text`.as('id'), formName: sql`${source.name}::text`.as('form_name'), formLabel: sql`${source.label}::text`.as('form_label'), from: messageTextColumn(source.columns.from).as('sender'), subject: messageTextColumn(source.columns.subject).as('subject'), submittedAt: sql`${source.table.submittedAt}::text`.as('submitted_at'), readAt: sql`${source.table.readAt}::text`.as('read_at'), unread: sql`${source.table.readAt} IS NULL`.as('unread'), archivedAt: sql`${source.table.archivedAt}::text`.as('archived_at') }) .from(source.table) .where(where) } async function listMessages(input: GetMessagesInput): Promise { 'use cache' cacheLife('max') const sources = input.forms ? messageSources.filter((source) => input.forms?.includes(source.name)) : messageSources for (const source of sources) { cacheTag(source.cacheTag) } if (sources.length === 0) { return { messages: [], total: 0, nextOffset: null } } const offset = Math.max(0, input.offset ?? 0) const limit = Math.min(MAX_PAGE_SIZE, Math.max(1, input.limit ?? DEFAULT_MESSAGES_PAGE_SIZE)) const arms = sources.map((source) => ({ source, where: buildWhere(source, input) })) const [first, second, ...rest] = arms.map(({ source, where }) => buildSelect(source, where)) const query = second ? unionAll(first, second, ...rest) : first const [rows, total] = await Promise.all([ query .orderBy(desc(sql`unread`), desc(sql`submitted_at`)) .limit(limit) .offset(offset), countMessageRows(arms) ]) const messages: MessageListItem[] = rows.map((row) => ({ id: row.id, formName: row.formName, formLabel: row.formLabel, from: row.from, subject: row.subject ?? `${row.formLabel} submission`, submittedAt: fromDatabaseTimestamp(row.submittedAt), readAt: fromDatabaseTimestamp(row.readAt), archivedAt: fromDatabaseTimestamp(row.archivedAt) })) return { messages, total, nextOffset: offset + limit < total ? offset + limit : null } } export async function getMessages(input: GetMessagesInput): Promise { await requireRole([UserRole.ADMIN, UserRole.EDITOR]) try { return await listMessages(input) } catch (error) { console.error('Error fetching messages:', error) throw new Error('Failed to fetch messages') } }