Email Templates

[jeffreykemp]

Implement an email template system.

• Store a template with name, subject, body, substitution variables, attachments (images, css)
  • sub-templates for Region(s), Sidebar(s), Header and Footer
• API to create/update/delete templates
• send_email accepts template name as parameter, plus substitution variables

All templates (including sub-templates) support these substitution variables:

• #GLOBAL_NAME# = database global name
• #DT:format# = date/time (specify Oracle format)
• #SENDER:NAME#
• #SENDER:EMAIL#
• #variable# = any arbitrary template variable

The main template supports these substitution variables:

• #HEADER#
• #BODY#
• #REGION1# .. #REGION9#
• #SIDEBAR1# .. #SIDEBAR9#
• #FOOTER#

Each Region and Sidebar sub-template supports these substitution variables:

• #TITLE#
• #CONTENT#
• #IMAGE#

Note: Mailgun substitution variables also allowed, e.g. %recipient.email%, %recipient.name%, %tag_unsubscribe_url%