修改数据统计的查询条件

13693261870

2024-03-25 b6b0cb226fcf184525ee7b36af3a09471e9c0057

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

@@ -1,18 +1,22 @@
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;
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.RequestParam;
import org.springframework.web.bind.annotation.RestController;

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

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

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

    @Autowired
    OneMapService aMapOfPipelineService;


    OneMapService oneMapService;

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

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

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


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

@@ -78,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]==================

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

    /**
     * 数据大类统计
     * Statistics of large categories of data
     */
    @SysLog()
    @ApiOperation(value = "数据大类统计")
    @GetMapping("/countLargeCategories")
    public ResponseMsg<Object> statisticalDataCategories() {
        List<String> resList = oneMapService.statisticalDataCategories();
        return success(resList);
    }

    /**
     * 数据服务类型统计
     * Data service type statistics
     */
    @SysLog()
    @ApiOperation(value = "数据服务类型统计")
    @GetMapping("/countDataServiceType")
    public ResponseMsg<Object> statisticalDataServiceType() {
        List<String> resList = oneMapService.statisticalDataServiceType();
        return success(resList);
    }

    /**
     * 登录次数统计
     * Number of logins
     */
    @SysLog()
    @ApiOperation(value = "登录次数统计")
    @GetMapping("/countLoginNumber")
    public ResponseMsg<Object> loginNumberStatistics() {
        List<String> resList = oneMapService.loginNumberStatistics();
        return success(resList);
    }

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

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

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

    /**
     * 下载量统计
     * Download statistics
     * <p>type类型：1-Shp文件，2-专题图，3-元数据，4-业务数据，5-管道分析，6-统计报告<p/>
     */
    @SysLog()
    @ApiOperation(value = "下载量统计")
    @GetMapping("/countDownloads")
    public ResponseMsg<Object> countDownloads() {
        List<String> resList = oneMapService.countDownloads();
        return success(resList);
    }

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

@@ -157,22 +216,206 @@
    @SysLog()
    @ApiOperation(value = "项目工程巡视")
    @GetMapping("/countProjectTour")
    public ResponseMsg<Object> countProjectTour() {
        return success("hello! 您已经成功访问-项目工程巡视");
    public ResponseMsg<Object> countProjectTour(MpipelineEntity mpipelineEntity) {
        List<String> resList = oneMapService.countProjectTour(mpipelineEntity);

        return success("hello! 您已经成功访问-项目工程巡视", resList);
    }

    /**
     * 项目工程巡视列表
     * Project inspection tour
     */
    @SysLog()
    @ApiOperation(value = "项目工程巡视列表")
    @GetMapping("/selectProjectTour")
    public ResponseMsg<Object> selectProjectTour() {
        List<String> resList = oneMapService.selectProjectTour();
        return success(resList);
    }

    /**
     * 项目工程类型
     * Project type
     * 工程项目目录
     * Project Catalog
     */
    /*@SysLog()
    @ApiOperation(value = "项目工程类型")
    @GetMapping("/countProjectType")
    public ResponseMsg<Object> countProjectType() {
        List<String> resList = aMapOfPipelineService.countProjectType1();
    @SysLog()
    @ApiOperation(value = "工程项目目录")
    @GetMapping("/selectProjectType")
    public ResponseMsg<Object> selectProjectType() {
        List<OneMapEntity> resList = oneMapService.selectProjectType1();
        return success(resList);
    }*/
    }

    /**
     * 根据表名查询表字段信息
     * Query table field information according to table name
     */
    @ApiOperation(value = "根据表名查询表字段信息")
    @GetMapping("/selectTableInfo")
    public ResponseMsg<Object> selectTableInfo(@RequestParam("tableName") String tableName) {
        List<String> resList = oneMapService.queryTableInfo(tableName);
        return success(resList);
    }

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

    /**
     * 全球管网图
     * Global pipe network map
     */
    @SysLog()
    @ApiOperation(value = "全球管网图")
    @GetMapping("/countGlobalPipeMap")
    public ResponseMsg<Object> countGlobalPipeMap() {
        List<String> resList = oneMapService.countGlobalPipeMap();
        return success(resList);
    }

    /**
     * 全国管网图
     * National pipe network map
     */
    @SysLog()
    @ApiOperation(value = "全国管网图")
    @GetMapping("/countNationalPipeMap")
    public ResponseMsg<Object> 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]==================

    /**
     * 项目信息查询
     * Project information query
     */
    @SysLog()
    @ApiOperation(value = "项目信息查询")
    @GetMapping("/selectProjectInfo")
    public ResponseMsg<Object> selectProjectInfo(@RequestParam("projectCode") String projectCode) {
        List<String> resList = oneMapService.selectProjectInfo(projectCode);
        return success(resList);
    }
    /**
     * 项目文件列表查询
     * Project file list query
     */
    @SysLog()
    @ApiOperation(value = "项目文件列表查询")
    @GetMapping("/selectProjectFileList")
    public ResponseMsg<Object> selectProjectFileList() {
        List<String> resList = oneMapService.selectProjectFileList();
        return success(resList);
    }

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