修改数据统计的查询条件

13693261870

2024-03-25 b6b0cb226fcf184525ee7b36af3a09471e9c0057

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

@@ -1,10 +1,10 @@
package com.lf.server.controller.show;


import com.lf.server.annotation.SysLog;
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;
@@ -16,6 +16,7 @@
import org.springframework.web.bind.annotation.RestController;

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

/**
 * 管网一张图
@@ -24,15 +25,12 @@
 * @author xing
 * @date 2023/02/13
 */

@Api(tags = "综合展示\\管网一张图")
@RestController
@RequestMapping("/oneMap")
public class OneMapController extends BaseController {

    @Autowired
    OneMapService aMapOfPipelineService;

    OneMapService oneMapService;

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

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

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


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

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

    /**
     * 全国维度-按照项自类型统计不同项目个数
     * Count the number of different items according to their type
     */
    @SysLog()
    @ApiOperation(value = "全国维度-按照项自类型统计不同项目个数")
    @GetMapping("/countProjectTypeNumber")
    public ResponseMsg<Object> countProjectTypeNumber() {
        List<String> resList = oneMapService.countProjectTypeNumber();
        return success(resList);
    }

    //============[数据统计 data Statistics]==================

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

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

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

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


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

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

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

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


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

@@ -211,7 +217,8 @@
    @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);
    }

@@ -223,10 +230,9 @@
    @ApiOperation(value = "项目工程巡视列表")
    @GetMapping("/selectProjectTour")
    public ResponseMsg<Object> selectProjectTour() {
        List<String> resList = aMapOfPipelineService.selectProjectTour();
        List<String> resList = oneMapService.selectProjectTour();
        return success(resList);
    }


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

@@ -247,10 +253,9 @@
    @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);
    }


    //============[专题展示 Thematic presentations]==================

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

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

    /**
     * 全国管网图输送介质长度
     * National pipe network diagram conveying medium length
     */
    @SysLog()
    @ApiOperation(value = "全国管网图输送介质长度")
    @GetMapping("/countZhPipeMapLength")
    public ResponseMsg<Object> countZhPipeMapLenByMed() {
        List<String> resList = oneMapService.countZhPipeMapLenByMed();
        return success(resList);
    }

    /**
     * 统计全国站场座数
     * Number of station seats nationwide
     */
    @SysLog()
    @ApiOperation(value = "全国站场座数、阀室、管道数等")
    @GetMapping("/countZhPipeStations")
    public ResponseMsg<Object> countZhPipeStations() {
        List<String> resList = oneMapService.countZhPipeStations();
        return success(resList);
    }

    /**
     * 按项目统计项目存储量
     * Count the amount of project storage by project
     */
    @SysLog()
    @ApiOperation(value = "按项目统计项目存储量")
    @GetMapping("/countStorageByProject")
    public ResponseMsg<Object> countStorageByProject() {
        List<String> resList = oneMapService.countStorageByProject();
        return success(resList);
    }

    //============[工程展示 Engineering Showcase]==================

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

@@ -314,11 +354,68 @@
    @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);
    }

    /**
     * 单个项目文件数量
     * The number of individual project files
     *
     * @param projectCode 项目代码
     * @return {@link ResponseMsg}<{@link Object}>
     */
    @SysLog()
    @ApiOperation(value = "单个项目文件类型数量")
    @GetMapping("/countProjectType")
    public ResponseMsg<Object> countProjectType(@RequestParam("projectCode") String projectCode) {
        List<Map<String, Object>> resList = oneMapService.countProjectType(projectCode);

        return success(resList);
    }

    /**
     * 统计项目下
     * 单个项目下载量
     *
     * @param projectCode 项目代码
     * @return {@link ResponseMsg}<{@link Object}>
     */
    @SysLog()
    @ApiOperation(value = "单个项目下载量")
    @GetMapping("/countProjectDown")
    public ResponseMsg<Object> countProjectDown(@RequestParam("projectCode") String 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());
        }
    }

    @SysLog()
    @ApiOperation(value = "查询计算数据")
    @GetMapping("/selectCalcData")
    public ResponseMsg<Object> selectCalcData(){
        try {
            String rs = oneMapService.calcData();

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