零件统计问题修复

zhanghl

2025-04-27 ee9f09aa18566a29e5e112ce7c5300038e925351

零件统计问题修复

 aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartRouteStatController.java

@@ -104,7 +104,7 @@
    /**
     * 1.根据现有零件计划 和工艺路线、资源池信息 更新统计表
     * */
    @RequiresPermissions("apsPartRouteStat:edit")

    @PostMapping("/updateStat")
    public AjaxResult updateStat()
    {

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPartRouteStatServiceImpl.java

@@ -175,6 +175,7 @@
                last = stat;
                stat.setId(IdUtils.fastUUID().toString());
                stat.setBatchNumber(batchNum);
                stat.setDelFlag("0");
                apsPartRouteStatMapper.insertApsPartRouteStat(stat);
            }
        }

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

@@ -124,6 +124,7 @@
            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 and rt.work_order_no is not null
             and pl.del_flag='0'
             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/ApsProcessRouteMapper.xml

@@ -52,6 +52,7 @@
            <if test="plant != null  and plant != ''"> and plant = #{plant}</if>
            <if test="workCenter != null  and workCenter != ''"> and work_center = #{workCenter}</if>
        </where>
        order by  process_number asc
    </select>

    <select id="selectApsProcessRouteById" parameterType="String" resultMap="ApsProcessRouteResult">