From 218e763626af7cd58f61135f510c8992912b8dc4 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 12 三月 2024 14:17:37 +0800
Subject: [PATCH] 修改 单个项目文件数量 接口
---
src/main/java/com/lf/server/service/show/OneMapService.java | 208 +++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 180 insertions(+), 28 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 3e4cdad..599dbd9 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -1,6 +1,7 @@
package com.lf.server.service.show;
import com.lf.server.entity.bs.MpipelineEntity;
+import com.lf.server.entity.ctrl.CountEntity;
import com.lf.server.entity.show.OneMapEntity;
import com.lf.server.mapper.show.OneMapMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -8,6 +9,7 @@
import java.util.ArrayList;
import java.util.List;
+import java.util.Map;
/**
* 绠＄綉涓�寮犲浘Service
@@ -17,31 +19,31 @@
@Service
public class OneMapService implements OneMapMapper {
@Autowired
- OneMapMapper aMapOfPipelineMapper;
+ OneMapMapper oneMapMapper;
/**
- * 娴嬮噺
+ * 娴嬬粯
*/
- private static String measurement = "娴嬮噺锛圗SV锛�";
+ private static final String MEASUREMENT = "娴嬬粯锛圗SV锛�";
/**
* 璋冩煡
*/
- private static String toInvestigate = "鍕樺療锛圗GE锛�";
+ private static final String TOINVESTIGATE = "鍕樺療锛圗GE锛�";
/**
* 鍦扮伨
*/
- private static String disaster = "鍦扮伨锛圗GD锛�";
+ private static final String DISASTER = "鍦扮伨锛圗GD锛�";
/**
* 鍦颁笅缁撴瀯娲炲簱
*/
- private static String undergroundStructure = "娲炲簱锛圗GD锛�";
+ private static final String UNDERGROUNDSTRUCTURE = "娲炲簱锛圗GD锛�";
/**
* 椤圭洰绫诲埆conut
*/
@Override
public List<String> projectCategoryCount() {
- return aMapOfPipelineMapper.projectCategoryCount();
+ return oneMapMapper.projectCategoryCount();
}
/**
@@ -51,7 +53,7 @@
*/
@Override
public List<String> projectLocationCount() {
- return aMapOfPipelineMapper.projectLocationCount();
+ return oneMapMapper.projectLocationCount();
}
/**
@@ -59,7 +61,7 @@
*/
@Override
public List<String> countryDimensionCount() {
- return aMapOfPipelineMapper.countryDimensionCount();
+ return oneMapMapper.countryDimensionCount();
}
/**
@@ -69,7 +71,17 @@
*/
@Override
public List<String> provinceDimensionCount() {
- return aMapOfPipelineMapper.provinceDimensionCount();
+ return oneMapMapper.provinceDimensionCount();
+ }
+
+ /**
+ * 鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectTypeNumber() {
+ return oneMapMapper.countProjectTypeNumber();
}
/**
@@ -79,7 +91,37 @@
*/
@Override
public List<String> dataStorageCount() {
- return aMapOfPipelineMapper.dataStorageCount();
+ return oneMapMapper.dataStorageCount();
+ }
+
+ /**
+ * 缁熻鏁版嵁绫诲埆
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataCategories() {
+ return oneMapMapper.statisticalDataCategories();
+ }
+
+ /**
+ * 缁熻鏁版嵁鏈嶅姟绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataServiceType() {
+ return oneMapMapper.statisticalDataServiceType();
+ }
+
+ /**
+ * 鐧诲綍浜烘暟缁熻
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> loginNumberStatistics() {
+ return oneMapMapper.loginNumberStatistics();
}
/**
@@ -89,7 +131,7 @@
*/
@Override
public List<String> fileFormatCount() {
- return aMapOfPipelineMapper.fileFormatCount();
+ return oneMapMapper.fileFormatCount();
}
/**
@@ -99,7 +141,7 @@
*/
@Override
public List<String> dataApplyCount() {
- return aMapOfPipelineMapper.dataApplyCount();
+ return oneMapMapper.dataApplyCount();
}
/**
@@ -109,7 +151,7 @@
*/
@Override
public List<String> dataVisitCount() {
- return aMapOfPipelineMapper.dataVisitCount();
+ return oneMapMapper.dataVisitCount();
}
/**
@@ -119,7 +161,7 @@
*/
@Override
public List<String> countDownloads() {
- return aMapOfPipelineMapper.countDownloads();
+ return oneMapMapper.countDownloads();
}
/**
@@ -129,7 +171,7 @@
*/
@Override
public List<String> countProjectDisplay() {
- return aMapOfPipelineMapper.countProjectDisplay();
+ return oneMapMapper.countProjectDisplay();
}
/**
@@ -139,7 +181,7 @@
*/
@Override
public List<String> countProjectTour(MpipelineEntity mpipelineEntity) {
- return aMapOfPipelineMapper.countProjectTour(mpipelineEntity);
+ return oneMapMapper.countProjectTour(mpipelineEntity);
}
/**
@@ -149,7 +191,7 @@
*/
@Override
public List<String> selectProjectTour() {
- return aMapOfPipelineMapper.selectProjectTour();
+ return oneMapMapper.selectProjectTour();
}
@@ -161,15 +203,15 @@
@Override
public List<OneMapEntity> selectProjectType1() {
List<OneMapEntity> resList = new ArrayList<>();
- List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1();
+ List<OneMapEntity> resInfo = oneMapMapper.selectProjectType1();
for (OneMapEntity oneMapEntity : resInfo) {
- if (measurement.equals(oneMapEntity.getValue())) {
+ if (MEASUREMENT.equals(oneMapEntity.getValue())) {
resList.addAll(queryDirectory(oneMapEntity));
- } else if (toInvestigate.equals(oneMapEntity.getValue())) {
+ } else if (TOINVESTIGATE.equals(oneMapEntity.getValue())) {
resList.addAll(queryDirectory(oneMapEntity));
- } else if (disaster.equals(oneMapEntity.getValue())) {
+ } else if (DISASTER.equals(oneMapEntity.getValue())) {
resList.addAll(queryDirectory(oneMapEntity));
- } else if (undergroundStructure.equals(oneMapEntity.getValue())) {
+ } else if (UNDERGROUNDSTRUCTURE.equals(oneMapEntity.getValue())) {
resList.addAll(queryDirectory(oneMapEntity));
}
}
@@ -185,7 +227,7 @@
String valueStr = oneMapEntity.getKey();
System.out.println(oneMapEntity.getValue() + " == value == " + valueStr);
String endSql = null;
- String sqlQur = "";
+ String sqlQur;
if (valueStr.length() > 0) {
String[] arrStr = valueStr.split(",");
StringBuilder one = new StringBuilder();
@@ -193,19 +235,19 @@
System.out.println("arrStr = " + arrStr.length);
}
for (String s : arrStr) {
- sqlQur = "\'" + s + "%\' " + "or dircode like";
+ 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);
+ return oneMapMapper.selectProjectTypeOne(endSql);
}
/**
* 閫夋嫨椤圭洰绫诲瀷涓�
*
- * @param sqlQur sql銆�
+ * @param sqlQur sql
* @return {@link List}<{@link OneMapEntity}>
*/
@Override
@@ -221,6 +263,116 @@
*/
@Override
public List<String> queryTableInfo(String tableName) {
- return aMapOfPipelineMapper.queryTableInfo(tableName);
+ return oneMapMapper.queryTableInfo(tableName);
+ }
+
+ /**
+ * 璁＄畻鍏ㄧ悆绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countGlobalPipeMap() {
+ return oneMapMapper.countGlobalPipeMap();
+ }
+
+ /**
+ * 璁＄畻鍏ㄥ浗绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countNationalPipeMap() {
+ return oneMapMapper.countNationalPipeMap();
+ }
+
+ /**
+ * 鍏ㄥ浗绠＄綉鍥捐緭閫佷粙璐ㄩ暱搴�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countZhPipeMapLenByMed() {
+ return oneMapMapper.countZhPipeMapLenByMed();
+ }
+
+ /**
+ * 鍏ㄥ浗绔欏満搴ф暟銆侀榾瀹ゃ�佺閬撴暟绛�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countZhPipeStations() {
+ return oneMapMapper.countZhPipeStations();
+ }
+
+ /**
+ * 鎸夐」鐩粺璁￠」鐩瓨鍌ㄩ噺
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countStorageByProject() {
+ return oneMapMapper.countStorageByProject();
+ }
+
+ /**
+ * 閫夋嫨椤圭洰淇℃伅
+ * 鏌ヨ椤圭洰淇℃伅
+ *
+ * @param projectCode 椤圭洰鍚嶇О
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectInfo(String projectCode) {
+ return oneMapMapper.selectProjectInfo(projectCode);
+ }
+
+ /**
+ * 閫夋嫨椤圭洰鏂囦欢鍒楄〃
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectFileList() {
+ return oneMapMapper.selectProjectFileList();
+ }
+
+ /**
+ * 璁＄畻瀛樺偍椤圭洰
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectStorage(String projectCode) {
+ return oneMapMapper.countProjectStorage(projectCode);
+ }
+
+ /**
+ * 鍗曚釜椤圭洰鏂囦欢鏁伴噺
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<Map<String, Object>> countProjectType(String projectCode) {
+ return oneMapMapper.countProjectType(projectCode);
+ }
+
+ /**
+ * 缁熻椤圭洰涓�
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectDown(String projectCode) {
+ return oneMapMapper.countProjectDown(projectCode);
+ }
+
+ @Override
+ public List<CountEntity> countByMajor() {
+ return oneMapMapper.countByMajor();
}
}
--
Gitblit v1.9.3