From d0b97b5655a6cac1efbda08dad1d3019ed973923 Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期三, 21 五月 2025 12:04:16 +0800 Subject: [PATCH] 设备日志批量导出 --- lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcEquipmentStatisticalInfoServiceImpl.java | 46 +++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 45 insertions(+), 1 deletions(-) diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcEquipmentStatisticalInfoServiceImpl.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcEquipmentStatisticalInfoServiceImpl.java index 2a09c05..ba6f2bf 100644 --- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcEquipmentStatisticalInfoServiceImpl.java +++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcEquipmentStatisticalInfoServiceImpl.java @@ -2,7 +2,6 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import io.swagger.models.auth.In; import org.apache.commons.lang.StringUtils; import org.jeecg.common.system.vo.DictModel; import org.jeecg.modules.mdc.entity.*; @@ -94,6 +93,51 @@ } } + @Override + public MdcEquipmentStatisticalInfo findMdcEquipmentStatisticalInfo(String equipmentId, String date) { + return this.baseMapper.findMdcEquipmentStatisticalInfo(equipmentId, date.replaceAll("-", "")); + } + + @Override + public BigDecimal computeUtilizationMonth(String productionId, String startDate, String endDate) { + BigDecimal processLong = this.baseMapper.computeUtilizationMonth(productionId, startDate, endDate); + if (processLong != null && processLong.compareTo(BigDecimal.ZERO) > 0) { + return processLong.divide(new BigDecimal("864"), 2, RoundingMode.HALF_UP); + } else { + return BigDecimal.ZERO; + } + } + + @Override + public BigDecimal computeUtilizationMonthTotal(String productionId, String startDate, String endDate) { + BigDecimal processLong = this.baseMapper.computeUtilizationMonthTotal(productionId, startDate, endDate); + if (processLong != null && processLong.compareTo(BigDecimal.ZERO) > 0) { + return processLong.divide(new BigDecimal("864"), 2, RoundingMode.HALF_UP); + } else { + return BigDecimal.ZERO; + } + } + + @Override + public BigDecimal computeUtilizationWeek(String productionId, String date) { + BigDecimal processLong = this.baseMapper.computeUtilizationWeek(productionId, date); + if (processLong != null && processLong.compareTo(BigDecimal.ZERO) > 0) { + return processLong.divide(new BigDecimal("864"), 2, RoundingMode.HALF_UP); + } else { + return BigDecimal.ZERO; + } + } + + @Override + public BigDecimal computeUtilizationWeekTotal(String productionId, String date) { + BigDecimal processLong = this.baseMapper.computeUtilizationWeekTotal(productionId, date); + if (processLong != null && processLong.compareTo(BigDecimal.ZERO) > 0) { + return processLong.divide(new BigDecimal("864"), 2, RoundingMode.HALF_UP); + } else { + return BigDecimal.ZERO; + } + } + private List<EquipmentStatisticalInfo> dataHandle(List<MdcEquipmentStatisticalInfo> list) { List<EquipmentStatisticalInfo> result = new ArrayList<>(); list.forEach(item -> { -- Gitblit v1.9.3