-- ===================================================== -- 需求四 外贸订单 —— 补件提醒站内信模板(幂等) -- 用途:外贸订单按出货模式校验必填单据缺件时,向业务员推送「补件提醒」站内信 -- 模板编码:trade_foreign_doc_missing -- ===================================================== INSERT INTO `system_notify_template` (`name`, `code`, `nickname`, `content`, `type`, `params`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '外贸订单补件提醒', 'trade_foreign_doc_missing', '外贸订单', '外贸订单【{orderNo}】{scene}时缺少必填单据,请及时补件:{docs}', 2, '["orderNo","docs","scene"]', 0, '外贸订单按出货模式校验必填单据缺件时推送', '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `system_notify_template` WHERE `code` = 'trade_foreign_doc_missing');