新增业务字典查询接口，可以根据code 和 parentId 查询字典信息

zhongrj

2023-05-26 cd46a066e91c2b1b1de4ad630ffaaa695a311465

新增业务字典查询接口，可以根据code 和 parentId 查询字典信息

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/controller/DictBizController.java

@@ -165,6 +165,17 @@
    }

    /**
     * 获取字典
     */
    @GetMapping("/dictionaryByParentId")
    @ApiOperationSupport(order = 8)
    @ApiOperation(value = "获取字典", notes = "获取字典")
    public R<List<DictBiz>> dictionaryByParentId(String code,Long parentId) {
        List<DictBiz> tree = dictService.getListByParentId(code,parentId);
        return R.data(tree);
    }

    /**
     * 获取字典树
     */
    @GetMapping("/dictionary-tree")

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.java

@@ -61,4 +61,11 @@
     */
    List<DictBizVO> parentTree();

    /**
     * 获取字典
     * @param code
     * @param parentId
     * @return
     */
    List<DictBiz> getListByParentId(String code, Long parentId);
}

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.xml

@@ -48,4 +48,13 @@
        select id, parent_id, dict_value as title, id as "value", id as "key" from blade_dict_biz where is_deleted = 0 and parent_id = 0
    </select>

    <!--获取字典-根据父id及code-->
    <select id="getListByParentId" resultMap="dictResultMap">
        select id, tenant_id, parent_id, code, dict_key, dict_value, sort, remark from blade_dict_biz
        where parent_id in(
            select id from blade_dict_biz where  parent_id > 0 and is_sealed = 0 and is_deleted = 0
            and code like  concat(concat('%',#{param1}),'%') and parent_id = #{param2}
        )
    </select>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/IDictBizService.java

@@ -98,4 +98,11 @@
     */
    List<DictBizVO> childList(Map<String, Object> dict, Long parentId);

    /**
     * 获取字典
     * @param code
     * @param parentId
     * @return
     */
    List<DictBiz> getListByParentId(String code, Long parentId);
}

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/DictBizServiceImpl.java

@@ -116,4 +116,15 @@
        List<DictBiz> list = this.list(Condition.getQueryWrapper(dict, DictBiz.class).lambda().ne(DictBiz::getId, parentId).eq(DictBiz::getCode, parentDict.getCode()).orderByAsc(DictBiz::getSort));
        return DictBizWrapper.build().listNodeVO(list);
    }

    /**
     * 获取字典
     * @param code
     * @param parentId
     * @return
     */
    @Override
    public List<DictBiz> getListByParentId(String code, Long parentId) {
        return baseMapper.getListByParentId(code,parentId);
    }
}