Add externalId on import and export

3 files changed, 3 insertions, 10 deletions

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 })