流程卡进度修改

chenlu

2025-08-12 b579ef3f2ddb93a035cbefb813864ebd00b1ed5d

流程卡进度修改

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

@@ -164,7 +164,7 @@
            //判断中空和中空后工序
            //Objects.equals(basicData.getNickname(), "stepB") || Objects.equals(basicData.getNickname(), "stepD")
            if(Objects.equals(basicData.getNickname(), "stepB") || Objects.equals(basicData.getNickname(), "stepD")){
                columns.add(15+i);
                columns.add(16+i);
            }
        }


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

@@ -14,7 +14,15 @@
    and a.breakage_quantity>0
    and a.patch_status=0
    and b.reviewed_state>=0
    and b.this_process in (SUBSTRING_INDEX(#{behindProcess},',',1))
    and b.this_process in (WITH RECURSIVE cte AS (
                            SELECT 1 AS n
                            UNION ALL
                            SELECT n + 1 FROM cte WHERE n < 20 -- 这里的 20 是最大拆分个数
                        )
                           SELECT REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) AS process
                           FROM cte
                           WHERE REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) IS NOT NULL)

</select>

</mapper>