-- 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_ = '<p>任务创建：流程实例<a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>，执行到${nodeName}</p>' WHERE ID_ = '1';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>流程实例抄送：流程<a href=\"${baseUrl}/fvue/instance/${instId}\">${taskSubject}</a>的${instId}实例，已经抄送给您。</p>' WHERE ID_ = '10';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>流程实例结束<a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '11';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>流转撤销：流程实例：<a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>的${nodeName}流转任务，已被撤销。</p>' WHERE ID_ = '12';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>审批提醒：<br/>您有新的工作流需要审批<a href=\"${baseUrl}/fvue/task/${taskId}/0/\">${taskSubject}</a></p>' WHERE ID_ = '13';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>驳回提醒：<br/>您的<a href=\"${baseUrl}/fvue/task/${taskId}/0/\">${taskSubject}</a>请求被驳回，请处理!</p>' WHERE ID_ = '14';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>撤销提醒：<br/>审批任务<a href=\"${baseUrl}/fvue/instance/${instId}\">${taskSubject}</a>被撤销，撤销原因${cause}。</p>' WHERE ID_ = '15';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>代理任务审批：<br/>您有新的代理任务需要审批<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>，委托人${delegate}.</p>' WHERE ID_ = '16';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>流程实例结束<a href=\"${baseUrl}/fvue/instance/${instId}\">${taskSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '17';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>任务并行审批通知：<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>的${nodeName}任务，已经发起并行审批给你。</p>' WHERE ID_ = '18';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>并行审批撤销：流程实例：<a href=\"${baseUrl}/fvue/instance/${instId}\">${taskSubject}</a>的${nodeName}并行审批任务，已被撤销。</p>' WHERE ID_ = '19';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>任务沟通提醒，${receiver}您好,任务：<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>需要与您交流，请给出意见。</p>' WHERE ID_ = '2';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>流程实例已恢复运行中状态<a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '20';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>设置任务执行人：<a href=\"${baseUrl}/fvue/instance/${instId}\">${taskSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '21';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>代理通知：<br/>您的任务<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>，代理给${agent}</p>' WHERE ID_ = '3';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>沟通反馈提醒，实例<a href=\"${baseUrl}/fvue/instance/${instId}\" style=\"white-space: normal;\">${taskSubject}</a>发起的沟通，已给出意见。</p>' WHERE ID_ = '4';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>任务流转通知：<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>的${nodeName}任务，已经流转给你。</p>' WHERE ID_ = '5';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>任务转交：流程实例<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>，需要你办理。</p>' WHERE ID_ = '6';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>加签通知：<br/>${sender}邀请你参与会签任务<a href=\"${baseUrl}/fvue/task/${taskId}\">${taskSubject}</a>,加签原因:${cause}</p>' WHERE ID_ = '7';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>${nodeName}完成：流程实例: <a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>完成.</p>' WHERE ID_ = '8';
UPDATE portal_sys_msg_tpl SET HTML_ = '<p>任务驳回：流程实例<a href=\"${baseUrl}/fvue/instance/${instId}\">${instSubject}</a>，驳回原因:${cause}</p>' 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';