From be0f537dc4fe384eef09436833c6407e6482c16d Mon Sep 17 00:00:00 2001
From: Rafi Zadanly <zadanlyr@gmail.com>
Date: Thu, 9 Nov 2023 15:40:16 +0700
Subject: Initial commit

---
 src/app/api/product/import/route.tsx | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 src/app/api/product/import/route.tsx

(limited to 'src/app/api/product/import')

diff --git a/src/app/api/product/import/route.tsx b/src/app/api/product/import/route.tsx
new file mode 100644
index 0000000..7358205
--- /dev/null
+++ b/src/app/api/product/import/route.tsx
@@ -0,0 +1,27 @@
+import { NextRequest, NextResponse } from "next/server";
+import { prisma } from "prisma/client";
+import * as XLSX from "xlsx";
+
+export async function POST(request: NextRequest) {
+  const body = await request.arrayBuffer();
+  const workbook = XLSX.read(body, { type: 'buffer' })
+  const worksheetName = workbook.SheetNames[0]
+  const worksheet = workbook.Sheets[worksheetName]
+  const fileData: any[] = XLSX.utils.sheet_to_json(worksheet, { header: 1 })
+  fileData.shift();
+
+  const newProducts = fileData.map(row => ({
+    id: undefined,
+    isDifferent: false,
+    name: row[0],
+    barcode: row[1],
+    itemCode: row[2],
+    onhandQty: row[3],
+    differenceQty: row[4],
+    companyId: row[5],
+  }));
+
+  await prisma.product.createMany({ data: newProducts })
+
+  return NextResponse.json(true)
+}
\ No newline at end of file
-- 
cgit v1.2.3