From e26af85e049516e6ce2b082bc2bc90bf71643e95 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 24 三月 2023 09:06:30 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/show/OneMapService.java | 291 +++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 207 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..cccce80 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 final String MEASUREMENT = "娴嬮噺锛圗SV锛�";
+ /**
+ * 璋冩煡
+ */
+ private static final String TOINVESTIGATE = "鍕樺療锛圗GE锛�";
+ /**
+ * 鍦扮伨
+ */
+ private static final String DISASTER = "鍦扮伨锛圗GD锛�";
+ /**
+ * 鍦颁笅缁撴瀯娲炲簱
+ */
+ private static final String UNDERGROUNDSTRUCTURE = "娲炲簱锛圗GD锛�";
+
+ /**
* 椤圭洰绫诲埆conut
*/
@Override
@@ -56,6 +73,16 @@
}
/**
+ * 鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectTypeNumber() {
+ return aMapOfPipelineMapper.countProjectTypeNumber();
+ }
+
+ /**
* 鏁版嵁瀛樺偍conut
*
* @return {@link List}<{@link String}>
@@ -63,6 +90,36 @@
@Override
public List<String> dataStorageCount() {
return aMapOfPipelineMapper.dataStorageCount();
+ }
+
+ /**
+ * 缁熻鏁版嵁绫诲埆
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataCategories() {
+ return aMapOfPipelineMapper.statisticalDataCategories();
+ }
+
+ /**
+ * 缁熻鏁版嵁鏈嶅姟绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataServiceType() {
+ return aMapOfPipelineMapper.statisticalDataServiceType();
+ }
+
+ /**
+ * 鐧诲綍浜烘暟缁熻
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> loginNumberStatistics() {
+ return aMapOfPipelineMapper.loginNumberStatistics();
}
/**
@@ -135,102 +192,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;
@@ -246,4 +263,110 @@
public List<String> queryTableInfo(String tableName) {
return aMapOfPipelineMapper.queryTableInfo(tableName);
}
+
+ /**
+ * 璁＄畻鍏ㄧ悆绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countGlobalPipeMap() {
+ return aMapOfPipelineMapper.countGlobalPipeMap();
+ }
+
+ /**
+ * 璁＄畻鍏ㄥ浗绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countNationalPipeMap() {
+ return aMapOfPipelineMapper.countNationalPipeMap();
+ }
+
+ /**
+ * 鍏ㄥ浗绠＄綉鍥捐緭閫佷粙璐ㄩ暱搴�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countZhPipeMapLenByMed() {
+ return aMapOfPipelineMapper.countZhPipeMapLenByMed();
+ }
+
+ /**
+ * 鍏ㄥ浗绔欏満搴ф暟銆侀榾瀹ゃ�佺閬撴暟绛�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countZhPipeStations() {
+ return aMapOfPipelineMapper.countZhPipeStations();
+ }
+
+ /**
+ * 鎸夐」鐩粺璁￠」鐩瓨鍌ㄩ噺
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countStorageByProject() {
+ return aMapOfPipelineMapper.countStorageByProject();
+ }
+
+ /**
+ * 閫夋嫨椤圭洰淇℃伅
+ * 鏌ヨ椤圭洰淇℃伅
+ *
+ * @param projectName 椤圭洰鍚嶇О
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectInfo(String projectCode) {
+ return aMapOfPipelineMapper.selectProjectInfo(projectCode);
+ }
+
+ /**
+ * 閫夋嫨椤圭洰鏂囦欢鍒楄〃
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectFileList() {
+ return aMapOfPipelineMapper.selectProjectFileList();
+ }
+
+ /**
+ * 璁＄畻瀛樺偍椤圭洰
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectStorage(String projectCode) {
+ return aMapOfPipelineMapper.countProjectStorage(projectCode);
+ }
+
+ /**
+ * 鍗曚釜椤圭洰鏂囦欢鏁伴噺
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectType(String projectCode) {
+ return aMapOfPipelineMapper.countProjectType(projectCode);
+ }
+
+ /**
+ * 缁熻椤圭洰涓�
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectDown(String projectCode) {
+ return aMapOfPipelineMapper.countProjectDown(projectCode);
+ }
+
}
--
Gitblit v1.9.3