From b4ec8b4cc3476b49b9bc47e11ec03c4eecaba880 Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期四, 06 三月 2025 19:27:52 +0800 Subject: [PATCH] 四期 --- src/main/java/com/zy/asrs/controller/OrderDetlController.java | 33 ++++++++++++++++++++++++++++++--- 1 files changed, 30 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderDetlController.java b/src/main/java/com/zy/asrs/controller/OrderDetlController.java index 968877f..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,12 +203,20 @@ 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鍑哄簱鍗� if (split[0].equals("-1")) { - wrapper.like("order_no", "EB", SqlLike.RIGHT); - wrapper.in("source", split); + List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1)); + List<Long> docIds = new ArrayList<>(); + for (DocType pakin : pakins) { + if (pakin.getDocId() != 33) { + docIds.add(pakin.getDocId()); + } + } + wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", docIds); + flag = true; } else { wrapper.in("source", split); } @@ -224,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); } @@ -294,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); @@ -328,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); @@ -361,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