import fs from 'fs/promises'; import path from 'path'; import { select } from '@evershop/postgres-query-builder'; import { CONSTANTS } from '../../../../lib/helpers.js'; import { translate } from '../../../../lib/locale/translate/translate.js'; import { debug, error } from '../../../../lib/log/logger.js'; import { buildEmailBodyFromTemplate, sendEmail } from '../../../../lib/mail/emailHelper.js'; import { pool } from '../../../../lib/postgres/connection.js'; import { getAssetUrl } from '../../../../lib/util/getAssetUrl.js'; import { getConfig } from '../../../../lib/util/getConfig.js'; import { getValue } from '../../../../lib/util/registry.js'; import { EventData } from '../../../../types/event.js'; import { getStoreLanguage } from '../../../setting/services/setting.js'; import { decorateAddressForEmail } from '../../services/addressEmailData.js'; import { getOrderEmailLink } from '../../services/orderEmailLink.js'; export const TEMPLATE = `{{#> emailLayout preheader=(t "Your order #\${number} is confirmed." number=order.order_number)}}

{{t "Your order is confirmed"}}

{{t "Order #\${number}" number=order.order_number}} · {{date order.created_at}}

{{> itemsTable}} {{#if order.discount_amount}}{{/if}} {{#if order.tax_amount}}{{/if}}
{{t "Subtotal"}}{{currency order.sub_total}}
{{t "Discount"}}-{{currency order.discount_amount}}
{{t "Shipping"}}{{currency order.shipping_fee_incl_tax}}
{{t "Tax"}}{{currency order.tax_amount}}
{{t "Total"}}{{currency order.grand_total}}
{{#if orderUrl}}{{> button href=orderUrl label=(t "View your order")}}{{/if}} {{#if shippingAddress}}

{{t "Shipping to"}}

{{#each shippingAddress.formatted}}{{this}}
{{/each}}

{{/if}} {{/emailLayout}}`; export default async function sendOrderConfirmationEmail( data: EventData<'order_placed'> ) { try { const config = getConfig('system.notification_emails.order_confirmation', { enabled: true }); if (config?.enabled === false) { return; } // Build the email data const orderId = data.order_id; const order = await select() .from('order') .where('order_id', '=', orderId) .load(pool); if (!order) { return; } const items = await select() .from('order_item') .where('order_item_order_id', '=', order.order_id) .execute(pool); // Local storage stores thumbnails as relative paths; remote providers // store absolute URLs that must pass through untouched. order.items = items.map((item) => { if (item.thumbnail) { item.thumbnail = getAssetUrl(item.thumbnail); } return item; }); // Off-request (event subscriber) โ€” resolve the store locale explicitly (D7). // It drives the subject, the body's currency/date format and the address // lines, and is passed to sendEmail so everything matches. const locale = await getStoreLanguage(); // Addresses travel under the new column names plus `formatted` (the display // lines the default template prints โ€” line 2 and the country included) and // the derived names (spec ยง 3.6). `province_name` is gone with the rename. const shippingRow = order.shipping_address_id ? await select() .from('order_address') .where('order_address_id', '=', order.shipping_address_id) .load(pool) : null; const shippingAddress = shippingRow ? await decorateAddressForEmail(shippingRow, locale) : null; // Zero-total orders may have no billing address โ€” pass null through so // custom templates can `{{#if billingAddress}}` it (the default template // does not render billing at all). const billingRow = order.billing_address_id ? await select() .from('order_address') .where('order_address_id', '=', order.billing_address_id) .load(pool) : null; const billingAddress = billingRow ? await decorateAddressForEmail(billingRow, locale) : null; let template; if (config?.templatePath) { const filePath = path.join(CONSTANTS.ROOTPATH, config.templatePath); try { await fs.access(filePath); template = await fs.readFile(filePath, 'utf8'); } catch (error) { debug( `Order confirmation email template file not found at path: ${filePath}. Using default template.` ); template = TEMPLATE; } } else { template = TEMPLATE; } // The "View your order" link: the signed tracking page, or the account // page when the token secret is not configured (shared with the shipment // emails) const orderUrl = getOrderEmailLink(order.uuid); const dynamicData = await getValue('orderConfirmationEmailData', { order, shippingAddress, billingAddress, orderUrl }); const subject = translate('Your order has been confirmed!', {}, locale); if (data.customer_email) { const args = await getValue( 'orderConfirmationEmailArguments', { to: data.customer_email, subject, template, data: dynamicData, locale }, { order } ); await sendEmail('order_confirmation', args); } } catch (e) { error(e); } }