From c977921f02308af769af37f6b7d37b21869797f2 Mon Sep 17 00:00:00 2001
From: Rafi Zadanly <zadanlyr@gmail.com>
Date: Tue, 5 Dec 2023 10:53:52 +0700
Subject: Add externalId on import and export

---
 src/app/api/product/import/route.tsx      |  1 +
 src/app/api/stock-opname/export/route.tsx |  1 +
 src/app/api/stock-opname/route.tsx        | 11 +----------
 3 files changed, 3 insertions(+), 10 deletions(-)

(limited to 'src/app/api')

diff --git a/src/app/api/product/import/route.tsx b/src/app/api/product/import/route.tsx
index eb87f07..e4e38c6 100644
--- a/src/app/api/product/import/route.tsx
+++ b/src/app/api/product/import/route.tsx
@@ -25,6 +25,7 @@ export async function POST(request: NextRequest) {
     onhandQty: row[3],
     differenceQty: row[4],
     companyId: row[5],
+    externalId: row[6] ?? null
   }));
 
   const whereCompany = { companyId: intCompanyId }
diff --git a/src/app/api/stock-opname/export/route.tsx b/src/app/api/stock-opname/export/route.tsx
index 650ceba..2537070 100644
--- a/src/app/api/stock-opname/export/route.tsx
+++ b/src/app/api/stock-opname/export/route.tsx
@@ -46,6 +46,7 @@ export async function GET(request: NextRequest) {
 
   for (const opname of stockOpnames) {
     const defaultItems = {
+      externalId: opname?.externalId,
       itemCode: opname?.itemCode,
       barcode: opname?.barcode,
       name: opname.name,
diff --git a/src/app/api/stock-opname/route.tsx b/src/app/api/stock-opname/route.tsx
index e98c3b2..cba16e2 100644
--- a/src/app/api/stock-opname/route.tsx
+++ b/src/app/api/stock-opname/route.tsx
@@ -40,16 +40,7 @@ export async function GET(request: NextRequest) {
   const products = await prisma.product.findMany({
     skip: (intPage - 1) * PAGE_SIZE,
     take: PAGE_SIZE,
-    where,
-    select: {
-      id: true,
-      name: true,
-      itemCode: true,
-      barcode: true,
-      onhandQty: true,
-      differenceQty: true,
-      isDifferent: true
-    }
+    where
   })
 
   const productCount = await prisma.product.count({ where })
-- 
cgit v1.2.3