INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562982111859822594', '维修申请', 'embedded', 'email', 'maintenance-apply', '{"subject":"维修申请","content":"

尊敬的客户:

    ${#code} 维修申请单已经生成,请及时处理。

${#repairMaintainTable}

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 09:55:49', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 09:55:49', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563069997951053825', '保养计划', 'qyTextMessage', 'weiXinQY', 'maintenance', '{"content":"尊敬的客户,${#code}保养计划已经生成,计划开始时间为:${#planStartTime},计划结束时间为:${#planEndTime}。"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:45:03', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:45:03', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563070221285158913', '保养计划', 'systemDefault', 'internalMessage', 'maintenance', '{"subject":"保养计划","content":"

尊敬的客户,

${#code} 计划已经生成,计划开始时间为:${#planStartTime},计划结束时间为:${#planEndTime}

设备清单:

${#maintains}

请按照计划开始时间及时保养哦!

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:45:56', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:45:56', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563070351929339905', '保养计划预警', 'systemDefault', 'internalMessage', 'maintenance-warning', '{"subject":"保养预警通知","content":"

尊敬的客户:

${#code} 保养计划,距离预计开始时间还有${#day}天,请及时关注并处理。

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:46:27', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:46:48', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563070616002719746', '保养计划预警', 'qyTextMessage', 'weiXinQY', 'maintenance-warning', '{"content":"尊敬的客户,${#code}保养计划,距离预计开始时间还有${#day}天,请及时关注并处理。"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:47:30', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:47:30', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563070758088962050', '保养逾期', 'qyTextMessage', 'weiXinQY', 'maintain-overdue', '{"content":"尊敬的客户,${#code}保养计划,已经逾期${#day}天,请及时关注并处理。"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:48:04', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:48:04', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563071379236024322', '保养逾期', 'systemDefault', 'internalMessage', 'maintain-overdue', '{"subject":"保养逾期","content":"

尊敬的客户:

 ${#code} 保养计划,已经逾期${#day}天,请及时关注并处理。

设备明细:

${maintains}

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:50:32', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:50:32', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563071963208970241', '维修申请', 'qyTextMessage', 'weiXinQY', 'maintenance-apply', '{"content":"尊敬的客户,${#code}维修申请单已经生成,紧急度:${#urgency},机器编号:${#deviceCode},机器名称:${#deviceName}。"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:52:51', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:52:51', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1563072049578078209', '维修申请', 'systemDefault', 'internalMessage', 'maintenance-apply', '{"subject":"维修申请","content":"

尊敬的客户:

 ${#code} 维修申请单已经生成,请及时处理。

${#repairMaintainTable}

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 15:53:12', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:53:12', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562685856046661634', '保养逾期', 'dingTalkMessage', 'dingTalk', 'maintain-overdue', '{"agentId":"","title":"你有一条新的保养计划通知","message":"新的消息 \n *** \n ${#code}**保养计划** \n 已逾期${#day}天,请及时关注并处理。 \n   \n   \n ${#now} \n *** \n [查看详情]()"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-25 14:18:36', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-25 14:18:36', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562643197663932417', '保养计划', 'dingTalkMessage', 'dingTalk', 'maintenance', '{"agentId":"","title":"保养计划","message":"新的消息 \n *** \n 您有一条新的保养计划通知,请及时查收。 \n 保养计划编号 **${#code}** \n 计划开始时间 **${#planStartTime}** \n 计划结束时间 **${#planEndTime}** \n *** \n [查看详情]()"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-25 11:29:05', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 17:50:29', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562682333502390274', '保养计划预警', 'dingTalkMessage', 'dingTalk', 'maintenance-warning', '{"agentId":"","title":"你有一条新的保养计划通知,请及时查收。","message":"新的消息 \n *** \n ${#code}**保养计划** \n 距离开始时间还有${#day}天,请及时关注并处理。 \n   \n   \n ${#now} \n *** \n [查看详情]()"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-25 14:04:36', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-25 14:04:36', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562779702906605570', '维修申请', 'dingTalkMessage', 'dingTalk', 'maintenance-apply', '{"agentId":"","title":"新的消息","message":"新的消息 \n *** \n 您有一条新的维修申请单,请及时查收。 \n 维修申请单号  **${#code}** \n 机器编号  **${#deviceCode}** \n 机器名称  **${#deviceName}** \n 故障类型  **${#malfunctionName}** \n 故障描述  **${#description}** \n *** \n [查看详情]()"}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-25 20:31:31', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-25 20:31:31', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562978285975097345', '保养计划', 'embedded', 'email', 'maintenance', '{"subject":"保养计划","content":"

尊敬的客户,

${#code} 计划已经生成,计划开始时间为:${#planStartTime},计划结束时间为:${#planEndTime}

设备清单:

${#maintains}

请按照计划开始时间及时保养哦!

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 09:40:37', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 09:40:37', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562980158614392833', '保养计划预警', 'embedded', 'email', 'maintenance-warning', '{"subject":"保养预警通知","content":"

尊敬的客户:

${#code} 保养计划,距离预计开始时间还有${#day}天,请及时关注并处理。

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 09:48:03', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 15:53:47', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000'); INSERT INTO "BLADE_NOTIFY_TEMPLATE" ("ID", "NAME", "PROVIDER", "TYPE", "BUSINESS", "TEMPLATE", "CREATE_USER", "CREATE_DEPT", "CREATE_TIME", "UPDATE_USER", "UPDATE_TIME", "STATUS", "IS_DELETED", "TENANT_ID") VALUES ('1562981467010748418', '保养逾期', 'embedded', 'email', 'maintain-overdue', '{"subject":"保养逾期","content":"

尊敬的客户:

 ${#code} 保养计划,已经逾期${#day}天,请及时关注并处理。

设备明细:

${maintains}

","attachments":[{"name":"","location":""}]}', '1123598821738675201', '1123598813738675201', TO_DATE('2022-08-26 09:53:15', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201', TO_DATE('2022-08-26 09:53:15', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', '000000');