From ceeac33daaa44f605e2bd5a9c443c9438795be0d Mon Sep 17 00:00:00 2001 From: Administrator <56479841@QQ.COM> Date: 星期六, 07 十月 2023 16:17:07 +0800 Subject: [PATCH] #补丁 --- src/main/java/com/zy/asrs/controller/LocDetlController.java | 53 ++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 44 insertions(+), 9 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java index 304007b..77d49d2 100644 --- a/src/main/java/com/zy/asrs/controller/LocDetlController.java +++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java @@ -205,7 +205,41 @@ .where("loc_no like '" + row + "%'"); } List<LocDetl> list = locDetlService.selectList(wrapper); - return R.ok(exportSupport(list, fields)); + 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)); } @RequestMapping(value = "/locDetlQuery/auth") @@ -385,14 +419,15 @@ if (!Cools.isEmpty(mat.getStoreMaxDate())) { - if (Cools.isEmpty(locDetl.getBatch())) { - continue; - } else if (locDetl.getBatch().length() != 8) { - continue; - } +// if (Cools.isEmpty(locDetl.getBatch())) { +// continue; +// } else if (locDetl.getBatch().length() != 8) { +// continue; +// } try { - SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); - Date maxDate = simple.parse(locDetl.getBatch()); +// SimpleDateFormat simple = new SimpleDateFormat("yyyyMMdd"); +// Date maxDate = simple.parse(locDetl.getBatch()); + Date maxDate = locDetl.getModiTime(); Calendar calendar = new GregorianCalendar(); calendar.setTime(maxDate); // 鎶婃棩鏈熷線鍚庡鍔犱竴澶�,鏁存暟 寰�鍚庢帹,璐熸暟寰�鍓嶇Щ鍔� @@ -409,7 +444,7 @@ abnormalLocDetlParam.setSpecs(mat.getSpecs()); abnormalLocDetlParam.setBatch(locDetl.getBatch()); if (now.compareTo(maxDate) > 0) { - long difference = (now.getTime() - maxDate.getTime()) / (24 * 60 * 60 * 1000); + long difference = (now.getTime() - locDetl.getModiTime().getTime()) / (24 * 60 * 60 * 1000); abnormalLocDetlParam.setNowTime(Integer.parseInt(String.valueOf(difference))); result.add(abnormalLocDetlParam); } -- Gitblit v1.9.1