package cn.iocoder.yudao.module.mes.service.wm.warehouse;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.util.ObjUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationImportExcelVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationImportRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationSaveReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseLocationDO;
|
import cn.iocoder.yudao.module.mes.dal.mysql.wm.warehouse.MesWmWarehouseLocationMapper;
|
import cn.iocoder.yudao.module.mes.dal.mysql.wm.warehouse.MesWmWarehouseMapper;
|
import cn.iocoder.yudao.module.mes.enums.wm.BarcodeBizTypeEnum;
|
import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService;
|
import cn.iocoder.yudao.module.mes.service.wm.barcode.MesWmBarcodeService;
|
import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService;
|
import jakarta.annotation.Resource;
|
import org.springframework.context.annotation.Lazy;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.validation.annotation.Validated;
|
|
import java.util.ArrayList;
|
import java.util.Collection;
|
import java.util.Collections;
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
import java.util.concurrent.atomic.AtomicInteger;
|
|
import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
|
import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
|
|
/**
|
* MES 库区 Service 实现类
|
*/
|
@Service
|
@Validated
|
public class MesWmWarehouseLocationServiceImpl implements MesWmWarehouseLocationService {
|
|
@Resource
|
private MesWmWarehouseLocationMapper locationMapper;
|
|
@Resource
|
private MesWmWarehouseMapper warehouseMapper;
|
|
@Resource
|
private MesWmWarehouseAreaService areaService;
|
@Resource
|
@Lazy
|
private MesMdWorkstationService workstationService;
|
@Resource
|
private MesWmMaterialStockService materialStockService;
|
@Resource
|
@Lazy
|
private MesWmWarehouseService warehouseService;
|
@Resource
|
private MesWmBarcodeService barcodeService;
|
|
@Override
|
public Long createWarehouseLocation(MesWmWarehouseLocationSaveReqVO createReqVO) {
|
// 校验虚拟库区不允许新增
|
validateNotVirtual(createReqVO.getCode());
|
// 校验数据
|
validateWarehouseLocationSaveData(createReqVO);
|
|
// 插入
|
MesWmWarehouseLocationDO location = BeanUtils.toBean(createReqVO, MesWmWarehouseLocationDO.class);
|
locationMapper.insert(location);
|
|
// 自动生成条码
|
barcodeService.autoGenerateBarcode(BarcodeBizTypeEnum.LOCATION.getValue(),
|
location.getId(), location.getCode(), location.getName());
|
return location.getId();
|
}
|
|
@Override
|
public void updateWarehouseLocation(MesWmWarehouseLocationSaveReqVO updateReqVO) {
|
// 校验存在
|
MesWmWarehouseLocationDO location = validateWarehouseLocationExists(updateReqVO.getId());
|
// 校验虚拟库区不允许修改
|
validateNotVirtual(location.getCode());
|
// 校验数据
|
validateWarehouseLocationSaveData(updateReqVO);
|
|
// 更新
|
MesWmWarehouseLocationDO updateObj = BeanUtils.toBean(updateReqVO, MesWmWarehouseLocationDO.class);
|
locationMapper.updateById(updateObj);
|
}
|
|
private void validateWarehouseLocationSaveData(MesWmWarehouseLocationSaveReqVO reqVO) {
|
// 校验仓库存在
|
warehouseService.validateWarehouseExists(reqVO.getWarehouseId());
|
// 校验编码唯一
|
validateWarehouseLocationCodeUnique(reqVO.getId(), reqVO.getWarehouseId(), reqVO.getCode());
|
// 校验名称唯一
|
validateWarehouseLocationNameUnique(reqVO.getId(), reqVO.getWarehouseId(), reqVO.getName());
|
}
|
|
private void validateNotVirtual(String code) {
|
if (MesWmWarehouseLocationDO.WIP_VIRTUAL_LOCATION.equals(code)) {
|
throw exception(WM_WAREHOUSE_LOCATION_IS_VIRTUAL);
|
}
|
}
|
|
@Override
|
public void deleteWarehouseLocation(Long id) {
|
// 校验存在
|
MesWmWarehouseLocationDO location = validateWarehouseLocationExists(id);
|
// 校验虚拟库区不允许删除
|
validateNotVirtual(location.getCode());
|
// 校验是否有库位
|
if (areaService.getWarehouseAreaCountByLocationId(id) > 0) {
|
throw exception(WM_WAREHOUSE_LOCATION_HAS_AREA);
|
}
|
// 校验是否被工作站引用
|
if (workstationService.getWorkstationCountByLocationId(id) > 0) {
|
throw exception(WM_WAREHOUSE_LOCATION_HAS_WORKSTATION);
|
}
|
// 校验是否有库存记录
|
if (materialStockService.getMaterialStockCountByLocationId(id) > 0) {
|
throw exception(WM_WAREHOUSE_LOCATION_HAS_MATERIAL_STOCK);
|
}
|
|
// 删除
|
locationMapper.deleteById(id);
|
}
|
|
@Override
|
public MesWmWarehouseLocationDO validateWarehouseLocationExists(Long id) {
|
MesWmWarehouseLocationDO location = locationMapper.selectById(id);
|
if (location == null) {
|
throw exception(WM_WAREHOUSE_LOCATION_NOT_EXISTS);
|
}
|
return location;
|
}
|
|
private void validateWarehouseLocationCodeUnique(Long id, Long warehouseId, String code) {
|
MesWmWarehouseLocationDO location = locationMapper.selectByCode(warehouseId, code);
|
if (location == null) {
|
return;
|
}
|
if (ObjUtil.notEqual(location.getId(), id)) {
|
throw exception(WM_WAREHOUSE_LOCATION_CODE_DUPLICATE);
|
}
|
}
|
|
private void validateWarehouseLocationNameUnique(Long id, Long warehouseId, String name) {
|
MesWmWarehouseLocationDO location = locationMapper.selectByName(warehouseId, name);
|
if (location == null) {
|
return;
|
}
|
if (ObjUtil.notEqual(location.getId(), id)) {
|
throw exception(WM_WAREHOUSE_LOCATION_NAME_DUPLICATE);
|
}
|
}
|
|
@Override
|
public MesWmWarehouseLocationDO getWarehouseLocation(Long id) {
|
return locationMapper.selectById(id);
|
}
|
|
@Override
|
public PageResult<MesWmWarehouseLocationDO> getWarehouseLocationPage(MesWmWarehouseLocationPageReqVO pageReqVO) {
|
return locationMapper.selectPage(pageReqVO);
|
}
|
|
@Override
|
public List<MesWmWarehouseLocationDO> getWarehouseLocationList(Long warehouseId) {
|
return locationMapper.selectSimpleList(warehouseId);
|
}
|
|
@Override
|
public List<MesWmWarehouseLocationDO> getWarehouseLocationList(Collection<Long> ids) {
|
if (CollUtil.isEmpty(ids)) {
|
return Collections.emptyList();
|
}
|
return locationMapper.selectListByIds(ids);
|
}
|
|
@Override
|
public Long getWarehouseLocationCountByWarehouseId(Long warehouseId) {
|
return locationMapper.selectCountByWarehouseId(warehouseId);
|
}
|
|
@Override
|
public MesWmWarehouseLocationDO getWarehouseLocationByCode(String code) {
|
// 1. 查询库区，存在则直接返回
|
MesWmWarehouseLocationDO location = locationMapper.selectByCode(code);
|
if (location != null) {
|
return location;
|
}
|
|
// 2. 如果是虚拟线边库区编码，则自动初始化
|
if (MesWmWarehouseLocationDO.WIP_VIRTUAL_LOCATION.equals(code)) {
|
// 2.1 先确保虚拟仓库存在（getWarehouseByCode 会级联创建仓库）
|
MesWmWarehouseDO warehouse = warehouseService.getWarehouseByCode(MesWmWarehouseDO.WIP_VIRTUAL_WAREHOUSE);
|
cn.hutool.core.lang.Assert.notNull(warehouse, "虚拟仓库必须存在");
|
// 2.2 自动初始化
|
MesWmWarehouseLocationDO newLocation = MesWmWarehouseLocationDO.builder()
|
.warehouseId(warehouse.getId()).code(code).name("虚拟线边库区")
|
.frozen(false).remark("系统自动初始化的虚拟线边库区")
|
.build();
|
locationMapper.insert(newLocation);
|
return newLocation;
|
}
|
return null;
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public MesWmWarehouseLocationImportRespVO importWarehouseLocationList(List<MesWmWarehouseLocationImportExcelVO> importList, boolean updateSupport) {
|
// 校验导入数据不能为空
|
if (CollUtil.isEmpty(importList)) {
|
throw exception(WM_WAREHOUSE_LOCATION_IMPORT_LIST_IS_EMPTY);
|
}
|
MesWmWarehouseLocationImportRespVO respVO = MesWmWarehouseLocationImportRespVO.builder()
|
.createCodes(new ArrayList<>()).updateCodes(new ArrayList<>())
|
.failureCodes(new LinkedHashMap<>()).build();
|
// 索引，用于错误提示
|
AtomicInteger index = new AtomicInteger(1);
|
importList.forEach(importItem -> {
|
int currentIndex = index.getAndIncrement();
|
String code = importItem.getCode();
|
String key = StrUtil.blankToDefault(code, "第 " + currentIndex + " 行");
|
// 校验编码必填
|
if (StrUtil.isBlank(code)) {
|
respVO.getFailureCodes().put(key, "库区编码不能为空");
|
return;
|
}
|
// 校验名称必填
|
if (StrUtil.isBlank(importItem.getName())) {
|
respVO.getFailureCodes().put(key, "库区名称不能为空");
|
return;
|
}
|
// 校验虚拟库区不允许导入
|
if (MesWmWarehouseLocationDO.WIP_VIRTUAL_LOCATION.equals(code)) {
|
respVO.getFailureCodes().put(key, "虚拟库区不允许导入");
|
return;
|
}
|
// 按名称解析所属仓库
|
if (StrUtil.isBlank(importItem.getWarehouseName())) {
|
respVO.getFailureCodes().put(key, "所属仓库不能为空");
|
return;
|
}
|
MesWmWarehouseDO warehouse = warehouseMapper.selectByName(importItem.getWarehouseName());
|
if (warehouse == null) {
|
respVO.getFailureCodes().put(key, "仓库不存在：" + importItem.getWarehouseName());
|
return;
|
}
|
Long warehouseId = warehouse.getId();
|
MesWmWarehouseLocationDO existingByCode = locationMapper.selectByCode(warehouseId, code);
|
MesWmWarehouseLocationDO existingByName = locationMapper.selectByName(warehouseId, importItem.getName());
|
if (existingByCode != null && updateSupport) {
|
// 名称唯一校验（排除自己）
|
if (existingByName != null && !existingByCode.getId().equals(existingByName.getId())) {
|
respVO.getFailureCodes().put(key, "库区名称已存在：" + importItem.getName());
|
return;
|
}
|
// 更新
|
MesWmWarehouseLocationDO updateObj = new MesWmWarehouseLocationDO();
|
updateObj.setId(existingByCode.getId());
|
updateObj.setName(importItem.getName());
|
updateObj.setWarehouseId(warehouseId);
|
updateObj.setArea(importItem.getArea());
|
updateObj.setFrozen(importItem.getFrozen());
|
updateObj.setRemark(importItem.getRemark());
|
locationMapper.updateById(updateObj);
|
respVO.getUpdateCodes().add(code);
|
} else if (existingByCode != null) {
|
respVO.getFailureCodes().put(key, "库区编码已存在：" + code);
|
} else {
|
// 名称唯一校验
|
if (existingByName != null) {
|
respVO.getFailureCodes().put(key, "库区名称已存在：" + importItem.getName());
|
return;
|
}
|
// 创建
|
MesWmWarehouseLocationDO createObj = new MesWmWarehouseLocationDO();
|
createObj.setId(null);
|
createObj.setCode(code);
|
createObj.setName(importItem.getName());
|
createObj.setWarehouseId(warehouseId);
|
createObj.setArea(importItem.getArea());
|
createObj.setFrozen(ObjUtil.defaultIfNull(importItem.getFrozen(), Boolean.FALSE));
|
createObj.setRemark(importItem.getRemark());
|
locationMapper.insert(createObj);
|
// 自动生成条码
|
barcodeService.autoGenerateBarcode(BarcodeBizTypeEnum.LOCATION.getValue(),
|
createObj.getId(), createObj.getCode(), createObj.getName());
|
respVO.getCreateCodes().add(code);
|
}
|
});
|
return respVO;
|
}
|
|
}
|
