From 138b5fc883c3ccb25f4bed7114a60f93e78aaa9a Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期日, 02 六月 2024 13:30:37 +0800
Subject: [PATCH] #条码检测

---
 src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java |   40 +++++++++++++++++++++++++++++-----------
 1 files changed, 29 insertions(+), 11 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
index f6b5c47..9e7dff0 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
@@ -82,14 +82,18 @@
                 double anfme = agvLocDetl.getAnfme();
                 //int ioType = anfme > issued ? 101 : 103;
                 anfme = anfme > issued ? issued : anfme;
-                LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNo, anfme);
+                //鐢ㄤ簬鏄剧ず宸ヤ綔鏄庣粏妗g殑璁㈠崟鍙�
+                String orderNoWrkDtel = Utils.getOrderNo(orderNo,anfme);
+                //鏇存柊璁㈠崟鏁伴噺
+                orderNo = Utils.orderMergeUpdate(orderNo,anfme);
+                LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNoWrkDtel, anfme);
                 locDto.setCsocode(csocode);
                 locDto.setIsoseq(isoseq);
                 locDto.setContainerCode(agvLocDetl.getSuppCode());
                 //褰撳墠搴撲綅鎵�澶勬ゼ灞�
-                int floor = Integer.parseInt(agvLocDetl.getLocNo().split("@")[1]);
+                int floor = Integer.parseInt(agvLocDetl.getLocNo().split("F")[1]);
                 //locDto.setAgvStaNos(queryAgvStaNosByFloor(floor));
-                locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByFloor(floor));
+                locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(),floor));
                 locDtoList.add(locDto);
 
                 issued -= anfme;
@@ -113,9 +117,19 @@
         return page;
     }
 
+    @Override
+    public Double getSumAnfme(String matnr, String threeCode) {
+        return this.baseMapper.selectSumAnfmeByMatnr(matnr, threeCode);
+    }
+
+    @Override
+    public Double getSumAnfmeDb(String matnr, String threeCode,Integer floor) {
+        return this.baseMapper.selectSumAnfmeByMatnr2(matnr, threeCode, floor);
+    }
+
     /*
-    鑾峰彇搴撳瓨鎬绘暟
-     */
+        鑾峰彇搴撳瓨鎬绘暟
+         */
     public Integer sum() {
         return this.baseMapper.sum();
     }
@@ -149,13 +163,14 @@
 
     public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode) {
         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>();
-        Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode);
         wrapper.eq("loc_no", locNo);
+        Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode);
         if (anfme <= 0) {
             return this.baseMapper.deleteLocDetl(locNo,anfme,matnr,batch,csocode,isocode) > 0;
         } else {
             AgvLocDetl agvLocDetl = this.selectOne(wrapper);
             agvLocDetl.setAnfme(anfme);
+            agvLocDetl.setModiTime(new Date());
             return this.baseMapper.updateAnfme(locNo,anfme,matnr,batch,csocode,isocode) > 0;
         }
     }
@@ -165,7 +180,7 @@
         if(Cools.isEmpty(condition)){
             wrapper.andNew().eq(column,"").or().isNull(column);
         }else {
-            wrapper.eq(column,condition);
+            wrapper.andNew().eq(column,condition);
         }
     }
 
@@ -236,18 +251,21 @@
             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鏉′互涓婅褰�");
             }
         }
     }
 
-
+    @Override
+    public void updateLocNo(String locNo, String sourceLoc, AgvLocDetl agvLocDetl) {
+        this.baseMapper.updateLocNo(locNo,sourceLoc,agvLocDetl.getSuppCode());
+    }
 }

--
Gitblit v1.9.1