eeplat_13角色授权(菜单权限、操作权限、数据权限)统一勾选的实现.docVIP

角色授权（菜单权限、操作权限、数据权限）统一勾选的实现 写在前面：如果增加了角色授权统一勾选功能之后，工作流相关待办任务的待办列表打开速度过慢（一分钟或以上），则给工作流相关表加索引。 执行索引的sql语句（执行之前，把以下sql语句中相关表的索引删掉）如下： CREATE?INDEX?nodeinstance_pi_index?ON?do_wfi_nodeinstance?(PI_UID);CREATE?INDEX?nodeinstance_exestatus_index?ON?do_wfi_nodeinstance?(ExeStatus);CREATE?INDEX?nodeinstance_node_uid_index?ON?do_wfi_nodeinstance?(node_uid);CREATE?INDEX?nodeinstance_union?ON?do_wfi_nodeinstance?(ExeStatus,PI_UID,node_uid);CREATE?INDEX?do_wfi_ni_dependency_Pre_NID_UID?ON?do_wfi_ni_dependency?(Pre_NID_UID);CREATE?INDEX?do_wfi_ni_dependency_Post_NID_UID?ON?do_wfi_ni_dependency?(Post_NID_UID);CREATE?INDEX?process_exestatus_index?ON?do_wfi_processinstance?(ExeStatus);CREATE?INDEX?do_authorization_ouuid?ON?do_authorization?(ouuid);CREATE?INDEX?do_authorization_whatuid?ON?do_authorization?(whatuid);CREATE?INDEX?do_authorization_parteruid?ON?do_authorization?(parteruid);CREATE?INDEX?do_authorization_union?ON?do_authorization?(parterUid,ouUid,whatUid);CREATE?INDEX?do_org_user_role_userid_index?ON?do_org_user_role?(USER_UID);CREATE?INDEX?do_org_user_role_roleid_index?ON?do_org_user_role?(ROLE_UID);CREATE?INDEX?do_wfi_his_ni_dependency_Pre_NID_UID?ON?do_wfi_his_ni_dependency?(Pre_NID_UID);CREATE?INDEX?do_wfi_his_ni_dependency_Post_NID_UID?ON?do_wfi_his_ni_dependency?(Post_NID_UID);CREATE?INDEX?nodeinstance_his_pi_index?ON?do_wfi_his_nodeinstance?(PI_UID);CREATE?INDEX?nodeinstance_his_exestatus_index?ON?do_wfi_his_nodeinstance?(ExeStatus);CREATE?INDEX?nodeinstance_his_union?ON?do_wfi_his_nodeinstance?(ExeStatus,PI_UID);CREATE?INDEX?process_history_exestatus_index?ON?do_wfi_his_processinstance?(ExeStatus); 配置实现步骤： 将平台WebContent/exedo/webv3文件夹下的DO_Auth_Role.jsp中第232行左右处的“DOMenuModel dmm = DOMenuModel.getMenuModelByName(bbb_root);”中的“bbb_root”改为自己项目的根菜单的名字。 补充： A、如果DO_Auth_Role.jsp文件中国际化的js文件没有加入，那么加上如下语句： % if (en.equals(DOGlobals.getValue(lang.local))){ % script type=text/javascript src=%=request.getContextPath()%/exedo/webv3/js/main/lang_en.js