From 593ded3205553e24003e8bd95753cc9b88013a1b Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 21 二月 2023 09:52:18 +0800
Subject: [PATCH] 20230221@xingjs@提交官网一张图相关内容接口
---
src/main/java/com/lf/server/entity/show/OneMapEntity.java | 12 +
src/main/java/com/lf/server/controller/show/OneMapController.java | 152 +++++++++++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 71 ++++++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 81 +++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 54 +++++++
5 files changed, 370 insertions(+), 0 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
new file mode 100644
index 0000000..1137f68
--- /dev/null
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -0,0 +1,152 @@
+package com.lf.server.controller.show;
+
+
+import com.lf.server.controller.all.BaseController;
+import com.lf.server.entity.all.ResponseMsg;
+import com.lf.server.service.show.OneMapService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import java.util.List;
+
+/**
+ * 绠＄綉涓�寮犲浘
+ * aFigurePipelineNetwork
+ *
+ * @author xing
+ * @date 2023/02/13
+ */
+
+@Api(tags = "绠＄綉涓�寮犲浘")
+@RestController
+@RequestMapping("/one_Map")
+public class OneMapController extends BaseController {
+
+ @Autowired
+ OneMapService aMapOfPipelineService;
+
+ //@SysLog()
+ @GetMapping("/hello")
+ public ResponseMsg<Object> hello() {
+ System.out.println("log = " + log);
+ return success("hello! 鎮ㄥ凡缁忔垚鍔熻闂�", 1);
+ }
+
+
+ //============[椤圭洰缁熻 project Statistics]==================
+
+ /**
+ * 椤圭洰绫诲埆
+ * Project category
+ */
+ @ApiOperation(value = "椤圭洰绫诲埆")
+ @GetMapping("/countProjectCategory")
+ public ResponseMsg<Object> projectCategoryConut() {
+ List<String> resList = aMapOfPipelineService.projectCategoryConut();
+ return success(resList);
+ }
+
+ /**
+ * 椤圭洰浣嶇疆鍒嗗竷鎺ュ彛
+ * Project location
+ */
+ @ApiOperation(value = "椤圭洰浣嶇疆鍒嗗竷鎺ュ彛")
+ @GetMapping("/countProjectLocation")
+ public ResponseMsg<Object> projectLocationConut() {
+ List<String> resList = aMapOfPipelineService.projectLocationConut();
+ return success(resList);
+ }
+
+
+ /**
+ * 鍥藉缁村害-鏁伴噺缁熻
+ * Country dimension
+ */
+ @ApiOperation(value = "鍥藉缁村害-鏁伴噺缁熻")
+ @GetMapping("/conutCountryDimension")
+ public ResponseMsg<Object> countryDimensionConut() {
+ List<String> resList = aMapOfPipelineService.countryDimensionConut();
+ return success(resList);
+ }
+
+ /**
+ * 鐪佺淮搴�-鏁伴噺缁熻
+ * Province dimension - quantity
+ */
+ @ApiOperation(value = "鐪佺淮搴�-鏁伴噺缁熻")
+ @GetMapping("/conutProvinceDimension")
+ public ResponseMsg<Object> provinceDimensionConut() {
+ List<String> resList = aMapOfPipelineService.provinceDimensionConut();
+ return success(resList);
+ }
+
+
+ //============[鏁版嵁缁熻 data Statistics]==================
+
+ /**
+ * 鏁版嵁缁熻
+ * 鏁版嵁瀛樺偍
+ * data storage
+ */
+ @ApiOperation(value = "鏁版嵁瀛樺偍缁熻")
+ @GetMapping("/countDataStorage")
+ public ResponseMsg<Object> dataStorageConut() {
+ List<String> resList = aMapOfPipelineService.dataStorageConut();
+ return success(resList);
+ }
+
+ /**
+ * 鏁版嵁缁熻
+ * 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟
+ * File format dimension
+ */
+ @ApiOperation(value = "鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟")
+ @GetMapping("/conutFileFormat")
+ public ResponseMsg<Object> fileFormatConut() {
+ List<String> resList = aMapOfPipelineService.fileFormatConut();
+ return success(resList);
+ }
+
+ /**
+ * 鏁版嵁缁熻
+ * 鏁版嵁鐢宠
+ * Data application
+ */
+ @ApiOperation(value = "鏁版嵁鐢宠")
+ @GetMapping("/conutDataApply")
+ public ResponseMsg<Object> dataApplyConut() {
+ List<String> resList = aMapOfPipelineService.dataApplyConut();
+ return success(resList);
+ }
+
+ /**
+ * 鏁版嵁缁熻
+ * 璁块棶娆℃暟
+ * Number of visits
+ */
+ @ApiOperation(value = "璁块棶娆℃暟")
+ @GetMapping("/conutDataVisit")
+ public ResponseMsg<Object> dataVisitConut() {
+ List<String> resList = aMapOfPipelineService.dataVisitConut();
+ return success(resList);
+ }
+
+
+ /**
+ * 鏁版嵁缁熻
+ * 璁块棶娆℃暟
+ * Number of visits
+ */
+ @ApiOperation(value = "璁块棶娆℃暟")
+ @GetMapping("data_visit1")
+ public ResponseMsg<Object> dataVisitConut1() {
+ List<String> resList = aMapOfPipelineService.dataVisitConut();
+ 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
new file mode 100644
index 0000000..7c73c49
--- /dev/null
+++ b/src/main/java/com/lf/server/entity/show/OneMapEntity.java
@@ -0,0 +1,12 @@
+package com.lf.server.entity.show;
+
+import java.io.Serializable;
+
+public class OneMapEntity implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+
+
+
+
+}
diff --git a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
new file mode 100644
index 0000000..1f845fd
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -0,0 +1,71 @@
+package com.lf.server.mapper.show;
+
+
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.stereotype.Repository;
+
+import java.util.List;
+
+@Mapper
+@Repository
+public interface OneMapMapper {
+
+
+ /**
+ * 椤圭洰绫诲埆conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> projectCategoryConut();
+
+ /**
+ * 椤圭洰浣嶇疆conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> projectLocationConut();
+
+ /**
+ * 鍥藉缁村害conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countryDimensionConut();
+
+ /**
+ * 鐪佺淮conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> provinceDimensionConut();
+
+ /**
+ * 鏁版嵁瀛樺偍conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> dataStorageConut();
+
+ /**
+ * 鏂囦欢鏍煎紡conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> fileFormatConut();
+
+ /**
+ * 鏁版嵁鐢宠conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> dataApplyConut();
+
+ /**
+ * 鏁版嵁璁块棶conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> dataVisitConut();
+
+
+}
diff --git a/src/main/java/com/lf/server/service/show/OneMapService.java b/src/main/java/com/lf/server/service/show/OneMapService.java
new file mode 100644
index 0000000..f0e2117
--- /dev/null
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -0,0 +1,81 @@
+package com.lf.server.service.show;
+
+import com.lf.server.mapper.show.OneMapMapper;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+@Service
+public class OneMapService implements OneMapMapper {
+
+ @Autowired
+ OneMapMapper aMapOfPipelineMapper;
+
+ /**
+ * 椤圭洰绫诲埆conut
+ */
+ public List<String> projectCategoryConut() {
+ return aMapOfPipelineMapper.projectCategoryConut();
+ }
+
+ /**
+ * 椤圭洰浣嶇疆conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> projectLocationConut() {
+ return aMapOfPipelineMapper.projectLocationConut();
+ }
+
+
+ /**
+ * 鍥藉缁村害conut
+ */
+ public List<String> countryDimensionConut() {
+ return aMapOfPipelineMapper.countryDimensionConut();
+ }
+
+
+ /**
+ * 鐪佺淮conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> provinceDimensionConut() {
+ return aMapOfPipelineMapper.provinceDimensionConut();
+ }
+
+ /**
+ * 鏁版嵁瀛樺偍conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> dataStorageConut() {
+ return aMapOfPipelineMapper.dataStorageConut();
+ }
+
+ /**
+ * 鏂囦欢鏍煎紡conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> fileFormatConut() {
+ return aMapOfPipelineMapper.fileFormatConut();
+ }
+
+ /**
+ * 鏁版嵁鐢宠conut
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> dataApplyConut() {
+ return aMapOfPipelineMapper.dataApplyConut();
+ }
+
+ public List<String> dataVisitConut() {
+ return aMapOfPipelineMapper.dataVisitConut();
+ }
+
+
+}
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
new file mode 100644
index 0000000..4de1b0a
--- /dev/null
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper
+ PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+ "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.lf.server.mapper.show.OneMapMapper">
+
+
+ <!-- 椤圭洰绫诲埆 select * from bs.bs_project; -->
+ <select id="projectCategoryConut" resultType="java.util.Map">
+ select projtype,count(*) from bs.bs_project group by projtype;
+ </select>
+
+
+ <!-- 椤圭洰浣嶇疆鍒嗗竷 select a.*,st_astext(geom) from bs.bs_project a -->
+ <select id="projectLocationConut" resultType="java.util.Map">
+ select a.*,st_astext(geom) from bs.bs_project a;
+ </select>
+
+ <!-- 椤圭洰绫诲埆 鍥藉缁村害-鏁伴噺 -->
+ <select id="countryDimensionConut" resultType="java.util.Map">
+ select country,count(*) from bs.bs_project group by country;
+ </select>
+
+ <!-- 椤圭洰绫诲埆 鐪佺淮搴�-鏁伴噺 -->
+ <select id="provinceDimensionConut" resultType="java.util.Map">
+ select province,count(*) from bs.bs_project where country like '%涓浗%' group by province ;
+ </select>
+
+ <!-- 鏁版嵁缁熻 鏁版嵁瀛樺偍 -->
+ <select id="dataStorageConut" resultType="java.util.Map">
+ select name "鍚嶇О", (select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "鏂囦欢鏁�",
+ (select count(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "鏁伴噺(MB)"
+ from lf.sys_dir a where id > 1 and pid = 0;
+ </select>
+
+ <!-- 鏁版嵁缁熻 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟 -->
+ <select id="fileFormatConut" resultType="java.util.Map">
+ select type,count(*),count(sizes) from lf.sys_meta group by type;
+ </select>
+
+ <!-- 鏁版嵁缁熻 鏁版嵁鐢宠 -->
+ <select id="dataApplyConut" resultType="java.util.Map">
+ select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id;
+ </select>
+
+ <!-- 鏁版嵁缁熻 璁块棶缁熻 -->
+ <select id="dataVisitConut" resultType="java.util.Map">
+ select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
+ </select>
+
+
+
+
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3