Update promotion program feature

2 files changed, 101 insertions, 0 deletions

diff --git a/src-migrate/pages/api/product-variant/[id].tsx b/src-migrate/pages/api/product-variant/[id].tsx
new file mode 100644
index 00000000..ec95714d
--- /dev/null
+++ b/src-migrate/pages/api/product-variant/[id].tsx
@@ -0,0 +1,45 @@
+import { NextApiRequest, NextApiResponse } from "next";
+import { SolrResponse } from "~/common/types/solr";
+
+const SOLR_HOST = process.env.SOLR_HOST as string
+
+export default async function handler(req: NextApiRequest, res: NextApiResponse) {
+  const variantId = req.query.id as string
+  let price_tier = 'tier1'
+
+  let auth = req.cookies.auth ? JSON.parse(req.cookies.auth) : null
+  if (auth?.pricelist) price_tier = auth.pricelist
+
+  if (req.method === 'GET') {
+    const queryParams = new URLSearchParams({ q: `id:${variantId}` })
+    const response = await fetch(`${SOLR_HOST}/solr/variants/select?${queryParams.toString()}`)
+    const data: SolrResponse<any[]> = await response.json()
+
+    if (data.response.numFound === 0) {
+      res.status(404).json({ error: 'Variant not found' })
+      return
+    }
+
+    const variant = await extractVariant(data.response.docs[0], price_tier)
+
+    res.status(200).json({ data: variant })
+  }
+}
+
+const extractVariant = async (variant: any, price_tier: string) => {
+  const data: any = {}
+
+  data.id = parseInt(variant.id)
+  data.parent_id = variant.template_id_i
+  data.display_name = variant.display_name_s
+  data.image = variant.image_s
+  data.name = variant.name_s
+  data.default_code = variant.default_code_s
+  data.price = {
+    price: variant.price_v2_f,
+    discount_percentage: variant[`discount_${price_tier}_v2_f`] || 0,
+    price_discount: variant[`price_${price_tier}_v2_f`] || 0,
+  }
+
+  return data
+}
\ No newline at end of file
diff --git a/src-migrate/pages/api/product-variant/[id]/promotion/highlight.tsx b/src-migrate/pages/api/product-variant/[id]/promotion/highlight.tsx
new file mode 100644
index 00000000..0fe8fd1b
--- /dev/null
+++ b/src-migrate/pages/api/product-variant/[id]/promotion/highlight.tsx
@@ -0,0 +1,56 @@
+import { NextApiRequest, NextApiResponse } from "next";
+import { SolrResponse } from "~/common/types/solr";
+
+const SOLR_HOST = process.env.SOLR_HOST as string
+
+export default async function handler(req: NextApiRequest, res: NextApiResponse) {
+  const productId = req.query.id as string
+
+  if (req.method === 'GET') {
+    const types = ['bundling', 'discount_loading', 'merchandise']
+    const queryParams = new URLSearchParams({
+      q: `product_ids:${productId}`,
+      rows: '1'
+    })
+
+    let programs: any[] = []
+
+    for (const type of types) {
+      queryParams.set('fq', `type_value_s:${type}`)
+      const response = await fetch(`${SOLR_HOST}/solr/promotion_program_lines/select?${queryParams.toString()}`)
+      const data: SolrResponse<any[]> = await response.json()
+      programs.push(...data.response.docs)
+    }
+
+    programs = await extractPrograms(programs)
+    res.status(200).json({ data: programs })
+  }
+}
+
+const extractPrograms = async (programs: any[]) => {
+  const result = []
+
+  for (const program of programs) {
+    const data: any = {}
+
+    data.id = program.id
+    data.program_id = program.program_id_i
+    data.name = program.name_s
+    data.type = {
+      value: program.type_value_s,
+      label: program.type_label_s,
+    }
+    data.limit = program.package_limit_i
+    data.limit_user = program.package_limit_user_i
+    data.limit_trx = program.package_limit_trx_i
+    data.price = program.price_f
+    data.total_qty = program.total_qty_i
+
+    data.products = JSON.parse(program.products_s)
+    data.free_products = JSON.parse(program.free_products_s)
+
+    result.push(data)
+  }
+
+  return result
+}
\ No newline at end of file