// src/inquiry-notifications/email-template.ts
export interface EmailTemplateData {
type: string;
inquiry_ref: string;
company_name: string;
old_status: string;
new_status: string;
message: string;
timestamp: string;
pdf_url?: string;
docx_url?: string;
inquiry_type?: string;
auditor_name?: string;
previous_cert_no?: string;
cert_body?: string; // ✅ NEW
audit_stage?: string; // ✅ NEW
submitted_by_name?: string; // ✅ NEW
submitted_by_email?: string; // ✅ NEW
notes?: string;
}
interface TypeStyle {
color: string;
bg: string;
label: string;
}
const TYPE_CONFIG: { [key: string]: TypeStyle } = {
NEW_INQUIRY: { color: '#1E40AF', bg: '#EFF6FF', label: 'New Inquiry' },
IN_REVIEW: { color: '#5B21B6', bg: '#F5F3FF', label: 'In Review' },
DRAFT_READY: { color: '#0F766E', bg: '#F0FDFA', label: 'Draft Ready' },
CHANGES_REQUESTED: {
color: '#991B1B',
bg: '#FEF2F2',
label: 'Changes Requested',
},
CLIENT_CONFIRMED: {
color: '#065F46',
bg: '#F0FDF4',
label: 'Client Confirmed',
},
FINAL_ISSUED: { color: '#0C4A6E', bg: '#F0F9FF', label: 'Final Issued' },
};
// Color constants
const BRAND = '#0F4C5C';
const BRAND_LIGHT = '#E6EEF0';
const TEXT = '#1A1A1A';
const MUTED = '#6B7280';
const BORDER = '#E5E7EB';
const PAGE_BG = '#F4F5F7';
// Strip emojis for clean professional look
function cleanText(text: string): string {
return text
.replace(
/[\u{1F300}-\u{1F9FF}]|[\u{2600}-\u{26FF}]|[\u{2700}-\u{27BF}]/gu,
'',
)
.trim();
}
// Format inquiry type (NEW → "New", RE_CERTIFICATION → "Re Certification")
function formatType(t: string | undefined): string {
if (!t) return '—';
return t
.replace(/_/g, ' ')
.toLowerCase()
.replace(/\b\w/g, (c) => c.toUpperCase());
}
// ✅ NEW — Build a professional structured headline with proper typography hierarchy
function buildHeadline(event: EmailTemplateData, cleanMessage: string): string {
const ref = event.inquiry_ref;
const submitter = event.submitted_by_name;
const company = event.company_name;
// Detect the action verb from the message (submitted / updated / approved / etc.)
let action = 'Update';
const lower = cleanMessage.toLowerCase();
if (lower.includes('submitted')) action = 'New inquiry submitted';
else if (lower.includes('approved')) action = 'Inquiry approved';
else if (lower.includes('confirmed')) action = 'Inquiry confirmed';
else if (lower.includes('issued')) action = 'Final certificate issued';
else if (lower.includes('changes requested')) action = 'Changes requested';
else if (lower.includes('draft')) action = 'Draft ready for review';
else if (lower.includes('review')) action = 'Inquiry under review';
else action = cleanMessage.split('.')[0]; // fallback to first sentence
// Eyebrow line (small, uppercase, muted) — context above the headline
const eyebrow = `${ref}
`;
// Main headline — clean, balanced, professional weight
const headline = `${action}
`;
// Sub-line — company + submitter context in lighter weight
const parts: string[] = [];
if (company) {
parts.push(
`${company}`,
);
}
if (submitter) {
parts.push(`submitted by ${submitter}`);
}
const subline = parts.length
? `${parts.join(' · ')}
`
: '';
return `${eyebrow}${headline}${subline}`;
}
// Outlook-safe button
function vmlButton(href: string, label: string, bg: string): string {
return `${label}`;
}
// Build a single details table row
function detailRow(
label: string,
value: string,
mono: boolean,
isLast: boolean,
): string {
const borderStyle = isLast ? '' : `border-bottom:1px solid ${BORDER};`;
const valueFont = mono
? `font-family:'Courier New',Courier,monospace;`
: `font-family:Arial,Helvetica,sans-serif;`;
return `| ${label} | ${value} |
`;
}
// ✅ NEW — Special row that renders the value as a colored badge (for cert_body / audit_stage)
function badgeRow(
label: string,
value: string,
badgeColor: string,
badgeBg: string,
isLast: boolean,
): string {
const borderStyle = isLast ? '' : `border-bottom:1px solid ${BORDER};`;
const badgeHtml = `${value}`;
return `| ${label} | ${badgeHtml} |
`;
}
export function buildEmailHtmlTemplate(event: EmailTemplateData): string {
const cfg = TYPE_CONFIG[event.type] || {
color: '#374151',
bg: '#F3F4F6',
label: event.type,
};
const appUrl = process.env.APP_URL || 'http://localhost:3011';
const date = new Date(event.timestamp).toLocaleString('en-GB', {
day: '2-digit',
month: 'short',
year: 'numeric',
hour: '2-digit',
minute: '2-digit',
hour12: false,
});
const cleanMessage = cleanText(event.message);
// Status display
const statusHtml = event.old_status
? `${event.old_status} → ${event.new_status}`
: `${event.new_status}`;
// Build all detail rows (only render rows that have values)
const detailRows: string[] = [];
detailRows.push(
detailRow('Reference Number', event.inquiry_ref, true, false),
);
detailRows.push(detailRow('Company', event.company_name, false, false));
// ✅ NEW — Certification Body badge (purple if QRS, teal if TQS)
if (event.cert_body) {
const isQrs = event.cert_body.toUpperCase() === 'QRS';
detailRows.push(
badgeRow(
'Certification Body',
event.cert_body,
isQrs ? '#7c3aed' : '#0f766e', // text color
isQrs ? '#f5f3ff' : '#f0fdfa', // bg color
false,
),
);
}
// ✅ NEW — Audit Stage badge (always purple/lavender for visibility)
if (event.audit_stage) {
detailRows.push(
badgeRow('Audit Stage', event.audit_stage, '#6d28d9', '#ede9fe', false),
);
}
if (event.inquiry_type) {
detailRows.push(
detailRow(
'Certification Type',
formatType(event.inquiry_type),
false,
false,
),
);
}
if (event.auditor_name) {
detailRows.push(detailRow('Auditor', event.auditor_name, false, false));
}
// ✅ NEW — Submitter info
if (event.submitted_by_name) {
detailRows.push(
detailRow('Submitted By', event.submitted_by_name, false, false),
);
}
if (event.submitted_by_email) {
detailRows.push(
detailRow('Submitter Email', event.submitted_by_email, false, false),
);
}
if (event.previous_cert_no) {
detailRows.push(
detailRow('Previous Cert. No.', event.previous_cert_no, true, false),
);
}
// Status row (with normal font)
detailRows.push(
`| Status | ${statusHtml} |
`,
);
// Notification Date (last row, no bottom border)
detailRows.push(detailRow('Notification Date', date, false, true));
// Download buttons
const pdfBlock = event.pdf_url
? `${vmlButton(`${appUrl}${event.pdf_url}`, 'DOWNLOAD PDF', BRAND)} | `
: '';
const docxBlock = event.docx_url
? `${vmlButton(`${appUrl}${event.docx_url}`, 'DOWNLOAD WORD', '#374151')} | `
: '';
const downloadSection =
event.pdf_url || event.docx_url
? `Documents Available Secure links valid for 30 days. Authentication required for access. |
`
: '';
// ✅ NEW — Notes section (only rendered when notes exist)
const rawNotes = event.notes ? cleanText(event.notes) : '';
const safeNotes = rawNotes
.replace(/&/g, '&')
.replace(//g, '>');
const notesSection = safeNotes
? `|
Notes
|
`
: '';
return `
QRS Certification
${cfg.label} · ${event.inquiry_ref} · ${event.company_name}
| |
QRS CERTIFICATION
Inquiry Management System
|
${date} |
|
|
|
|
${buildHeadline(event, cleanMessage)}
|
|
The following inquiry has been updated. Please review the details below and take any necessary action.
|
|
Inquiry Details
|
${notesSection}
| |
${downloadSection}
|
Action Required
${vmlButton(`${appUrl}/modules/inquiries`, 'ACCESS PORTAL', BRAND)}
Sign in to your QRS account to view full inquiry details and complete any pending actions.
|
| i |
Security notice: This is an automated message from QRS Certification. We will never ask for your password, OTP, or sensitive information via email. If you did not expect this notification, please contact your administrator immediately. |
|
|
This message was sent to you because you are a registered participant in the QRS Certification system. This is a system-generated email — please do not reply.
For assistance, contact coordinator@iicc.ae
|
|
© ${new Date().getFullYear()} QRS Certification. All rights reserved.
This communication is confidential and intended solely for the addressee. If you have received this email in error, please notify the sender and delete all copies.
|
|
`;
}