package com.zy.asrs.service.impl;
|
|
import com.baomidou.mybatisplus.mapper.EntityWrapper;
|
import com.baomidou.mybatisplus.mapper.Wrapper;
|
import com.core.common.BaseRes;
|
import com.core.common.Cools;
|
import com.core.common.DateUtils;
|
import com.core.common.SnowflakeIdWorker;
|
import com.core.exception.CoolException;
|
import com.zy.asrs.entity.*;
|
import com.zy.asrs.entity.param.EmptyPlateOutParam;
|
import com.zy.asrs.entity.param.FullStoreParam;
|
import com.zy.asrs.entity.param.LocDetlAdjustParam;
|
import com.zy.asrs.entity.param.StockOutParam;
|
import com.zy.asrs.mapper.OrderDetlMapper;
|
import com.zy.asrs.mapper.OrderMapper;
|
import com.zy.asrs.service.*;
|
import com.zy.asrs.utils.Utils;
|
import com.zy.common.model.*;
|
import com.zy.common.model.enums.IoWorkType;
|
import com.zy.common.model.enums.WorkNoType;
|
import com.zy.common.properties.SlaveProperties;
|
import com.zy.common.service.CommonService;
|
import com.zy.common.web.WcsController;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import java.util.*;
|
import java.util.concurrent.TimeUnit;
|
|
/**
|
* Created by vincent on 2020/6/11
|
*/
|
@Slf4j
|
@Service
|
public class WorkServiceImpl implements WorkService {
|
|
// 工作号生成规则默认类型
|
private static final int DEFAULT_WORK_NO_TYPE = 0;
|
// 库位排号分配默认类别
|
private static final int DEFAULT_ROW_NO_TYPE = 1;
|
|
// 堆垛机映射一楼的入库出库站点
|
private static final Map<Integer, List<Integer>> crnMapNo;
|
|
static {
|
crnMapNo = new HashMap<>();
|
crnMapNo.put(1, new ArrayList<Integer>() {{
|
add(3001);
|
add(3002);
|
}});
|
crnMapNo.put(2, new ArrayList<Integer>() {{
|
add(3004);
|
add(3003);
|
}});
|
crnMapNo.put(3, new ArrayList<Integer>() {{
|
add(3005);
|
add(3006);
|
}});
|
crnMapNo.put(4, new ArrayList<Integer>() {{
|
add(3007);
|
add(3008);
|
}});
|
crnMapNo.put(5, new ArrayList<Integer>() {{
|
add(3010);
|
add(3009);
|
}});
|
crnMapNo.put(6, new ArrayList<Integer>() {{
|
add(3011);
|
add(3012);
|
}});
|
}
|
|
@Autowired
|
private MatService matService;
|
@Autowired
|
private WrkMastService wrkMastService;
|
@Autowired
|
private DocTypeService docTypeService;
|
@Autowired
|
private WrkDetlService wrkDetlService;
|
@Autowired
|
private BasDevpService basDevpService;
|
@Autowired
|
private CommonService commonService;
|
@Autowired
|
private LocMastService locMastService;
|
@Autowired
|
private StaDescService staDescService;
|
@Autowired
|
private LocDetlService locDetlService;
|
@Autowired
|
private AdjDetlService adjDetlService;
|
@Autowired
|
private WrkMastLogService wrkMastLogService;
|
@Autowired
|
private WrkDetlLogService wrkDetlLogService;
|
@Autowired
|
private SnowflakeIdWorker snowflakeIdWorker;
|
@Autowired
|
private OrderService orderService;
|
@Autowired
|
private OrderDetlService orderDetlService;
|
@Resource
|
private OrderMapper orderMapper;
|
@Resource
|
private OrderDetlMapper orderDetlMapper;
|
@Autowired
|
private WcsController wcsController;
|
@Autowired
|
private RowLastnoService rowLastnoService;
|
@Autowired
|
private SlaveProperties slaveProperties;
|
@Autowired
|
private WaitPakinService waitPakinService;
|
@Resource
|
private OpenServiceImpl openService;
|
|
@Override
|
@Transactional
|
public String startupFullPutStore(FullStoreParam param, Long userId) {
|
// 参数非空判断
|
if (Cools.isEmpty(param.getDevpNo(), param.getList())) {
|
throw new CoolException(BaseRes.PARAM);
|
}
|
Date now = new Date();
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(param.getDevpNo(), true);
|
// 检索库位
|
LocTypeDto locTypeDto = new LocTypeDto(sourceStaNo);
|
// List<String> matnrs = param.getList().stream().map(FullStoreParam.MatCodeStore::getMatnr).distinct().collect(Collectors.toList());
|
StartupDto dto = commonService.getLocNo(DEFAULT_ROW_NO_TYPE, 1, param.getDevpNo(), param.getList().get(0).getMatnr(), null, null, locTypeDto);
|
// 生成工作号
|
int workNo = dto.getWorkNo();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(1L); // 工作状态：生成入库ID
|
wrkMast.setIoType(1); // 入出库状态：1.入库
|
wrkMast.setIoPri(13D); // 优先级：13
|
wrkMast.setCrnNo(dto.getCrnNo());
|
wrkMast.setSourceStaNo(dto.getSourceStaNo());
|
wrkMast.setStaNo(dto.getStaNo());
|
wrkMast.setLocNo(dto.getLocNo());
|
wrkMast.setBarcode(param.getBarcode()); // 托盘码
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型
|
wrkMast.setAppeUser(userId);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.insert(wrkMast)) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 生成工作档明细
|
List<DetlDto> detlDtos = new ArrayList<>();
|
param.getList().forEach(elem -> {
|
DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme());
|
if (DetlDto.has(detlDtos, detlDto)) {
|
DetlDto detlDto1 = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch());
|
assert detlDto1 != null;
|
detlDto1.setAnfme(detlDto1.getAnfme() + detlDto.getAnfme());
|
} else {
|
detlDtos.add(detlDto);
|
}
|
});
|
wrkDetlService.createWorkDetail(workNo, detlDtos, param.getBarcode(), userId, now);
|
// 更新源站点信息
|
sourceStaNo.setWrkNo(workNo);
|
sourceStaNo.setModiUser(userId);
|
sourceStaNo.setModiTime(now);
|
if (!basDevpService.updateById(sourceStaNo)) {
|
throw new CoolException("更新源站失败");
|
}
|
// 更新目标库位状态
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("O")) {
|
locMast.setLocSts("S"); // S.入库预约
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(dto.getLocNo() + "目标库位已被占用");
|
}
|
return dto.getLocNo();
|
}
|
|
@Override
|
@Transactional
|
public void startupFullTakeStore(StockOutParam param, Long userId) {
|
// 目标站点状态检测
|
BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite());
|
// 获取库位明细
|
List<LocDetlDto> locDetlDtos = new ArrayList<>();
|
for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) {
|
LocDetl one = new LocDetl();
|
// if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) {
|
one = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", paramLocDetl.getLocNo())
|
.eq("brand", paramLocDetl.getBrand()).eq("model", paramLocDetl.getModel()));
|
// selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch());
|
if (paramLocDetl.getMatnr().equals("空箱")) {
|
one = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", paramLocDetl.getLocNo()));
|
}
|
if (null != one && !paramLocDetl.getMatnr().equals("空箱")) {
|
// 3077 3106 只有合格能出
|
if((param.getOutSite() == 3077 || param.getOutSite() == 3106) && !"合格".equals(one.getThreeCode())) {
|
throw new CoolException(one.getModel() + "卷不合格:" + one.getThreeCode());
|
}
|
// 2041 只有待判能出
|
if(param.getOutSite() == 2041 && null != one.getThreeCode()) {
|
throw new CoolException(one.getModel() + "卷不为待判:" + one.getThreeCode());
|
}
|
locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount(), param.getOrderNo()));
|
} else {
|
locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount(), param.getOrderNo()));
|
}
|
// }
|
}
|
if (!locDetlDtos.isEmpty()) {
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetlDtos.get(0).getLocDetl().getLocNo()));
|
if (locMast.getLocSts().equals("F") || locMast.getLocSts().equals("D")) {
|
// 启动出库开始 101.出库
|
stockOut(staNo, locDetlDtos, null, userId);
|
} else {
|
throw new CoolException("所选库位存在状态不为F、D的库位，库位号：" + locMast.getLocNo() + " 、当前状态：" + locMast.getLocSts() + "-" + locMast.getLocSts$());
|
}
|
} else {
|
throw new CoolException("库存不存在");
|
}
|
}
|
|
@Override
|
@Transactional
|
public void startupFullTakeStoreOrder(StockOutParam param, Long userId) {
|
if (Cools.isEmpty(param) || Cools.isEmpty(param.getLocDetls())) {
|
throw new CoolException("参数为空");
|
}
|
if (Cools.isEmpty(param.getOrderNo())) {
|
throw new CoolException("订单号参数为空");
|
}
|
DocType docType = docTypeService.selectOrAdd("手动出库单", Boolean.FALSE);
|
Order order = orderService.selectByNo(param.getOrderNo());
|
if (Cools.isEmpty(order)) {
|
Date now = new Date();
|
order = new Order(
|
String.valueOf(snowflakeIdWorker.nextId()), // 编号[非空]
|
param.getOrderNo(), // 订单编号
|
DateUtils.convert(now), // 单据日期
|
docType.getDocId(), // 单据类型
|
null, // 项目编号
|
null, //
|
null, // 调拨项目编号
|
null, // 初始票据号
|
null, // 票据号
|
null, // 客户编号
|
null, // 客户
|
null, // 联系方式
|
null, // 操作人员
|
null, // 合计金额
|
null, // 优惠率
|
null, // 优惠金额
|
null, // 销售或采购费用合计
|
null, // 实付金额
|
null, // 付款类型
|
null, // 业务员
|
null, // 结算天数
|
null, // 邮费支付类型
|
null, // 邮费
|
null, // 付款时间
|
null, // 发货时间
|
null, // 物流名称
|
null, // 物流单号
|
// 2L, // 订单状态
|
1L, // 订单状态
|
1, // 状态
|
userId, // 添加人员
|
now, // 添加时间
|
userId, // 修改人员
|
now, // 修改时间
|
null // 备注
|
);
|
if (!orderService.insert(order)) {
|
throw new CoolException("保存订单主档失败");
|
}
|
// 单据明细档
|
List<DetlDto> list = new ArrayList<>();
|
List<StockOutParam.LocDetl> locDetls = param.getLocDetls();
|
int i = 0;
|
for (StockOutParam.LocDetl locDetl : locDetls) {
|
i++;
|
Mat mat = matService.selectByMatnr(locDetl.getMatnr());
|
if (Cools.isEmpty(mat)) {
|
throw new CoolException(locDetl.getMatnr() + "物料编码检索失败，请先添加商品");
|
}
|
OrderDetl orderDetl = new OrderDetl();
|
orderDetl.sync(mat);
|
orderDetl.setSuppCode(String.valueOf(i)); // 行号
|
orderDetl.setManu(locDetl.getLocNo()); //库位号
|
orderDetl.setBatch(locDetl.getBatch()); //木箱编码
|
orderDetl.setAnfme(locDetl.getAnfme());//出库数量
|
orderDetl.setModel(locDetl.getModel());//批次
|
orderDetl.setSpecs(locDetl.getSpecs());//规格
|
orderDetl.setBrand(locDetl.getBrand());//木箱类型
|
orderDetl.setBarcode(locDetl.getZpallet());//木箱类型
|
orderDetl.setWeight(locDetl.getWeight());
|
// orderDetl.setWorkQty(locDetl.getAnfme());
|
orderDetl.setWorkQty(0.0);
|
orderDetl.setOrderId(order.getId());
|
orderDetl.setOrderNo(order.getOrderNo());
|
orderDetl.setOrigin(locDetl.getOrigin());
|
orderDetl.setCreateBy(userId);
|
orderDetl.setCreateTime(now);
|
orderDetl.setUpdateBy(userId);
|
orderDetl.setUpdateTime(now);
|
orderDetl.setStatus(1);
|
orderDetl.setQty(0.0D);
|
if (!orderDetlService.insert(orderDetl)) {
|
throw new CoolException("生成单据明细失败，请联系管理员");
|
}
|
}
|
|
// List<StockOutParam> stockOutParams = OutboundAllocationUtil.OutboundClassification(param);
|
// for (StockOutParam stockOutParam : stockOutParams){
|
// startupFullTakeStore(stockOutParam,userId);
|
// }
|
|
} else {
|
throw new CoolException("订单号重复，订单" + param.getOrderNo() + "已存在！！！");
|
}
|
|
}
|
|
@Transactional
|
@Override
|
public void stockOut(BasDevp staNo, List<LocDetlDto> locDetlDtos, IoWorkType ioWorkType, Long userId) {
|
Date now = new Date();
|
// 合并同类项
|
Set<String> locNos = new HashSet<>();
|
List<OutLocDto> dtos = new ArrayList<>();
|
for (LocDetlDto locDetlDto : locDetlDtos) {
|
String locNo = locDetlDto.getLocDetl().getLocNo();
|
if (locNos.contains(locNo)) {
|
for (OutLocDto dto : dtos) {
|
if (dto.getLocNo().equals(locNo)) {
|
dto.getLocDetlDtos().add(locDetlDto);
|
break;
|
}
|
}
|
} else {
|
locNos.add(locNo);
|
dtos.add(new OutLocDto(locNo, locDetlDto));
|
}
|
}
|
Integer ioType = null;
|
// 生成工作档
|
for (OutLocDto dto : dtos) {
|
// 判断入出库类型：101.全板出库 or 103.拣料出库
|
if (ioWorkType == null) {
|
ioType = dto.isAll() ? 101 : 103;
|
} else if (ioWorkType.equals(IoWorkType.CHECK_OUT)) {
|
ioType = 107;
|
}
|
assert ioType != null;
|
// 获取库位
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
|
Integer outSta = staNo.getDevNo();
|
// //2号堆垛机全板出库站指定为204站，拣料站指定为202
|
// if(locMast.getCrnNo()==2){
|
// outSta = ioType == 101 ? 204 : 202;
|
// }
|
|
// 获取路径
|
StaDesc staDesc = staDescService.queryCrnStn(ioType, locMast.getCrnNo(), outSta);
|
// 生成工作号
|
int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType));
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(ioType); // 入出库状态
|
wrkMast.setIoPri(13D); // 优先级：13
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站
|
wrkMast.setStaNo(staDesc.getStnNo()); // 目标站
|
wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setSheetNo("0");
|
// wrkMast.setMemo(groupOrderNumber);
|
if (staDesc.getStnNo() < 118 || staDesc.getStnNo() > 121) {
|
wrkMast.setSheetNo("3");
|
}
|
wrkMast.setBarcode(locMast.getBarcode());
|
wrkMast.setAppeUser(userId); // 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.insert(wrkMast)) {
|
throw new CoolException("保存工作档失败，出库库位号：" + dto.getLocNo());
|
}
|
// 生成工作档明细
|
for (LocDetlDto detlDto : dto.getLocDetlDtos()) {
|
if (detlDto.getCount() == null || detlDto.getCount() <= 0.0D) {
|
continue;
|
}
|
WrkDetl wrkDetl = new WrkDetl();
|
List<OrderDetl> orderDetl = orderDetlService.selectByBrand(detlDto.getLocDetl().getBrand());
|
wrkDetl.sync(detlDto.getLocDetl());
|
for (OrderDetl orderDetlDto : orderDetl) {
|
if (orderDetlDto.getSupp() != null) {
|
wrkDetl.setSupp(orderDetlDto.getSupp());
|
}
|
if (orderDetlDto.getMemo() != null) {
|
wrkDetl.setMemo(orderDetlDto.getMemo());
|
}
|
}
|
wrkDetl.setOrderNo(detlDto.getOrderNo()); // 手动出库不需要带出库存中的单据编号
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setIoTime(now);
|
Double anfme = ioType == 101 ? detlDto.getLocDetl().getAnfme() : detlDto.getCount();
|
wrkDetl.setAnfme(anfme); // 数量
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
// 修改订单明细
|
orderDetlMapper.updateOrderDetlByGroupNo(detlDto.getOrderNo(), detlDto.getLocDetl().getBrand(), 1);
|
// 修改订单状态
|
orderMapper.updateSettleByOrderNo(detlDto.getOrderNo(), 2L, userId);
|
}
|
|
// 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中
|
locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("F")) {
|
locMast.setLocSts(ioType == 101 ? "R" : "P");
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("预约库位状态失败，库位号：" + dto.getLocNo());
|
}
|
} else {
|
throw new CoolException(dto.getLocNo() + "库位不是在库状态");
|
}
|
}
|
}
|
|
|
@Override
|
@Transactional
|
public void stockOut(BasDevp staNo, List<LocDetlDto> locDetlDtos, IoWorkType ioWorkType, Long userId, String groupOrderNumber) {
|
Date now = new Date();
|
// 合并同类项
|
Set<String> locNos = new HashSet<>();
|
List<OutLocDto> dtos = new ArrayList<>();
|
for (LocDetlDto locDetlDto : locDetlDtos) {
|
String locNo = locDetlDto.getLocDetl().getLocNo();
|
if (locNos.contains(locNo)) {
|
for (OutLocDto dto : dtos) {
|
if (dto.getLocNo().equals(locNo)) {
|
dto.getLocDetlDtos().add(locDetlDto);
|
break;
|
}
|
}
|
} else {
|
locNos.add(locNo);
|
dtos.add(new OutLocDto(locNo, locDetlDto));
|
}
|
}
|
Integer ioType = null;
|
// 生成工作档
|
for (OutLocDto dto : dtos) {
|
// 判断入出库类型：101.全板出库 or 103.拣料出库
|
if (ioWorkType == null) {
|
ioType = dto.isAll() ? 101 : 103;
|
} else if (ioWorkType.equals(IoWorkType.CHECK_OUT)) {
|
ioType = 107;
|
} else if (ioWorkType.equals(IoWorkType.ALL_OUT)) {
|
ioType = 101;
|
}
|
assert ioType != null;
|
// 获取库位
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
|
Integer outSta = staNo.getDevNo();
|
// //2号堆垛机全板出库站指定为204站，拣料站指定为202
|
// if(locMast.getCrnNo()==2){
|
// outSta = ioType == 101 ? 204 : 202;
|
// }
|
|
// 获取路径
|
StaDesc staDesc = staDescService.queryCrnStn(ioType, locMast.getCrnNo(), outSta);
|
// 生成工作号
|
int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType));
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(ioType); // 入出库状态
|
wrkMast.setIoPri(13D); // 优先级：13
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站
|
wrkMast.setStaNo(staDesc.getStnNo()); // 目标站
|
wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setSheetNo("0");
|
wrkMast.setMemo(groupOrderNumber);
|
if (staDesc.getStnNo() < 118 || staDesc.getStnNo() > 121) {
|
wrkMast.setSheetNo("3");
|
}
|
wrkMast.setBarcode(locMast.getBarcode());
|
wrkMast.setAppeUser(userId); // 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.insert(wrkMast)) {
|
throw new CoolException("保存工作档失败，出库库位号：" + dto.getLocNo());
|
}
|
// 生成工作档明细
|
for (LocDetlDto detlDto : dto.getLocDetlDtos()) {
|
if (detlDto.getCount() == null || detlDto.getCount() <= 0.0D) {
|
continue;
|
}
|
WrkDetl wrkDetl = new WrkDetl();
|
List<OrderDetl> orderDetl = orderDetlService.selectByBrand(detlDto.getLocDetl().getBrand());
|
wrkDetl.sync(detlDto.getLocDetl());
|
for (OrderDetl orderDetlDto : orderDetl) {
|
if (orderDetlDto.getSupp() != null) {
|
wrkDetl.setSupp(orderDetlDto.getSupp());
|
}
|
if (orderDetlDto.getMemo() != null) {
|
wrkDetl.setMemo(orderDetlDto.getMemo());
|
}
|
}
|
wrkDetl.setOrderNo(detlDto.getOrderNo()); // 手动出库不需要带出库存中的单据编号
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setIoTime(now);
|
Double anfme = ioType == 101 ? detlDto.getLocDetl().getAnfme() : detlDto.getCount();
|
wrkDetl.setAnfme(anfme); // 数量
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
// 修改订单明细
|
orderDetlMapper.updateOrderDetlByGroupNo(detlDto.getOrderNo(), detlDto.getLocDetl().getBrand(), 1);
|
// 修改订单状态
|
orderMapper.updateSettleByOrderNo(detlDto.getOrderNo(), 2L, userId);
|
}
|
|
// 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中
|
locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("F")) {
|
locMast.setLocSts(ioType == 101 ? "R" : "P");
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("预约库位状态失败，库位号：" + dto.getLocNo());
|
}
|
} else {
|
throw new CoolException(dto.getLocNo() + "库位不是在库状态");
|
}
|
}
|
}
|
|
@Override
|
@Transactional
|
public void stockOut2(BasDevp staNo, List<LocDetlDto> locDetlDtos, IoWorkType ioWorkType, Long userId, String groupOrderNumber) {
|
Date now = new Date();
|
// 合并同类项
|
Set<String> locNos = new HashSet<>();
|
List<OutLocDto> dtos = new ArrayList<>();
|
for (LocDetlDto locDetlDto : locDetlDtos) {
|
String locNo = locDetlDto.getLocDetl().getLocNo();
|
if (locNos.contains(locNo)) {
|
for (OutLocDto dto : dtos) {
|
if (dto.getLocNo().equals(locNo)) {
|
dto.getLocDetlDtos().add(locDetlDto);
|
break;
|
}
|
}
|
} else {
|
locNos.add(locNo);
|
dtos.add(new OutLocDto(locNo, locDetlDto));
|
}
|
}
|
Integer ioType = null;
|
// 生成工作档
|
for (OutLocDto dto : dtos) {
|
// 判断入出库类型：101.全板出库 or 103.拣料出库
|
if (ioWorkType == null) {
|
ioType = dto.isAll() ? 101 : 103;
|
} else if (ioWorkType.equals(IoWorkType.CHECK_OUT)) {
|
ioType = 107;
|
} else if (ioWorkType.equals(IoWorkType.ALL_OUT)) {
|
ioType = 101;
|
}
|
assert ioType != null;
|
// 获取库位
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
|
Integer outSta = staNo.getDevNo();
|
// //2号堆垛机全板出库站指定为204站，拣料站指定为202
|
// if(locMast.getCrnNo()==2){
|
// outSta = ioType == 101 ? 204 : 202;
|
// }
|
|
// 获取路径
|
StaDesc staDesc = staDescService.queryCrnStn(ioType, locMast.getCrnNo(), outSta);
|
// 生成工作号
|
int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType));
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(ioType); // 入出库状态
|
wrkMast.setIoPri(13D); // 优先级：13
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站
|
wrkMast.setStaNo(staDesc.getStnNo()); // 目标站
|
wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setSheetNo("0");
|
wrkMast.setMemo(groupOrderNumber);
|
if (staDesc.getStnNo() < 118 || staDesc.getStnNo() > 121) {
|
wrkMast.setSheetNo("3");
|
}
|
wrkMast.setBarcode(locMast.getBarcode());
|
wrkMast.setAppeUser(userId); // 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.insert(wrkMast)) {
|
throw new CoolException("保存工作档失败，出库库位号：" + dto.getLocNo());
|
}
|
// 生成工作档明细
|
for (LocDetlDto detlDto : dto.getLocDetlDtos()) {
|
if (detlDto.getCount() == null || detlDto.getCount() <= 0.0D) {
|
continue;
|
}
|
WrkDetl wrkDetl = new WrkDetl();
|
List<OrderDetl> orderDetl = orderDetlService.selectByModel(detlDto.getLocDetl().getModel());
|
wrkDetl.sync(detlDto.getLocDetl());
|
for (OrderDetl orderDetlDto : orderDetl) {
|
if (orderDetlDto.getSupp() != null) {
|
wrkDetl.setSupp(orderDetlDto.getSupp());
|
}
|
if (orderDetlDto.getMemo() != null) {
|
wrkDetl.setMemo(orderDetlDto.getMemo());
|
}
|
}
|
wrkDetl.setOrderNo(detlDto.getOrderNo()); // 手动出库不需要带出库存中的单据编号
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setIoTime(now);
|
Double anfme = ioType == 101 ? detlDto.getLocDetl().getAnfme() : detlDto.getCount();
|
wrkDetl.setAnfme(anfme); // 数量
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
// 修改订单明细
|
orderDetlMapper.updateOrderDetlByModel(detlDto.getOrderNo(), detlDto.getLocDetl().getModel(), 1);
|
// 修改订单状态
|
orderMapper.updateSettleByOrderNo(detlDto.getOrderNo(), 2L, userId);
|
}
|
|
// 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中
|
locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("F")) {
|
locMast.setLocSts(ioType == 101 ? "R" : "P");
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("预约库位状态失败，库位号：" + dto.getLocNo());
|
}
|
} else {
|
throw new CoolException(dto.getLocNo() + "库位不是在库状态");
|
}
|
}
|
}
|
|
@Override
|
@Transactional
|
public void stockOut(BasDevp staNo, TaskDto taskDto, Long userId) {
|
Date now = new Date();
|
List<LocDto> locDtos = taskDto.getLocDtos();
|
for (LocDto locDto : locDtos) {
|
if (!taskDto.getLocNo().equals(locDto.getLocNo()) && !taskDto.getStaNo().equals(locDto.getStaNo())) {
|
throw new CoolException("订单出库异常，请联系管理员");
|
}
|
}
|
// 获取库位
|
LocMast locMast = locMastService.selectById(taskDto.getLocNo());
|
// 获取路径
|
int ioType = taskDto.isAll() ? 101 : 103;
|
// StaDesc staDesc = staDescService.queryCrnStnAuto(ioType, locMast.getCrnNo(), staNo.getDevNo());
|
// 根据库位排号+出库站点，获取出库源站点
|
int row = Integer.parseInt(locMast.getLocNo().substring(0, 2));
|
int souresStaNo = 0;
|
if (taskDto.getStaNo() < 3000) { // 二楼
|
switch (row) {
|
case 1:
|
case 2:
|
case 3:
|
case 4:
|
souresStaNo = 2062;
|
break;
|
case 5:
|
case 6:
|
case 7:
|
case 8:
|
souresStaNo = 2065;
|
break;
|
case 9:
|
case 10:
|
case 11:
|
case 12:
|
souresStaNo = 2068;
|
break;
|
case 13:
|
case 14:
|
case 15:
|
case 16:
|
souresStaNo = 2070;
|
break;
|
case 17:
|
case 18:
|
case 19:
|
case 20:
|
souresStaNo = 2073;
|
break;
|
case 21:
|
case 22:
|
case 23:
|
case 24:
|
souresStaNo = 2076;
|
break;
|
default:
|
}
|
} else { // 一楼
|
switch (row) {
|
case 1:
|
case 2:
|
case 3:
|
case 4:
|
souresStaNo = 3002;
|
break;
|
case 5:
|
case 6:
|
case 7:
|
case 8:
|
souresStaNo = 3003;
|
break;
|
case 9:
|
case 10:
|
case 11:
|
case 12:
|
souresStaNo = 3006;
|
break;
|
case 13:
|
case 14:
|
case 15:
|
case 16:
|
souresStaNo = 3008;
|
break;
|
case 17:
|
case 18:
|
case 19:
|
case 20:
|
souresStaNo = 3009;
|
break;
|
case 21:
|
case 22:
|
case 23:
|
case 24:
|
souresStaNo = 3012;
|
break;
|
default:
|
}
|
}
|
|
if (souresStaNo == 0) {
|
throw new CoolException("源站点转换异常：" + row);
|
}
|
|
// 生成工作号
|
int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType));
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(ioType); // 入出库状态
|
wrkMast.setIoPri(13D); // 优先级：13
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceStaNo(souresStaNo); // 源站
|
wrkMast.setStaNo(taskDto.getStaNo()); // 目标站
|
wrkMast.setSourceLocNo(taskDto.getLocNo()); // 源库位
|
wrkMast.setFullPlt("Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("N"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setBarcode(locMast.getBarcode());
|
wrkMast.setAppeUser(userId); // 操作人员数据
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.insert(wrkMast)) {
|
throw new CoolException("保存工作档失败，出库库位号：" + taskDto.getLocNo());
|
}
|
// 生成工作档明细
|
for (LocDto locDto : taskDto.getLocDtos()) {
|
if (locDto.getAnfme() == null || locDto.getAnfme() <= 0.0D) {
|
continue;
|
}
|
OrderDetl orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch());
|
if (orderDetl == null) {
|
orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), null);
|
}
|
WrkDetl wrkDetl = new WrkDetl();
|
// wrkDetl.sync(orderDetl);
|
wrkDetl.setZpallet(wrkMast.getBarcode());
|
wrkDetl.setIoTime(now);
|
wrkDetl.setMatnr(locDto.getMatnr());
|
wrkDetl.setMaktx(locDto.getMaktx());
|
wrkDetl.setWeight(locDto.getWeight()); // 净重
|
wrkDetl.setVolume(locDto.getVolume()); // 毛重
|
wrkDetl.setOrigin(locDto.getOrigin()); // 木箱在托盘位置
|
wrkDetl.setPrice(locDto.getPrice());
|
wrkDetl.setSpecs(locDto.getSpecs());
|
wrkDetl.setModel(locDto.getModel());
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setBatch(locDto.getBatch());
|
wrkDetl.setOrderNo(locDto.getOrderNo());
|
wrkDetl.setAnfme(locDto.getAnfme()); // 数量
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
// 修改订单明细
|
if (!orderDetlService.increaseWorkQty(orderDetl.getOrderId(), orderDetl.getMatnr(), orderDetl.getBatch(), locDto.getAnfme())) {
|
throw new CoolException("修改订单明细数量失败");
|
}
|
orderService.updateSettle(orderDetl.getOrderId(), 2L, userId);
|
}
|
// 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中
|
locMast = locMastService.selectById(taskDto.getLocNo());
|
if (locMast.getLocSts().equals("F")) {
|
locMast.setLocSts(ioType == 101 ? "R" : "P");
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("预约库位状态失败，库位号：" + taskDto.getLocNo());
|
}
|
} else {
|
throw new CoolException(taskDto.getLocNo() + "库位不是在库状态");
|
}
|
}
|
|
@Override
|
@Transactional
|
public String emptyPlateIn(Integer devpNo, Long userId) {
|
// 源站点状态检测
|
BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true);
|
// 检索库位
|
LocTypeDto locTypeDto = new LocTypeDto(sourceStaNo);
|
StartupDto dto = commonService.getLocNo(DEFAULT_ROW_NO_TYPE, 10, devpNo, null, null, null, locTypeDto);
|
int workNo = dto.getWorkNo();
|
Date now = new Date();
|
// 生成工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(1L); // 工作状态：生成入库ID
|
wrkMast.setIoType(10); // 入出库状态：10.空板入库
|
wrkMast.setIoPri(10D); // 优先级：10
|
wrkMast.setCrnNo(dto.getCrnNo());
|
wrkMast.setSourceStaNo(dto.getSourceStaNo());
|
wrkMast.setStaNo(dto.getStaNo());
|
wrkMast.setLocNo(dto.getLocNo());
|
wrkMast.setFullPlt("N"); // 满板
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("Y"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型
|
// 操作人员数据
|
wrkMast.setAppeUser(userId);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 更新源站点信息
|
sourceStaNo.setWrkNo(workNo);
|
sourceStaNo.setModiUser(userId);
|
sourceStaNo.setModiTime(now);
|
if (!basDevpService.updateById(sourceStaNo)) {
|
throw new CoolException("更新源站失败");
|
}
|
// 更新目标库位状态
|
LocMast locMast = locMastService.selectById(dto.getLocNo());
|
if (locMast.getLocSts().equals("O")) {
|
locMast.setLocSts("S"); // S.入库预约
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(dto.getLocNo() + "目标库位已被占用");
|
}
|
return dto.getLocNo();
|
}
|
|
@Override
|
@Transactional
|
public void emptyPlateOut(EmptyPlateOutParam param, Long userId) {
|
if (Cools.isEmpty(param.getOutSite())) {
|
throw new CoolException("站点不存在");
|
}
|
for (String locNo : param.getLocNos()) {
|
// 获取工作号
|
int workNo = commonService.getWorkNo(WorkNoType.PAKOUT.type);
|
// 获取库位
|
LocMast locMast = locMastService.selectById(locNo);
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException(locNo + "库位不存在");
|
}
|
if (!locMast.getLocSts().equals("D")) {
|
throw new CoolException("所选库位存在状态不为D的库位，库位号：" + locMast.getLocNo() + " 、当前状态：" + locMast.getLocSts() + "-" + locMast.getLocSts$());
|
}
|
// 获取源站
|
Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
|
.eq("type_no", 110)
|
.eq("stn_no", param.getOutSite())
|
.eq("crn_no", locMast.getCrnNo());
|
StaDesc staDesc = staDescService.selectOne(wrapper);
|
Integer sourceStaNo = staDesc.getCrnStn();
|
if (Cools.isEmpty(sourceStaNo)) {
|
throw new CoolException("检索源站失败");
|
}
|
Date now = new Date();
|
// 保存工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(110); // 入出库状态： 110.空板出库
|
wrkMast.setIoPri(10D);
|
wrkMast.setSourceStaNo(sourceStaNo); // 源站
|
wrkMast.setStaNo(param.getOutSite()); // 目标站
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceLocNo(locNo); // 源库位
|
wrkMast.setFullPlt("N"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("Y"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setAppeUser(userId);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 更新库位状态 D.空板 -> R.出库预约
|
if (locMast.getLocSts().equals("D")) {
|
locMast.setLocSts("R");
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("更新库位状态失败");
|
}
|
}
|
}
|
}
|
|
@Override
|
@Transactional
|
public WrkMast emptyPlateOut(EmptyPlateOutParam param) {
|
WrkMast wrkMast = new WrkMast();
|
if (Cools.isEmpty(param.getOutSite())) {
|
throw new CoolException("站点不存在");
|
}
|
for (String locNo : param.getLocNos()) {
|
// 获取工作号
|
int workNo = commonService.getWorkNo(0);
|
// 获取库位
|
LocMast locMast = locMastService.selectById(locNo);
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException(locNo + "库位不存在");
|
}
|
// 获取源站
|
Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
|
.eq("type_no", 110)
|
.eq("stn_no", param.getOutSite())
|
.eq("crn_no", locMast.getCrnNo());
|
StaDesc staDesc = staDescService.selectOne(wrapper);
|
Integer sourceStaNo = staDesc.getCrnStn();
|
if (Cools.isEmpty(sourceStaNo)) {
|
throw new CoolException("检索源站失败");
|
}
|
Date now = new Date();
|
// 保存工作档
|
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(110); // 入出库状态： 110.空板出库
|
wrkMast.setIoPri(10D);
|
wrkMast.setSourceStaNo(sourceStaNo); // 源站
|
wrkMast.setStaNo(param.getOutSite()); // 目标站
|
wrkMast.setCrnNo(locMast.getCrnNo());
|
wrkMast.setSourceLocNo(locNo); // 源库位
|
wrkMast.setFullPlt("N"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk("Y"); // 空板
|
wrkMast.setLinkMis("N");
|
wrkMast.setAppeUser(1L);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(1L);
|
wrkMast.setModiTime(now);
|
wrkMast.setMemo("生成自动空板出库");
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 更新库位状态 D.空板 -> R.出库预约
|
if (locMast.getLocSts().equals("D")) {
|
locMast.setLocSts("R");
|
locMast.setModiUser(1L);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("更新库位状态失败");
|
}
|
}
|
}
|
return wrkMast;
|
}
|
|
@Override
|
@Transactional
|
public void locCheckOut(StockOutParam param, Long userId) {
|
// 目标站点状态检测
|
BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite());
|
// 获取库位明细
|
List<LocDetlDto> locDetlDtos = new ArrayList<>();
|
for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) {
|
LocDetl one = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", paramLocDetl.getLocNo())
|
.eq("brand", paramLocDetl.getBrand()).eq("model", paramLocDetl.getModel()));
|
if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount(), param.getOrderNo()));
|
}
|
if (!locDetlDtos.isEmpty()) {
|
LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetlDtos.get(0).getLocDetl().getLocNo()));
|
if (locMast.getLocSts().equals("F")) {
|
// 启动出库开始 107.盘点出库
|
stockOut(staNo, locDetlDtos, IoWorkType.CHECK_OUT, userId);
|
} else {
|
throw new CoolException("所选库位存在状态不为F的库位，库位号：" + locMast.getLocNo() + " 、当前状态：" + locMast.getLocSts() + "-" + locMast.getLocSts$());
|
}
|
} else {
|
throw new CoolException("库位物料不存在");
|
}
|
}
|
|
@Override
|
@Transactional
|
public void locMove(String sourceLocNo, String locNo, Long userId) {
|
LocMast sourceLoc = locMastService.selectById(sourceLocNo);
|
List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", sourceLocNo));
|
if (Cools.isEmpty(sourceLoc)) {
|
throw new CoolException("未找到库位");
|
}
|
LocMast loc = locMastService.selectById(locNo);
|
if (Cools.isEmpty(loc)) {
|
throw new CoolException("未找到库位");
|
}
|
if (!loc.getLocSts().equals("O") || (!sourceLoc.getLocSts().equals("F") && !sourceLoc.getLocSts().equals("D"))) {
|
throw new CoolException("库位状态已改变");
|
}
|
if (!sourceLoc.getCrnNo().equals(loc.getCrnNo())) {
|
throw new CoolException("移转库位属于不同堆垛机");
|
}
|
Date now = new Date();
|
// 获取工作号
|
int workNo = commonService.getWorkNo(WorkNoType.PICK.type);
|
// 保存工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(11); // 入出库状态： 11.库格移载
|
wrkMast.setIoPri(10D);
|
wrkMast.setCrnNo(sourceLoc.getCrnNo());
|
wrkMast.setSourceLocNo(sourceLocNo); // 源库位
|
wrkMast.setLocNo(locNo); // 目标库位
|
wrkMast.setFullPlt(Cools.isEmpty(locDetls) ? "N" : "Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk(sourceLoc.getLocSts().equals("D") ? "Y" : "N"); // 空板
|
wrkMast.setBarcode(sourceLoc.getBarcode()); // 托盘码
|
wrkMast.setLinkMis("N");
|
wrkMast.setAppeUser(userId);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 工作档明细保存
|
for (LocDetl locDetl : locDetls) {
|
WrkDetl wrkDetl = new WrkDetl();
|
wrkDetl.sync(locDetl);
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setIoTime(now);
|
wrkDetl.setAnfme(locDetl.getAnfme());
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
}
|
// 修改源库位状态
|
if (sourceLoc.getLocSts().equals("D") || sourceLoc.getLocSts().equals("F")) {
|
sourceLoc.setLocSts("R"); // R.出库预约
|
sourceLoc.setModiUser(userId);
|
sourceLoc.setModiTime(now);
|
if (!locMastService.updateById(sourceLoc)) {
|
throw new CoolException("更新源库位状态失败");
|
}
|
} else {
|
throw new CoolException("源库位出库失败，状态：" + sourceLoc.getLocSts$());
|
}
|
// 修改目标库位状态
|
if (loc.getLocSts().equals("O")) {
|
loc.setLocSts("S"); // S.入库预约
|
loc.setModiTime(now);
|
loc.setModiUser(userId);
|
if (!locMastService.updateById(loc)) {
|
throw new CoolException("更新目标库位状态失败");
|
}
|
} else {
|
throw new CoolException("移转失败，目标库位状态：" + loc.getLocSts$());
|
}
|
}
|
|
@Override
|
@Transactional
|
public void autoLocMove(String orderNo, String sourceLocNo, String locNo, Long userId) {
|
LocMast sourceLoc = locMastService.selectById(sourceLocNo);
|
List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", sourceLocNo));
|
if (Cools.isEmpty(sourceLoc)) {
|
throw new CoolException("未找到库位");
|
}
|
LocMast loc = locMastService.selectById(locNo);
|
if (Cools.isEmpty(loc)) {
|
throw new CoolException("未找到库位");
|
}
|
|
Date now = new Date();
|
// 获取工作号
|
int workNo = commonService.getWorkNo(WorkNoType.PICK.type);
|
// 保存工作档
|
WrkMast wrkMast = new WrkMast();
|
wrkMast.setWrkNo(workNo);
|
wrkMast.setIoTime(now);
|
wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID
|
wrkMast.setIoType(12); // 入出库状态： 11.库格移载
|
wrkMast.setIoPri(10D);
|
wrkMast.setCrnNo(sourceLoc.getCrnNo());
|
wrkMast.setSourceLocNo(sourceLocNo); // 源库位
|
wrkMast.setLocNo(locNo); // 目标库位
|
wrkMast.setSourceStaNo(crnMapNo.get(sourceLoc.getCrnNo()).get(1)); // 出库源站点
|
wrkMast.setStaNo(crnMapNo.get(loc.getCrnNo()).get(0)); // 入库目标站点
|
wrkMast.setFullPlt(Cools.isEmpty(locDetls) ? "N" : "Y"); // 满板：Y
|
wrkMast.setPicking("N"); // 拣料
|
wrkMast.setExitMk("N"); // 退出
|
wrkMast.setEmptyMk(sourceLoc.getLocSts().equals("D") ? "Y" : "N"); // 空板
|
wrkMast.setBarcode(sourceLoc.getBarcode()); // 托盘码
|
wrkMast.setLinkMis("N");
|
wrkMast.setAppeUser(userId);
|
wrkMast.setAppeTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
boolean res = wrkMastService.insert(wrkMast);
|
if (!res) {
|
throw new CoolException("保存工作档失败");
|
}
|
// 工作档明细保存
|
for (LocDetl locDetl : locDetls) {
|
WrkDetl wrkDetl = new WrkDetl();
|
|
wrkDetl.sync(locDetl);
|
wrkDetl.setOrderNo(orderNo);
|
wrkDetl.setWrkNo(workNo);
|
wrkDetl.setIoTime(now);
|
wrkDetl.setAnfme(locDetl.getAnfme());
|
wrkDetl.setAppeTime(now);
|
wrkDetl.setAppeUser(userId);
|
wrkDetl.setModiTime(now);
|
wrkDetl.setModiUser(userId);
|
if (!wrkDetlService.insert(wrkDetl)) {
|
throw new CoolException("保存工作档明细失败");
|
}
|
}
|
// 修改源库位状态
|
if (sourceLoc.getLocSts().equals("D") || sourceLoc.getLocSts().equals("F")) {
|
sourceLoc.setLocSts("R"); // R.出库预约
|
sourceLoc.setModiUser(userId);
|
sourceLoc.setModiTime(now);
|
if (!locMastService.updateById(sourceLoc)) {
|
throw new CoolException("更新源库位状态失败");
|
}
|
} else {
|
throw new CoolException("源库位出库失败，状态：" + sourceLoc.getLocSts$());
|
}
|
// 修改目标库位状态
|
if (loc.getLocSts().equals("O")) {
|
loc.setLocSts("S"); // S.入库预约
|
loc.setModiTime(now);
|
loc.setModiUser(userId);
|
if (!locMastService.updateById(loc)) {
|
throw new CoolException("更新目标库位状态失败");
|
}
|
} else {
|
throw new CoolException("移转失败，目标库位状态：" + loc.getLocSts$());
|
}
|
}
|
|
@Override
|
@Transactional
|
public void completeWrkMast(String workNo, Long userId) {
|
WrkMast wrkMast = wrkMastService.selectById(workNo);
|
if (Cools.isEmpty(wrkMast)) {
|
throw new CoolException(workNo + "工作档不存在");
|
}
|
if (wrkMast.getWrkSts() == 5 || wrkMast.getWrkSts() == 14 || wrkMast.getWrkSts() == 15) {
|
throw new CoolException("当前工作档已完成");
|
}
|
// 入库 + 库位转移
|
if (wrkMast.getIoType() < 60) {
|
wrkMast.setWrkSts(4L);
|
// 出库
|
} else if (wrkMast.getIoType() > 100 && wrkMast.getIoType() != 103 && wrkMast.getIoType() != 107 && wrkMast.getIoType() != 109) {
|
List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(Integer.valueOf(workNo));
|
openService.ckjgsbPushMes(wrkMast,wrkDetls);
|
wrkMast.setWrkSts(14L);
|
} else {
|
throw new CoolException("当前工作类型或状态无法完成");
|
}
|
Date now = new Date();
|
wrkMast.setCrnStrTime(DateUtils.calculate(now, 1L, TimeUnit.SECONDS, true));
|
wrkMast.setCrnEndTime(now);
|
wrkMast.setModiTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setSheetNo("3");
|
// 完成操作人员记录
|
wrkMast.setManuType("手动完成");
|
if (!wrkMastService.updateById(wrkMast)) {
|
throw new CoolException("修改工作档失败");
|
}
|
}
|
|
@Override
|
@Transactional
|
public void adjustLocDetl(LocDetlAdjustParam param, Long userId) {
|
param.integrate();
|
LocMast locMast = locMastService.selectById(param.getLocNo());
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException("库位不存在");
|
}
|
if (!(locMast.getLocSts().equals("F") || locMast.getLocSts().equals("D") || locMast.getLocSts().equals("O"))) {
|
throw new CoolException("当前库位不可调整！库位状态：" + locMast.getLocSts$());
|
}
|
|
Date now = new Date();
|
List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", param.getLocNo()));
|
|
List<LocDetlAdjustParam.LocDetlAdjust> list = param.getList();
|
|
// 修改数量
|
Iterator<LocDetl> iterator = locDetls.iterator();
|
while (iterator.hasNext()) {
|
LocDetl locDetl = iterator.next();
|
|
Iterator<LocDetlAdjustParam.LocDetlAdjust> iterator1 = list.iterator();
|
while (iterator1.hasNext()) {
|
LocDetlAdjustParam.LocDetlAdjust adjust = iterator1.next();
|
if (adjust.getCount() == 0) {
|
continue;
|
}
|
if (locDetl.getMatnr().equals(adjust.getMatnr()) && Cools.eq(locDetl.getBatch(), adjust.getBatch())) {
|
if (!locDetl.getAnfme().equals(adjust.getCount())) {
|
// todo 盘点记录
|
// 修改库存
|
if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch())) {
|
throw new CoolException(locDetl.getLocNo() + "库位，" + locDetl.getMatnr() + "商品，" + locDetl.getBatch() + "批号修改数量失败");
|
}
|
// 保存调整记录
|
AdjDetl adjDetl = new AdjDetl();
|
adjDetl.setLocNo(locDetl.getLocNo());
|
adjDetl.setMatnr(locDetl.getMatnr());
|
adjDetl.setBatch(locDetl.getBatch());
|
adjDetl.setOriQty(locDetl.getAnfme());
|
adjDetl.setAdjQty(adjust.getCount());
|
adjDetl.setModiTime(now);
|
adjDetl.setModiUser(userId);
|
adjDetl.setAppeTime(now);
|
adjDetl.setAppeUser(userId);
|
adjDetlService.save(adjDetl, userId);
|
}
|
iterator.remove();
|
iterator1.remove();
|
}
|
}
|
}
|
|
// 删除库存
|
for (LocDetl locDetl : locDetls) {
|
// todo 盘点记录
|
if (!locDetlService.updateAnfme(-1.0D, locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch())) {
|
throw new CoolException("删除" + locDetl.getLocNo() + "库位，" + locDetl.getMatnr() + "商品，" + locDetl.getBatch() + "批号库存明细失败");
|
}
|
// 保存调整记录
|
AdjDetl adjDetl = new AdjDetl();
|
adjDetl.setLocNo(locDetl.getLocNo());
|
adjDetl.setMatnr(locDetl.getMatnr());
|
adjDetl.setBatch(locDetl.getBatch());
|
adjDetl.setOriQty(locDetl.getAnfme());
|
adjDetl.setAdjQty(0.0D);
|
adjDetl.setModiTime(now);
|
adjDetl.setModiUser(userId);
|
adjDetl.setAppeTime(now);
|
adjDetl.setAppeUser(userId);
|
adjDetlService.save(adjDetl, userId);
|
}
|
|
// 添加库存
|
for (LocDetlAdjustParam.LocDetlAdjust adjust : list) {
|
if (adjust.getCount() == 0.0D) {
|
continue;
|
}
|
Mat mat = matService.selectByMatnr(adjust.getMatnr());
|
LocDetl locDetl = new LocDetl();
|
locDetl.sync(mat);
|
locDetl.setBatch(adjust.getBatch());
|
locDetl.setLocNo(locMast.getLocNo());
|
locDetl.setAnfme(adjust.getCount()); // 数量
|
locDetl.setModiUser(userId); // 操作人员信息
|
locDetl.setModiTime(now);
|
locDetl.setAppeUser(userId);
|
locDetl.setAppeTime(now);
|
if (!locDetlService.insert(locDetl)) {
|
throw new CoolException("添加" + locDetl.getLocNo() + "库位，" + locDetl.getMatnr() + "商品，" + locDetl.getBatch() + "批号库存明细失败");
|
}
|
// 保存调整记录
|
AdjDetl adjDetl = new AdjDetl();
|
adjDetl.setLocNo(locMast.getLocNo());
|
adjDetl.setMatnr(adjust.getMatnr());
|
adjDetl.setBatch(adjust.getBatch());
|
adjDetl.setOriQty(0.0D);
|
adjDetl.setAdjQty(adjust.getCount());
|
adjDetl.setModiTime(now);
|
adjDetl.setModiUser(userId);
|
adjDetl.setAppeTime(now);
|
adjDetl.setAppeUser(userId);
|
adjDetlService.save(adjDetl, userId);
|
}
|
// 修改库位状态
|
int count = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("loc_no", locMast.getLocNo()));
|
if (locMast.getLocSts().equals("F")) {
|
if (count == 0) {
|
locMast.setLocSts("D");
|
}
|
}
|
if (locMast.getLocSts().equals("D") || locMast.getLocSts().equals("O")) {
|
if (count > 0) {
|
locMast.setLocSts("F");
|
}
|
}
|
locMast.setModiUser(userId);
|
locMast.setModiTime(now);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("更新库位状态失败");
|
}
|
}
|
|
|
@Override
|
@Transactional
|
public void cancelWrkMast(String workNo, Long userId) {
|
Date now = new Date();
|
WrkMast wrkMast = wrkMastService.selectById(workNo);
|
if (Cools.isEmpty(wrkMast)) {
|
throw new CoolException(workNo + "工作档不存在");
|
}
|
String locNo = ""; // 待修改目标库位
|
String locSts = ""; // 待修改目标库位状态
|
// 入库取消（修改目标库位）
|
if (wrkMast.getWrkSts() == 1) {
|
locNo = wrkMast.getLocNo();
|
locSts = "O";
|
|
// 库位转移
|
if (wrkMast.getIoType() == 11) {
|
// 库位转移：源库位
|
LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo());
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException("取消库位转移失败，源库位不存在:" + wrkMast.getSourceLocNo());
|
}
|
locMast.setLocSts(wrkMast.getFullPlt().equalsIgnoreCase("N") ? "D" : "F");
|
locMast.setModiTime(now);
|
locMast.setModiUser(userId);
|
locMastService.updateById(locMast);
|
}
|
// 出库取消（修改源库位）
|
} else if (wrkMast.getWrkSts() == 11) {
|
locNo = wrkMast.getSourceLocNo();
|
// 出库 ===>> F.在库
|
if (wrkMast.getIoType() > 100 && wrkMast.getIoType() != 110) {
|
locSts = "F";
|
// 空板出库 ===>> D.空桶/空栈板
|
} else if (wrkMast.getIoType() == 110) {
|
locSts = "D";
|
// 库位转移 ===>> D.空桶/空栈板
|
} else if (wrkMast.getIoType() == 11 || wrkMast.getIoType() == 12) {
|
locSts = wrkMast.getFullPlt().equalsIgnoreCase("N") ? "D" : "F";
|
// 库位转移：目标库位
|
LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException("取消库位转移失败，目标库位不存在:" + wrkMast.getSourceLocNo());
|
}
|
locMast.setLocSts("O");
|
locMast.setModiTime(now);
|
locMast.setModiUser(userId);
|
locMastService.updateById(locMast);
|
}
|
} else {
|
throw new CoolException("当前工作状态无法取消");
|
}
|
|
//取消入库工作档时，查询组托表，如果有将状态改为待处理
|
if (wrkMast.getIoType() == 1) {
|
List<WaitPakin> waitPakins = waitPakinService.selectList(new EntityWrapper<WaitPakin>().eq("zpallet", wrkMast.getBarcode()));
|
for (WaitPakin waitPakin : waitPakins) {
|
if (!Cools.isEmpty(waitPakin)) {
|
waitPakin.setIoStatus("N");
|
waitPakin.setLocNo("");
|
waitPakinService.update(waitPakin, new EntityWrapper<WaitPakin>()
|
// .eq("order_no", waitPakin.getOrderNo())
|
.eq("zpallet", waitPakin.getZpallet())
|
.eq("matnr", waitPakin.getMatnr())
|
.eq("batch", waitPakin.getBatch()));
|
}
|
}
|
}
|
|
// 取消跨巷道移库任务时，回滚在执行的任务
|
if (wrkMast.getIoType() == 12) {
|
List<Order> orderList = orderMapper.selectList(new EntityWrapper<Order>().eq("doc_type", 24).lt("settle", 3));
|
if (orderList.size() == 1) {
|
Order order = orderList.get(0);
|
// 回滚单据明细的移库状态
|
List<OrderDetl> orderDetlList1 = orderDetlMapper.selectList(new EntityWrapper<OrderDetl>().eq("order_no", order.getOrderNo()).eq("specs", wrkMast.getSourceLocNo()));
|
for (OrderDetl orderDetl : orderDetlList1) {
|
if (orderDetl.getBeBatch() != null) {
|
orderDetl.setModel("");
|
}
|
orderDetl.setUpdateTime(now);
|
orderDetl.setDanger(0);
|
orderDetlMapper.updateById(orderDetl);
|
}
|
// 回滚单据状态，有大于0的订单明细则是作业中，没有则更新为待处理
|
Integer count = orderDetlMapper.selectCount(new EntityWrapper<OrderDetl>().eq("order_no", order.getOrderNo()).gt("danger", 0));
|
if (count == 0) {
|
order.setSettle(1L);
|
orderMapper.updateById(order);
|
}
|
} else {
|
log.error("回滚移库单据异常，无源库位数据：{}", wrkMast.getSourceLocNo());
|
}
|
}
|
|
// // 取消空闲理货任务时，回滚成未理货
|
// if (wrkMast.getIoType() == 109) {
|
// // 更新库存明细为理货中
|
// locDetlMapper.updateLhStsByLocNo(wrkMast.getSourceLocNo(),0);
|
// }
|
|
//取消出库工作档时，查询单据管理表，回滚作业中数量
|
if (wrkMast.getIoType() == 101 || wrkMast.getIoType() == 103 || wrkMast.getIoType() == 107) {
|
List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
|
for (WrkDetl wrkDetl : wrkDetls) {
|
if (!Cools.isEmpty(wrkDetl.getOrderNo())) {
|
// if (!orderDetlService.decrease(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getAnfme())) {
|
// throw new CoolException("订单数据回滚失败");
|
// }
|
orderDetlMapper.updateOrderDetlByGroupNo(wrkDetl.getOrderNo(), wrkDetl.getBrand(), 0);
|
|
//修改订单主表状态,没有作业数量时才可以修改
|
boolean flag = true;
|
List<OrderDetl> orderDetls = orderDetlService.selectList(new EntityWrapper<OrderDetl>().eq("order_no", wrkDetl.getOrderNo()));
|
for (OrderDetl orderDetl : orderDetls) {
|
if (orderDetl.getWorkQty() > 0) {
|
flag = false;
|
}
|
}
|
if (flag) {
|
Order order = orderService.selectOne(new EntityWrapper<Order>().eq("order_no", wrkDetl.getOrderNo()));
|
if (!Cools.isEmpty(order) && order.getSettle() == 2) {
|
order.setSettle(1L);
|
order.setUpdateBy(userId);
|
order.setUpdateTime(now);
|
}
|
if (!orderService.update(order, new EntityWrapper<Order>().eq("order_no", wrkDetl.getOrderNo()))) {
|
throw new CoolException("修改订单状态失败");
|
}
|
}
|
}
|
}
|
|
}
|
|
// // 订单关联
|
// List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
|
// for (WrkDetl wrkDetl : wrkDetls) {
|
// if (!Cools.isEmpty(wrkDetl.getOrderNo())) {
|
// if (!orderDetlService.decrease(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getAnfme())) {
|
// throw new CoolException("订单数据回滚失败");
|
// }
|
// // 生成新的出库作业
|
//// stockOutRe(wrkMast, wrkDetls);
|
// }
|
// }
|
|
// 取消操作人员记录
|
wrkMast.setManuType("手动取消");
|
wrkMast.setModiUser(userId);
|
wrkMast.setModiTime(now);
|
if (!wrkMastService.updateById(wrkMast)) {
|
throw new CoolException("取消工作档失败");
|
}
|
// 保存工作主档历史档
|
if (!wrkMastLogService.save(wrkMast.getWrkNo())) {
|
throw new CoolException("保存工作历史档失败, workNo = " + wrkMast.getWrkNo());
|
}
|
// 删除工作主档
|
boolean wrkMastRes = wrkMastService.deleteById(wrkMast);
|
|
if (wrkMast.getIoType() != 10 && wrkMast.getIoType() != 110) {
|
// 保存工作明细档历史档
|
if (!wrkDetlLogService.save(wrkMast.getWrkNo())) {
|
// throw new CoolException("保存工作明细历史档失败, workNo = " + wrkMast.getWrkNo());
|
}
|
// 删除工作档明细
|
boolean wrkDetlRes = wrkDetlService.delete(new EntityWrapper<WrkDetl>().eq("wrk_no", workNo));
|
}
|
if (wrkMast.getIoType() == 202 || wrkMast.getIoType() == 212) {
|
return;
|
}
|
|
// 修改库位状态
|
LocMast locMast = locMastService.selectById(locNo);
|
if (Cools.isEmpty(locMast)) {
|
throw new CoolException("取消工作档失败，库位不存在:" + locNo);
|
}
|
locMast.setLocSts(locSts);
|
locMast.setModiTime(now);
|
locMast.setModiUser(userId);
|
boolean locMastRes = locMastService.updateById(locMast);
|
if (!wrkMastRes || !locMastRes) {
|
throw new CoolException("保存数据失败");
|
}
|
}
|
|
@Override
|
@Transactional
|
public void pickWrkMast(String workNo, Long userId) {
|
WrkMast wrkMast = wrkMastService.selectById(workNo);
|
if (Cools.isEmpty(wrkMast)) {
|
throw new CoolException(workNo + "工作档不存在");
|
}
|
// 入出库类型判断
|
if (wrkMast.getIoType() != 103 && wrkMast.getIoType() != 104 && wrkMast.getIoType() != 107) {
|
throw new CoolException("当前入出库类型无法进行操作");
|
}
|
// 工作状态判断
|
if (wrkMast.getWrkSts() < 11 || wrkMast.getWrkSts() == 15) {
|
throw new CoolException("当前工作状态无法进行操作");
|
}
|
// 保存工作明细档历史档
|
// if (!wrkDetlLogService.save(wrkMast.getWrkNo())) {
|
// throw new CoolException("保存工作明细档历史档失败");
|
// }
|
// 保存工作主档历史档
|
if (!wrkMastLogService.save(wrkMast.getWrkNo())) {
|
throw new CoolException("保存工作主档历史档失败");
|
}
|
// 获取目标站
|
Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
|
.eq("type_no", wrkMast.getIoType() - 50)
|
.eq("stn_no", wrkMast.getStaNo()) // 作业站点 = 拣料出库的目标站
|
.eq("crn_no", wrkMast.getCrnNo()); // 堆垛机号
|
StaDesc staDesc = staDescService.selectOne(wrapper);
|
if (Cools.isEmpty(staDesc)) {
|
throw new CoolException("入库路径不存在");
|
}
|
Date now = new Date();
|
// 堆垛机站点(目标站)
|
Integer staNo = staDesc.getCrnStn();
|
// 更新工作档数据状态
|
wrkMast.setIoType(wrkMast.getIoType() - 50); // 入出库类型: 103->53,104->54,107->57
|
wrkMast.setWrkSts(2L); // 工作状态: 2.设备上走
|
wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 源站
|
wrkMast.setStaNo(staNo); // 目标站
|
wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 目标库位 = 出库时的源库位
|
wrkMast.setSourceLocNo(""); // 源库位清空
|
wrkMast.setModiTime(now);
|
wrkMast.setModiUser(userId);
|
if (!wrkMastService.updateById(wrkMast)) {
|
throw new CoolException("更新工作档数据状态失败");
|
}
|
// 修改库位状态 Q.拣料/盘点/并板再入库
|
LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
|
locMast.setLocSts("Q");
|
locMast.setModiTime(now);
|
locMast.setModiUser(userId);
|
if (!locMastService.updateById(locMast)) {
|
throw new CoolException("修改库位状态失败");
|
}
|
}
|
|
@Override
|
public StartupDto createWaitPainWrkMastStart(List<WaitPakin> list, Long userId) {
|
if (Cools.isEmpty(list)) {
|
throw new CoolException("入库通知档不能为空");
|
}
|
LocTypeDto locTypeDto = new LocTypeDto();
|
locTypeDto.setLocType1((short) 1);
|
return wcsController.startupFullPutStore(301, list.get(0).getZpallet(), locTypeDto, list);
|
}
|
|
@Override
|
@Transactional
|
public String dealPreHaveStart(Integer wrkNo, Long userId) {
|
WrkMast wrkMast = wrkMastService.selectById(wrkNo);
|
if (wrkMast == null) {
|
throw new CoolException("任务已失效");
|
}
|
String locNo = wrkMast.getLocNo();
|
LocMast locMast = locMastService.selectById(locNo);
|
assert locMast != null;
|
RowLastno rowLastno = rowLastnoService.findBySection(locMast.getRow1());
|
assert rowLastno != null;
|
|
// 目标库位
|
LocMast targetLoc = null;
|
|
for (int curRow = rowLastno.getsRow(); curRow <= rowLastno.geteRow(); curRow++) {
|
|
if (Utils.isShallowLoc(slaveProperties, curRow)) {
|
Integer deepRow = Utils.getDeepRow(slaveProperties, curRow);
|
targetLoc = locMastService.queryFreeLocMast(deepRow, locMast.getLocType1());
|
// 因库位移转、需预留空库位
|
if (!locMastService.checkEmptyCount(targetLoc)) {
|
continue;
|
}
|
}
|
if (Cools.isEmpty(targetLoc)) {
|
targetLoc = locMastService.queryFreeLocMast(curRow, locMast.getLocType1());
|
// 因库位移转、需预留空库位
|
if (!locMastService.checkEmptyCount(targetLoc)) {
|
continue;
|
}
|
// 目标库位 ===>> 浅库位， 则校验其深库位是否为 F D X
|
if (null != targetLoc && Utils.isShallowLoc(slaveProperties, targetLoc.getLocNo())) {
|
LocMast deepLoc = locMastService.selectById(Utils.getDeepLoc(slaveProperties, targetLoc.getLocNo()));
|
if (!deepLoc.getLocSts().equals("F") && !deepLoc.getLocSts().equals("D") && !deepLoc.getLocSts().equals("X")) {
|
continue;
|
}
|
}
|
// 目标库位 ===>> 深库位， 则校验其浅库位是否为 O
|
if (null != targetLoc && Utils.isDeepLoc(slaveProperties, targetLoc.getLocNo())) {
|
LocMast shallowLoc = locMastService.selectById(Utils.getShallowLoc(slaveProperties, targetLoc.getLocNo()));
|
if (!shallowLoc.getLocSts().equals("O")) {
|
continue;
|
}
|
}
|
}
|
|
if (!Cools.isEmpty(targetLoc)) {
|
break;
|
}
|
|
}
|
|
if (targetLoc == null) {
|
throw new CoolException("操作失败，当前仓库找不到空库位");
|
}
|
|
Date now = new Date();
|
// 修改工作档
|
StaDesc staDesc = staDescService.queryCrnStn(targetLoc.getCrnNo());
|
if (Cools.isEmpty(staDesc)) {
|
throw new CoolException("入库路径不存在");
|
}
|
wrkMast.setWrkSts(2L);
|
wrkMast.setLocNo(targetLoc.getLocNo());
|
wrkMast.setStaNo(staDesc.getCrnStn());
|
wrkMast.setCrnNo(targetLoc.getCrnNo());
|
wrkMast.setModiTime(now);
|
wrkMast.setModiUser(userId);
|
wrkMast.setPreHave("N");
|
if (!wrkMastService.updateById(wrkMast)) {
|
throw new CoolException("修改工作档失败");
|
}
|
// 修改库位状态 O ===>>> S
|
if (targetLoc.getLocSts().equals("O")) {
|
targetLoc.setLocSts("S"); // S.入库预约
|
targetLoc.setModiUser(userId);
|
targetLoc.setModiTime(now);
|
if (!locMastService.updateById(targetLoc)) {
|
throw new CoolException("改变库位状态失败");
|
}
|
} else {
|
throw new CoolException(targetLoc.getLocNo() + "目标库位已被占用");
|
}
|
// 禁用异常库位
|
// locMast.setLocSts("X"); // X.禁用
|
// locMast.setModiUser(userId);
|
// locMast.setModiTime(now);
|
// if (!locMastService.updateById(locMast)){
|
// throw new CoolException("改变库位状态失败");
|
// }
|
return targetLoc.getLocNo();
|
}
|
|
@Override
|
@Transactional
|
public void turnMatLocDetl(EmptyPlateOutParam param, Long userId) {
|
Mat mat = matService.selectOne(new EntityWrapper<Mat>().eq("id", param.getMatId()));
|
if (Cools.isEmpty(mat)) {
|
throw new CoolException("目标库位商品编码有误！");
|
}
|
List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("matnr", param.getLocDetls().get(0).getMatnr()));
|
if (Cools.isEmpty(locDetls) || locDetls.size() < 1) {
|
throw new CoolException("待修改商品无库存，无需修改！ 规格：" + param.getLocDetls().get(0).getMatnr());
|
}
|
try {
|
locDetlService.updateMatTurn(param.getLocDetls().get(0).getMatnr(), mat.getMatnr());
|
} catch (Exception e) {
|
throw new CoolException("对数据库修改出错！");
|
}
|
for (LocDetl locDetl : locDetls) {
|
// 保存调整记录
|
AdjDetl adjDetl = new AdjDetl();
|
adjDetl.setLocNo(locDetl.getLocNo());
|
adjDetl.setMatnr(mat.getMatnr());
|
adjDetl.setMatnrOld(param.getLocDetls().get(0).getMatnr());
|
adjDetl.setAdjQty(locDetl.getAnfme());
|
adjDetlService.save(adjDetl, userId);
|
}
|
}
|
|
}
|
