mirror of
https://github.com/hanzoai/sign.git
synced 2026-10-21 01:21:51 +00:00
zooqueen
fb4e3df0e3
The product is branded Hanzo eSign (esign.hanzo.ai, repo hanzoai/esign). Rename all workspace packages @hanzo/sign-* → @hanzo/esign-* (1052 files) and align docker/Dockerfile turbo --scope/--filter to the actual remix package name @hanzo/esign (was a pre-existing mismatch with -remix that broke the build). Protected deps (@hanzo/insights, @hanzo/logo) untouched.
35 lines
1.1 KiB
TypeScript
35 lines
1.1 KiB
TypeScript
import { DateTime } from 'luxon';
|
|
|
|
import { kyselyPrisma, monthTrunc } from '@hanzo/esign-prisma';
|
|
|
|
export const getUserMonthlyGrowth = async () => {
|
|
// SQLite month truncation (epoch-ms DateTime → YYYY-MM-01 via strftime).
|
|
const monthExpr = monthTrunc('User.createdAt');
|
|
|
|
const qb = kyselyPrisma.$kysely
|
|
.selectFrom('User')
|
|
.select(({ fn }) => [
|
|
monthExpr.as('month'),
|
|
fn.count('id').as('count'),
|
|
fn
|
|
.sum(fn.count('id'))
|
|
// Feels like a bug in the Kysely extension but I just can not do this orderBy in a type-safe manner
|
|
// eslint-disable-next-line @typescript-eslint/consistent-type-assertions, @typescript-eslint/no-explicit-any
|
|
.over((ob) => ob.orderBy(monthExpr as any))
|
|
.as('cume_count'),
|
|
])
|
|
.groupBy('month')
|
|
.orderBy('month', 'desc')
|
|
.limit(12);
|
|
|
|
const result = await qb.execute();
|
|
|
|
return result.map((row) => ({
|
|
month: DateTime.fromFormat(row.month, 'yyyy-MM-dd').toFormat('yyyy-MM'),
|
|
count: Number(row.count),
|
|
cume_count: Number(row.cume_count),
|
|
}));
|
|
};
|
|
|
|
export type GetUserMonthlyGrowthResult = Awaited<ReturnType<typeof getUserMonthlyGrowth>>;
|