| | |
|---|
| | | import com.ruoyi.common.core.domain.entity.SysRole; |
|---|
| | | import com.ruoyi.common.core.domain.entity.SysUser; |
|---|
| | | import com.ruoyi.common.exception.ServiceException; |
|---|
| | | import com.ruoyi.common.helper.DataBaseHelper; |
|---|
| | | import com.ruoyi.common.helper.LoginHelper; |
|---|
| | | import com.ruoyi.common.utils.StringUtils; |
|---|
| | | import com.ruoyi.common.utils.TreeBuildUtils; |
|---|
| | |
|---|
| | | public long selectNormalChildrenDeptById(Long deptId) { |
|---|
| | | return baseMapper.selectCount(new LambdaQueryWrapper<SysDept>() |
|---|
| | | .eq(SysDept::getStatus, UserConstants.DEPT_NORMAL) |
|---|
| | | .apply("find_in_set({0}, ancestors) <> 0", deptId)); |
|---|
| | | .apply(DataBaseHelper.findInSet(deptId, "ancestors"))); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | */ |
|---|
| | | public void updateDeptChildren(Long deptId, String newAncestors, String oldAncestors) { |
|---|
| | | List<SysDept> children = baseMapper.selectList(new LambdaQueryWrapper<SysDept>() |
|---|
| | | .apply("find_in_set({0},ancestors) <> 0", deptId)); |
|---|
| | | .apply(DataBaseHelper.findInSet(deptId, "ancestors"))); |
|---|
| | | List<SysDept> list = new ArrayList<>(); |
|---|
| | | for (SysDept child : children) { |
|---|
| | | SysDept dept = new SysDept(); |
|---|
