| | |
| | | import com.aps.core.domain.ApsPartPlan; |
| | | import com.aps.core.domain.ApsResourceDateStat; |
| | | import com.aps.core.domain.ApsResourceGroup; |
| | | import com.aps.core.mapper.ApsAbnormalProcessAnalysisMapper; |
| | | import com.aps.core.mapper.ApsResourceGroupMapper; |
| | | import com.aps.core.service.IApsAbnormalProcessAnalysisService; |
| | | import jakarta.annotation.Resource; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.poi.ss.usermodel.*; |
| | | import org.apache.poi.ss.util.CellRangeAddress; |
| | | import org.apache.poi.util.IOUtils; |
| | | import org.apache.poi.util.Removal; |
| | | import org.apache.poi.xssf.streaming.SXSSFCell; |
| | | import org.apache.poi.xssf.streaming.SXSSFRow; |
| | | import org.apache.poi.xssf.streaming.SXSSFSheet; |
| | |
| | | private ApsResourceGroupMapper resourceGroupMapper; |
| | | @Autowired |
| | | private ApsResourceGroupMapper apsResourceGroupMapper; |
| | | |
| | | @Resource |
| | | private IApsAbnormalProcessAnalysisService analysisService; |
| | | |
| | | /** |
| | | * 查询零件统计表 |
| | |
| | | if (stat.getCurrentProcessNumber().compareTo(stat.getRoadProcessNumber()) < 0) { |
| | | if (last != null) { |
| | | LocalDateTime lastStartDate = LocalDateTime.ofInstant(last.getProcessPlanStartDay().toInstant(), ZoneId.systemDefault()); |
| | | lastStartDate.plusHours(last.getProcessTotalTime()); |
| | | lastStartDate.plusHours(last.getProcessTotalTime().longValue()); |
| | | stat.setProcessPlanStartDay(Date.from(lastStartDate.atZone(ZoneId.systemDefault()).toInstant())); |
| | | } |
| | | } |
| | |
| | | last = stat; |
| | | stat.setId(IdUtils.fastUUID().toString()); |
| | | stat.setBatchNumber(batchNum); |
| | | stat.setDelFlag("0"); |
| | | apsPartRouteStatMapper.insertApsPartRouteStat(stat); |
| | | } |
| | | } |
| | | apsPartRouteStatMapper.deleteLastBatch(batchNum); |
| | | /*计算并保存 工序异常信息*/ |
| | | analysisService.batchSaveAbnormalInfo(); |
| | | } |
| | | /** 查询资源日历表 |
| | | */ |