diff options
Diffstat (limited to 'lib/vendor-document-list/enhanced-document-service.ts')
| -rw-r--r-- | lib/vendor-document-list/enhanced-document-service.ts | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/lib/vendor-document-list/enhanced-document-service.ts b/lib/vendor-document-list/enhanced-document-service.ts index e5cce1b1..96a5ecff 100644 --- a/lib/vendor-document-list/enhanced-document-service.ts +++ b/lib/vendor-document-list/enhanced-document-service.ts @@ -1059,12 +1059,30 @@ export async function getDocumentDetails(documentId: number) { ilike(simplifiedDocumentsView.vendorDocNumber, searchTerm), ) } + + // 4.5. B4 필터 처리 (drawingMoveGbn 기반) + let b4FilterWhere + if (input.b4FilterType && input.b4FilterType !== 'all') { + if (input.b4FilterType === 'gtt_deliverable') { + b4FilterWhere = eq(simplifiedDocumentsView.drawingMoveGbn, '도면입수') + } else if (input.b4FilterType === 'shi_input') { + b4FilterWhere = eq(simplifiedDocumentsView.drawingMoveGbn, '도면제출') + } + } + + // 4.6. Project Code 필터 처리 + let projectCodeWhere + if (input.projectCode && input.projectCode !== 'all') { + projectCodeWhere = eq(simplifiedDocumentsView.projectCode, input.projectCode) + } // 5. 최종 WHERE 조건 (계약 ID들로 필터링) const finalWhere = and( eq(simplifiedDocumentsView.vendorId, Number(companyId)), advancedWhere, globalWhere, + b4FilterWhere, + projectCodeWhere, ) // 6. 정렬 처리 |
