From bae4b94d9d30aab92fb86a302240f257bd7e0d99 Mon Sep 17 00:00:00 2001 From: zhang <zc857179121@qq.com> Date: 星期一, 15 九月 2025 14:34:28 +0800 Subject: [PATCH] 1 --- src/main/java/com/zy/asrs/controller/OrderController.java | 49 ++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 38 insertions(+), 11 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index e0134e4..a5ea6e5 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -11,6 +11,7 @@ import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.OrderDomainParam; import com.zy.asrs.entity.result.WrkTraceVo; +import com.zy.asrs.mapper.OrderMapper; import com.zy.asrs.service.*; import com.zy.common.model.DetlDto; import com.zy.common.web.BaseController; @@ -61,6 +62,15 @@ private FlowLogService flowLogService; @Autowired private ConfigService configService; + @Autowired + private OrderMapper orderMapper; + + + @GetMapping("/code/type/list") + public R docTypeLis2t(@RequestParam String threeCode) { + List<String> pakins = orderMapper.selectThreeCode(threeCode); + return R.ok().add(pakins); + } @GetMapping("/doc/type/list") @Transactional @@ -231,24 +241,28 @@ EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); excludeTrash(param); Object o = param.get("orderType"); + param.remove("orderType"); + convert(param, wrapper); if (o != null) { String[] split = o.toString().split(","); if (split[0].equals("39")) { //wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", split); wrapper.in("source", split); List<String> m = configService.getMatCode(); - wrapper.andNew(); if (!Cools.isEmpty(m)) { - for (String s : m) { - wrapper.like("matnr", s, SqlLike.RIGHT); + for (int i = 0; i < m.size(); i++) { + if (i == 0) { + wrapper.andNew().like("matnr", m.get(i), SqlLike.RIGHT); + } else { + wrapper.or().like("matnr", m.get(i), SqlLike.RIGHT); + } } } } else { wrapper.in("source", split); } - param.remove("orderType"); } - convert(param, wrapper); + // List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1)); // List<Long> docIds = new ArrayList<>(); // for (DocType pakin : pakins) { @@ -256,7 +270,8 @@ // docIds.add(pakin.getDocId()); // } // } - return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); + Page<OrderDetl> orderDetlPage = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); + return R.ok(orderDetlPage); } @@ -318,8 +333,18 @@ docIds.add(pakin.getDocId()); } } - wrapper.like("matnr", "50", SqlLike.RIGHT); wrapper.in("source", docIds); + List<String> m = configService.getMatCode2(); + if (!Cools.isEmpty(m)) { + for (int i = 0; i < m.size(); i++) { + if (i == 0) { + wrapper.andNew().like("matnr", m.get(i), SqlLike.RIGHT); + } else { + wrapper.or().like("matnr", m.get(i), SqlLike.RIGHT); + } + } + } + //wrapper.like("matnr", "50", SqlLike.RIGHT); return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); } @@ -369,13 +394,15 @@ wrapper.in("source", docIds); List<String> m = configService.getMatCode(); - wrapper.andNew(); if (!Cools.isEmpty(m)) { - for (String s : m) { - wrapper.notLike("matnr", s, SqlLike.RIGHT); + for (int i = 0; i < m.size(); i++) { + if (i == 0) { + wrapper.andNew().notLike("matnr", m.get(i), SqlLike.RIGHT); + } else { + wrapper.or().notLike("matnr", m.get(i), SqlLike.RIGHT); + } } } - Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfmeDb(record.getMatnr(), record.getThreeCode(), 1); -- Gitblit v1.9.1