开发一张图的按大类统计数据功能

13693261870

2024-03-06 26d835757ba7134db69557c23efe1215e4bf978e

开发一张图的按大类统计数据功能

 src/main/java/com/lf/server/controller/show/OneMapController.java

@@ -4,6 +4,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.ctrl.CountEntity;
import com.lf.server.entity.show.OneMapEntity;
import com.lf.server.service.show.OneMapService;
import io.swagger.annotations.Api;
@@ -27,9 +28,8 @@
@RestController
@RequestMapping("/oneMap")
public class OneMapController extends BaseController {

    @Autowired
    OneMapService aMapOfPipelineService;
    OneMapService oneMapService;

    //============[项目统计 project Statistics]==================

@@ -41,7 +41,7 @@
    @ApiOperation(value = "项目类别")
    @GetMapping("/countProjectCategory")
    public ResponseMsg<Object> projectCategoryCount() {
        List<String> resList = aMapOfPipelineService.projectCategoryCount();
        List<String> resList = oneMapService.projectCategoryCount();
        return success(resList);
    }

@@ -53,7 +53,7 @@
    @ApiOperation(value = "项目位置分布接口")
    @GetMapping("/countProjectLocation")
    public ResponseMsg<Object> projectLocationCount() {
        List<String> resList = aMapOfPipelineService.projectLocationCount();
        List<String> resList = oneMapService.projectLocationCount();
        return success(resList);
    }

@@ -65,7 +65,7 @@
    @ApiOperation(value = "国家维度-数量统计")
    @GetMapping("/countCountryDimension")
    public ResponseMsg<Object> countryDimensionCount() {
        List<String> resList = aMapOfPipelineService.countryDimensionCount();
        List<String> resList = oneMapService.countryDimensionCount();
        return success(resList);
    }

@@ -77,7 +77,7 @@
    @ApiOperation(value = "省维度-数量统计")
    @GetMapping("/countProvinceDimension")
    public ResponseMsg<Object> provinceDimensionCount() {
        List<String> resList = aMapOfPipelineService.provinceDimensionCount();
        List<String> resList = oneMapService.provinceDimensionCount();
        return success(resList);
    }

@@ -89,7 +89,7 @@
    @ApiOperation(value = "全国维度-按照项自类型统计不同项目个数")
    @GetMapping("/countProjectTypeNumber")
    public ResponseMsg<Object> countProjectTypeNumber() {
        List<String> resList = aMapOfPipelineService.countProjectTypeNumber();
        List<String> resList = oneMapService.countProjectTypeNumber();
        return success(resList);
    }

@@ -104,7 +104,7 @@
    @ApiOperation(value = "数据存储统计")
    @GetMapping("/countDataStorage")
    public ResponseMsg<Object> dataStorageCount() {
        List<String> resList = aMapOfPipelineService.dataStorageCount();
        List<String> resList = oneMapService.dataStorageCount();
        return success(resList);
    }

@@ -116,7 +116,7 @@
    @ApiOperation(value = "数据大类统计")
    @GetMapping("/countLargeCategories")
    public ResponseMsg<Object> statisticalDataCategories() {
        List<String> resList = aMapOfPipelineService.statisticalDataCategories();
        List<String> resList = oneMapService.statisticalDataCategories();
        return success(resList);
    }

@@ -128,7 +128,7 @@
    @ApiOperation(value = "数据服务类型统计")
    @GetMapping("/countDataServiceType")
    public ResponseMsg<Object> statisticalDataServiceType() {
        List<String> resList = aMapOfPipelineService.statisticalDataServiceType();
        List<String> resList = oneMapService.statisticalDataServiceType();
        return success(resList);
    }

@@ -140,7 +140,7 @@
    @ApiOperation(value = "登录次数统计")
    @GetMapping("/countLoginNumber")
    public ResponseMsg<Object> loginNumberStatistics() {
        List<String> resList = aMapOfPipelineService.loginNumberStatistics();
        List<String> resList = oneMapService.loginNumberStatistics();
        return success(resList);
    }

@@ -153,7 +153,7 @@
    @ApiOperation(value = "文件格式维度-文件个数")
    @GetMapping("/countFileFormat")
    public ResponseMsg<Object> fileFormatCount() {
        List<String> resList = aMapOfPipelineService.fileFormatCount();
        List<String> resList = oneMapService.fileFormatCount();
        return success(resList);
    }

@@ -166,7 +166,7 @@
    @ApiOperation(value = "数据申请")
    @GetMapping("/countDataApply")
    public ResponseMsg<Object> dataApplyCount() {
        List<String> resList = aMapOfPipelineService.dataApplyCount();
        List<String> resList = oneMapService.dataApplyCount();
        return success(resList);
    }

@@ -179,7 +179,7 @@
    @ApiOperation(value = "访问次数")
    @GetMapping("/countDataVisit")
    public ResponseMsg<Object> dataVisitCount() {
        List<String> resList = aMapOfPipelineService.dataVisitCount();
        List<String> resList = oneMapService.dataVisitCount();
        return success(resList);
    }

@@ -192,7 +192,7 @@
    @ApiOperation(value = "下载量统计")
    @GetMapping("/countDownloads")
    public ResponseMsg<Object> countDownloads() {
        List<String> resList = aMapOfPipelineService.countDownloads();
        List<String> resList = oneMapService.countDownloads();
        return success(resList);
    }

@@ -204,7 +204,7 @@
    @ApiOperation(value = "项目工程展示")
    @GetMapping("/countProjectDisplay")
    public ResponseMsg<Object> countProjectDisplay() {
        List<String> resList = aMapOfPipelineService.countProjectDisplay();
        List<String> resList = oneMapService.countProjectDisplay();
        return success(resList);
    }

@@ -216,7 +216,7 @@
    @ApiOperation(value = "项目工程巡视")
    @GetMapping("/countProjectTour")
    public ResponseMsg<Object> countProjectTour(MpipelineEntity mpipelineEntity) {
        List<String> resList = aMapOfPipelineService.countProjectTour(mpipelineEntity);
        List<String> resList = oneMapService.countProjectTour(mpipelineEntity);

        return success("hello! 您已经成功访问-项目工程巡视", resList);
    }
@@ -229,7 +229,7 @@
    @ApiOperation(value = "项目工程巡视列表")
    @GetMapping("/selectProjectTour")
    public ResponseMsg<Object> selectProjectTour() {
        List<String> resList = aMapOfPipelineService.selectProjectTour();
        List<String> resList = oneMapService.selectProjectTour();
        return success(resList);
    }

@@ -241,7 +241,7 @@
    @ApiOperation(value = "工程项目目录")
    @GetMapping("/selectProjectType")
    public ResponseMsg<Object> selectProjectType() {
        List<OneMapEntity> resList = aMapOfPipelineService.selectProjectType1();
        List<OneMapEntity> resList = oneMapService.selectProjectType1();
        return success(resList);
    }

@@ -252,7 +252,7 @@
    @ApiOperation(value = "根据表名查询表字段信息")
    @GetMapping("/selectTableInfo")
    public ResponseMsg<Object> selectTableInfo(@RequestParam("tableName") String tableName) {
        List<String> resList = aMapOfPipelineService.queryTableInfo(tableName);
        List<String> resList = oneMapService.queryTableInfo(tableName);
        return success(resList);
    }

@@ -266,7 +266,7 @@
    @ApiOperation(value = "全球管网图")
    @GetMapping("/countGlobalPipeMap")
    public ResponseMsg<Object> countGlobalPipeMap() {
        List<String> resList = aMapOfPipelineService.countGlobalPipeMap();
        List<String> resList = oneMapService.countGlobalPipeMap();
        return success(resList);
    }

@@ -278,7 +278,7 @@
    @ApiOperation(value = "全国管网图")
    @GetMapping("/countNationalPipeMap")
    public ResponseMsg<Object> countNationalPipeMap() {
        List<String> resList = aMapOfPipelineService.countNationalPipeMap();
        List<String> resList = oneMapService.countNationalPipeMap();
        return success(resList);
    }

@@ -290,7 +290,7 @@
    @ApiOperation(value = "全国管网图输送介质长度")
    @GetMapping("/countZhPipeMapLength")
    public ResponseMsg<Object> countZhPipeMapLenByMed() {
        List<String> resList = aMapOfPipelineService.countZhPipeMapLenByMed();
        List<String> resList = oneMapService.countZhPipeMapLenByMed();
        return success(resList);
    }

@@ -302,7 +302,7 @@
    @ApiOperation(value = "全国站场座数、阀室、管道数等")
    @GetMapping("/countZhPipeStations")
    public ResponseMsg<Object> countZhPipeStations() {
        List<String> resList = aMapOfPipelineService.countZhPipeStations();
        List<String> resList = oneMapService.countZhPipeStations();
        return success(resList);
    }

@@ -314,7 +314,7 @@
    @ApiOperation(value = "按项目统计项目存储量")
    @GetMapping("/countStorageByProject")
    public ResponseMsg<Object> countStorageByProject() {
        List<String> resList = aMapOfPipelineService.countStorageByProject();
        List<String> resList = oneMapService.countStorageByProject();
        return success(resList);
    }

@@ -328,7 +328,7 @@
    @ApiOperation(value = "项目信息查询")
    @GetMapping("/selectProjectInfo")
    public ResponseMsg<Object> selectProjectInfo(@RequestParam("projectCode") String projectCode) {
        List<String> resList = aMapOfPipelineService.selectProjectInfo(projectCode);
        List<String> resList = oneMapService.selectProjectInfo(projectCode);
        return success(resList);
    }
    /**
@@ -339,7 +339,7 @@
    @ApiOperation(value = "项目文件列表查询")
    @GetMapping("/selectProjectFileList")
    public ResponseMsg<Object> selectProjectFileList() {
        List<String> resList = aMapOfPipelineService.selectProjectFileList();
        List<String> resList = oneMapService.selectProjectFileList();
        return success(resList);
    }

@@ -353,7 +353,7 @@
    @ApiOperation(value = "单个项目存储量")
    @GetMapping("/countProjectStorage")
    public ResponseMsg<Object> countProjectStorage(@RequestParam("projectCode") String projectCode) {
        List<String> resList = aMapOfPipelineService.countProjectStorage(projectCode);
        List<String> resList = oneMapService.countProjectStorage(projectCode);
        return success(resList);
    }

@@ -368,7 +368,7 @@
    @ApiOperation(value = "单个项目文件类型数量")
    @GetMapping("/countProjectType")
    public ResponseMsg<Object> countProjectType(@RequestParam("projectCode") String projectCode) {
        List<String> resList = aMapOfPipelineService.countProjectType(projectCode);
        List<String> resList = oneMapService.countProjectType(projectCode);
        return success(resList);
    }

@@ -383,7 +383,22 @@
    @ApiOperation(value = "单个项目下载量")
    @GetMapping("/countProjectDown")
    public ResponseMsg<Object> countProjectDown(@RequestParam("projectCode") String projectCode) {
        List<String> resList = aMapOfPipelineService.countProjectDown(projectCode);
        List<String> resList = oneMapService.countProjectDown(projectCode);
        return success(resList);
    }

    // ============[ 数据统计 - 2024-03-06]============
    @SysLog()
    @ApiOperation(value = "数据统计(按大类统计)")
    @GetMapping("/countByMajor")
    public ResponseMsg<Object> countByMajor(){
        try {
            List<CountEntity> list = oneMapService.countByMajor();

            return success(list);
        }catch (Exception ex){
            log.error(ex.getMessage(), ex);
            return fail(ex.getMessage());
        }
    }
}

 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.ctrl.CountEntity;
import com.lf.server.entity.show.OneMapEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@@ -226,4 +227,11 @@
     * @return {@link List}<{@link String}>
     */
    public List<String> countProjectDown(String projectCode);

