From 44bdb81a60d3a44ba7e379f3c20fe6d8fb284339 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 7 Jul 2025 08:24:16 +0000
Subject: (대표님) 변경사항 20250707 12시 30분
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/page-visits/validation.ts | 44 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 lib/page-visits/validation.ts

(limited to 'lib/page-visits/validation.ts')

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
-- 
cgit v1.2.3