# 自动回流取消任务更改源库位为D

whycq

2024-05-24 d17a7346759fbb432cea1c83de63d29c6a3d330d

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

@@ -122,6 +122,11 @@
        return this.baseMapper.selectSumAnfmeByMatnr(matnr, threeCode);
    }

    @Override
    public Double getSumAnfmeDb(String matnr, String threeCode,Integer floor) {
        return this.baseMapper.selectSumAnfmeByMatnr2(matnr, threeCode, floor);
    }

    /*
        获取库存总数
         */
@@ -245,15 +250,15 @@
            Row row = sheet.getRow(i);
            // 库位号
            String locNo = dataFormatter.formatCellValue(row.getCell(0));
            // 容器码
            // 货架码
            String containerCode = dataFormatter.formatCellValue(row.getCell(1));

            List<AgvLocDetl> agvLocDetls = this.selectList(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo).eq("supp_code", containerCode));
            if(Cools.isEmpty(agvLocDetls)){
                log.info("库位号：" + locNo + "，容器码：" + containerCode + "，不存在明细");
                log.info("库位号：" + locNo + "，货架码：" + containerCode + "，不存在明细");
            }
            if(agvLocDetls.size()>1){
                log.info("库位号：" + locNo + "，容器码：" + containerCode + "，存在1条以上记录");
                log.info("库位号：" + locNo + "，货架码：" + containerCode + "，存在1条以上记录");
            }
        }
    }