Skip to content

armgit / kaneo

Public Imported from GitHub
0

⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.

3.4 KB
Raw Blame
import { and, count, desc, eq, exists, gte, sql } from "drizzle-orm";
import db, { schema } from "../../database";
import { getInstanceSettings } from "../../instance-settings/get-instance-settings";
import { instanceAdminRoleSql } from "../../utils/instance-admin-role";
import { notBannedCondition } from "../../utils/user-ban";
import { configurationWarnings } from "../overview/configuration-warnings";
import { getServiceStatus } from "../system/get-service-status";

export default async function getOverview() {
  const {
    userTable: user,
    sessionTable: session,
    workspaceTable: workspace,
    adminAuditLogTable: audit,
  } = schema;
  const cutoff = new Date(Date.now() - 30 * 24 * 60 * 60 * 1_000);
  const enabled = notBannedCondition();
  const recentlyActive = exists(
    db
      .select({ id: session.id })
      .from(session)
      .where(and(eq(session.userId, user.id), gte(session.updatedAt, cutoff))),
  );
  const [
    [
      users = {
        total: 0,
        activeLast30Days: 0,
        deactivated: 0,
        enabledAdmins: 0,
      },
    ],
    [workspaces = { total: 0, archived: 0 }],
    recentUsers,
    recentActions,
    services,
  ] = await Promise.all([
    db
      .select({
        total: count(),
        activeLast30Days:
          sql`count(*) filter (where ${enabled} and ${recentlyActive})`.mapWith(
            Number,
          ),
        deactivated: sql`count(*) filter (where not (${enabled}))`.mapWith(
          Number,
        ),
        enabledAdmins:
          sql`count(*) filter (where ${enabled} and ${instanceAdminRoleSql(user.role)})`.mapWith(
            Number,
          ),
      })
      .from(user),
    db
      .select({
        total: count(),
        archived:
          sql`count(*) filter (where ${workspace.archivedAt} is not null)`.mapWith(
            Number,
          ),
      })
      .from(workspace),
    db
      .select({
        id: user.id,
        name: user.name,
        email: user.email,
        image: user.image,
        createdAt: user.createdAt,
      })
      .from(user)
      .orderBy(desc(user.createdAt), desc(user.id))
      .limit(5),
    db
      .select({
        id: audit.id,
        createdAt: audit.createdAt,
        action: audit.action,
        actor: {
          id: audit.actorUserId,
          name: audit.actorName,
          email: audit.actorEmail,
        },
        targetType: audit.targetType,
        targetId: audit.targetId,
        targetLabel: audit.targetLabel,
      })
      .from(audit)
      .orderBy(desc(audit.createdAt), desc(audit.id))
      .limit(5),
    getServiceStatus(),
  ]);
  return {
    users: {
      total: users.total,
      activeLast30Days: users.activeLast30Days,
      deactivated: users.deactivated,
    },
    workspaces,
    recentUsers: recentUsers.map((row) => ({
      ...row,
      createdAt: row.createdAt.toISOString(),
    })),
    recentActions: recentActions.map((row) => ({
      ...row,
      createdAt: row.createdAt.toISOString(),
    })),
    services: {
      checkedAt: services.checkedAt,
      api: services.api.status,
      database: services.database.status,
      realtime: services.realtime.status,
      redis: services.redis.status,
      email: services.email.status,
      storage: services.storage.status,
    },
    warnings: configurationWarnings(
      services,
      (await getInstanceSettings()).registrationEnabled,
      users.enabledAdmins,
    ),
  };
}