From be370f5d432d8a9e2ae1354bb4e1ac4881ab15fa Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期三, 22 二月 2023 15:01:39 +0800
Subject: [PATCH] 20230221@xingjs@提交官网一张图相关内容接口
---
src/main/java/com/lf/server/service/show/OneMapService.java | 145 ++++++++++++++++++++----------------------------
1 files changed, 61 insertions(+), 84 deletions(-)
diff --git a/src/main/java/com/lf/server/service/show/OneMapService.java b/src/main/java/com/lf/server/service/show/OneMapService.java
index 1f149e4..3e4cdad 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -20,6 +20,23 @@
OneMapMapper aMapOfPipelineMapper;
/**
+ * 娴嬮噺
+ */
+ private static String measurement = "娴嬮噺锛圗SV锛�";
+ /**
+ * 璋冩煡
+ */
+ private static String toInvestigate = "鍕樺療锛圗GE锛�";
+ /**
+ * 鍦扮伨
+ */
+ private static String disaster = "鍦扮伨锛圗GD锛�";
+ /**
+ * 鍦颁笅缁撴瀯娲炲簱
+ */
+ private static String undergroundStructure = "娲炲簱锛圗GD锛�";
+
+ /**
* 椤圭洰绫诲埆conut
*/
@Override
@@ -135,102 +152,62 @@
return aMapOfPipelineMapper.selectProjectTour();
}
+
/**
- * 缁熻椤圭洰绫诲瀷
+ * 閫夋嫨椤圭洰绫诲瀷
*
- * @return {@link List}<{@link String}>
+ * @return {@link List}<{@link OneMapEntity}>
*/
+ @Override
public List<OneMapEntity> selectProjectType1() {
-
-
List<OneMapEntity> resList = new ArrayList<>();
-
List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1();
for (OneMapEntity oneMapEntity : resInfo) {
- if (oneMapEntity.getValue().equals("娴嬮噺锛圗SV锛�")) {
- String valueStr = oneMapEntity.getKey();
- System.out.println("娴嬮噺锛圗SV锛�== valueStr == " + valueStr);
- String endSql = null;
- String sqlQur = "";
- if (valueStr.length() > 0) {
- String[] arrStr = valueStr.split(",");
- StringBuilder one = new StringBuilder();
- if (arrStr.length > 0) {
- System.out.println("arrStr = " + arrStr.length);
- }
- for (String s : arrStr) {
- sqlQur = "\'" + s + "%\' " + "or dircode like";
- one.append(sqlQur);
- }
- endSql = " where dircode like " + one.substring(0, one.toString().length() - 15);
- System.out.println("endSql = " + endSql);
- }
- resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql));
-
- } else if (oneMapEntity.getValue().equals("鍕樺療锛圗GE锛�")) {
- String valueStr = oneMapEntity.getKey();
- System.out.println("鍕樺療锛圗GE锛�== valueStr == " + valueStr);
- String endSql1 = null;
- String sqlQur = "";
- if (valueStr.length() > 0) {
- String[] arrStr1 = valueStr.split(",");
- StringBuilder one = new StringBuilder();
- if (arrStr1.length > 0) {
- System.out.println("arrStr = " + arrStr1.length);
- }
- for (String s : arrStr1) {
- sqlQur = "\'" + s + "%\' " + "or dircode like";
- one.append(sqlQur);
- }
- endSql1 = " where dircode like " + one.substring(0, one.toString().length() - 15);
- System.out.println("endSql1 = " + endSql1);
- }
- resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql1));
-
- } else if (oneMapEntity.getValue().equals("鍦扮伨锛圗GD锛�")) {
- String valueStr = oneMapEntity.getKey();
- System.out.println("鍦扮伨锛圗GD锛�== valueStr == " + valueStr);
- String endSql2 = null;
- String sqlQur = "";
- if (valueStr.length() > 0) {
- String[] arrStr2 = valueStr.split(",");
- StringBuilder one = new StringBuilder();
- if (arrStr2.length > 0) {
- System.out.println("arrStr = " + arrStr2.length);
- }
- for (int j = 0; j < arrStr2.length; j++) {
- sqlQur = "\'" + arrStr2[j] + "%\' " + "or dircode like";
- one.append(sqlQur);
- }
- endSql2 = " where dircode like " + one.substring(0, one.toString().length() - 15);
- System.out.println("endSql2 = " + endSql2);
- }
- resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql2));
-
- } else if (oneMapEntity.getValue().equals("娲炲簱锛圗GD锛�")) {
- String valueStr = oneMapEntity.getKey();
- System.out.println("娲炲簱锛圗GD锛�== valueStr == " + valueStr);
- String endSql3 = null;
- String sqlQur = "";
- if (valueStr.length() > 0) {
- String[] arrStr3 = valueStr.split(",");
- StringBuilder one = new StringBuilder();
- if (arrStr3.length > 0) {
- System.out.println("arrStr = " + arrStr3.length);
- }
- for (int j = 0; j < arrStr3.length; j++) {
- sqlQur = "\'" + arrStr3[j] + "%\' " + "or dircode like";
- one.append(sqlQur);
- }
- endSql3 = " where dircode like " + one.substring(0, one.toString().length() - 15);
- System.out.println("endSql3 = " + endSql3);
- }
- resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql3));
+ if (measurement.equals(oneMapEntity.getValue())) {
+ resList.addAll(queryDirectory(oneMapEntity));
+ } else if (toInvestigate.equals(oneMapEntity.getValue())) {
+ resList.addAll(queryDirectory(oneMapEntity));
+ } else if (disaster.equals(oneMapEntity.getValue())) {
+ resList.addAll(queryDirectory(oneMapEntity));
+ } else if (undergroundStructure.equals(oneMapEntity.getValue())) {
+ resList.addAll(queryDirectory(oneMapEntity));
}
}
return resList;
}
+ /**
+ * 鏌ヨ鐩綍
+ *
+ * @return {@link List}<{@link OneMapEntity}>
+ */
+ public List<OneMapEntity> queryDirectory(OneMapEntity oneMapEntity) {
+ String valueStr = oneMapEntity.getKey();
+ System.out.println(oneMapEntity.getValue() + " == value == " + valueStr);
+ String endSql = null;
+ String sqlQur = "";
+ if (valueStr.length() > 0) {
+ String[] arrStr = valueStr.split(",");
+ StringBuilder one = new StringBuilder();
+ if (arrStr.length > 0) {
+ System.out.println("arrStr = " + arrStr.length);
+ }
+ for (String s : arrStr) {
+ sqlQur = "\'" + s + "%\' " + "or dircode like";
+ one.append(sqlQur);
+ }
+ endSql = " where dircode like " + one.substring(0, one.toString().length() - 15);
+ System.out.println("endSql = " + endSql);
+ }
+ return aMapOfPipelineMapper.selectProjectTypeOne(endSql);
+ }
+
+ /**
+ * 閫夋嫨椤圭洰绫诲瀷涓�
+ *
+ * @param sqlQur sql銆�
+ * @return {@link List}<{@link OneMapEntity}>
+ */
@Override
public List<OneMapEntity> selectProjectTypeOne(String sqlQur) {
return null;
--
Gitblit v1.9.3