1 files changed, 44 insertions, 0 deletions
diff --git a/lib/page-visits/validation.ts b/lib/page-visits/validation.ts
new file mode 100644
index 00000000..5364505a
--- /dev/null
+++ b/lib/page-visits/validation.ts
@@ -0,0 +1,44 @@
+import {
+    createSearchParamsCache,
+    parseAsArrayOf,
+    parseAsInteger,
+    parseAsString,
+    parseAsStringEnum,
+  } from "nuqs/server"
+  import * as z from "zod"
+  
+  import { getFiltersStateParser, getSortingStateParser } from "@/lib/parsers"
+  import { pageVisits, users } from "@/db/schema"
+  
+  // 조인된 데이터 타입 정의
+  export type ExtendedPageVisit = typeof pageVisits.$inferSelect & {
+    userEmail?: string | null;
+    userName?: string | null;
+    durationFormatted?: string; // 계산된 필드
+    isLongVisit?: boolean; // 5분 이상 체류
+  };
+  
+  // 검색 파라미터 캐시 정의
+  export const searchParamsCache = createSearchParamsCache({
+    flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault([]),
+    page: parseAsInteger.withDefault(1),
+    perPage: parseAsInteger.withDefault(10),
+    
+    // 정렬
+    sort: getSortingStateParser<ExtendedPageVisit>().withDefault([
+      { id: "visitedAt", desc: true },
+    ]),
+    
+    // 기본 필터
+    route: parseAsString.withDefault(""),
+    deviceType: parseAsString.withDefault(""),
+    browserName: parseAsString.withDefault(""),
+    
+    // 고급 필터
+    filters: getFiltersStateParser().withDefault([]),
+    joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
+    search: parseAsString.withDefault(""),
+  });
+  
+  // 타입 내보내기
+  export type GetPageVisitsSchema = Awaited<ReturnType<typeof searchParamsCache.parse>>;
+\ No newline at end of file