修改转工单出现的bug

chenlu

2025-08-01 7f2deaf115a651e16944b39d0e10f85c0a53e1d7

修改转工单出现的bug

 north-glass-erp/src/main/java/com/example/erp/mapper/pp/WorkOrderMapper.java

@@ -37,4 +37,6 @@
    Integer selectYesWorkCount(String orderId);

    Integer selectProcessCard(String orderId);

    Boolean updateWorkIdMp(String orderId, String userName);
}

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

@@ -90,6 +90,8 @@
            }
            //添加生产订单
            workOrderMapper.addOrderWorkMp(productIdVl, orderDetail.getOrderId(), orderDetail.getProductId(), orderDetail.getProductName(), userName,orderDetail.getOrderGlassDetail().getProcess());
            //避免同序号不同工艺修改
            workOrderMapper.updateWorkIdMp(orderDetail.getOrderId(),userName);
            Integer state = 2;
            Integer states = 1;
            //查询该订单未转生产订单的条数

 north-glass-erp/src/main/resources/mapper/pp/WordOrder.xml

@@ -222,4 +222,22 @@
    <select id="selectProcessCard">
        select processing_card from sd.`order` where order_id = #{orderId}
    </select>

    <update id="updateWorkIdMp">
        UPDATE sd.order_glass_detail AS ogd
            JOIN (
            SELECT order_id, order_number, MAX(production_id) AS production_id
            FROM sd.order_glass_detail
            WHERE production_id IS NOT NULL
            AND FIND_IN_SET(order_id, #{orderId})  
            GROUP BY order_id, order_number
            ) AS t
        ON ogd.order_id = t.order_id AND ogd.order_number = t.order_number
            SET ogd.production_id = t.production_id,
                ogd.production_time = NOW(),
                ogd.founder = #{userName}
        WHERE ogd.production_id IS NULL
          AND FIND_IN_SET(ogd.order_id, #{orderId})

    </update>
</mapper>