write new obtain-subscription-plans.ts

[chase-moskal]

this is a replacement for fetch-subscription-plans.ts

• the job of this function is to return an array of xiome subscription plans, the details of which are derived by querying our own database, and also querying stripe for related data

desirable traits of an improved system

• fault tolerant -- if stripe products or prices are missing, our system should not explode
• self-healing -- a tier should probably delete itself if the associated stripe product is missing -- stripe is the boss and source-of-truth -- also delete the tier's associated permissions role?
• each tier should be tied to a stripe product, not a stripe price
• if a tier's default stripe price is missing or inactive:
  • let's make the pricing object for the returned subscription plan be undefined -- which means SubscriptionPlan.pricing can be marked optional in the interface
  • the subscription-catalog should not display tiers for which pricing is undefined
  • in the subscription planning ui, if a tier's pricing is undefined, let's display a warning ui indicator, that says something like "price not set", and the merchant/clerk can fix this by setting a new price for the tier and clicking save
• setting a tier to active/inactive should set the stripe product's active/inactive -- need to change this in helpers-for-managing-subscriptions.ts

[chase-moskal]

ideas for an improved listing service

• the idea here is that we delete fetch-subscription-plans.ts, and we don't even write a single monolithic obtain-subscription-plans.ts either --
• instead, we could write a handful of new file/functions in backend utils that serve to make the listing service's listPlans function really easy to read and understand

import * as renraku from "renraku"
import {StoreServiceOptions} from "../../types/options.js"

export const makeSubscriptionListingService = (options: StoreServiceOptions) =>
renraku
.service()
.policy(options.storePolicies.connected)
.expose(auth => ({

    async listPlans() {

        const {planRows, tierRows} =
            await queryDatabaseAboutSubscriptionPlans(auth)

        const {stripeProducts, stripePrices} =
            await queryStripeAboutSubscriptionPlans({
                auth,
                planRows,
                tierRows,
            })

        await performSelfHealingRoutinesForSubscriptionPlans({
            auth,
            planRows,
            tierRows,
            stripeProducts,
            stripePrices,
        })

        return compileDataTogetherIntoSubscriptionPlansForFrontend({
            auth,
            planRows,
            tierRows,
            stripeProducts,
            stripePrices,
        })
    },
}))

[chase-moskal]

• [x] the subscription-catalog should not display tiers for which pricing is undefined

---

• subscription-status component doesn't need any changes -- changes to that component will happen in #214