-- qiuxd 新聞公告文件信息字段加長 alter table PORTAL_NEWS_NOTICE_ modify FILE_ varchar(1500) null comment '文件'; -- jijx update portal_sys_column set DATA_PARAM = '{\"id\":\"1330698555119243264\",\"name\":\"新闻数量统计\",\"chartType\":2}' WHERE ALIAS = 'xwggxx'; -- jason 2020-08-02 修改消息模板中的地址 UPDATE portal_sys_msg_tpl SET HTML_ = '

任务创建：流程实例${instSubject}，执行到${nodeName}

' WHERE ID_ = '1'; UPDATE portal_sys_msg_tpl SET HTML_ = '

流程实例抄送：流程${taskSubject}的${instId}实例，已经抄送给您。

' WHERE ID_ = '10'; UPDATE portal_sys_msg_tpl SET HTML_ = '

流程实例结束${instSubject}，意见:${cause}。

' WHERE ID_ = '11'; UPDATE portal_sys_msg_tpl SET HTML_ = '

流转撤销：流程实例：${instSubject}的${nodeName}流转任务，已被撤销。

' WHERE ID_ = '12'; UPDATE portal_sys_msg_tpl SET HTML_ = '

审批提醒：
您有新的工作流需要审批${taskSubject}

' WHERE ID_ = '13'; UPDATE portal_sys_msg_tpl SET HTML_ = '

驳回提醒：
您的${taskSubject}请求被驳回，请处理!

' WHERE ID_ = '14'; UPDATE portal_sys_msg_tpl SET HTML_ = '

撤销提醒：
审批任务${taskSubject}被撤销，撤销原因${cause}。

' WHERE ID_ = '15'; UPDATE portal_sys_msg_tpl SET HTML_ = '

代理任务审批：
您有新的代理任务需要审批${taskSubject}，委托人${delegate}.

' WHERE ID_ = '16'; UPDATE portal_sys_msg_tpl SET HTML_ = '

流程实例结束${taskSubject}，意见:${cause}。

' WHERE ID_ = '17'; UPDATE portal_sys_msg_tpl SET HTML_ = '

任务并行审批通知：${taskSubject}的${nodeName}任务，已经发起并行审批给你。

' WHERE ID_ = '18'; UPDATE portal_sys_msg_tpl SET HTML_ = '

并行审批撤销：流程实例：${taskSubject}的${nodeName}并行审批任务，已被撤销。

' WHERE ID_ = '19'; UPDATE portal_sys_msg_tpl SET HTML_ = '

任务沟通提醒，${receiver}您好,任务：${taskSubject}需要与您交流，请给出意见。

' WHERE ID_ = '2'; UPDATE portal_sys_msg_tpl SET HTML_ = '

流程实例已恢复运行中状态${instSubject}，意见:${cause}。

' WHERE ID_ = '20'; UPDATE portal_sys_msg_tpl SET HTML_ = '

设置任务执行人：${taskSubject}，意见:${cause}。

' WHERE ID_ = '21'; UPDATE portal_sys_msg_tpl SET HTML_ = '

代理通知：
您的任务${taskSubject}，代理给${agent}

' WHERE ID_ = '3'; UPDATE portal_sys_msg_tpl SET HTML_ = '

沟通反馈提醒，实例${taskSubject}发起的沟通，已给出意见。

' WHERE ID_ = '4'; UPDATE portal_sys_msg_tpl SET HTML_ = '

任务流转通知：${taskSubject}的${nodeName}任务，已经流转给你。

' WHERE ID_ = '5'; UPDATE portal_sys_msg_tpl SET HTML_ = '

任务转交：流程实例${taskSubject}，需要你办理。

' WHERE ID_ = '6'; UPDATE portal_sys_msg_tpl SET HTML_ = '

加签通知：
${sender}邀请你参与会签任务${taskSubject},加签原因:${cause}

' WHERE ID_ = '7'; UPDATE portal_sys_msg_tpl SET HTML_ = '

${nodeName}完成：流程实例: ${instSubject}完成.

' WHERE ID_ = '8'; UPDATE portal_sys_msg_tpl SET HTML_ = '

任务驳回：流程实例${instSubject}，驳回原因:${cause}

' WHERE ID_ = '9'; -- qiuxd 把移动端门户我的传阅改为我的代阅 UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML = 'PGRpdiBpZD0iYXBwIj4KPGVsLXJvdyA6Z3V0dGVyPSIyMCIgc3R5bGU9InBhZGRpbmctdG9wOjZweDtwYWRkaW5nLWJvdHRvbTo1cHg7Ij4KICA8ZWwtY29sIDpzcGFuPSI4Ij4KIDxkaXY+CiAgICA8cm91dGVyLWxpbmsgdG89Ii93b3JrL215TWF0dGVycyIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19ibHVlX19iZyI+5YqePC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOW+heWKnjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teVRha3MuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgIDwvcm91dGVyLWxpbms+CiAgPC9kaXY+CiAgPC9lbC1jb2w+CiAgPGVsLWNvbCA6c3Bhbj0iOCI+CiAgICAgPGRpdj4KCSA8cm91dGVyLWxpbmsgdG89Ii93b3JrL215UmVxdWVzdCIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19waW5rX19iZyI+6K+3PC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOivt+axgjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teVJlcXVlc3QuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9teU1hdHRlcnMvMSIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19kZWVwX19ibHVlX19iZyI+5a6aPC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOW3suWKnjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teUFscmVhZHkuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgIDwvcm91dGVyLWxpbms+CiAgICA8L2Rpdj4KICA8L2VsLWNvbD4KPC9lbC1yb3c+CjxlbC1yb3cgOmd1dHRlcj0iMjAiIHN0eWxlPSJwYWRkaW5nLWJvdHRvbTo1cHg7cGFkZGluZy10b3A6IDVweDsiPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXYgPgoJIDxyb3V0ZXItbGluayB0bz0iL3dvcmsvbXlOb3RpY2UiIHRhZz0iZGl2Ij4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXIiPgogICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX195ZWxsb3dfX2JnIj7pmIU8L2Rpdj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2JveCI+IAogICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOW+hemYhTwvcD4KICAgICAgICAgICAgICAgIDxwIGNsYXNzPSJjb250YWluZXJfYm94X2NvdW50Ij4oe3tkYXRhLm15Tm90aWNlUmVhZC5kYXRhVGV4dH19KTwvcD4KICAgICAgICAgICAgPC9kaXY+CiAgICAgICAgPC9kaXY+CiAgICA8L3JvdXRlci1saW5rPgo8L2Rpdj4KICAgIAogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9NeVR1cm5PdXRMaXN0IiB0YWc9ImRpdiI+CiAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyIj4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19wdXJwbGVfX2JnIj7ovaw8L2Rpdj4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgIDxwIGNsYXNzPSJjb250YWluZXJfYm94X3RpdGxlIj7miJHnmoTovazlip48L3A+CiAgICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9zdGFydEZsb3dMaXN0IiB0YWc9ImRpdiI+CiAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyIj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2ljb24gaWNvbl9fZ3JlZW5fX2JnIj7lu7o8L2Rpdj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2JveCI+IAogICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaWsOW7uua1geeoizwvcD4KICAgICAgICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgo8L2VsLXJvdz4KPC9kaXY+' WHERE ID = '1267991710768697344';