summaryrefslogtreecommitdiff
path: root/lib/dashboard/partners-service.ts
diff options
context:
space:
mode:
Diffstat (limited to 'lib/dashboard/partners-service.ts')
-rw-r--r--lib/dashboard/partners-service.ts28
1 files changed, 1 insertions, 27 deletions
diff --git a/lib/dashboard/partners-service.ts b/lib/dashboard/partners-service.ts
index 327a16a9..ac8ca920 100644
--- a/lib/dashboard/partners-service.ts
+++ b/lib/dashboard/partners-service.ts
@@ -73,7 +73,6 @@ export async function getPartnersTeamDashboardData(domain: string): Promise<Part
}
});
- console.log('πŸ“Š νŒŒνŠΈλ„ˆ νŒ€ λŒ€μ‹œλ³΄λ“œ κ²°κ³Ό:', successfulResults);
return successfulResults;
} catch (error) {
console.error("νŒŒνŠΈλ„ˆ νŒ€ λŒ€μ‹œλ³΄λ“œ 데이터 쑰회 μ‹€νŒ¨:", error);
@@ -98,7 +97,6 @@ export async function getPartnersUserDashboardData(domain: string): Promise<Part
return [];
}
- console.log(`πŸ‘€ μ‚¬μš©μž ID: ${userId}, νšŒμ‚¬ ID: ${companyId}`);
// 병렬 처리둜 μ„±λŠ₯ ν–₯상
const results = await Promise.allSettled(
@@ -176,7 +174,6 @@ export async function getPartnersDashboardData(domain: string): Promise<Partners
// Partners ν…Œμ΄λΈ”λ³„ 전체 톡계 쑰회 (νšŒμ‚¬ 필터링 포함)
async function getPartnersTableStats(config: TableConfig, companyId: string): Promise<PartnersDashboardStats> {
try {
- console.log(`\nπŸ” νŒŒνŠΈλ„ˆ ν…Œμ΄λΈ” ${config.tableName} 톡계 쑰회 (νšŒμ‚¬: ${companyId})`);
// 1단계: νšŒμ‚¬λ³„ 총 개수 확인
const totalQuery = `
@@ -184,10 +181,8 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
FROM "${config.tableName}"
WHERE "vendor_id" = '${companyId}'
`;
- console.log("Total SQL:", totalQuery);
const totalResult = await db.execute(sql.raw(totalQuery));
- console.log("Total κ²°κ³Ό:", totalResult.rows[0]);
// 2단계: νšŒμ‚¬λ³„ μƒνƒœκ°’ 뢄포 확인
const statusQuery = `
@@ -197,10 +192,8 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
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단계: μƒνƒœλ³„ 개수 쑰회
const pendingValues = Object.entries(config.statusMapping)
@@ -215,11 +208,7 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
.filter(([_, mapped]) => mapped === 'completed')
.map(([original]) => original);
- console.log("νŒŒνŠΈλ„ˆ μƒνƒœ λ§€ν•‘:");
- console.log("- pending:", pendingValues);
- console.log("- inProgress:", inProgressValues);
- console.log("- completed:", completedValues);
-
+
let pendingCount = 0;
let inProgressCount = 0;
let completedCount = 0;
@@ -235,7 +224,6 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
const pendingResult = await db.execute(sql.raw(pendingQuery));
pendingCount = parseInt(pendingResult.rows[0]?.count || '0');
- console.log("Pending 개수:", pendingCount);
}
// In Progress 개수 (νšŒμ‚¬ ν•„ν„° 포함)
@@ -249,7 +237,6 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
const inProgressResult = await db.execute(sql.raw(inProgressQuery));
inProgressCount = parseInt(inProgressResult.rows[0]?.count || '0');
- console.log("InProgress 개수:", inProgressCount);
}
// Completed 개수 (νšŒμ‚¬ ν•„ν„° 포함)
@@ -263,7 +250,6 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
const completedResult = await db.execute(sql.raw(completedQuery));
completedCount = parseInt(completedResult.rows[0]?.count || '0');
- console.log("Completed 개수:", completedCount);
}
const stats = {
@@ -275,7 +261,6 @@ async function getPartnersTableStats(config: TableConfig, companyId: string): Pr
completed: completedCount
};
- console.log(`βœ… νŒŒνŠΈλ„ˆ ${config.tableName} μ΅œμ’… 톡계:`, stats);
return stats;
} catch (error) {
console.error(`❌ νŒŒνŠΈλ„ˆ ν…Œμ΄λΈ” ${config.tableName} 톡계 쑰회 쀑 였λ₯˜:`, error);
@@ -288,11 +273,9 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
try {
// μ‚¬μš©μž ν•„λ“œκ°€ μ—†λŠ” 경우 빈 톡계 λ°˜ν™˜
if (!hasUserFields(config)) {
- console.log(`⚠️ νŒŒνŠΈλ„ˆ ν…Œμ΄λΈ” ${config.tableName}에 μ‚¬μš©μž ν•„λ“œκ°€ μ—†μŠ΅λ‹ˆλ‹€.`);
return createEmptyPartnersStats(config);
}
- console.log(`\nπŸ‘€ νŒŒνŠΈλ„ˆ μ‚¬μš©μž ${userId}의 ${config.tableName} 톡계 쑰회 (νšŒμ‚¬: ${companyId})`);
// μ‚¬μš©μž 쑰건 생성 (νšŒμ‚¬ ν•„ν„° 포함)
const userConditions = [];
@@ -318,10 +301,8 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
FROM "${config.tableName}"
WHERE "vendor_id" = '${companyId}' AND (${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)
@@ -351,7 +332,6 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
const userPendingResult = await db.execute(sql.raw(userPendingQuery));
userPendingCount = parseInt(userPendingResult.rows[0]?.count || '0');
- console.log("User Pending 개수:", userPendingCount);
}
// User + Company In Progress 개수
@@ -365,7 +345,6 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
const userInProgressResult = await db.execute(sql.raw(userInProgressQuery));
userInProgressCount = parseInt(userInProgressResult.rows[0]?.count || '0');
- console.log("User InProgress 개수:", userInProgressCount);
}
// User + Company Completed 개수
@@ -379,7 +358,6 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
const userCompletedResult = await db.execute(sql.raw(userCompletedQuery));
userCompletedCount = parseInt(userCompletedResult.rows[0]?.count || '0');
- console.log("User Completed 개수:", userCompletedCount);
}
const stats = {
@@ -391,7 +369,6 @@ async function getPartnersUserTableStats(config: TableConfig, companyId: string,
completed: userCompletedCount
};
- console.log(`βœ… νŒŒνŠΈλ„ˆ μ‚¬μš©μž ${config.tableName} μ΅œμ’… 톡계:`, stats);
return stats;
} catch (error) {
console.error(`❌ νŒŒνŠΈλ„ˆ ν…Œμ΄λΈ” ${config.tableName} μ‚¬μš©μž 톡계 쑰회 쀑 였λ₯˜:`, error);
@@ -418,12 +395,10 @@ function hasUserFields(config: TableConfig): boolean {
// 디버깅 ν•¨μˆ˜: Partners μ „μš©
export async function simplePartnersTest(tableName: string, statusField: string, companyId: string) {
try {
- console.log(`\nπŸ§ͺ νŒŒνŠΈλ„ˆ ${tableName} κ°„λ‹¨ν•œ ν…ŒμŠ€νŠΈ (νšŒμ‚¬: ${companyId}):`);
// 1. νšŒμ‚¬λ³„ 총 개수
const totalQuery = `SELECT COUNT(*) as total FROM "${tableName}" WHERE "vendor_id" = '${companyId}'`;
const totalResult = await db.execute(sql.raw(totalQuery));
- console.log("νšŒμ‚¬λ³„ 총 개수:", totalResult.rows[0]);
// 2. νšŒμ‚¬λ³„ μƒνƒœ 뢄포
const statusQuery = `
@@ -434,7 +409,6 @@ export async function simplePartnersTest(tableName: string, statusField: string,
ORDER BY count DESC
`;
const statusResult = await db.execute(sql.raw(statusQuery));
- console.log("νšŒμ‚¬λ³„ μƒνƒœ 뢄포:", statusResult.rows);
return {
total: totalResult.rows[0],