(대표님) lib 파트 커밋

1 files changed, 4 insertions, 20 deletions

diff --git a/lib/form-list/repository.ts b/lib/form-list/repository.ts
index 9c7f6891..ef8000c5 100644
--- a/lib/form-list/repository.ts
+++ b/lib/form-list/repository.ts
@@ -1,7 +1,7 @@
 import db from "@/db/db";
 import { projects } from "@/db/schema";
 import { Item, items } from "@/db/schema/items";
-import { tagTypeClassFormMappings } from "@/db/schema/vendorData";
+import { formListsView, tagTypeClassFormMappings } from "@/db/schema/vendorData";
 import {
   eq,
   inArray,
@@ -29,23 +29,8 @@ export async function selectFormLists(
   const { where, orderBy, offset = 0, limit = 10 } = params;
   
   return tx
-    .select({
-      id: tagTypeClassFormMappings.id,
-      projectId: tagTypeClassFormMappings.projectId,
-      tagTypeLabel: tagTypeClassFormMappings.tagTypeLabel,
-      classLabel: tagTypeClassFormMappings.classLabel,
-      formCode: tagTypeClassFormMappings.formCode,
-      formName: tagTypeClassFormMappings.formName,
-      ep: tagTypeClassFormMappings.ep,
-      remark: tagTypeClassFormMappings.remark,
-      createdAt: tagTypeClassFormMappings.createdAt,
-      updatedAt: tagTypeClassFormMappings.updatedAt,
-      // 프로젝트 정보 추가
-      projectCode: projects.code,
-      projectName: projects.name
-    })
-    .from(tagTypeClassFormMappings)
-    .innerJoin(projects, eq(tagTypeClassFormMappings.projectId, projects.id))
+    .select()
+    .from(formListsView)
     .where(where)
     .orderBy(...(orderBy ?? []))
     .offset(offset)
@@ -59,8 +44,7 @@ export async function selectFormLists(
   ) {
     const res = await tx
       .select({ count: count() })
-      .from(tagTypeClassFormMappings)
-      .leftJoin(projects, eq(tagTypeClassFormMappings.projectId, projects.id))
+      .from(formListsView)
       .where(where);
     return res[0]?.count ?? 0;
   }
\ No newline at end of file