修改数据统计控制器

13693261870

2024-03-06 f849c87a07300020dbef300c79d1eacfc1439f84

 src/main/java/com/lf/server/controller/data/DataCountController.java

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

import com.lf.server.annotation.SysLog;
import com.lf.server.controller.all.BaseController;
import com.lf.server.controller.all.BaseQueryController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.ctrl.CountEntity;
import com.lf.server.entity.sys.ReportEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.StringHelper;
@@ -15,10 +17,10 @@
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * 数据统计
@@ -27,7 +29,7 @@
@Api(tags = "数据管理\\数据统计")
@RestController
@RequestMapping("/dataCount")
public class DataCountController extends BaseQueryController {
public class DataCountController extends BaseController {
    @Autowired
    ReportService reportService;

@@ -37,32 +39,116 @@
    @Autowired
    UploadAttachService uploadAttachService;

    private final static String TAB_NAME = "lf.sys_report";

    @SysLog()
    @ApiOperation(value = "上传文件")
    @ResponseBody
    @PostMapping(value = "/upload")
    public ResponseMsg<String> upload(@RequestParam("file") MultipartFile file, HttpServletRequest req) {
        UserEntity ue = tokenService.getCurrentUser(req);
    @ApiOperation(value = "分页查询并返回记录数")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = ""),
            @ApiImplicitParam(name = "code", value = "编码", dataType = "String", paramType = "query", example = "countOperates"),
            @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"),
            @ApiImplicitParam(name = "pageIndex", value = "分页数（从1开始）", dataType = "Integer", paramType = "query", example = "1")
    })
    @GetMapping(value = "/selectByPageAndCount")
    public ResponseMsg<List<ReportEntity>> selectByPageAndCount(String name, String code, Integer pageSize, Integer pageIndex) {
        try {
            if (pageSize < 1 || pageIndex < 1) {
                return fail("每页页数或分页数小于1", null);
            }

        return uploadAttachService.upload(ue, TAB_NAME, file, this);
            int count = reportService.selectCount(name, code);
            if (count == 0) {
                return success(0, null);
            }

            List<ReportEntity> rs = reportService.selectByPage(name, code, pageSize, pageSize * (pageIndex - 1));

            return success(count, rs);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "下载文件")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "guid", value = "附件Guid", dataType = "String", paramType = "body")
    })
    @GetMapping(value = "/download")
    public void download(String guid, HttpServletResponse res) {
        uploadAttachService.download(guid, res);
    @ApiOperation(value = "查询数据量统计")
    @GetMapping(value = "/selectCountSizes")
    public ResponseMsg<Object> selectCountSizes() {
        try {
            List<CountEntity> list = reportService.countSizes();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按文件类型统计")
    @GetMapping(value = "/countSizesByType")
    public ResponseMsg<Object> countSizesByType() {
        try {
            List<CountEntity> list = reportService.countSizesByType();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "查询服务调用量统计")
    @GetMapping(value = "/selectCountServices")
    public ResponseMsg<Object> selectCountServices() {
        try {
            List<CountEntity> list = reportService.countServices();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "查询用户流量统计")
    @GetMapping(value = "/selectCountOperates")
    public ResponseMsg<Object> selectCountOperates() {
        try {
            List<CountEntity> list = reportService.countOperates();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计数据")
    @GetMapping(value = "/countSizesByPrj")
    public ResponseMsg<Object> countSizesByPrj() {
        try {
            List<CountEntity> list = reportService.countSizesByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计钻孔数据")
    @GetMapping(value = "/countExplorationPoints")
    public ResponseMsg<Object> countExplorationPoints() {
        try {
            List<CountEntity> list = reportService.countExplorationPoints();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "下载报告")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "id", value = "报告ID", dataType = "Integer", paramType = "7")
            @ApiImplicitParam(name = "id", value = "报告ID", dataType = "Integer", paramType = "query", example = "18")
    })
    @GetMapping(value = "/downloadReport")
    public void downloadReport(Integer id, HttpServletRequest req, HttpServletResponse res) {
@@ -83,4 +169,173 @@
            log.error(ex.getMessage(), ex);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计数字高程模型面积")
    @GetMapping(value = "/countDemAreaByPrj")
    public ResponseMsg<Object> countDemAreaByPrj() {
        try {
            List<CountEntity> list = reportService.countDemAreaByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计三维地形模型面积")
    @GetMapping(value = "/countMptAreaByPrj")
    public ResponseMsg<Object> countMptAreaByPrj() {
        try {
            List<CountEntity> list = reportService.countMptAreaByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计倾斜摄影模型面积")
    @GetMapping(value = "/countOsgbAreaByPrj")
    public ResponseMsg<Object> countOsgbAreaByPrj() {
        try {
            List<CountEntity> list = reportService.countOsgbAreaByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计激光点云模型面积")
    @GetMapping(value = "/countLasAreaByPrj")
    public ResponseMsg<Object> countLasAreaByPrj() {
        try {
            List<CountEntity> list = reportService.countLasAreaByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计勘察工点个数")
    @GetMapping(value = "/countSurveyWorksiteByPrj")
    public ResponseMsg<Object> countSurveyWorksiteByPrj() {
        try {
            List<CountEntity> list = reportService.countSurveyWorksiteByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计勘察报告个数")
    @GetMapping(value = "/countExplorationReportByPrj")
    public ResponseMsg<Object> countExplorationReportByPrj() {
        try {
            List<CountEntity> list = reportService.countExplorationReportByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计崩塌个数")
    @GetMapping(value = "/countCollapseByPrj")
    public ResponseMsg<Object> countCollapseByPrj() {
        try {
            List<CountEntity> list = reportService.countCollapseByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计泥石流个数")
    @GetMapping(value = "/countDebrisFlowByPrj")
    public ResponseMsg<Object> countDebrisFlowByPrj() {
        try {
            List<CountEntity> list = reportService.countDebrisFlowByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计地面塌陷个数")
    @GetMapping(value = "/countGroundCollapseByPrj")
    public ResponseMsg<Object> countGroundCollapseByPrj() {
        try {
            List<CountEntity> list = reportService.countGroundCollapseByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计高陡边坡个数")
    @GetMapping(value = "/countHighSteepSlopeByPrj")
    public ResponseMsg<Object> countHighSteepSlopeByPrj() {
        try {
            List<CountEntity> list = reportService.countHighSteepSlopeByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计滑坡个数")
    @GetMapping(value = "/countLandSlideByPrj")
    public ResponseMsg<Object> countLandSlideByPrj() {
        try {
            List<CountEntity> list = reportService.countLandSlideByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计不稳定斜坡个数")
    @GetMapping(value = "/countUnstableSlopeByPrj")
    public ResponseMsg<Object> countUnstableSlopeByPrj() {
        try {
            List<CountEntity> list = reportService.countUnstableSlopeByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }

    @SysLog()
    @ApiOperation(value = "按项目统计水毁个数")
    @GetMapping(value = "/countWaterDamageByPrj")
    public ResponseMsg<Object> countWaterDamageByPrj() {
        try {
            List<CountEntity> list = reportService.countWaterDamageByPrj();

            return success(list);
        } catch (Exception ex) {
            return fail(ex, null);
        }
    }
}