⚡ 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, 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,
),
};
}