From 61865754d0cd0fd08480ebe746b06299b5e8d395 Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期四, 06 三月 2025 18:37:12 +0800 Subject: [PATCH] 四期 --- src/main/java/com/zy/asrs/controller/OrderDetlController.java | 25 +++++++++++++++++++++++-- 1 files changed, 23 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderDetlController.java b/src/main/java/com/zy/asrs/controller/OrderDetlController.java index b6744b8..be477d4 100644 --- a/src/main/java/com/zy/asrs/controller/OrderDetlController.java +++ b/src/main/java/com/zy/asrs/controller/OrderDetlController.java @@ -13,6 +13,7 @@ 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 +40,9 @@ private LocDetlService locDetlService; @Autowired private AgvLocDetlService agvLocDetlService; + + @Autowired + private AgvWrkDetlMapper agvWrkDetlMapper; @RequestMapping(value = "/orderDetl/{id}/auth") @ManagerAuth @@ -183,6 +187,8 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfme(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); } @@ -197,6 +203,7 @@ EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); excludeTrash(param); Object o = param.get("orderType"); + boolean flag = false; if (o != null) { String[] split = o.toString().split(","); //-1璇存槑鏄崐鎴愬搧绠卞3鍑哄簱鍗� @@ -208,7 +215,8 @@ docIds.add(pakin.getDocId()); } } - wrapper.in("source", docIds).andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT); + wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", docIds); + flag = true; } else { wrapper.in("source", split); } @@ -230,8 +238,15 @@ // wrapper.in("source", docIds); Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); for (OrderDetl record : page.getRecords()) { - Double sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode()); + Double sumAnfme; + if (flag) { + sumAnfme = agvLocDetlService.getSumAnfme2(record.getMatnr(), record.getThreeCode()); + } else { + sumAnfme = agvLocDetlService.getSumAnfme(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); } @@ -300,6 +315,8 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed(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); @@ -334,6 +351,8 @@ 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); @@ -367,6 +386,8 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfme(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); -- Gitblit v1.9.1