设置报工下工序从后台中获取

guoyuji

2024-09-13 92a898d580a07e0977d7f3e2942d49712cd156ae

设置报工下工序从后台中获取

 north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderProcessDetailMapper.java

@@ -29,4 +29,6 @@
    List<Map<String,String>> filterOrderProcessCollect(Date selectTime1, Date selectTime2);

    List<Map<String, Integer>> getGlassLRowCollect(Date selectTime1, Date selectTime2);

    String selectNextProcess(String processId, String technologyNumber, String thisProcess);
}

 north-glass-erp/src/main/java/com/example/erp/service/pp/ReportingWorkService.java

@@ -199,7 +199,8 @@
        String formattedDate = dateFormat.format(currentDate);
        String reportingWorkId = "BG" + formattedDate + formattedNumber;
        reportingWork.setReportingWorkId(reportingWorkId);
        reportingWork.setProcessId(reportingWork.getProcessId().substring(0, 14));
        String[] processIdStr = reportingWork.getProcessId().split("/");
        reportingWork.setProcessId(processIdStr[0]);

        int reviewState = (int) reportingWorkJson.get("type");
        if (reviewState == 1) {
@@ -208,6 +209,8 @@
        } else {
            reportingWork.setReviewedState(0);
        }

        reportingWork.setNextProcess(orderProcessDetailMapper.selectNextProcess(processIdStr[0],processIdStr[1],reportingWork.getThisProcess()));
        //主表插入
        reportingWorkMapper.insert(reportingWork);
        //副表循环插入，并且插入次破信息表。再根据次破信息修改订单玻璃流程表的完工数量与刺破数量

 north-glass-erp/src/main/resources/mapper/sd/OrderProcessDetailMapper.xml

@@ -151,4 +151,17 @@
        where o.create_time BETWEEN #{selectTime1} and #{selectTime2}
        group by a.order_number
    </select>
    
    <select id="selectNextProcess">
        select a.process from sd.order_process_detail as a,
                              (select id,process from sd.order_process_detail
                                  where process_id=#{processId}
                                    and technology_number=#{technologyNumber}
                                    and process=#{thisProcess}
                                group by process) as b
        where a.id = b.id + 1
        and a.process_id=#{processId}
        and a.technology_number=#{technologyNumber}

    </select>
</mapper>