    /**
     * 按大类统计 - 数据统计
     *
     * @return
     */
    public List<CountEntity> countByMajor();
}

 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;
@@ -17,7 +18,7 @@
@Service
public class OneMapService implements OneMapMapper {
    @Autowired
    OneMapMapper aMapOfPipelineMapper;
    OneMapMapper oneMapMapper;

    /**
     * 测绘
@@ -41,7 +42,7 @@
     */
    @Override
    public List<String> projectCategoryCount() {
        return aMapOfPipelineMapper.projectCategoryCount();
        return oneMapMapper.projectCategoryCount();
    }

    /**
@@ -51,7 +52,7 @@
     */
    @Override
    public List<String> projectLocationCount() {
        return aMapOfPipelineMapper.projectLocationCount();
        return oneMapMapper.projectLocationCount();
    }

    /**
@@ -59,7 +60,7 @@
     */
    @Override
    public List<String> countryDimensionCount() {
        return aMapOfPipelineMapper.countryDimensionCount();
        return oneMapMapper.countryDimensionCount();
    }

    /**
@@ -69,7 +70,7 @@
     */
    @Override
    public List<String> provinceDimensionCount() {
        return aMapOfPipelineMapper.provinceDimensionCount();
        return oneMapMapper.provinceDimensionCount();
    }

