修改数据统计的查询条件

13693261870

2024-03-25 b6b0cb226fcf184525ee7b36af3a09471e9c0057

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

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

/**
 * 管网一张图
@@ -27,9 +29,8 @@
@RestController
@RequestMapping("/oneMap")
public class OneMapController extends BaseController {

    @Autowired
    OneMapService aMapOfPipelineService;
    OneMapService oneMapService;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@@ -216,7 +217,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 +230,7 @@
    @ApiOperation(value = "项目工程巡视列表")
    @GetMapping("/selectProjectTour")
    public ResponseMsg<Object> selectProjectTour() {
        List<String> resList = aMapOfPipelineService.selectProjectTour();
        List<String> resList = oneMapService.selectProjectTour();
        return success(resList);
    }

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

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

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

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

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

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

@@ -328,7 +329,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 +340,7 @@
    @ApiOperation(value = "项目文件列表查询")
    @GetMapping("/selectProjectFileList")
    public ResponseMsg<Object> selectProjectFileList() {
        List<String> resList = aMapOfPipelineService.selectProjectFileList();
        List<String> resList = oneMapService.selectProjectFileList();
        return success(resList);
    }

@@ -353,7 +354,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 +369,8 @@
    @ApiOperation(value = "单个项目文件类型数量")
    @GetMapping("/countProjectType")
    public ResponseMsg<Object> countProjectType(@RequestParam("projectCode") String projectCode) {
        List<String> resList = aMapOfPipelineService.countProjectType(projectCode);
        List<Map<String, Object>> resList = oneMapService.countProjectType(projectCode);

        return success(resList);
    }

@@ -383,7 +385,37 @@
    @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());
        }
    }

    @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());
        }
    }
}