From 0174ad394032a8dad81107341f477d6d23a3c04c Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Fri, 24 Oct 2025 09:52:35 +0000
Subject: (최겸) 구매 피드백 수정(PQ, 실사 등)-1024
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/pq/helper.ts | 22 ++++++++++++++++------
 1 file changed, 16 insertions(+), 6 deletions(-)

(limited to 'lib/pq/helper.ts')

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
-- 
cgit v1.2.3