From cd46a066e91c2b1b1de4ad630ffaaa695a311465 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 26 May 2023 21:08:03 +0800
Subject: [PATCH] 新增业务字典查询接口，可以根据code 和 parentId 查询字典信息
---
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.java | 7 +++++++
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.xml | 9 +++++++++
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/DictBizServiceImpl.java | 11 +++++++++++
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/controller/DictBizController.java | 11 +++++++++++
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/IDictBizService.java | 7 +++++++
5 files changed, 45 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/controller/DictBizController.java b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/controller/DictBizController.java
index e3c5afa..9757ad7 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/controller/DictBizController.java
+++ b/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")
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.java
index d522e63..e2ad488 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.java
+++ b/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);
}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.xml
index e8066f1..6cf42b2 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/DictBizMapper.xml
+++ b/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>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/IDictBizService.java b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/IDictBizService.java
index e791ebd..38a16eb 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/IDictBizService.java
+++ b/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);
}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/DictBizServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/DictBizServiceImpl.java
index 316e4f4..9aa5ce3 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/DictBizServiceImpl.java
+++ b/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);
+ }
}
--
Gitblit v1.9.3