Function getWeeklyUsage

packages/billing/src/subscription.ts:199–242

(params: {
  userId: string
  billingPeriodStart: Date
  weeklyCreditsLimit: number
  logger: Logger
  conn?: DbConn
})

 * billing-aligned week.
 */
export async function getWeeklyUsage(params: {
  userId: string
  billingPeriodStart: Date
  weeklyCreditsLimit: number
  logger: Logger
  conn?: DbConn
}): Promise<WeeklyUsage> {
  const {
    userId,
    billingPeriodStart,
    weeklyCreditsLimit,
    conn = db,
  } = params

  const now = new Date()
  const weekStart = getWeekStart(billingPeriodStart, now)
  const weekEnd = getWeekEnd(billingPeriodStart, now)

  const result = await conn
    .select({
      total: sql<number>`COALESCE(SUM(${schema.creditLedger.principal} - ${schema.creditLedger.balance}), 0)`,
    })
    .from(schema.creditLedger)
    .where(
      and(
        eq(schema.creditLedger.user_id, userId),
        eq(schema.creditLedger.type, 'subscription'),
        gte(schema.creditLedger.created_at, weekStart),
        lt(schema.creditLedger.created_at, weekEnd),
      ),
    )

  const used = Number(result[0]?.total ?? 0)

  return {
    used,
    limit: weeklyCreditsLimit,
    remaining: Math.max(0, weeklyCreditsLimit - used),
    resetsAt: weekEnd,
    percentUsed: weeklyCreditsLimit > 0
      ? Math.round((used / weeklyCreditsLimit) * 100)
      : 0,
  }
}

// ---------------------------------------------------------------------------
// Block grant management