-- qiuxd 新聞公告文件信息字段加長 ALTER TABLE PORTAL_NEWS_NOTICE_ alter COLUMN FILE_ type VARCHAR(1500) ; comment on column PORTAL_NEWS_NOTICE_.FILE_ is '附件'; -- 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}
驳回提醒:
您的${taskSubject}请求被驳回,请处理!
撤销提醒:
审批任务${taskSubject}被撤销,撤销原因${cause}。
代理任务审批:
您有新的代理任务需要审批${taskSubject},委托人${delegate}.
流程实例结束${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}
沟通反馈提醒,实例${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}
${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';