简要描述:

  • 浏览功能Sql
  • 辅助接口,生成基础的sql语句,辅助开发人员快速添加栏目和功能
  • 执行sql语句后,需要针对实际需求,到平台栏目管理和权限管理中进行配置和授权
  • 生成的sql语句里面parent_id和sort等直接手动修改或插入后,到平台里面再修改

接口版本:

版本号 制定人 制定日期 修订日期
v3 陈碧贵 2021-09-29 xxxx-xx-xx

请求URL:

请求方式:

  • GET
  • POST

请求头:

参数名 是否必须 类型 说明
XownerId string 项目唯一ID,对应bo_project {ownerId}
XsysId string 所属系统 对应 bo_system 表
XuserFromFirstShareId string 一级分享用户ID, bo_user user_id
XuserFromSecondShareId string 二级分享用户ID, bo_user user_id
XverifyApi string 加密规则encryptByDES(`${newGuid()}
XfilterAreaCode string 行政区编码, 对应 bo_sys_area area_code
Content-Type: string application/json; charset=utf-8 请求类型

请求参数:

  • 当事件发生时,调用http/https接口,传递参数信息,响应请求结果。
参数名 是否必须 类型 说明
menuName string 栏目名称
_nodejs string common-data 对应/Config/AppNodeJs/Plugins/fn- common-data.js, 通过nodejs插件,对响应结果进行二次处理 common-data 普通数据(小写驼峰)common-data-under 普通数据下划线

返回示例:

正确时返回:

{
    "data": {
        "url": "~/App_Temp/menus-sql/bt/bs-msg-notice-my-bo_menu_function.sql"
    },
    "code": "0",
    "retCode": "0",
    "success": true
}

错误时返回:

{
    "code": 0,
    "message": ""
    "error":{
      errorCode:null,
      errorText:null
    }
    "success": false,
}

返回参数说明:

参数名 类型 说明
success bool true 表示数据请求成功(跟code=0一致),调用者优先使用
code int true 表示数据请求成功(跟code=0一致),调用者优先使用
data array 响应的结果数据 name:显示的名称 value:交互的数据库中值 id:通常和value一致,树形结构需要 parentId: 父节点,树形结构需要level:等级,树形结构需要
cacheType string redis/sqlite/local 数据来源缓存 的类型(便于开发调试和性能优化)
cacheDate date 最后数据获取时间

bo_menu_function.sql 简易版本,通常为1级栏目

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('3963545014096629760', null, '消息通知', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-msg-notice|my', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-detail', '3963545014096629760', 'detail', 1);
INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('basis-dev-menu', null, '开发栏目', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bo-menu|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('basis-dev-menu-detail', 'basis-dev-menu', 'detail', 1);

bo_menu_function.sql 生成的栏目

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('3963545014096629760', 'basis-dev-menu', '我的通知', 99999855, NULL, NULL, 0, 0, '', NULL,
'{\n        \"mkey\": \"bs-msg-notice\",\n        \"field\": \"my\",\n        \"moulesShow\": [\n          \"table\",\n          \"action\"\n        ],\n        \"modulesHide\": [\n          \"form\"\n        ],\n        \"position\": \"tab\",\n        \"class\": \"el-icon-unlock\",\n        \"menuClass\": \"nav-menu__all\",\n        \"attrs\": {\n          \"label\": \"我的通知\"\n        },\n        \"popup\": {\n          \"component\": \"bs-table\"\n        },\n        \"tab\": {\n          \"component\": \"bs-table\"\n        }\n      }'
, 1, NULL, 'site', '', 1, 0, 'bt|bs-msg-notice|my', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-detail', '3963545014096629760', 'detail', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-history', '3963545014096629760', 'history', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-edit', '3963545014096629760', 'edit', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-del', '3963545014096629760', 'del', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-save', '3963545014096629760', 'save', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-refresh', '3963545014096629760', 'refresh', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-add', '3963545014096629760', 'add', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-search', '3963545014096629760', 'search', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-import', '3963545014096629760', 'import', 1);
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('3963545014096629760-export', '3963545014096629760', 'export', 1);

大屏中心

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard', null, '大屏中心', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-detail', 'dashboard', 'detail', 1);


INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard-my', 'dashboard', '我的大屏', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|my', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-my-detail', 'dashboard', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard-dep', 'dashboard', '机构大屏', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|dep', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-dep-detail', 'dashboard', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard-area', 'dashboard', '行政大屏', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|area', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-area-detail', 'dashboard', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard-ops', 'dashboard', '运维大屏', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|area', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-ops-detail', 'dashboard', 'detail', 1);



INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('dashboard-data', 'dashboard', '数据大屏', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-dashboard|area', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('dashboard-data-detail', 'dashboard', 'detail', 1);

活动中心

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('activity-center', null, '活动中心', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-activity|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('activity-center-detail', 'dashboard', 'detail', 1);

项目中心

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('project-center', null, '项目中心', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-project|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('project-center-detail', 'project-center', 'detail', 1);

其它栏目

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('else-center', null, '其它栏目', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-else|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('else-center-detail', 'else-center', 'detail', 1);

平台组件

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('pf-components', null, '平台组件', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-pf-components|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('pf-components-detail', 'meta-components', 'detail', 1);

box-con

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('components-icon-box', 'pf-components', 'box-icon', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-components-icon-box|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('components-icon-box-detail', 'components-icon-box', 'detail', 1);

line-icon

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('components-icon-line', 'pf-components', 'line-icon', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-components-icon-line|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('components-icon-line-detail', 'components-icon-line', 'detail', 1);

原子组件

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('meta-components', 'pf-components', '原子组件', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-meta-components|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('meta-components-detail', 'meta-components', 'detail', 1);

业务组件

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('biz-components', 'pf-components', '业务组件', 99999999, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-biz-components|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('biz-components-detail', 'biz-components', 'detail', 1);

日志中心

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('log-center', null, '日志中心', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-log-center|manager', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('log-center-detail', 'log-center', 'detail', 1);


INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('log-center-login', 'log-center', '登录日志', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-log-center|login', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('log-center-login-detail', 'log-center', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('log-center-op', 'log-center', '操作日志', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-log-op|dep', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('log-center-op-detail', 'log-center', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('log-center-ub', 'log-center', '行为日志', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-log-center|area', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('log-center-ub-detail', 'log-center', 'detail', 1);

INSERT INTO `bo_sys_menu`(`MENU_ID`, `PARENT_ID`, `MENU_NAME`, `SORT_ID`, `Path`, `ICON`, `IS_DEFAULT`, `IS_HIDDEN`, `SYS_ID`, `META_REMARK`, `META`, `IS_ENABLED`, `REMARK`, `RESOURCE_TYPE`, `RESOURCE_ID`, `AUTH`, `IS_DEVELOPING`, `MAPPER_FIELD`, `IS_MOBILE`, `IS_WEB`, `IS_MAP`, `POSITION`) 
VALUES ('log-center-error', 'log-center', '异常日志', 99999855, NULL, NULL, 0, 0, '', NULL,
'{}'
, 1, NULL, 'site', '', 1, 0, 'basis|bs-log-center|area', 0, 0, 0, 'nav-content,nav-more');
INSERT INTO `bo_menu_function`(`MF_ID`, `MENU_ID`, `FUNC_ID`, `IS_ENABLED`) VALUES ('log-center-error-detail', 'log-center', 'detail', 1);
文档更新时间: 2022-03-22 06:34   作者:admin