xh-erp.7in6.com/application/extra/rfq_salesman_email_template_install.sql

-- 查询询价：通知业务员邮箱模版（scene=rfq_salesman_email）
-- 变量：{contact_name}/{salesman_name}/{cyjmc}/{cgymc}/{this_quantity}/{supplier_name}/{cywyxm}/{email}
INSERT INTO `purchase_sms_template` (`scene`, `title`, `content`, `remark`, `status`, `createtime`, `updatetime`)
SELECT
  'rfq_salesman_email',
  '询价邮箱通知',
  '您好，{contact_name}：\n\n有新的协助采购询价需求，请知悉。\n印件名称：{cyjmc}\n工序名称：{cgymc}\n本次数量：{this_quantity}\n供应商：{supplier_name}\n需求发起人：{cywyxm}\n',
  '查询询价-通知业务员邮箱；模版名称作邮件主题',
  1,
  NOW(),
  NOW()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `purchase_sms_template` WHERE `scene` = 'rfq_salesman_email' LIMIT 1
);

-- 已有旧模版时：去掉需求编号，补上供应商
UPDATE `purchase_sms_template`
SET `content` = '您好，{contact_name}：\n\n有新的协助采购询价需求，请知悉。\n印件名称：{cyjmc}\n工序名称：{cgymc}\n本次数量：{this_quantity}\n供应商：{supplier_name}\n需求发起人：{cywyxm}\n',
    `updatetime` = NOW()
WHERE `scene` = 'rfq_salesman_email'
  AND (
    `content` LIKE '%需求编号：{ccydh}%'
    OR (`content` NOT LIKE '%{supplier_name}%' AND `content` NOT LIKE '%供应商：%')
  );