'use server' import { requireRole, UserRole } from '@admin/auth/middleware' import { countMessageRows } from '@admin/lib/messages/count-message-rows' import { messageSources } from '@admin/lib/messages/sources' import { and, isNull } from 'drizzle-orm' import { cacheLife, cacheTag } from 'next/cache' async function countUnreadMessages(): Promise { 'use cache' cacheLife('max') for (const source of messageSources) { cacheTag(source.cacheTag) } return countMessageRows( messageSources.map((source) => ({ source, where: and(isNull(source.table.readAt), isNull(source.table.archivedAt)) })) ) } export async function getUnreadMessageCount(): Promise { await requireRole([UserRole.ADMIN, UserRole.EDITOR]) try { return await countUnreadMessages() } catch (error) { console.error('Error counting unread messages:', error) throw new Error('Failed to count unread messages') } }