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/mapper/show/OneMapMapper.java   |    1 
 src/main/java/com/lf/server/service/show/OneMapService.java |  145 ++++++++++++++++++++----------------------------
 2 files changed, 62 insertions(+), 84 deletions(-)

diff --git a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
index 0a438cb..bbc1632 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -88,6 +88,7 @@
     /**
      * 缁熻椤圭洰鍙傝
      *
+     * @param mpipelineEntity mpipeline瀹炰綋
      * @return {@link List}<{@link String}>
      */
     public List<String> countProjectTour(MpipelineEntity mpipelineEntity);
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