From e270e477f362dd68249bb4a013c66eab293bba82 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 7 Aug 2025 05:04:39 +0000
Subject: (최겸) PQ요청+기본계약 로직 수정(한글화 미적용)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/basic-contract/service.ts | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'lib/basic-contract/service.ts')

diff --git a/lib/basic-contract/service.ts b/lib/basic-contract/service.ts
index 9b5505b5..03b27f96 100644
--- a/lib/basic-contract/service.ts
+++ b/lib/basic-contract/service.ts
@@ -1129,4 +1129,16 @@ export async function getExistingTemplateNames(): Promise<string[]> {
     .groupBy(basicContractTemplates.templateName);
 
   return rows.map((r) => r.templateName);
+}
+
+export async function getExistingTemplateNamesById(id:number): Promise<string> {
+  const rows = await db
+    .select({
+      templateName: basicContractTemplates.templateName,
+    })
+    .from(basicContractTemplates)
+    .where(and(eq(basicContractTemplates.status,"ACTIVE"),eq(basicContractTemplates.id,id)))
+    .limit(1)
+
+  return rows[0].templateName;
 }
\ No newline at end of file
-- 
cgit v1.2.3