From a182725ea3476ac4441b34904ca77b5f958a098d Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期五, 25 七月 2025 16:29:51 +0800
Subject: [PATCH] 库存明细导出完善

---
 src/main/java/com/zy/asrs/controller/LocDetlController.java |   68 +++++++++++++++++-----------------
 1 files changed, 34 insertions(+), 34 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java
index 7a7c881..c431979 100644
--- a/src/main/java/com/zy/asrs/controller/LocDetlController.java
+++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java
@@ -296,41 +296,41 @@
                     .where("loc_no like '" + row + "%'");
         }
         List<LocDetl> list = locDetlService.selectList(wrapper);
-        List<AbnormalLocDetlParam> result = new ArrayList<>();
+//        List<AbnormalLocDetlParam> result = new ArrayList<>();
 
-        Page<LocDetl> groupLocDetl = locDetlService.getStockStatis2(toPage(1, 10000, param, LocDetl.class));
-        for (LocDetl locDetl : groupLocDetl.getRecords()) {
-            AbnormalLocDetlParam abnormalLocDetlParam = new AbnormalLocDetlParam();
-            Mat mat = matService.selectOne(new EntityWrapper<Mat>()
-                    .eq("matnr", locDetl.getMatnr()));
-            if (Cools.isEmpty(mat)) {
-                continue;
-            }
-            if (!Cools.isEmpty(mat                                                                          .getStoreMax()) || !Cools.isEmpty(mat.getStoreMin())) {
-                abnormalLocDetlParam.setStoreMax(mat.getStoreMax());
-                abnormalLocDetlParam.setStoreMaxDate(mat.getStoreMaxDate());
-                abnormalLocDetlParam.setStoreMin(mat.getStoreMin());
-                abnormalLocDetlParam.setAnfme(locDetl.getAnfme());
-                abnormalLocDetlParam.setMaktx(mat.getMaktx());
-                abnormalLocDetlParam.setMatnr(mat.getMatnr());
-                abnormalLocDetlParam.setSpecs(mat.getSpecs());
-                abnormalLocDetlParam.setBatch(locDetl.getBatch());
-
-//                SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd");
-//                Date maxDate = simple.parse(locDetl.getBatch());
-//                long time = maxDate.getTime();
-//                Date now = new Date();
-//                long time1 = now.getTime();
-//                abnormalLocDetlParam.setNowTime((int) ((time1 - time) / (1000 * 60 * 60 * 24)));
-
-                if (!Cools.isEmpty(mat.getStoreMax()) && locDetl.getAnfme() > mat.getStoreMax()) {
-                    result.add(abnormalLocDetlParam);
-                } else if (!Cools.isEmpty(mat.getStoreMin()) && locDetl.getAnfme() < mat.getStoreMin()) {
-                    result.add(abnormalLocDetlParam);
-                }
-            }
-        }
-        return R.ok(exportSupport(result, fields));
+//        Page<LocDetl> groupLocDetl = locDetlService.getStockStatis2(toPage(1, 10000, param, LocDetl.class));
+//        for (LocDetl locDetl : list) {
+//            AbnormalLocDetlParam abnormalLocDetlParam = new AbnormalLocDetlParam();
+//            Mat mat = matService.selectOne(new EntityWrapper<Mat>()
+//                    .eq("matnr", locDetl.getMatnr()));
+//            if (Cools.isEmpty(mat)) {
+//                continue;
+//            }
+//            if (!Cools.isEmpty(mat                                                                          .getStoreMax()) || !Cools.isEmpty(mat.getStoreMin())) {
+//                abnormalLocDetlParam.setStoreMax(mat.getStoreMax());
+//                abnormalLocDetlParam.setStoreMaxDate(mat.getStoreMaxDate());
+//                abnormalLocDetlParam.setStoreMin(mat.getStoreMin());
+//                abnormalLocDetlParam.setAnfme(locDetl.getAnfme());
+//                abnormalLocDetlParam.setMaktx(mat.getMaktx());
+//                abnormalLocDetlParam.setMatnr(mat.getMatnr());
+//                abnormalLocDetlParam.setSpecs(mat.getSpecs());
+//                abnormalLocDetlParam.setBatch(locDetl.getBatch());
+//
+////                SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd");
+////                Date maxDate = simple.parse(locDetl.getBatch());
+////                long time = maxDate.getTime();
+////                Date now = new Date();
+////                long time1 = now.getTime();
+////                abnormalLocDetlParam.setNowTime((int) ((time1 - time) / (1000 * 60 * 60 * 24)));
+//
+//                if (!Cools.isEmpty(mat.getStoreMax()) && locDetl.getAnfme() > mat.getStoreMax()) {
+//                    result.add(abnormalLocDetlParam);
+//                } else if (!Cools.isEmpty(mat.getStoreMin()) && locDetl.getAnfme() < mat.getStoreMin()) {
+//                    result.add(abnormalLocDetlParam);
+//                }
+//            }
+//        }
+        return R.ok(exportSupport(list, fields));
     }
 
     @RequestMapping(value = "/locDetl/selectOwner/list/auth")

--
Gitblit v1.9.1