diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-07 05:04:39 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-07 05:04:39 +0000 |
| commit | e270e477f362dd68249bb4a013c66eab293bba82 (patch) | |
| tree | ef29ec732fc62c220ca2f6ab12aa282b0db7c9ab /lib/basic-contract/service.ts | |
| parent | a5cecbef039e29beaa616e3a36e7f15b8b35623c (diff) | |
(최겸) PQ요청+기본계약 로직 수정(한글화 미적용)
Diffstat (limited to 'lib/basic-contract/service.ts')
| -rw-r--r-- | lib/basic-contract/service.ts | 12 |
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 |