|  |  | 
 |  |  | import com.zy.asrs.mapper.WaitPakinMapper; | 
 |  |  | import com.zy.asrs.mapper.WrkMastMapper; | 
 |  |  | import com.zy.asrs.service.*; | 
 |  |  | import com.zy.asrs.utils.VersionUtils; | 
 |  |  | import com.zy.common.model.MatDto; | 
 |  |  | import com.zy.common.model.StartupDto; | 
 |  |  | import com.zy.common.service.CommonService; | 
 |  |  | import com.zy.common.utils.CollectionUtils; | 
 |  |  | import com.zy.core.CrnThread; | 
 |  |  | import com.zy.core.cache.MessageQueue; | 
 |  |  | import com.zy.core.cache.SlaveConnection; | 
 |  |  | import com.zy.core.enums.*; | 
 |  |  | 
 |  |  | import com.zy.core.model.protocol.StaProtocol; | 
 |  |  | import com.zy.core.properties.SlaveProperties; | 
 |  |  | import com.zy.core.thread.BarcodeThread; | 
 |  |  | import com.zy.core.thread.CrnThread; | 
 |  |  | import com.zy.core.thread.DevpThread; | 
 |  |  | import com.zy.core.thread.LedThread; | 
 |  |  | import lombok.extern.slf4j.Slf4j; | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private BasDevpService basDevpService; | 
 |  |  |     @Autowired | 
 |  |  |     private LocDetlService locDetlService; | 
 |  |  |     @Autowired | 
 |  |  |     private JdbcTemplate jdbcTemplate; | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 组托 | 
 |  |  |      * 入库站,根据条码扫描生成入库工作档,工作状态 2 | 
 |  |  |      */ | 
 |  |  |     @Async | 
 |  |  | 
 |  |  |                 // 获取条码扫描仪信息 | 
 |  |  |                 BarcodeThread barcodeThread = (BarcodeThread) SlaveConnection.get(SlaveType.Barcode, inSta.getBarcode()); | 
 |  |  |                 String barcode = barcodeThread.getBarcode(); | 
 |  |  |                 if(!Cools.isEmpty(barcode)) { | 
 |  |  |                     System.err.println(barcode); | 
 |  |  |                 } | 
 |  |  |                 // 获取入库站信息 | 
 |  |  |                 DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, devp.getId()); | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(inSta.getStaNo()); | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 // 判断是否满足入库条件 | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.isInEnable() | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() | 
 |  |  | //                        && staProtocol.isInEnable() | 
 |  |  |                         && !staProtocol.isEmptyMk() && staProtocol.getWorkNo() == 0 | 
 |  |  |                         && staProtocol.isPakMk() && !Cools.isEmpty(barcode)) { | 
 |  |  |                     // 判断重复工作档 | 
 |  |  | 
 |  |  |  | 
 |  |  |                         // 命令下发区 -------------------------------------------------------------------------- | 
 |  |  |  | 
 |  |  |  | 
 |  |  |                         // 更新站点信息 且 下发plc命令 | 
 |  |  |                         barcodeThread.setBarcode(""); | 
 |  |  |                         staProtocol.setWorkNo((short) workNo); | 
 |  |  |                         staProtocol.setStaNo(startupDto.getStaNo().shortValue()); | 
 |  |  |                         staProtocol.setPakMk(false); | 
 |  |  |                         devpThread.setPakMk(staProtocol.getSiteId(), false); | 
 |  |  |                         boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol)); | 
 |  |  |                         if (!result) { | 
 |  |  |                             throw new CoolException("更新plc站点信息失败"); | 
 |  |  |                         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |                     } catch (Exception e) { | 
 |  |  |                         TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); | 
 |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * wms入库 | 
 |  |  |      * 入库站,根据条码扫描生成入库工作档,工作状态 1 ==>> 2 | 
 |  |  |      */ | 
 |  |  |     @Async | 
 |  |  |     public void generateStoreWrkFile2() { | 
 |  |  |     public void generateStoreWrkFile0() { | 
 |  |  |         // 根据输送线plc遍历 | 
 |  |  |         for (DevpSlave devp : slaveProperties.getDevp()) { | 
 |  |  |             // 遍历入库口 | 
 |  |  | 
 |  |  |                 // 获取入库站信息 | 
 |  |  |                 DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, devp.getId()); | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(inSta.getStaNo()); | 
 |  |  |                 if (staProtocol == null) { continue; } | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 // 判断是否满足入库条件 | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() | 
 |  |  |                         && !staProtocol.isEmptyMk() && staProtocol.getWorkNo() == 0 | 
 |  |  | 
 |  |  |                     // 更新站点信息 且 下发plc命令 | 
 |  |  |                     staProtocol.setWorkNo(wrkMast.getWrkNo().shortValue()); | 
 |  |  |                     staProtocol.setStaNo(wrkMast.getStaNo().shortValue()); | 
 |  |  |                     staProtocol.setPakMk(false); | 
 |  |  |                     devpThread.setPakMk(staProtocol.getSiteId(), false); | 
 |  |  |                     boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol)); | 
 |  |  |                     if (result) { | 
 |  |  |                         // 更新工作主档 | 
 |  |  | 
 |  |  |                 // 获取拣料入库站信息 | 
 |  |  |                 DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, devp.getId()); | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(pickSta.getStaNo()); | 
 |  |  |                 if (staProtocol == null) { continue; } | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.isInEnable() | 
 |  |  |                     && staProtocol.getWorkNo() > 0 && staProtocol.isPakMk()){ | 
 |  |  |                     WrkMast wrkMast = wrkMastMapper.selectPickStep(staProtocol.getWorkNo().intValue()); | 
 |  |  | 
 |  |  |                     StaDesc staDesc = staDescService.selectOne(wrapper); | 
 |  |  |                     if (Cools.isEmpty(staDesc)) { | 
 |  |  |                         log.error("入库路径不存在"); | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     // 更新站点信息 且 下发plc命令 | 
 |  |  |                     staProtocol.setWorkNo(wrkMast.getWrkNo().shortValue()); | 
 |  |  |                     staProtocol.setStaNo(wrkMast.getStaNo().shortValue()); | 
 |  |  |                     staProtocol.setPakMk(false); | 
 |  |  |                     boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol)); | 
 |  |  |                     if (!result) { | 
 |  |  |                         log.error("发布命令至输送线队列失败!!! [plc编号:{}]", devp.getId()); | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  | 
 |  |  |                     } catch (Exception e) { | 
 |  |  |                         e.printStackTrace(); | 
 |  |  |                         TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     // 更新站点信息 且 下发plc命令 | 
 |  |  |                     staProtocol.setWorkNo(wrkMast.getWrkNo().shortValue()); | 
 |  |  |                     staProtocol.setStaNo(wrkMast.getStaNo().shortValue()); | 
 |  |  |                     devpThread.setPakMk(staProtocol.getSiteId(), false); | 
 |  |  |                     boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol)); | 
 |  |  |                     if (!result) { | 
 |  |  |                         log.error("发布命令至输送线队列失败!!! [plc编号:{}]", devp.getId()); | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                 } | 
 |  |  | 
 |  |  |                 // 获取堆垛机出库站信息 | 
 |  |  |                 DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, crnStn.getDevpPlcId()); | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(crnStn.getStaNo()); | 
 |  |  |                 if (staProtocol == null) { continue; } | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() && (staProtocol.getWorkNo() == 0 || staProtocol.getStaNo() == null)) { | 
 |  |  |                     // 查询工作档 | 
 |  |  |                     WrkMast wrkMast = wrkMastMapper.selectPakOutStep2(staProtocol.getSiteId()); | 
 |  |  | 
 |  |  |             // 获取堆垛机入库站信息 | 
 |  |  |             DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, crnStn.getDevpPlcId()); | 
 |  |  |             StaProtocol staProtocol = devpThread.getStation().get(crnStn.getStaNo()); | 
 |  |  |             if (staProtocol == null) { continue; } | 
 |  |  |             if (staProtocol == null) { | 
 |  |  |                 continue; | 
 |  |  |             } else { | 
 |  |  |                 staProtocol = staProtocol.clone(); | 
 |  |  |             } | 
 |  |  |             // 查询站点详细信息 | 
 |  |  |             BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo()); | 
 |  |  |             if (staDetl == null) { | 
 |  |  |                 log.error("入库 ===>> 堆垛机站点在数据库不存在, 站点编号={}", crnStn.getStaNo()); | 
 |  |  |                 continue; | 
 |  |  |             } | 
 |  |  |             if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.getWorkNo() > 0 | 
 |  |  |             if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.getWorkNo() > 0 && staProtocol.isInEnable() | 
 |  |  |                     && staDetl.getCanining()!=null && staDetl.getCanining().equals("Y")) { | 
 |  |  |                 flag = true; | 
 |  |  |             } | 
 |  |  | 
 |  |  |             // 获取堆垛机出库站信息 | 
 |  |  |             DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, crnStn.getDevpPlcId()); | 
 |  |  |             StaProtocol staProtocol = devpThread.getStation().get(crnStn.getStaNo()); | 
 |  |  |             if (staProtocol == null) { continue; } | 
 |  |  |             if (staProtocol == null) { | 
 |  |  |                 continue; | 
 |  |  |             } else { | 
 |  |  |                 staProtocol = staProtocol.clone(); | 
 |  |  |             } | 
 |  |  |             // 查询站点详细信息 | 
 |  |  |             BasDevp staDetl = basDevpService.selectById(crnStn.getStaNo()); | 
 |  |  |             if (staDetl == null) { | 
 |  |  | 
 |  |  |             } | 
 |  |  |             // 判断堆垛机出库站状态 | 
 |  |  |             if (staProtocol.isAutoing() && !staProtocol.isLoading() && staDetl.getCanouting() !=null && staDetl.getCanouting().equals("Y") | 
 |  |  |                     && staProtocol.getWorkNo() == 0) { | 
 |  |  |                     && staProtocol.getWorkNo() == 0 && staProtocol.isOutEnable()) { | 
 |  |  |                 // 命令下发区 -------------------------------------------------------------------------- | 
 |  |  |  | 
 |  |  |                 // 堆垛机控制过滤 | 
 |  |  | 
 |  |  |                 // 获取空板入库站信息 | 
 |  |  |                 DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, devp.getId()); | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(emptyInSta.getStaNo()); | 
 |  |  |                 if (staProtocol == null) { continue; } | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 // 站点条件判断 | 
 |  |  |                 if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.isInEnable() | 
 |  |  |                         && staProtocol.isEmptyMk() && staProtocol.getWorkNo() == 0 && staProtocol.isPakMk()) { | 
 |  |  | 
 |  |  |                         // 更新站点信息 且 下发plc命令 | 
 |  |  |                         staProtocol.setWorkNo((short) workNo); | 
 |  |  |                         staProtocol.setStaNo(startupDto.getStaNo().shortValue()); | 
 |  |  |                         staProtocol.setPakMk(false); | 
 |  |  |                         devpThread.setPakMk(staProtocol.getSiteId(), false); | 
 |  |  |                         boolean result = MessageQueue.offer(SlaveType.Devp, devp.getId(), new Task(2, staProtocol)); | 
 |  |  |                         if (!result) { | 
 |  |  |                             throw new CoolException("更新plc站点信息失败"); | 
 |  |  | 
 |  |  |             for (Integer staNo : led.getStaArr()) { | 
 |  |  |                 // 获取叉车站点 | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(staNo); | 
 |  |  |                 if (null == staProtocol || null == staProtocol.getWorkNo() || 0 == staProtocol.getWorkNo() || !staProtocol.isLoading()) { continue; } | 
 |  |  |                 if (null == staProtocol || null == staProtocol.getWorkNo() || 0 == staProtocol.getWorkNo() || !staProtocol.isLoading()) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 // 获取工作档数据 | 
 |  |  |                 WrkMast wrkMast = wrkMastMapper.selectById(staProtocol.getWorkNo()); | 
 |  |  |                 if (null == wrkMast || wrkMast.getWrkSts() < 14 || wrkMast.getIoType() < 100) { continue; } | 
 |  |  | 
 |  |  |             for (Integer staNo : led.getStaArr()) { | 
 |  |  |                 // 获取叉车站点 | 
 |  |  |                 StaProtocol staProtocol = devpThread.getStation().get(staNo); | 
 |  |  |                 if (staProtocol == null) {continue;} | 
 |  |  |                 if (staProtocol == null) { | 
 |  |  |                     continue; | 
 |  |  |                 } else { | 
 |  |  |                     staProtocol = staProtocol.clone(); | 
 |  |  |                 } | 
 |  |  |                 if (staProtocol.getWorkNo() != 0) { | 
 |  |  |                     reset = false; | 
 |  |  |                     break; | 
 |  |  | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 堆垛机演示  ===>> 库位移转 | 
 |  |  |      */ | 
 |  |  |     @Async | 
 |  |  |     public void crnDemoOfLocMove(Integer crn){ | 
 |  |  |         for (int i = 0; i < 5; i++) { | 
 |  |  |  | 
 |  |  |             LocMast sourceLoc = locMastService.queryDemoSourceLoc(crn); | 
 |  |  |             LocMast loc = locMastService.queryDemoLoc(crn); | 
 |  |  |             if (null == sourceLoc || null == loc) { | 
 |  |  |                 break; | 
 |  |  |             } | 
 |  |  |             String sourceLocNo = sourceLoc.getLocNo(); | 
 |  |  |             String locNo = loc.getLocNo(); | 
 |  |  |  | 
 |  |  |             // 获取工作号 | 
 |  |  |             int workNo = commonService.getWorkNo(0); | 
 |  |  |             // 保存工作档 | 
 |  |  |             WrkMast wrkMast = new WrkMast(); | 
 |  |  |             wrkMast.setWrkNo(workNo); | 
 |  |  |             wrkMast.setIoTime(new Date()); | 
 |  |  |             wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID | 
 |  |  |             wrkMast.setIoType(11); // 入出库状态: 11.库格移载 | 
 |  |  |             wrkMast.setIoPri(13D); | 
 |  |  |             wrkMast.setCrnNo(crn); | 
 |  |  |             wrkMast.setSourceLocNo(sourceLocNo); // 源库位 | 
 |  |  |             wrkMast.setLocNo(locNo); // 目标库位 | 
 |  |  |             wrkMast.setFullPlt("N"); // 满板:Y | 
 |  |  |             wrkMast.setPicking("N"); // 拣料 | 
 |  |  |             wrkMast.setExitMk("N"); // 退出 | 
 |  |  |             wrkMast.setEmptyMk(sourceLoc.getLocSts().equals("D")?"Y":"N"); // 空板 | 
 |  |  |             wrkMast.setBarcode(sourceLoc.getBarcode()); // 托盘码 | 
 |  |  |             wrkMast.setLinkMis("N"); | 
 |  |  |             wrkMast.setAppeTime(new Date()); | 
 |  |  |             wrkMast.setModiTime(new Date()); | 
 |  |  |             int res = wrkMastMapper.insert(wrkMast); | 
 |  |  |             if (res == 0) { | 
 |  |  |                 throw new CoolException("保存工作档失败"); | 
 |  |  |             } | 
 |  |  |             // 工作档明细保存 | 
 |  |  |             List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", sourceLocNo)); | 
 |  |  |             for (LocDetl locDetl : locDetls) { | 
 |  |  |                 WrkDetl wrkDetl = new WrkDetl(); | 
 |  |  |                 wrkDetl.setWrkNo(workNo); | 
 |  |  |                 wrkDetl.setIoTime(new Date()); | 
 |  |  |                 wrkDetl.setAnfme(locDetl.getAnfme()); | 
 |  |  |                 VersionUtils.setWrkDetl(wrkDetl, locDetl); // 版本控制 | 
 |  |  |                 wrkDetl.setAppeTime(new Date()); | 
 |  |  |                 wrkDetl.setModiTime(new Date()); | 
 |  |  |                 if (!wrkDetlService.insert(wrkDetl)) { | 
 |  |  |                     throw new CoolException("保存工作档明细失败"); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             // 修改源库位状态 | 
 |  |  |             if (sourceLoc.getLocSts().equals("D") || sourceLoc.getLocSts().equals("F")) { | 
 |  |  |                 sourceLoc.setLocSts("R"); // R.出库预约 | 
 |  |  |                 sourceLoc.setModiTime(new Date()); | 
 |  |  |                 if (!locMastService.updateById(sourceLoc)){ | 
 |  |  |                     throw new CoolException("更新源库位状态失败"); | 
 |  |  |                 } | 
 |  |  |             } else { | 
 |  |  |                 throw new CoolException("源库位出库失败"); | 
 |  |  |             } | 
 |  |  |             // 修改目标库位状态 | 
 |  |  |             if (loc.getLocSts().equals("O")) { | 
 |  |  |                 loc.setLocSts("S"); // S.入库预约 | 
 |  |  |                 loc.setModiTime(new Date()); | 
 |  |  |                 if (!locMastService.updateById(loc)) { | 
 |  |  |                     throw new CoolException("更新目标库位状态失败"); | 
 |  |  |                 } | 
 |  |  |             } else { | 
 |  |  |                 throw new CoolException("移转失败"); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | } |