package com.zy.asrs.service.impl; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.service.impl.ServiceImpl; import com.core.common.Cools; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.StockOutParam; import com.zy.asrs.mapper.OutStockMapper; import com.zy.asrs.service.*; import com.zy.asrs.utils.VersionUtils; import com.zy.common.model.LocDetlDto; import com.zy.common.model.OutLocDto; import com.zy.common.service.CommonService; import com.zy.common.service.erp.entity.OutStockBillEntry; import io.swagger.models.auth.In; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.util.*; @Service("outStockService") public class OutStockServiceImpl extends ServiceImpl implements OutStockService{ // 工作号生成规则默认类型 private static final int DEFAULT_WORK_NO_TYPE = 0; @Autowired private WrkMastService wrkMastService; @Autowired private BasDevpService basDevpService; @Autowired private LocDetlService locDetlService; @Autowired private LocMastService locMastService; @Autowired private StaDescService staDescService; @Autowired private CommonService commonService; @Autowired private WrkDetlService wrkDetlService; @Override public Page queryOutStock(Page page) { page.setRecords(baseMapper.queryOutStock(page.getCondition())); page.setTotal(baseMapper.queryOutStockCount(page.getCondition())); return page; } @Override public List queryMatWithLoc(String fbillNo) { List matList = baseMapper.queryMatnrWithBillNo(fbillNo); List tempLocList = new ArrayList(); List locList = new ArrayList(); for (Integer i = 0; i < matList.size(); i++) { /*自动根据物料编码选取最优出货顺序(先进先出,靠外货物先出)*/ tempLocList = baseMapper.queryMatWithLoc(matList.get(i).getFNumber()); BigDecimal needNum = matList.get(i).getFAuxQty(); BigDecimal locNum = BigDecimal.ZERO; if (tempLocList.size() > 0) { for (Integer j = 0; j < tempLocList.size(); j ++) { locNum = locNum.add(new BigDecimal(tempLocList.get(j).getAnfme())); /* 计算需要的数量,符合数量后结束循环 */ if (needNum.compareTo(locNum) == 1) { locList.add(tempLocList.get(j)); } else { locList.add(tempLocList.get(j)); break; } } } } return locList; } @Override @Transactional public void startupFullTakeStore(StockOutParam param, Long userId) { // 目标站点状态检测 BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite()); // 获取库位明细 List locDetlDtos = new ArrayList<>(); for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) { LocDetl sqlParam = new LocDetl(); sqlParam.setLocNo(paramLocDetl.getLocNo()); sqlParam.setMatnr(paramLocDetl.getMatnr()); LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount())); } } if (!locDetlDtos.isEmpty()) { // 启动出库开始 101.出库 stockOut(staNo, locDetlDtos, null, userId, param.getFbillNo()); } else { throw new CoolException("库位物料不存在"); } } // @Override @Transactional public void stockOut(BasDevp staNo, List locDetlDtos, Integer ioType, Long userId, String fbillNo) { // 合并同类项 Set locNos = new HashSet<>(); locDetlDtos.forEach(dto -> locNos.add(dto.getLocDetl().getLocNo())); List dtos = new ArrayList<>(); for (String locNo : locNos) { List list = new ArrayList<>(); Iterator iterator = locDetlDtos.iterator(); while (iterator.hasNext()) { LocDetlDto dto = iterator.next(); if (locNo.equals(dto.getLocDetl().getLocNo())) { list.add(dto); iterator.remove(); } } dtos.add(new OutLocDto(locNo, list)); } // 生成工作档 for (OutLocDto dto : dtos) { // 判断入出库类型:101.全板出库 or 103.拣料出库 if (ioType == null) { ioType = dto.isAll() ? 101 : 103; } // 获取库位 LocMast locMast = locMastService.selectById(dto.getLocNo()); // 获取路径 Wrapper wrapper = new EntityWrapper() .eq("type_no", ioType) .eq("stn_no", staNo.getDevNo()) .eq("crn_no", locMast.getCrnNo()); StaDesc staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { throw new CoolException("出库路径不存在"); } // 生成工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); 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.setAppeUser(userId); // 操作人员数据 wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); if (!wrkMastService.insert(wrkMast)) { throw new CoolException("保存工作档失败,出库库位号:"+dto.getLocNo()); } // 生成工作档明细 for (LocDetlDto detlDto : dto.getLocDetlDtos()) { // 出库时,数量为0的直接忽略 if (detlDto.getCount()==null || detlDto.getCount() <= 0.0D) {continue;} WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(new Date()); Double anfme = ioType==101?detlDto.getLocDetl().getAnfme():detlDto.getCount(); wrkDetl.setAnfme(anfme); // 数量 VersionUtils.setWrkDetl(wrkDetl, detlDto.getLocDetl()); // 版本控制 wrkDetl.setAppeTime(new Date()); wrkDetl.setAppeUser(userId); wrkDetl.setModiTime(new Date()); wrkDetl.setModiUser(userId); wrkDetl.setWarehouse(fbillNo); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作档明细失败"); } } // 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中 locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("F")) { locMast.setLocSts(ioType==101?"R":"P"); locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)) { throw new CoolException("预约库位状态失败,库位号:"+dto.getLocNo()); } } else { throw new CoolException(dto.getLocNo() + "库位不是在库状态"); } } // todo:luxiaotao // 同一列的同时出库,则优先出浅库位 } }