From 653bf849292826f389b8ff58f9584d1f7e179b83 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期五, 13 十月 2023 10:48:58 +0800 Subject: [PATCH] update 优化 数据权限 减少二次校验查询 --- ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysDeptServiceImpl.java | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysDeptServiceImpl.java b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysDeptServiceImpl.java index 36680e3..aa66705 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysDeptServiceImpl.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/org/dromara/system/service/impl/SysDeptServiceImpl.java @@ -69,8 +69,10 @@ */ @Override public List<Tree<Long>> selectDeptTreeList(SysDeptBo bo) { + // 鍙煡璇㈡湭绂佺敤閮ㄩ棬 + bo.setStatus(UserConstants.DEPT_NORMAL); LambdaQueryWrapper<SysDept> lqw = buildQueryWrapper(bo); - List<SysDept> depts = baseMapper.selectList(lqw); + List<SysDeptVo> depts = baseMapper.selectDeptList(lqw); return buildDeptTreeSelect(depts); } @@ -81,6 +83,7 @@ lqw.eq(ObjectUtil.isNotNull(bo.getParentId()), SysDept::getParentId, bo.getParentId()); lqw.like(StringUtils.isNotBlank(bo.getDeptName()), SysDept::getDeptName, bo.getDeptName()); lqw.eq(StringUtils.isNotBlank(bo.getStatus()), SysDept::getStatus, bo.getStatus()); + lqw.orderByAsc(SysDept::getDeptId); lqw.orderByAsc(SysDept::getParentId); lqw.orderByAsc(SysDept::getOrderNum); return lqw; @@ -93,7 +96,7 @@ * @return 涓嬫媺鏍戠粨鏋勫垪琛� */ @Override - public List<Tree<Long>> buildDeptTreeSelect(List<SysDept> depts) { + public List<Tree<Long>> buildDeptTreeSelect(List<SysDeptVo> depts) { if (CollUtil.isEmpty(depts)) { return CollUtil.newArrayList(); } -- Gitblit v1.9.3