From e4ea838c20e94dff4fdbb4f82b542a8b5790fa9d Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期五, 18 六月 2021 09:22:06 +0800 Subject: [PATCH] # 库存跳转上报erp --- src/main/java/zy/cloud/wms/manager/service/impl/WorkServiceImpl.java | 333 ++++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 228 insertions(+), 105 deletions(-) diff --git a/src/main/java/zy/cloud/wms/manager/service/impl/WorkServiceImpl.java b/src/main/java/zy/cloud/wms/manager/service/impl/WorkServiceImpl.java index 96a73ef..b494987 100644 --- a/src/main/java/zy/cloud/wms/manager/service/impl/WorkServiceImpl.java +++ b/src/main/java/zy/cloud/wms/manager/service/impl/WorkServiceImpl.java @@ -1,6 +1,7 @@ package zy.cloud.wms.manager.service.impl; import com.baomidou.mybatisplus.mapper.EntityWrapper; +import com.core.common.Arith; import com.core.common.Cools; import com.core.common.R; import com.core.common.SnowflakeIdWorker; @@ -9,10 +10,13 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import zy.cloud.wms.common.config.CodeCoolException; import zy.cloud.wms.common.model.BillDto; import zy.cloud.wms.common.model.MatnrDto; import zy.cloud.wms.common.model.OrderStoDto; import zy.cloud.wms.common.service.MainService; +import zy.cloud.wms.common.service.asrs.AsrsService; +import zy.cloud.wms.common.service.asrs.entity.Result1; import zy.cloud.wms.common.service.erp.ErpService; import zy.cloud.wms.common.utils.VersionUtils; import zy.cloud.wms.manager.entity.*; @@ -38,15 +42,11 @@ @Autowired private LocDetlService locDetlService; @Autowired - private CustOrderService custOrderService; - @Autowired private PakoutService pakoutService; @Autowired private SnowflakeIdWorker snowflakeIdWorker; @Autowired private MatService matService; - @Autowired - private ErpService erpService; @Autowired private CheckService checkService; @Autowired @@ -57,6 +57,10 @@ private ItemService itemService; @Autowired private CstmrService cstmrService; + @Autowired + private ErpService erpService; + @Autowired + private AsrsService asrsService; @Override @Transactional @@ -70,6 +74,18 @@ } if (Cools.isEmpty(param.getMats())) { return R.error("鍏ュ簱鐗╂枡涓嶈兘涓虹┖"); + } + Integer docId = Optional.ofNullable(param.getDocType()).orElse(34); + String docNum = String.valueOf(snowflakeIdWorker.nextId()); + switch (docId) { + case 34: // 閲囪喘鍗� + docNum = "PU-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); + break; + case 45: // 閿�鍞��璐у崟 + docNum = "SR-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); + break; + default: + break; } Date now = new Date(); for (MatnrDto dto : param.getMats()) { @@ -86,8 +102,8 @@ locDetl.setZpallet(""); locDetl.setAnfme(dto.getCount()); VersionUtils.setLocDetl(locDetl, mat); -// locDetl.setDocId(param.getDocType().longValue()); -// locDetl.setDocNum(docNum); + locDetl.setDocId(docId.longValue()); + locDetl.setDocNum(docNum); locDetl.setStatus(1); locDetl.setCreateBy(userId); locDetl.setCreateTime(now); @@ -112,22 +128,67 @@ billDto.setQty(dto.getCount()); dtos.add(billDto); } - Integer docId = Optional.ofNullable(param.getDocType()).orElse(34); - String docNum = String.valueOf(snowflakeIdWorker.nextId()); - switch (docId) { - case 34: // 閲囪喘鍗� - docNum = "PU-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); - break; - case 45: // 閿�鍞��璐у崟 - docNum = "SR-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); - break; - default: - break; - } if (!erpService.uploadBill(dtos, docId, docNum)) { throw new CoolException("鏃犳硶涓婃姤鑷砮rp"); } + return R.ok("鍏ュ簱鎴愬姛"); + } + + @Override + @Transactional + public R stockPakout(PakoutParam param, Long userId) { + Mat mat = matService.selectByMatnr(param.getMatnr()); + Node node = nodeService.selectByUuid(param.getNodeUuid()); + LocDetl locDetl = locDetlService.getLocDetl(node.getId(), mat.getMatnr()); + if (locDetl == null || locDetl.getAnfme() < param.getCount()) { + return R.error(mat.getMaktx() + "搴撳瓨涓嶈冻"); + } + Pakout pakout = new Pakout( + String.valueOf(snowflakeIdWorker.nextId()), // 浠诲姟鍙穂闈炵┖] + 3L, // 宸ヤ綔鐘舵�� + null, // 鎵樼洏鍙� + param.getCount(), // 鍑哄簱鏁伴噺 + node.getId(), // 鍏宠仈璐т綅[闈炵┖] + node.getUuid(), // 璐т綅[闈炵┖] + mat.getMatnr(), // 鍟嗗搧缂栫爜[闈炵┖] + null, // 鍟嗗搧鍚嶇О + null, // 鍚嶇О + null, // 灏虹爜 + null, // 鍨嬪彿 + null, // 鎵瑰彿 + null, // 鍗曚綅 + null, // SKC + null, // 鍗曟嵁绫诲瀷 + null, // 鍗曟嵁缂栧彿 + null, // 瀹㈡埛鍚嶇О + null, // 鍝侀」鏁� + null, // 鏁伴噺 + null, // 閲嶉噺 + 1, // 鐘舵�� + userId, // 娣诲姞浜哄憳 + new Date(), // 娣诲姞鏃堕棿 + userId, // 淇敼浜哄憳 + new Date(), // 淇敼鏃堕棿 + null // 澶囨敞 + ); + VersionUtils.setPakout(pakout, mat); + // 淇濆瓨鍑哄簱閫氱煡鍗� + if (!pakoutService.insert(pakout)) { + throw new CoolException("淇濆瓨鍑哄簱閫氱煡鍗曞け璐�"); + } + if (param.getCount()>=locDetl.getAnfme()) { + // 鍒犻櫎搴撳瓨鏄庣粏 + if (!locDetlService.removeStock(node.getId(), mat.getMatnr())) { + throw new CoolException("鍒犻櫎搴撳瓨鏄庣粏澶辫触"); + } + } else { + // 淇敼搴撳瓨鏄庣粏鏁伴噺 + if (!locDetlService.reduceStock(node.getId(), mat.getMatnr(), param.getCount())) { + throw new CoolException("淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触"); + } + } + return R.ok(); } @Override @@ -202,7 +263,6 @@ if (!erpService.uploadBill(dtos, param.getDocType(), docNum)) { throw new CoolException("鏃犳硶涓婃姤鑷砮rp"); } - return R.ok(); } @@ -212,54 +272,65 @@ } @Override - public R stockOutPrint(StockOutParam param, Long userId) { - List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>().eq("doc_num", param.getNumber())); - Double total = 0.0D; - String custName = ""; - for (Pakout pakout : pakouts) { - total = pakout.getAnfme() + total; - custName = pakout.getCustName(); - } - StoPrintVo vo = new StoPrintVo(); - vo.setDocNum(param.getNumber()); - vo.setList(pakouts); - vo.setTotal(total); - vo.setCustName("娴欐睙涓壃绔嬪簱鎶�鏈湁闄愬叕鍙�"); - vo.setWorkerName("闄嗘檽娑�"); - return R.ok().add(vo); - } - - @Override public R stockOutPreview(StockOutParam param, Long userId) { - List<CustOrder> custOrders = custOrderService.selectList(new EntityWrapper<CustOrder>() - .eq("number", param.getNumber()) - .eq("status", 1) - ); - OrderStoDto dto = new OrderStoDto(); - dto.setNumber(param.getNumber()); - dto.setCustOrders(custOrders); + Order order = orderService.selectByOrderNo(param.getOrderNo()); + if (order.getSettle() != 1) { + return R.error("姝ゅ崟鎹棤娉曠敓鎴愭嫞璐у崟"); + } + List<OrderDetl> orderDetls = orderDetlService.selectByOrderNo(order.getOrderNo()); + if (Cools.isEmpty(orderDetls)) { + return R.error("姝ゅ崟鎹凡澶辨晥锛岃鑱旂郴绠$悊鍛�"); + } + OrderStoDto dto = new OrderStoDto().create(order.getOrderNo(), orderDetls); return R.ok().add(mainService.stockOutPreview(dto)); } @Override - public R stockOut(StockOutParam param, Long userId) { - List<CustOrder> custOrders = custOrderService.selectList(new EntityWrapper<CustOrder>() - .eq("number", param.getNumber()) - .eq("status", 1) - ); - OrderStoDto dto = new OrderStoDto(); - dto.setNumber(param.getNumber()); - dto.setCustOrders(custOrders); + public R stockOutCreate(StockOutParam param, Long userId) { + Order order = orderService.selectByOrderNo(param.getOrderNo()); + if (order.getSettle() != 1) { + return R.error("姝ゅ崟鎹棤娉曠敓鎴愭嫞璐у崟"); + } + List<OrderDetl> orderDetls = orderDetlService.selectByOrderNo(param.getOrderNo()); + if (Cools.isEmpty(orderDetls)) { + return R.error("姝ゅ崟鎹凡澶辨晥锛岃鑱旂郴绠$悊鍛�"); + } + for (OrderDetl orderDetl : orderDetls) { + if (Arith.remainder(orderDetl.getAnfme(), 1) > 0) { + return R.error(orderDetl.getMaktx() + "鏁伴噺蹇呴』涓烘暣鏁�"); + } + } + OrderStoDto dto = new OrderStoDto().create(order.getOrderNo(), orderDetls); // 寮�濮嬫暣鐞嗗嚭搴撴暟鎹� mainService.stockOutProcess(dto); return R.ok("鐢熸垚鎷h揣鍗曟垚鍔�"); } @Override + public R stockOutPrint(StockOutParam param, Long userId) { + Order order = orderService.selectByOrderNo(param.getOrderNo()); + if (order == null) { + return R.error("姝ゅ崟鎹凡澶辨晥"); + } + List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>().eq("doc_num", order.getOrderNo())); + Double total = 0.0D; + for (Pakout pakout : pakouts) { + total = pakout.getAnfme() + total; + } + StoPrintVo vo = new StoPrintVo(); + vo.setDocNum(param.getOrderNo()); + vo.setList(pakouts); + vo.setTotal(total); + vo.setCstmrName(order.getCstmrName()); + vo.setWorkerName(Cools.isEmpty(order.getOperMemb())? "" : order.getOperMemb()); + return R.ok().add(vo); + } + + @Override @Transactional public R stockOutComplete(StockConfirmParam param, Long userId) { List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>() - .eq("doc_num", param.getNumber()) + .eq("doc_num", param.getOrderNo()) .in("wrk_sts", 1, 2)); for (Pakout pakout : pakouts) { LocDetl locDetl = locDetlService.getLocDetl(pakout.getNodeId(), pakout.getMatnr()); @@ -328,31 +399,13 @@ } // 淇敼鍑哄簱鍗曠姸鎬� - if (!pakoutService.stockOutComplete(param.getWrkNo(), param.getNumber(), userId)) { + if (!pakoutService.stockOutComplete(param.getWrkNo(), param.getOrderNo(), userId)) { return R.error("淇濆瓨鏁版嵁澶辫触"); } // 淇敼鍗曟嵁鐘舵�� - if (!custOrderService.updateStatus(param.getNumber(), 4)) { + if (!orderService.updateSettle(param.getOrderNo(), 4L)) { throw new CoolException("淇敼鍗曟嵁鐘舵�佸け璐�"); } - // 閲囪喘閫�璐у崟 -// if (param.getNumber().startsWith("PR-")) { - // erp鍗曟嵁涓婁紶 todo -// Long docId = pakouts.get(0).getDocId(); -// if (null != docId) { -// List<BillDto> dtos = new ArrayList<>(); -// for (Pakout pakout : pakouts) { -// BillDto billDto = new BillDto(); -// billDto.setMatnr(pakout.getMatnr()); -// billDto.setQty(pakout.getAnfme()); -// dtos.add(billDto); -// } -// if (!erpService.uploadBill(dtos, docId.intValue() , pakouts.get(0).getDocNum())) { -// throw new CoolException("鏃犳硶涓婃姤鑷砮rp"); -// } -// } - -// } return R.ok(); } @@ -426,7 +479,7 @@ } if (complete) { // 淇敼鍗曟嵁鐘舵�� - if (!custOrderService.updateStatus(pakout.getDocNum(), 4)) { + if (!orderService.updateSettle(pakout.getDocNum(), 4L)) { throw new CoolException("淇敼鍗曟嵁鐘舵�佸け璐�"); } } @@ -441,35 +494,14 @@ @Transactional public R cancelPakout(String wrkNo, Long userId) { Pakout pakout = pakoutService.selectOne(new EntityWrapper<Pakout>().eq("wrk_no", wrkNo)); -// if (null != pakout) { -// LocDetl locDetl = locDetlService.getLocDetl(pakout.getNodeId(), pakout.getMatnr()); -// if (locDetl == null) { -// LocDetl oldLocDetl = new LocDetl(); -// VersionUtils.setLocDetl(oldLocDetl, pakout); -// oldLocDetl.setCreateTime(new Date()); -// oldLocDetl.setCreateBy(userId); -// oldLocDetl.setUpdateTime(new Date()); -// oldLocDetl.setUpdateBy(userId); -// if (!locDetlService.insert(oldLocDetl)) { -// throw new CoolException("鎭㈠搴撳瓨鏄庣粏澶辫触"); -// } -// } else { -// if (!locDetlService.incrementStock(locDetl.getNodeId(), locDetl.getMatnr(), pakout.getAnfme())) { -// throw new CoolException("鎭㈠搴撳瓨鏄庣粏澶辫触"); -// } -// } -// } else { -// return R.error("鎷h揣鍗曞凡澶辨晥锛屽彇娑堝け璐ワ紒"); -// } if (!pakoutService.delete(new EntityWrapper<Pakout>().eq("wrk_no", pakout.getWrkNo()))) { throw new CoolException("鍒犻櫎鎷h揣鍗曞け璐�"); } - // 鍙栨秷閿�鍞鍗� List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>().eq("doc_num", pakout.getDocNum())); if (Cools.isEmpty(pakouts)){ // 淇敼鍗曟嵁鐘舵�� - if (!custOrderService.updateStatus(pakout.getDocNum(), 3)) { + if (!orderService.updateSettle(pakout.getDocNum(), 3L)) { throw new CoolException("淇敼鍗曟嵁鐘舵�佸け璐�"); } } @@ -486,6 +518,15 @@ Date now = new Date(); Item item = itemService.selectByName(param.getItem()); Cstmr cstmr = cstmrService.selectByName(param.getCstmr()); + // 閲囪喘閫�璐у崟妫�楠� + if (param.getDocType() == 6) { + for (MatnrDto dto : param.getList()) { + if (locDetlService.getStockByDocType34(dto.getMatnr()) < dto.getCount()) { + return R.error(dto.getMatnr() + "閲囪喘閲忎笉瓒充互鐢熸垚閫�璐у崟锛�"); + } + } + } + // 鏂板璁㈠崟琛ㄥご order = new Order( String.valueOf(snowflakeIdWorker.nextId()), // 缂栧彿[闈炵┖] @@ -515,7 +556,7 @@ null, // 鍙戣揣鏃堕棿 null, // 鐗╂祦鍚嶇О null, // 鐗╂祦鍗曞彿 - null, // 璁㈠崟鐘舵�� + 1L, // 璁㈠崟鐘舵�� 1, // 鐘舵�� userId, // 娣诲姞浜哄憳 now, // 娣诲姞鏃堕棿 @@ -523,8 +564,7 @@ now, // 淇敼鏃堕棿 null // 澶囨敞 ); - Integer orderId = orderService.insertReturnId(order); - if (orderId == 0) { + if (!orderService.insert(order)) { throw new CoolException("淇濆瓨璁㈠崟琛ㄥご澶辫触锛�"); } // 閬嶅巻鍟嗗搧鏁伴噺骞朵繚瀛� @@ -535,7 +575,7 @@ continue; } OrderDetl orderDetl = new OrderDetl(); - orderDetl.setOrderId(orderId.longValue()); // 璁㈠崟鍐呯爜 + orderDetl.setOrderId(order.getId()); // 璁㈠崟鍐呯爜 orderDetl.setAnfme(dto.getCount()); // 鏁伴噺 orderDetl.setCreateBy(userId); orderDetl.setCreateTime(now); @@ -548,6 +588,88 @@ } } return R.ok("鍒涘缓璁㈠崟鎴愬姛"); + } + + @Override + public R asrsStockTransfer(AsrsTransferParam param, Long userId) { + if (Cools.isEmpty(param.getNode_id(), param.getMatnr(), param.getSafe_qua(), param.getAmount())) { + return R.error("鏁伴噺閿欒"); + } + Node node = nodeService.selectById(param.getNode_id()); + Mat mat = matService.selectByMatnr(param.getMatnr()); + if (node == null || mat == null) { + return R.error(); + } + double anfme = Arith.subtract(2, param.getSafe_qua(), param.getAmount()); + List<StockTransferParam> params = new ArrayList<>(); + StockTransferParam transferParam = new StockTransferParam(); + transferParam.setMatnr(param.getMatnr()); + transferParam.setAnfme(anfme); + transferParam.setAllotNo(param.getNode_id()+ "_" +param.getMatnr()); + params.add(transferParam); + Result1 result = asrsService.stockTransfer(params); + if (result.getCode() == 500) { + if (Cools.isEmpty(result.getData())) { + throw new CoolException(result.getMsg()); + } else { + throw new CodeCoolException("20001-" + result.getData()); + } + } + // 鐩存帴澧炲姞搴撳瓨 +// LocDetl locDetl = locDetlService.getLocDetl(param.getNode_id(), param.getMatnr()); +// if (locDetl == null) { +// // 鏇存柊璐т綅搴撳瓨鏄庣粏 +// locDetl = new LocDetl(); +// locDetl.setLocNo(node.getName()); +// locDetl.setNodeId(node.getId()); +// locDetl.setAnfme(anfme); +// VersionUtils.setLocDetl(locDetl, mat); +// locDetl.setStatus(1); +// locDetl.setCreateBy(userId); +// locDetl.setCreateTime(new Date()); +// locDetl.setUpdateBy(userId); +// locDetl.setUpdateTime(new Date()); +// boolean insert = locDetlService.insert(locDetl); +// if (!insert) { +// throw new CoolException("鏂板搴撳瓨鏄庣粏妗eけ璐�"); +// } +// } else { +// if (!locDetlService.incrementStock(node.getId(), param.getMatnr(), anfme)) { +// throw new CoolException("鏂板搴撳瓨鏄庣粏妗eけ璐�"); +// } +// } + + return R.ok("琛ヤ粨鎴愬姛锛岀瓑寰呯珛搴撹皟鎷�"); + } + + @Override + public R asrsStockTransferLocMode(AsrsTransferParam param, Long userId) { + if (Cools.isEmpty(param.getNode_id(), param.getMatnr(), param.getSafe_qua(), param.getAmount())) { + return R.error("鏁伴噺閿欒"); + } + Node node = nodeService.selectById(param.getNode_id()); + Mat mat = matService.selectByMatnr(param.getMatnr()); + if (node == null || mat == null) { + return R.error(); + } + double anfme = Arith.subtract(2, param.getSafe_qua(), param.getAmount()); + List<StockTransferParam> params = new ArrayList<>(); + StockTransferParam transferParam = new StockTransferParam(); + transferParam.setMatnr(param.getMatnr()); + transferParam.setAnfme(anfme); + transferParam.setAllotNo(param.getNode_id()+ "_" +param.getMatnr()); + transferParam.setLocNo(param.getLocNo()); + params.add(transferParam); + Result1 result = asrsService.stockTransferLocMode(params); + if (result.getCode() == 500) { + if (Cools.isEmpty(result.getData())) { + throw new CoolException(result.getMsg()); + } else { + throw new CodeCoolException("20001-" + result.getData()); + } + } + + return R.ok("琛ヤ粨鎴愬姛锛岀瓑寰呯珛搴撹皟鎷�"); } @Override @@ -671,7 +793,7 @@ @Transactional public R stockCheckAuditing(Long checkId, Long userId) { Check check = checkService.selectById(checkId); - if (null == check) { + if (null == check || check.getStatus() != 1) { return R.error("鐩樼偣璁板綍宸插け鏁�"); } Date now = new Date(); @@ -723,9 +845,11 @@ String docNum = null; Long docId = null; switch (check.getSettle()) { - case 1: // 鐩樼泩 - docNum = "CS-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); - docId = 14L; // 鎶ユ孩鍗� + case 1: // 鐩樼泩 todo 鍓嶆湡鐢ㄩ噰璐崟涓婃姤 +// docNum = "CS-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); +// docId = 14L; // 鎶ユ孩鍗� + docNum = "PU-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); + docId = 34L; // 閲囪喘鍗� break; case 2: // 鐩樹簭 docNum = "CD-" + String.valueOf(snowflakeIdWorker.nextId()).substring(0, 15); @@ -752,7 +876,6 @@ if (!erpService.uploadBill(dtos, docId.intValue(), docNum)) { throw new CoolException("鏃犳硶涓婃姤鑷砮rp"); } - return R.ok(); } -- Gitblit v1.9.1