import { MigrationInterface, QueryRunner } from 'typeorm'; /** * Seeds a default EMAIL and WHATSAPP template for the QUERY context * per tenant. * * The EMAIL/QUERY template mirrors the docx sample stakeholders * shared 2026-06-30 (Package Overview → Hotels → Total Price → * Inclusion → Terms & Conditions). It's authored as inline-styled * HTML so Gmail/Outlook render it faithfully when copied and pasted. * * The WHATSAPP/QUERY template is a plain-text summary — short enough * to send as a first-touch WhatsApp reply without truncation. * * Both rows land with is_default = true. The partial unique index * on the master migration allows exactly one default per (tenant, * channel, context), so if an existing seed run has already added * one it's kept and this seed is skipped. * * Idempotent — safe to re-run. */ export class CommunicationTemplatesSeed1782600000000 implements MigrationInterface { name = 'CommunicationTemplatesSeed1782600000000'; public async up(qr: QueryRunner): Promise { // Backfill role_permissions so existing tenants pick up the new // ModuleName.COMMUNICATION_TEMPLATE key without re-onboarding. // Admins get 'full', everyone else 'view' (so the Copy Email / // Copy WhatsApp buttons work for them). Idempotent — the WHERE // NOT EXISTS gate skips roles that already have a row. // access_level column is a Postgres enum // (none|view|create|edit|delete). Admin gets 'delete' (highest // hierarchy level in usePermission), everyone else gets 'view' so // the Copy Email/Copy WhatsApp buttons work from any role. await qr.query(` INSERT INTO role_permissions (role_id, module, access_level, tenant_id, created_by, updated_by) SELECT r.id, 'communication_template', (CASE WHEN r.name = 'Admin' THEN 'delete' ELSE 'view' END) ::role_permissions_access_level_enum, r.tenant_id, NULL, NULL FROM roles r WHERE r.is_deleted = false AND NOT EXISTS ( SELECT 1 FROM role_permissions rp WHERE rp.role_id = r.id AND rp.module = 'communication_template' ); `); const emailBody = `

Dear {{query.guest_name}},

Greetings from {{company.name}} !!!

Thanks for your query. Please find the below quote as per your requirement…

Package Overview

{{#if query.reference_id}}{{/if}}
Trip ID{{query.number}}
Destination{{destination.name}}
Start Date{{query.start_date}}
Trip Duration{{query.nights}} Nights / {{query.days}} Days
Pax{{query.pax.adults}} Adults{{#if query.pax.children}} + {{query.pax.children}} Children{{/if}}
Reference ID#{{query.reference_id}}
{{#if hotels}}

Hotels

{{#each hotels}} {{/each}}
Nights City Hotel Name Meal Plan Accommodation
{{check_in_date}} — {{check_out_date}} ({{nights}} nights) {{city}} {{hotel_name}}{{#if star_rating}} — {{star_rating}} Star{{/if}} {{meal_plan}} {{num_rooms}} × {{room_type}}
{{/if}} {{#if quote}}

Total Price

{{quote.currency}} {{quote.selling_total}} (including VAT)

{{/if}} {{#if inclusion_by_day}}

Inclusion

{{#each inclusion_by_day}}

{{day_number}}st Day ({{weekday}}, {{date}})

{{/each}} {{/if}} {{#if terms}}

Terms & Conditions

{{terms}}
{{/if}}

Regards,
{{company.name}}
{{company.email}} · {{company.phone}}

`; const emailSubject = `Your {{destination.name}} package — {{query.number}}`; // Matches the hardcoded `generateItineraryMessage` output on the // FE byte-for-byte so the switchover in Phase C causes zero // wording change for ops. Framing (greeting, price line, CTA, // sig) stays as editable tokens; the algorithmic per-day block // is precomputed by QueryContextResolver as day_blocks and // interpolated here. const whatsAppBody = `*{{title_emoji}} Your {{destination.name}} Itinerary {{title_emoji}}* Hi {{query.greeting_name}}, Here's your personalized itinerary crafted for you. 📅 *{{query.date_range}}* 🧳 {{query.duration}} 👥 {{query.pax_summary}} {{#if customer_remarks}} _{{customer_remarks}}_ {{/if}} {{divider}} {{day_blocks}} {{#if has_specials}}{{specials_block}} {{/if}}{{divider}} 💰 *Package Price: {{price_amount}}* _Inclusive of {{tax_label}} and selected services_ Questions? Reply here or call us — happy to help. {{#if signature_block}} {{signature_block}}{{/if}}`; // Seed one row per tenant per (channel, context). Skips tenants // that already have a row in that bucket (safe re-run). await qr.query( ` INSERT INTO communication_templates (tenant_id, channel, context, name, subject, body_template, is_default, is_active) SELECT DISTINCT t.tenant_id, 'EMAIL', 'QUERY', 'Standard Quote', $1, $2, true, true FROM tenant_settings t WHERE NOT EXISTS ( SELECT 1 FROM communication_templates ct WHERE ct.tenant_id = t.tenant_id AND ct.channel = 'EMAIL' AND ct.context = 'QUERY' AND ct.is_deleted = false ) `, [emailSubject, emailBody], ); await qr.query( ` INSERT INTO communication_templates (tenant_id, channel, context, name, subject, body_template, is_default, is_active) SELECT DISTINCT t.tenant_id, 'WHATSAPP', 'QUERY', 'Standard Summary', NULL, $1, true, true FROM tenant_settings t WHERE NOT EXISTS ( SELECT 1 FROM communication_templates ct WHERE ct.tenant_id = t.tenant_id AND ct.channel = 'WHATSAPP' AND ct.context = 'QUERY' AND ct.is_deleted = false ) `, [whatsAppBody], ); } public async down(qr: QueryRunner): Promise { // Only drop the default seeds we planted — user-added rows stay. await qr.query(` DELETE FROM communication_templates WHERE context = 'QUERY' AND name IN ('Standard Quote','Standard Summary') AND is_default = true; `); } }