summaryrefslogtreecommitdiff
path: root/lib/dashboard
diff options
context:
space:
mode:
Diffstat (limited to 'lib/dashboard')
-rw-r--r--lib/dashboard/service.ts29
1 files changed, 0 insertions, 29 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 = `