-- 赵祥云 新增待办部门信息（部门待办数量）和待办_xx部门(部门待办详情)栏目 INSERT INTO portal_sys_column (ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('1311220566576992256', '待办_技术部', 'db_jsb', '', '0', '3', '${bpmRunTime}/runtime/task/v1/getTodoList', '', NULL, '327', '/v-flow/v-todo', 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJjZW50ZXIiIHdpZHRoPSI1MCIgbGFiZWw9IuW6j+WPtyI+PC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9InByb2NJbnN0SWQiIGxhYmVsPSLmtYHnqIvnvJblj7ciIGFsaWduPSJjZW50ZXIiIHdpZHRoPSIyMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCAvPgogICAgPGVsLXRhYmxlLWNvbHVtbiBsYWJlbD0i5qCH6aKYIiBhbGlnbj0ibGVmdCIgIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSI+e3tzY29wZS5yb3cuc3ViamVjdH19PC9zcGFuPgogICAgICAgIDwvdGVtcGxhdGU+CiAgICA8L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gcHJvcD0iY3JlYXRlVGltZSIgbGFiZWw9IuWIsOi+vuaXtumXtCIgd2lkdGg9IjE1MCIgc2hvdy1vdmVyZmxvdy10b29sdGlwIGFsaWduPSJjZW50ZXIiPjwvZWwtdGFibGUtY29sdW1uPgo8L2VsLXRhYmxlPg==', '2', NULL, NULL, NULL, '', '[{"name":"pageBean","type":"string","mode":"0","value":"{\\"page\\":1,\\"pageSize\\":7,\\"total\\":0,\\"showTotal\\":false}"},{"name":"querys","type":"string","mode":"0","value":"[{\\"property\\": \\"inst.CREATE_ORG_PATH_\\", \\"value\\": \\"1306170252345872384\\", \\"group\\": \\"orgId\\", \\"operation\\": \\"LIKE\\"}]"}]', '0', NULL, NULL, NULL, '1', NULL, NULL, 'POST', '', NULL, '-1'); INSERT INTO portal_sys_column (ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('1311223536270053376', '待办部门信息', 'dbbmxx', '31081', '0', '3', '${bpmRunTime}/runtime/instance/v1/getDefaultInfoTodo', '', NULL, '80', '/v-flow/v-todo', 'PGRpdj4KCTxlbC1yb3cgOmd1dHRlcj0iMjAiIHN0eWxlPSJwYWRkaW5nLXRvcDogMTBweDtwYWRkaW5nLWJvdHRvbToxMHB4Ij4KCQk8ZWwtY29sIDpzcGFuPSIxMCIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiBAY2xpY2s9ImhhbmRsZVRvZG9MaXN0Q2xpY2soZGF0YS5qc2IpIj4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYmEoMTA0LDE5NSwyNTMsMSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiBjbGFzcz0iaWNvbi10b2RvIiBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiA4cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4KICAgICAgICAgICAgPC9zcGFuPgoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdiBzdHlsZT0iaGVpZ2h0OjE4cHg7Ij4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgyOCwyOCwyOCwxKTtsaW5lLWhlaWdodDozMHB4OyI+e3tkYXRhLmpzYi50b2RvTnVtP2RhdGEuanNiLnRvZG9OdW06JzAnfX08L3NwYW4+PC9kaXY+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDozMHB4OyI+5b6F5YqeX+aKgOacr+mDqDwvc3Bhbj48L2Rpdj4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQkJPGRpdiBzdHlsZT0iZmxvYXQ6cmlnaHQ7Ij4KICAgIDxzcGFuIGNsYXNzPSJlbC1kaXZpZGVyIGVsLWRpdmlkZXItLXZlcnRpY2FsIiBzdHlsZT0iZm9udC1zaXplOjQwcHg7Ij4KICAgICAgPC9zcGFuPgoJCQk8L2Rpdj4KCQk8L2VsLWNvbD4KCTwvZWwtcm93Pgo8L2Rpdj4=', '2', NULL, NULL, NULL, '', '[{"name":"jsb","type":"string","mode":"0","value":"\\"1306170252345872384\\""}]', '0', NULL, NULL, NULL, '1', NULL, NULL, 'POST', '默认分类', NULL, '-1'); --之前遗漏SQL -- 2020-09-28 赵祥云 流程实例表添加所属组织路径字段 alter table BPM_PRO_INST add CREATE_ORG_PATH_ varchar2(1000) / comment on column BPM_PRO_INST.create_org_path_ is '所属组织路径' / -- 2020-09-29 赵祥云 给初始化常用语添加更新时间（用更新时间升序排序） update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:10','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '6901702'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:11','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '752469'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:14','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '752475'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:13','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '8982173'; -- 修改BPM_CHECK_OPINION BPM_CHECK_OPINION_HI表字段长度限制，防止内审批人超时长度时报错 alter table BPM_CHECK_OPINION_HI drop column QUALFIEDS_; alter table BPM_CHECK_OPINION_HI add QUALFIEDS_ CLOB; alter table BPM_CHECK_OPINION_HI drop column QUALFIED_NAMES_; alter table BPM_CHECK_OPINION_HI add QUALFIED_NAMES_ CLOB; alter table BPM_CHECK_OPINION drop column QUALFIEDS_; alter table BPM_CHECK_OPINION add QUALFIEDS_ CLOB; alter table BPM_CHECK_OPINION drop column QUALFIED_NAMES_; alter table BPM_CHECK_OPINION add QUALFIED_NAMES_ CLOB; alter table BPM_TASK_NOTICE_DONE drop column QUALFIEDS_; alter table BPM_TASK_NOTICE_DONE add QUALFIEDS_ CLOB; alter table BPM_TASK_NOTICE_DONE drop column QUALFIED_NAMES_; alter table BPM_TASK_NOTICE_DONE add QUALFIED_NAMES_ CLOB; -- 张耀祥 添加一个内部消息的菜单 INSERT INTO "PORTAL_SYS_MENU" ("ID_", "PARENT_ID_", "NAME_", "ALIAS_", "ACTIVE_TAB_", "MENU_ICON_", "OPENED_", "SN_", "TABS_STYLE_", "PATH_", "HREF_", "TENANT_ID_") VALUES ( '1288290323419762688', '59217', '内部消息', 'v-messageReceiver', '', '', '1', '100', '', '-1.3.59217.1288290323419762688.', '', '-1' ); -- lingpj 2020-10-19 添加一条人员脚本 INSERT INTO BPM_MULTI_SCRIPT(ID_, ALIAS_NAME_, ALIAS_DESC_, CLASS_NAME_, CLASS_INS_NAME_, METHOD_NAME_, METHOD_DESC_, RETURN_TYPE_, ARGUMENT_, ENABLE_, TYPE_, TENANT_ID_) VALUES ('1318030354614980608', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getUserFromSubData', '从子表数据中提取节点审批人', 'java.util.Set', '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"业务对象别名"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"子表别名（sub_)"},{"paraName":"arg2","paraType":"java.lang.String","paraDesc":"用户ID字段"}]', 1, 2, NULL); insert into portal_sys_type(id_, type_group_key_, name_, type_key_, stru_type_, parent_id_, depth_, path_, is_leaf_, owner_id_, sn_, create_by_, create_time_, create_org_id_, update_by_, update_time_, icon_, tenant_id_) VALUES (31120,'TAG','表单标签','bdbq',1,11,1,'11.31120.','N','0',0,'1',null,null,null,null,'{}','-1'); insert into portal_sys_type(id_, type_group_key_, name_, type_key_, stru_type_, parent_id_, depth_, path_, is_leaf_, owner_id_, sn_, create_by_, create_time_, create_org_id_, update_by_, update_time_, icon_, tenant_id_) VALUES (31121,'TAG','应用标签','yybq',1,11,1,'11.31121.','N','0',0,'1',null,null,null,null,'{}','-1'); create table portal_app_tags_relation ( ID_ VARCHAR(50) not null, APP_ID_ VARCHAR(64) not null, TAG_ID_ VARCHAR(64) not null, TENANT_ID_ VARCHAR(64) default '-1' null, constraint portal_app_tags_relation_pk primary key (ID_) ); comment on column portal_app_tags_relation.ID_ is '主键'; comment on column portal_app_tags_relation.APP_ID_ is '应用ID'; comment on column portal_app_tags_relation.TAG_ID_ is '标签ID'; comment on column portal_app_tags_relation.TENANT_ID_ is '租户ID'; comment on table portal_app_tags_relation is '应用标签关系表'; create table portal_app_param ( ID_ VARCHAR(64) not null, NAME_ varchar(64) null, ALIAS_ varchar(64) null, CONTROL_TYPE_ VARCHAR(64) null, VALUE_ CLOB null, APP_ID_ VARCHAR(64) null, TENANT_ID_ VARCHAR(64) default -1 null, CREATE_TIME_ timestamp null, constraint portal_app_param_pk primary key (ID_) ); comment on column portal_app_param.ID_ is '主键'; comment on column portal_app_param.NAME_ is '参数名称'; comment on column portal_app_param.ALIAS_ is '参数编码'; comment on column portal_app_param.CONTROL_TYPE_ is '控件类型'; comment on column portal_app_param.VALUE_ is '参数值'; comment on column portal_app_param.APP_ID_ is '应用ID'; comment on column portal_app_param.TENANT_ID_ is '租户ID'; comment on column portal_app_param.CREATE_TIME_ is '创建时间'; comment on table portal_app_param is '应用参数表'; ALTER TABLE "FORM_DATA_TEMPLATE" ADD ("SUB_FIELD_" NCLOB); -- 邱喜达 应用中心 update portal_sys_layout_manage set DESIGN_HTML = 'eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLmiJHnmoTlvoXlip4iLCJhbGlhcyI6InZ1ZVRvZG8iLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkyMTIwMDBfODg0NzMifSwia2V5IjoiMTU5MTE0OTIxMjAwMF84ODQ3MyIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkyMTIwMDBfODg0NzMiLCJydWxlcyI6W119XX0seyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuS9k+iCsiIsImFsaWFzIjoiMTMxNDQ0NjY4NzIwNDQxMzQ0MCIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwMjIyNjE2NDAwMF8zODI2MiJ9LCJrZXkiOiIxNjAyMjI2MTY0MDAwXzM4MjYyIiwibW9kZWwiOiJ1bmRlZmluZWRfMTYwMjIyNjE2NDAwMF8zODI2MiIsInJ1bGVzIjpbXX1dfV0sIm9wdGlvbnMiOnsiZ3V0dGVyIjo1LCJqdXN0aWZ5Ijoic3RhcnQiLCJhbGlnbiI6InRvcCIsInJlbW90ZUZ1bmMiOiJmdW5jXzE1OTEwOTcxNzkwMDBfNTU1NzEifSwia2V5IjoiMTU5MTA5NzE3OTAwMF81NTU3MSIsIm1vZGVsIjoiZ3JpZF8xNTkxMDk3MTc5MDAwXzU1NTcxIiwicnVsZXMiOltdfSx7InR5cGUiOiJncmlkIiwibmFtZSI6IuagheagvOW4g+WxgCIsImljb24iOiJpY29uLWdyaWQiLCJjb2x1bW5zIjpbeyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuaIkeeahOivt+axgiIsImFsaWFzIjoidnVlTXlyZXF1ZXN0Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMTQ5MjIwMDAwXzkwMDczIn0sImtleSI6IjE1OTExNDkyMjAwMDBfOTAwNzMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTkxMTQ5MjIwMDAwXzkwMDczIiwicnVsZXMiOltdfV19LHsic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLluLjnlKjmtYHnqIsiLCJhbGlhcyI6InZ1ZU9mdGVuRmxvdyIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwMjIyODUwNzAwMF8zNDk2NiJ9LCJrZXkiOiIxNjAyMjI4NTA3MDAwXzM0OTY2IiwibW9kZWwiOiJ1bmRlZmluZWRfMTYwMjIyODUwNzAwMF8zNDk2NiIsInJ1bGVzIjpbXX1dfV0sIm9wdGlvbnMiOnsiZ3V0dGVyIjo1LCJqdXN0aWZ5Ijoic3RhcnQiLCJhbGlnbiI6InRvcCIsInJlbW90ZUZ1bmMiOiJmdW5jXzE1OTEwOTcyMDQwMDBfMTc3ODIifSwia2V5IjoiMTU5MTA5NzIwNDAwMF8xNzc4MiIsIm1vZGVsIjoiZ3JpZF8xNTkxMDk3MjA0MDAwXzE3NzgyIiwicnVsZXMiOltdfSx7InR5cGUiOiJncmlkIiwibmFtZSI6IuagheagvOW4g+WxgCIsImljb24iOiJpY29uLWdyaWQiLCJjb2x1bW5zIjpbeyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuS7u+WKoemdouadvyIsImFsaWFzIjoicndtYnZ1ZSIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTE0OTIyOTAwMF8xMjEwMSJ9LCJrZXkiOiIxNTkxMTQ5MjI5MDAwXzEyMTAxIiwibW9kZWwiOiJ1bmRlZmluZWRfMTU5MTE0OTIyOTAwMF8xMjEwMSIsInJ1bGVzIjpbXX1dfSx7InNwYW4iOjYsImxpc3QiOlt7Im5hbWUiOiLmlrDpl7vlm77niYciLCJhbGlhcyI6IjEzMTQ0NjM3MDU5NDk0MDkyODAiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDIyMjg1MTAwMDBfNjM2MSJ9LCJrZXkiOiIxNjAyMjI4NTEwMDAwXzYzNjEiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjAyMjI4NTEwMDAwXzYzNjEiLCJydWxlcyI6W119XX0seyJzcGFuIjo2LCJsaXN0IjpbeyJuYW1lIjoi5pyA5paw6aG555uuIiwiYWxpYXMiOiJ6eHhtdnVlIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTk4NDM1MTUzMDAwXzUyNjU5In0sImtleSI6IjE1OTg0MzUxNTMwMDBfNTI2NTkiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTk4NDM1MTUzMDAwXzUyNjU5IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjUsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTA5NzIyMzAwMF84MzIzNCJ9LCJrZXkiOiIxNTkxMDk3MjIzMDAwXzgzMjM0IiwibW9kZWwiOiJncmlkXzE1OTEwOTcyMjMwMDBfODMyMzQiLCJydWxlcyI6W119LHsidHlwZSI6ImdyaWQiLCJuYW1lIjoi5qCF5qC85biD5bGAIiwiaWNvbiI6Imljb24tZ3JpZCIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5YWz5LqO5oiR5LusIiwiYWxpYXMiOiJneXdtdnVlIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMTQ5MjM3MDAwXzI0OTQ1In0sImtleSI6IjE1OTExNDkyMzcwMDBfMjQ5NDUiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTkxMTQ5MjM3MDAwXzI0OTQ1IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjAsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTA5NzI0MzAwMF84MzE2NyJ9LCJrZXkiOiIxNTkxMDk3MjQzMDAwXzgzMTY3IiwibW9kZWwiOiJncmlkXzE1OTEwOTcyNDMwMDBfODMxNjciLCJydWxlcyI6W119XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19' where id = 2; -- 2020-10-19 赵祥云 表单详情表添加表单配置字段 ALTER TABLE FORM_DEFINITION ADD FORM_SETTING_ VARCHAR2(2000); -- 2020-10-21 李洪桥 电子签章 create table uc_electronic_seal ( ID_ varchar2(64) constraint UC_ELECTRONIC_SEAL_PK primary key, USER_ID_ varchar2(64), FILE_ID_ varchar2(64), PASSWORD_ varchar2(64), IS_USE_ int, CREATE_TIME_ date, UPDATE_TIME_ date, CREATE_ORG_ID_ varchar2(64), CREATE_BY_ varchar2(64), UPDATE_BY_ varchar2(64), TENANT_ID_ varchar2(64) ) / comment on table uc_electronic_seal is '电子签章' / comment on column uc_electronic_seal.ID_ is '主键ID' / comment on column uc_electronic_seal.USER_ID_ is '用户ID' / comment on column uc_electronic_seal.FILE_ID_ is '签章图片ID' / comment on column uc_electronic_seal.PASSWORD_ is '使用密码' / comment on column uc_electronic_seal.IS_USE_ is '当前是否使用 0为当前使用 1 为非当前使用' / -- 2020-10-23 lingpj 定时计划两条初始化语句调整 UPDATE "QRTZ_JOB_DETAILS" SET "JOB_DATA" = HEXTORAW('230D0A23467269204F63742032332031353A33303A30372043535420323032300D0A') WHERE "SCHED_NAME" = 'quartzScheduler' AND "JOB_NAME" = '流程定时启动任务类' AND "JOB_GROUP" = '-1'; UPDATE "QRTZ_JOB_DETAILS" SET "JOB_DATA" = HEXTORAW('230D0A23467269204F63742032332031353A33303A31312043535420323032300D0A') WHERE "SCHED_NAME" = 'quartzScheduler' AND "JOB_NAME" = '任务催办定时计划' AND "JOB_GROUP" = '-1'; -- 2020-10-27 linpj 关系矩阵添加默认分类 INSERT INTO PORTAL_SYS_TYPE(ID_, TYPE_GROUP_KEY_, NAME_, TYPE_KEY_, STRU_TYPE_, PARENT_ID_, DEPTH_, PATH_, IS_LEAF_, OWNER_ID_, SN_, CREATE_BY_, CREATE_TIME_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, ICON_, TENANT_ID_) VALUES ('1320902983285870592', 'jzfl', '默认分类', 'mrfl', '0', '1285467330515701760', 1, '1285467330515701760.1320902983285870592.', 'Y', '0', 0, '1', NULL, '', NULL, NULL, NULL, '-1'); -- 2020-10-28 lingpj 调整新闻公告url字段长度 ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY URL_ VARCHAR2(2000); -- 2020-10-28 lingpj 移动端信息台默认授权 INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1321385863887851520', '1295248036242526208', NULL, NULL, 'everyone', 'indexColumn', '-1'); -- 2020-10-29 jjx 修改人员脚本描述 update bpm_multi_script set METHOD_DESC_='获取上一节点执行人的部门负责人(主组织)' where ID_=11; -- 2020-10-29 曾善铜 修改应用中心请求链接 update portal_sys_column set DATA_FROM = '${portal}/portal/sysApp/v1/authList' where ID = '1298555788968726528'; -- 2020-10-29 jijx 修改人员脚本汇报线描述 update bpm_multi_script set ARGUMENT_='[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"","paraCtBindName":"ID_","paraCtBindKey":"","multiSelect":false}]' where ID_=12; update bpm_multi_script set ARGUMENT_='[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:yhgxflxz","paraCtBindName":"ID_","paraCtBindKey":"ID_","multiSelect":false}]' where ID_=13; -- 2020-10-29 jijx 修改人员脚本配置及说明 update bpm_multi_script set ARGUMENT_='[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"业务对象别名"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"子表别名（sub_)"},{"paraName":"arg2","paraType":"java.lang.String","paraDesc":"用户帐号字段"}]' where ID_=1318030354614980608; update bpm_multi_script set ARGUMENT_='[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织编码","paraCt":"base:org-selector","paraCtBindName":"id_","paraCtBindKey":"id","multiSelect":false,"$$hashKey":"object:645"}]' where ID_=2; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织编码","paraCt":"base:org-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"职务编码","paraCt":"base:job-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false}]' where ID_=20; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"用户id","multiSelect":false,"paraCt":"base:user-selector","paraCtBindKey":"id","paraCtBindName":"id"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=21; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=22; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=23; -- 2020-11-04 qiuxd 对话框添加组合对话框配置字段 ALTER TABLE form_custom_dialog ADD combine_config_ VARCHAR(2000); -- 2020-11-04 ZST 组合对话框覆盖更新 alter table FORM_CUSTOM_DIALOG rename column COMBINE_CONFIG_ to COMBINATION_RULE_ / -- 2020-11-5 jijx 修改人员脚本配置从子表数据中提取节点审批人的说明 update bpm_multi_script set METHOD_DESC_='从子表数据中提取节点审批人(固定值生效)' where ID_=1318030354614980608; -- 2020-11-05 wanghb BPM_PRO_INST添加BPMN_INST_ID_唯一索引 CREATE UNIQUE INDEX "IDX_PRO_INST_BPMNINSTID" ON "BPM_PRO_INST" ("BPMN_INST_ID_"); -- 2020-11-04 赵祥云 新增常用流程授权对象表 CREATE TABLE bpm_often_flow_user ( ID_ varchar2(64) not null, OFTEN_FLOW_ID_ varchar2(64) null, OWNER_ID_ varchar2(64) null, OWNER_NAME_ varchar2(128) null, RIGHT_TYPE_ varchar2(20) null, TENANT_ID_ varchar2(255) null, constraint bpm_often_flow_user_pk primary key (ID_) ); -- 2020-11-05 赵祥云 修改常用流程表字段信息设置USER_ID_和USER_NAME_可以为空 alter table bpm_often_flow modify USER_ID_ null; alter table bpm_often_flow modify USER_NAME_ null; -- 2020-11-5 zhangxw 修改日志表操作名称字段长度 ALTER TABLE "PORTAL_SYS_LOGS" MODIFY ("OPE_NAME_" VARCHAR2(500 BYTE)); -- 2020-11-07 wanghb 调整表单元数据name字段长度 ALTER TABLE FORM_META MODIFY NAME_ VARCHAR2(128); -- oracle 添加默认应用分类 INSERT INTO "PORTAL_SYS_MENU"("ID_", "PARENT_ID_", "NAME_", "ALIAS_", "ACTIVE_TAB_", "MENU_ICON_", "OPENED_", "SN_", "TABS_STYLE_", "PATH_", "HREF_", "TENANT_ID_") VALUES ('1324959516441317376', '4', '默认分类', 'default', '', '', NULL, 2, '', '-1.4.1324959516441317376.', '', '-1'); -- jjx 2020-11-9 修改人员脚本配置内容在oracle下不显示问题 UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[ {"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织ID","paraCt":"base:org-selector","paraCtBindName":"组织ID","paraCtBindKey":"id","multiSelect":false,"$$hashKey":"object:3067"},{"paraName":"arg1","paraType":"java.lang.Boolean","paraDesc":"是否主负责人","paraCt":null,"paraCtBindName":"","paraCtBindKey":null,"multiSelect":false,"$$hashKey":"object:3068"}]' WHERE ID_ = '10'; UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"","paraCtBindName":"ID_","paraCtBindKey":"","multiSelect":false}]' WHERE ID_ = '12'; UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:yhgxflxz","paraCtBindName":"ID_","paraCtBindKey":"ID_","multiSelect":false}]' WHERE ID_ = '13'; UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"业务对象别名"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"子表别名（sub_)"},{"paraName":"arg2","paraType":"java.lang.String","paraDesc":"用户帐号字段"},{"paraName":"arg3","paraType":"java.lang.String","paraDesc":"用户名字段"}]' WHERE ID_ = '1318030354614980608'; UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织编码","paraCt":"base:org-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"职务编码","paraCt":"base:job-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false}]' WHERE ID_ = '20'; UPDATE BPM_MULTI_SCRIPT SET ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"用户id","multiSelect":false,"paraCt":"base:user-selector","paraCtBindKey":"id","paraCtBindName":"id"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' WHERE ID_ = '21'; -- zhangxw 2020-11-12 添加汇报线选择器并更新至汇报线相关人员脚本 INSERT INTO form_custom_dialog(ID_, NAME_, ALIAS_, STYLE_, OBJ_NAME_, NEED_PAGE_, PAGE_SIZE_, DISPLAYFIELD_, CONDITIONFIELD_, RESULTFIELD_, SORTFIELD_, DSALIAS_, IS_TABLE_, DIY_SQL_, SQL_BUILD_TYPE_, WIDTH_, HEIGHT_, SELECT_NUM_, SYSTEM_, PARENT_CHECK_, CHILDREN_CHECK_, DS_TYPE_, URL_, REQUEST_TYPE_, DATA_PARAM_, PAGE_KEY_, PAGESIZE_KEY_, TOTAL_KEY_, LIST_KEY_, TENANT_ID_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, HEADER_) VALUES ('1326830804449497088', '汇报线选择器', 'reportLine', 1, 'portal_sys_type', 1, NULL, '{"isScript":false,"id":"ID_","pid":"PARENT_ID_","pvalue":"12","displayName":"NAME_"}', '[{"field":"TYPE_GROUP_KEY_","comment":"所属分类组业务主键","condition":"EQ","dbType":"varchar","defaultType":"2","defaultValue":"REPORT_LINE"}]', '[{"field":"ID_","comment":"ID_","idKey":"0","AggFuncOp":"","columnType":"varchar"},{"field":"NAME_","comment":"NAME_","idKey":"0","AggFuncOp":"","columnType":"varchar"},{"field":"TYPE_KEY_","comment":"TYPE_KEY_","idKey":"0","AggFuncOp":"","columnType":"varchar"}]', '[]', 'LOCAL', 1, NULL, 0, 800, 600, 1, 0, NULL, NULL, 'dataSource', NULL, 'POST', NULL, 'page', 'pageSize', 'total', 'rows', '-1', '1', '1', '', NULL); UPDATE bpm_multi_script SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:reportLine","paraCtBindName":"ID_","paraCtBindKey":"TYPE_KEY_","multiSelect":false}]' WHERE METHOD_NAME_ = 'getByRelPreNode'; UPDATE bpm_multi_script SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:reportLine","paraCtBindName":"ID_","paraCtBindKey":"TYPE_KEY_","multiSelect":false}]' WHERE METHOD_NAME_ = 'getByRelStartUser'; -- zhangxw 2020-11-16 更新消息模板中html链接地址（查看消息时，点击标题链接到对应页面） UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

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

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

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