    /**
@@ -79,7 +80,7 @@
     */
    @Override
    public List<String> countProjectTypeNumber() {
        return aMapOfPipelineMapper.countProjectTypeNumber();
        return oneMapMapper.countProjectTypeNumber();
    }

    /**
@@ -89,7 +90,7 @@
     */
    @Override
    public List<String> dataStorageCount() {
        return aMapOfPipelineMapper.dataStorageCount();
        return oneMapMapper.dataStorageCount();
    }

    /**
@@ -99,7 +100,7 @@
     */
    @Override
    public List<String> statisticalDataCategories() {
        return aMapOfPipelineMapper.statisticalDataCategories();
        return oneMapMapper.statisticalDataCategories();
    }

    /**
@@ -109,7 +110,7 @@
     */
    @Override
    public List<String> statisticalDataServiceType() {
        return aMapOfPipelineMapper.statisticalDataServiceType();
        return oneMapMapper.statisticalDataServiceType();
    }

    /**
@@ -119,7 +120,7 @@
     */
    @Override
    public List<String> loginNumberStatistics() {
        return aMapOfPipelineMapper.loginNumberStatistics();
        return oneMapMapper.loginNumberStatistics();
    }

    /**
@@ -129,7 +130,7 @@
     */
    @Override
    public List<String> fileFormatCount() {
        return aMapOfPipelineMapper.fileFormatCount();
        return oneMapMapper.fileFormatCount();
    }

