import { Injectable, Logger } from '@nestjs/common'; import { MailsService } from '../mails/mails.service'; import { ReportData } from './report.service'; @Injectable() export class MailerService { private readonly logger = new Logger(MailerService.name); constructor(private readonly mails: MailsService) {} /** * Sends the report (Excel + PDF) through your existing dynamic mail system. * `to` overrides the recipient (typed in the UI); falls back to MANAGEMENT_EMAIL. */ async sendReport( report: ReportData, summary: string, excel: Buffer, pdf: Buffer, senderUserId: number, to?: string, ): Promise { const recipient = (to && to.trim()) || process.env.MANAGEMENT_EMAIL || ''; const base = `Certification_Report_${report.monthName}_${report.year}`; if (!recipient) { this.logger.warn('No recipient (to / MANAGEMENT_EMAIL) — skipping send.'); return; } await this.mails.sendAsUser(senderUserId, { to: recipient, subject: `Certification Report — ${report.monthName} ${report.year} (${report.total} due)`, html: this.buildHtml(report, summary), attachments: [ { filename: `${base}.xlsx`, content: excel }, { filename: `${base}.pdf`, content: pdf }, ], }); this.logger.log(`Report emailed to ${recipient} from user #${senderUserId}: ${base}`); } /** Professional, brand-styled HTML email. */ private buildHtml(report: ReportData, summary: string): string { const accents: Record = { recert: '#D85A30', surv_11: '#1D9E75', surv_1: '#BA7517', }; const cards = report.buckets .map( (b) => `

${b.count}

${b.label}

`, ) .join(''); return `

Quality Registrar Systems

Certification Report

${report.monthName} ${report.year}

${summary}

${cards}

Total certificates due

${report.total}

📎 The full breakdown is attached as Excel (one sheet per category) and PDF.

`; } }