From 5264cf0915ee9901cb9520fdcc6b8cdd5ecd4837 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期三, 20 八月 2025 10:50:03 +0800 Subject: [PATCH] 库存调整功能界面优化 库存调整接口功能开发 --- rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java | 498 ++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 471 insertions(+), 27 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java index 36895d4..de0ec9c 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReceiveMsgServiceImpl.java @@ -2,19 +2,29 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.vincent.rsf.framework.common.R; import com.vincent.rsf.framework.exception.CoolException; -import com.vincent.rsf.server.api.entity.enums.OrderType; -import com.vincent.rsf.server.manager.entity.PurchaseItem; -import com.vincent.rsf.server.manager.service.PurchaseItemService; -import com.vincent.rsf.server.manager.service.PurchaseService; +import com.vincent.rsf.server.api.controller.erp.params.*; +import com.vincent.rsf.server.common.domain.BaseParam; +import com.vincent.rsf.server.common.domain.PageParam; +import com.vincent.rsf.server.manager.controller.dto.LocStockDto; +import com.vincent.rsf.server.manager.entity.*; +import com.vincent.rsf.server.manager.enums.CompanysType; +import com.vincent.rsf.server.manager.enums.OrderSourceType; +import com.vincent.rsf.server.manager.enums.OrderType; +import com.vincent.rsf.server.manager.enums.OrderWorkType; +import com.vincent.rsf.server.manager.service.*; +import com.vincent.rsf.server.manager.service.impl.MatnrServiceImpl; +import com.vincent.rsf.server.manager.service.impl.TransferItemServiceImpl; import com.vincent.rsf.server.system.constant.SerialRuleCode; -import com.vincent.rsf.server.api.controller.params.OrderParams; import com.vincent.rsf.server.system.entity.Fields; import com.vincent.rsf.server.system.service.FieldsItemService; import com.vincent.rsf.server.system.service.FieldsService; import com.vincent.rsf.server.system.utils.SerialRuleUtils; import com.vincent.rsf.server.api.service.ReceiveMsgService; -import com.vincent.rsf.server.manager.entity.Purchase; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; @@ -22,6 +32,7 @@ import org.springframework.transaction.annotation.Transactional; import java.util.*; +import java.util.stream.Collectors; /** * @author Ryan @@ -42,7 +53,46 @@ private FieldsService fieldsService; @Autowired private FieldsItemService fieldsItemService; + @Autowired + private MatnrGroupService matnrGroupService; + @Autowired + private MatnrServiceImpl matnrService; + @Autowired + private AsnOrderService asnOrderService; + @Autowired + private AsnOrderItemService asnOrderItemService; + @Autowired + private DeliveryService deliveryService; + @Autowired + private DeliveryItemService deliveryItemService; + @Autowired + private LocService locService; + @Autowired + private LocItemService locItemService; + @Autowired + private WarehouseAreasService warehouseAreasService; + @Autowired + private WarehouseService warehouseService; + @Autowired + private CompanysService companysService; + @Autowired + private TransferService transferService; + @Autowired + private TransferItemService transferItemService; + @Autowired + private LocReviseService locReviseService; + @Autowired + private ReviseLogService reviseLogService; + @Autowired + private ReviseLogItemService reviseLogItemService; + + /** + * @author Ryan + * @date 2025/8/15 + * @description: 淇濆瓨PO/DO鍗曟嵁 + * @version 1.0 + */ @Override @Transactional(rollbackFor = Exception.class) public boolean syncPurchasee(List<OrderParams> orders) { @@ -50,35 +100,69 @@ throw new CoolException("鍗曟嵁鍐呭涓嶈兘涓虹┖锛侊紒"); } orders.forEach(ors -> { - Purchase purchase = new Purchase(); - BeanUtils.copyProperties(ors, purchase); - String wkVal = SerialRuleUtils.generateRuleCode(SerialRuleCode.PURCHASE_CODE, purchase); - purchase.setCode(wkVal) - .setType(OrderType.ORDER_PURCHASE_IN.type); - if (!purchaseService.save(purchase)) { - throw new CoolException("閲囪喘鍗曟嵁淇濆瓨澶辫触"); - } + if (ors.getType().equals("po")) { + Purchase purchase = new Purchase(); + BeanUtils.copyProperties(ors, purchase); + String wkVal = SerialRuleUtils.generateRuleCode(SerialRuleCode.PURCHASE_CODE, purchase); + purchase.setCode(wkVal) + .setType(OrderType.ORDER_IN.type); + if (!purchaseService.save(purchase)) { + throw new CoolException("閲囪喘鍗曟嵁淇濆瓨澶辫触"); + } - //鏌ヨ鎵╁睍瀛楁鏄惁瀛樺湪 - List<Fields> fields = fieldsService.list(new LambdaQueryWrapper<Fields>().eq(Fields::getStatus, 1).eq(Fields::getFlagEnable, 1)); + //鏌ヨ鎵╁睍瀛楁鏄惁瀛樺湪 + List<Fields> fields = fieldsService.list(new LambdaQueryWrapper<Fields>().eq(Fields::getStatus, 1).eq(Fields::getFlagEnable, 1)); - //鍒ゆ柇瀛愬垪琛ㄤ笉涓虹┖ - if (!ors.getChildren().isEmpty()) { - ArrayList<PurchaseItem> list = new ArrayList<>(); - ors.getChildren().forEach(orderItem -> { - PurchaseItem item = new PurchaseItem(); - BeanUtils.copyProperties(orderItem, item); + //鍒ゆ柇瀛愬垪琛ㄤ笉涓虹┖ + if (!ors.getChildren().isEmpty()) { + ArrayList<PurchaseItem> list = new ArrayList<>(); + ors.getChildren().forEach(orderItem -> { + PurchaseItem item = new PurchaseItem(); + BeanUtils.copyProperties(orderItem, item); // if (!fields.isEmpty()) { // List<String> fieldValue = fields.stream().map(Fields::getFields).collect(Collectors.toList()); // fieldValue.forEach(value -> { // // }); // } - item.setPurchaseId(purchase.getId()); - list.add(item); - }); - if (!purchaseItemService.saveBatch(list)) { - throw new CoolException("閲囪喘鍗曟槑缁嗕繚瀛樺け璐ワ紒锛�"); + item.setPurchaseId(purchase.getId()); + list.add(item); + }); + if (!purchaseItemService.saveBatch(list)) { + throw new CoolException("閲囪喘鍗曟槑缁嗕繚瀛樺け璐ワ紒锛�"); + } + } + } else { + Delivery delivery = new Delivery(); + BeanUtils.copyProperties(ors, delivery); + String wkVal = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_DELIVERY_RULE_CODE, delivery); + delivery.setCode(wkVal) + .setType(OrderType.ORDER_OUT.type); + if (!deliveryService.save(delivery)) { + throw new CoolException("閲囪喘鍗曟嵁淇濆瓨澶辫触"); + } + + //鏌ヨ鎵╁睍瀛楁鏄惁瀛樺湪 + List<Fields> fields = fieldsService.list(new LambdaQueryWrapper<Fields>().eq(Fields::getStatus, 1).eq(Fields::getFlagEnable, 1)); + + //鍒ゆ柇瀛愬垪琛ㄤ笉涓虹┖ + if (!ors.getChildren().isEmpty()) { + ArrayList<DeliveryItem> list = new ArrayList<>(); + ors.getChildren().forEach(orderItem -> { + DeliveryItem item = new DeliveryItem(); + BeanUtils.copyProperties(orderItem, item); +// if (!fields.isEmpty()) { +// List<String> fieldValue = fields.stream().map(Fields::getFields).collect(Collectors.toList()); +// fieldValue.forEach(value -> { +// +// }); +// } + item.setDeliveryId(delivery.getId()); + list.add(item); + }); + if (!deliveryItemService.saveBatch(list)) { + throw new CoolException("閲囪喘鍗曟槑缁嗕繚瀛樺け璐ワ紒锛�"); + } } } }); @@ -86,6 +170,366 @@ return true; } + /** + * 鐗╂枡淇℃伅鍚屾 + * + * @param matnrs + */ + @Override + public void syncMatnrs(List<BaseMatParms> matnrs) { + List<Matnr> syncMatnrs = new ArrayList<>(); + if (!matnrs.isEmpty()) { + matnrs.forEach(matnr -> { + Matnr mat = new Matnr(); + if (Objects.isNull(matnr.getMatnr())) { + throw new RuntimeException("鐗╂枡缂栫爜涓嶈兘涓虹┖锛侊紒"); + } + BeanUtils.copyProperties(matnr, mat); + mat.setCode(matnr.getMatnr()).setName(matnr.getMaktx()); + if (!Objects.isNull(matnr.getGroupName())) { + MatnrGroup matnrGroup = matnrGroupService.getOne(new LambdaQueryWrapper<MatnrGroup>().eq(MatnrGroup::getName, matnr.getGroupName()), false); + if (Objects.isNull(matnrGroup)) { + mat.setGroupCode(matnrGroup.getCode()).setGroupId(matnrGroup.getId()); + } + } + syncMatnrs.add(mat); + }); + if (!matnrService.saveOrUpdateBatch(syncMatnrs)) { + throw new CoolException("鐗╂枡淇℃伅淇濆瓨鎴愬姛锛侊紒"); + } + } + } + + /** + * @author Ryan + * @date 2025/8/15 + * @description: 璁㈠崟鏌ヨ + * @version 1.0 + */ + @Override + public R queryOrderStatus(QueryOrderParam queryParams) { + WkOrder wkOrders = asnOrderService.getOne(new LambdaQueryWrapper<WkOrder>() + .eq(WkOrder::getCode, queryParams.getOrderNo()) + .eq(WkOrder::getType, queryParams.getType())); + if (Objects.isNull(wkOrders)) { + throw new CoolException("鍗曟嵁涓嶅瓨鍦紒锛�"); + } + List<WkOrderItem> orderItems = asnOrderItemService.list(new LambdaQueryWrapper<WkOrderItem>().eq(WkOrderItem::getOrderId, wkOrders.getId())); + + WkOrderDto wkorderDto = new WkOrderDto(); + wkorderDto.setOrder(wkOrders).setOrderItems(orderItems); + + return R.ok().add(wkorderDto); + } + + /** + * @author Ryan + * @date 2025/8/15 + * @description: 鏌ヨ搴撲綅淇℃伅 + * @version 1.0 + */ + @Override + public R syncLocsDetl(PageParam<Loc, BaseParam> pageParam, QueryWrapper<Loc> wrapper) { + Page<Object> page = new Page<>(); + page.setCurrent(pageParam.getCurrent()).setSize(pageParam.getSize()); + IPage<LocStockDto> locStocks = locService.getLocDetls(page); + return R.ok().add(locStocks); + } + + /** + * @author Ryan + * @date 2025/8/18 + * @description: 搴撲綅鍚屾 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncLocs(List<SyncLocsParams> locs) { + List<Loc> syncLocs = new ArrayList<>(); + locs.forEach(loc -> { + Loc loc1 = new Loc(); + BeanUtils.copyProperties(loc, loc1); + loc1.setCode(loc.getLocCode()).setId(null); + syncLocs.add(loc1); + }); + if (!locService.saveBatch(syncLocs)) { + throw new CoolException("搴撲綅鍚屾澶辫触锛侊紒"); + } + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/18 + * @description: 鐗╂枡淇℃伅鍚屾 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncMatGroups(List<SyncMatGroupsParams> matGroupsParams) { + List<MatnrGroup> syncMatGroups = new ArrayList<>(); + matGroupsParams.forEach(matGroupsParam -> { + MatnrGroup matnrGroup = new MatnrGroup(); + BeanUtils.copyProperties(matGroupsParam, matnrGroup); + if (Objects.isNull(matGroupsParam.getCode())) { + throw new CoolException("鐗╂枡鍒嗙粍缂栫爜涓嶈兘涓虹┖锛侊紒"); + } + if (Objects.isNull(matGroupsParam.getName())) { + throw new CoolException("鍒嗙粍鍚嶇О涓嶈兘涓虹┖锛侊紒"); + } + if (Objects.isNull(matGroupsParam.getParCode())) { + throw new CoolException("涓婄骇鐗╂枡鍒嗙粍缂栫爜涓嶈兘涓虹┖锛侊紒"); + } + syncMatGroups.add(matnrGroup); + }); + if (!matnrGroupService.saveBatch(syncMatGroups)) { + throw new CoolException("鐗╂枡鍒嗙粍淇濆瓨澶辫触锛侊紒"); + } + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/18 + * @description: 搴撳尯淇℃伅鍚屾 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncWarehouseAreas(List<LocAreasParams> areasParams) { + areasParams.forEach(param -> { + WarehouseAreas locArea = new WarehouseAreas(); + BeanUtils.copyProperties(param, locArea); + WarehouseAreas warehouseAreas = warehouseAreasService + .getOne(new LambdaQueryWrapper<WarehouseAreas>() + .eq(WarehouseAreas::getName, param.getName())); + if (!Objects.isNull(warehouseAreas)) { + locArea.setWarehouseId(warehouseAreas.getId()); + } + locArea.setName(param.getName()) + .setCode(param.getCode()) + .setId(null); + if (!warehouseAreasService.save(locArea)) { + throw new CoolException("搴撳尯淇濆瓨澶辫触锛侊紒"); + } + }); + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/18 + * @description: 浠撳簱鍚屾 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncWarehouse(List<WarehouseParams> warehouses) { + warehouses.forEach(warehouse -> { + Warehouse ware = new Warehouse(); + BeanUtils.copyProperties(warehouse, ware); + ware.setId(null); + if (!warehouseService.save(ware)) { + throw new CoolException("浠撳簱鍚屾淇濆瓨澶辫触锛侊紒"); + } + }); + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/19 + * @description: 鍚屾浼佷笟淇℃伅 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncCompanies(List<CompaniesParam> companyParams) { + companyParams.forEach(param -> { + Companys companys = new Companys(); + BeanUtils.copyProperties(param, companys); + if (Objects.isNull(companys.getCode())) { + throw new CoolException("浼佷笟缂栫爜涓嶈兘涓虹┖锛侊紒"); + } + Companys one = companysService.getOne(new LambdaQueryWrapper<Companys>().eq(Companys::getName, param.getName())); + if (Objects.isNull(one)) { + String ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_COMPANYS_CODE, null); + companys.setCode(ruleCode); + } else { + throw new CoolException(one.getName() + "锛屼紒涓氬悕閲嶅锛侊紒"); + } + companys.setType(CompanysType.getCustomVal(param.getType())) + .setId(null); + if (!companysService.save(companys)) { + throw new CoolException("浼佷笟淇濆瓨澶辫触锛侊紒"); + } + }); + return R.ok(); + } + + + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncCheckOrder(SyncOrderParams syncOrders, Long loginUserId) { + List<SyncOrdersItem> ordersItems = syncOrders.getItems(); + Map<String, List<SyncOrdersItem>> listMap = ordersItems.stream().collect(Collectors.groupingBy(SyncOrdersItem::getOrderCode)); + listMap.keySet().forEach(orderCode -> { + WkOrder wkOrder = new WkOrder(); + String ruleCode = null; + if (syncOrders.getType().equals(OrderType.ORDER_CHECK.type)) { + ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_CHECK_RULE_CODE, null); + } else if (syncOrders.getType().equals(OrderType.ORDER_IN.type)) { + ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_ASN_ORDER, null); + } else if (syncOrders.getType().equals(OrderType.ORDER_OUT.type)) { + ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_OUT_STOCK_CODE, null); + } else if (syncOrders.getType().equals(OrderType.ORDER_REVISE.type)) { + ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_LOC_REVISE_CODE, null); + } else if (syncOrders.getType().equals(OrderType.ORDER_TRANSFER.type)) { + ruleCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_TRANSFER_ORDER_CODE, null); + } + + SyncOrdersItem ordersItem = listMap.get(orderCode).stream().findFirst().get(); + Double anfmes = listMap.get(orderCode).stream().mapToDouble(SyncOrdersItem::getAnfme).sum(); + wkOrder.setType(syncOrders.getType()) + .setWkType(OrderWorkType.getWorkType(ordersItem.getWkType())) + .setAnfme(anfmes) + .setPoCode(orderCode) + .setPoId(ordersItem.getId()) + .setCode(ruleCode) + .setId(null) + .setCreateTime(new Date()) + .setUpdateTime(new Date()) + .setCreateBy(loginUserId) + .setUpdateBy(loginUserId); + + if (!asnOrderService.save(wkOrder)) { + throw new CoolException("鍗曟嵁淇濆瓨澶辫触锛侊紒"); + } + + listMap.get(orderCode).forEach(order -> { + WkOrderItem wkOrderItem = new WkOrderItem(); + BeanUtils.copyProperties(order, wkOrderItem); + wkOrderItem.setOrderCode(wkOrder.getCode()) + .setOrderId(wkOrder.getId()) + .setId(null); + + if (!asnOrderItemService.save(wkOrderItem)) { + throw new CoolException("鍗曟嵁鏄庣粏淇濆瓨澶辫触锛侊紒"); + } + }); + }); + + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/19 + * @description: 璋冩嫈鍗曟嵁鍚屾 + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncTransfer(SyncTransferParams transferParams) { + Transfer transfer = new Transfer(); + WarehouseAreas warehouseAreas = warehouseAreasService + .getOne(new LambdaQueryWrapper<WarehouseAreas>() + .eq(WarehouseAreas::getName, transfer.getOrgAreaName())); + if (Objects.isNull(warehouseAreas)) { + throw new CoolException("鍘熷簱鍖轰笉瀛樺湪锛侊紒"); + } + + WarehouseAreas warehouseAreas1 = warehouseAreasService.getOne(new LambdaQueryWrapper<WarehouseAreas>() + .eq(WarehouseAreas::getName, transfer.getTarAreaName())); + if (Objects.isNull(warehouseAreas1)) { + throw new CoolException("鐩爣搴撳尯涓嶅瓨鍦紒锛�"); + } + + transfer.setOrgAreaName(warehouseAreas.getName()) + .setOrgAreaId(warehouseAreas.getId()) + .setOrgWareName(warehouseAreas.getWarehouseId$()) + .setOrgWareId(warehouseAreas.getWarehouseId()) + .setTarWareName(warehouseAreas1.getWarehouseId$()) + .setTarAreaName(warehouseAreas1.getName()) + .setTarAreaId(warehouseAreas1.getId()) + .setTarWareName(warehouseAreas1.getWarehouseId$()) + .setTarWareId(warehouseAreas1.getWarehouseId()) + .setSource(OrderSourceType.ORDER_SOURCE_TYPE_ERP.val); + + if (!transferService.save(transfer)) { + throw new CoolException("璋冩嫈鍗曟嵁淇濆瓨澶辫触锛侊紒"); + } + + transferParams.getItems().forEach(item -> { + TransferItem transferItem = new TransferItem(); + BeanUtils.copyProperties(item, transferItem); + Matnr matnr = matnrService.getOne(new LambdaQueryWrapper<Matnr>().eq(Matnr::getCode, item.getMatnrCode())); + if (Objects.isNull(matnr)) { + throw new CoolException("鐗╂枡涓嶅瓨鍦紒锛�"); + } + transferItem.setMatnrId(matnr.getId()) + .setTransferId(transfer.getId()) + .setTransferCode(transfer.getCode()); + + if (!transferItemService.save(transferItem)) { + throw new CoolException("璋冩嫈鍗曟槑缁嗕繚瀛樺け璐ワ紒锛�"); + } + }); + + return R.ok(); + } + + /** + * @author Ryan + * @date 2025/8/20 + * @description: 搴撳瓨璋冩暣鍗曞悓姝� + * @version 1.0 + */ + @Override + @Transactional(timeout = 60, rollbackFor = Exception.class) + public R syncLocRevise(SyncLocReviseParams reviseParams) { + LocRevise locRevise = new LocRevise(); + if (Objects.isNull(reviseParams.getAreaName())) { + throw new CoolException("搴撳尯涓嶈兘涓虹┖锛侊紒"); + } + WarehouseAreas warehouseAreas = warehouseAreasService + .getOne(new LambdaQueryWrapper<WarehouseAreas>() + .eq(WarehouseAreas::getName, reviseParams.getAreaName())); + if (Objects.isNull(warehouseAreas)) { + throw new CoolException("搴撳尯涓嶅瓨鍦紒锛�"); + } + locRevise.setAreaName(locRevise.getAreaName()) + .setAreaId(warehouseAreas.getId()); + locRevise.setCode(SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_LOC_REVISE_CODE, null)); + + if (!locReviseService.save(locRevise)) { + throw new CoolException("搴撳瓨璋冩暣鍗曚繚瀛樺け璐ワ紒锛�"); + } + + reviseParams.getItems().forEach(revise -> { + Loc loc = locService.getOne(new LambdaQueryWrapper<Loc>().eq(Loc::getCode, revise.getLocCode())); + ReviseLog reviseLog = new ReviseLog(); + BeanUtils.copyProperties(loc, reviseLog); + reviseLog.setReviseId(locRevise.getId()).setReviseCode(locRevise.getCode()); + if (!reviseLogService.save(reviseLog)) { + throw new CoolException("搴撳瓨璋冩暣鍗曚笉鑳戒负绌猴紒锛�"); + } + revise.getItems().forEach(reviseItem -> { + ReviseLogItem logItem = new ReviseLogItem(); + BeanUtils.copyProperties(reviseItem, logItem); + logItem.setLocId(loc.getId()) + .setLocCode(loc.getCode()) + .setId(null) + .setReviseQty(reviseItem.getAnfme()); + + if (!reviseLogItemService.save(logItem)) { + throw new CoolException("璋冩暣搴撳瓨鏄庣粏淇濆瓨澶辫触锛侊紒"); + } + }); + }); + + return R.ok(); + } } -- Gitblit v1.9.1