screen-api SQL优化 screen-manage 日志模块更新，SQL优化

kaiyu

2021-08-25 41622b7aa1d948040b0f8ea024aece42d5a518a2

 screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java

@@ -34,6 +34,16 @@
        return childrenOrganization;
    }

    @Override
    public Organization getStateControlStation() {
        QueryWrapper<Organization> wrapper = new QueryWrapper<>();
        wrapper.select("id");
        wrapper.eq("name","国控站");
        wrapper.eq("is_delete",Constants.NOT_DELETE);
        Organization organization = organizationMapper.selectOne(wrapper);
        return organization;
    }

    /**
    * @Description: 通过父组织查询下面所有的子组织放到children中
            * @Param: [parentId, children]
@@ -43,6 +53,7 @@
            */
    private void recursionQueryChildren(Integer parentId, List<Organization> children) {
        QueryWrapper<Organization> queryWrapper = new QueryWrapper();
        queryWrapper.select("id");
        queryWrapper.eq("is_delete", Constants.NOT_DELETE);
        queryWrapper.eq("parent_id", parentId);
        List<Organization> organizations = organizationMapper.selectList(queryWrapper);