' WHERE ID_ = '2'; 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'; 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_ = '

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

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

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

' WHERE ID_ = '21'; -- 2020-11-17 lingpj 调整修改原因字段长度 ALTER TABLE BPM_FORM_MODIFY_RECORD RENAME COLUMN REASON_ TO REASON_BAK_; ALTER TABLE BPM_FORM_MODIFY_RECORD ADD REASON_ CLOB; UPDATE BPM_FORM_MODIFY_RECORD SET REASON_=REASON_BAK_; COMMIT; ALTER TABLE BPM_FORM_MODIFY_RECORD DROP COLUMN REASON_BAK_; -- 2020-11-18 heyf 在form_key上添加索引 CREATE INDEX INDEX_FORMTEMP_FORMKEY ON FORM_DATA_TEMPLATE (FORM_KEY_); -- 2020-11-23 赵祥云 新增流程实例状态排序表 CREATE TABLE BPM_PRO_INST_STATUS ( ID_ VARCHAR2(64) NOT NULL, KEY_ VARCHAR2(255) DEFAULT NULL, VALUE_ VARCHAR2(255) DEFAULT NULL, CONSTRAINT PK_BPM_PRO_INST_STATUS PRIMARY KEY (ID_) ); COMMENT ON COLUMN BPM_PRO_INST_STATUS.KEY_ IS '流程实例状态'; COMMENT ON COLUMN BPM_PRO_INST_STATUS.VALUE_ IS '流程实例状态对应的排序号'; -- 2020-11-23 赵祥云 初始化流程实例状态排序表数据 INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('1', 'draft', '1'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('2', 'revoke', '2'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('3', 'back', '3'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('4', 'backToStart', '4'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('5', 'running', '5'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('6', 'manualend', '6'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('7', 'end', '7'); -- 2020-11-23 lingpj oracle 驳回报错问题 外键级联删除 没有设置 ALTER TABLE "ACT_RU_TASK" DROP CONSTRAINT "ACT_FK_TASK_EXE"; ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_EXE" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- 2020-11-23 邱喜达 修改自定义图标sortField类型 ALTER TABLE form_custom_chart MODIFY SORTFIELD_ VARCHAR2(4000); -- 增加新闻分类信息-lucong INSERT INTO PORTAL_NEWS_TREE_(ID_, NAME_, PATH_, PARENT_ID_, RANK_, SN_, PARENT_NAME_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, COL_HEIGHT_, COLUMN_ID_, INTERVAL_TIME_, MOBILE_ISSUE_) VALUES ('1325679193043898368', '宏天软件', '100.1325679193043898368.', '100', 2, 1, '新闻公告', '-1', NULL, '1', NULL, NULL, 100, NULL, NULL, 0); INSERT INTO PORTAL_NEWS_TREE_(ID_, NAME_, PATH_, PARENT_ID_, RANK_, SN_, PARENT_NAME_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, COL_HEIGHT_, COLUMN_ID_, INTERVAL_TIME_, MOBILE_ISSUE_) VALUES ('1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '1325679193043898368', 3, NULL, '宏天软件', '-1', NULL, '1', NULL, '1', 0, '1325681915189137408', NULL, 1); INSERT INTO PORTAL_NEWS_TREE_(ID_, NAME_, PATH_, PARENT_ID_, RANK_, SN_, PARENT_NAME_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, COL_HEIGHT_, COLUMN_ID_, INTERVAL_TIME_, MOBILE_ISSUE_) VALUES ('1325679288829218816', '宏天软件', '200.1325679288829218816.', '200', 2, 1, '轮播图', '-1', NULL, '1', NULL, NULL, 0, NULL, NULL, 0); INSERT INTO PORTAL_NEWS_TREE_(ID_, NAME_, PATH_, PARENT_ID_, RANK_, SN_, PARENT_NAME_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, COL_HEIGHT_, COLUMN_ID_, INTERVAL_TIME_, MOBILE_ISSUE_) VALUES ('1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '1325679288829218816', 3, 1, '宏天软件', '-1', NULL, '1', NULL, '1', 100, '1330699934319644672', 0, 0); INSERT INTO PORTAL_NEWS_TREE_(ID_, NAME_, PATH_, PARENT_ID_, RANK_, SN_, PARENT_NAME_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, COL_HEIGHT_, COLUMN_ID_, INTERVAL_TIME_, MOBILE_ISSUE_) VALUES ('1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '1325679288829218816', 3, 2, '宏天软件', '-1', NULL, '1', NULL, '1', 100, '1330747571286708224', NULL, 0); -- 插入新闻公告附件 lucong INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('1', NULL, '产品中心', NULL, 'folder', 'images\\one.png', NULL, 262022, 'png', '255.88 KB', '1', '超级管理员', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('2', NULL, '我们的产品', NULL, 'folder', 'images\\two.png', NULL, 153785, 'png', '150.18 KB', '1', '超级管理员', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('3', NULL, '客户案例', NULL, 'folder', 'images\\three.png', NULL, 281358, 'png', '274.76 KB', '1', '超级管理员', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('4', NULL, '解决方案', NULL, 'folder', 'images\\four.png', NULL, 283864, 'png', '277.21 KB', '1', '超级管理员', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('5', NULL, '业务咨询', NULL, 'folder', 'images\\five.png', NULL, 14812, 'png', '14.46 KB', '1', '超级管理员', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO PORTAL_SYS_FILE(ID_, XB_TYPE_ID_, FILE_NAME_, FILE_TYPE_, STORE_TYPE_, FILE_PATH_, BYTES_, BYTE_COUNT_, EXT_, NOTE_, CREATE_BY_, CREATOR_NAME_, CREATE_TIME_, IS_DEL_, PROP1_, PROP2_, PROP3_, PROP4_, PROP5_, PROP6_, TYPE_, TENANT_ID_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_) VALUES ('6', NULL, '费用预算明细表_导入模板', NULL, 'folder', 'images\\six.png', NULL, 5632, 'xls', '5.50 KB', '1324559179100327936', 'yh1', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); -- 插入新闻公告内容 lucong INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1325679810151845888', '1325679230087991296', '知识必读', '100.1325679193043898368.1325679230087991296.', '宏天软件EIP产品帮助说明', 'true', 'http://www.hotent.org:5171/eip_saas/', NULL, 1, NULL, NULL, '', '800', '-1', NULL, '1', NULL, '1', 2, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1325680074938257408', '1325679230087991296', '知识必读', '100.1325679193043898368.1325679230087991296.', '小宏来帮您', 'true', 'https://bot.4paradigm.com/web/chat/14420/510cee75-4203-4966-888f-850abcd8da9c', NULL, 2, NULL, NULL, '', '800', '-1', NULL, '1', NULL, '1', 2, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1325681305643520000', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '版本更新说明', 'true', 'http://www.hotent.org:5171/eip_saas/mdFile/update/eip_saas_725.html', NULL, 3, NULL, NULL, '', '800', '-1', NULL, '1', NULL, '1', 2, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1325681714877566976', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '欢迎了解宏天软件', 'true', 'https://www.hotent.com/', NULL, 4, NULL, NULL, '', '800', '-1', NULL, '1', NULL, '1', 2, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1325681895811452928', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '宏天软件最新产品试用', 'true', 'http://sso.hotent.com/login', NULL, 5, NULL, NULL, '', '800', '-1', NULL, '1', NULL, '1', 2, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330711296110366720', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '产品中心', 'false', 'https://www.hotent.com/products.html', '

联系我们

020-89089123

邮　　箱：hotent@jee-soft.cn

技术Q群：142215631

地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室

邮政编号：510308

传真号码：020-89089366


', 0, NULL, '3', NULL, '800', '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330711456060149760', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '解决方案', 'true', 'https://www.hotent.com/solutions.html', NULL, 0, NULL, '1', NULL, '800', '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330712214058962944', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '客户案例', 'true', 'https://www.hotent.com/case.html', NULL, 0, NULL, '2', NULL, '800', '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330747232420499456', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '商务咨询', 'false', NULL, '

联系我们

020-89089123

邮　　箱：hotent@jee-soft.cn

技术Q群：142215631

地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室

邮政编号：510308

传真号码：020-89089366

', 3, NULL, '6', NULL, NULL, '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330747415233433600', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '客户墙', 'false', NULL, '

越来越多的大公司愿意与宏天合作


传统&高科制造

辽宁忠旺集团有限公司 

广东科达洁能股份有限公司 

金鹏电子信息机器有限公司 

中国万向控股有限公司

纳思达股份有限公司

江门大长江集团

华润三九医药股份有限公司

香港澳美制药集团

深圳市汇顶科技股份有限公司

欧派集团

富士康集团

兴奇集团（广东兴奇金属有限公司）

武汉武船信息集成有限公司

广东芯智慧科技有限公司（保利地产） 

宝时得机械（中国）有限公司 

浙江美华包装机械有限公司

北京工大智源科技发展有限公司 

江苏凯路威电子有限公司

北京索德电气工业有限公司 

河南思维自动化设备股份有限公司

合肥开元精密工程有限责任公司 

东聚电子电讯制品有限公司 

施耐德（广州）母线有限公司  

通信运营

中国电信股份有限公司 

卓望数码技术（深圳）有限公司

大唐软件技术股份有限公司

广州从兴电子开发有限公司

爱立信

深圳天珑移动技术股份有限公司

福建福诺移动通信技术有限公司

江苏怡丰通信设备有限公司 

长春市杰迅联合通信网络有限公司 

深圳市讯方通信技术有限公司 

宁波市安贞信息科技有限公司 

四川川大金键信息产业有限责任公司 

湖南创发天辰科技有限责任公司

军工航空航天

航天科工集团

航天恒星科技有限公司 

中国航空无线电电子研究所 

航天云网科技发展有限责任公司

北京仿真中心

航天软件评测中心

海南航空股份有限公司

金融证券

深圳证券交易所

中信集团

华泰联合证券有限责任公司

前海股权交易中心 

易智付科技（北京）有限公司

深圳前海大道金融服务有限公司 

深圳市金斧子网络科技有限公司

厦门弘信创业工场投资集团股份有限公司 

政府&公共单位

中央国债登记结算有限责任公司 

农业部渔业渔政管理局 

国家知识产权中心，中船，武船

', 1, NULL, '4', NULL, NULL, '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); UPDATE PORTAL_NEWS_NOTICE_ set CONTENT_=CONCAT(CONTENT_,'

兰州市政府 ，绍兴市政府，武汉城管局

北京交通大学，昆明铁路局

北京师范大学、北京工业大学

西北民族大学 、吉林大学 

哈尔滨工程大学

广东职业技术学院

中科院深圳先进技术研究院 

深圳市深圳通有限公司 

哈尔滨交研交通工程有限责任公司 

能源电力

国家电网，南方电网

东莞供电局，东莞电力设计院

广东电网公司电力科学研究院

国家核电示范基地有限公司

西部管道公司，山东能源集团

山西冀中能源集团

新疆石油勘察设计研究院 

秦皇岛晨砻信息科技有限公司

快消&零售物流

中国邮政

顺丰集团

万达集团

上海旭辉集团

茂业百货集团

天河城、天虹

印力地产

太平洋百货

银泰百货、同仁堂

深圳海雅集团

深圳海岸城集团

深圳市安亿通科技发展有限公司 

天津煊塬科技有限公司 

邯郸市帅先电子有限公司 

武汉锐昊泰科技有限公司 

哈尔滨金地多维科技发展有限公司 

佛山市科瑞森科技有限公司 

黑龙江长周科技有限公司 

沈阳艾尔时代科技发展有限公司 

广州市睿志信息科技有限公司

深圳天珑移动技术股份有限公司

北京灵信互动信息技术有限公司

新疆信智远达信息技术有限公司

北京旋极信息技术股份有限公司

深圳普华春天科技发展有限公司 

深圳市前海圆舟网络科技股份有限公司

深圳国泰安教育技术股份有限公司

广州佰仲企业管理顾问有限公司 

北京行智信天成咨询有限责任公司 

广东地球村计算机系统有限公司

内蒙古坤兰科技有限责任公司 

南京英派电子科技有限公司 

广州联奕信息科技有限公司

广东金质信息技术有限公司 

北京腾信软创科技有限公司 

北京新锐创想科技有限公司

黑龙江长周科技有限公司 

乌鲁木齐俊涛伟业科技有限公司

河南软信科技有限公司

长春雅森达科技有限责任公司

福建福诺移动通信技术有限公司

大唐云动力科技股份有限公司 

辽宁同泽通信技术有限公司 

成都汇码科技有限公司

广东凤凰高科电子商务有限公司

江西泰豪信息技术有限公司

人网(北京）信息科技有限公司





') WHERE ID_ = '1330747415233433600'; UPDATE PORTAL_NEWS_NOTICE_ set CONTENT_=CONCAT(CONTENT_,'

苏酒集团

绍兴商盈服饰有限公司 

全领域合作客户——IT&互联网


中国电子系统技术有限公司

中国软件与技术服务股份有限公司

北京太极信息系统技术有限公司

大唐软件技术股份有限公司

广州从兴电子开发有限公司

北京北科维拓科技有限公司

西安未来国际信息股份有限公司 

易智付科技（北京）有限公司

卓望数码技术（深圳）有限公司

中信网络科技有限公司

广州粤能信息技术有限公司 

深圳市金斧子网络科技有限公司

北京天下图数据技术有限公司

湖南长信畅中科技股份有限公司

江苏华生恒业科技有限公司

捷达世软件（深圳）有限公司

象翌微链科技发展有限公司

上海亚太计算机信息系统有限公司

山西精英科技股份有限公司 

深圳市中博科创信息技术有限公司

易云捷讯科技（北京）股份有限公司

石家庄惠远邮电设计咨询有限公司

秦皇岛晨砻信息科技有限公司

成都依能科技股份有限公司

山东潍科软件科技有限公司

腾讯科技（深圳）有限公司

德勤管理咨询（上海）有限公司 

武汉武船信息集成有限公司

首都信息发展股份有限公司

湖南湘邮科技股份有限公司

湖南新云网科技有限公司

团车互联网信息服务（北京）有限公司

湖南大洋有限公司 

北京爱迪思维科技发展有限公司

北京信普达系统工程有限公司

天津中软软件系统有限公司 

海南残友科技发展有限公司（大德宝）

北京长远视通科技有限公司 

广东益泰达科技发展有限公司

山东新海软件股份有限公司 

厦门福旺达信息科技有限公司 

河北汉佳电子科技有限公司 

北京国研网络数据科技有限公司

北京天作科技有限公司 

广东汇卡商务服务有限公司

镇江市新创计算机系统集成有限公司 

厦门微谷信息技术有限公司 

昆山百润科技有限公司 

兰州北科维拓科技股份有限公司 

吉林省纵横软件开发有限公司 

中电智绘系统技术有限公司

正方软件股份有限公司 

广州博纳信息技术有限公司

大连创盛科技有限公司 

深圳市共济科技股份有限公司 

海南信息岛技术服务中心有限公司 

广州联奕信息科技有限公司

北京北斗兴业信息技术有限公司

河南思维自动化设备股份有限公司

南京英派电子科技有限公司

内蒙古坤兰科技有限责任公司 

广州智算信息技术有限公司

深圳市奥宇节能技术股份有限公司 

') WHERE ID_ = '1330747415233433600'; INSERT INTO PORTAL_NEWS_NOTICE_(ID_, CLASSIFY_ID_, CLASSIFY_NAME_, CLASSIFY_PATH_, TITLE_, IS_URL_, URL_, CONTENT_, SN_, END_TIME_, ROTATING_DISPLAY_PICTURES_, TITLE_DESCRIPTION_, PAGE_HEIGHT_, TENANT_ID_, CREATE_TIME_, CREATE_BY_, UPDATE_TIME_, UPDATE_BY_, TYPE_, ICON_, FILE_, DRAFTER_) VALUES ('1330747528550944768', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '核心功能', 'false', NULL, '

我们可以是：

移动端

门户平台

表单引擎

流程引擎

用户中心

快速开发平台


', 2, NULL, '5', NULL, NULL, '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏'); -- 增加移动端栏目-lucong INSERT INTO PORTAL_SYS_NEWS_COLUMN(ID_, PORTAL_NEWS_ID_, NAME_, TYPE_, TENANT_ID_) VALUES ('1330779070446833664', '1325679230087991296', '系统帮助', '0', '-1'); INSERT INTO PORTAL_SYS_NEWS_COLUMN(ID_, PORTAL_NEWS_ID_, NAME_, TYPE_, TENANT_ID_) VALUES ('1330779114596077568', '1330747098659950592', '宏天信息', '1', '-1'); -- 增加数据报表 INSERT INTO FORM_CUSTOM_CHART(ID_, NAME_, ALIAS_, STYLE_, OBJ_NAME_, DISPLAYFIELD_, CONDITIONFIELD_, RESULTFIELD_, SORTFIELD_, DSALIAS_, IS_TABLE_, DIY_SQL_, WIDTH_, HEIGHT_, XAXIS_FIELD_, YAXIS_UNIT_, CONF_, TENANT_ID_, CREATE_TIME_, UPDATE_TIME_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_) VALUES ('1330698555119243264', '新闻数量统计', 'xwsltj', 1, NULL, '[{"comment":"数量","dbType":"bigint","field":"NO","nameKey":"0","type":"line","yAxis":1}]', '[]', NULL, '[]', 'LOCAL', 2, 'select classify_name_,count(classify_name_) as no from portal_news_notice_ group by classify_name_', 400, 200, '[{"comment":"新闻类型","dbType":"varchar","field":"CLASSIFY_NAME_","nameKey":"0"}]', NULL, '{"maxLength":0,"yMin":"1","xShowAll":"1","theme":"default","title":{"show":true,"textStyle":{"fontStyle":"normal","fontFamily":"sans-serif","fontSize":18},"subtext":"","left":"auto","top":"auto"},"legend":{"show":true,"type":"plain","left":"auto","top":"auto","orient":"horizontal"},"series":{"doubleYAxis":true,"stack":false,"showType":true,"smooth":true,"dataZoom":false}}', '-1', NULL, NULL, '1', NULL, ''); -- 调整门户默认栏目-lucong UPDATE PORTAL_SYS_COLUMN SET COL_HEIGHT = 300 WHERE ID = '1267768754310352896'; UPDATE PORTAL_SYS_COLUMN SET COL_HEIGHT = 200 WHERE ID = '1267776505338007552'; UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJsZWZ0IiBsYWJlbD0i5bqP5Y+3Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gbGFiZWw9Iuagh+mimCIgYWxpZ249ImxlZnQiIHdpZHRoPSIzMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSI+e3tzY29wZS5yb3cuc3ViamVjdH19PC9zcGFuPgogICAgICAgIDwvdGVtcGxhdGU+CiAgICA8L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gcHJvcD0iY3JlYXRlVGltZSIgbGFiZWw9IuWIsOi+vuaXtumXtCIgc2hvdy1vdmVyZmxvdy10b29sdGlwIGFsaWduPSJsZWZ0Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gd2lkdGg9IjkwIiBhbGlnbj0ibGVmdCIgbGFiZWw9Iuexu+WeiyI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9Insgcm93IH0iPgogICAgICAgICAgICAgIDxzcGFuIHNpemU9InNtYWxsIiBjbGFzcz0iYmx1ZS1jb2xvciI+e3sKICAgICAgICAgICAgICAgIHN0YXR1c1tyb3cuc3RhdHVzXSArCiAgICAgICAgICAgICAgICAocm93Lmluc3RJc0ZvcmJpZGRlbiA9PT0gIjEiID8gIijmjILotbcpIiA6ICIiKQogICAgICAgICAgICAgIH19PC9zcGFuPgogICAgICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CjwvZWwtdGFibGU+' WHERE ALIAS = 'vueTodo'; INSERT INTO PORTAL_SYS_COLUMN(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('18', '系统帮助', '1325679230087991296', '31081', 0, NULL, '', '', NULL, 300, '/newsList/1325679230087991296', 'PGhvbWUtbmV3cy1saXN0IGNsYXNzaWZ5SWQ9JzEzMjU2NzkyMzAwODc5OTEyOTYnLz4=', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1'); INSERT INTO PORTAL_SYS_COLUMN(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('19', '宏天软件', '1330698840872980480', '31081', 0, NULL, '', '', NULL, 200, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDY5ODg0MDg3Mjk4MDQ4MCcgOmludGVydmFsPScwJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1'); INSERT INTO PORTAL_SYS_COLUMN(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('20', '新闻公告信息', 'xwggxx', '31081', 4, NULL, '', '', NULL, 300, '', '', 2, NULL, NULL, NULL, '', '{"id":"1330698555119243264","name":"新闻数量统计","chartType":2}', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1'); INSERT INTO PORTAL_SYS_COLUMN(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('21', '宏天信息', '1330747098659950592', '31081', 0, NULL, '', '', NULL, 300, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDc0NzA5ODY1OTk1MDU5MicgOmludGVydmFsPSdudWxsJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1'); INSERT INTO PORTAL_SYS_COLUMN(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('22', '常用系统', 'cyxt', '31081', 0, NULL, '', '', NULL, 80, '', 'PGRpdiBzdHlsZT0idGV4dC1hbGlnbjpjZW50ZXIiPgoJPGVsLXJvdyA6Z3V0dGVyPSIyMCIgc3R5bGU9InBhZGRpbmctdG9wOiAxMHB4O3BhZGRpbmctYm90dG9tOjEwcHg7Ij4KCgkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tJywnJywnJyk7Ij4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOiMwZjBjZTg7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTRweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgRSAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCQkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+RVJQ566h55CG57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6IzI5MjkyOTtib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxNHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBQICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+UE3ns7vnu588L3NwYW4+PC9kaXY+CgkJCQk8L2Rpdj4KCQkJPC9kaXY+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OnJpZ2h0OyI+CiAgICA8c3BhbiBjbGFzcz0iZWwtZGl2aWRlciBlbC1kaXZpZGVyLS12ZXJ0aWNhbCIgc3R5bGU9ImZvbnQtc2l6ZTo0MHB4OyI+CiAgICAgIDwvc3Bhbj4KCQkJPC9kaXY+CgkJPC9lbC1jb2w+CgkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDojYTUwMTAxO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgICAgPHNwYW4gIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDE0cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4gIEsgIDwvc3Bhbj4KICAgICAgICAgICAgCgkJCQk8L2Rpdj4KCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPktN57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJw', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1'); UPDATE PORTAL_SYS_COLUMN set TEMPLATE_HTML=CONCAT(TEMPLATE_HTML,'YWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6IzI4NTgwMztib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxMnB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBDICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+Q1JN57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOiM4YTA0Njc7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTBweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgTyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPk9B57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDojMDg3NGIzO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgICAgPHNwYW4gIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDE0cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4gIFQgIDwvc3Bhbj4KICAgICAgICAgICAgCgkJCQk8L2Rpdj4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDo4cHg7Ij4KCQkJCQk8ZGl2PiA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjIwcHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDQwLDQxLDQxLDEpO2xpbmUtaGVpZ2h0OjMwcHg7Ij5UQVNL57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJCQk8ZWwtY29sIDpzcGFuPSIzIiBzdHlsZT0icGFkZGluZy10b3A6NXB4Ij4KCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsiICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tJywnJywnJyk7Ij4KCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYigxMjUgMTQgMTUyKTtib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxNHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBFICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRk') WHERE ID = '22'; UPDATE PORTAL_SYS_COLUMN set TEMPLATE_HTML=CONCAT(TEMPLATE_HTML,'aW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+RUlQPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6cmdiKDEyOCAxMzAgOSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTRweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgSyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPktQSTwvc3Bhbj48L2Rpdj4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQoJCTwvZWwtY29sPgoJPC9lbC1yb3c+CjwvZGl2PgoK') WHERE ID = '22'; INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('18', '18', NULL, NULL, 'everyone', 'indexColumn', '-1'); INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('19', '19', NULL, NULL, 'everyone', 'indexColumn', '-1'); INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('20', '20', NULL, NULL, 'everyone', 'indexColumn', '-1'); INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('21', '21', NULL, NULL, 'everyone', 'indexColumn', '-1'); INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('22', '22', NULL, NULL, 'everyone', 'indexColumn', '-1'); delete from PORTAL_SYS_AUTH_USER where AUTHORIZE_ID_ not in (select id from portal_sys_column); -- 调整应用端默认门户-lucong UPDATE PORTAL_SYS_LAYOUT_MANAGE set DESIGN_HTML='eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjAsImxpc3QiOlt7Im5hbWUiOiJiYW5uZXIiLCJhbGlhcyI6IjEzMzA2OTg4NDA4NzI5ODA0ODAiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA4MDcwMDBfNzcxMjcifSwia2V5IjoiMTYwNjEwMDgwNzAwMF83NzEyNyIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDcwMDBfNzcxMjciLCJydWxlcyI6W119XX0seyJzcGFuIjo0LCJsaXN0IjpbeyJuYW1lIjoi5bi455So5rWB56iLIiwiYWxpYXMiOiJ2dWVPZnRlbkZsb3ciLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTY1NzIwMDBfNjc4NTgifSwia2V5IjoiMTYwNjA5NjU3MjAwMF82Nzg1OCIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTY1NzIwMDBfNjc4NTgiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2NTY1MDAwXzYyNjkxIn0sImtleSI6IjE2MDYwOTY1NjUwMDBfNjI2OTEiLCJtb2RlbCI6ImdyaWRfMTYwNjA5NjU2NTAwMF82MjY5MSIsInJ1bGVzIjpbXX0seyJuYW1lIjoi5bi455So57O757ufIiwiYWxpYXMiOiJjeXh0Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTMwMzY5MDAwXzI4ODUzIn0sImtleSI6IjE2MDYxMzAzNjkwMDBfMjg4NTMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTMwMzY5MDAwXzI4ODUzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjEwMDgwNDAwMF8xNzA2In0sImtleSI6IjE2MDYxMDA4MDQwMDBfMTcwNiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDQwMDBfMTcwNiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLmiJHnmoTlvoXlip4iLCJhbGlhcyI6InZ1ZVRvZG8iLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA3NTQwMDBfMzA1NzYifSwia2V5IjoiMTYwNjEwMDc1NDAwMF8zMDU3NiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA3NTQwMDBfMzA1NzYiLCJydWxlcyI6W119XX0seyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuaWsOmXu+WFrOWRiuS/oeaBryIsImFsaWFzIjoieHdnZ3h4Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTAwNzU5MDAwXzE0MDQ0In0sImtleSI6IjE2MDYxMDA3NTkwMDBfMTQwNDQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTAwNzU5MDAwXzE0MDQ0IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjUsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjA5NjU5NzAwMF81NTQ1MCJ9LCJrZXkiOiIxNjA2MDk2NTk3MDAwXzU1NDUwIiwibW9kZWwiOiJncmlkXzE2MDYwOTY1OTcwMDBfNTU0NTAiLCJydWxlcyI6W119LHsidHlwZSI6ImdyaWQiLCJuYW1lIjoi5qCF5qC85biD5bGAIiwiaWNvbiI6Imljb24tZ3JpZCIsImNvbHVtbnMiOlt7InNwYW4iOjE4LCJsaXN0IjpbeyJuYW1lIjoi57O757uf5biu5YqpIiwiYWxpYXMiOiIxMzI1Njc5MjMwMDg3OTkxMjk2Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2MDQ4MDAwXzUxNzYzIn0sImtleSI6IjE2MDYwOTYwNDgwMDBfNTE3NjMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2MDQ4MDAwXzUxNzYzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLku7vliqHpnaLmnb8iLCJhbGlhcyI6InJ3bWJ2dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODAwMDBfMzQ4MyJ9LCJrZXkiOiIxNjA2MDk2MDgwMDAwXzM0ODMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2' WHERE ID = '2'; UPDATE PORTAL_SYS_LAYOUT_MANAGE set DESIGN_HTML=CONCAT(DESIGN_HTML,'MDgwMDAwXzM0ODMiLCJydWxlcyI6W119XX0seyJzcGFuIjo2LCJsaXN0IjpbeyJuYW1lIjoi5a6P5aSp5L+h5oGvIiwiYWxpYXMiOiIxMzMwNzQ3MDk4NjU5OTUwNTkyIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTA5OTUyMDAwXzcyNjM0In0sImtleSI6IjE2MDYxMDk5NTIwMDBfNzI2MzQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTA5OTUyMDAwXzcyNjM0IiwicnVsZXMiOltdfSx7Im5hbWUiOiLmnIDmlrDpobnnm64iLCJhbGlhcyI6Inp4eG12dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODIwMDBfMjc5MzUifSwia2V5IjoiMTYwNjA5NjA4MjAwMF8yNzkzNSIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTYwODIwMDBfMjc5MzUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA1NTk2NDIyMDAwXzI1MDgyIn0sImtleSI6IjE2MDU1OTY0MjIwMDBfMjUwODIiLCJtb2RlbCI6ImdyaWRfMTYwNTU5NjQyMjAwMF8yNTA4MiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d212dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkyMzcwMDBfMjQ5NDUifSwia2V5IjoiMTU5MTE0OTIzNzAwMF8yNDk0NSIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkyMzcwMDBfMjQ5NDUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6MCwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMDk3MjQzMDAwXzgzMTY3In0sImtleSI6IjE1OTEwOTcyNDMwMDBfODMxNjciLCJtb2RlbCI6ImdyaWRfMTU5MTA5NzI0MzAwMF84MzE2NyIsInJ1bGVzIjpbXX1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0=') WHERE ID = '2'; -- 2020-11-25 jjx 删除人员脚本中与下属管理相关的配置 delete from bpm_multi_script where ID_ = 21; delete from bpm_multi_script where ID_ = 22; delete from bpm_multi_script where ID_ = 23; -- 2020-11-25 曾善铜 门户栏目更新 update portal_sys_column set TEMPLATE_HTML = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJsZWZ0IiBsYWJlbD0i5bqP5Y+3Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gbGFiZWw9Iuagh+mimCIgYWxpZ249ImxlZnQiIHdpZHRoPSIzMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSIgQGNvbnRleHRtZW51LnByZXZlbnQ9ImhhbmRsZVRvZG9DbGljayhzY29wZS5yb3csdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9ImNyZWF0ZVRpbWUiIGxhYmVsPSLliLDovr7ml7bpl7QiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCBhbGlnbj0ibGVmdCI+PC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIGFsaWduPSJsZWZ0IiBsYWJlbD0i5Y+R6LW35Lq6IiBwcm9wPSJjcmVhdG9yIj48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gYWxpZ249ImxlZnQiIGxhYmVsPSLmiYDlsZ7mtYHnqIsiIHByb3A9InByb2NEZWZOYW1lIj48L2VsLXRhYmxlLWNvbHVtbj4KPC9lbC10YWJsZT4=' where ALIAS = 'vueTodo'; update portal_sys_column set TEMPLATE_HTML = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiPgogICAgPGVsLXRhYmxlLWNvbHVtbiB0eXBlPSJpbmRleCIgYWxpZ249ImxlZnQiIGxhYmVsPSLluo/lj7ciPjwvZWwtdGFibGUtY29sdW1uPgogICAgPGVsLXRhYmxlLWNvbHVtbiBhbGlnbj0ibGVmdCIgbGFiZWw9IueKtuaAgSI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9InNjb3BlIj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3Jldm9rZSciIHN0eWxlPSJjb2xvcjojZjcxMDEwIj7mkqTlm548L3NwYW4+CiAgICAgICAgICAgIDxzcGFuIHYtaWY9InNjb3BlLnJvdy5zdGF0dXM9PSdyZXZva2VUb1N0YXJ0JyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPuaSpOWbnuWIsOWPkei1t+S6ujwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J2RyYWZ0JyIgc3R5bGU9ImNvbG9yOiNjMmE0MzciPuiNieeovzwvc3Bhbj4KCQkJCQkJPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3J1bm5pbmcnIiBzdHlsZT0iY29sb3I6IzMxODQwOSI+5q2j5Zyo6L+Q6KGMPC9zcGFuPgogICAgICAgICAgICA8c3BhbiB2LWlmPSJzY29wZS5yb3cuc3RhdHVzPT0nZW5kJyIgc3R5bGU9ImNvbG9yOiM5MDkzOTkiPue7k+adnzwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J21hbnVhbGVuZCciIHN0eWxlPSJjb2xvcjojOTA5Mzk5Ij7kurrlt6Xnu5PmnZ88L3NwYW4+CiAgICAgICAgICAgIDxzcGFuIHYtaWY9InNjb3BlLnJvdy5zdGF0dXM9PSdiYWNrJyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPumps+Wbnjwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J2JhY2tUb1N0YXJ0JyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPumps+WbnueahOWPkei1t+S6ujwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIGxhYmVsPSLmoIfpopgiIGFsaWduPSJsZWZ0IiBzaG93LW92ZXJmbG93LXRvb2x0aXAgd2lkdGg9IjMwMCI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9InNjb3BlIj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3J1bm5pbmcnIHx8IHNjb3BlLnJvdy5zdGF0dXM9PSdiYWNrJyB8fCBzY29wZS5yb3cuc3RhdHVzPT0ncmV2b2tlJyIKICAgICAgICAgICAgICAgIGNsYXNzPSJ0b2RvLXN1YmplY3QiCiAgICAgICAgICAgICAgICBAY2xpY2s9ImhhbmRsZVJvd0NsaWNrKCcvaW5zdC8nK3Njb3BlLnJvdy5pZCsgJy9yZXF1ZXN0JykiIEBjb250ZXh0bWVudS5wcmV2ZW50PSJoYW5kbGVSb3dDbGljaygnL2luc3QvJytzY29wZS5yb3cuaWQrICcvcmVxdWVzdCcsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1lbHNlLWlmPSJzY29wZS5yb3cuc3RhdHVzPT0nZHJhZnQnIiBjbGFzcz0idG9kby1zdWJqZWN0IgogICAgICAgICAgICAgICAgQGNsaWNrPSJoYW5kbGVSb3dDbGljaygnL3N0YXJ0Lycrc2NvcGUucm93LnByb2NEZWZJZCsnLycrc2NvcGUucm93LmlkKSIgQGNvbnRleHRtZW51LnByZXZlbnQ9ImhhbmRsZVJvd0NsaWNrKCcvc3RhcnQvJytzY29wZS5yb3cucHJvY0RlZklkKycvJytzY29wZS5yb3cuaWQsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1lbHNlIGNsYXNzPSJ0b2RvLXN1YmplY3QiCiAgICAgICAgICAgICAgICBAY2xpY2s9ImhhbmRsZVJvd0NsaWNrKCcvaW5zdC8nK3Njb3BlLnJvdy5pZCkiIEBjb250ZXh0bWVudS5wcmV2ZW50PSJoYW5kbGVSb3dDbGljaygnL2luc3QvJytzY29wZS5yb3cuaWQsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9ImNyZWF0ZVRpbWUiIGxhYmVsPSLlj5Hotbfml7bpl7QiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCBhbGlnbj0ibGVmdCIgd2lkdGg9IjE1MCI+PC9lbC10YWJsZS1jb2x1bW4+CjwvZWwtdGFibGU+' where ALIAS = 'vueMyrequest'; -- 2020-11-26 周进起 流程附件上传配置表 添加阿里云OSS三个字段 ALTER TABLE "PORTAL_FLOW_UPLOAD_PROPERTIES" ADD ("ALIYUN_OSS_ENDPOINT_" VARCHAR2(255)) ADD ("ALIYUN_OSS_ACCESSKEYID_" VARCHAR2(255)) ADD ("ALIYUN_OSS_ACCESSKEYSECRET_" VARCHAR2(255)); COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ENDPOINT_" IS '访问路径 endpoint'; COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ACCESSKEYID_" IS '访问密钥ID accessKeyId'; COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ACCESSKEYSECRET_" IS '访问密钥 accessKeySecret' -- 2020-11-26 周进起 更新系统属性表 文件存储方式描叙字段 UPDATE "PORTAL_SYS_PROPERTIES" SET "DESCRIPTION" = '可用参数值：database（保存在数据库）；folder（保存在服务器文件目录）；ftp（上传到ftp）；aliyunOss（上传到阿里云OSS）' WHERE "ALIAS" = 'file.saveType'; -- 2020-11-26 lingpj 调整角色管理菜单 UPDATE PORTAL_SYS_MENU SET PARENT_ID_ = '3441009' WHERE ID_ = '1290961424914452480'; UPDATE PORTAL_SYS_MENU SET PARENT_ID_ = '3441009' WHERE ID_ = '1290961558574338048'; DELETE FROM PORTAL_SYS_MENU WHERE ID_ = '3441030'; -- 2020-11-27 wanghb 数据列表新增是否允许外链字段 ALTER TABLE form_data_template ADD ( ALLOW_SHARE_ SMALLINT DEFAULT 2 ); COMMENT ON COLUMN form_data_template.ALLOW_SHARE_ IS '是否允许外链。1，允许。2，不允许';