From 970bc6b960117a15e6e7d87d0615ab0371b15708 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期三, 22 二月 2023 14:01:17 +0800
Subject: [PATCH] 20230221@xingjs@提交官网一张图相关内容接口
---
src/main/java/com/lf/server/service/show/OneMapService.java | 101 +++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 99 insertions(+), 2 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 37547b5..c3b6bd6 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -1,14 +1,17 @@
package com.lf.server.service.show;
import com.lf.server.entity.bs.MpipelineEntity;
+import com.lf.server.entity.show.OneMapEntity;
import com.lf.server.mapper.show.OneMapMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import java.util.ArrayList;
import java.util.List;
/**
* 绠＄綉涓�寮犲浘Service
+ *
* @author 閭㈤敠鍙�
*/
@Service
@@ -137,9 +140,103 @@
*
* @return {@link List}<{@link String}>
*/
+ public List<OneMapEntity> selectProjectType1() {
+
+
+ List<OneMapEntity> resList = new ArrayList<>();
+
+ List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1();
+ for (int i = 0; i < resInfo.size(); i++) {
+ if (resInfo.get(i).getValue().equals("娴嬮噺锛圗SV锛�")) {
+
+ String valueStr = resInfo.get(i).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 (int j = 0; j < arrStr.length; j++) {
+ sqlQur = "\'" + arrStr[j] + "%\' " + "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 (resInfo.get(i).getValue().equals("鍕樺療锛圗GE锛�")) {
+
+ String valueStr = resInfo.get(i).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 (int j = 0; j < arrStr1.length; j++) {
+ sqlQur = "\'" + arrStr1[j] + "%\' " + "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 (resInfo.get(i).getValue().equals("鍦扮伨锛圗GD锛�")) {
+ String valueStr = resInfo.get(i).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 (resInfo.get(i).getValue().equals("娲炲簱锛圗GD锛�")) {
+ String valueStr = resInfo.get(i).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));
+ }
+ }
+ return resList;
+ }
+
@Override
- public List<String> selectProjectType1() {
- return aMapOfPipelineMapper.selectProjectType1();
+ public List<OneMapEntity> selectProjectTypeOne(String sqlQur) {
+ return null;
}
--
Gitblit v1.9.3