sanity-product-updated.ts

import {inngest} from 'inngest/inngest.server'
import {prisma} from '@skillrecordings/database'
import {v4} from 'uuid'
import {loadSanityProduct} from './index'
import {SANITY_WEBHOOK_EVENT} from '../sanity-inngest-events'
import {paymentOptions} from 'pages/api/skill/[...skillRecordings]'

const stripe = paymentOptions.providers.stripe?.paymentClient

export const sanityProductUpdated = inngest.createFunction(
  {
    id: `product-update`,
    name: 'Update Product in Database',
    concurrency: 1,
    debounce: {
      key: 'event.data._id + "-" + event.data.event',
      period: '30s',
    },
  },
  {
    event: SANITY_WEBHOOK_EVENT,
    if: 'event.data.event == "product.update"',
  },
  async ({event, step}) => {
    if (!stripe) {
      throw new Error('Payment provider (Stripe) is missing')
    }

    const sanityProduct = await step.run('get sanity product', async () => {
      return loadSanityProduct(event.data._id)
    })

    const {
      productId,
      title,
      quantityAvailable,
      unitAmount,
      slug,
      image,
      upgradableTo,
      state,
    } = sanityProduct

    if (!productId) {
      throw new Error(`Product id not found`)
    }

    const product = await step.run('get product in database', async () => {
      return await prisma.product.findUnique({
        where: {
          id: productId,
        },
        include: {
          prices: true,
        },
      })
    })

    if (!product) {
      throw new Error(`Product not found [${productId}]`)
    }

    const merchantProduct = await step.run('get merchant product', async () => {
      return await prisma.merchantProduct.findFirst({
        where: {
          productId,
        },
      })
    })

    if (!merchantProduct) {
      throw new Error(
        `Merchant Product not found for product id [${productId}]`,
      )
    }

    const currentProductUpgrades = await step.run(
      'get product upgrades',
      async () => {
        return await prisma.upgradableProducts.findMany({
          where: {
            upgradableFromId: product.id,
          },
        })
      },
    )

    const upgradeToIds = upgradableTo?.map(
      (upgradeToProduct) => upgradeToProduct.productId,
    )
    const currentProductUpgradeIds = currentProductUpgrades?.map(
      (currentProductUpgrade) => currentProductUpgrade.upgradableToId,
    )
    const upgradeToIdsMatch = upgradeToIds?.every((id) =>
      currentProductUpgradeIds?.includes(id),
    )

    if (!upgradeToIdsMatch) {
      await step.run('delete product upgrades', async () => {
        return await prisma.upgradableProducts.deleteMany({
          where: {
            upgradableFromId: product.id,
          },
        })
      })

      if (upgradableTo) {
        await step.run('create product upgrades', async () => {
          return await prisma.upgradableProducts.createMany({
            data: upgradableTo.map((upgradeToProduct) => ({
              upgradableFromId: product.id,
              upgradableToId: upgradeToProduct.productId,
            })),
          })
        })
      }
    }

    const stripeProduct = await step.run('get stripe product', async () => {
      if (!merchantProduct?.identifier) {
        throw new Error('Merchant Product not found')
      }
      return await stripe.products.retrieve(merchantProduct.identifier)
    })

    const priceChanged = !product.prices
      .map((price) => Number(price.unitAmount))
      .includes(unitAmount)

    if (priceChanged) {
      const currentMerchantPrice = await step.run(
        'get current merchant price',
        async () => {
          return await prisma.merchantPrice.findFirst({
            where: {
              priceId: product.prices[0].id,
            },
          })
        },
      )

      const currentStripePrice = await step.run(
        'get stripe price',
        async () => {
          if (!currentMerchantPrice?.identifier) {
            throw new Error('Merchant Price not found')
          }
          return await stripe.prices.retrieve(currentMerchantPrice.identifier)
        },
      )

      const newStripePrice = await step.run(
        'create new stripe price',
        async () => {
          return await stripe.prices.create({
            unit_amount: Math.floor(Number(unitAmount) * 100),
            currency: 'usd',
            product: stripeProduct.id,
            active: true,
          })
        },
      )

      await step.run('set stripeProduct default price', async () => {
        return await stripe.products.update(stripeProduct.id, {
          default_price: newStripePrice.id,
        })
      })

      await step.run('create new merchant price', async () => {
        const newMerchantPriceId = v4()
        return await prisma.merchantPrice.create({
          data: {
            id: newMerchantPriceId,
            merchantProductId: merchantProduct.id,
            priceId: product.prices[0].id,
            merchantAccountId: merchantProduct.merchantAccountId,
            identifier: newStripePrice.id,
            status: 1,
          },
        })
      })

      if (currentMerchantPrice) {
        await step.run('deactivate old merchant price', async () => {
          return await prisma.merchantPrice.update({
            where: {
              id: currentMerchantPrice.id,
            },
            data: {
              status: 0,
            },
          })
        })
      }

      await step.run('update price in database', async () => {
        return await prisma.price.update({
          where: {
            id: product.prices[0].id,
          },
          data: {
            nickname: title,
            unitAmount,
          },
        })
      })

      if (currentStripePrice) {
        await step.run('deactivate stripe price', async () => {
          return await stripe.prices.update(currentStripePrice.id, {
            active: false,
          })
        })
      }
    }

    const updatedStripeProduct = await step.run(
      'update stripe product',
      async () => {
        return await stripe.products.update(stripeProduct.id, {
          name: title,
          active: true,
          ...(image && {images: [image.url]}),
          metadata: {
            slug,
          },
        })
      },
    )

    const updatedProduct = await step.run(
      'update product in database',
      async () => {
        return await prisma.product.update({
          where: {
            id: product.id,
          },
          data: {
            name: title,
            quantityAvailable,
            status: state === 'active' ? 1 : 0,
          },
          include: {
            prices: true,
            merchantProducts: true,
          },
        })
      },
    )

    return {updatedProduct, updatedStripeProduct}
  },
)