From 40631d025469ac3fb60a57dfab1d9022cb0298a6 Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期二, 25 三月 2025 16:57:46 +0800
Subject: [PATCH] 站点退回操作,防止改成空库位

---
 src/main/java/com/zy/asrs/controller/OrderDetlController.java |   64 +++++++++++++++++++++++++++++--
 1 files changed, 59 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OrderDetlController.java b/src/main/java/com/zy/asrs/controller/OrderDetlController.java
index 718f555..77bc3c8 100644
--- a/src/main/java/com/zy/asrs/controller/OrderDetlController.java
+++ b/src/main/java/com/zy/asrs/controller/OrderDetlController.java
@@ -10,9 +10,11 @@
 import com.core.common.Cools;
 import com.core.common.DateUtils;
 import com.core.common.R;
+import com.zy.asrs.entity.AgvWrkDetl;
 import com.zy.asrs.entity.DocType;
 import com.zy.asrs.entity.Order;
 import com.zy.asrs.entity.OrderDetl;
+import com.zy.asrs.mapper.AgvWrkDetlMapper;
 import com.zy.asrs.service.*;
 import com.zy.common.web.BaseController;
 import lombok.Synchronized;
@@ -39,6 +41,9 @@
     private LocDetlService locDetlService;
     @Autowired
     private AgvLocDetlService agvLocDetlService;
+
+    @Autowired
+    private AgvWrkDetlMapper agvWrkDetlMapper;
 
     @RequestMapping(value = "/orderDetl/{id}/auth")
     @ManagerAuth
@@ -183,7 +188,8 @@
         for (OrderDetl record : page.getRecords()) {
             Double sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode());
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
-            record.setWorkNum(0D);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
         }
         return R.ok(page);
     }
@@ -240,7 +246,8 @@
                 sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode());
             }
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
-            record.setWorkNum(0D);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
         }
         return R.ok(page);
     }
@@ -309,7 +316,8 @@
         for (OrderDetl record : page.getRecords()) {
             Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed(record.getMatnr(), record.getThreeCode());
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
-            record.setWorkNum(0D);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
         }
 
         return R.ok(page);
@@ -344,7 +352,43 @@
         for (OrderDetl record : page.getRecords()) {
             Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed2(record.getMatnr(), record.getThreeCode());
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
-            record.setWorkNum(0D);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
+        }
+
+        return R.ok(page);
+    }
+
+    @RequestMapping(value = "/orderDetl/pakout/list/authV9")
+    @ManagerAuth
+    public R pakoutList9(@RequestParam(defaultValue = "1") Integer curr,
+                         @RequestParam(defaultValue = "10") Integer limit,
+                         @RequestParam(required = false) String orderByField,
+                         @RequestParam(required = false) String orderByType,
+                         @RequestParam Map<String, Object> param) {
+        EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
+        excludeTrash(param);
+        convertLike(param, wrapper);
+        if (!Cools.isEmpty(orderByField)) {
+            wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));
+        } else {
+            wrapper.orderBy("create_time", false);
+        }
+        List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1));
+        List<Long> docIds = new ArrayList<>();
+        for (DocType pakin : pakins) {
+            if (pakin.getDocId() == 48) {
+                docIds.add(pakin.getDocId());
+            }
+        }
+
+        wrapper.in("source", docIds);
+        Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper);
+        for (OrderDetl record : page.getRecords()) {
+            Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed2(record.getMatnr(), record.getThreeCode());
+            record.setStock(sumAnfme == null ? 0 : sumAnfme);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
         }
 
         return R.ok(page);
@@ -378,12 +422,22 @@
         for (OrderDetl record : page.getRecords()) {
             Double sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode());
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
-            record.setWorkNum(0D);
+            //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo());
+            //record.setWorkNum(workNum == null ? 0 : workNum);
         }
 
         return R.ok(page);
     }
 
+    @RequestMapping(value = "/orderDetl/pakout/workNum")
+    @ManagerAuth
+    public R listWorkDetl() {
+        List<AgvWrkDetl> agvWrkDetls = agvWrkDetlMapper.listAnfmeByMatnr();
+        return R.ok(agvWrkDetls);
+
+    }
+
+
     private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper) {
         for (Map.Entry<String, Object> entry : map.entrySet()) {
             String val = String.valueOf(entry.getValue());

--
Gitblit v1.9.1