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.
38 lines
1.3 KiB
TypeScript
38 lines
1.3 KiB
TypeScript
import { DateTime } from 'luxon';
|
|
|
|
import { kyselyPrisma, monthTrunc } from '@hanzo/esign-prisma';
|
|
|
|
export const getSignerConversionMonthly = async () => {
|
|
// SQLite month truncation (epoch-ms DateTime → YYYY-MM-01 via strftime).
|
|
const monthExpr = monthTrunc('User.createdAt');
|
|
|
|
const qb = kyselyPrisma.$kysely
|
|
.selectFrom('Recipient')
|
|
.innerJoin('User', 'Recipient.email', 'User.email')
|
|
.select(({ fn }) => [
|
|
monthExpr.as('month'),
|
|
fn.count('Recipient.email').distinct().as('count'),
|
|
fn
|
|
.sum(fn.count('Recipient.email').distinct())
|
|
// eslint-disable-next-line @typescript-eslint/consistent-type-assertions, @typescript-eslint/no-explicit-any
|
|
.over((ob) => ob.orderBy(monthExpr as any))
|
|
.as('cume_count'),
|
|
])
|
|
.where('Recipient.signedAt', 'is not', null)
|
|
.where('Recipient.signedAt', '<', (eb) => eb.ref('User.createdAt'))
|
|
.groupBy(monthExpr)
|
|
.orderBy('month', 'desc');
|
|
|
|
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 GetSignerConversionMonthlyResult = Awaited<
|
|
ReturnType<typeof getSignerConversionMonthly>
|
|
>;
|