Email for professionals and teams
import { eq, desc, and } from "drizzle-orm";
import { getDb } from "@/db";
import { messages, domains, mailboxes } from "@/db/schema";
import { getMailboxAccessLevel, listAccessibleMailboxIds } from "@/lib/mailboxes/access";
import { createAuditLog } from "@/lib/mailboxes/audit";
import type { SessionUser } from "@/lib/auth/types";
import { applySpamFeedback } from "@/lib/spam/feedback";
export async function listMessagesForUser(
env: CloudflareEnv,
userId: string,
options?: { direction?: "inbound" | "outbound"; limit?: number },
) {
const db = getDb(env);
const limit = options?.limit ?? 50;
const conditions = [eq(messages.userId, userId)];
if (options?.direction) {
conditions.push(eq(messages.direction, options.direction));
}
return db
.select()
.from(messages)
.where(and(...conditions))
.orderBy(desc(messages.createdAt))
.limit(limit);
}
export async function listMailboxesForUser(env: CloudflareEnv, userId: string) {
const db = getDb(env);
return db.select().from(mailboxes).where(eq(mailboxes.userId, userId));
}
export async function userHasMailboxes(env: CloudflareEnv, userId: string): Promise<boolean> {
const db = getDb(env);
const [row] = await db.select({ id: mailboxes.id }).from(mailboxes).where(and(eq(mailboxes.userId, userId), eq(mailboxes.disabled, false))).limit(1);
return !!row;
}
export async function userHasAccessibleMailboxes(env: CloudflareEnv, user: SessionUser): Promise<boolean> {
const db = getDb(env);
const ids = await listAccessibleMailboxIds(db, user);
return ids.length > 0;
}
export async function hasPrimaryDomain(env: CloudflareEnv): Promise<boolean> {
const db = getDb(env);
const [row] = await db.select({ id: domains.id }).from(domains).limit(1);
return !!row;
}
export async function getPrimaryDomain(env: CloudflareEnv) {
const db = getDb(env);
const [row] = await db.select().from(domains).limit(1);
return row ?? null;
}
export async function getMailboxForUser(env: CloudflareEnv, userId: string, mailboxId: string) {
const db = getDb(env);
const [row] = await db
.select()
.from(mailboxes)
.where(and(eq(mailboxes.id, mailboxId), eq(mailboxes.userId, userId)))
.limit(1);
return row ?? null;
}
export async function markMessageAsRead(env: CloudflareEnv, userId: string, messageId: string) {
const db = getDb(env);
const [message] = await db
.select()
.from(messages)
.where(eq(messages.id, messageId))
.limit(1);
if (!message || message.userId !== userId) return false;
await db
.update(messages)
.set({ read: true })
.where(eq(messages.id, messageId));
return true;
}
export async function markMessageAsReadForUser(env: CloudflareEnv, user: SessionUser, messageId: string) {
const db = getDb(env);
const [message] = await db.select().from(messages).where(eq(messages.id, messageId)).limit(1);
if (!message?.mailboxId) return false;
const access = await getMailboxAccessLevel(db, user, message.mailboxId);
if (!access?.canRead) return false;
await db.update(messages).set({ read: true }).where(eq(messages.id, messageId));
await createAuditLog(env, {
actorUserId: user.id,
mailboxId: message.mailboxId,
messageId,
action: "email.read",
});
return true;
}
export async function updateMessageStatusForUser(
env: CloudflareEnv,
user: SessionUser,
messageId: string,
status: string,
) {
const db = getDb(env);
const [message] = await db.select().from(messages).where(eq(messages.id, messageId)).limit(1);
if (!message?.mailboxId) return false;
const access = await getMailboxAccessLevel(db, user, message.mailboxId);
if (!access?.canManage) return false;
if (status === "spam") return applySpamFeedback(env, user, messageId, "spam");
if (status === "received" && message.status === "spam") return applySpamFeedback(env, user, messageId, "ham");
await db.update(messages).set({ status }).where(eq(messages.id, messageId));
await createAuditLog(env, {
actorUserId: user.id,
mailboxId: message.mailboxId,
messageId,
action: "email.delete",
metadata: { status },
});
return true;
}
export async function updateMessageStatus(
env: CloudflareEnv,
userId: string,
messageId: string,
status: string,
) {
const db = getDb(env);
const [message] = await db
.select()
.from(messages)
.where(eq(messages.id, messageId))
.limit(1);
if (!message || message.userId !== userId) return false;
await db
.update(messages)
.set({ status })
.where(eq(messages.id, messageId));
return true;
}