#可删除 用于审计数据筛选

LSH

2023-06-21 28dacc09ae4a3da06a1115b278bff76c78a51cac

#可删除   用于审计数据筛选

 src/main/java/com/zy/asrs/mapper/LocMastMapper.java

@@ -24,4 +24,5 @@
    List<LocMast> queryShallowLocFMast(@Param("crnNo") Integer crnNo);

    LocMast queryNeedMoveShallLoc(Integer crnNo);
    LocMast queryNeedMoveShallLocD(Integer crnNo);
}

 src/main/java/com/zy/asrs/service/LocMastService.java

@@ -39,5 +39,6 @@
    List<LocMast> queryShallowLocFMast(Integer crnNo);

    public LocMast queryNeedMoveShallLoc(Integer crnNo);
    public LocMast queryNeedMoveShallLocD(Integer crnNo);

}

 src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java

@@ -57,4 +57,8 @@
    public LocMast queryNeedMoveShallLoc(Integer crnNo) {
        return this.baseMapper.queryNeedMoveShallLoc(crnNo);
    }
    @Override
    public LocMast queryNeedMoveShallLocD(Integer crnNo) {
        return this.baseMapper.queryNeedMoveShallLocD(crnNo);
    }
}

 src/main/java/com/zy/asrs/task/handler/CheckDeepHandler.java

@@ -57,8 +57,12 @@
                if(!Cools.isEmpty(crnp) && !Cools.isEmpty(crnp.getTankQty()) && crnp.getTankQty()==0){
                    continue;
                }

                LocMast locMast = locMastService.queryNeedMoveShallLoc(crnNo);
                if (crnNo==2 || crnNo == 4){
                    locMast=locMastService.queryNeedMoveShallLocD(crnNo);
                }


//                LocMast targetLoc = locMastService.queryEmptyDeepLoc(crnNo);
                if (!Cools.isEmpty(locMast)) {
                    workService.locMove(locMast.getLocNo(), 1L);

 src/main/resources/mapper/LocMastMapper.xml

@@ -85,4 +85,13 @@
            crn_no = #{crnNo} AND (loc_sts = 'F' OR loc_sts = 'D') and inv_wh = '0'
        order by bay1,lev1
    </select>
    <select id="queryNeedMoveShallLocD" resultMap="BaseResultMap">
        SELECT
            TOP 1 *
        FROM
            asr_loc_mast
        WHERE
            crn_no = #{crnNo} AND (loc_sts = 'F' OR loc_sts = 'D') and inv_wh = '0'
        order by bay1,lev1 Desc
    </select>
</mapper>