3.0.1 数据权限bug

Blade 未结 2 887
kelchoi
kelchoi 剑圣 2022-09-09 11:26

一、该问题的重现步骤是什么?

1、下载 BladeX-Boot 和 Sword 的工程源码,导入 IDE,导入数据库,安装依赖,启动工程。


2、登陆系统,找到 权限管理 / 数据权限,随便找一条数据,点配置,如下图:

截图_选择区域_20220909105455.png


3、在弹出的表单中点 新增

截图_选择区域_20220909105613.png

4、 在 权限名称 一栏随便输入点内容:

截图_选择区域_20220909105737.png

5、再在 权限字段 一栏输入点东西,此时会发现 权限名称 输入的内容自动清空了


截图_选择区域_20220909110407.png



6、 继续在其它字段随便输入点内容,然后点击保存:


截图_选择区域_20220909110509.png





保存成功,但列表上没有显示出来


截图_选择区域_20220909110533.png




7、 自己去点一下查询按钮,发现报错


截图_选择区域_20220909110640.png






对应的后端打印信息:


截图_选择区域_20220909110722.png





前端发送请求的参数 scopeType = undefined 会导致报错 NumberFormatException:


截图_选择区域_20220909110818.png




8、自己去点一下 重置 按钮,又能查出来,但是权限名称、权限编号之前明明有填写的,又没有内容,明显是没有保存到数据库


截图_选择区域_20220909111547.png

截图_选择区域_20220909111637.png





二、你期待的结果是什么?实际看到的又是什么?

期待结果:

  • 新增数据权限,填写表单时,权限名称一项,不会自动清空

  • 新增数据权限,填写表单时,规则类型一项,不应该是 undefined

  • 新增数据权限后,查询权限数据列表,应该不会报错,且能成功显示权限数据

实际看到:

  • 新增数据权限,填写表单时,权限名称一项,会自动清空

  • 新增数据权限,填写表单时,规则类型一项,是 undefined

  • 新增数据权限后,查询权限数据列表,报错,且不能成功显示权限数据

三、你正在使用的是什么产品,什么版本?在什么操作系统上?

  • 产品:Bladex-Boot 、Sword

  • 版本:2.9.1、3.0.1

  • 操作系统:Deepin V20.7

四、请提供详细的错误堆栈信息,这很重要。

信息 1

点击 配置  弹出“[参数管理] 数据权限配置”弹窗时,后端对应的日志:

2022-09-09 11:19:37.254  INFO 53931 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 

================  Request Start  ================
===> GET: /blade-system/dict/dictionary Parameters: {"code":"data_scope_type"}
===Headers===  sec-fetch-mode: cors
===Headers===  referer: http://localhost:8888/
===Headers===  sec-fetch-site: same-origin
===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw
===Headers===  accept-language: zh-CN,zh;q=0.9
===Headers===  cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864
===Headers===  accept: */*
===Headers===  authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0
===Headers===  sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104"
===Headers===  sec-ch-ua-mobile: ?0
===Headers===  sec-ch-ua-platform: "Linux"
===Headers===  host: 127.0.0.1:7033
===Headers===  connection: close
===Headers===  accept-encoding: gzip, deflate, br
===Headers===  user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
===Headers===  sec-fetch-dest: empty
================   Request End   ================

2022-09-09 11:19:37.260  INFO 53931 --- [  XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select id, parent_id, code, dict_key, dict_value , sort, remark from blade_dict where code = 'data_scope_type' and parent_id > 0 and is_sealed = 0 and is_deleted = 0
Execute Time: 1.076ms
==============  Sql  End   ==============

2022-09-09 11:19:37.260  INFO 53931 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 

===============  Response Start  ================
===Result===  {"code":200,"success":true,"data":[{"id":"1123598814738675232","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"1","dictValue":"全部可见","sort":1,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675233","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"2","dictValue":"本人可见","sort":2,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675234","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"3","dictValue":"所在机构可见","sort":3,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675235","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"4","dictValue":"所在机构及子级可见","sort":4,"remark":null,"isSealed":null,"isDeleted":null},{"id":"1123598814738675236","parentId":"1123598814738675231","code":"data_scope_type","dictKey":"5","dictValue":"自定义","sort":5,"remark":null,"isSealed":null,"isDeleted":null}],"msg":"操作成功"}
<=== GET: /blade-system/dict/dictionary (6 ms)
===============   Response End   ================

2022-09-09 11:19:37.378  INFO 53931 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 

================  Request Start  ================
===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":null,"size":null,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":null,"scopeValue":null,"remark":null}}
===Headers===  sec-fetch-mode: cors
===Headers===  referer: http://localhost:8888/
===Headers===  sec-fetch-site: same-origin
===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw
===Headers===  accept-language: zh-CN,zh;q=0.9
===Headers===  cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864
===Headers===  accept: */*
===Headers===  authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0
===Headers===  sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104"
===Headers===  sec-ch-ua-mobile: ?0
===Headers===  sec-ch-ua-platform: "Linux"
===Headers===  host: 127.0.0.1:7033
===Headers===  connection: close
===Headers===  accept-encoding: gzip, deflate, br
===Headers===  user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
===Headers===  sec-fetch-dest: empty
================   Request End   ================