    /**
@@ -139,7 +140,7 @@
     */
    @Override
    public List<String> dataApplyCount() {
        return aMapOfPipelineMapper.dataApplyCount();
        return oneMapMapper.dataApplyCount();
    }

    /**
@@ -149,7 +150,7 @@
     */
    @Override
    public List<String> dataVisitCount() {
        return aMapOfPipelineMapper.dataVisitCount();
        return oneMapMapper.dataVisitCount();
    }

    /**
@@ -159,7 +160,7 @@
     */
    @Override
    public List<String> countDownloads() {
        return aMapOfPipelineMapper.countDownloads();
        return oneMapMapper.countDownloads();
    }

    /**
@@ -169,7 +170,7 @@
     */
    @Override
    public List<String> countProjectDisplay() {
        return aMapOfPipelineMapper.countProjectDisplay();
        return oneMapMapper.countProjectDisplay();
    }

    /**
@@ -179,7 +180,7 @@
     */
    @Override
    public List<String> countProjectTour(MpipelineEntity mpipelineEntity) {
        return aMapOfPipelineMapper.countProjectTour(mpipelineEntity);
        return oneMapMapper.countProjectTour(mpipelineEntity);
    }

    /**
@@ -189,7 +190,7 @@
     */
    @Override
    public List<String> selectProjectTour() {
        return aMapOfPipelineMapper.selectProjectTour();
        return oneMapMapper.selectProjectTour();
    }


@@ -201,7 +202,7 @@
    @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())) {
                resList.addAll(queryDirectory(oneMapEntity));
@@ -239,7 +240,7 @@
            endSql = " where dircode like " + one.substring(0, one.toString().length() - 15);
            System.out.println("endSql = " + endSql);
        }
        return aMapOfPipelineMapper.selectProjectTypeOne(endSql);
        return oneMapMapper.selectProjectTypeOne(endSql);
    }

    /**
@@ -261,7 +262,7 @@
     */
    @Override
    public List<String> queryTableInfo(String tableName) {
        return aMapOfPipelineMapper.queryTableInfo(tableName);
        return oneMapMapper.queryTableInfo(tableName);
    }

    /**
@@ -271,7 +272,7 @@
     */
    @Override
    public List<String> countGlobalPipeMap() {
        return aMapOfPipelineMapper.countGlobalPipeMap();
        return oneMapMapper.countGlobalPipeMap();
    }

    /**
@@ -281,7 +282,7 @@
     */
    @Override
    public List<String> countNationalPipeMap() {
        return aMapOfPipelineMapper.countNationalPipeMap();
        return oneMapMapper.countNationalPipeMap();
    }

    /**
@@ -291,7 +292,7 @@
     */
    @Override
    public List<String> countZhPipeMapLenByMed() {
        return aMapOfPipelineMapper.countZhPipeMapLenByMed();
        return oneMapMapper.countZhPipeMapLenByMed();
    }

    /**
@@ -301,7 +302,7 @@
     */
    @Override
    public List<String> countZhPipeStations() {
        return aMapOfPipelineMapper.countZhPipeStations();
        return oneMapMapper.countZhPipeStations();
    }

    /**
@@ -311,19 +312,19 @@
     */
    @Override
    public List<String> countStorageByProject() {
        return aMapOfPipelineMapper.countStorageByProject();
        return oneMapMapper.countStorageByProject();
    }

    /**
     * 选择项目信息
     * 查询项目信息
     *
     * @param projectName 项目名称
     * @param projectCode 项目名称
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> selectProjectInfo(String projectCode) {
        return aMapOfPipelineMapper.selectProjectInfo(projectCode);
        return oneMapMapper.selectProjectInfo(projectCode);
    }

    /**
@@ -333,7 +334,7 @@
     */
    @Override
    public List<String> selectProjectFileList() {
        return aMapOfPipelineMapper.selectProjectFileList();
        return oneMapMapper.selectProjectFileList();
    }

    /**
@@ -344,7 +345,7 @@
     */
    @Override
    public List<String> countProjectStorage(String projectCode) {
        return aMapOfPipelineMapper.countProjectStorage(projectCode);
        return oneMapMapper.countProjectStorage(projectCode);
    }

    /**
@@ -355,7 +356,7 @@
     */
    @Override
    public List<String> countProjectType(String projectCode) {
        return aMapOfPipelineMapper.countProjectType(projectCode);
        return oneMapMapper.countProjectType(projectCode);
    }

    /**
@@ -366,7 +367,11 @@
     */
    @Override
    public List<String> countProjectDown(String projectCode) {
        return aMapOfPipelineMapper.countProjectDown(projectCode);
        return oneMapMapper.countProjectDown(projectCode);
    }

    @Override
    public List<CountEntity> countByMajor() {
        return oneMapMapper.countByMajor();
    }
}

 src/main/java/com/lf/server/service/sys/DepService.java

