import { MigrationInterface, QueryRunner } from 'typeorm'; /** * Seeds the two default BOOKING-context templates per tenant: * an email confirmation matching the docx sample layout (subject * swaps query_number → booking_number) and a WhatsApp confirmation * that mirrors generateItineraryMessage's output for the booking * surface — same day_blocks/signature/tax_label token set the * QUERY seed uses, only the copy changes ("Here's your confirmed * trip itinerary" vs "…personalized itinerary crafted for you"). * * Idempotent — skips tenants that already have a default row. */ export class CommunicationTemplatesBookingSeed1782800000000 implements MigrationInterface { name = 'CommunicationTemplatesBookingSeed1782800000000'; public async up(qr: QueryRunner): Promise { const emailSubject = `Booking confirmed — {{booking.number}}`; const emailBody = `

Dear {{query.guest_name}},

Thanks for choosing {{company.name}} !!!

Your booking is confirmed. Please find the full itinerary below.

Booking Overview

Booking ID	{{booking.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}}

{{#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}}

Total Price

{{price_amount}} (including {{tax_label}})

{{#if inclusion_by_day}}

Inclusion

{{#each inclusion_by_day}}

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

{{label}}

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

Terms & Conditions

{{terms}}

{{/if}}

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

`; // WhatsApp body — matches generateItineraryMessage's booking // branch (only greeting_text differs from the QUERY seed). const whatsAppBody = `*{{title_emoji}} Your {{destination.name}} Itinerary {{title_emoji}}* Hi {{query.greeting_name}}, Here's your confirmed trip itinerary. 📅 *{{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}}`; 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', 'BOOKING', 'Standard Confirmation', $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 = 'BOOKING' 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', 'BOOKING', 'Standard Confirmation', 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 = 'BOOKING' AND ct.is_deleted = false ) `, [whatsAppBody], ); } public async down(qr: QueryRunner): Promise { await qr.query(` DELETE FROM communication_templates WHERE context = 'BOOKING' AND name = 'Standard Confirmation' AND is_default = true; `); } }