2022-09-09 11:19:37.389  INFO 53931 --- [  XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0
Execute Time: 1.467ms
==============  Sql  End   ==============

2022-09-09 11:19:37.393  INFO 53931 --- [  XNIO-1 task-1] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select id, menu_id, resource_code, scope_name, scope_field , scope_class, scope_column, scope_type, scope_value, remark , create_user, create_dept, create_time, update_user, update_time , status, is_deleted from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 limit 10
Execute Time: 1.162ms
==============  Sql  End   ==============

2022-09-09 11:19:37.442  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

================  Request Start  ================
===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":1,"scopeValue":null,"remark":null}}
===Headers===  sec-fetch-mode: cors
===Headers===  referer: http://localhost:8888/
===Headers===  sec-fetch-site: same-origin
===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw
===Headers===  accept-language: zh-CN,zh;q=0.9
===Headers===  cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864
===Headers===  accept: */*
===Headers===  authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0
===Headers===  sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104"
===Headers===  sec-ch-ua-mobile: ?0
===Headers===  sec-ch-ua-platform: "Linux"
===Headers===  host: 127.0.0.1:7033
===Headers===  connection: close
===Headers===  accept-encoding: gzip, deflate, br
===Headers===  user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
===Headers===  sec-fetch-dest: empty
================   Request End   ================

2022-09-09 11:19:37.443  INFO 53931 --- [  XNIO-1 task-1] o.s.core.log.aspect.RequestLogAspect     : 

===============  Response Start  ================
===Result===  {"code":200,"success":true,"data":{"records":[{"id":"1568073026364715010","createUser":"1123598821738675201","createDept":"1123598813738675201","createTime":"2022-09-09 11:05:18","updateUser":"1123598821738675201","updateTime":"2022-09-09 11:05:18","status":1,"isDeleted":0,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":"xx","scopeClass":"xxx","scopeColumn":"bbb","scopeType":3,"scopeValue":"xxxx","remark":"vvvv","scopeTypeName":"所在机构可见"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1},"msg":"操作成功"}
<=== GET: /blade-system/data-scope/list (64 ms)
===============   Response End   ================

2022-09-09 11:19:37.460  INFO 53931 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and scope_type = 1 and is_deleted = 0
Execute Time: 5.676ms
==============  Sql  End   ==============

2022-09-09 11:19:37.461  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

===============  Response Start  ================
===Result===  {"code":200,"success":true,"data":{"records":[],"total":0,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":0},"msg":"操作成功"}
<=== GET: /blade-system/data-scope/list (18 ms)
===============   Response End   ================


对应的页面:


截图_选择区域_20220909112137.png






信息 2

在“[参数管理] 数据权限配置”弹窗点击“查询”,对应的后端日志:

2022-09-09 11:22:39.005  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

================  Request Start  ================
===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":1,"scopeValue":null,"remark":null}}
===Headers===  sec-fetch-mode: cors
===Headers===  referer: http://localhost:8888/
===Headers===  sec-fetch-site: same-origin
===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw
===Headers===  accept-language: zh-CN,zh;q=0.9
===Headers===  cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864
===Headers===  accept: */*
===Headers===  authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0
===Headers===  sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104"
===Headers===  sec-ch-ua-mobile: ?0
===Headers===  sec-ch-ua-platform: "Linux"
===Headers===  host: 127.0.0.1:7033
===Headers===  connection: close
===Headers===  accept-encoding: gzip, deflate, br
===Headers===  user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
===Headers===  sec-fetch-dest: empty
================   Request End   ================

2022-09-09 11:22:39.015  WARN 53931 --- [  XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource   : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 181558
2022-09-09 11:22:39.017  WARN 53931 --- [  XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource   : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 243270
2022-09-09 11:22:39.052  INFO 53931 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and scope_type = 1 and is_deleted = 0
Execute Time: 4.487ms
==============  Sql  End   ==============

2022-09-09 11:22:39.053  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

===============  Response Start  ================
===Result===  {"code":200,"success":true,"data":{"records":[],"total":0,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":0},"msg":"操作成功"}
<=== GET: /blade-system/data-scope/list (47 ms)
===============   Response End   ================

对应的页面:


截图_选择区域_20220909112258.png





信息 3

在“[参数管理] 数据权限配置”弹窗点击“重置”,对应的后端日志:

2022-09-09 11:24:07.520  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

================  Request Start  ================
===> GET: /blade-system/data-scope/list Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"dataScope":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":null,"scopeClass":null,"scopeColumn":null,"scopeType":null,"scopeValue":null,"remark":null}}
===Headers===  sec-fetch-mode: cors
===Headers===  referer: http://localhost:8888/
===Headers===  sec-fetch-site: same-origin
===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJkZXRhaWwiOnsidHlwZSI6IndlYiJ9LCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzd29yZCIsImV4cCI6MTY2MjY5NjgyNywibmJmIjoxNjYyNjkzMjI3fQ.ljbut1pWFHW05sN9SBeS7BLi11R3-1HrjCs_aX0btEE4ZV6jUtNo_raYHLBgqrgvYb3E9MItcAeMpl-s9O0Lmw
===Headers===  accept-language: zh-CN,zh;q=0.9
===Headers===  cookie: rememberMe=true; XXL_JOB_LOGIN_IDENTITY=7b226964223a312c22757365726e616d65223a2261646d696e222c2270617373776f7264223a226531306164633339343962613539616262653536653035376632306638383365222c22726f6c65223a312c227065726d697373696f6e223a6e756c6c7d; JSESSIONID=0uOtcfDIzsymqnpQ0rbLavZd9pIk0T_Ha2zmipfB; Hm_lvt_8117e2ede53d19f7eace5e3683f6a005=1656898278; Hm_lpvt_8117e2ede53d19f7eace5e3683f6a005=1656898282; sidebarStatus=1; username=admin; password=CJxD+8VO+A250zcuhrSUNQQsdFnw5ptyqhZ7HOtVeL5WaGsLhoOW22m3tYD+F4GxTSt3z8xokmPemfsGyPMq5A==; Admin-Token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiJzeXNfdXNlcjoxIiwicm5TdHIiOiJFeGpGTHhjQld3eUVlSXhJem9WQUYySndiZ3ozR0xmMSJ9.lQYvj3gS9b3kYd8ubgauy73E3MZG0AO3q49bMmZhMw8; Hm_lvt_931a8de1263e8fcdea855e1b3c00abff=1661158846; Hm_lpvt_931a8de1263e8fcdea855e1b3c00abff=1661418864
===Headers===  accept: */*
===Headers===  authorization: Basic c3dvcmQ6c3dvcmRfc2VjcmV0
===Headers===  sec-ch-ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104"
===Headers===  sec-ch-ua-mobile: ?0
===Headers===  sec-ch-ua-platform: "Linux"
===Headers===  host: 127.0.0.1:7033
===Headers===  connection: close
===Headers===  accept-encoding: gzip, deflate, br
===Headers===  user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
===Headers===  sec-fetch-dest: empty
================   Request End   ================

2022-09-09 11:24:07.535  WARN 53931 --- [  XNIO-1 task-4] c.a.druid.pool.DruidAbstractDataSource   : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/bladex_boot_301?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 88476
2022-09-09 11:24:07.542  INFO 53931 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select count(*) as total from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0
Execute Time: 2.753ms
==============  Sql  End   ==============

2022-09-09 11:24:07.548  INFO 53931 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 

==============  Sql Start  ==============
Execute SQL : select id, menu_id, resource_code, scope_name, scope_field , scope_class, scope_column, scope_type, scope_value, remark , create_user, create_dept, create_time, update_user, update_time , status, is_deleted from blade_scope_data where menu_id = 1123598815738675209 and is_deleted = 0 limit 10
Execute Time: 1.830ms
==============  Sql  End   ==============

2022-09-09 11:24:07.551  INFO 53931 --- [  XNIO-1 task-4] o.s.core.log.aspect.RequestLogAspect     : 

===============  Response Start  ================
===Result===  {"code":200,"success":true,"data":{"records":[{"id":"1568073026364715010","createUser":"1123598821738675201","createDept":"1123598813738675201","createTime":"2022-09-09 11:05:18","updateUser":"1123598821738675201","updateTime":"2022-09-09 11:05:18","status":1,"isDeleted":0,"menuId":1123598815738675209,"resourceCode":null,"scopeName":null,"scopeField":"xx","scopeClass":"xxx","scopeColumn":"bbb","scopeType":3,"scopeValue":"xxxx","remark":"vvvv","scopeTypeName":"所在机构可见"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1},"msg":"操作成功"}
<=== GET: /blade-system/data-scope/list (31 ms)
===============   Response End   ================

对应的页面:



截图_选择区域_20220909112428.png


五、若有更多详细信息,请在下面提供。


2条回答
  • 2022-09-09 11:31

    你好,图片外链挂了,麻烦重新补充一下,另外商业版是需要用商业授权qq注册的账号提问的哈,麻烦改绑一下授权qq邮箱哦

    0 讨论(6)
  • 2023-07-04 09:55

    请问这个问题解决了吗

    0 讨论(0)
提交回复