⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { and, desc, eq } from "drizzle-orm";
import db from "../../database";
import {
notificationTable,
projectTable,
taskTable,
workspaceTable,
} from "../../database/schema";
import type { PermissionMap } from "../../utils/role-permissions";
import { notificationReadAccess } from "../resource-access";
import { notificationWorkspaceFilter } from "../workspace-filter";
async function getNotifications(
userId: string,
workspaceId?: string,
apiKeyPermissions?: PermissionMap | null,
) {
const access = await notificationReadAccess(
userId,
notificationTable.resourceId,
notificationTable.resourceType,
apiKeyPermissions,
workspaceId,
);
const rows = await db
.select({
notification: notificationTable,
projectId: projectTable.id,
workspaceId: workspaceTable.id,
})
.from(notificationTable)
.leftJoin(
taskTable,
and(
eq(notificationTable.resourceId, taskTable.id),
eq(notificationTable.resourceType, "task"),
),
)
.leftJoin(projectTable, eq(taskTable.projectId, projectTable.id))
.leftJoin(workspaceTable, eq(projectTable.workspaceId, workspaceTable.id))
.where(
and(
eq(notificationTable.userId, userId),
notificationWorkspaceFilter(workspaceId),
access,
),
)
.orderBy(desc(notificationTable.createdAt))
.limit(50);
return rows.map(({ notification, projectId, workspaceId }) => {
if (!projectId && !workspaceId) {
return notification;
}
const existing =
notification.eventData &&
typeof notification.eventData === "object" &&
!Array.isArray(notification.eventData)
? (notification.eventData as Record<string, unknown>)
: {};
return {
...notification,
eventData: {
...existing,
projectId: projectId ?? existing.projectId ?? null,
workspaceId: workspaceId ?? existing.workspaceId ?? null,
},
};
});
}
export default getNotifications;