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/entity/show/OneMapEntity.java | 67 ++++++++++++++++
src/main/java/com/lf/server/controller/show/OneMapController.java | 5
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 4
src/main/java/com/lf/server/service/show/OneMapService.java | 101 ++++++++++++++++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 14 +++
5 files changed, 184 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/show/OneMapController.java b/src/main/java/com/lf/server/controller/show/OneMapController.java
index 7a25811..03d6951 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -5,6 +5,7 @@
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.bs.MpipelineEntity;
+import com.lf.server.entity.show.OneMapEntity;
import com.lf.server.service.show.OneMapService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -197,8 +198,8 @@
@SysLog()
@ApiOperation(value = "宸ョ▼椤圭洰鐩綍")
@GetMapping("/selectProjectType")
- public ResponseMsg<Object> selectProjectType1() {
- List<String> resList = aMapOfPipelineService.selectProjectType1();
+ public ResponseMsg<Object> selectProjectType() {
+ List<OneMapEntity> resList = aMapOfPipelineService.selectProjectType1();
return success(resList);
}
diff --git a/src/main/java/com/lf/server/entity/show/OneMapEntity.java b/src/main/java/com/lf/server/entity/show/OneMapEntity.java
index 2423b9e..574ab85 100644
--- a/src/main/java/com/lf/server/entity/show/OneMapEntity.java
+++ b/src/main/java/com/lf/server/entity/show/OneMapEntity.java
@@ -1,6 +1,10 @@
package com.lf.server.entity.show;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import lombok.Data;
+
import java.io.Serializable;
+import java.sql.Timestamp;
/**
* 瀹樼綉涓�寮犲浘瀹炰綋
@@ -8,8 +12,71 @@
* @author xing
* @date 2023/02/20
*/
+@Data
public class OneMapEntity implements Serializable {
private static final long serialVersionUID = 1L;
+ /**
+ * value
+ */
+ @JsonIgnore
+ private String value;
+
+ /**
+ * key
+ */
+ @JsonIgnore
+ private String key;
+
+ private int id;
+
+ private String eventid;
+
+ private int metaid;
+
+ private short ismeta;
+
+ private String dircode;
+
+ private String depcode;
+
+ private int verid;
+
+ private String name;
+
+ private String type;
+
+ private String guid;
+
+ private String path;
+
+ private double sizes;
+
+ private String tab;
+
+ private String layer;
+
+ private int rows;
+
+ private int createUser;
+
+ private Timestamp createTime;
+
+ private int updateUser;
+
+ private Timestamp updateTime;
+
+ private String bak;
+
+ private String geom;
+
+ private String uname;
+
+ private String depName;
+
+ private String verName;
+
+ private String dirName;
+
}
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 6489932..7fc6bec 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -1,6 +1,7 @@
package com.lf.server.mapper.show;
import com.lf.server.entity.bs.MpipelineEntity;
+import com.lf.server.entity.show.OneMapEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
@@ -103,7 +104,8 @@
*
* @return {@link List}<{@link String}>
*/
- public List<String> selectProjectType1();
+ public List<OneMapEntity> selectProjectType1();
+ public List<OneMapEntity> selectProjectTypeOne(@Param("endSql") String endSql);
/**
* 鏌ヨ琛ㄤ俊鎭�
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;
}
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 61b6ce8..9086928 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -4,6 +4,11 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.show.OneMapMapper">
+ <resultMap type="com.lf.server.entity.show.OneMapEntity" id="OneMapResult">
+ <result property="value" column="value" />
+ <result property="key" column="key" />
+ </resultMap>
+
<!-- 椤圭洰绫诲埆 select * from bs.bs_project; -->
<select id="projectCategoryCount" resultType="java.util.Map">
@@ -81,13 +86,18 @@
<!-- 缁熻椤圭洰绫诲瀷 1 -->
- <select id="selectProjectType1" resultType="java.util.Map">
+ <select id="selectProjectType1" resultMap="OneMapResult">
select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
where name in ('娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�') group by name order by name;
</select>
<!-- 缁熻椤圭洰绫诲瀷 2 -->
- <select id="selectProjectType2" resultType="java.util.Map">
+ <select id="selectProjectTypeOne" resultType="com.lf.server.entity.show.OneMapEntity">
+ select * from lf.sys_meta ${endSql}
+ </select>
+
+ <!-- 缁熻椤圭洰绫诲瀷 2 -->
+ <select id="selectProjectType2" resultType="com.lf.server.entity.show.OneMapEntity">
select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
</select>
--
Gitblit v1.9.3