package com.consum.base.core;
|
|
import cn.hutool.core.convert.Convert;
|
import com.consum.base.core.service.LWhWarningCoreServiceImpl;
|
import com.consum.base.core.utils.IdUtil;
|
import com.consum.base.core.utils.LockManage;
|
import com.consum.base.service.GoodsBaseServiceImpl;
|
import com.consum.base.service.LWarehouseFlowService;
|
import com.consum.base.service.LWhGoodsRecordService;
|
import com.consum.base.service.LWhGoodsService;
|
import com.consum.base.service.impl.LWhGoodsRecordDetailsService;
|
import com.consum.model.po.BaseWarehouse;
|
import com.consum.model.po.LWarehouseFlow;
|
import com.consum.model.po.LWhGoodsRecord;
|
import com.consum.model.po.UsingFormBack;
|
import com.iplatform.model.po.S_user_core;
|
import com.walker.infrastructure.utils.CollectionUtils;
|
import com.walker.web.ResponseValue;
|
import java.util.Arrays;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Propagation;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.transaction.interceptor.TransactionAspectSupport;
|
|
import javax.annotation.Resource;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* @ClassName DepFormScrappedCoreServiceImpl
|
* @Author cy
|
* @Date 2023/12/2
|
* @Description
|
* @Version 1.0
|
**/
|
@Service
|
@Slf4j
|
@Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
|
public class DepUsingFormBackCoreServiceImpl {
|
@Resource
|
private GoodsBaseServiceImpl goodsBaseService;
|
@Resource
|
private LWhGoodsService lWhGoodsService;
|
@Resource
|
private LWhGoodsRecordDetailsService lWhGoodsRecordDetailsService;
|
@Resource
|
private LWhGoodsRecordService lWhGoodsRecordServiceImpl;
|
@Resource
|
private LWarehouseFlowService lWarehouseFlowService;
|
@Resource
|
private LWhWarningCoreServiceImpl lWhWarningCoreService;
|
|
/**
|
* 根据报废单报废：修改调拨单中可退回数量；仓库中物品状态设置为报废;生成一个保费流水；更新报废型号表中，物品价值
|
* <p>
|
* 1.找到需要退回的型号， 按同一个
|
*
|
* @param lWhFormBackId
|
*/
|
public ResponseValue updateBack(Long lWhFormBackId, S_user_core currentUser, Long dealTime) {
|
// 查询报废单状态
|
UsingFormBack depFormScrapped = new UsingFormBack(lWhFormBackId);
|
depFormScrapped = goodsBaseService.get(depFormScrapped);
|
//状态 1=待报废；2=已报废
|
if (depFormScrapped == null || depFormScrapped.getStates() != 1) {
|
return ResponseValue.error("请检查报废单");
|
}
|
|
Long userId = currentUser.getId();
|
String nickName = currentUser.getNick_name();
|
|
// 根据报废单 查询需要报废的型号数量
|
List<Map<String, Object>> bfModelList = goodsBaseService.select("SELECT scrGoods.TRANS_OUT_WAREHOUSE_TYPE,scrGoods.TRANS_OUT_WAREHOUSE_ID,scrGoods.TRANS_BUSINESS_ID,scrGoods.BUSINESS_FORM_CODE,scrGoods.TRANS_OUT_WAREHOUSE_TYPE,scrGoods.TRANS_OUT_WAREHOUSE_ID,scrGoods.BASE_GOODS_TEMPLATE_ID,scrGoods.BASE_GOODS_TEMPLATE_NAME,goodsModel.id formScrappedModelId,goodsModel.BASE_GOODS_TEMPLATE_ID,goodsModel.BASE_GOODS_MODELS_ID,goodsModel.COUNTS,goodsModel.PROCURE_MODEL_USER_ID,goodsModel.GOODS_USER_NAME,goodsModel.BASE_GOODS_MODELS_NAME FROM USING_FORM_BACK_GOODS scrGoods LEFT JOIN USING_FORM_BACK_MODEL goodsModel ON scrgoods.id=goodsModel.USING_FORM_BACK_GOODS_ID WHERE scrGoods.USING_FORM_BACK_ID=?", new Object[]{lWhFormBackId});
|
Map<Object, List<Map<String, Object>>> groupByModelIdMap = bfModelList.stream()
|
.collect(Collectors.groupingBy(map -> map.get("BASE_GOODS_MODELS_ID")));
|
Integer warehouseType = depFormScrapped.getOutWarehouseType();
|
Long warehouseId = depFormScrapped.getOutWarehouseId();
|
String warehouseName = depFormScrapped.getOutWarehouseName();
|
|
// 流水记录总表ID
|
long lWarehouseFlowId = IdUtil.generateId();
|
|
// 更新 报废单物品【DEP_FORM_SCRAPPED_MODEL】中价格的list
|
Map<Long, Long> modelTotalPriceMap = new HashMap<>();
|
|
ArrayList<LWhGoodsRecord> lWhGoodsRecordList = new ArrayList<>();
|
|
//采购、调拨、出库等的物品型号【L_WH_PROCURE_MODEL】中 根据调拨单+型号 更新 在用数量
|
Map<String, Integer> procureModelMap = new HashMap<>();
|
|
for (Object key : groupByModelIdMap.keySet()) {
|
Long modelTotalPrice = 0L;
|
//要报废的总数量
|
int modelTotalNum = 0;
|
|
Long baseGoodsModelsId = (Long) key;
|
List<Map<String, Object>> eachFfModelList = groupByModelIdMap.get(key);
|
Map<String, Object> eachFfModelBase = eachFfModelList.get(0);
|
Long tempGoodsId = Convert.toLong(eachFfModelBase.get("BASE_GOODS_TEMPLATE_ID"));
|
String goodsName = Convert.toStr(eachFfModelBase.get("BASE_GOODS_TEMPLATE_NAME"));
|
String modelName = Convert.toStr(eachFfModelBase.get("BASE_GOODS_MODELS_NAME"));
|
|
// 插入 各规格物品的进出库记录 L_WH_GOODS_RECORD
|
long whGoodsRecordId = IdUtil.generateId();
|
LWhGoodsRecord whGoodsRecord = new LWhGoodsRecord();
|
whGoodsRecord.setId(whGoodsRecordId);
|
whGoodsRecord.setWarehouseType(warehouseType);
|
whGoodsRecord.setWarehouseId(warehouseId);
|
whGoodsRecord.setWarehouseFlowId(lWarehouseFlowId);
|
whGoodsRecord.setBaseGoodsTemplateId(tempGoodsId);
|
whGoodsRecord.setGoodsTemplateName(goodsName);
|
whGoodsRecord.setBaseGoodsModelsId(baseGoodsModelsId);
|
whGoodsRecord.setBaseGoodsModelsName(modelName);
|
whGoodsRecord.setDealTime(dealTime);
|
//本次调整类型 1=调增；2=调减
|
whGoodsRecord.setThisType(2);
|
|
//通过LockManage获得锁
|
Object warehouseModelLockObj = LockManage.acquireLock(warehouseType, warehouseId, baseGoodsModelsId);
|
int goodsModelNum = 0;
|
synchronized (warehouseModelLockObj) {
|
List<Long> warehouseIds = new ArrayList<>(Arrays.asList(warehouseId));
|
goodsModelNum = lWhGoodsService.queryGoodsModelNum(warehouseType, warehouseIds, baseGoodsModelsId, 2, null);
|
for (Map<String, Object> depFormScrappedModel : eachFfModelList) {
|
// 调拨单信息
|
Long transBusinessId = (Long) depFormScrappedModel.get("TRANS_BUSINESS_ID");
|
String nowUserName = Convert.toStr(depFormScrappedModel.get("GOODS_USER_NAME"));
|
Integer counts = Convert.toInt(depFormScrappedModel.get("COUNTS"));
|
Long formScrappedModelId = Convert.toLong(depFormScrappedModel.get("formScrappedModelId"));
|
|
modelTotalNum += counts;
|
|
// 根据分发单、型号、使用人信息查询物品信息
|
List<Map<String, Object>> scrappedGoodsList = lWhGoodsService.queryScrappedGoods(warehouseType, warehouseId, transBusinessId, nowUserName, baseGoodsModelsId, (short) 2, counts);
|
if (CollectionUtils.isEmpty(scrappedGoodsList) || scrappedGoodsList.size() < counts) {
|
log.error("要退回的物品数量不足！");
|
// 手动回滚
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
throw new RuntimeException("报废失败!型号数量不足");
|
}
|
// 放入物品ID等信息
|
depFormScrappedModel.put("scrappedGoodsList", scrappedGoodsList);
|
|
Long formScrappedModelPrice = scrappedGoodsList.stream().mapToLong(map -> (long) map.get("price")).sum();
|
modelTotalPrice += formScrappedModelPrice;
|
// 更新 报废单物品【DEP_FORM_SCRAPPED_MODEL】中 价格
|
modelTotalPriceMap.put(formScrappedModelId, formScrappedModelPrice);
|
//采购、调拨、出库等的物品型号【L_WH_PROCURE_MODEL】中 在用数量
|
Integer procureModelNum = Convert.toInt(procureModelMap.get(transBusinessId + "_" + baseGoodsModelsId), 0);
|
procureModelMap.put(transBusinessId + "_" + baseGoodsModelsId, counts + procureModelNum);
|
|
// 汇总出需要修改状态的物品id
|
List<Long> srappedGoodsIds = scrappedGoodsList.stream().map(map -> (Long) map.get("id")).collect(Collectors.toList());
|
|
// 设置物品为报废状态
|
// lWhGoodsService.modGoodsTransfering(srappedGoodsIds, null, null, null, 3);
|
// 批量插入 进出库流水明细[L_WH_GOODS_RECORD_DETAILS]
|
lWhGoodsRecordDetailsService.sameGoodsInsertMore(srappedGoodsIds, whGoodsRecordId, (short) 2);
|
}
|
}
|
|
whGoodsRecord.setInitialCount(goodsModelNum);
|
whGoodsRecord.setEndCount(goodsModelNum - modelTotalNum);
|
whGoodsRecord.setThisCount(modelTotalNum);
|
whGoodsRecord.setTotalPrice(modelTotalPrice);
|
// lWhGoodsRecordService.insert(whGoodsRecord);
|
lWhGoodsRecordList.add(whGoodsRecord);
|
}
|
|
// 插入总流水
|
LWarehouseFlow warehouseFlow = new LWarehouseFlow();
|
warehouseFlow.setId(lWarehouseFlowId);
|
warehouseFlow.setWarehouseType(warehouseType);
|
warehouseFlow.setWarehouseId(warehouseId);
|
warehouseFlow.setWarehouseName(warehouseName);
|
warehouseFlow.setThisType(2);
|
warehouseFlow.setBusinessType(WhBusinessEnum.BUMENTUIHUI.getValue() + 0);
|
warehouseFlow.setBusinessFormId(lWhFormBackId);
|
warehouseFlow.setOperatorId(userId);
|
warehouseFlow.setOperatorName(nickName);
|
warehouseFlow.setDealTime(dealTime);
|
// 插入流水总表
|
int flowInsertFlag = lWarehouseFlowService.insert(warehouseFlow);
|
if (flowInsertFlag == 0) {
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
return null;
|
}
|
// 批量插入 各规格物品的进出库【L_WH_GOODS_RECORD】
|
lWhGoodsRecordServiceImpl.insertBatch(lWhGoodsRecordList);
|
|
// 更新报废单
|
depFormScrapped = new UsingFormBack(lWhFormBackId);
|
depFormScrapped.setStates(2);
|
goodsBaseService.update(depFormScrapped);
|
|
// 更新 报废单物品【DEP_FORM_SCRAPPED_MODEL】中价格的list
|
List<Object[]> parameterList = new ArrayList<>();
|
for (Map.Entry<Long, Long> entry : modelTotalPriceMap.entrySet()) {
|
Long key = entry.getKey();
|
Long value = entry.getValue();
|
Object[] one = new Object[2];
|
one[0] = value;
|
one[1] = key;
|
parameterList.add(one);
|
}
|
goodsBaseService.execBatchUpdate("update DEP_FORM_SCRAPPED_MODEL set TOTAL_AMOUNT=? where id=?", parameterList);
|
|
//如果是A类物品，则更新 分发物品使用人【L_WH_PROCURE_MODEL_USER】 中 根据id 更新 在用数量(USE_COUNT)
|
List<Object[]> procureModelUserIdList = new ArrayList<>();
|
for (Map<String, Object> itemMap : bfModelList) {
|
Long procureModelUserId = Convert.toLong(itemMap.get("PROCURE_MODEL_USER_ID"));
|
if (procureModelUserId==null){
|
continue;
|
}
|
Integer counts = Convert.toInt(itemMap.get("COUNTS"));
|
|
// StringBuilder sb = new StringBuilder("update L_WH_PROCURE_MODEL_USER set USE_COUNT=USE_COUNT-").append(counts);
|
// sb.append(" where id=").append(procureModelUserId);
|
// sb.append(" and USE_COUNT-").append(counts).append(" >=0");
|
// goodsBaseService.update(sb.toString());
|
|
Object[] one = new Object[3];
|
one[0] = counts;
|
one[1] = procureModelUserId;
|
one[2] = counts;
|
procureModelUserIdList.add(one);
|
}
|
if (!CollectionUtils.isEmpty(procureModelUserIdList)) {
|
goodsBaseService.execBatchUpdate("update L_WH_PROCURE_MODEL_USER set USE_COUNT=USE_COUNT- ? where id= ? and USE_COUNT- ? >=0", procureModelUserIdList);
|
}
|
|
|
//采购、调拨、出库等的物品型号【L_WH_PROCURE_MODEL】中 根据调拨单+型号 更新 在用数量
|
List<Object[]> procureModelParameterList = new ArrayList<>();
|
for (Map.Entry<String, Integer> entry : procureModelMap.entrySet()) {
|
String key = entry.getKey();
|
Integer modelUseingNum = entry.getValue();
|
String[] strings = key.split("_");
|
String transBusinessId = strings[0];
|
String baseGoodsModelsId = strings[1];
|
Object[] one = new Object[4];
|
one[0] = modelUseingNum;
|
one[1] = transBusinessId;
|
one[2] = baseGoodsModelsId;
|
one[3] = modelUseingNum;
|
procureModelParameterList.add(one);
|
StringBuilder sb = new StringBuilder("update L_WH_PROCURE_MODEL set USE_COUNT=USE_COUNT-");
|
sb.append(modelUseingNum).append(" where BUSINESS_TYPE=4 and BUSINESS_ID=");
|
sb.append(transBusinessId).append(" and BASE_GOODS_MODELS_ID=");
|
sb.append(baseGoodsModelsId).append(" and USE_COUNT-");
|
sb.append(modelUseingNum).append(" >=0");
|
goodsBaseService.update(sb.toString());
|
}
|
// goodsBaseService.execBatchUpdate("update L_WH_PROCURE_MODEL set USE_COUNT=USE_COUNT-? where BUSINESS_TYPE=4 and BUSINESS_ID=? and BASE_GOODS_MODELS_ID=? and USE_COUNT=USE_COUNT-? >0", parameterList);
|
|
|
// 操作入库，此时要按物品所属仓库 生成不同仓库入库的流水
|
Map<String, List<Map<String, Object>>> groupByOutWarehouseIdMap = bfModelList.stream()
|
.collect(Collectors.groupingBy(map -> map.get("TRANS_OUT_WAREHOUSE_TYPE") + "_" + map.get("TRANS_OUT_WAREHOUSE_ID")));
|
//每个仓库一个流水表
|
ArrayList<LWarehouseFlow> flowArrayList = new ArrayList<>();
|
ArrayList<LWhGoodsRecord> flowRecordArrayList = new ArrayList<>();
|
|
for (String outWarehouseTypeAndId : groupByOutWarehouseIdMap.keySet()) {
|
List<Map<String, Object>> eachWareHouseList = groupByOutWarehouseIdMap.get(outWarehouseTypeAndId);
|
Map<String, Object> eachWarehouseModelMap = eachWareHouseList.get(0);
|
|
// Integer inWareHouseType = Convert.toInt(eachWarehouseModelMap.get("TRANS_OUT_WAREHOUSE_TYPE"));
|
Long inWarehouseId = Convert.toLong(eachWarehouseModelMap.get("TRANS_OUT_WAREHOUSE_ID"));
|
String inWarehouseName = null;
|
BaseWarehouse baseWarehouse = goodsBaseService.get(new BaseWarehouse(inWarehouseId));
|
if (baseWarehouse != null) {
|
inWarehouseName = baseWarehouse.getWarehouseName();
|
}
|
|
// 每个仓库一个流水表
|
LWarehouseFlow inWarehouseFlow = new LWarehouseFlow();
|
// 流水记录总表ID
|
long inWarehouseFlowId = IdUtil.generateId();
|
inWarehouseFlow.setId(inWarehouseFlowId);
|
inWarehouseFlow.setWarehouseType(0);
|
inWarehouseFlow.setWarehouseId(inWarehouseId);
|
inWarehouseFlow.setWarehouseName(inWarehouseName);
|
inWarehouseFlow.setThisType(1);
|
inWarehouseFlow.setBusinessType(WhBusinessEnum.BUMENTUIHUI.getValue() + 0);
|
inWarehouseFlow.setBusinessFormId(lWhFormBackId);
|
inWarehouseFlow.setOperatorId(userId);
|
inWarehouseFlow.setOperatorName(nickName);
|
inWarehouseFlow.setDealTime(dealTime);
|
flowArrayList.add(inWarehouseFlow);
|
|
//按型号分 每个型号一个 L_WH_GOODS_RECORD
|
Map<Object, List<Map<String, Object>>> eachWareHouseModelMap = eachWareHouseList.stream()
|
.collect(Collectors.groupingBy(map -> map.get("BASE_GOODS_MODELS_ID")));
|
for (Object key : eachWareHouseModelMap.keySet()) {
|
Long baseGoodsModelsId = (Long) key;
|
|
List<Map<String, Object>> eachFfModelList = eachWareHouseModelMap.get(baseGoodsModelsId);
|
Map<String, Object> eachFfModelBase = eachFfModelList.get(0);
|
Long tempGoodsId = Convert.toLong(eachFfModelBase.get("BASE_GOODS_TEMPLATE_ID"));
|
String goodsName = Convert.toStr(eachFfModelBase.get("BASE_GOODS_TEMPLATE_NAME"));
|
String modelName = Convert.toStr(eachFfModelBase.get("BASE_GOODS_MODELS_NAME"));
|
|
// 插入 各规格物品的进出库记录 L_WH_GOODS_RECORD
|
long whGoodsRecordId = IdUtil.generateId();
|
LWhGoodsRecord whGoodsRecord = new LWhGoodsRecord();
|
whGoodsRecord.setId(whGoodsRecordId);
|
whGoodsRecord.setWarehouseType(0);
|
whGoodsRecord.setWarehouseId(inWarehouseId);
|
whGoodsRecord.setWarehouseFlowId(inWarehouseFlowId);
|
whGoodsRecord.setBaseGoodsTemplateId(tempGoodsId);
|
whGoodsRecord.setGoodsTemplateName(goodsName);
|
whGoodsRecord.setBaseGoodsModelsId(baseGoodsModelsId);
|
whGoodsRecord.setBaseGoodsModelsName(modelName);
|
whGoodsRecord.setDealTime(dealTime);
|
//本次调整类型 1=调增；2=调减
|
whGoodsRecord.setThisType(1);
|
//通过LockManage获得锁
|
Object warehouseModelLockObj = LockManage.acquireLock(0, inWarehouseId, baseGoodsModelsId);
|
int goodsModelNum = 0;
|
// 存放所有的物品id 价格等信息
|
List<Map<String, Object>> scrappedAllGoodsList = new ArrayList<>();
|
synchronized (warehouseModelLockObj) {
|
//查询期初数量
|
List<Long> warehouseIds = new ArrayList<>(Arrays.asList(inWarehouseId));
|
goodsModelNum = lWhGoodsService.queryGoodsModelNum(0, warehouseIds, baseGoodsModelsId, 1, null);
|
for (Map<String, Object> depFormScrappedModel : eachFfModelList) {
|
scrappedAllGoodsList.addAll((List<Map<String, Object>>) depFormScrappedModel.get("scrappedGoodsList"));
|
}
|
// 汇总出需要修改状态的物品id
|
List<Long> srappedGoodsIds = scrappedAllGoodsList.stream().map(map -> (Long) map.get("id")).collect(Collectors.toList());
|
|
// 设置物品为入库未分发， 并设置所属仓库
|
lWhGoodsService.modGoodsTransfering(srappedGoodsIds, 0, inWarehouseId, warehouseName, 1);
|
// 使用人信息
|
|
// 批量插入 进出库流水明细[L_WH_GOODS_RECORD_DETAILS]
|
lWhGoodsRecordDetailsService.sameGoodsInsertMore(srappedGoodsIds, whGoodsRecordId, (short) 1);
|
}
|
// 上方物品的价格
|
Long formScrappedModelPrice = scrappedAllGoodsList.stream().mapToLong(map -> (long) map.get("price")).sum();
|
whGoodsRecord.setInitialCount(goodsModelNum);
|
whGoodsRecord.setEndCount(goodsModelNum + scrappedAllGoodsList.size());
|
whGoodsRecord.setThisCount(scrappedAllGoodsList.size());
|
whGoodsRecord.setTotalPrice(formScrappedModelPrice);
|
//lWhGoodsRecordService.insert(whGoodsRecord);
|
flowRecordArrayList.add(whGoodsRecord);
|
}
|
|
// 提取baseGoodsModelsId并放入新的List中
|
List<Long> allChangModelList = eachWareHouseList.stream()
|
.map(map -> Convert.toLong(map.get("BASE_GOODS_MODELS_ID")))
|
.distinct()
|
.collect(Collectors.toList());
|
//当库存变动时调用该方法
|
lWhWarningCoreService.updateKuCun((short) 0, inWarehouseId, allChangModelList, null, dealTime);
|
}
|
// 插入流水总表
|
flowInsertFlag = lWarehouseFlowService.insertBatch(flowArrayList);
|
if (flowInsertFlag == 0) {
|
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
|
return null;
|
}
|
// 批量插入 各规格物品的进出库【L_WH_GOODS_RECORD】
|
lWhGoodsRecordServiceImpl.insertBatch(flowRecordArrayList);
|
|
return null;
|
}
|
}
|
