Function buildActiveGrantsFilter

packages/billing/src/balance-calculator.ts:71–79

(userId: string, now: Date)

> /* + whatever else you call */

function buildActiveGrantsFilter(userId: string, now: Date) {
  return and(
    eq(schema.creditLedger.user_id, userId),
    or(
      isNull(schema.creditLedger.expires_at),
      gt(schema.creditLedger.expires_at, now),
    ),
  )
}

/**
 * Gets active grants for a user, ordered by expiration (soonest first), then priority, and creation date.