(최겸) 구매 피드백 수정(PQ, 실사 등)-1024

1 files changed, 16 insertions, 6 deletions

diff --git a/lib/pq/helper.ts b/lib/pq/helper.ts
index 81ee5db2..d3970fd7 100644
--- a/lib/pq/helper.ts
+++ b/lib/pq/helper.ts
@@ -1,11 +1,12 @@
-import { 

-  vendorPQSubmissions, 

-  vendors, 

-  projects, 

-  users, 

-  vendorInvestigations 

+import {

+  vendorPQSubmissions,

+  vendors,

+  projects,

+  users,

+  vendorInvestigations

 } from "@/db/schema"

 import { CustomColumnMapping } from "../filter-columns"

+import { sql } from "drizzle-orm"

 

 /**

  * Helper function to create custom column mapping for PQ submissions

@@ -41,6 +42,12 @@ export function createPQFilterMapping(): CustomColumnMapping {
     investigationStatus: { table: vendorInvestigations, column: "investigationStatus" },

     investigationAddress: { table: vendorInvestigations, column: "investigationAddress" },

     qmManagerId: { table: vendorInvestigations, column: "qmManagerId" },

+

+    // pqItems JSON 검색 (첫 번째 아이템의 itemCode 또는 itemName)

+    pqItems: {

+      table: vendorPQSubmissions,

+      column: "pqItems"

+    },

   }

 }

 

@@ -90,5 +97,8 @@ export function createPQDirectColumnMapping(): CustomColumnMapping {
     investigationStatus: vendorInvestigations.investigationStatus,

     investigationAddress: vendorInvestigations.investigationAddress,

     qmManagerId: vendorInvestigations.qmManagerId,

+

+    // pqItems JSON 검색 (첫 번째 아이템의 itemCode 또는 itemName)

+    pqItems: vendorPQSubmissions.pqItems,

   }

 }
\ No newline at end of file