@@ -2,7 +2,6 @@

import com.lf.server.entity.all.RedisCacheKey;
import com.lf.server.entity.ctrl.IdNameEntity;
import com.lf.server.entity.data.LayerEntity;
import com.lf.server.entity.sys.DepEntity;
import com.lf.server.mapper.sys.DepMapper;
import com.lf.server.service.all.RedisService;

 src/main/resources/mapper/show/OneMapMapper.xml

@@ -1,20 +1,15 @@
<?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">
<!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">

    <resultMap type="com.lf.server.entity.show.OneMapEntity" id="OneMapResult">
        <result property="value"       column="value"    />
        <result property="key"     column="key"     />
        <result property="value" column="value" />
        <result property="key" column="key" />
    </resultMap>


    <!--  项目类别 select * from bs.bs_project;  -->
    <select id="projectCategoryCount" 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="projectLocationCount" resultType="java.util.Map">
@@ -67,23 +62,22 @@
        ORDER BY  name;
    </select>


    <!--  统计数据服务类型  -->
    <select id="statisticalDataServiceType" resultType="java.util.Map">
        SELECT COUNT(*),TYPE FROM lf.sys_serve_log GROUP BY TYPE;
    </select>

    <!--  登录次数统计  -->
    <!-- 登录次数统计 -->
    <select id="loginNumberStatistics" resultType="java.util.Map">
        select b.uname, count(*) from lf.sys_login a inner join lf.sys_user b on a.userid = b.id group by uname;
    </select>

    <!--  数据统计 文件格式维度-文件个数 select type,count(*),count(sizes) from lf.sys_meta group by type;  -->
    <!-- 数据统计 文件格式维度-文件个数 select type,count(*),count(sizes) from lf.sys_meta group by type; -->
    <select id="fileFormatCount" resultType="java.util.Map">
        select type,count(type) AS number,sum(sizes) AS capacity from lf.sys_meta group by type;
    </select>

    <!--  数据统计 数据申请 select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id;  -->
    <!-- 数据统计 数据申请 select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id; -->
    <select id="dataApplyCount" resultType="java.util.Map">
        SELECT
            count(c.name) AS number,
