|  |  | 
 |  |  | 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.Shelves; | 
 |  |  | 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 org.springframework.transaction.annotation.Transactional; | 
 |  |  |  | 
 |  |  | import java.util.List; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  |  * 双深式货架核心功能 | 
 |  |  |  * 货架核心功能 | 
 |  |  |  * Created by vincent on 2020/6/11 | 
 |  |  |  */ | 
 |  |  | @Slf4j | 
 |  |  | @Service | 
 |  |  | public class CommonService { | 
 |  |  |  | 
 |  |  | 
 |  |  |     private BasDevpService basDevpService; | 
 |  |  |     @Autowired | 
 |  |  |     private LocMastService locMastService; | 
 |  |  |     @Autowired | 
 |  |  |     private LocDetlService locDetlService; | 
 |  |  |     @Autowired | 
 |  |  |     private SlaveProperties slaveProperties; | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 生成工作号 | 
 |  |  |      * @param wrkMk 0:入出库 ; 1:其他 | 
 |  |  |      * @param wrkMk 0:入库 1 - 3000 ; 1:拣料/并板/盘点 3001 - 6000 ; 2: 出库 6001 -9000 ; 3:其他 9001 -9999 | 
 |  |  |      * @return workNo(工作号) | 
 |  |  |      */ | 
 |  |  |     public int getWorkNo(Integer wrkMk) { | 
 |  |  | 
 |  |  |         if (Cools.isEmpty(wrkLastno)) { | 
 |  |  |             throw new CoolException("数据异常,请联系管理员"); | 
 |  |  |         } | 
 |  |  |         int workNo = 0; | 
 |  |  |         // 入出库类型 | 
 |  |  |         if (wrkLastno.getWrkMk() == 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; | 
 |  |  |                 } | 
 |  |  |         int 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){ | 
 |  |  |                 // todo | 
 |  |  |                 wrkLastno.setWrkNo(workNo); | 
 |  |  |                 wrkLastnoService.updateById(wrkLastno); | 
 |  |  |         } | 
 |  |  |         // 修改序号记录 | 
 |  |  |         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; | 
 |  |  | 
 |  |  |     /** | 
 |  |  |      * 检索库位号 | 
 |  |  |      * @param whsType 类型 1:双深式货架 | 
 |  |  |      * @param staDescId 路径工作类型 | 
 |  |  |      * @param sourceStaNo 源站 | 
 |  |  |      * @param matNos 商品编号集合 | 
 |  |  |      * @return locNo 检索到的库位号 | 
 |  |  |      */ | 
 |  |  |     public String getLocNo(Integer whsType, String sourceStaNo) { | 
 |  |  |     @Transactional | 
 |  |  |     public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, int times) { | 
 |  |  |         whsType = getWhsType(sourceStaNo, times); | 
 |  |  |         StartupDto startupDto = new StartupDto(); | 
 |  |  |         // 生成工作号 | 
 |  |  |         int workNo = getWorkNo(0); | 
 |  |  |         RowLastno rowLastno = rowLastnoService.selectById(whsType); | 
 |  |  |         if (Cools.isEmpty(rowLastno)) { | 
 |  |  |             throw new CoolException("数据异常,请联系管理员"); | 
 |  |  |         } | 
 |  |  |         String locNo = null; | 
 |  |  |         if (rowLastno.getWhsType() == 1){ | 
 |  |  |             int curRow = rowLastno.getCurrentRow(); | 
 |  |  |             int sRow = rowLastno.getsRow(); | 
 |  |  |             int eRow = rowLastno.geteRow(); | 
 |  |  |             int crn_qty = rowLastno.getCrnQty(); | 
 |  |  |  | 
 |  |  |             // 获取目标站所在货架排号 | 
 |  |  |             Shelves shelves = new Shelves(8, crn_qty); | 
 |  |  |             curRow = shelves.start(curRow); | 
 |  |  |             if (curRow < 0) { | 
 |  |  |                 throw new CoolException("检索库位失败,请联系管理员"); | 
 |  |  |             } | 
 |  |  |             // 堆垛机号 | 
 |  |  |             int crnNo = 0; | 
 |  |  |             for (List<Integer> node : shelves.nodes){ | 
 |  |  |                 if (node.contains(curRow)) { | 
 |  |  |                     crnNo = shelves.nodes.indexOf(node) + 1; | 
 |  |  |         // ===============>>>> 开始执行 | 
 |  |  |         int curRow = rowLastno.getCurrentRow(); | 
 |  |  |         int sRow = rowLastno.getsRow(); | 
 |  |  |         int eRow = rowLastno.geteRow(); | 
 |  |  |         int crn_qty = rowLastno.getCrnQty(); | 
 |  |  |         int rowCount = eRow - sRow + 1; | 
 |  |  |         // 目标堆垛机号 | 
 |  |  |         int crnNo = 0; | 
 |  |  |         // 目标库位 | 
 |  |  |         LocMast locMast = null; | 
 |  |  |  | 
 |  |  |         // 靠近摆放规则 --- 同天同规格物料 | 
 |  |  |         if (!Cools.isEmpty(matNos)) { | 
 |  |  |             List<String> locNos = locDetlService.getSameDetlToday(matNos.get(0), sRow, eRow); | 
 |  |  |             for (String locNo : locNos) { | 
 |  |  |                 if (Utils.isShallowLoc(slaveProperties, locNo)) { | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 String shallowLocNo = Utils.getShallowLoc(slaveProperties, locNo); | 
 |  |  |                 // 检测目标库位是否为空库位 | 
 |  |  |                 LocMast shallowLoc = locMastService.selectById(shallowLocNo); | 
 |  |  |                 if (shallowLoc != null && shallowLoc.getLocSts().equals("O")) { | 
 |  |  |                     if (VersionUtils.locMoveCheckLocType(shallowLoc, locTypeDto)) { | 
 |  |  |                         if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) { | 
 |  |  |                             locMast = shallowLoc; | 
 |  |  |                             crnNo = locMast.getCrnNo(); | 
 |  |  |                             break; | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             BasCrnp crnp = basCrnpService.selectById(crnNo); | 
 |  |  |             if (Cools.isEmpty(crnp)) { | 
 |  |  |                 throw new CoolException("堆垛机编号错误"); | 
 |  |  |             } | 
 |  |  |             if (!"Y".equals(crnp.getInEnable())) { | 
 |  |  |                 throw new CoolException("当前堆垛机无法入库"); | 
 |  |  |             } | 
 |  |  |             // 获取目标站 | 
 |  |  |             Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() | 
 |  |  |                     .eq("type_no", 1) | 
 |  |  |                     .eq("stnNo", sourceStaNo) | 
 |  |  |                     .eq("crn_no", crnNo); | 
 |  |  |             StaDesc staDesc = staDescService.selectOne(wrapper); | 
 |  |  |             if (Cools.isEmpty(staDesc)) { | 
 |  |  |                 throw new CoolException("入库路径不存在"); | 
 |  |  |             } | 
 |  |  |             BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn()); | 
 |  |  |             int inQty = staNo.getInQty(); | 
 |  |  |             if (staNo.getInEnable().equals("Y") && staNo.getAutoing().equals("Y") && inQty<2) { | 
 |  |  |                 // 查找库位 todo | 
 |  |  |                 LocMast locMast = locMastService.queryFreeLocMast(curRow, 1); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |             rowLastno.setCurrentRow(curRow); | 
 |  |  |             rowLastnoService.updateById(rowLastno); | 
 |  |  |         } | 
 |  |  |         return locNo; | 
 |  |  |  | 
 |  |  |         // 靠近摆放规则 --- 空托 | 
 |  |  |         if (staDescId == 10) { | 
 |  |  |             List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow)); | 
 |  |  |             if (locMasts.size() > 0) { | 
 |  |  |                 for (LocMast loc : locMasts) { | 
 |  |  |                     if (Utils.isShallowLoc(slaveProperties, loc.getLocNo())) { | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |                     String shallowLocNo = Utils.getShallowLoc(slaveProperties,  loc.getLocNo()); | 
 |  |  |                     // 检测目标库位是否为空库位 | 
 |  |  |                     LocMast shallowLoc = locMastService.selectById(shallowLocNo); | 
 |  |  |                     if (shallowLoc != null && shallowLoc.getLocSts().equals("O")) { | 
 |  |  |                         if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) { | 
 |  |  |                             locMast = shallowLoc; | 
 |  |  |                             crnNo = locMast.getCrnNo(); | 
 |  |  |                             break; | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         // 如果没有相近物料,则按规则轮询货架 | 
 |  |  |         if (null == locMast) { | 
 |  |  |             Shelves shelves = new Shelves(rowCount, crn_qty); | 
 |  |  |             for (int i = 0; i < shelves.group; i ++) { | 
 |  |  |                 curRow = shelves.start(curRow); | 
 |  |  |                 if (curRow < 0) { | 
 |  |  |                     throw new CoolException("检索库位失败,请联系管理员"); | 
 |  |  |                 } | 
 |  |  |                 Integer crnNo1 = shelves.get(curRow); | 
 |  |  |                 if (basCrnpService.checkSiteError(crnNo1, true)) { | 
 |  |  |                     crnNo = crnNo1; | 
 |  |  |                     break; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         if (crnNo == 0) { | 
 |  |  |             throw new CoolException("没有可用的堆垛机"); | 
 |  |  |         } | 
 |  |  |         // 获取目标站 | 
 |  |  |         Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() | 
 |  |  |                 .eq("type_no", staDescId) | 
 |  |  |                 .eq("stn_no", sourceStaNo) | 
 |  |  |                 .eq("crn_no", crnNo); | 
 |  |  |         StaDesc staDesc = staDescService.selectOne(wrapper); | 
 |  |  |         if (Cools.isEmpty(staDesc)) { | 
 |  |  |             log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo); | 
 |  |  |             throw new CoolException("入库路径不存在"); | 
 |  |  |         } | 
 |  |  |         BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn()); | 
 |  |  |         if (!staNo.getAutoing().equals("Y")) { | 
 |  |  |             throw new CoolException("目标站"+staDesc.getCrnStn()+"不可用"); | 
 |  |  |         } | 
 |  |  |         // 更新库位排号 | 
 |  |  |         rowLastno.setCurrentRow(curRow); | 
 |  |  |         rowLastnoService.updateById(rowLastno); | 
 |  |  |  | 
 |  |  |         // 开始查找库位 ==============================>> | 
 |  |  |  | 
 |  |  |         // 1.当检索库排为浅库位排时,优先寻找当前库排的深库位排 | 
 |  |  |         if (locMast == null) { | 
 |  |  |             if (Utils.isShallowLoc(slaveProperties, curRow)) { | 
 |  |  |                 Integer deepRow = Utils.getDeepRow(slaveProperties, curRow); | 
 |  |  |                 locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1()); | 
 |  |  |                 // todo:luxiaotao 如果用浅排找到的深库位,那么则需要判断这个深库位对应的浅库位是否有货(F、X、D) | 
 |  |  |                 // 因库位移转、需预留空库位 | 
 |  |  |                 if (!locMastService.checkEmptyCount(locMast)) { | 
 |  |  |                     locMast = null; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             if (Cools.isEmpty(locMast)) { | 
 |  |  |                 locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1()); | 
 |  |  |                 // 因库位移转、需预留空库位 | 
 |  |  |                 if (!locMastService.checkEmptyCount(locMast)) { | 
 |  |  |                     locMast = null; | 
 |  |  |                 } | 
 |  |  |                 // 目标库位 ===>> 浅库位, 则校验其深库位是否为 F D X | 
 |  |  |                 if (null != locMast && Utils.isShallowLoc(slaveProperties, locMast.getLocNo())) { | 
 |  |  |                     LocMast deepLoc = locMastService.selectById(Utils.getDeepLoc(slaveProperties, locMast.getLocNo())); | 
 |  |  |                     if (!deepLoc.getLocSts().equals("F") && !deepLoc.getLocSts().equals("D") && !deepLoc.getLocSts().equals("X")) { | 
 |  |  |                         locMast = null; | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |                 // 目标库位 ===>> 深库位, 则校验其浅库位是否为 O | 
 |  |  |                 if (null != locMast && Utils.isDeepLoc(slaveProperties, locMast.getLocNo())) { | 
 |  |  |                     LocMast shallowLoc = locMastService.selectById(Utils.getShallowLoc(slaveProperties, locMast.getLocNo())); | 
 |  |  |                     if (!shallowLoc.getLocSts().equals("O")) { | 
 |  |  |                         locMast = null; | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         // 2.库位当前所属尺寸无空库位时,调整尺寸参数,向上兼容检索库位 | 
 |  |  |         if (Cools.isEmpty(locMast)) { | 
 |  |  |             // 当前巷道无空库位时,递归调整至下一巷道,检索全部巷道无果后,跳出递归 | 
 |  |  |             if (times < rowCount) { | 
 |  |  |                 times = times + 1; | 
 |  |  |                 return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             // 轻货物找轻库位为空时,可以去找重库位仓 | 
 |  |  |             if (locTypeDto.getLocType1() == 1) { | 
 |  |  |                 locTypeDto.setLocType1((short) 2); | 
 |  |  |                 return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times); | 
 |  |  |             } | 
 |  |  |             log.error("系统没有空库位!!! 尺寸规格: {}, 轮询次数:{}", JSON.toJSONString(locTypeDto), times); | 
 |  |  |             throw new CoolException("没有空库位"); | 
 |  |  |         } | 
 |  |  |         String locNo = locMast.getLocNo(); | 
 |  |  |  | 
 |  |  |         // 返回dto | 
 |  |  |         startupDto.setWorkNo(workNo); | 
 |  |  |         startupDto.setCrnNo(crnNo); | 
 |  |  |         startupDto.setSourceStaNo(sourceStaNo); | 
 |  |  |         startupDto.setStaNo(staNo.getDevNo()); | 
 |  |  |         startupDto.setLocNo(locNo); | 
 |  |  |         return startupDto; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | } | 
 |  |  |  | 
 |  |  |     public static String zerofill(String msg, Integer count) { | 
 |  |  |         if (msg.length() == count) { | 
 |  |  |             return msg; | 
 |  |  |         } else if (msg.length() > count) { | 
 |  |  |             return msg.substring(0, 16); | 
 |  |  |         } else { | 
 |  |  |             StringBuilder msgBuilder = new StringBuilder(msg); | 
 |  |  |             for(int i = 0; i < count - msg.length(); ++i) { | 
 |  |  |                 msgBuilder.insert(0, "0"); | 
 |  |  |             } | 
 |  |  |             return msgBuilder.toString(); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 根据入库站获取库位排号分配 | 
 |  |  |      */ | 
 |  |  |     private Integer getWhsType(Integer sourceStaNo, int times) { | 
 |  |  |         if (true) { | 
 |  |  |             return 4; | 
 |  |  |         } | 
 |  |  |         if (times >= 16) { | 
 |  |  |             return 4; | 
 |  |  |         } | 
 |  |  |         switch (sourceStaNo) { | 
 |  |  |             case 173: | 
 |  |  |             case 176: | 
 |  |  |             case 180: | 
 |  |  |             case 185: | 
 |  |  |                 return 1; | 
 |  |  |             case 189: | 
 |  |  |             case 194: | 
 |  |  |             case 198: | 
 |  |  |             case 202: | 
 |  |  |                 return 2; | 
 |  |  |             case 206: | 
 |  |  | //            case 211: | 
 |  |  | //            case 215: | 
 |  |  | //            case 219: | 
 |  |  | //            case 223: | 
 |  |  |             case 227: | 
 |  |  |                 return 3; | 
 |  |  |             case 305: | 
 |  |  |             case 303: | 
 |  |  |             case 301: | 
 |  |  |                 return 4; | 
 |  |  |             default: | 
 |  |  |                 throw new CoolException("根据入库站获取库位排号分配失败,入库站:" + sourceStaNo); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | } |