From 40631d025469ac3fb60a57dfab1d9022cb0298a6 Mon Sep 17 00:00:00 2001 From: ZY <zc857179121@qq.com> Date: 星期二, 25 三月 2025 16:57:46 +0800 Subject: [PATCH] 站点退回操作,防止改成空库位 --- src/main/java/com/zy/asrs/controller/OrderDetlController.java | 64 +++++++++++++++++++++++++++++-- 1 files changed, 59 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderDetlController.java b/src/main/java/com/zy/asrs/controller/OrderDetlController.java index 718f555..77bc3c8 100644 --- a/src/main/java/com/zy/asrs/controller/OrderDetlController.java +++ b/src/main/java/com/zy/asrs/controller/OrderDetlController.java @@ -10,9 +10,11 @@ import com.core.common.Cools; import com.core.common.DateUtils; import com.core.common.R; +import com.zy.asrs.entity.AgvWrkDetl; 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 +41,9 @@ private LocDetlService locDetlService; @Autowired private AgvLocDetlService agvLocDetlService; + + @Autowired + private AgvWrkDetlMapper agvWrkDetlMapper; @RequestMapping(value = "/orderDetl/{id}/auth") @ManagerAuth @@ -183,7 +188,8 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode()); record.setStock(sumAnfme == null ? 0 : sumAnfme); - record.setWorkNum(0D); + //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo()); + //record.setWorkNum(workNum == null ? 0 : workNum); } return R.ok(page); } @@ -240,7 +246,8 @@ sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode()); } record.setStock(sumAnfme == null ? 0 : sumAnfme); - record.setWorkNum(0D); + //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo()); + //record.setWorkNum(workNum == null ? 0 : workNum); } return R.ok(page); } @@ -309,7 +316,8 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed(record.getMatnr(), record.getThreeCode()); record.setStock(sumAnfme == null ? 0 : sumAnfme); - record.setWorkNum(0D); + //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo()); + //record.setWorkNum(workNum == null ? 0 : workNum); } return R.ok(page); @@ -344,7 +352,43 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfmeProcessed2(record.getMatnr(), record.getThreeCode()); record.setStock(sumAnfme == null ? 0 : sumAnfme); - record.setWorkNum(0D); + //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/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); @@ -378,12 +422,22 @@ for (OrderDetl record : page.getRecords()) { Double sumAnfme = agvLocDetlService.getSumAnfme(record.getMatnr(), record.getThreeCode()); record.setStock(sumAnfme == null ? 0 : sumAnfme); - record.setWorkNum(0D); + //Double workNum = agvWrkDetlMapper.sumAnfmeByMatnr(record.getMatnr(), record.getThreeCode(), record.getOrderNo()); + //record.setWorkNum(workNum == null ? 0 : workNum); } return R.ok(page); } + @RequestMapping(value = "/orderDetl/pakout/workNum") + @ManagerAuth + public R listWorkDetl() { + List<AgvWrkDetl> agvWrkDetls = agvWrkDetlMapper.listAnfmeByMatnr(); + return R.ok(agvWrkDetls); + + } + + private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper) { for (Map.Entry<String, Object> entry : map.entrySet()) { String val = String.valueOf(entry.getValue()); -- Gitblit v1.9.1