@@ -139,7 +133,6 @@
        SELECT DISTINCT pipename  FROM bs.m_pipeline;
    </select>


    <!--  统计项目类型 1  -->
    <!-- select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
    where name in ('测绘（ESV）', '勘察（EGE）', '地灾（EGD）', '洞库（EGD）') group by name order by name;-->
@@ -165,7 +158,6 @@
        select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
    </select>


    <!--  查询表信息  -->
    <select id="queryTableInfo" resultType="java.util.Map">
        SELECT a.attnum,
@@ -180,7 +172,6 @@
          AND d.objoid=a.attrelid
          AND d.objsubid=a.attnum;
    </select>


    <!--  统计计算全球管道图  -->
    <select id="countGlobalPipeMap" resultType="java.util.Map">
@@ -274,7 +265,7 @@
    </select>

    <!--  单个项目的下载个数、下载次数和数据量-->
    <!--    select count(*) "number", sum(c.dcount) "count", sum(c.sizes) "size"
    <!--  select count(*) "number", sum(c.dcount) "count", sum(c.sizes) "size"
            from lf.sys_meta a inner join lf.sys_meta_down b on a.id = b.metaid
                               inner join lf.sys_download c on b.downid = c.id
            where dircode like '${projectCode}%';  -->
@@ -297,7 +288,18 @@
        where pid = 0 AND d.code like '${projectCode}%'
    </select>




    <!-- 按大类统计 -->
    <select id="countByMajor" resultType="com.lf.server.entity.ctrl.CountEntity">
        select '测绘（ESV）' "m1", '数字线划图' "m2", '平方千米' "m3", 0.0 "sizes"
        union all
        select '测绘（ESV）' "m1", '数字正射影像图' "m2", '平方千米' "m3", 0.0 "sizes"
        union all
        select '测绘（ESV）' "m1", '管线数据' "m2", '千米' "m3", cast( sum( st_length( st_geographyfromtext( st_astext(geom) ) ) ) / 1000 as decimal(12, 2) ) "sizes" from bs.m_pipeline
        union all
        select '勘察（EGE）' "m1", '勘探点' "m2", '个' "m3", count(*) "sizes" from bs.s_explorationpoint
        union all
        select '勘察（EGE）' "m1", '三维地质模型' "m2", '平方米' "m3", 0.0 "sizes"
        union all
        select '地灾（EGD）' "m1", '地灾点' "m2", '个' "m3", count(*) "sizes" from bd.b_geologic_hazard;
    </select>
</mapper>