| | |
| | | import org.jeecg.modules.mdc.entity.Equipment; |
| | | import org.jeecg.modules.mdc.mapper.EquipmentMapper; |
| | | import org.jeecg.modules.mdc.service.IEquipmentService; |
| | | import org.jeecg.modules.mdc.vo.WsEquipmentStatus; |
| | | import org.jeecg.modules.mdc.vo.WsEquipmentUtilizationRate; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.time.LocalDate; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @Description: 采集设备表 |
| | |
| | | public void insertNoTableData(String backupTableName, String tableName, String day) { |
| | | this.baseMapper.insertNoTableData(backupTableName, tableName, day); |
| | | } |
| | | |
| | | @Override |
| | | public List<WsEquipmentStatus> selectEquipmentStatus() { |
| | | return this.baseMapper.selectEquipmentStatus(); |
| | | } |
| | | |
| | | @Override |
| | | public List<WsEquipmentUtilizationRate> selectEquipmentRate() { |
| | | String date = LocalDate.now().plusDays(-1).toString(); |
| | | List<WsEquipmentUtilizationRate> list = this.baseMapper.selectEquipmentRate(date.replaceAll("-", "")); |
| | | if (list != null && !list.isEmpty()) { |
| | | for (WsEquipmentUtilizationRate wsEquipmentUtilizationRate : list) { |
| | | String equipmentRunTime = wsEquipmentUtilizationRate.getEquipmentRunTime(); |
| | | wsEquipmentUtilizationRate.setStatisType("D"); |
| | | wsEquipmentUtilizationRate.setEquipmentRunTime(new BigDecimal(equipmentRunTime).divide(new BigDecimal("60"), 0, RoundingMode.HALF_UP).toString()); |
| | | wsEquipmentUtilizationRate.setEquipmentRate(new BigDecimal(equipmentRunTime).divide(new BigDecimal("86400"), 2, RoundingMode.HALF_UP).toString()); |
| | | wsEquipmentUtilizationRate.setEquipmentCalendar(date); |
| | | String oee = this.baseMapper.selectOee(wsEquipmentUtilizationRate.getEquipmentCode(), date); |
| | | wsEquipmentUtilizationRate.setEquipmentOee(oee == null ? "0" : oee); |
| | | } |
| | | } |
| | | return list; |
| | | } |
| | | } |