From 6b2a561265fb649398e1770f720365ee10f542e9 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 22 Oct 2025 21:10:24 +0900
Subject: (김준회) SWP 문서 업로드
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/vendorDocu.ts | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db')

diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts
index 624ce11d..de9dc7fb 100644
--- a/db/schema/vendorDocu.ts
+++ b/db/schema/vendorDocu.ts
@@ -1949,7 +1949,8 @@ export const stageSubmissionView = pgView("stage_submission_view", {
     FROM stage_documents sd
     LEFT JOIN projects p ON sd.project_id = p.id
     LEFT JOIN vendors v ON sd.vendor_id = v.id
-    WHERE sd.buyer_system_status = '승인(DC)'
+    WHERE 
+      ( sd.buyer_system_status = '승인(DC)' OR sd.buyer_system_status = 'Completed' ) -- 승인(DC)라고 하였으나 실제 값은 Completed로 옴
       AND sd.status = 'ACTIVE'
   ),
   
-- 
cgit v1.2.3