| | |
| | | package com.consum.base.service.impl; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | |
| | | import com.consum.base.core.WhBusinessEnum; |
| | | import com.consum.base.core.service.LWhWarningCoreServiceImpl; |
| | | import com.consum.base.core.type.TransferStatesType; |
| | | import com.consum.base.core.utils.IdUtil; |
| | | import com.consum.base.core.utils.LockManage; |
| | | import com.consum.base.service.BaseGoodsTemplateService; |
| | | import com.consum.base.service.GoodsBaseServiceImpl; |
| | | import com.consum.base.service.LGoodsUserRecordServiceImpl; |
| | | import com.consum.base.service.LGoodsWhRecordServiceImpl; |
| | |
| | | import com.consum.base.service.LWhFormTransferService; |
| | | import com.consum.base.service.LWhGoodsRecordService; |
| | | import com.consum.base.service.LWhGoodsService; |
| | | import com.consum.base.service.LWhProcureModelService; |
| | | import com.consum.model.po.LGoodsUserRecord; |
| | | import com.consum.model.po.LWarehouseFlow; |
| | | import com.consum.model.po.LWhFormTransfer; |
| | | import com.consum.model.po.LWhGoodsRecord; |
| | | import com.consum.model.po.LWhGoodsRecordDetails; |
| | | import com.consum.model.po.LWhProcureModel; |
| | | import com.consum.model.po.LWhProcureModelUser; |
| | | import com.iplatform.model.po.S_user_core; |
| | | import com.walker.infrastructure.utils.CollectionUtils; |
| | | import com.walker.infrastructure.utils.DateUtils; |
| | | import com.walker.infrastructure.utils.NumberGenerator; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | |
| | | import cn.hutool.core.convert.Convert; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | |
| | | @Resource |
| | | private LWhFormTransferService lWhFormTransferService; |
| | | @Resource |
| | | private LWhProcureModelService lWhProcureModelService; |
| | | @Resource |
| | | private BaseGoodsTemplateService baseGoodsTemplateService; |
| | | |
| | | @Resource |
| | | private LWhFormOutputCoreService lWhFormOutputCoreService; |
| | | @Resource |
| | |
| | | long dealTime = DateUtils.getDateTimeNumber(System.currentTimeMillis()); |
| | | // 单据类型。0仓库调拨;1部门分发;2部门物品回退 |
| | | Integer businessType = lWhFormTransfer.getBusinessType(); |
| | | businessType = businessType == null ? 0 : businessType; |
| | | WhBusinessEnum businessEnum = WhBusinessEnum.DIAOBO; |
| | | if (businessType == 0) { |
| | | businessEnum = WhBusinessEnum.DIAOBO; |
| | | } else if (businessType == 1) { |
| | | WhBusinessEnum businessEnum; |
| | | if (businessType == 1) { |
| | | businessEnum = WhBusinessEnum.BUMENFENFA; |
| | | } else if (businessType == 2) { |
| | | businessEnum = WhBusinessEnum.BUMENTUIHUI; |
| | | } else { |
| | | businessEnum = WhBusinessEnum.DIAOBO; |
| | | } |
| | | |
| | | // 出库单ID |
| | |
| | | } |
| | | |
| | | /** |
| | | * 新调拨出库 ,不再生成出库单 |
| | | * |
| | | * @param whFormTransferId |
| | | * @param currentUser |
| | | */ |
| | | public Long doTransferOutPutNew(Long whFormTransferId, S_user_core currentUser) { |
| | | LWhFormTransfer lWhFormTransfer = new LWhFormTransfer(whFormTransferId); |
| | | lWhFormTransfer = lWhFormTransferService.get(lWhFormTransfer); |
| | | if (lWhFormTransfer == null || lWhFormTransfer.getStates() != 0) { |
| | | log.error("调拨失败!请检查调拨单状态"); |
| | | return null; |
| | | } |
| | | |
| | | Long userId = currentUser.getId(); |
| | | String nickName = currentUser.getNick_name(); |
| | | long dealTime = DateUtils.getDateTimeNumber(System.currentTimeMillis()); |
| | | // 申请调拨的物品 |
| | | List<LWhProcureModel> goodsModelNumList = |
| | | lWhProcureModelService.getModelByForm(WhBusinessEnum.DIAOBO, whFormTransferId); |
| | | if (CollectionUtils.isEmpty(goodsModelNumList)) { |
| | | log.error("没有要出库的物品"); |
| | | return null; |
| | | } |
| | | List<LWhProcureModel> goodsModelNumUpdList = new ArrayList<>(goodsModelNumList.size()); |
| | | |
| | | // 要出物品的仓库id |
| | | Integer outWarehouseType = lWhFormTransfer.getOutWarehouseType(); |
| | | Long outWarehouseId = lWhFormTransfer.getOutWarehouseId(); |
| | | String warehouseName = lWhFormTransfer.getOutWarehouseName(); |
| | | Integer inWarehouseType = lWhFormTransfer.getInWarehouseType(); |
| | | Long inWarehouseId = lWhFormTransfer.getInWarehouseId(); |
| | | String inWarehouseName = lWhFormTransfer.getInWarehouseName(); |
| | | |
| | | // 流水记录总表ID |
| | | long lWarehouseFlowId = NumberGenerator.getLongSequenceNumberNano(); |
| | | // 流水记录总表中 业务ID 。调拨单时 保存调拨单id 出库单时 保存出库单id |
| | | long lWarehouseFlowBusinessId = whFormTransferId; |
| | | |
| | | // 物品状态(0=在途调拨;1=入库未分发;2=已下发;3=报废) |
| | | Integer queryModelStatusT = 1; |
| | | // 采购方式(1:集采;2=自采) |
| | | Integer buyTypeT = null; |
| | | Integer modGoodsTransferingStatusT = null; |
| | | // 调拨出库 |
| | | queryModelStatusT = 1; |
| | | buyTypeT = 1; |
| | | modGoodsTransferingStatusT = 0; |
| | | |
| | | Integer queryModelStatus = queryModelStatusT; |
| | | Integer buyType = buyTypeT; |
| | | Integer modGoodsTransferingStatus = modGoodsTransferingStatusT; |
| | | |
| | | ArrayList<Long> allChangModelList = new ArrayList<>(); |
| | | goodsModelNumList.forEach(itemModelInfo -> { |
| | | // 需要调拨的物品的某个型号 |
| | | Long baseGoodsModelsId = itemModelInfo.getBaseGoodsModelsId(); |
| | | LWhProcureModel updWhProcureModel = new LWhProcureModel(itemModelInfo.getId()); |
| | | // TODO 为空时不加入更新列表 |
| | | if (baseGoodsModelsId != null) { |
| | | allChangModelList.add(baseGoodsModelsId); |
| | | } |
| | | // 需要调拨的物品某个型号的数量 |
| | | Integer counts = itemModelInfo.getCounts(); |
| | | // 查询型号信息 |
| | | Map<String, Object> tempGoodsInfo = baseGoodsTemplateService.queryGoodsInfoByModelId(baseGoodsModelsId); |
| | | Long tempGoodsId = (Long)tempGoodsInfo.get("goodsid"); |
| | | String goodsName = (String)tempGoodsInfo.get("goodsname"); |
| | | String modelName = (String)tempGoodsInfo.get("modelname"); |
| | | |
| | | // 插入 各规格物品的进出库记录 L_WH_GOODS_RECORD |
| | | long whGoodsRecordId = NumberGenerator.getLongSequenceNumberNano(); |
| | | LWhGoodsRecord whGoodsRecord = new LWhGoodsRecord(); |
| | | whGoodsRecord.setId(whGoodsRecordId); |
| | | whGoodsRecord.setWarehouseId(outWarehouseId); |
| | | whGoodsRecord.setWarehouseFlowId(lWarehouseFlowId); |
| | | whGoodsRecord.setBaseGoodsTemplateId(tempGoodsId); |
| | | whGoodsRecord.setGoodsTemplateName(goodsName); |
| | | whGoodsRecord.setBaseGoodsModelsId(baseGoodsModelsId); |
| | | whGoodsRecord.setBaseGoodsModelsName(modelName); |
| | | whGoodsRecord.setDealTime(dealTime); |
| | | // 本次调整类型 1=调增;2=调减 |
| | | whGoodsRecord.setThisType(2); |
| | | whGoodsRecord.setThisCount(counts); |
| | | |
| | | // 通过LockManage获得锁 |
| | | Object warehouseModelLockObj = LockManage.acquireLock(outWarehouseType, outWarehouseId, baseGoodsModelsId); |
| | | List<Long> outGoodsId = null; |
| | | synchronized (warehouseModelLockObj) { |
| | | // 获得锁后查询该型号的期初数量 |
| | | List<Long> warehouseIds = new ArrayList<>(Arrays.asList(outWarehouseId)); |
| | | int goodsModelNum = lWhGoodsService.queryGoodsModelNum(outWarehouseType, warehouseIds, |
| | | baseGoodsModelsId, queryModelStatus, buyType); |
| | | if (goodsModelNum < counts) { |
| | | log.error("出库失败!型号{} 的数量不足,需要调拨{}个,仓库中现存{}个", baseGoodsModelsId, counts, goodsModelNum); |
| | | // 手动回滚 |
| | | TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); |
| | | throw new RuntimeException("出库失败!型号数量不足"); |
| | | } |
| | | whGoodsRecord.setInitialCount(goodsModelNum); |
| | | whGoodsRecord.setEndCount(goodsModelNum - counts); |
| | | |
| | | // 出库时候,按 先入库的先出库,同时入库的,按价格高的先出库 |
| | | outGoodsId = lWhGoodsService.queryOutGoodsId(outWarehouseType, outWarehouseId, baseGoodsModelsId, |
| | | queryModelStatus, buyType, counts); |
| | | lWhGoodsService.modGoodsTransfering(outGoodsId, inWarehouseType, inWarehouseId, inWarehouseName, |
| | | modGoodsTransferingStatus); |
| | | // 批量插入 进出库流水明细[L_WH_GOODS_RECORD_DETAILS] |
| | | lWhGoodsRecordDetailsService.sameGoodsInsertMore(outGoodsId, whGoodsRecordId, (short)0); |
| | | } |
| | | long totalAmount = lWhGoodsService.queryGoodsPriceById(outGoodsId); |
| | | LWhProcureModel lWhProcureModel = new LWhProcureModel(itemModelInfo.getId()); |
| | | whGoodsRecord.setTotalPrice(totalAmount); |
| | | lWhGoodsRecordServiceImpl.insert(whGoodsRecord); |
| | | lWhProcureModel.setTotalAmount(totalAmount); |
| | | lWhProcureModelService.update(lWhProcureModel); |
| | | updWhProcureModel.setTotalAmount(totalAmount); |
| | | goodsModelNumUpdList.add(updWhProcureModel); |
| | | }); |
| | | // 更新L_WH_PROCURE_MODEL表内金额 |
| | | lWhProcureModelService.updateBatch(goodsModelNumUpdList); |
| | | |
| | | LWarehouseFlow warehouseFlow = new LWarehouseFlow(); |
| | | warehouseFlow.setId(lWarehouseFlowId); |
| | | warehouseFlow.setWarehouseId(outWarehouseId); |
| | | warehouseFlow.setWarehouseName(warehouseName); |
| | | warehouseFlow.setThisType(2); |
| | | warehouseFlow.setBusinessType(WhBusinessEnum.DIAOBO.getValue() + 0); |
| | | |
| | | warehouseFlow.setBusinessFormId(whFormTransferId == null ? lWarehouseFlowBusinessId : whFormTransferId); |
| | | warehouseFlow.setOperatorId(userId); |
| | | warehouseFlow.setOperatorName(nickName); |
| | | warehouseFlow.setDealTime(dealTime); |
| | | // 插入流水总表 |
| | | int flowInsertFlag = lWarehouseFlowService.insert(warehouseFlow); |
| | | if (flowInsertFlag == 0) { |
| | | return null; |
| | | } |
| | | |
| | | // 当库存变动时调用该方法 |
| | | if (outWarehouseType == 0) { |
| | | lWhWarningCoreService.updateKuCun(Convert.toShort(outWarehouseType, (short)0), outWarehouseId, |
| | | allChangModelList, null, dealTime); |
| | | } |
| | | |
| | | // 更新调拨单 |
| | | lWhFormTransfer = new LWhFormTransfer(whFormTransferId); |
| | | // 调拨单不再关联出入库单 |
| | | // lWhFormTransfer.setOutWarehouseFormId(outWarehouseFormId); |
| | | lWhFormTransfer.setStates(TransferStatesType.RECEIVE_ING.getValue()); |
| | | lWhFormTransfer.setOutOperatorId(userId); |
| | | lWhFormTransfer.setOutOperatorName(nickName); |
| | | lWhFormTransfer.setOutputTime(dealTime); |
| | | lWhFormTransfer.setOutWarehouseFlowId(lWarehouseFlowId); |
| | | lWhFormTransferService.update(lWhFormTransfer); |
| | | |
| | | log.info("调拨单:{} 出库完成", whFormTransferId); |
| | | return lWarehouseFlowId; |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 调拨单入库 |
| | | * |
| | | * @param whFormTransferId |
| | | * @param currentUser |
| | | */ |
| | | public void doTransferInPut(Long whFormTransferId, S_user_core currentUser) { |
| | | public void doTransferInPut(Long whFormTransferId, S_user_core currentUser, String inOperatorName) { |
| | | LWhFormTransfer lWhFormTransfer = new LWhFormTransfer(whFormTransferId); |
| | | lWhFormTransfer = lWhFormTransferService.get(lWhFormTransfer); |
| | | if (lWhFormTransfer == null || lWhFormTransfer.getStates() != 1) { |
| | |
| | | TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); |
| | | throw new RuntimeException("入库单失败,未查询到物品!"); |
| | | } |
| | | // 获得锁后查询该型号的期初数量 |
| | | List<Long> warehouseIds = new ArrayList<>(Arrays.asList(inWarehouseId)); |
| | | int goodsModelNum = |
| | | lWhGoodsService.queryGoodsModelNum(inWarehouseType, warehouseIds, baseGoodsModelsId, 1, null); |
| | | |
| | | // 库存物品详情(L_WH_GOODS)中 状态设置为1 |
| | | lWhGoodsService.modGoodsTransfering(outGoodsIds, inWarehouseType, inWarehouseId, inWarehouseName, |
| | | goodsStatus); |
| | | |
| | | // 通过物品id查询所有商品的总金额 |
| | | // long amount = lWhGoodsService.queryGoodsPriceById(outGoodsIds); |
| | | // LWhProcureModel lWhFormScrappedGoods = new LWhProcureModel(formScrappedGood.getId()); |
| | | // lWhFormScrappedGoods.setTotalAmount(amount); |
| | | // lWhFormTransferService.update(lWhFormScrappedGoods); |
| | | |
| | | // 获得锁后查询该型号的期初数量 |
| | | int goodsModelNum = |
| | | lWhGoodsService.queryGoodsModelNum(inWarehouseType, inWarehouseId, baseGoodsModelsId, 1, null); |
| | | whGoodsRecord.setInitialCount(goodsModelNum); |
| | | whGoodsRecord.setEndCount(goodsModelNum + whGoodsRecord.getThisCount()); |
| | | long totalAmount = lWhGoodsService.queryGoodsPriceById(outGoodsIds); |
| | |
| | | lWhFormTransfer = new LWhFormTransfer(whFormTransferId); |
| | | lWhFormTransfer.setInWarehouseFlowId(inWarehouseFlowId); |
| | | lWhFormTransfer.setInWarehouseFormId(null); |
| | | lWhFormTransfer.setStates(2); |
| | | lWhFormTransfer.setInOperatorId(userId); |
| | | lWhFormTransfer.setInOperatorName(nickName); |
| | | lWhFormTransfer.setStates(TransferStatesType.SUCCESS.getValue()); |
| | | if (StringUtils.isEmpty(inOperatorName)) { |
| | | lWhFormTransfer.setInOperatorId(userId); |
| | | lWhFormTransfer.setInOperatorName(nickName); |
| | | } else { |
| | | lWhFormTransfer.setInOperatorName(inOperatorName); |
| | | } |
| | | |
| | | lWhFormTransfer.setInTime(dealTime); |
| | | lWhFormTransferService.update(lWhFormTransfer); |
| | | |