3.0.1 数据权限bug

Blade 未结

关注

 2  892

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条回答

流光幻影 (楼主)

2023-07-04 09:55

请问这个问题解决了吗

0 讨论(0)

查看其它2个回答
发布评论:

提交评论
- 加载中...