diff options
| author | joonhoekim <26rote@gmail.com> | 2025-10-22 21:10:24 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-10-22 21:10:24 +0900 |
| commit | 6b2a561265fb649398e1770f720365ee10f542e9 (patch) | |
| tree | 50ae6453939d8ce4be850d603450d03d31e05442 /db/schema/vendorDocu.ts | |
| parent | 2ecf88af270c5d044a853793f72f3a4536e05b89 (diff) | |
(김준회) SWP 문서 업로드
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 3 |
1 files changed, 2 insertions, 1 deletions
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' ), |