(대표님) 20250630 16시 - 유저 도메인별 라우터 분리와 보안성검토 대응

2 files changed, 52 insertions, 1 deletions

diff --git a/lib/admin-users/repository.ts b/lib/admin-users/repository.ts
index aff2da28..63e98b4e 100644
--- a/lib/admin-users/repository.ts
+++ b/lib/admin-users/repository.ts
@@ -49,6 +49,30 @@ export async function selectUsersWithCompanyAndRoles(
   return rows
 }
 
+export async function selectUsers(
+  tx: PgTransaction<any, any, any>,
+  params: {
+    where?: any
+    orderBy?: (ReturnType<typeof asc> | ReturnType<typeof desc>)[]
+    offset?: number
+    limit?: number
+  }
+) {
+  const { where, orderBy, offset = 0, limit = 10 } = params
+
+  // 1) 쿼리 빌더 생성
+  const queryBuilder = tx
+    .select()
+    .from(users)
+    .where(where)
+    .orderBy(...(orderBy ?? []))
+    .offset(offset)
+    .limit(limit)
+
+  const rows = await queryBuilder
+  return rows
+}
+
 
 /** 총 개수 count */
 export async function countUsers(
@@ -59,6 +83,14 @@ export async function countUsers(
   return res[0]?.count ?? 0;
 }
 
+export async function countUsersSimple(
+  tx: PgTransaction<any, any, any>,
+  where?: any
+) {
+  const res = await tx.select({ count: count() }).from(users).where(where);
+  return res[0]?.count ?? 0;
+}
+
 export async function groupByCompany(
   tx: PgTransaction<any, any, any>,
 ) {
diff --git a/lib/admin-users/validations.ts b/lib/admin-users/validations.ts
index e505067d..3c2fdb9c 100644
--- a/lib/admin-users/validations.ts
+++ b/lib/admin-users/validations.ts
@@ -1,4 +1,4 @@
-import { userRoles, users, type UserView } from "@/db/schema/users";
+import { User, userRoles, users, type UserView } from "@/db/schema/users";
 import {
   createSearchParamsCache,
   parseAsArrayOf,
@@ -29,6 +29,24 @@ export const searchParamsCache = createSearchParamsCache({
 
 })
 
+
+export const searchParamsUsersCache = createSearchParamsCache({
+  flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault(
+    []
+  ),
+  page: parseAsInteger.withDefault(1),
+  perPage: parseAsInteger.withDefault(10),
+  sort: getSortingStateParser<User>().withDefault([
+    { id: "createdAt", desc: true },
+  ]),
+  email: parseAsString.withDefault(""),
+  // advanced filter
+  filters: getFiltersStateParser().withDefault([]),
+  joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
+  search: parseAsString.withDefault(""),
+
+})
+
 export const createUserSchema = z.object({
   email: z
     .string()
@@ -61,5 +79,6 @@ export const updateUserSchema = z.object({
 
 });
 export type GetUsersSchema = Awaited<ReturnType<typeof searchParamsCache.parse>>
+export type GetSimpleUsersSchema = Awaited<ReturnType<typeof searchParamsUsersCache.parse>>
 export type CreateUserSchema = z.infer<typeof createUserSchema>
 export type UpdateUserSchema = z.infer<typeof updateUserSchema>