Skip to content

Email for professionals and teams

1022 B
Raw Blame
import { and, asc, eq } from "drizzle-orm";
import type { getDb } from "@/db";
import { folders } from "@/db/schema";
import type { SessionUser } from "@/lib/auth/types";
import { getMailboxAccessLevel } from "@/lib/mailboxes/access";

type Db = ReturnType<typeof getDb>;

export async function getMailboxFolderAccess(db: Db, user: SessionUser, mailboxId: string) {
	const access = await getMailboxAccessLevel(db, user, mailboxId);
	if (!access?.canRead) return null;
	return { mailboxId: access.mailbox.id, mailboxUserId: access.mailbox.userId, canManage: access.canManage };
}

export function listFoldersForMailbox(db: Db, mailboxId: string) {
	return db
		.select()
		.from(folders)
		.where(eq(folders.mailboxId, mailboxId))
		.orderBy(asc(folders.name));
}

export async function getFolderForMailbox(db: Db, folderId: string, mailboxId: string) {
	const [folder] = await db
		.select()
		.from(folders)
		.where(and(eq(folders.id, folderId), eq(folders.mailboxId, mailboxId)))
		.limit(1);
	return folder ?? null;
}