mirror of
https://github.com/hanzoai/sign.git
synced 2026-10-30 14:57:59 +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.
45 lines
1.4 KiB
TypeScript
45 lines
1.4 KiB
TypeScript
import { DateTime } from 'luxon';
|
|
|
|
import { kyselyPrisma, monthTrunc } from '@hanzo/esign-prisma';
|
|
|
|
import { addZeroMonth } from '../add-zero-month';
|
|
|
|
export const getUserMonthlyGrowth = async (type: 'count' | 'cumulative' = 'count') => {
|
|
// 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'))
|
|
// 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');
|
|
|
|
const result = await qb.execute();
|
|
|
|
const transformedData = {
|
|
labels: result
|
|
.map((row) => DateTime.fromFormat(row.month, 'yyyy-MM-dd').toFormat('MMM yyyy'))
|
|
.reverse(),
|
|
datasets: [
|
|
{
|
|
label: type === 'count' ? 'New Users' : 'Total Users',
|
|
data: result
|
|
.map((row) => (type === 'count' ? Number(row.count) : Number(row.cume_count)))
|
|
.reverse(),
|
|
},
|
|
],
|
|
};
|
|
|
|
return addZeroMonth(transformedData, type === 'cumulative');
|
|
};
|
|
|
|
export type GetUserMonthlyGrowthResult = Awaited<ReturnType<typeof getUserMonthlyGrowth>>;
|