From ea38d3a38c37b68ad9102b0fdae9a4ff844e9f42 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Fri, 19 May 2023 11:37:10 +0800
Subject: [PATCH] 增加返回所有行政区划接口
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java | 3 +++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java | 5 +++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttAdBaseController.java | 17 +++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml | 26 ++++++++++++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java | 2 ++
5 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttAdBaseController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttAdBaseController.java
index 77246d8..3ee4d3f 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttAdBaseController.java
+++ b/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
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java
index e3a9c04..f2db645 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java
+++ b/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);
+
}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml
index 465995d..0ba0294 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml
+++ b/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>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java
index 954ab82..a2ad44a 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java
+++ b/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
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java
index ef8fa18..f51efde 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java
+++ b/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
--
Gitblit v1.9.3