{ "edges": [ { "to": "a5294383-503e-4c15-a5e7-51e6e3ec0ed8", "from": "753c9210-efd8-43bf-993c-6f50799b0dfb", "toPort": "0", "fromPort": "0" }, { "to": "1f697c3b-9d42-4f15-ac8e-98c5b0490a38", "from": "381fbd24-3e48-4d3f-8b92-ae73df6d8456", "toPort": "0", "fromPort": "0" }, { "to": "055cc8ac-f30a-4f69-a236-edd0425b58cc", "from": "f228e077-eae6-4442-abd5-46d713a980ff", "toPort": "0", "fromPort": "0" }, { "to": "0e709eaf-f296-4e60-8fa5-20739dd4a9e8", "from": "055cc8ac-f30a-4f69-a236-edd0425b58cc", "toPort": "0", "fromPort": "0" }, { "to": "0a14fabc-e525-4c78-8291-b1f9dad92492", "from": "055cc8ac-f30a-4f69-a236-edd0425b58cc", "toPort": "0", "fromPort": "0" }, { "to": "f228e077-eae6-4442-abd5-46d713a980ff", "from": "51e18cb1-20e1-486a-9ea5-a9c65bb72a27", "toPort": "0", "fromPort": "0" }, { "to": "753c9210-efd8-43bf-993c-6f50799b0dfb", "from": "1f697c3b-9d42-4f15-ac8e-98c5b0490a38", "toPort": "0", "fromPort": "0" }, { "to": "381fbd24-3e48-4d3f-8b92-ae73df6d8456", "from": "0e709eaf-f296-4e60-8fa5-20739dd4a9e8", "toPort": "0", "fromPort": "0" }, { "to": "381fbd24-3e48-4d3f-8b92-ae73df6d8456", "from": "3453b9a8-0e24-422b-972f-ad490bdc8fcf", "toPort": "1", "fromPort": "0" }, { "to": "3453b9a8-0e24-422b-972f-ad490bdc8fcf", "from": "0a14fabc-e525-4c78-8291-b1f9dad92492", "toPort": "0", "fromPort": "0" }, { "to": "fc46a11c-cb88-470d-ac28-314a4f911676", "from": "a5294383-503e-4c15-a5e7-51e6e3ec0ed8", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "fc46a11c-cb88-470d-ac28-314a4f911676", "name": "Send an Email", "type": "integration", "params": { "html": "={{ $json.html }}", "options": { "appendAttribution": false, "allowUnauthorizedCerts": true }, "service": "smtp", "subject": "={{ $json.subject }}", "toEmail": "info@example.com", "fromEmail": "info@example.com", "operation": "read" }, "position": [ 2704, 176 ] }, { "id": "51e18cb1-20e1-486a-9ea5-a9c65bb72a27", "name": "Every Day at 9:00", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 9 * * 1-5" } ] } }, "position": [ 736, 256 ] }, { "id": "f228e077-eae6-4442-abd5-46d713a980ff", "name": "GET Projects", "type": "http", "params": { "url": "https://kimai/api/projects", "options": {}, "sendQuery": true, "authentication": "genericCredentialType", "genericAuthType": "httpBearerAuth", "queryParameters": { "parameters": [ { "name": "visible", "value": "1" } ] } }, "position": [ 960, 256 ] }, { "id": "055cc8ac-f30a-4f69-a236-edd0425b58cc", "name": "Get only Bilable", "type": "code", "params": { "jsCode": "const results = [];\n\nfor (const item of $input.all()) {\n if (item.json.billable === true) {\n results.push({ json: item.json });\n }\n}\n\nreturn results;" }, "position": [ 1184, 256 ] }, { "id": "0e709eaf-f296-4e60-8fa5-20739dd4a9e8", "name": "GET Projects Details", "type": "http", "params": { "url": "=https://kimai/api/projects/{{$json.id}}", "options": {}, "authentication": "genericCredentialType", "genericAuthType": "httpBearerAuth" }, "position": [ 1552, 160 ] }, { "id": "0a14fabc-e525-4c78-8291-b1f9dad92492", "name": "GET Timesheet Records", "type": "http", "params": { "url": "https://kimai/api/timesheets", "options": {}, "sendQuery": true, "authentication": "genericCredentialType", "genericAuthType": "httpBearerAuth", "queryParameters": { "parameters": [ { "name": "user", "value": "all" }, { "name": "project", "value": "={{ $json.id }}" }, { "name": "size", "value": "1+1234567890" } ] } }, "position": [ 1408, 352 ] }, { "id": "3453b9a8-0e24-422b-972f-ad490bdc8fcf", "name": "Calculate Budget Uses", "type": "code", "params": { "jsCode": "const totali = {};\n\nfor (const item of $input.all()) {\n const projectId = item.json.project?.id ?? item.json.project ?? null;\n const duration = Number(item.json.duration ?? 0);\n\n if (!projectId) continue;\n\n if (!totali[projectId]) {\n totali[projectId] = 0;\n }\n\n totali[projectId] += duration;\n}\n\nconst results = Object.entries(totali)\n .map(([id, totalSeconds]) => ({\n json: {\n id: Number(id),\n total_seconds: totalSeconds,\n total_ore: Math.round((totalSeconds / 3600) * 100) / 100\n }\n }))\n .sort((a, b) => a.json.id - b.json.id);\n\nreturn results;" }, "position": [ 1632, 352 ] }, { "id": "381fbd24-3e48-4d3f-8b92-ae73df6d8456", "name": "Combine Data", "type": "merge", "params": { "mode": "combine", "options": {}, "joinMode": "enrichInput1", "fieldsToMatchString": "id" }, "position": [ 1856, 256 ] }, { "id": "1f697c3b-9d42-4f15-ac8e-98c5b0490a38", "name": "Calculate expiration", "type": "code", "params": { "jsCode": "const daysThreshold = 10;\n\nconst now = new Date();\nconst today = new Date(now.getFullYear(), now.getMonth(), now.getDate());\n\nconst msPerDay = 1000 * 60 * 60 * 24;\nconst projects = [];\n\nfunction formatIsoToItalian(isoDate) {\n if (!isoDate) return null;\n\n const parts = String(isoDate).split(\"-\");\n if (parts.length !== 3) return null;\n\n return `${parts[2]}/${parts[1]}/${parts[0]}`;\n}\n\nfunction getDaysDiff(date) {\n if (!date) return null;\n return Math.round((date.getTime() - today.getTime()) / msPerDay);\n}\n\nfunction getUrgency(days) {\n if (days === null || days === undefined) return \"none\";\n if (days < 0) return \"expired\";\n if (days <= 3) return \"high\";\n if (days <= 7) return \"medium\";\n return \"low\";\n}\n\nfunction getStatus(days) {\n if (days === null || days === undefined) return \"not_present\";\n return days < 0 ? \"expired\" : \"expiring\";\n}\n\nfunction getBudgetInfo(timeBudget, totalSeconds) {\n if (!timeBudget || timeBudget <= 0) return null;\n\n const percentage = Math.round((totalSeconds / timeBudget) * 100);\n const usedHours = Math.round((totalSeconds / 3600) * 100) / 100;\n const budgetHours = Math.round((timeBudget / 3600) * 100) / 100;\n const remainingHours = Math.round(((timeBudget - totalSeconds) / 3600) * 100) / 100;\n\n return {\n percentage,\n usedHours,\n budgetHours,\n remainingHours,\n exceeded: percentage >= 100,\n shouldReport: percentage >= 80\n };\n}\n\nfor (const item of $input.all()) {\n const id = item.json.id ?? null;\n const name = String(item.json.name ?? \"\");\n const customer = String(item.json.parentTitle ?? \"\");\n\n const endRaw = item.json.end ?? null;\n\n let projectDeadline = \"not present\";\n let projectDeadlineIso = null;\n let projectDays = null;\n let projectUrgency = \"none\";\n let projectStatus = \"not_present\";\n\n if (endRaw) {\n const endDate = new Date(`${endRaw}T00:00:00`);\n if (!isNaN(endDate.getTime())) {\n projectDeadline = formatIsoToItalian(endRaw) || endRaw;\n projectDeadlineIso = endRaw;\n projectDays = getDaysDiff(endDate);\n projectUrgency = getUrgency(projectDays);\n projectStatus = getStatus(projectDays);\n }\n }\n\n const timeBudget = Number(item.json.timeBudget ?? 0);\n const totalSeconds = Number(item.json.total_seconds ?? 0);\n const budget = getBudgetInfo(timeBudget, totalSeconds);\n\n const projectShouldReport =\n projectDays !== null && projectDays >= 0 && projectDays <= daysThreshold;\n\n const budgetShouldReport =\n budget !== null && budget.shouldReport;\n\n const shouldReport =\n projectShouldReport ||\n budgetShouldReport;\n\n if (!shouldReport) {\n continue;\n }\n\n projects.push({\n id,\n name,\n customer,\n\n project_deadline: projectDeadline,\n project_deadline_iso: projectDeadlineIso,\n project_days: projectDays,\n project_urgency: projectUrgency,\n project_status: projectStatus,\n\n budget_set: timeBudget > 0,\n budget_total_hours: budget ? budget.budgetHours : null,\n budget_used_hours: budget ? budget.usedHours : null,\n budget_remaining_hours: budget ? budget.remainingHours : null,\n budget_percentage: budget ? budget.percentage : null,\n budget_exceeded: budget ? budget.exceeded : false,\n budget_should_report: budget ? budget.shouldReport : false\n });\n}\n\nprojects.sort((a, b) => {\n const aVal = a.project_days ?? 999999;\n const bVal = b.project_days ?? 999999;\n return aVal - bVal;\n});\n\nreturn [\n {\n json: {\n daysThreshold,\n count: projects.length,\n projects\n }\n }\n];" }, "position": [ 2080, 256 ] }, { "id": "753c9210-efd8-43bf-993c-6f50799b0dfb", "name": "Need Email?", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "condition-count", "operator": { "type": "number", "operation": "gt" }, "leftValue": "={{ $json.count }}", "rightValue": 0 } ] } }, "position": [ 2304, 256 ] }, { "id": "a5294383-503e-4c15-a5e7-51e6e3ec0ed8", "name": "Build Email HTML - Report", "type": "code", "params": { "jsCode": "const projects = $json.projects || [];\nconst todayDate = $now.setLocale('en').toFormat('dd LLL yyyy');\nconst count = Number($json.count || 0);\nconst daysThreshold = Number($json.daysThreshold || 10);\n\nconst urgencyConfig = {\n expired: { color: '#ef4444', background: '#fef2f2', icon: '🚨', label: 'EXPIRED', action: 'TAKE ACTION' },\n high: { color: '#f97316', background: '#fff7ed', icon: '🔥', label: 'URGENT', action: 'DUE SOON' },\n medium: { color: '#d97706', background: '#fffbeb', icon: '⏳', label: 'WARNING', action: 'TO MONITOR' },\n low: { color: '#10b981', background: '#ecfdf5', icon: '✅', label: 'OK', action: 'ON TRACK' },\n none: { color: '#6366f1', background: '#f5f3ff', icon: '🔍', label: 'TO CHECK', action: 'MISSING DATA' }\n};\n\nconst escapeHtml = (v) =>\n String(v ?? '')\n .replace(/&/g, '&')\n .replace(//g, '>');\n\nconst buildStatusBlock = (urgency, date, label) => {\n const cfg = urgencyConfig[urgency] || urgencyConfig.none;\n const isMissing = !date || date === 'not present';\n\n return `\n

\n ${cfg.icon}\n ${cfg.label}\n

\n ${escapeHtml(isMissing ? 'MISSING DATA' : date)}\n

${escapeHtml(label)}

\n `;\n};\n\nconst buildBudgetBlock = (p) => {\n if (!p.budget_set) {\n return `\n

🔍

Budget not configured

Check whether this project should be billable

`;\n }\n\n const percent = Math.min(Number(p.budget_percentage ?? 0), 100);\n const isOver = p.budget_exceeded;\n const color = isOver ? '#ef4444' : (percent > 85 ? '#f97316' : '#3b82f6');\n\n return `\n

\n \n \n \n \n \n

Budget Usage

${p.budget_percentage}%

\n \n \n \n \n \n

${p.budget_used_hours}h logged

Total: ${p.budget_total_hours}h

`;\n};\n\nconst rowsHTML = projects.map((p) => {\n const projectLabel =\n p.project_status === 'not_present'\n ? 'Add the PO deadline'\n : (p.project_days < 0\n ? `Expired ${Math.abs(p.project_days)} days ago`\n : `In ${p.project_days} days`);\n\n return `\n

${escapeHtml(p.customer)}

${escapeHtml(p.name)}

\n \n

Order Deadline (PO)

\n ${buildStatusBlock(p.project_urgency, p.project_deadline, projectLabel)}\n\n

\n\n

Hours Monitoring

\n ${buildBudgetBlock(p)}\n

`;\n}).join('');\n\nconst html = `\n\n\n \n \n \n \n

\n \n \n \n \n\n \n \n \n\n \n \n \n

Timesheet Analysis

Deadline Report

Detected ${count} projects to manage or verify.

${rowsHTML}

\n Open Timesheet →\n

\n Automatically generated on ${todayDate}\n

\n\n`;\n\nreturn [\n {\n json: {\n html,\n subject: `[Timesheet] - Projects Deadline Report`\n }\n }\n];" }, "position": [ 2528, 176 ] } ] }

Monitor Kimai project deadlines and budgets with daily email alerts