diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java index 0d199fc..8236dc7 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java @@ -12,7 +12,6 @@ import com.casic.missiles.model.response.ResponseData; import com.casic.missiles.modular.system.dto.AlarmDeptStaticsDto; import com.casic.missiles.modular.system.dto.ExcelModel.*; -import com.casic.missiles.modular.system.dto.statistic.DataH2s; import com.casic.missiles.modular.system.enums.DeviceExportEnum; import com.casic.missiles.modular.system.service.IDataAnalysisService; import lombok.extern.slf4j.Slf4j; @@ -83,6 +82,66 @@ } /** + * 井盖液位一体化列表 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/list-page") + @Permission + public Object wellliquiddataListPage(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + page.setRecords(deviceDataDtoList); + return ResponseData.success(super.packForBT(page)); + } + + /** + * 井盖液位一体化导出 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/export") + @Permission + public void wellliquiddataExport(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + super.exportExcel(DataWellLiquidDto.class, deviceDataDtoList, DeviceExportEnum.WELLLIQUIDDATA_EXPORT.getFileName()); + } + + + /** * @param keywords * @param deptid * @param beginTime diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java index 0d199fc..8236dc7 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java @@ -12,7 +12,6 @@ import com.casic.missiles.model.response.ResponseData; import com.casic.missiles.modular.system.dto.AlarmDeptStaticsDto; import com.casic.missiles.modular.system.dto.ExcelModel.*; -import com.casic.missiles.modular.system.dto.statistic.DataH2s; import com.casic.missiles.modular.system.enums.DeviceExportEnum; import com.casic.missiles.modular.system.service.IDataAnalysisService; import lombok.extern.slf4j.Slf4j; @@ -83,6 +82,66 @@ } /** + * 井盖液位一体化列表 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/list-page") + @Permission + public Object wellliquiddataListPage(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + page.setRecords(deviceDataDtoList); + return ResponseData.success(super.packForBT(page)); + } + + /** + * 井盖液位一体化导出 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/export") + @Permission + public void wellliquiddataExport(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + super.exportExcel(DataWellLiquidDto.class, deviceDataDtoList, DeviceExportEnum.WELLLIQUIDDATA_EXPORT.getFileName()); + } + + + /** * @param keywords * @param deptid * @param beginTime diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java index 0b99b60..cd21bad 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java @@ -1,5 +1,6 @@ package com.casic.missiles.modular.system.dao; +import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.datascope.DataScope; @@ -74,6 +75,8 @@ List selectLiquidDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); + List getWellliquiddataList(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); + List selectGasDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); List selectTubeDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java index 0d199fc..8236dc7 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/DeviceWellDataController.java @@ -12,7 +12,6 @@ import com.casic.missiles.model.response.ResponseData; import com.casic.missiles.modular.system.dto.AlarmDeptStaticsDto; import com.casic.missiles.modular.system.dto.ExcelModel.*; -import com.casic.missiles.modular.system.dto.statistic.DataH2s; import com.casic.missiles.modular.system.enums.DeviceExportEnum; import com.casic.missiles.modular.system.service.IDataAnalysisService; import lombok.extern.slf4j.Slf4j; @@ -83,6 +82,66 @@ } /** + * 井盖液位一体化列表 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/list-page") + @Permission + public Object wellliquiddataListPage(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + page.setRecords(deviceDataDtoList); + return ResponseData.success(super.packForBT(page)); + } + + /** + * 井盖液位一体化导出 + * + * @param response + * @param keywords + * @param deptid + * @param beginTime + * @param endTime + * @throws IOException + */ + @GetMapping(value = "/wellliquiddata/export") + @Permission + public void wellliquiddataExport(HttpServletResponse response, String keywords, String deptid, String beginTime, String endTime) throws IOException { + Page page = PageFactory.defaultPage(); + if (CollectionUtil.isEmpty(page.orders())) { + OrderItem orderItem = new OrderItem(); + orderItem.setColumn("UPTIME"); + orderItem.setAsc(false); + page.addOrder(orderItem); + } + //查询数据权限 使用默认DEPTID 字段 + DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); + List deviceDataDtoList = deviceService.getWellliquiddataList(dataScope, page, deptid, beginTime, endTime, keywords); + deviceDataDtoList.forEach(deviceDto -> { + deviceDto.setDeptName(permissionService.getDeptService().getDeptName(deviceDto.getDeptid())); + }); + super.exportExcel(DataWellLiquidDto.class, deviceDataDtoList, DeviceExportEnum.WELLLIQUIDDATA_EXPORT.getFileName()); + } + + + /** * @param keywords * @param deptid * @param beginTime diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java index 0b99b60..cd21bad 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/DataAnalysisMapper.java @@ -1,5 +1,6 @@ package com.casic.missiles.modular.system.dao; +import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.datascope.DataScope; @@ -74,6 +75,8 @@ List selectLiquidDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); + List getWellliquiddataList(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); + List selectGasDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); List selectTubeDataScopePage(@Param("dataScope") DataScope dataScope, @Param("page") Page page, @Param("deptid") Long deptid, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("keywords") String keywords); diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml index c586d01..63decc1 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml @@ -338,6 +338,57 @@ ORDER BY UPTIME DESC + + + + + + + + + + + + + + + + + +