帷幄君成-富创-后端代码
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
zhanghl
2025-04-29 e1929dddde64e28f7078b403db9d37afa90ce9ce 
 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java


@@ -21,6 +21,7 @@


import org.apache.poi.xssf.streaming.SXSSFRow;


import org.apache.poi.xssf.streaming.SXSSFSheet;


import org.apache.poi.xssf.streaming.SXSSFWorkbook;


import org.springframework.beans.BeanUtils;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


@@ -28,12 +29,11 @@


import java.math.BigDecimal;


import java.math.RoundingMode;


import java.text.SimpleDateFormat;


import java.time.LocalDate;


import java.time.LocalDateTime;


import java.time.YearMonth;


import java.time.ZoneId;


import java.time.*;


import java.time.format.DateTimeFormatter;


import java.util.*;




import static java.util.stream.Collectors.groupingBy;




/**


 * 气体管路产能负载统计Service业务层处理


@@ -166,7 +166,7 @@


                    //工序名称


                    apsGasPipingRouteStat.setProcessName(apsProcessRoute.getProcessName());


                    //工序号


                    apsGasPipingRouteStat.setRoadProcessNumber(apsProcessRoute.getProcessNumber());


                    apsGasPipingRouteStat.setRoadProcessNumber( new BigDecimal(apsProcessRoute.getProcessNumber()) );


                    //标准工时


                    apsGasPipingRouteStat.setStandardTime(apsProcessRoute.getStandardTime());


                    //专业


@@ -303,7 +303,10 @@


                formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");


                simpleDateFormat = new SimpleDateFormat("yyyy-MM");


            }


            apsGasPipingRouteStats = apsGasPipingRouteStatMapper.selectApsGasPipingRouteStatList(apsGasPipingRouteStat);


            ApsGasPipingRouteStat queryStatParam = new ApsGasPipingRouteStat();


            BeanUtils.copyProperties(apsGasPipingRouteStat,queryStatParam);


            queryStatParam.setMajor("");


            apsGasPipingRouteStats = apsGasPipingRouteStatMapper.selectApsGasPipingRouteStatList(queryStatParam);


            //根据开工日进行升序排序


            apsGasPipingRouteStats.sort((a, b)->a.getProcessPlanStartDay().compareTo(b.getProcessPlanStartDay()));


            //工序开工日期


@@ -705,7 +708,7 @@


        }


        // 批量插入以提高性能


        if (!cptStateList.isEmpty()) {


            int batchSize = 500;


            int batchSize = 1000;


            int size = cptStateList.size();


            for (int i = 0; i < size; i += batchSize) {


                int end = Math.min(i + batchSize, size);