(대표님) 입찰, 법무검토, EDP 변경사항 대응, dolce 개선, form-data 개선, 정규업체 등록관리 추가

(최겸) pq 미사용 컴포넌트 및 페이지 제거, 파일 라우트에 pq 적용

1 files changed, 9 insertions, 2 deletions

diff --git a/db/schema/pq.ts b/db/schema/pq.ts
index 7adcbf8b..0bc720f6 100644
--- a/db/schema/pq.ts
+++ b/db/schema/pq.ts
@@ -133,8 +133,8 @@ export const vendorPQSubmissions = pgTable("vendor_pq_submissions", {
   dueDate: timestamp("due_date"),
   agreements: jsonb("agreements").notNull().default({}), // ✅ 체크 항목들을 JSON으로 저장
 
-  // PQ 대상품목
-  pqItems: varchar("pq_items", { length: 1000 }),
+  // PQ 대상품목 - [{ itemCode: string, itemName: string }, ...]
+  pqItems: jsonb("pq_items"),
 
   submittedAt: timestamp("submitted_at"),
   approvedAt: timestamp("approved_at"),
@@ -405,6 +405,9 @@ export const vendorInvestigationsView = pgView(
       vendorName: vendors.vendorName,
       vendorCode: vendors.vendorCode,
       
+      // PQ 정보
+      pqItems: vendorPQSubmissions.pqItems,
+      
       // User names and emails instead of just IDs
       requesterName: sql<string>`requester.name`.as("requesterName"),
       requesterEmail: sql<string>`requester.email`.as("requesterEmail"),
@@ -436,6 +439,10 @@ export const vendorInvestigationsView = pgView(
       sql`users AS qm_manager`, 
       eq(vendorInvestigations.qmManagerId, sql`qm_manager.id`)
     )
+    .leftJoin(
+      vendorPQSubmissions,
+      eq(vendorInvestigations.pqSubmissionId, vendorPQSubmissions.id)
+    )
 })
 
 // 방문실사 요청 테이블