From 24c2fd8ab62fa12ae96658664e7ffd478bef6e62 Mon Sep 17 00:00:00 2001 From: whycq <913841844@qq.com> Date: 星期一, 13 五月 2024 19:16:15 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/OrderController.java | 210 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 209 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index cf452b0..2808a62 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -52,6 +52,8 @@ private LocDetlService locDetlService; @Autowired private MatService matService; + @Autowired + private AgvLocDetlService agvLocDetlService; @RequestMapping(value = "/order/nav/list/auth") @ManagerAuth @@ -130,7 +132,19 @@ @RequestParam(required = false)String orderByField, @RequestParam(required = false)String orderByType, @RequestParam Map<String, Object> param){ - return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class))); + EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); + excludeTrash(param); + convert(param, wrapper); +// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class))); + List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1)); + List<Long> docIds = new ArrayList<>(); + for (DocType pakin : pakins) { + if (pakin.getDocId() != 32) { + docIds.add(pakin.getDocId()); + } + } + wrapper.in("source",docIds); + return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); // EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); // excludeTrash(param); // convert(param, wrapper); @@ -150,6 +164,56 @@ // } // wrapper.in("order_no",orderNos); // return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); + } + + // 鎵�鏈夊叆搴撹鍗曟槑缁� + @RequestMapping(value = "/order/bcp/detls/pakin/page/auth") + @ManagerAuth + public R bcpOrderDetls(@RequestParam(defaultValue = "1")Integer curr, + @RequestParam(defaultValue = "100")Integer limit, + @RequestParam(required = false)String orderByField, + @RequestParam(required = false)String orderByType, + @RequestParam Map<String, Object> param){ + EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); + excludeTrash(param); + convert(param, wrapper); +// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class))); + List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1)); + List<Long> docIds = new ArrayList<>(); + for (DocType pakin : pakins) { + if (pakin.getDocId() == 32) { + docIds.add(pakin.getDocId()); + } + } + wrapper.in("source",docIds); + return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper)); + } + + @RequestMapping(value = "/order/bcpDb/detls/pakin/page/auth") + @ManagerAuth + public R bcpDbOrderDetls(@RequestParam(defaultValue = "1")Integer curr, + @RequestParam(defaultValue = "100")Integer limit, + @RequestParam(required = false)String orderByField, + @RequestParam(required = false)String orderByType, + @RequestParam Map<String, Object> param){ + EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>(); + excludeTrash(param); + convert(param, wrapper); +// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class))); + 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.in("source",docIds); + Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper); + for (OrderDetl record : page.getRecords()) { + Double sumAnfme = agvLocDetlService.getSumAnfmeDb(record.getMatnr(), record.getThreeCode(),1); + record.setStock(sumAnfme == null ? 0 : sumAnfme); + } + return R.ok(page); } @RequestMapping(value = "/order/detl/all/auth") @@ -219,6 +283,7 @@ list.add(dto); orderDetl.setOrderId(order.getId()); orderDetl.setOrderNo(order.getOrderNo()); + orderDetl.setSource(param.getDocType().intValue()); orderDetl.setCreateBy(getUserId()); orderDetl.setCreateTime(now); orderDetl.setUpdateBy(getUserId()); @@ -230,6 +295,74 @@ } } } + if (param.getDocType().intValue() == 32) { + order = new Order( + String.valueOf(snowflakeIdWorker.nextId()), // 缂栧彿[闈炵┖] + "DB" + param.getOrderNo(), // 璁㈠崟缂栧彿 + DateUtils.convert(now), // 鍗曟嵁鏃ユ湡 + 33L, // 鍗曟嵁绫诲瀷 + null, // 椤圭洰缂栧彿 + null, // + null, // 璋冩嫧椤圭洰缂栧彿 + null, // 鍒濆绁ㄦ嵁鍙� + null, // 绁ㄦ嵁鍙� + null, // 瀹㈡埛缂栧彿 + null, // 瀹㈡埛 + null, // 鑱旂郴鏂瑰紡 + null, // 鎿嶄綔浜哄憳 + null, // 鍚堣閲戦 + null, // 浼樻儬鐜� + null, // 浼樻儬閲戦 + null, // 閿�鍞垨閲囪喘璐圭敤鍚堣 + null, // 瀹炰粯閲戦 + null, // 浠樻绫诲瀷 + null, // 涓氬姟鍛� + null, // 缁撶畻澶╂暟 + null, // 閭垂鏀粯绫诲瀷 + null, // 閭垂 + null, // 浠樻鏃堕棿 + null, // 鍙戣揣鏃堕棿 + null, // 鐗╂祦鍚嶇О + null, // 鐗╂祦鍗曞彿 + 1L, // 璁㈠崟鐘舵�� + 1, // 鐘舵�� + getUserId(), // 娣诲姞浜哄憳 + now, // 娣诲姞鏃堕棿 + getUserId(), // 淇敼浜哄憳 + now, // 淇敼鏃堕棿 + null // 澶囨敞 + ); + if (!orderService.insert(order)) { + throw new CoolException("鐢熸垚鍗婃垚鍝佽皟鎷ㄥ崟澶辫触"); + } + List<DetlDto> dbList = new ArrayList<>(); + for (OrderDetl orderDetl : param.getOrderDetlList()) { + DetlDto dto = new DetlDto(orderDetl.getMatnr(), orderDetl.getBatch()); + if (DetlDto.has(dbList, dto)) { + OrderDetl item = orderDetlService.selectItem(order.getId(), orderDetl.getMatnr(), orderDetl.getBatch(),orderDetl.getThreeCode(),orderDetl.getDeadTime()); + item.setAnfme(item.getAnfme() + orderDetl.getAnfme()); + if (!orderDetlService.updateById(item)) { + throw new CoolException("鐢熸垚鍗婃垚鍝佽皟鎷ㄥ崟鏄庣粏妗eけ璐�"); + } + } else { + dbList.add(dto); + orderDetl.setOrderId(order.getId()); + orderDetl.setOrderNo(order.getOrderNo()); + orderDetl.setSource(33); + orderDetl.setCreateBy(getUserId()); + orderDetl.setCreateTime(now); + orderDetl.setUpdateBy(getUserId()); + orderDetl.setUpdateTime(now); + orderDetl.setStatus(1); + orderDetl.setQty(0.0D); + if (!orderDetlService.insert(orderDetl)) { + throw new CoolException("鐢熸垚鍗婃垚鍝佽皟鎷ㄥ崟鏄庣粏妗eけ璐�"); + } + } + } + } + + return R.ok("璁㈠崟娣诲姞鎴愬姛"); } @@ -573,6 +706,7 @@ if (orderDetl == null) { orderDetl = new OrderDetl(); orderDetl.sync(mat); + orderDetl.setSource(docType.getDocId().intValue()); orderDetl.setBatch(null); orderDetl.setAnfme(anfme); orderDetl.setOrderId(order.getId()); @@ -593,6 +727,80 @@ throw new CoolException("鐢熸垚鍗曟嵁鏄庣粏澶辫触锛岃閲嶆柊瀵煎叆锛�"); } } + if (docType.getDocId().intValue() == 32) { + String dbUuid = "DB" + uuid; + Order order2 = orderService.selectByNo(dbUuid); + if (null == order2) { + order2 = new Order( + String.valueOf(snowflakeIdWorker.nextId()), // 缂栧彿[闈炵┖] + dbUuid, // 璁㈠崟缂栧彿 + null, // 鍗曟嵁鏃ユ湡 + 33L, // 鍗曟嵁绫诲瀷 + null, // 椤圭洰缂栧彿 + null, // + null, // 璋冩嫧椤圭洰缂栧彿 + null, // 鍒濆绁ㄦ嵁鍙� + null, // 绁ㄦ嵁鍙� + null, // 瀹㈡埛缂栧彿 + null, // 瀹㈡埛 + null, // 鑱旂郴鏂瑰紡 + null, // 鎿嶄綔浜哄憳 + null, // 鍚堣閲戦 + null, // 浼樻儬鐜� + null, // 浼樻儬閲戦 + null, // 閿�鍞垨閲囪喘璐圭敤鍚堣 + null, // 瀹炰粯閲戦 + null, // 浠樻绫诲瀷 + null, // 涓氬姟鍛� + null, // 缁撶畻澶╂暟 + null, // 閭垂鏀粯绫诲瀷 + null, // 閭垂 + null, // 浠樻鏃堕棿 + null, // 鍙戣揣鏃堕棿 + null, // 鐗╂祦鍚嶇О + null, // 鐗╂祦鍗曞彿 + 1L, // 璁㈠崟鐘舵�� + 1, // 鐘舵�� + userId, // 娣诲姞浜哄憳 + now, // 娣诲姞鏃堕棿 + userId, // 淇敼浜哄憳 + now, // 淇敼鏃堕棿 + null // 澶囨敞 + ); + if (!orderService.insert(order2)) { + throw new CoolException("鐢熸垚鍗曟嵁涓绘。澶辫触锛岃閲嶆柊瀵煎叆锛�"); + } + }else { + order2.setSettle(order.getSettle() == 1L ? 1L : 2L ); + orderService.updateById(order2); + } + + OrderDetl orderDetl2 = orderDetlService.selectItem(order2.getId(), matnr, null,csocode,isocode); + if (orderDetl2 == null) { + orderDetl2 = new OrderDetl(); + orderDetl2.sync(mat); + orderDetl2.setSource(33); + orderDetl2.setBatch(null); + orderDetl2.setAnfme(anfme); + orderDetl2.setOrderId(order2.getId()); + orderDetl2.setOrderNo(order2.getOrderNo()); + orderDetl2.setCreateBy(userId); + orderDetl2.setCreateTime(now); + orderDetl2.setUpdateBy(userId); + orderDetl2.setUpdateTime(now); + orderDetl2.setThreeCode(csocode); + orderDetl2.setDeadTime(isocode); + orderDetl2.setStatus(1); + orderDetl2.setQty(0.0D); + if (!orderDetlService.insert(orderDetl2)) { + throw new CoolException("鐢熸垚鍗曟嵁鏄庣粏澶辫触锛岃閲嶆柊瀵煎叆锛�"); + } + } else { + if(!orderDetlService.increaseAnfme(order2.getId(), matnr, null, anfme,csocode,isocode)) { + throw new CoolException("鐢熸垚鍗曟嵁鏄庣粏澶辫触锛岃閲嶆柊瀵煎叆锛�"); + } + } + } } return R.ok("瀵煎叆鎴愬姛"); } -- Gitblit v1.9.1