增加返回所有行政区划接口

xieb

2023-05-19 ea38d3a38c37b68ad9102b0fdae9a4ff844e9f42

增加返回所有行政区划接口

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttAdBaseController.java

@@ -65,6 +65,23 @@
        return R.data(listNodeLazyVO(list));
    }

    @GetMapping("/selectAll")
    @ApiImplicitParams({
        @ApiImplicitParam(name = "code", value = "区划编号", paramType = "query", dataType = "string"),
        @ApiImplicitParam(name = "name", value = "区划名称", paramType = "query", dataType = "string")
    })
    @ApiOperation(value = "加载树列表", notes = "传入code")
    public R<List<AttAdBaseVO>> selectAll(String parentCode, @ApiIgnore @RequestParam Map<String, Object> obj) {
        String code = obj.get("code").toString();
        if (code.substring(0,4).indexOf("00") > -1) {
            obj.put("code",code.substring(0,2));
        } else if (code.substring(0,6).indexOf("00") > -1) {
            obj.put("code",code.substring(0,4));
        }
        List<AttAdBaseVO> list = attAdBaseService.lazyTreeAll(parentCode, obj);
        return R.data(listNodeLazyVO(list));
    }

    /**
     * 查询区域菜单树-带层级
     * @param parentCode

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java

@@ -26,4 +26,7 @@
     */
    @MapKey("id")
    Map<String, TreeNode> selectAttAdBaseTree(String parentCode, Map<String, Object> param);

    List<AttAdBaseVO> lazyTreeAll(String parentCode, Map<String, Object> param);

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml

@@ -60,4 +60,30 @@
        </where>
        ORDER BY region."ad_code"
    </select>

    <select id="lazyTreeAll" resultType="cn.gistack.common.node.TreeNode">
        SELECT
        region."ad_code" AS "id",
        region."p_ad_code" AS "parent_id",
        region."ad_name" AS "title",
        region."ad_code" AS "value",
        region."ad_grad" AS "adGrad",
        region."ad_code" AS "key",
        ( SELECT CASE WHEN count( 1 ) > 0 THEN 1 ELSE 0 END FROM "SJZT_MD"."att_ad_base" WHERE "p_ad_code" = region."ad_code" ) AS "has_children"
        FROM
        "SJZT_MD"."att_ad_base" region
        <where>
            <if test="param1!=null">
                and region."p_ad_code" = #{param1}
            </if>
            <if test="param2.code!=null and param2.code!=''">
                and region."ad_code" like concat(concat('%', #{param2.code}),'%')
            </if>
            <if test="param2.name!=null and param2.name!=''">
                and region."ad_name" like concat(concat('%', #{param2.name}),'%')
            </if>
        </where>
        ORDER BY region."ad_code"
    </select>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java

@@ -18,6 +18,8 @@

    List<AttAdBaseVO> lazyTree(String parentCode, Map<String, Object> param);

    List<AttAdBaseVO> lazyTreeAll(String parentCode, Map<String, Object> param);

    /**
     * 查询区域菜单树-带层级
     * @param parentCode

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java

@@ -31,6 +31,11 @@
        return baseMapper.lazyTree(parentCode, param);
    }

    @Override
    public List<AttAdBaseVO> lazyTreeAll(String parentCode, Map<String, Object> param) {
        return baseMapper.lazyTreeAll(parentCode, param);
    }

    /**
     * 查询区域菜单树-带层级
     * @param parentCode