1 files changed, 65 insertions, 1 deletions
diff --git a/lib/basic-contract/repository.ts b/lib/basic-contract/repository.ts
index aab70106..237402d0 100644
--- a/lib/basic-contract/repository.ts
+++ b/lib/basic-contract/repository.ts
@@ -1,7 +1,7 @@
 "use server";
 
 import { asc, count,inArray ,eq} from "drizzle-orm";
-import { basicContractTemplates, basicContractView, type BasicContractTemplate } from "@/db/schema";
+import { basicContractTemplates, basicContractView,basicContractTemplateStatsView, type BasicContractTemplate } from "@/db/schema";
 import { PgTransaction } from "drizzle-orm/pg-core";
 import db from "@/db/db"; 
 
@@ -39,6 +39,47 @@ export async function selectBasicContracts(
 
   return tx
     .select()
+    .from(basicContractTemplateStatsView)
+    .where(where || undefined)
+    .orderBy(...(orderBy || [asc(basicContractTemplateStatsView.lastActivityDate)]))
+    .offset(offset || 0)
+    .limit(limit || 50);
+}
+
+export async function selectBasicContractsVendor(
+  tx: PgTransaction<any, any, any>,
+  options: {
+    where?: any;
+    orderBy?: any[];
+    offset?: number;
+    limit?: number;
+  }
+) {
+  const { where, orderBy, offset, limit } = options;
+
+  return tx
+    .select()
+    .from(basicContractView)
+    .where(where || undefined)
+    .orderBy(...(orderBy || [asc(basicContractView.createdAt)]))
+    .offset(offset || 0)
+    .limit(limit || 50);
+}
+
+
+export async function selectBasicContractsById(
+  tx: PgTransaction<any, any, any>,
+  options: {
+    where?: any;
+    orderBy?: any[];
+    offset?: number;
+    limit?: number;
+  }
+) {
+  const { where, orderBy, offset, limit } = options;
+
+  return tx
+    .select()
     .from(basicContractView)
     .where(where || undefined)
     .orderBy(...(orderBy || [asc(basicContractView.createdAt)]))
@@ -65,12 +106,35 @@ export async function countBasicContracts(
 ) {
   const result = await tx
     .select({ count: count() })
+    .from(basicContractTemplateStatsView)
+    .where(where || undefined);
+
+  return result[0]?.count || 0;
+}
+
+export async function countBasicContractsVendor(
+  tx: PgTransaction<any, any, any>,
+  where?: any
+) {
+  const result = await tx
+    .select({ count: count() })
     .from(basicContractView)
     .where(where || undefined);
 
   return result[0]?.count || 0;
 }
 
+export async function countBasicContractsById(
+  tx: PgTransaction<any, any, any>,
+  where?: any
+) {
+  const result = await tx
+    .select({ count: count() })
+    .from(basicContractView)
+    .where(where || undefined);
+
+  return result[0]?.count || 0;
+}
 
 // 템플릿 생성
 export async function insertBasicContractTemplate(