根据类型查询元数据（用于计算面积）

13693261870

2024-03-12 c0ffe9147554b1e3e4d5459b1cc530d09b55b165

 src/main/java/com/lf/server/service/show/OneMapService.java

@@ -1,6 +1,8 @@
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.ctrl.IdNameEntity;
import com.lf.server.entity.show.OneMapEntity;
import com.lf.server.mapper.show.OneMapMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -8,6 +10,7 @@

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * 管网一张图Service
@@ -17,12 +20,12 @@
@Service
public class OneMapService implements OneMapMapper {
    @Autowired
    OneMapMapper aMapOfPipelineMapper;
    OneMapMapper oneMapMapper;

    /**
     * 测量
     * 测绘
     */
    private static final String MEASUREMENT = "测量（ESV）";
    private static final String MEASUREMENT = "测绘（ESV）";
    /**
     * 调查
     */
@@ -41,7 +44,7 @@
     */
    @Override
    public List<String> projectCategoryCount() {
        return aMapOfPipelineMapper.projectCategoryCount();
        return oneMapMapper.projectCategoryCount();
    }

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

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

    /**
@@ -69,7 +72,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 +92,7 @@
     */
    @Override
    public List<String> dataStorageCount() {
        return aMapOfPipelineMapper.dataStorageCount();
        return oneMapMapper.dataStorageCount();
    }

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

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

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

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

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

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

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

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

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

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


@@ -191,7 +204,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));
@@ -229,7 +242,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);
    }

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

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

    /**
@@ -271,19 +284,49 @@
     */
    @Override
    public List<String> countNationalPipeMap() {
        return aMapOfPipelineMapper.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 projectName 项目名称
     * @param projectCode 项目名称
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> selectProjectInfo(String projectName) {
        return aMapOfPipelineMapper.selectProjectInfo(projectName);
    public List<String> selectProjectInfo(String projectCode) {
        return oneMapMapper.selectProjectInfo(projectCode);
    }

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

    /**
@@ -304,7 +347,43 @@
     */
    @Override
    public List<String> countProjectStorage(String projectCode) {
        return aMapOfPipelineMapper.countProjectStorage(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();
    }

    @Override
    public Integer selectLineBuffer() {
        return oneMapMapper.selectLineBuffer();
    }

    @Override
    public List<IdNameEntity> selectMetaByType() {
        return oneMapMapper.selectMetaByType();
    }
}