1 files changed, 12 insertions, 0 deletions
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