零件统计问题修复

zhanghl

2025-04-27 d77e9d8f3ca222fd6b9de32751edcfc2b0c79418

零件统计问题修复

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml

@@ -123,7 +123,7 @@
        from aps_part_plan  as pl
            left join aps_process_route as rt on pl.document_number=rt.work_order_no
            left join aps_resource_group as rs on rs.resource_group_name=rt.process_name
        where pl.document_number is not null
        where pl.document_number is not null and rt.work_order_no is not null
             and  rt.process_plan_start_day  <= rs.request_date
            order by rt.work_order_no,process_plan_start_day
    </select>

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml

@@ -144,7 +144,7 @@
               pl.plan_end_day                                                                    as order_plan_end_day
        from aps_plate_plan as pl
                 left join aps_process_route as rt on pl.document_number = rt.work_order_no
        where pl.document_number is not null
        where pl.document_number is not null and rt.work_order_no is not null
        order by rt.work_order_no asc, rt.process_number desc
    </select>
    <update id="removeOtherStat" parameterType="String">