MCP Toggl Server

import type { HydratedTimeEntry, DailyReport, WeeklyReport, ProjectSummary, WorkspaceSummary, ReportEntry, DateRange } from './types.js'; // Convert seconds to hours with decimal precision export function secondsToHours(seconds: number): number { return Math.round((seconds / 3600) * 100) / 100; } // Format duration for display export function formatDuration(seconds: number): string { const hours = Math.floor(seconds / 3600); const minutes = Math.floor((seconds % 3600) / 60); const secs = seconds % 60; if (hours > 0) { return `${hours}h ${minutes}m`; } else if (minutes > 0) { return `${minutes}m ${secs}s`; } else { return `${secs}s`; } } // Parse ISO date to local date string export function formatDate(dateStr: string): string { const date = new Date(dateStr); return date.toLocaleDateString('en-US', { weekday: 'short', year: 'numeric', month: 'short', day: 'numeric' }); } // Get date range for various periods export function getDateRange(period: 'today' | 'yesterday' | 'week' | 'lastWeek' | 'month' | 'lastMonth'): DateRange { const today = new Date(); today.setHours(0, 0, 0, 0); switch (period) { case 'today': { const tomorrow = new Date(today); tomorrow.setDate(tomorrow.getDate() + 1); return { start: today, end: tomorrow }; } case 'yesterday': { const yesterday = new Date(today); yesterday.setDate(yesterday.getDate() - 1); return { start: yesterday, end: today }; } case 'week': { const dayOfWeek = today.getDay(); const diff = today.getDate() - dayOfWeek + (dayOfWeek === 0 ? -6 : 1); const monday = new Date(today.setDate(diff)); const sunday = new Date(monday); sunday.setDate(sunday.getDate() + 6); sunday.setHours(23, 59, 59, 999); return { start: monday, end: sunday }; } case 'lastWeek': { const dayOfWeek = today.getDay(); const diff = today.getDate() - dayOfWeek + (dayOfWeek === 0 ? -6 : 1) - 7; const monday = new Date(today.setDate(diff)); const sunday = new Date(monday); sunday.setDate(sunday.getDate() + 6); sunday.setHours(23, 59, 59, 999); return { start: monday, end: sunday }; } case 'month': { const firstDay = new Date(today.getFullYear(), today.getMonth(), 1); const lastDay = new Date(today.getFullYear(), today.getMonth() + 1, 0); lastDay.setHours(23, 59, 59, 999); return { start: firstDay, end: lastDay }; } case 'lastMonth': { const firstDay = new Date(today.getFullYear(), today.getMonth() - 1, 1); const lastDay = new Date(today.getFullYear(), today.getMonth(), 0); lastDay.setHours(23, 59, 59, 999); return { start: firstDay, end: lastDay }; } } } // Group time entries by date export function groupEntriesByDate(entries: HydratedTimeEntry[]): Map<string, HydratedTimeEntry[]> { const grouped = new Map<string, HydratedTimeEntry[]>(); entries.forEach(entry => { const date = entry.start.split('T')[0]; if (!grouped.has(date)) { grouped.set(date, []); } grouped.get(date)!.push(entry); }); return grouped; } // Group time entries by project export function groupEntriesByProject(entries: HydratedTimeEntry[]): Map<string, HydratedTimeEntry[]> { const grouped = new Map<string, HydratedTimeEntry[]>(); entries.forEach(entry => { const key = entry.project_name || 'No Project'; if (!grouped.has(key)) { grouped.set(key, []); } grouped.get(key)!.push(entry); }); return grouped; } // Group time entries by workspace export function groupEntriesByWorkspace(entries: HydratedTimeEntry[]): Map<string, HydratedTimeEntry[]> { const grouped = new Map<string, HydratedTimeEntry[]>(); entries.forEach(entry => { const key = entry.workspace_name; if (!grouped.has(key)) { grouped.set(key, []); } grouped.get(key)!.push(entry); }); return grouped; } // Calculate total duration from entries export function calculateTotalDuration(entries: HydratedTimeEntry[]): number { return entries.reduce((total, entry) => { // Handle running timers (negative duration) const duration = entry.duration < 0 ? Math.floor((Date.now() - new Date(entry.start).getTime()) / 1000) : entry.duration; return total + duration; }, 0); } // Create a report entry from a hydrated time entry export function createReportEntry(entry: HydratedTimeEntry): ReportEntry { const duration = entry.duration < 0 ? Math.floor((Date.now() - new Date(entry.start).getTime()) / 1000) : entry.duration; return { id: entry.id, workspace: entry.workspace_name, project: entry.project_name, client: entry.client_name, task: entry.task_name, description: entry.description, start: entry.start, stop: entry.stop, duration_hours: secondsToHours(duration), duration_seconds: duration, tags: entry.tag_names || entry.tags, billable: entry.billable }; } // Generate project summary export function generateProjectSummary( projectName: string, entries: HydratedTimeEntry[] ): ProjectSummary { const totalSeconds = calculateTotalDuration(entries); const billableSeconds = entries .filter(e => e.billable) .reduce((total, e) => total + (e.duration < 0 ? 0 : e.duration), 0); return { project_id: entries[0]?.project_id, project_name: projectName, client_name: entries[0]?.client_name, workspace_name: entries[0]?.workspace_name || 'Unknown', total_hours: secondsToHours(totalSeconds), total_seconds: totalSeconds, billable_hours: secondsToHours(billableSeconds), billable_seconds: billableSeconds, entry_count: entries.length }; } // Generate workspace summary export function generateWorkspaceSummary( workspaceName: string, workspaceId: number, entries: HydratedTimeEntry[] ): WorkspaceSummary { const totalSeconds = calculateTotalDuration(entries); const billableSeconds = entries .filter(e => e.billable) .reduce((total, e) => total + (e.duration < 0 ? 0 : e.duration), 0); const projectIds = new Set(entries.map(e => e.project_id).filter(Boolean)); return { workspace_id: workspaceId, workspace_name: workspaceName, total_hours: secondsToHours(totalSeconds), total_seconds: totalSeconds, billable_hours: secondsToHours(billableSeconds), billable_seconds: billableSeconds, project_count: projectIds.size, entry_count: entries.length }; } // Generate daily report export function generateDailyReport(date: string, entries: HydratedTimeEntry[]): DailyReport { const totalSeconds = calculateTotalDuration(entries); const reportEntries = entries.map(createReportEntry); // Group by project const byProject = groupEntriesByProject(entries); const projectSummaries: ProjectSummary[] = []; byProject.forEach((projectEntries, projectName) => { projectSummaries.push(generateProjectSummary(projectName, projectEntries)); }); // Group by workspace const byWorkspace = groupEntriesByWorkspace(entries); const workspaceSummaries: WorkspaceSummary[] = []; byWorkspace.forEach((wsEntries, wsName) => { const wsId = wsEntries[0]?.workspace_id || 0; workspaceSummaries.push(generateWorkspaceSummary(wsName, wsId, wsEntries)); }); return { date, total_hours: secondsToHours(totalSeconds), total_seconds: totalSeconds, entries: reportEntries, by_project: projectSummaries, by_workspace: workspaceSummaries }; } // Generate weekly report export function generateWeeklyReport( weekStart: Date, weekEnd: Date, entries: HydratedTimeEntry[] ): WeeklyReport { const totalSeconds = calculateTotalDuration(entries); // Group by date for daily breakdown const byDate = groupEntriesByDate(entries); const dailyBreakdown: DailyReport[] = []; byDate.forEach((dateEntries, date) => { dailyBreakdown.push(generateDailyReport(date, dateEntries)); }); // Sort daily reports dailyBreakdown.sort((a, b) => a.date.localeCompare(b.date)); // Overall project summaries const byProject = groupEntriesByProject(entries); const projectSummaries: ProjectSummary[] = []; byProject.forEach((projectEntries, projectName) => { projectSummaries.push(generateProjectSummary(projectName, projectEntries)); }); // Overall workspace summaries const byWorkspace = groupEntriesByWorkspace(entries); const workspaceSummaries: WorkspaceSummary[] = []; byWorkspace.forEach((wsEntries, wsName) => { const wsId = wsEntries[0]?.workspace_id || 0; workspaceSummaries.push(generateWorkspaceSummary(wsName, wsId, wsEntries)); }); return { week_start: weekStart.toISOString().split('T')[0], week_end: weekEnd.toISOString().split('T')[0], total_hours: secondsToHours(totalSeconds), total_seconds: totalSeconds, daily_breakdown: dailyBreakdown, by_project: projectSummaries, by_workspace: workspaceSummaries }; } // Format report for display export function formatReportForDisplay(report: DailyReport | WeeklyReport): string { const lines: string[] = []; if ('week_start' in report) { // Weekly report lines.push(`📊 Weekly Report (${report.week_start} to ${report.week_end})`); lines.push(`Total: ${report.total_hours} hours`); lines.push(''); lines.push('📅 Daily Breakdown:'); report.daily_breakdown.forEach(day => { lines.push(` ${day.date}: ${day.total_hours}h`); }); } else { // Daily report lines.push(`📊 Daily Report for ${report.date}`); lines.push(`Total: ${report.total_hours} hours`); } lines.push(''); lines.push('🏢 By Workspace:'); report.by_workspace.forEach(ws => { lines.push(` ${ws.workspace_name}: ${ws.total_hours}h (${ws.project_count} projects)`); }); lines.push(''); lines.push('📁 By Project:'); report.by_project.forEach(proj => { const client = proj.client_name ? ` (${proj.client_name})` : ''; lines.push(` ${proj.project_name}${client}: ${proj.total_hours}h`); }); return lines.join('\n'); }