(고건) 삭제된 이메일 템플릿이 목록에 보이지 않도록 수정

1 files changed, 5 insertions, 3 deletions

diff --git a/lib/email-template/service.ts b/lib/email-template/service.ts
index c492410a..7c92b377 100644
--- a/lib/email-template/service.ts
+++ b/lib/email-template/service.ts
@@ -1,7 +1,7 @@
 'use server';
 
 import db from '@/db/db';
-import { eq, and, desc, sql, count, ilike, asc, or } from 'drizzle-orm';
+import { eq, and, desc, sql, count, ilike, asc, or, SQL } from 'drizzle-orm';
 import handlebars from 'handlebars';
 import i18next from 'i18next';
 import resourcesToBackend from 'i18next-resources-to-backend';
@@ -255,7 +255,9 @@ export async function getTemplateList(input: GetEmailTemplateSchema) {
       }
     }
 
-    const conditions = [];
+    const conditions: SQL[] = [];
+    conditions.push(eq(templateListView.isActive, true));
+
     if (advancedWhere) conditions.push(advancedWhere);
     if (globalWhere) conditions.push(globalWhere);
     
@@ -265,7 +267,7 @@ export async function getTemplateList(input: GetEmailTemplateSchema) {
     }
 
     // 아니면 ilike, inArray, gte 등으로 where 절 구성
-    const where = finalWhere
+    const where = finalWhere;
 
     // 정렬 조건 구성
     let orderBy;