From d43b2b81ccc729e0ec214565c1811eefdbcf1974 Mon Sep 17 00:00:00 2001 From: zhang <zc857179121@qq.com> Date: 星期一, 14 七月 2025 15:20:20 +0800 Subject: [PATCH] 1 --- src/main/java/com/zy/asrs/controller/OrderDetlController.java | 47 ++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 46 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderDetlController.java b/src/main/java/com/zy/asrs/controller/OrderDetlController.java index 6d70670..321feeb 100644 --- a/src/main/java/com/zy/asrs/controller/OrderDetlController.java +++ b/src/main/java/com/zy/asrs/controller/OrderDetlController.java @@ -17,6 +17,7 @@ import com.zy.asrs.mapper.AgvWrkDetlMapper; import com.zy.asrs.service.*; import com.zy.common.web.BaseController; +import com.zy.system.service.ConfigService; import lombok.Synchronized; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @@ -44,6 +45,8 @@ @Autowired private AgvWrkDetlMapper agvWrkDetlMapper; + @Autowired + private ConfigService configService; @RequestMapping(value = "/orderDetl/{id}/auth") @ManagerAuth @@ -216,7 +219,14 @@ docIds.add(pakin.getDocId()); } } - wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", docIds); + wrapper.in("source", docIds); + List<String> m = configService.getMatCode(); + wrapper.andNew(); + if (!Cools.isEmpty(m)) { + for (String s : m) { + wrapper.like("matnr", s, SqlLike.RIGHT); + } + } flag = true; } else { wrapper.in("source", split); @@ -359,6 +369,41 @@ return R.ok(page); } + @RequestMapping(value = "/orderDetl/pakout/list/authV9") + @ManagerAuth + public R pakoutList9(@RequestParam(defaultValue = "1") Integer curr, + @RequestParam(defaultValue = "10") Integer limit, + @RequestParam(required = false) String orderByField, + @RequestParam(required = false) String orderByType, + @RequestParam Map<String, Object> param) { + EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); + excludeTrash(param); + convertLike(param, wrapper); + if (!Cools.isEmpty(orderByField)) { + wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); + } else { + wrapper.orderBy("create_time", false); + } + List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1)); + List<Long> docIds = new ArrayList<>(); + for (DocType pakin : pakins) { + if (pakin.getDocId() == 48) { + docIds.add(pakin.getDocId()); + } + } + + wrapper.in("source", docIds); + Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); + 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); + } + @RequestMapping(value = "/orderDetl/pakout/list/authV6") @ManagerAuth public R pakoutList6(@RequestParam(defaultValue = "1") Integer curr, -- Gitblit v1.9.1