(김준회) I/F 수신 대량데이터 처리 문제 수정, 파트너측 settings-preferences 링크 오류 수정

2 files changed, 9 insertions, 4 deletions

diff --git a/app/[lng]/partners/(partners)/settings/layout.tsx b/app/[lng]/partners/(partners)/settings/layout.tsx
index 3b8f48a3..4725d982 100644
--- a/app/[lng]/partners/(partners)/settings/layout.tsx
+++ b/app/[lng]/partners/(partners)/settings/layout.tsx
@@ -29,11 +29,11 @@ export default async function SettingsLayout({
 
     {
       title: "Account",
-      href: `/${lng}/evcp/settings`,
+      href: `/${lng}/partners/settings`,
     },
     {
       title: "Preferences",
-      href: `/${lng}/evcp/settings/preferences`,
+      href: `/${lng}/partners/settings/preferences`,
     }
 
   
diff --git a/lib/soap/batch-utils.ts b/lib/soap/batch-utils.ts
index 76127fc2..ff2c3520 100644
--- a/lib/soap/batch-utils.ts
+++ b/lib/soap/batch-utils.ts
@@ -1,4 +1,4 @@
-import { inArray, sql } from "drizzle-orm";
+import { inArray, sql, getTableColumns } from "drizzle-orm";
 import db from "@/db/db";
 
 /**
@@ -31,9 +31,14 @@ export async function bulkUpsert<T extends Record<string, unknown>>(
   // Build SET clause once, using excluded.* reference for every column except PK / createdAt / id
   const buildSetClause = (sample: T) => {
     const setObj: Record<string, unknown> = { updatedAt: new Date() };
+    const tableColumns = getTableColumns(table);
+    
     for (const col of Object.keys(sample)) {
       if (col === uniqueCol || col === "id" || col === "createdAt" || col === "updatedAt") continue;
-      setObj[col] = sql.raw(`excluded."${col}"`);
+      
+      // Drizzle 테이블 스키마에서 실제 데이터베이스 컬럼명 가져오기
+      const dbColumnName = tableColumns[col]?.name || col;
+      setObj[col] = sql.raw(`excluded."${dbColumnName}"`);
     }
     return setObj;
   };