(대표님) 변경사항 20250707 12시 30분

15 files changed, 951 insertions, 112 deletions

diff --git a/lib/dashboard/service.ts b/lib/dashboard/service.ts
index 569ff9cd..91ed5eb2 100644
--- a/lib/dashboard/service.ts
+++ b/lib/dashboard/service.ts
@@ -178,18 +178,10 @@ export async function getDashboardData(domain: string): Promise<DashboardData> {
 // 테이블별 전체 통계 조회 (완전히 수정된 버전)
 async function getTableStats(config: TableConfig): Promise<DashboardStats> {
   try {
-    console.log(`\n🔍 테이블 ${config.tableName} 통계 조회 시작`);
-    
-    // 1단계: 기본 총 개수 확인
-    console.log("1단계: 총 개수 조회");
     const totalQuery = `SELECT COUNT(*)::INTEGER as total FROM "${config.tableName}"`;
-    console.log("Total SQL:", totalQuery);
     
     const totalResult = await db.execute(sql.raw(totalQuery));
-    console.log("Total 결과:", totalResult.rows[0]);
     
-    // 2단계: 실제 상태값 확인
-    console.log("2단계: 상태값 분포 확인");
     const statusQuery = `
       SELECT "${config.statusField}" as status, COUNT(*) as count
       FROM "${config.tableName}"
@@ -197,13 +189,9 @@ async function getTableStats(config: TableConfig): Promise<DashboardStats> {
       GROUP BY "${config.statusField}"
       ORDER BY count DESC
     `;
-    console.log("Status SQL:", statusQuery);
     
     const statusResult = await db.execute(sql.raw(statusQuery));
-    console.log("Status 결과:", statusResult.rows);
     
-    // 3단계: 상태별 개수 조회 (개별 쿼리)
-    console.log("3단계: 상태별 개수 조회");
     
     const pendingValues = Object.entries(config.statusMapping)
       .filter(([_, mapped]) => mapped === 'pending')
@@ -217,10 +205,6 @@ async function getTableStats(config: TableConfig): Promise<DashboardStats> {
       .filter(([_, mapped]) => mapped === 'completed')
       .map(([original]) => original);
     
-    console.log("매핑된 상태값:");
-    console.log("- pending:", pendingValues);
-    console.log("- inProgress:", inProgressValues);
-    console.log("- completed:", completedValues);
     
     // 개별 쿼리로 정확한 개수 조회
     let pendingCount = 0;
@@ -235,11 +219,9 @@ async function getTableStats(config: TableConfig): Promise<DashboardStats> {
         FROM "${config.tableName}"
         WHERE "${config.statusField}" IN (${pendingValuesList})
       `;
-      console.log("Pending SQL:", pendingQuery);
       
       const pendingResult = await db.execute(sql.raw(pendingQuery));
       pendingCount = parseInt(pendingResult.rows[0]?.count || '0');
-      console.log("Pending 개수:", pendingCount);
     }
     
     // In Progress 개수
@@ -250,11 +232,9 @@ async function getTableStats(config: TableConfig): Promise<DashboardStats> {
         FROM "${config.tableName}"
         WHERE "${config.statusField}" IN (${inProgressValuesList})
       `;
-      console.log("InProgress SQL:", inProgressQuery);
       
       const inProgressResult = await db.execute(sql.raw(inProgressQuery));
       inProgressCount = parseInt(inProgressResult.rows[0]?.count || '0');
-      console.log("InProgress 개수:", inProgressCount);
     }
     
     // Completed 개수
@@ -265,11 +245,9 @@ async function getTableStats(config: TableConfig): Promise<DashboardStats> {
         FROM "${config.tableName}"
         WHERE "${config.statusField}" IN (${completedValuesList})
       `;
-      console.log("Completed SQL:", completedQuery);
       
       const completedResult = await db.execute(sql.raw(completedQuery));
       completedCount = parseInt(completedResult.rows[0]?.count || '0');
-      console.log("Completed 개수:", completedCount);
     }
     
     const stats = {
@@ -325,10 +303,8 @@ async function getUserTableStats(config: TableConfig, userId: string): Promise<D
       FROM "${config.tableName}"
       WHERE ${userConditionStr}
     `;
-    console.log("User Total SQL:", userTotalQuery);
     
     const userTotalResult = await db.execute(sql.raw(userTotalQuery));
-    console.log("User Total 결과:", userTotalResult.rows[0]);
     
     // 2. 사용자 상태별 개수
     const pendingValues = Object.entries(config.statusMapping)
@@ -372,7 +348,6 @@ async function getUserTableStats(config: TableConfig, userId: string): Promise<D
       
       const userInProgressResult = await db.execute(sql.raw(userInProgressQuery));
       userInProgressCount = parseInt(userInProgressResult.rows[0]?.count || '0');
-      console.log("User InProgress 개수:", userInProgressCount);
     }
     
     // User Completed 개수
@@ -386,7 +361,6 @@ async function getUserTableStats(config: TableConfig, userId: string): Promise<D
       
       const userCompletedResult = await db.execute(sql.raw(userCompletedQuery));
       userCompletedCount = parseInt(userCompletedResult.rows[0]?.count || '0');
-      console.log("User Completed 개수:", userCompletedCount);
     }
 
     const stats = {
@@ -398,7 +372,6 @@ async function getUserTableStats(config: TableConfig, userId: string): Promise<D
       completed: userCompletedCount
     };
 
-    console.log(`✅ 사용자 ${config.tableName} 최종 통계:`, stats);
     return stats;
   } catch (error) {
     console.error(`❌ 테이블 ${config.tableName} 사용자 통계 조회 중 오류:`, error);
@@ -425,12 +398,10 @@ function hasUserFields(config: TableConfig): boolean {
 // 디버깅 함수: 단순한 테스트
 export async function simpleTest(tableName: string, statusField: string) {
   try {
-    console.log(`\n🧪 ${tableName} 간단한 테스트:`);
     
     // 1. 총 개수
     const totalQuery = `SELECT COUNT(*) as total FROM "${tableName}"`;
     const totalResult = await db.execute(sql.raw(totalQuery));
-    console.log("총 개수:", totalResult.rows[0]);
     
     // 2. 상태 분포
     const statusQuery = `
diff --git a/lib/evaluation-target-list/service.ts b/lib/evaluation-target-list/service.ts
index 0e209aa2..d134b54e 100644
--- a/lib/evaluation-target-list/service.ts
+++ b/lib/evaluation-target-list/service.ts
@@ -774,6 +774,7 @@ export async function confirmEvaluationTargets(
             updatedAt: new Date()
           })
         }
+        console.log("periodicEvaluationsToCreate", periodicEvaluationsToCreate)
       }
       
       // 3. periodicEvaluations 레코드들 일괄 생성
@@ -786,7 +787,7 @@ export async function confirmEvaluationTargets(
         
         createdEvaluationsCount = createdEvaluations.length
       }
-      
+      console.log("createdEvaluationsCount", createdEvaluationsCount)
       // 4. 평가 항목 수 조회 (evaluationSubmissions 생성을 위해)
       const [generalItemsCount, esgItemsCount] = await Promise.all([
         // 활성화된 일반평가 항목 수
@@ -846,6 +847,29 @@ export async function confirmEvaluationTargets(
       // 6. 벤더별 evaluationSubmissions 레코드 생성
       const evaluationSubmissionsToCreate = []
       
+      // 생성된 periodicEvaluations의 ID를 매핑하기 위한 맵 생성
+      const periodicEvaluationIdMap = new Map()
+      if (createdEvaluationsCount > 0) {
+        const createdEvaluations = await tx
+          .select({
+            id: periodicEvaluations.id,
+            evaluationTargetId: periodicEvaluations.evaluationTargetId
+          })
+          .from(periodicEvaluations)
+          .where(
+            and(
+              inArray(periodicEvaluations.evaluationTargetId, confirmedTargetIds),
+              eq(periodicEvaluations.evaluationPeriod, currentPeriod)
+            )
+          )
+        
+                 // evaluationTargetId를 키로 하는 맵 생성
+         createdEvaluations.forEach(periodicEval => {
+           periodicEvaluationIdMap.set(periodicEval.evaluationTargetId, periodicEval.id)
+         })
+      }
+      console.log("periodicEvaluationIdMap", periodicEvaluationIdMap)
+      
       for (const target of eligibleTargets) {
         // 이미 해당 년도/기간에 제출 레코드가 있는지 확인
         const existingSubmission = await tx
@@ -862,22 +886,25 @@ export async function confirmEvaluationTargets(
         
         // 없으면 생성 목록에 추가
         if (existingSubmission.length === 0) {
-          evaluationSubmissionsToCreate.push({
-            companyId: target.vendorId,
-            evaluationYear: target.evaluationYear,
-            evaluationRound: currentPeriod,
-            submissionStatus: "draft" as const,
-            totalGeneralItems: totalGeneralItems,
-            completedGeneralItems: 0,
-            totalEsgItems: totalEsgItems,
-            completedEsgItems: 0,
-            isActive: true,
-            createdAt: new Date(),
-            updatedAt: new Date()
-          })
+          const periodicEvaluationId = periodicEvaluationIdMap.get(target.id)
+          if (periodicEvaluationId) {
+            evaluationSubmissionsToCreate.push({
+              companyId: target.vendorId,
+              periodicEvaluationId: periodicEvaluationId,
+              evaluationYear: target.evaluationYear,
+              evaluationRound: currentPeriod,
+              submissionStatus: "draft" as const,
+              totalGeneralItems: totalGeneralItems,
+              completedGeneralItems: 0,
+              totalEsgItems: totalEsgItems,
+              completedEsgItems: 0,
+              isActive: true,
+              createdAt: new Date(),
+              updatedAt: new Date()
+            })
+          }
         }
       }
-      
       // 7. evaluationSubmissions 레코드들 일괄 생성
       let createdSubmissionsCount = 0
       if (evaluationSubmissionsToCreate.length > 0) {
diff --git a/lib/evaluation/service.ts b/lib/evaluation/service.ts
index 67a692ab..bbe9daa9 100644
--- a/lib/evaluation/service.ts
+++ b/lib/evaluation/service.ts
@@ -28,7 +28,8 @@ import { GetEvaluationTargetsSchema } from "../evaluation-target-list/validation
 import { sendEmail } from "../mail/sendEmail"
 import { revalidatePath } from "next/cache"
 import { DEPARTMENT_CODE_LABELS } from "@/types/evaluation"
-
+import { getServerSession } from "next-auth"
+import { authOptions } from "@/app/api/auth/[...nextauth]/route"
 export async function getPeriodicEvaluations(input: GetEvaluationTargetsSchema) {
   try {
 
@@ -756,8 +757,8 @@ export async function finalizeEvaluations(
 ) {
   try {
     // 현재 사용자 정보 가져오기
-    const currentUser = await getCurrentUser()
-    if (!currentUser) {
+    const session = await getServerSession(authOptions)
+    if (!session?.user) {
       throw new Error("인증이 필요합니다")
     }
 
@@ -795,7 +796,7 @@ export async function finalizeEvaluations(
             finalGrade: evaluation.finalGrade,
             status: "FINALIZED",
             finalizedAt: now,
-            finalizedBy: currentUser.id,
+            finalizedBy: session?.user?.id ? Number(session.user.id) : null,
             updatedAt: now,
           })
           .where(eq(periodicEvaluations.id, evaluation.id))
@@ -824,8 +825,8 @@ export async function finalizeEvaluations(
  */
 export async function unfinalizeEvaluations(evaluationIds: number[]) {
   try {
-    const currentUser = await getCurrentUser()
-    if (!currentUser) {
+    const session = await getServerSession(authOptions)
+    if (!session?.user) {
       throw new Error("인증이 필요합니다")
     }
 
diff --git a/lib/login-session/table/login-sessions-table-columns.tsx b/lib/login-session/table/login-sessions-table-columns.tsx
index e3d8bc2f..5d2389be 100644
--- a/lib/login-session/table/login-sessions-table-columns.tsx
+++ b/lib/login-session/table/login-sessions-table-columns.tsx
@@ -193,51 +193,51 @@ export function getColumns({ setRowAction }: GetColumnsProps): ColumnDef<Extende
         },
       ],
     },
-    {
-      id: "actions",
-      cell: function Cell({ row }) {
-        const session = row.original
+    // {
+    //   id: "actions",
+    //   cell: function Cell({ row }) {
+    //     const session = row.original
 
-        return (
-          <DropdownMenu>
-            <DropdownMenuTrigger asChild>
-              <Button
-                aria-label="Open menu"
-                variant="ghost"
-                className="flex size-8 p-0 data-[state=open]:bg-muted"
-              >
-                <Ellipsis className="size-4" aria-hidden="true" />
-              </Button>
-            </DropdownMenuTrigger>
-            <DropdownMenuContent align="end" className="w-40">
-              <DropdownMenuItem
-                onSelect={() => setRowAction({ type: "view", row })}
-              >
-                <Eye className="mr-2 size-4" aria-hidden="true" />
-                상세 보기
-              </DropdownMenuItem>
-              <DropdownMenuItem
-                onSelect={() => setRowAction({ type: "viewSecurity", row })}
-              >
-                <Shield className="mr-2 size-4" aria-hidden="true" />
-                보안 정보
-              </DropdownMenuItem>
-              {session.isCurrentlyActive && (
-                <DropdownMenuItem
-                  onSelect={() => setRowAction({ type: "forceLogout", row })}
-                  className="text-red-600"
-                >
-                  <LogOut className="mr-2 size-4" aria-hidden="true" />
-                  강제 로그아웃
-                  <DropdownMenuShortcut>⌘⌫</DropdownMenuShortcut>
-                </DropdownMenuItem>
-              )}
-            </DropdownMenuContent>
-          </DropdownMenu>
-        )
-      },
-      enableSorting: false,
-      enableHiding: false,
-    },
+    //     return (
+    //       <DropdownMenu>
+    //         <DropdownMenuTrigger asChild>
+    //           <Button
+    //             aria-label="Open menu"
+    //             variant="ghost"
+    //             className="flex size-8 p-0 data-[state=open]:bg-muted"
+    //           >
+    //             <Ellipsis className="size-4" aria-hidden="true" />
+    //           </Button>
+    //         </DropdownMenuTrigger>
+    //         <DropdownMenuContent align="end" className="w-40">
+    //           <DropdownMenuItem
+    //             onSelect={() => setRowAction({ type: "view", row })}
+    //           >
+    //             <Eye className="mr-2 size-4" aria-hidden="true" />
+    //             상세 보기
+    //           </DropdownMenuItem>
+    //           <DropdownMenuItem
+    //             onSelect={() => setRowAction({ type: "viewSecurity", row })}
+    //           >
+    //             <Shield className="mr-2 size-4" aria-hidden="true" />
+    //             보안 정보
+    //           </DropdownMenuItem>
+    //           {session.isCurrentlyActive && (
+    //             <DropdownMenuItem
+    //               onSelect={() => setRowAction({ type: "forceLogout", row })}
+    //               className="text-red-600"
+    //             >
+    //               <LogOut className="mr-2 size-4" aria-hidden="true" />
+    //               강제 로그아웃
+    //               <DropdownMenuShortcut>⌘⌫</DropdownMenuShortcut>
+    //             </DropdownMenuItem>
+    //           )}
+    //         </DropdownMenuContent>
+    //       </DropdownMenu>
+    //     )
+    //   },
+    //   enableSorting: false,
+    //   enableHiding: false,
+    // },
   ]
 }
\ No newline at end of file
diff --git a/lib/login-session/table/login-sessions-table-toolbar-actions.tsx b/lib/login-session/table/login-sessions-table-toolbar-actions.tsx
index 36665bc0..2c8781a3 100644
--- a/lib/login-session/table/login-sessions-table-toolbar-actions.tsx
+++ b/lib/login-session/table/login-sessions-table-toolbar-actions.tsx
@@ -8,6 +8,8 @@ import { Tooltip, TooltipContent, TooltipTrigger } from "@/components/ui/tooltip
 
 import { ExtendedLoginSession } from "../validation"
 import { exportTableToExcel } from "@/lib/export_all"
+import { useTransition } from "react"
+import { useRouter } from "next/navigation"
 
 interface LoginSessionsTableToolbarActionsProps {
   table: Table<ExtendedLoginSession>
@@ -16,6 +18,15 @@ interface LoginSessionsTableToolbarActionsProps {
 export function LoginSessionsTableToolbarActions({
   table,
 }: LoginSessionsTableToolbarActionsProps) {
+
+  const router = useRouter()
+  const [isPending, startTransition] = useTransition()
+
+  const handleRefresh = () => {
+    startTransition(() => {
+      router.refresh() // ✅ 서버 컴포넌트만 새로고침 (더 빠르고 부드러움)
+    })
+  }
   return (
     <div className="flex items-center gap-2">
       <Tooltip>
@@ -44,18 +55,23 @@ export function LoginSessionsTableToolbarActions({
           <Button
             variant="outline"
             size="sm"
-            onClick={() => window.location.reload()}
+            onClick={handleRefresh}
+            disabled={isPending} // 로딩 중 비활성화
           >
-            <RotateCcw className="mr-2 size-4" aria-hidden="true" />
-            새로고침
+            <RotateCcw 
+              className={`mr-2 size-4 ${isPending ? 'animate-spin' : ''}`} 
+              aria-hidden="true" 
+            />
+            {isPending ? '새로고침 중...' : '새로고침'}
           </Button>
         </TooltipTrigger>
         <TooltipContent>
           <p>데이터 새로고침</p>
         </TooltipContent>
       </Tooltip>
+      
 
-      <Tooltip>
+      {/* <Tooltip>
         <TooltipTrigger asChild>
           <Button
             variant="outline"
@@ -72,7 +88,7 @@ export function LoginSessionsTableToolbarActions({
         <TooltipContent>
           <p>보안 분석 리포트 생성</p>
         </TooltipContent>
-      </Tooltip>
+      </Tooltip> */}
     </div>
   )
 }
\ No newline at end of file
diff --git a/lib/login-session/table/login-sessions-table.tsx b/lib/login-session/table/login-sessions-table.tsx
index 43568f41..c81efc37 100644
--- a/lib/login-session/table/login-sessions-table.tsx
+++ b/lib/login-session/table/login-sessions-table.tsx
@@ -10,7 +10,6 @@ import type {
 import { useDataTable } from "@/hooks/use-data-table"
 import { DataTable } from "@/components/data-table/data-table"
 import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
-import { useFeatureFlags } from "@/components/data-table/feature-flags-provider"
 
 import { getLoginSessions } from "../service"
 import { LoginSessionsTableToolbarActions } from "./login-sessions-table-toolbar-actions"
@@ -26,8 +25,6 @@ interface LoginSessionsTableProps {
 }
 
 export function LoginSessionsTable({ promises }: LoginSessionsTableProps) {
-  const { featureFlags } = useFeatureFlags()
-
   const [{ data, pageCount }] = React.use(promises)
 
   const [rowAction, setRowAction] =
diff --git a/lib/page-visits/service.ts b/lib/page-visits/service.ts
new file mode 100644
index 00000000..66c57eaa
--- /dev/null
+++ b/lib/page-visits/service.ts
@@ -0,0 +1,169 @@
+import db from "@/db/db"
+import { loginSessions, pageVisits, users } from "@/db/schema"
+import { and, or, ilike, eq, desc, asc, count, sql, isNull } from "drizzle-orm"
+import { filterColumns } from "@/lib/filter-columns";
+import type { GetPageVisitsSchema, ExtendedPageVisit } from "./validation"
+
+export async function getPageVisits(input: GetPageVisitsSchema) {
+  try {
+    const offset = (input.page - 1) * input.perPage;
+    const advancedTable = true;
+
+    // 고급 필터 처리
+    const advancedWhere = filterColumns({
+      table: pageVisits,
+      filters: input.filters,
+      joinOperator: input.joinOperator,
+    });
+
+    // 전역 검색
+    let globalWhere;
+    if (input.search) {
+      const s = `%${input.search}%`;
+      globalWhere = or(
+        ilike(pageVisits.route, s),
+        ilike(pageVisits.pageTitle, s),
+        ilike(pageVisits.referrer, s),
+        ilike(pageVisits.deviceType, s),
+        ilike(pageVisits.browserName, s),
+        ilike(pageVisits.osName, s),
+        ilike(users.email, s),
+        ilike(users.name, s)
+      );
+    }
+
+    // 조건 결합
+    const conditions = [];
+    if (advancedWhere) conditions.push(advancedWhere);
+    if (globalWhere) conditions.push(globalWhere);
+
+    let finalWhere;
+    if (conditions.length > 0) {
+      finalWhere = conditions.length > 1 ? and(...conditions) : conditions[0];
+    }
+
+    // 정렬 처리
+    const orderBy =
+      input.sort.length > 0
+        ? input.sort.map((item) => {
+            // 사용자 관련 필드 정렬
+            if (item.id === 'userEmail') {
+              return item.desc ? desc(users.email) : asc(users.email);
+            } else if (item.id === 'userName') {
+              return item.desc ? desc(users.name) : asc(users.name);
+            } else {
+              // 페이지 방문 필드 정렬
+              return item.desc
+                ? desc(pageVisits[item.id as keyof typeof pageVisits.$inferSelect])
+                : asc(pageVisits[item.id as keyof typeof pageVisits.$inferSelect]);
+            }
+          })
+        : [desc(pageVisits.visitedAt)];
+
+    // 데이터 조회
+    const data = await db
+      .select({
+        id: pageVisits.id,
+        userId: pageVisits.userId,
+        sessionId: pageVisits.sessionId,
+        route: pageVisits.route,
+        pageTitle: pageVisits.pageTitle,
+        referrer: pageVisits.referrer,
+        ipAddress: pageVisits.ipAddress,
+        userAgent: pageVisits.userAgent,
+        visitedAt: pageVisits.visitedAt,
+        duration: pageVisits.duration,
+        queryParams: pageVisits.queryParams,
+        deviceType: pageVisits.deviceType,
+        browserName: pageVisits.browserName,
+        osName: pageVisits.osName,
+        userEmail: users.email,
+        userName: users.name,
+        // 지속 시간 포맷팅
+        durationFormatted: sql<string>`
+          CASE 
+            WHEN ${pageVisits.duration} IS NULL THEN NULL
+            WHEN ${pageVisits.duration} < 60 THEN CONCAT(${pageVisits.duration}, '초')
+            WHEN ${pageVisits.duration} < 3600 THEN CONCAT(FLOOR(${pageVisits.duration} / 60), '분 ', ${pageVisits.duration} % 60, '초')
+            ELSE CONCAT(FLOOR(${pageVisits.duration} / 3600), '시간 ', FLOOR((${pageVisits.duration} % 3600) / 60), '분')
+          END
+        `,
+        // 장기 체류 여부 (5분 이상)
+        isLongVisit: sql<boolean>`${pageVisits.duration} >= 300`
+      })
+      .from(pageVisits)
+      .leftJoin(users, eq(pageVisits.userId, users.id))
+      .where(finalWhere)
+      .orderBy(...orderBy)
+      .limit(input.perPage)
+      .offset(offset);
+
+    // 총 개수 조회
+    const totalResult = await db
+      .select({ count: count() })
+      .from(pageVisits)
+      .leftJoin(users, eq(pageVisits.userId, users.id))
+      .where(finalWhere);
+
+    const total = totalResult[0]?.count || 0;
+    const pageCount = Math.ceil(total / input.perPage);
+
+    return { data: data as ExtendedPageVisit[], pageCount };
+  } catch (err) {
+    console.error("Failed to fetch page visits:", err);
+    return { data: [], pageCount: 0 };
+  }
+}
+
+
+export async function getUserActivitySummary(userId: string, startDate: Date, endDate: Date) {
+  try {
+    // 페이지 방문 통계
+    const pageStats = await db
+      .select({
+        route: pageVisits.route,
+        visitCount: count(),
+        totalDuration: sql<number>`SUM(${pageVisits.duration})`,
+        avgDuration: sql<number>`AVG(${pageVisits.duration})`,
+      })
+      .from(pageVisits)
+      .where(
+        and(
+          eq(pageVisits.userId, userId),
+          between(pageVisits.visitedAt, startDate, endDate)
+        )
+      )
+      .groupBy(pageVisits.route)
+      .orderBy(desc(count()));
+
+    // 세션 통계
+    const sessionStats = await db
+      .select({
+        sessionCount: count(),
+        totalSessionTime: sql<number>`
+          SUM(EXTRACT(EPOCH FROM (
+            COALESCE(${loginSessions.logoutAt}, ${loginSessions.lastActivityAt}) 
+            - ${loginSessions.loginAt}
+          )) / 60)
+        `,
+      })
+      .from(loginSessions)
+      .where(
+        and(
+          eq(loginSessions.userId, userId),
+          between(loginSessions.loginAt, startDate, endDate)
+        )
+      );
+
+    return {
+      pageStats,
+      sessionStats: sessionStats[0] || { sessionCount: 0, totalSessionTime: 0 },
+    };
+  } catch (error) {
+    console.error("Failed to get user activity summary:", error);
+    return {
+      pageStats: [],
+      sessionStats: { sessionCount: 0, totalSessionTime: 0 },
+    };
+  }
+}
\ No newline at end of file
diff --git a/lib/page-visits/table/page-visits-table-columns.tsx b/lib/page-visits/table/page-visits-table-columns.tsx
new file mode 100644
index 00000000..e1d2fed4
--- /dev/null
+++ b/lib/page-visits/table/page-visits-table-columns.tsx
@@ -0,0 +1,309 @@
+"use client"
+
+import * as React from "react"
+import { type DataTableRowAction } from "@/types/table"
+import { type ColumnDef } from "@tanstack/react-table"
+import { Badge } from "@/components/ui/badge"
+import { Button } from "@/components/ui/button"
+import { Checkbox } from "@/components/ui/checkbox"
+import {
+  DropdownMenu,
+  DropdownMenuContent,
+  DropdownMenuItem,
+  DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+import { Tooltip, TooltipContent, TooltipTrigger } from "@/components/ui/tooltip"
+
+import { formatDate } from "@/lib/utils"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+import { ExtendedPageVisit } from "../validation"
+import { Eye, ExternalLink, Clock, User, Ellipsis } from "lucide-react"
+
+interface GetColumnsProps {
+  setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<ExtendedPageVisit> | null>>
+}
+
+export function getColumns({ setRowAction }: GetColumnsProps): ColumnDef<ExtendedPageVisit>[] {
+  return [
+    {
+      id: "select",
+      header: ({ table }) => (
+        <Checkbox
+          checked={
+            table.getIsAllPageRowsSelected() ||
+            (table.getIsSomePageRowsSelected() && "indeterminate")
+          }
+          onCheckedChange={(value) => table.toggleAllPageRowsSelected(!!value)}
+          aria-label="Select all"
+          className="translate-y-0.5"
+        />
+      ),
+      cell: ({ row }) => (
+        <Checkbox
+          checked={row.getIsSelected()}
+          onCheckedChange={(value) => row.toggleSelected(!!value)}
+          aria-label="Select row"
+          className="translate-y-0.5"
+        />
+      ),
+      enableSorting: false,
+      enableHiding: false,
+    },
+    {
+      id: "사용자",
+      header: "사용자",
+      columns: [
+        {
+          accessorKey: "userEmail",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="사용자" />
+          ),
+          cell: ({ row }) => {
+            const userEmail = row.getValue("userEmail") as string | null
+            const userName = row.original.userName
+            
+            if (!userEmail) {
+              return (
+                <div className="flex items-center gap-2">
+                  <User className="size-3 text-muted-foreground" />
+                  <span className="text-muted-foreground text-xs">익명</span>
+                </div>
+              )
+            }
+            
+            return (
+              <div className="flex flex-col">
+                <span className="font-medium text-sm">{userEmail}</span>
+                {userName && (
+                  <span className="text-xs text-muted-foreground">{userName}</span>
+                )}
+              </div>
+            )
+          },
+        },
+      ],
+    },
+    {
+      id: "페이지 정보",
+      header: "페이지 정보",
+      columns: [
+        {
+          accessorKey: "route",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="경로" />
+          ),
+          cell: ({ row }) => {
+            const route = row.getValue("route") as string
+            const pageTitle = row.original.pageTitle
+            
+            return (
+              <div className="flex flex-col max-w-[200px]">
+                <code className="text-xs bg-muted px-1 py-0.5 rounded font-mono">
+                  {route}
+                </code>
+                {pageTitle && (
+                  <span className="text-xs text-muted-foreground mt-1 truncate">
+                    {pageTitle}
+                  </span>
+                )}
+              </div>
+            )
+          },
+        },
+        {
+          accessorKey: "visitedAt",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="방문 시간" />
+          ),
+          cell: ({ row }) => {
+            const date = row.getValue("visitedAt") as Date
+            return (
+              <Tooltip>
+                <TooltipTrigger>
+                  <div className="text-sm">
+                    {formatDate(date, 'KR')}
+                  </div>
+                </TooltipTrigger>
+                <TooltipContent>
+                  {formatDate(date)}
+                </TooltipContent>
+              </Tooltip>
+            )
+          },
+        },
+        {
+          accessorKey: "duration",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="체류 시간" />
+          ),
+          cell: ({ row }) => {
+            const duration = row.getValue("duration") as number | null
+            const isLongVisit = row.original.isLongVisit
+            
+            if (!duration) {
+              return <span className="text-muted-foreground">-</span>
+            }
+            
+            const minutes = Math.floor(duration / 60)
+            const seconds = duration % 60
+            
+            let displayText = ""
+            if (minutes > 0) {
+              displayText = `${minutes}분 ${seconds}초`
+            } else {
+              displayText = `${seconds}초`
+            }
+            
+            return (
+              <div className="flex items-center gap-2">
+                {isLongVisit && <Clock className="size-3 text-orange-500" />}
+                <span className={isLongVisit ? "font-medium" : ""}>
+                  {displayText}
+                </span>
+              </div>
+            )
+          },
+        },
+      ],
+    },
+    {
+      id: "환경 정보",
+      header: "환경 정보",
+      columns: [
+        {
+          accessorKey: "deviceType",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="디바이스" />
+          ),
+          cell: ({ row }) => {
+            const deviceType = row.getValue("deviceType") as string
+            const variants = {
+              desktop: "default",
+              mobile: "secondary",
+              tablet: "outline",
+            } as const
+            
+            return (
+              <Badge variant={variants[deviceType as keyof typeof variants] || "default"} className="text-xs">
+                {deviceType}
+              </Badge>
+            )
+          },
+        },
+        {
+          accessorKey: "browserName",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="브라우저" />
+          ),
+          cell: ({ row }) => {
+            const browserName = row.getValue("browserName") as string | null
+            const osName = row.original.osName
+            
+            return (
+              <div className="flex flex-col">
+                <span className="text-sm">{browserName || "Unknown"}</span>
+                {osName && (
+                  <span className="text-xs text-muted-foreground">{osName}</span>
+                )}
+              </div>
+            )
+          },
+        },
+        {
+          accessorKey: "ipAddress",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="IP" />
+          ),
+          cell: ({ row }) => (
+            <code className="text-xs bg-muted px-2 py-1 rounded">
+              {row.getValue("ipAddress")}
+            </code>
+          ),
+        },
+      ],
+    },
+    {
+      id: "추가 정보",
+      header: "추가 정보",
+      columns: [
+        {
+          accessorKey: "referrer",
+          header: ({ column }) => (
+            <DataTableColumnHeaderSimple column={column} title="리퍼러" />
+          ),
+          cell: ({ row }) => {
+            const referrer = row.getValue("referrer") as string | null
+            
+            if (!referrer) {
+              return <span className="text-muted-foreground text-xs">직접 접근</span>
+            }
+            
+            try {
+              const url = new URL(referrer)
+              return (
+                <div className="flex items-center gap-1">
+                  <ExternalLink className="size-3" />
+                  <span className="text-xs truncate max-w-[100px]">
+                    {url.hostname}
+                  </span>
+                </div>
+              )
+            } catch {
+              return (
+                <span className="text-xs truncate max-w-[100px]">
+                  {referrer}
+                </span>
+              )
+            }
+          },
+        },
+      ],
+    },
+    // {
+    //   id: "actions",
+    //   cell: function Cell({ row }) {
+    //     const visit = row.original
+
+    //     return (
+    //       <DropdownMenu>
+    //         <DropdownMenuTrigger asChild>
+    //           <Button
+    //             aria-label="Open menu"
+    //             variant="ghost"
+    //             className="flex size-8 p-0 data-[state=open]:bg-muted"
+    //           >
+    //             <Ellipsis className="size-4" aria-hidden="true" />
+    //           </Button>
+    //         </DropdownMenuTrigger>
+    //         <DropdownMenuContent align="end" className="w-40">
+    //           <DropdownMenuItem
+    //             onSelect={() => setRowAction({ type: "view", row })}
+    //           >
+    //             <Eye className="mr-2 size-4" aria-hidden="true" />
+    //             상세 보기
+    //           </DropdownMenuItem>
+    //           {visit.userEmail && (
+    //             <DropdownMenuItem
+    //               onSelect={() => setRowAction({ type: "viewUserActivity", row })}
+    //             >
+    //               <User className="mr-2 size-4" aria-hidden="true" />
+    //               사용자 활동
+    //             </DropdownMenuItem>
+    //           )}
+    //           {visit.route && (
+    //             <DropdownMenuItem
+    //               onSelect={() => setRowAction({ type: "viewPageStats", row })}
+    //             >
+    //               <ExternalLink className="mr-2 size-4" aria-hidden="true" />
+    //               페이지 통계
+    //             </DropdownMenuItem>
+    //           )}
+    //         </DropdownMenuContent>
+    //       </DropdownMenu>
+    //     )
+    //   },
+    //   enableSorting: false,
+    //   enableHiding: false,
+    // },
+  ]
+}
\ No newline at end of file
diff --git a/lib/page-visits/table/page-visits-table-toolbar-actions.tsx b/lib/page-visits/table/page-visits-table-toolbar-actions.tsx
new file mode 100644
index 00000000..5a74a765
--- /dev/null
+++ b/lib/page-visits/table/page-visits-table-toolbar-actions.tsx
@@ -0,0 +1,112 @@
+"use client"
+
+import { type Table } from "@tanstack/react-table"
+import { Download, RotateCcw, BarChart3, Filter } from "lucide-react"
+import { useRouter } from "next/navigation"
+import { useTransition } from "react"
+
+import { Button } from "@/components/ui/button"
+import { Tooltip, TooltipContent, TooltipTrigger } from "@/components/ui/tooltip"
+
+import { ExtendedPageVisit } from "../validation"
+import { exportTableToExcel } from "@/lib/export_all"
+
+interface PageVisitsTableToolbarActionsProps {
+  table: Table<ExtendedPageVisit>
+}
+
+export function PageVisitsTableToolbarActions({
+  table,
+}: PageVisitsTableToolbarActionsProps) {
+  const router = useRouter()
+  const [isPending, startTransition] = useTransition()
+
+  const handleRefresh = () => {
+    startTransition(() => {
+      router.refresh() // ✅ 서버 컴포넌트만 새로고침 (더 빠르고 부드러움)
+    })
+  }
+
+  return (
+    <div className="flex items-center gap-2">
+      <Tooltip>
+        <TooltipTrigger asChild>
+          <Button
+            variant="outline"
+            size="sm"
+            onClick={() =>
+              exportTableToExcel(table, {
+                filename: "page-visits",
+                excludeColumns: ["select", "actions"],
+              })
+            }
+          >
+            <Download className="mr-2 size-4" aria-hidden="true" />
+            Export
+          </Button>
+        </TooltipTrigger>
+        <TooltipContent>
+          <p>페이지 방문 데이터를 엑셀로 내보내기</p>
+        </TooltipContent>
+      </Tooltip>
+
+      <Tooltip>
+        <TooltipTrigger asChild>
+          <Button
+            variant="outline"
+            size="sm"
+            onClick={handleRefresh}
+            disabled={isPending} // 로딩 중 비활성화
+          >
+            <RotateCcw 
+              className={`mr-2 size-4 ${isPending ? 'animate-spin' : ''}`} 
+              aria-hidden="true" 
+            />
+            {isPending ? '새로고침 중...' : '새로고침'}
+          </Button>
+        </TooltipTrigger>
+        <TooltipContent>
+          <p>데이터 새로고침</p>
+        </TooltipContent>
+      </Tooltip>
+
+      <Tooltip>
+        <TooltipTrigger asChild>
+          <Button
+            variant="outline"
+            size="sm"
+            onClick={() => {
+              // 페이지 통계 분석 기능
+              console.log("Generate page analytics")
+            }}
+          >
+            <BarChart3 className="mr-2 size-4" aria-hidden="true" />
+            페이지 분석
+          </Button>
+        </TooltipTrigger>
+        <TooltipContent>
+          <p>페이지별 방문 통계 분석</p>
+        </TooltipContent>
+      </Tooltip>
+
+      <Tooltip>
+        <TooltipTrigger asChild>
+          <Button
+            variant="outline"
+            size="sm"
+            onClick={() => {
+              // 고급 필터링 옵션
+              console.log("Advanced filtering options")
+            }}
+          >
+            <Filter className="mr-2 size-4" aria-hidden="true" />
+            고급 필터
+          </Button>
+        </TooltipTrigger>
+        <TooltipContent>
+          <p>고급 필터링 옵션</p>
+        </TooltipContent>
+      </Tooltip>
+    </div>
+  )
+}
diff --git a/lib/page-visits/table/page-visits-table.tsx b/lib/page-visits/table/page-visits-table.tsx
new file mode 100644
index 00000000..914b8180
--- /dev/null
+++ b/lib/page-visits/table/page-visits-table.tsx
@@ -0,0 +1,146 @@
+"use client"
+
+import * as React from "react"
+import type {
+  DataTableAdvancedFilterField,
+  DataTableFilterField,
+  DataTableRowAction,
+} from "@/types/table"
+
+import { useDataTable } from "@/hooks/use-data-table"
+import { DataTable } from "@/components/data-table/data-table"
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
+
+import { getPageVisits } from "../service"
+import { PageVisitsTableToolbarActions } from "./page-visits-table-toolbar-actions"
+import { getColumns } from "./page-visits-table-columns"
+import { ExtendedPageVisit } from "../validation"
+
+interface PageVisitsTableProps {
+  promises: Promise<
+    [
+      Awaited<ReturnType<typeof getPageVisits>>,
+    ]
+  >
+}
+
+export function PageVisitsTable({ promises }: PageVisitsTableProps) {
+
+  const [{ data, pageCount }] = React.use(promises)
+
+  const [rowAction, setRowAction] =
+    React.useState<DataTableRowAction<ExtendedPageVisit> | null>(null)
+
+  const columns = React.useMemo(
+    () => getColumns({ setRowAction }),
+    [setRowAction]
+  )
+
+  // 기본 필터 필드
+  const filterFields: DataTableFilterField<ExtendedPageVisit>[] = [
+    {
+      id: "deviceType",
+      label: "디바이스",
+      options: [
+        { label: "Desktop", value: "desktop" },
+        { label: "Mobile", value: "mobile" },
+        { label: "Tablet", value: "tablet" },
+      ],
+    },
+    {
+      id: "browserName",
+      label: "브라우저",
+      options: [
+        { label: "Chrome", value: "Chrome" },
+        { label: "Firefox", value: "Firefox" },
+        { label: "Safari", value: "Safari" },
+        { label: "Edge", value: "Edge" },
+      ],
+    },
+  ]
+
+  // 고급 필터 필드
+  const advancedFilterFields: DataTableAdvancedFilterField<ExtendedPageVisit>[] = [
+    {
+      id: "userEmail",
+      label: "사용자 이메일",
+      type: "text",
+    },
+    {
+      id: "route",
+      label: "페이지 경로",
+      type: "text",
+    },
+    {
+      id: "pageTitle",
+      label: "페이지 제목",
+      type: "text",
+    },
+    {
+      id: "deviceType",
+      label: "디바이스 타입",
+      type: "multi-select",
+      options: [
+        { label: "Desktop", value: "desktop" },
+        { label: "Mobile", value: "mobile" },
+        { label: "Tablet", value: "tablet" },
+      ],
+    },
+    {
+      id: "browserName",
+      label: "브라우저",
+      type: "multi-select",
+      options: [
+        { label: "Chrome", value: "Chrome" },
+        { label: "Firefox", value: "Firefox" },
+        { label: "Safari", value: "Safari" },
+        { label: "Edge", value: "Edge" },
+      ],
+    },
+    {
+      id: "duration",
+      label: "체류 시간 (초)",
+      type: "number",
+    },
+    {
+      id: "visitedAt",
+      label: "방문 시간",
+      type: "date",
+    },
+    {
+      id: "ipAddress",
+      label: "IP 주소",
+      type: "text",
+    },
+  ]
+
+  const { table } = useDataTable({
+    data,
+    columns,
+    pageCount,
+    filterFields,
+    enablePinning: true,
+    enableAdvancedFilter: true,
+    initialState: {
+      sorting: [{ id: "visitedAt", desc: true }],
+      columnPinning: { right: ["actions"] },
+    },
+    getRowId: (originalRow) => String(originalRow.id),
+    shallow: false,
+    clearOnDefault: true,
+  })
+
+  return (
+    <>
+      <DataTable table={table}>
+        <DataTableAdvancedToolbar
+          table={table}
+          filterFields={advancedFilterFields}
+          shallow={false}
+        >
+          <PageVisitsTableToolbarActions table={table} />
+        </DataTableAdvancedToolbar>
+      </DataTable>
+    </>
+  )
+}
\ No newline at end of file
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
diff --git a/lib/tech-vendors/table/tech-vendors-table-columns.tsx b/lib/tech-vendors/table/tech-vendors-table-columns.tsx
index 438fceac..f690d266 100644
--- a/lib/tech-vendors/table/tech-vendors-table-columns.tsx
+++ b/lib/tech-vendors/table/tech-vendors-table-columns.tsx
@@ -268,7 +268,54 @@ export function getColumns({ setRowAction, router, openItemsDialog }: GetColumns
             </div>
           );
         }
-         
+        // TechVendorType 컬럼을 badge로 표시
+        // if (cfg.id === "techVendorType") {
+        //   const techVendorType = row.original.techVendorType as string;
+          
+        //   // 벤더 타입 파싱 개선
+        //   let types: string[] = [];
+        //   if (!techVendorType) {
+        //     types = [];
+        //   } else if (techVendorType.startsWith('[') && techVendorType.endsWith(']')) {
+        //     // JSON 배열 형태
+        //     try {
+        //       const parsed = JSON.parse(techVendorType);
+        //       types = Array.isArray(parsed) ? parsed.filter(Boolean) : [techVendorType];
+        //     } catch {
+        //       types = [techVendorType];
+        //     }
+        //   } else if (techVendorType.includes(',')) {
+        //     // 콤마로 구분된 문자열
+        //     types = techVendorType.split(',').map(t => t.trim()).filter(Boolean);
+        //   } else {
+        //     // 단일 문자열
+        //     types = [techVendorType.trim()].filter(Boolean);
+        //   }
+        // // 벤더 타입 정렬 - 조선 > 해양top > 해양hull 순
+        // const typeOrder = ["조선", "해양top", "해양hull"];
+        // types.sort((a, b) => {
+        //   const indexA = typeOrder.indexOf(a);
+        //   const indexB = typeOrder.indexOf(b);
+          
+        //   // 정의된 순서에 있는 경우 우선순위 적용
+        //   if (indexA !== -1 && indexB !== -1) {
+        //     return indexA - indexB;
+        //   }
+        //   return a.localeCompare(b);
+        // });
+        //   return (
+        //     <div className="flex flex-wrap gap-1">
+        //       {types.length > 0 ? types.map((type, index) => (
+        //         <Badge key={`${type}-${index}`} variant="secondary" className="text-xs">
+        //           {type}
+        //         </Badge>
+        //       )) : (
+        //         <span className="text-muted-foreground">-</span>
+        //       )}
+        //     </div>
+        //   );
+        // }
+
         // 날짜 컬럼 포맷팅
         if (cfg.type === "date" && cell.getValue()) {
           return formatDate(cell.getValue() as Date);
diff --git a/lib/users/auth/verifyCredentails.ts b/lib/users/auth/verifyCredentails.ts
index ff3cd0e3..42e6dac3 100644
--- a/lib/users/auth/verifyCredentails.ts
+++ b/lib/users/auth/verifyCredentails.ts
@@ -29,7 +29,7 @@ export type AuthError =
 export interface AuthResult {
   success: boolean;
   user?: {
-    id: string;
+    id: number;
     name: string;
     email: string;
     imageUrl?: string | null;
@@ -370,7 +370,7 @@ export async function verifyExternalCredentials(
     return {
       success: true,
       user: {
-        id: user.id.toString(),
+        id: user.id,
         name: user.name,
         email: user.email,
         imageUrl: user.imageUrl,
@@ -541,7 +541,7 @@ export async function authenticateWithSGips(
 ): Promise<{
   success: boolean;
   user?: {
-    id: string;
+    id: number;
     name: string;
     email: string;
     imageUrl?: string | null;
@@ -594,7 +594,7 @@ export async function authenticateWithSGips(
     return {
       success: true,
       user: {
-        id: user.id.toString(),
+        id: user.id,
         name: user.name,
         email: user.email,
         imageUrl: user.imageUrl,
diff --git a/lib/users/session/repository.ts b/lib/users/session/repository.ts
index a3b44fbf..be7a0b2b 100644
--- a/lib/users/session/repository.ts
+++ b/lib/users/session/repository.ts
@@ -206,7 +206,7 @@ export class SessionRepository {
     }
   }
 
-  static async logoutAllUserSessions(userId: string) {
+  static async logoutAllUserSessions(userId: number) {
     try {
       await db
         .update(loginSessions)
diff --git a/lib/vendor-evaluation-submit/service.ts b/lib/vendor-evaluation-submit/service.ts
index 63a6bdb6..7be18fb8 100644
--- a/lib/vendor-evaluation-submit/service.ts
+++ b/lib/vendor-evaluation-submit/service.ts
@@ -340,9 +340,9 @@ export async function getEvaluationSubmissionCompleteness(submissionId: number)
         ) : Promise.resolve([{ total: 0, completed: 0, averageScore: null }])
     ]);
 
-    // 실제 완료된 항목 수
-    const generalCompleted = generalStats[0]?.completed || 0;
-    const esgCompleted = esgStats[0]?.completed || 0;
+    // 실제 완료된 항목 수 (숫자로 변환 0707 최겸 수정)
+    const generalCompleted = Number(generalStats[0]?.completed || 0);
+    const esgCompleted = Number(esgStats[0]?.completed || 0);
     const esgAverage = parseFloat(esgStats[0]?.averageScore?.toString() || '0');
 
     // 🎯 실제 평가 항목 수를 기준으로 완성도 계산