1
2
3
4
5
6
7
8
9
10
11
12
| -- =====================================================
| -- 需求四 外贸订单 —— 补件提醒站内信模板(幂等)
| -- 用途:外贸订单按出货模式校验必填单据缺件时,向业务员推送「补件提醒」站内信
| -- 模板编码: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');
|
|