(merge) 대표님/최겸 작업사항 머지

1 files changed, 28 insertions, 1 deletions

diff --git a/lib/techsales-rfq/repository.ts b/lib/techsales-rfq/repository.ts
index e9ad3925..1aaf4b3d 100644
--- a/lib/techsales-rfq/repository.ts
+++ b/lib/techsales-rfq/repository.ts
@@ -117,11 +117,24 @@ export async function selectTechSalesRfqsWithJoin(
     projMsrm: biddingProjects.projMsrm,
     ptypeNm: biddingProjects.ptypeNm,
     
-    // 첨부파일 개수
+    // 첨부파일 개수 (타입별로 분리)
     attachmentCount: sql<number>`(
       SELECT COUNT(*) 
       FROM tech_sales_attachments 
       WHERE tech_sales_attachments.tech_sales_rfq_id = ${techSalesRfqs.id}
+      AND tech_sales_attachments.attachment_type = 'RFQ_COMMON'
+    )`,
+    hasTbeAttachments: sql<boolean>`(
+      SELECT CASE WHEN COUNT(*) > 0 THEN TRUE ELSE FALSE END
+      FROM tech_sales_attachments 
+      WHERE tech_sales_attachments.tech_sales_rfq_id = ${techSalesRfqs.id}
+      AND tech_sales_attachments.attachment_type = 'TBE_RESULT'
+    )`,
+    hasCbeAttachments: sql<boolean>`(
+      SELECT CASE WHEN COUNT(*) > 0 THEN TRUE ELSE FALSE END
+      FROM tech_sales_attachments 
+      WHERE tech_sales_attachments.tech_sales_rfq_id = ${techSalesRfqs.id}
+      AND tech_sales_attachments.attachment_type = 'CBE_RESULT'
     )`,
     
     // 벤더 견적 개수
@@ -258,6 +271,20 @@ export async function selectTechSalesVendorQuotationsWithJoin(
       WHERE tech_sales_attachments.tech_sales_rfq_id = ${techSalesRfqs.id}
     )`,
 
+    // 견적서 첨부파일 개수
+    quotationAttachmentCount: sql<number>`(
+      SELECT COUNT(*) 
+      FROM tech_sales_vendor_quotation_attachments 
+      WHERE tech_sales_vendor_quotation_attachments.quotation_id = ${techSalesVendorQuotations.id}
+    )`,
+
+    // RFQ 아이템 개수
+    itemCount: sql<number>`(
+      SELECT COUNT(*) 
+      FROM tech_sales_rfq_items 
+      WHERE tech_sales_rfq_items.rfq_id = ${techSalesRfqs.id}
+    )`,
+
   })
   .from(techSalesVendorQuotations)
   .leftJoin(techSalesRfqs, sql`${techSalesVendorQuotations.rfqId} = ${techSalesRfqs.id}`)