-- Add editable invoice message template to each company WhatsApp settings row.
-- Safe to run from phpMyAdmin.

SET @column_exists := (
    SELECT COUNT(*)
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA = DATABASE()
      AND TABLE_NAME = 'veno_whatsapp_settings'
      AND COLUMN_NAME = 'invoice_message_template'
);

SET @sql := IF(
    @column_exists = 0,
    'ALTER TABLE `veno_whatsapp_settings` ADD COLUMN `invoice_message_template` TEXT NULL AFTER `default_country_code`',
    'SELECT "invoice_message_template column already exists" AS message'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

UPDATE `veno_whatsapp_settings`
SET `invoice_message_template` = 'شكراً لتعاملكم مع {business_name}\nعزيزي العميل {customer_name}\nرقم الفاتورة: {invoice_no}\nالإجمالي: {total}\nرابط الفاتورة:\n{invoice_url}'
WHERE `invoice_message_template` IS NULL OR `invoice_message_template` = '';