长者信息树

最新推荐文章于 2024-10-08 13:19:19 发布

djq8080

最新推荐文章于 2024-10-08 13:19:19 发布

阅读量181

点赞数

本文链接：https://blog.csdn.net/djq8080/article/details/121750417

版权

数据结构树形数据数据库查询信息组织遍历算法

关键词由CSDN通过智能技术生成

 public List<TreeNode> getServiceElderTree() {
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        //获取服务中心数据
        List<TreeNode> orgTreeNodes = this.baseMapper.selectByOrgId(user.getOrgId());
        //获取服务区域-社区信息
        //List<TreeNode> serviceTreeNodes = this.baseMapper.selectByServiceId(user.getOrgId());
        //长者信息树
        List<TreeNode> elderTreeNodes = this.baseMapper.selectByElderId(user.getOrgId());
        for (TreeNode treeN : orgTreeNodes) {
            String[] vals = treeN.getValue().split(",");
            List<TreeNode> serviceTreeNodeList = new ArrayList<>();
            for (String str :vals){
                TreeNode treeNode = new TreeNode();
                //社区名称
                String communityName = this.baseMapper.selectByCommunityId(str);
                String communityKey = str;
                treeNode.setLeaf(false);
                treeNode.setKey(str);
                treeNode.setValue(communityName);
                treeNode.setTitle(communityName);
                serviceTreeNodeList.add(treeNode);
                treeN.setChildren(serviceTreeNodeList);
                //遍历老人信息
                List<TreeNode> elderList = new ArrayList<>();
                for (TreeNode elderTreeNode : elderTreeNodes) {
                    String elderValue = elderTreeNode.getValue();
                    elderTreeNode.setLeaf(true);
                    if (communityKey.equals(elderValue)) {
                        elderList.add(elderTreeNode);
                        treeNode.setChildren(elderList);
                    }
                }
            }
        }
        return orgTreeNodes;
    }

    <!-- 登录人服务中心树 -->
    <select id="selectByOrgId" resultType="org.jeecg.common.api.vo.TreeNode">
        SELECT id as 'key', service_district as 'value',name as 'title',service_district as 'label' from organization_community_services where id = #{orgId}
    </select>
```java
    <!-- 长者信息树 -->
    <select id="selectByElderId" resultType="org.jeecg.common.api.vo.TreeNode">
        SELECT id as 'key', community as 'value',name as 'title', id as 'parentId' from elder_info
    </select>