/home/techb158/balavpn.abdallabala.com/src/services/

/home/techb158/balavpn.abdallabala.com/src/services

Name	Size	Mode	Actions
audit-service.js	659	0644	edit dl rm
auth-service.js	4779	0644	edit dl rm
dashboard-service.js	1109	0644	edit dl rm
gate-service.js	4512	0644	edit dl rm
integration-service.js	16595	0644	edit dl rm
project-service.js	5973	0644	edit dl rm
reporting-service.js	8644	0644	edit dl rm
risk-service.js	12505	0644	edit dl rm
sso-service.js	3167	0644	edit dl rm

Edit: /home/techb158/balavpn.abdallabala.com/src/services/reporting-service.js (8644B)

const { prisma } = require("../lib/prisma");
const { getProjectDashboard } = require("./dashboard-service");

function csvEscape(value) {
  const text = value === null || value === undefined ? "" : String(value);
  return /[",\n]/.test(text) ? `"${text.replace(/"/g, '""')}"` : text;
}

function toCsv(headers, rows) {
  return [headers.join(","), ...rows.map(row => headers.map(header => csvEscape(row[header])).join(","))].join("\n");
}

function riskScoreColor(score) {
  if (score >= 15) return "#dc2626";
  if (score >= 10) return "#f59e0b";
  if (score >= 5) return "#eab308";
  return "#16a34a";
}

async function getFullExportCsv(projectId) {
  const project = await prisma.project.findUnique({
    where: { id: projectId },
    include: {
      risks: {
        include: { mitigations: { orderBy: { sequence: "asc" } } },
        orderBy: { createdAt: "asc" }
      },
      lifecyclePhases: { orderBy: { sequence: "asc" } },
      indicators: true
    }
  });
  if (!project) {
    const error = new Error(`Project not found: ${projectId}`);
    error.status = 404;
    throw error;
  }

const riskHeaders = ["riskId", "title", "dimension", "status", "probability", "impact", "normalizedScore", "residualScore", "createdAt"];
  const riskRows = project.risks.map(r => ({
    riskId: r.id, title: r.title, dimension: r.dimension, status: r.status,
    probability: r.probability, impact: r.impact,
    normalizedScore: r.normalizedScore ?? "", residualScore: r.residualScore ?? "",
    createdAt: r.createdAt?.toISOString?.() ?? r.createdAt
  }));

let csv = "=== RISKS ===\n";
  csv += toCsv(riskHeaders, riskRows) + "\n\n";
  csv += "=== MITIGATIONS ===\n";
  csv += toCsv(mitHeaders, mitigationRows) + "\n\n";

if (project.lifecyclePhases.length > 0) {
    const phaseHeaders = ["phaseId", "name", "status", "sequence"];
    const phaseRows = project.lifecyclePhases.map(p => ({
      phaseId: p.id, name: p.name, status: p.gateStatus ?? "", sequence: p.sequence
    }));
    csv += "=== PHASES ===\n";
    csv += toCsv(phaseHeaders, phaseRows) + "\n\n";
  }

if (project.indicators.length > 0) {
    const indHeaders = ["indicatorId", "name", "category", "value", "target", "trend"];
    const indRows = project.indicators.map(i => ({
      indicatorId: i.id, name: i.name, category: i.category ?? "",
      value: i.value ?? "", target: i.target ?? "", trend: i.trend ?? ""
    }));
    csv += "=== INDICATORS ===\n";
    csv += toCsv(indHeaders, indRows) + "\n\n";
  }

return { contentType: "text/csv; charset=utf-8", body: csv };
}

function buildExecutiveHtml(dashboard) {
  const { project, summary, scoredRisks, indicators, lifecyclePhases, dimensionalScores } = dashboard;
  const score = summary.overallScore;
  const color = riskScoreColor(score);

const phaseRows = (lifecyclePhases || []).map(p =>
    `<tr><td>${csvEscape(p.name)}</td><td>${p.gateStatus ?? ""}</td><td>${p.sequence ?? ""}</td></tr>`
  ).join("\n");

const indRows = (indicators || []).map(i =>
    `<tr><td>${csvEscape(i.name)}</td><td>${i.category ?? ""}</td><td>${i.value ?? ""}</td><td>${i.target ?? ""}</td><td>${i.trend ?? ""}</td></tr>`
  ).join("\n");

const barWidth = Math.min(score * 5, 100);

return `<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Executive Report - ${csvEscape(project.name)}</title>
<style>
  @page { margin: 20mm; }
  body { font-family: 'Segoe UI', Arial, sans-serif; color: #1f2937; line-height: 1.6; max-width: 1000px; margin: 0 auto; padding: 20px; }
  h1 { color: #111827; border-bottom: 3px solid ${color}; padding-bottom: 8px; }
  h2 { color: #374151; margin-top: 30px; }
  .score-card { background: #f9fafb; border-left: 5px solid ${color}; padding: 15px 20px; border-radius: 6px; margin: 16px 0; }
  .score-bar { height: 24px; background: #e5e7eb; border-radius: 12px; overflow: hidden; margin-top: 8px; }
  .score-fill { height: 100%; background: ${color}; border-radius: 12px; width: ${barWidth}%; transition: width .5s; }
  .meta { color: #6b7280; font-size: 0.9em; }
  table { width: 100%; border-collapse: collapse; margin: 12px 0; }
  th, td { padding: 8px 12px; text-align: left; border-bottom: 1px solid #e5e7eb; }
  th { background: #f3f4f6; font-weight: 600; color: #374151; }
  tr:hover td { background: #f9fafb; }
  .footer { margin-top: 40px; padding-top: 16px; border-top: 1px solid #d1d5db; font-size: 0.8em; color: #9ca3af; }
  .badge { display: inline-block; padding: 2px 10px; border-radius: 12px; font-size: 0.8em; font-weight: 600; }
  .badge-green { background: #dcfce7; color: #166534; }
  .badge-yellow { background: #fef9c3; color: #854d0e; }
  .badge-red { background: #fee2e2; color: #991b1b; }
  @media print { body { padding: 0; } }
</style>
</head>
<body>
<h1>${csvEscape(project.name)} — Executive Report</h1>
<p class="meta">Generated: ${new Date().toISOString()} | ID: ${project.id}</p>

<div class="score-card">
  <strong>Overall AI Risk Score: ${score}</strong>
  <div class="score-bar"><div class="score-fill"></div></div>
</div>

<table>
  <tr><th>Metric</th><th>Value</th></tr>
  <tr><td>Gate Status</td><td>${summary.gateStatus ?? "N/A"}</td></tr>
  <tr><td>Open Risks</td><td>${summary.openRisks ?? 0}</td></tr>
  <tr><td>Mitigated Risks</td><td>${summary.mitigatedRisks ?? 0}</td></tr>
  <tr><td>Total Risks</td><td>${(scoredRisks || []).length}</td></tr>
</table>

${dimRows ? `<h2>Dimensional Scores</h2><table><tr><th>Dimension</th><th>Score</th></tr>${dimRows}</table>` : ""}

<h2>Risk Register</h2>
<table><tr><th>Title</th><th>Dimension</th><th>Status</th><th>Score</th><th>Residual</th></tr>${riskRows}</table>

${phaseRows ? `<h2>Lifecycle Phases</h2><table><tr><th>Phase</th><th>Status</th><th>Sequence</th></tr>${phaseRows}</table>` : ""}

${indRows ? `<h2>Indicators</h2><table><tr><th>Name</th><th>Category</th><th>Value</th><th>Target</th><th>Trend</th></tr>${indRows}</table>` : ""}

<div class="footer">
  <p>COSMIC AI-Risk Dashboard — Confidential</p>
</div>
</body>
</html>`;
}

async function getReport(projectId, reportType) {
  if (reportType === "full-export.csv") {
    return getFullExportCsv(projectId);
  }

const dashboard = await getProjectDashboard(projectId);

if (reportType === "risk-register.csv") {
    return {
      contentType: "text/csv; charset=utf-8",
      body: toCsv(["id", "title", "dimension", "status", "normalizedScore", "residualScore"], dashboard.scoredRisks)
    };
  }

if (reportType === "executive.html") {
    return {
      contentType: "text/html; charset=utf-8",
      body: buildExecutiveHtml(dashboard)
    };
  }

if (reportType === "executive.json") {
    return {
      contentType: "application/json; charset=utf-8",
      body: JSON.stringify({
        project: { id: dashboard.project.id, name: dashboard.project.name },
        summary: dashboard.summary,
        dimensionalScores: dashboard.dimensionalScores,
        scoredRisks: dashboard.scoredRisks.map(r => ({
          id: r.id, title: r.title, dimension: r.dimension, status: r.status,
          normalizedScore: r.normalizedScore, residualScore: r.residualScore
        })),
        generatedAt: new Date().toISOString()
      }, null, 2)
    };
  }

return {
    contentType: "application/json; charset=utf-8",
    body: JSON.stringify({ reportType, dashboard }, null, 2)
  };
}

module.exports = { getReport, buildExecutiveHtml };

const { prisma } = require("../lib/prisma"); const { getProjectDashboard } = require("./dashboard-service"); function csvEscape(value) { const text = value === null || value === undefined ? "" : String(value); return /[",\n]/.test(text) ? `"${text.replace(/"/g, '""')}"` : text; } function toCsv(headers, rows) { return [headers.join(","), ...rows.map(row => headers.map(header => csvEscape(row[header])).join(","))].join("\n"); } function riskScoreColor(score) { if (score >= 15) return "#dc2626"; if (score >= 10) return "#f59e0b"; if (score >= 5) return "#eab308"; return "#16a34a"; } async function getFullExportCsv(projectId) { const project = await prisma.project.findUnique({ where: { id: projectId }, include: { risks: { include: { mitigations: { orderBy: { sequence: "asc" } } }, orderBy: { createdAt: "asc" } }, lifecyclePhases: { orderBy: { sequence: "asc" } }, indicators: true } }); if (!project) { const error = new Error(`Project not found: ${projectId}`); error.status = 404; throw error; } const riskHeaders = ["riskId", "title", "dimension", "status", "probability", "impact", "normalizedScore", "residualScore", "createdAt"]; const riskRows = project.risks.map(r => ({ riskId: r.id, title: r.title, dimension: r.dimension, status: r.status, probability: r.probability, impact: r.impact, normalizedScore: r.normalizedScore ?? "", residualScore: r.residualScore ?? "", createdAt: r.createdAt?.toISOString?.() ?? r.createdAt })); const mitigationRows = []; for (const risk of project.risks) { for (const m of risk.mitigations) { mitigationRows.push({ riskId: risk.id, riskTitle: risk.title, mitigationId: m.id, title: m.title, type: m.type, status: m.status, sequence: m.sequence, createdAt: m.createdAt?.toISOString?.() ?? m.createdAt }); } } const mitHeaders = ["riskId", "riskTitle", "mitigationId", "title", "type", "status", "sequence", "createdAt"]; let csv = "=== RISKS ===\n"; csv += toCsv(riskHeaders, riskRows) + "\n\n"; csv += "=== MITIGATIONS ===\n"; csv += toCsv(mitHeaders, mitigationRows) + "\n\n"; if (project.lifecyclePhases.length > 0) { const phaseHeaders = ["phaseId", "name", "status", "sequence"]; const phaseRows = project.lifecyclePhases.map(p => ({ phaseId: p.id, name: p.name, status: p.gateStatus ?? "", sequence: p.sequence })); csv += "=== PHASES ===\n"; csv += toCsv(phaseHeaders, phaseRows) + "\n\n"; } if (project.indicators.length > 0) { const indHeaders = ["indicatorId", "name", "category", "value", "target", "trend"]; const indRows = project.indicators.map(i => ({ indicatorId: i.id, name: i.name, category: i.category ?? "", value: i.value ?? "", target: i.target ?? "", trend: i.trend ?? "" })); csv += "=== INDICATORS ===\n"; csv += toCsv(indHeaders, indRows) + "\n\n"; } return { contentType: "text/csv; charset=utf-8", body: csv }; } function buildExecutiveHtml(dashboard) { const { project, summary, scoredRisks, indicators, lifecyclePhases, dimensionalScores } = dashboard; const score = summary.overallScore; const color = riskScoreColor(score); const riskRows = scoredRisks.map(r => { const rc = riskScoreColor(r.normalizedScore ?? 0); return ` ${csvEscape(r.title)} ${r.dimension ?? ""} ${r.status ?? ""} ${r.normalizedScore ?? ""} ${r.residualScore ?? ""} `; }).join("\n"); const dimRows = (dimensionalScores ? Object.entries(dimensionalScores) : []).map(([dim, dimData]) => { const ds = typeof dimData === "object" ? (dimData.score ?? dimData) : dimData; const dc = riskScoreColor(ds); return `${csvEscape(dim)}${ds}`; }).join("\n"); const phaseRows = (lifecyclePhases || []).map(p => `${csvEscape(p.name)}${p.gateStatus ?? ""}${p.sequence ?? ""}` ).join("\n"); const indRows = (indicators || []).map(i => `${csvEscape(i.name)}${i.category ?? ""}${i.value ?? ""}${i.target ?? ""}${i.trend ?? ""}` ).join("\n"); const barWidth = Math.min(score * 5, 100); return ` Executive Report - ${csvEscape(project.name)}

${csvEscape(project.name)} — Executive Report

Generated: ${new Date().toISOString()} | ID: ${project.id}

Overall AI Risk Score: ${score}

Metric	Value
Gate Status	${summary.gateStatus ?? "N/A"}
Open Risks	${summary.openRisks ?? 0}
Mitigated Risks	${summary.mitigatedRisks ?? 0}
Total Risks	${(scoredRisks \|\| []).length}

${dimRows ? `

Dimensional Scores

${dimRows}

Dimension	Score

` : ""}

Risk Register

${riskRows}

Title	Dimension	Status	Score	Residual

${phaseRows ? `

Lifecycle Phases

${phaseRows}

Phase	Status	Sequence

` : ""} ${indRows ? `

Indicators

${indRows}

Name	Category	Value	Target	Trend

` : ""} `; } async function getReport(projectId, reportType) { if (reportType === "full-export.csv") { return getFullExportCsv(projectId); } const dashboard = await getProjectDashboard(projectId); if (reportType === "risk-register.csv") { return { contentType: "text/csv; charset=utf-8", body: toCsv(["id", "title", "dimension", "status", "normalizedScore", "residualScore"], dashboard.scoredRisks) }; } if (reportType === "executive.html") { return { contentType: "text/html; charset=utf-8", body: buildExecutiveHtml(dashboard) }; } if (reportType === "executive.json") { return { contentType: "application/json; charset=utf-8", body: JSON.stringify({ project: { id: dashboard.project.id, name: dashboard.project.name }, summary: dashboard.summary, dimensionalScores: dashboard.dimensionalScores, scoredRisks: dashboard.scoredRisks.map(r => ({ id: r.id, title: r.title, dimension: r.dimension, status: r.status, normalizedScore: r.normalizedScore, residualScore: r.residualScore })), generatedAt: new Date().toISOString() }, null, 2) }; } return { contentType: "application/json; charset=utf-8", body: JSON.stringify({ reportType, dashboard }, null, 2) }; } module.exports = { getReport, buildExecutiveHtml };