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 { sendEmail } from '../../../../lib/mail/emailHelper.js'; import { pool } from '../../../../lib/postgres/connection.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} has been delivered." number=order.order_number)}}

{{t "Your order was delivered"}}

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

{{t "We hope it's everything you expected. If anything's not right, just reply to this email."}}

{{#if shippingAddress}}

{{t "Delivered to"}}

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

{{/if}} {{#if items.length}}

{{t "Delivered items"}}

{{#each items}}{{/each}}
{{this.product_name}} · {{t "Qty"}} {{this.qty}}
{{/if}} {{> button href=trackOrderUrl label=(t "View your order")}} {{/emailLayout}}`; export default async function sendShipmentDeliveredEmail( data: EventData<'shipment_delivered'> ) { try { const config = getConfig('system.notification_emails.shipment_delivered', { enabled: true }); if (config?.enabled === false) return; const shipment = await select() .from('shipment') .where('shipment_id', '=', data.shipmentId) .load(pool); if (!shipment) return; const order = await select() .from('order') .where('order_id', '=', shipment.shipment_order_id) .load(pool); if (!order || !order.customer_email) return; const shipmentItems = await select() .from('shipment_item') .where('shipment_id', '=', shipment.shipment_id) .execute(pool); if (shipmentItems.length === 0) return; const orderItems = await select() .from('order_item') .where( 'order_item_id', 'IN', shipmentItems.map((i) => i.order_item_id) ) .execute(pool); const oiByid = new Map(orderItems.map((oi) => [oi.order_item_id, oi])); const items = shipmentItems.map((si) => { const oi = oiByid.get(si.order_item_id); return { qty: si.qty, product_name: oi?.product_name ?? '', product_sku: oi?.product_sku ?? '' }; }); // Direct pending โ†’ delivered transitions leave `shipped_at` NULL. Fall back // to `delivered_at`, then `created_at`, so the email never shows a blank // date. const deliveredOn = shipment.delivered_at || shipment.shipped_at || shipment.created_at; const trackOrderUrl = getOrderEmailLink(order.uuid); 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 { debug( `Shipment delivered email template not found at ${filePath}. Using default.` ); template = TEMPLATE; } } else { template = TEMPLATE; } // Off-request (event subscriber) โ€” resolve the store locale explicitly (D7). const locale = await getStoreLanguage(); // The delivery address, as `formatted` lines plus the derived names // (spec ยง 3.6) โ€” the same data the order confirmation prints. 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; const dynamicData = await getValue('shipmentDeliveredEmailData', { order, shippingAddress, shipment, items, deliveredOn, trackOrderUrl }); const subject = translate( 'Your order #${number} has been delivered', { number: String(order.order_number) }, locale ); const args = await getValue( 'shipmentDeliveredEmailArguments', { to: order.customer_email, subject, template, data: dynamicData, locale }, { order, shipment } ); await sendEmail('shipment_delivered', args); } catch (e) { error(e); } }