Function getReportDataCore

packages/db/src/services/reports.service.ts:180–221

(input: {
  projectId: string;
  reportId: string;
  organizationId: string;
})

}

export async function getReportDataCore(input: {
  projectId: string;
  reportId: string;
  organizationId: string;
}) {
  const rawReport = await db.report.findUnique({
    where: { id: input.reportId, projectId: input.projectId },
    include: { layout: true },
  });

  if (!rawReport) {
    throw new Error(`Report not found: ${input.reportId}`);
  }

  const report = transformReport(rawReport);
  const { timezone } = await getSettingsForProject(input.projectId);
  const { startDate, endDate } = getChartStartEndDate(report, timezone);
  const chartInput = { ...report, startDate, endDate, timezone };

  const meta = {
    id: report.id,
    name: report.name,
    chartType: report.chartType,
    range: report.range,
    interval: report.interval,
    startDate,
    endDate,
  };

  if (report.chartType === 'funnel') {
    const result = await funnelService.getFunnel(chartInput);
    return { ...meta, data: result };
  }

  if (report.chartType === 'metric') {
    const result = await AggregateChartEngine.execute(chartInput);
    return { ...meta, data: result };
  }

  const result = await ChartEngine.execute(chartInput);
  return { ...meta, data: result };
}