package com.zy.common.service; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.core.common.Cools; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.service.*; import com.zy.asrs.utils.Utils; import com.zy.asrs.utils.VersionUtils; import com.zy.common.model.LocTypeDto; import com.zy.common.model.StartupDto; import com.zy.common.properties.SlaveProperties; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.List; /** * 货架核心功能 * Created by vincent on 2020/6/11 */ @Slf4j @Service public class CommonService { public static final List FIRST_GROUP_ROW_LIST = new ArrayList() {{ add(1);add(2);add(3);add(4);add(5);add(6);add(7);add(8);add(9);add(10); }}; public static final List FIRST_GROUP_ROW_LIST_SHORT = new ArrayList() {{ add(8);add(9);add(10); }}; public static final List SECOND_GROUP_ROW_LIST = new ArrayList() {{ add(12);add(13);add(14);add(15);add(16);add(17);add(18); }}; public static final List THIRD_GROUP_ROW_LIST = new ArrayList() {{ add(20);add(21);add(22);add(23); }}; @Autowired private WrkMastService wrkMastService; @Autowired private WrkLastnoService wrkLastnoService; @Autowired private RowLastnoService rowLastnoService; @Autowired private BasCrnpService basCrnpService; @Autowired private StaDescService staDescService; @Autowired private BasDevpService basDevpService; @Autowired private LocMastService locMastService; @Autowired private LocDetlService locDetlService; @Autowired private SlaveProperties slaveProperties; /** * 生成工作号 * @param wrkMk 0:入出库 ; 1:其他 * @return workNo(工作号) */ public int getWorkNo(Integer wrkMk) { WrkLastno wrkLastno = wrkLastnoService.selectById(wrkMk); if (Cools.isEmpty(wrkLastno)) { throw new CoolException("数据异常,请联系管理员"); } int workNo = 0; // 入出库类型 workNo = wrkLastno.getWrkNo(); int sNo = wrkLastno.getSNo(); int eNo = wrkLastno.getENo(); workNo = workNo>=eNo ? sNo : workNo+1; while (true) { WrkMast wrkMast = wrkMastService.selectById(workNo); if (null != wrkMast) { workNo = workNo>=eNo ? sNo : workNo+1; } else { break; } } if (workNo > 0){ wrkLastno.setWrkNo(workNo); wrkLastnoService.updateById(wrkLastno); } if (workNo == 0) { throw new CoolException("生成工作号失败,请联系管理员"); } else { if (wrkMastService.selectById(workNo)!=null) { throw new CoolException("生成工作号" + workNo + "在工作档中已存在"); } } return workNo; } public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List matNos, LocTypeDto locTypeDto, int times) { return getLocNo(staDescId, sourceStaNo, matNos, locTypeDto, times); } /** * 检索库位号 * @param staDescId 路径ID * @param sourceStaNo 源站 * @param matNos 物料号集合 * @return locNo 检索到的库位号 */ public StartupDto getLocNo(Integer staDescId, Integer sourceStaNo, List matNos, LocTypeDto locTypeDto,int times) { StartupDto startupDto = new StartupDto(); // 目标库位 LocMast locMast = null; // 靠近摆放规则 --- 相同订单号, 同天同规格物料 if (!Cools.isEmpty(matNos) && matNos.size() == 1 && staDescId == 1) { //先判断工作档,查找主档IOType=1, wrkSts < 10的工作明细,料号相同的明细库位 List wrkMasts = wrkMastService.selectSameMatnrs(matNos.get(0)); for (WrkMast wrkMast : wrkMasts) { LocMast locMast0 = locMastService.findNearloc(wrkMast.getLocNo()); if (null != locMast0) { // 浅库位符合尺寸检测 if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) { locMast = locMast0; break; } } } if (Cools.isEmpty(locMast)) { //再判断库存明细档,料号相同的明细库位 List locNos = locDetlService.getSameDetl(matNos.get(0)); for (String locNo : locNos) { LocMast locMast0 = locMastService.findNearloc(locNo); if (null != locMast0) { // 浅库位符合尺寸检测 if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) { locMast = locMast0; break; } } } } } // 靠近摆放规则 --- 空托 if (staDescId == 10) { //先判断工作档,查找主档IOType=1, wrkSts < 10的工作明细,料号相同的明细库位 List wrkMasts = wrkMastService.selectList(new EntityWrapper().eq("io_type",10)); for (WrkMast wrkMast : wrkMasts) { LocMast locMast0 = locMastService.findNearloc(wrkMast.getLocNo()); if (null != locMast0) { // 浅库位符合尺寸检测 if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) { locMast = locMast0; break; } } } if (Cools.isEmpty(locMast)){ List locMasts = locMastService.selectList(new EntityWrapper() .eq("loc_sts", "D")); if (locMasts.size() > 0) { for (LocMast loc : locMasts) { LocMast locMast0 = locMastService.findNearloc(loc.getLocNo()); if (null != locMast0) { // 浅库位符合尺寸检测 if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) { locMast = locMast0; break; } } } } } } // 如果没有相近物料,则按规则轮询货架 // 获取目标站 Wrapper wrapper = new EntityWrapper() .eq("type_no", staDescId) .eq("stn_no", sourceStaNo); StaDesc staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { log.error("入库路径不存在, staDescId={}, sourceStaNo={}", staDescId, sourceStaNo); throw new CoolException("入库路径不存在"); } // 检测目标站 BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn()); if (!staNo.getAutoing().equals("Y")) { throw new CoolException("目标站" + staDesc.getCrnStn() + "不可用"); } // 开始查找库位 ==============================>> // 1.当检索库排为浅库位排时,优先寻找当前库排的深库位排 if (locMast == null) { List peakLocs = locMastService.selectAllPeakLoc(); for (LocMast peakLoc : peakLocs) { List groupInsideLoc = Utils.getGroupInsideLoc(peakLoc.getLocNo()); if (!Cools.isEmpty(groupInsideLoc)){ if (!locMastService.checkAllLocEmpty(groupInsideLoc)) continue; locMast = peakLoc; break; }else { locMast=peakLoc; break; } } } // 2.库位当前所属尺寸无空库位时,调整尺寸参数,向上兼容检索库位 if (Cools.isEmpty(locMast)) { log.error("系统没有空库位!!! 尺寸规格: {}, 轮询次数:{}", JSON.toJSONString(locTypeDto), times); throw new CoolException("没有空库位"); } String locNo = locMast.getLocNo(); // 生成工作号 int workNo = getWorkNo(0); // 返回dto startupDto.setWorkNo(workNo); startupDto.setSourceStaNo(sourceStaNo); startupDto.setStaNo(staNo.getDevNo()); startupDto.setLocNo(locNo); return startupDto; } }