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/dashboard/service.ts | 29 -----------------------------
 1 file changed, 29 deletions(-)

(limited to 'lib/dashboard')

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