报工修改可报数量>=下工序完工+次破

guoyuji

2024-07-18 faefd4652a9d7180713877b6e594a7c6978dcd1c

报工修改可报数量>=下工序完工+次破

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

@@ -469,7 +469,7 @@
            and f.order_number = a.order_number
            and f.technology_number = a.technology_number
        <if test="nextProcess != null and nextProcess != ''">
            left join (select ifnull(sum(completed_quantity),0) as completed_quantity ,
            left join (select sum(ifnull(completed_quantity,0)+ifnull(breakage_quantity,0)) as completed_quantity ,
                            rw.process_id,
                            rwd.order_number,
                            rwd.technology_number,