|  |  | 
 |  |  |             agvLocDetl.setLocNo(locNo); | 
 |  |  |             this.insert(agvLocDetl); | 
 |  |  |             // 流水 -- 新增订单明细 | 
 |  |  |             OrderDetl orderDetl = orderDetlService.selectItem(agvWrkDetl.getOrderNo(), agvWrkDetl.getMatnr(), agvWrkDetl.getThreeCode()); | 
 |  |  |             OrderDetl orderDetl = orderDetlService.selectItem(agvWrkDetl.getOrderNo(), agvWrkDetl.getMatnr(), agvWrkDetl.getBatch(), agvWrkDetl.getThreeCode()); | 
 |  |  | //            FlowLog flowLog = new FlowLog(); | 
 |  |  | //            flowLog.setFid(String.valueOf(flowId)); | 
 |  |  | //            flowLog.setSpare2(String.valueOf(taskCode)); | 
 |  |  | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq,String type) { | 
 |  |  |     public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq, String type) { | 
 |  |  |         //根据物料号和批次找到对应的库存,并且按照修改时间排序 | 
 |  |  |         Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).orderBy("modi_time"); | 
 |  |  |         if (type != null) { | 
 |  |  |             wrapper.notLike("loc_no", "F1"); | 
 |  |  |         } | 
 |  |  |         wapperSetCondition(wrapper,"batch",batch); | 
 |  |  |         wapperSetCondition(wrapper,"three_code",csocode); | 
 |  |  |         wapperSetCondition(wrapper,"dead_time",isoseq); | 
 |  |  |         wapperSetCondition(wrapper, "batch", batch); | 
 |  |  |         wapperSetCondition(wrapper, "three_code", csocode); | 
 |  |  |         wapperSetCondition(wrapper, "dead_time", isoseq); | 
 |  |  |  | 
 |  |  |         if ("JG".equals(orderNo.substring(0,2))) { | 
 |  |  |             wapperSetCondition(wrapper,"process_sts","1"); | 
 |  |  |         if ("JG".equals(orderNo.substring(0, 2))) { | 
 |  |  |             wapperSetCondition(wrapper, "process_sts", "1"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         List<AgvLocDetl> agvLocDetls = this.selectList(wrapper); | 
 |  |  |  | 
 |  |  |         for (AgvLocDetl agvLocDetl: agvLocDetls) { | 
 |  |  |         for (AgvLocDetl agvLocDetl : agvLocDetls) { | 
 |  |  |             //判断当前库位货物是否F在库 | 
 |  |  |             AgvLocMast agvLocMast = agvLocMastService.selectById(agvLocDetl.getLocNo()); | 
 |  |  |             if(!"F".equals(agvLocMast.getLocSts())){ | 
 |  |  |             if (!"F".equals(agvLocMast.getLocSts())) { | 
 |  |  |                 continue; | 
 |  |  |             } | 
 |  |  |             //如果订单剩余出库量大于0 | 
 |  |  |             if(issued > 0) { | 
 |  |  |             if (issued > 0) { | 
 |  |  |                 //当前库位的库存量 | 
 |  |  |                 double anfme = agvLocDetl.getAnfme(); | 
 |  |  |                 //int ioType = anfme > issued ? 101 : 103; | 
 |  |  |                 anfme = anfme > issued ? issued : anfme; | 
 |  |  |                 //用于显示工作明细档的订单号 | 
 |  |  |                 String orderNoWrkDtel = Utils.getOrderNo(orderNo,anfme); | 
 |  |  |                 String orderNoWrkDtel = Utils.getOrderNo(orderNo, anfme); | 
 |  |  |                 //更新订单数量 | 
 |  |  |                 orderNo = Utils.orderMergeUpdate(orderNo,anfme); | 
 |  |  |                 LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNoWrkDtel, anfme,agvLocDetl.getProcessSts()); | 
 |  |  |                 orderNo = Utils.orderMergeUpdate(orderNo, anfme); | 
 |  |  |                 LocDto locDto = new LocDto(agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getMaktx(), agvLocDetl.getBatch(), orderNoWrkDtel, anfme, agvLocDetl.getProcessSts()); | 
 |  |  |                 locDto.setCsocode(csocode); | 
 |  |  |                 locDto.setIsoseq(isoseq); | 
 |  |  |                 locDto.setContainerCode(agvLocDetl.getSuppCode()); | 
 |  |  | 
 |  |  |                 //当前库位所处楼层 | 
 |  |  |                 int floor = Integer.parseInt(agvLocDetl.getLocNo().split("F")[1]); | 
 |  |  |                 //locDto.setAgvStaNos(queryAgvStaNosByFloor(floor)); | 
 |  |  |                 locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(),floor)); | 
 |  |  |                 locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(), floor)); | 
 |  |  |                 locDtoList.add(locDto); | 
 |  |  |  | 
 |  |  |                 issued -= anfme; | 
 |  |  | 
 |  |  |     更新库存明细 | 
 |  |  |      */ | 
 |  |  |     public void updateStock(String sourceLoc, String targetLoc) { | 
 |  |  |         this.baseMapper.updateStock(sourceLoc,targetLoc); | 
 |  |  |         this.baseMapper.updateStock(sourceLoc, targetLoc); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page) { | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public AgvLocDetl selectItem(String locNo, String matnr, String batch, String csocode, String isoCode) { | 
 |  |  |         return this.baseMapper.selectItemByOrderNo(locNo, matnr, batch,csocode,isoCode); | 
 |  |  |         return this.baseMapper.selectItemByOrderNo(locNo, matnr, batch, csocode, isoCode); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public Double getSumAnfmeDb(String matnr, String threeCode,Integer floor) { | 
 |  |  |     public Double getSumAnfmeDb(String matnr, String threeCode, Integer floor) { | 
 |  |  |         return this.baseMapper.selectSumAnfmeByMatnr2(matnr, threeCode, floor); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public Double getSumAnfmeback(String matnr, String threeCode,Integer floor) { | 
 |  |  |     public Double getSumAnfmeback(String matnr, String threeCode, Integer floor) { | 
 |  |  |         return this.baseMapper.getSumAnfmeback(matnr, threeCode, floor); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |         return this.baseMapper.sum(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public List<AgvLocDetl> getStockStatisExcel(){ | 
 |  |  |     public List<AgvLocDetl> getStockStatisExcel() { | 
 |  |  |         return this.baseMapper.getStockStatisExcel(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |             return new ArrayList<AgvLocDetl>(); | 
 |  |  |         } | 
 |  |  |         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); | 
 |  |  |         if(Cools.isEmpty(orderNo)){ | 
 |  |  |             wrapper.like("order_no",orderNo); | 
 |  |  |         if (Cools.isEmpty(orderNo)) { | 
 |  |  |             wrapper.like("order_no", orderNo); | 
 |  |  |         } | 
 |  |  |         if(Cools.isEmpty(matnr)){ | 
 |  |  |             wrapper.like("matnr",matnr); | 
 |  |  |         if (Cools.isEmpty(matnr)) { | 
 |  |  |             wrapper.like("matnr", matnr); | 
 |  |  |         } | 
 |  |  |         if(Cools.isEmpty(maktx)){ | 
 |  |  |             wrapper.like("maktx",maktx); | 
 |  |  |         if (Cools.isEmpty(maktx)) { | 
 |  |  |             wrapper.like("maktx", maktx); | 
 |  |  |         } | 
 |  |  |         if(Cools.isEmpty(specs)){ | 
 |  |  |             wrapper.like("specs",specs); | 
 |  |  |         if (Cools.isEmpty(specs)) { | 
 |  |  |             wrapper.like("specs", specs); | 
 |  |  |         } | 
 |  |  |         if(Cools.isEmpty()){ | 
 |  |  |             wrapper.like("loc_no",locNo); | 
 |  |  |         if (Cools.isEmpty()) { | 
 |  |  |             wrapper.like("loc_no", locNo); | 
 |  |  |         } | 
 |  |  |         return this.selectList(wrapper); | 
 |  |  |     } | 
 |  |  | 
 |  |  |     public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode) { | 
 |  |  |         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); | 
 |  |  |         wrapper.eq("loc_no", locNo); | 
 |  |  |         Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode); | 
 |  |  |         Utils.confirmOnlyMat(wrapper, matnr, batch, csocode, isocode); | 
 |  |  |         if (anfme <= 0) { | 
 |  |  |             return this.baseMapper.deleteLocDetl(locNo,anfme,matnr,batch,csocode,isocode) > 0; | 
 |  |  |             return this.baseMapper.deleteLocDetl(locNo, anfme, matnr, batch, csocode, isocode) > 0; | 
 |  |  |         } else { | 
 |  |  |             AgvLocDetl agvLocDetl = this.selectOne(wrapper); | 
 |  |  |             agvLocDetl.setAnfme(anfme); | 
 |  |  |             agvLocDetl.setModiTime(new Date()); | 
 |  |  |             return this.baseMapper.updateAnfme(locNo,anfme,matnr,batch,csocode,isocode) > 0; | 
 |  |  |             return this.baseMapper.updateAnfme(locNo, anfme, matnr, batch, csocode, isocode) > 0; | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public boolean updateAnfmeProcess(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode, Integer process) { | 
 |  |  |         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); | 
 |  |  |         wrapper.eq("loc_no", locNo); | 
 |  |  |         Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode); | 
 |  |  |         Utils.confirmOnlyMat(wrapper, matnr, batch, csocode, isocode); | 
 |  |  |         if (anfme <= 0) { | 
 |  |  |             return this.baseMapper.deleteLocDetl(locNo,anfme,matnr,batch,csocode,isocode) > 0; | 
 |  |  |             return this.baseMapper.deleteLocDetl(locNo, anfme, matnr, batch, csocode, isocode) > 0; | 
 |  |  |         } else { | 
 |  |  |             AgvLocDetl agvLocDetl = this.selectOne(wrapper); | 
 |  |  |             agvLocDetl.setAnfme(anfme); | 
 |  |  |             agvLocDetl.setModiTime(new Date()); | 
 |  |  |             return this.baseMapper.updateAnfmeProcess(locNo,anfme,matnr,batch,csocode,isocode,process) > 0; | 
 |  |  |             return this.baseMapper.updateAnfmeProcess(locNo, anfme, matnr, batch, csocode, isocode, process) > 0; | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     private void wapperSetCondition(Wrapper wrapper,String column, String condition){ | 
 |  |  |         if(Cools.isEmpty(condition)){ | 
 |  |  |             wrapper.andNew().eq(column,"").or().isNull(column); | 
 |  |  |         }else { | 
 |  |  |             wrapper.andNew().eq(column,condition); | 
 |  |  |     private void wapperSetCondition(Wrapper wrapper, String column, String condition) { | 
 |  |  |         if (Cools.isEmpty(condition)) { | 
 |  |  |             wrapper.andNew().eq(column, "").or().isNull(column); | 
 |  |  |         } else { | 
 |  |  |             wrapper.andNew().eq(column, condition); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public AgvLocDetl selectByLocNo(String locNo){ | 
 |  |  |         return this.selectOne(new EntityWrapper<AgvLocDetl>().eq("loc_no",locNo)); | 
 |  |  |     public AgvLocDetl selectByLocNo(String locNo) { | 
 |  |  |         return this.selectOne(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo)); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |         List<AgvLocDetl> agvLocDetls = new ArrayList<>(); | 
 |  |  |  | 
 |  |  |         taskDto.getLocDtos().forEach(locDto -> { | 
 |  |  |             AgvLocDetl agvLocDetl = this.selectByMatnrAndBatchAndCsocodeAndisoCode(locDto.getLocNo(),locDto.getMatnr(), locDto.getBatch(), locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |             AgvLocDetl agvLocDetl = this.selectByMatnrAndBatchAndCsocodeAndisoCode(locDto.getLocNo(), locDto.getMatnr(), locDto.getBatch(), locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |             agvLocDetls.add(agvLocDetl); | 
 |  |  |         }); | 
 |  |  |         return agvLocDetls; | 
 |  |  | 
 |  |  |     @Override | 
 |  |  |     public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode(String locNo, String matnr, String batch, String csocode, String isocode) { | 
 |  |  |         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); | 
 |  |  |         wrapper.eq("loc_no",locNo); | 
 |  |  |         Utils.confirmOnlyMat(wrapper,matnr,batch,csocode,isocode); | 
 |  |  |         wrapper.eq("loc_no", locNo); | 
 |  |  |         Utils.confirmOnlyMat(wrapper, matnr, batch, csocode, isocode); | 
 |  |  |         return this.selectOne(wrapper); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode2(String locNo,String orderNo, String matnr, String batch, String csocode, String isocode) { | 
 |  |  |     public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode2(String locNo, String orderNo, String matnr, String batch, String csocode, String isocode) { | 
 |  |  |         EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); | 
 |  |  |         wrapper.eq("loc_no",locNo); | 
 |  |  |         Utils.confirmOnlyMat2(wrapper,orderNo,matnr,batch,csocode,isocode); | 
 |  |  |         wrapper.eq("loc_no", locNo); | 
 |  |  |         Utils.confirmOnlyMat2(wrapper, orderNo, matnr, batch, csocode, isocode); | 
 |  |  |         return this.selectOne(wrapper); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public AgvLocDetl selectLocdetl(String locNo, String matnr, String batch, String csocode, String isocode) { | 
 |  |  |         return this.baseMapper.selectLocdetl(locNo,matnr,batch,csocode,isocode); | 
 |  |  |         return this.baseMapper.selectLocdetl(locNo, matnr, batch, csocode, isocode); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  | 
 |  |  |         try { | 
 |  |  |             if (excelVersion == 2003) { | 
 |  |  |                 book = new HSSFWorkbook(inStream); | 
 |  |  |             } | 
 |  |  |             else {  // 当 excel 是 2007 时 | 
 |  |  |             } else {  // 当 excel 是 2007 时 | 
 |  |  |                 book = new XSSFWorkbook(inStream); | 
 |  |  |             } | 
 |  |  |         } catch (Exception e) { | 
 |  |  | 
 |  |  |             String containerCode = dataFormatter.formatCellValue(row.getCell(1)); | 
 |  |  |  | 
 |  |  |             List<AgvLocDetl> agvLocDetls = this.selectList(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo).eq("supp_code", containerCode)); | 
 |  |  |             if(Cools.isEmpty(agvLocDetls)){ | 
 |  |  |             if (Cools.isEmpty(agvLocDetls)) { | 
 |  |  |                 log.info("库位号:" + locNo + ",货架码:" + containerCode + ",不存在明细"); | 
 |  |  |             } | 
 |  |  |             if(agvLocDetls.size()>1){ | 
 |  |  |             if (agvLocDetls.size() > 1) { | 
 |  |  |                 log.info("库位号:" + locNo + ",货架码:" + containerCode + ",存在1条以上记录"); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void updateLocNo(String locNo, String sourceLoc, AgvLocDetl agvLocDetl) { | 
 |  |  |         this.baseMapper.updateLocNo(locNo,sourceLoc,agvLocDetl.getSuppCode()); | 
 |  |  |         this.baseMapper.updateLocNo(locNo, sourceLoc, agvLocDetl.getSuppCode()); | 
 |  |  |     } | 
 |  |  | } | 
 
 |  |  | 
 |  |  |         return this.baseMapper.selectItemByOrderNo2(orderNo, matnr, batch, threeCode); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public OrderDetl selectItemNoneOfBatch(String orderNo, String matnr) { | 
 |  |  |         return this.baseMapper.selectItemNoneOfBatch(orderNo, matnr); | 
 
 |  |  | 
 |  |  |         // 生成工作档明细 | 
 |  |  |         List<DetlDto> detlDtos = new ArrayList<>(); | 
 |  |  |         param.getList().forEach(elem -> { | 
 |  |  |             DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme(), elem.getCsocode(), elem.getIsoseq(),elem.getContainerCode()); | 
 |  |  |             DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme(), elem.getCsocode(), elem.getIsoseq(), elem.getContainerCode()); | 
 |  |  |             if (DetlDto.has(detlDtos, detlDto)) { | 
 |  |  |                 DetlDto detlDto1 = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch(),detlDto.getCsocode(),detlDto.getIsoseq(),detlDto.getContainerCode()); | 
 |  |  |                 DetlDto detlDto1 = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch(), detlDto.getCsocode(), detlDto.getIsoseq(), detlDto.getContainerCode()); | 
 |  |  |                 assert detlDto1 != null; | 
 |  |  |                 detlDto1.setAnfme(detlDto1.getAnfme() + detlDto.getAnfme()); | 
 |  |  |             } else { | 
 |  |  | 
 |  |  |         sourceStaNo.setWrkNo(workNo); | 
 |  |  |         sourceStaNo.setModiUser(userId); | 
 |  |  |         sourceStaNo.setModiTime(now); | 
 |  |  |         if (!basDevpService.updateById(sourceStaNo)){ | 
 |  |  |         if (!basDevpService.updateById(sourceStaNo)) { | 
 |  |  |             throw new CoolException("更新源站失败"); | 
 |  |  |         } | 
 |  |  |         // 更新目标库位状态 | 
 |  |  |         LocMast locMast = locMastService.selectById(dto.getLocNo()); | 
 |  |  |         if (locMast.getLocSts().equals("O")){ | 
 |  |  |         if (locMast.getLocSts().equals("O")) { | 
 |  |  |             locMast.setLocSts("S"); // S.入库预约 | 
 |  |  |             locMast.setModiUser(userId); | 
 |  |  |             locMast.setModiTime(now); | 
 |  |  |             if (!locMastService.updateById(locMast)){ | 
 |  |  |             if (!locMastService.updateById(locMast)) { | 
 |  |  |                 throw new CoolException("改变库位状态失败"); | 
 |  |  |             } | 
 |  |  |         } else { | 
 |  |  |             throw new CoolException(dto.getLocNo()+"目标库位已被占用"); | 
 |  |  |             throw new CoolException(dto.getLocNo() + "目标库位已被占用"); | 
 |  |  |         } | 
 |  |  |         return dto.getLocNo(); | 
 |  |  |     } | 
 |  |  | 
 |  |  |     @Transactional | 
 |  |  |     public void startupFullTakeStore(StockOutParam param, Long userId) { | 
 |  |  |         ArrayList<String> locNos = new ArrayList<>(); | 
 |  |  |         for (StockOutParam.LocDetl locDetl:param.getLocDetls()){ | 
 |  |  |             if (!locNos.contains(locDetl.getLocNo())){ | 
 |  |  |         for (StockOutParam.LocDetl locDetl : param.getLocDetls()) { | 
 |  |  |             if (!locNos.contains(locDetl.getLocNo())) { | 
 |  |  |                 locNos.add(locDetl.getLocNo()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         //检测是否为浅库位 | 
 |  |  |         boolean sign=false; | 
 |  |  |         boolean sign = false; | 
 |  |  |         String th = ""; | 
 |  |  |         for (String locNo:locNos){ | 
 |  |  |             if (sign){ | 
 |  |  |         for (String locNo : locNos) { | 
 |  |  |             if (sign) { | 
 |  |  |                 break; | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             //检测出库的货物中是否有状态为禁止的货物。 | 
 |  |  |             for (LocDetl locDetl : locDetlService.selectByLocNo(locNo)) { | 
 |  |  |                 if (locDetl.getStockFreeze() == 0) { | 
 |  |  |                     th="库位号:"+locNo+" 有禁止出库的货物!"; | 
 |  |  |                     throw new CoolException("出库失败;"+th); | 
 |  |  |                     th = "库位号:" + locNo + " 有禁止出库的货物!"; | 
 |  |  |                     throw new CoolException("出库失败;" + th); | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 Mat mat = matService.selectByMatnr(locDetl.getMatnr()); | 
 |  |  | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 if (mat.getStatus() == 0) { | 
 |  |  |                     th="库位号:"+locNo+" 有禁止出库的货物!"; | 
 |  |  |                     throw new CoolException("出库失败;"+th); | 
 |  |  |                     th = "库位号:" + locNo + " 有禁止出库的货物!"; | 
 |  |  |                     throw new CoolException("出库失败;" + th); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             List<String> groupOuterLoc = Utils.getGroupOuterLoc(locNo); | 
 |  |  |             if (!Cools.isEmpty(groupOuterLoc)) { | 
 |  |  |                 for (String outerLoc : groupOuterLoc) { | 
 |  |  |                     if (locNos.contains(outerLoc)){ | 
 |  |  |                     if (locNos.contains(outerLoc)) { | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |                     LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", outerLoc)); | 
 |  |  |                     if (locMast != null) { | 
 |  |  |                         if (!locMast.getLocSts().equals("O") && !locMast.getLocSts().equals("R")){ | 
 |  |  |                             sign=true; | 
 |  |  |                             th="库位号:"+locNo+" 浅库位有非空库位!"; | 
 |  |  |                         if (!locMast.getLocSts().equals("O") && !locMast.getLocSts().equals("R")) { | 
 |  |  |                             sign = true; | 
 |  |  |                             th = "库位号:" + locNo + " 浅库位有非空库位!"; | 
 |  |  |                             break; | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         if (sign){ | 
 |  |  |             throw new CoolException("出库失败;"+th); | 
 |  |  |         if (sign) { | 
 |  |  |             throw new CoolException("出库失败;" + th); | 
 |  |  |         } | 
 |  |  |         // 目标站点状态检测 | 
 |  |  |         BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite()); | 
 |  |  | 
 |  |  |             throw new CoolException("库存不存在"); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 通过库位号获取 排 | 
 |  |  |      */ | 
 |  |  | 
 |  |  |         } | 
 |  |  |         throw new RuntimeException("库位解析异常"); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 通过库位号获取 列 | 
 |  |  |      */ | 
 |  |  | 
 |  |  |         } | 
 |  |  |         throw new RuntimeException("库位解析异常"); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 通过库位号获取 层 | 
 |  |  |      */ | 
 |  |  | 
 |  |  |  | 
 |  |  |         ArrayList<String> outerLocs = new ArrayList<>(); | 
 |  |  |         //检测是否为浅库位 | 
 |  |  |         boolean sign=false; | 
 |  |  |         boolean sign = false; | 
 |  |  |         String th = ""; | 
 |  |  |         for (String locNo : locNos) { | 
 |  |  |             if (sign) { | 
 |  |  | 
 |  |  |         //**************325、331、333、339站点额外逻辑代码************** | 
 |  |  |         HashMap<String, Object> tmpMap = new HashMap<>(); | 
 |  |  |         if (staNo.getDevNo() == 325 || staNo.getDevNo() == 331 || staNo.getDevNo() == 333 || staNo.getDevNo() == 339) { | 
 |  |  |             int[] data = {325,331,333,339}; | 
 |  |  |             int[] data = {325, 331, 333, 339}; | 
 |  |  |             for (String locNo : locNos) { | 
 |  |  |                 List<String> groupOuterLoc = Utils.getGroupDeepLoc(locNo); | 
 |  |  |                 if (groupOuterLoc.isEmpty()) { | 
 |  |  | 
 |  |  |             wrkMast.setIoType(ioType); // 入出库状态 | 
 |  |  |             Double ioPri = wrkMastService.getIoPri(ioType, dto.getLocNo()); | 
 |  |  |             wrkMast.setIoPri(ioPri); // 优先级:13 | 
 |  |  |             wrkMast.setOutMost(outMost?1:0);; | 
 |  |  |             wrkMast.setCrnNo(outMost?outCrnNo:locMast.getCrnNo()); | 
 |  |  |             wrkMast.setOutMost(outMost ? 1 : 0); | 
 |  |  |             ; | 
 |  |  |             wrkMast.setCrnNo(outMost ? outCrnNo : locMast.getCrnNo()); | 
 |  |  |             wrkMast.setSourceStaNo(sourceStaNo); // 源站 | 
 |  |  |             wrkMast.setStaNo(stnNo); // 目标站 | 
 |  |  |             wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位 | 
 |  |  | 
 |  |  |             wrkMast.setModiUser(userId); | 
 |  |  |             wrkMast.setModiTime(now); | 
 |  |  |             if (!wrkMastService.insert(wrkMast)) { | 
 |  |  |                 throw new CoolException("保存工作档失败,出库库位号:"+dto.getLocNo()); | 
 |  |  |                 throw new CoolException("保存工作档失败,出库库位号:" + dto.getLocNo()); | 
 |  |  |             } | 
 |  |  |             // 生成工作档明细 | 
 |  |  |             for (LocDetlDto detlDto : dto.getLocDetlDtos()) { | 
 |  |  |                 if (detlDto.getCount()==null || detlDto.getCount() <= 0.0D) {continue;} | 
 |  |  |                 if (detlDto.getCount() == null || detlDto.getCount() <= 0.0D) { | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 WrkDetl wrkDetl = new WrkDetl(); | 
 |  |  |                 wrkDetl.sync(detlDto.getLocDetl()); | 
 |  |  |                 wrkDetl.setOrderNo(""); // 手动出库不需要带出库存中的单据编号 | 
 |  |  |                 wrkDetl.setWrkNo(workNo); | 
 |  |  |                 wrkDetl.setIoTime(now); | 
 |  |  |                 Double anfme = ioType==101?detlDto.getLocDetl().getAnfme():detlDto.getCount(); | 
 |  |  |                 Double anfme = ioType == 101 ? detlDto.getLocDetl().getAnfme() : detlDto.getCount(); | 
 |  |  |                 wrkDetl.setAnfme(anfme); // 数量 | 
 |  |  |                 wrkDetl.setAppeTime(now); | 
 |  |  |                 wrkDetl.setAppeUser(userId); | 
 |  |  | 
 |  |  |             // 修改库位状态:   F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中 | 
 |  |  |             locMast = locMastService.selectById(dto.getLocNo()); | 
 |  |  |             if (locMast.getLocSts().equals("F")) { | 
 |  |  |                 locMast.setLocSts(ioType==101?"R":"P"); | 
 |  |  |                 locMast.setLocSts(ioType == 101 ? "R" : "P"); | 
 |  |  |                 locMast.setModiUser(userId); | 
 |  |  |                 locMast.setModiTime(now); | 
 |  |  |                 if (!locMastService.updateById(locMast)) { | 
 |  |  |                     throw new CoolException("预约库位状态失败,库位号:"+dto.getLocNo()); | 
 |  |  |                     throw new CoolException("预约库位状态失败,库位号:" + dto.getLocNo()); | 
 |  |  |                 } | 
 |  |  |             } else { | 
 |  |  |                 throw new CoolException(dto.getLocNo() + "库位不是在库状态"); | 
 |  |  | 
 |  |  |         wrkMast.setIoType(ioType); // 入出库状态 | 
 |  |  |         Double ioPri = wrkMastService.getIoPri(ioType, taskDto.getLocNo()); | 
 |  |  |         wrkMast.setIoPri(ioPri); // 优先级:13 | 
 |  |  |         wrkMast.setOutMost(outMost?1:0);; | 
 |  |  |         wrkMast.setCrnNo(outMost?outCrnNo:locMast.getCrnNo()); | 
 |  |  |         wrkMast.setOutMost(outMost ? 1 : 0); | 
 |  |  |         ; | 
 |  |  |         wrkMast.setCrnNo(outMost ? outCrnNo : locMast.getCrnNo()); | 
 |  |  |         wrkMast.setSourceStaNo(sourceStaNo); // 源站 | 
 |  |  |         wrkMast.setStaNo(stnNo); // 目标站 | 
 |  |  |         wrkMast.setPltType(locMast.getPltType()); | 
 |  |  |         if(ioType == 101 && taskDto.getStaNo()>=300){ | 
 |  |  |         if (ioType == 101 && taskDto.getStaNo() >= 300) { | 
 |  |  |             wrkMast.setSourceStaNo(346); // 源站 | 
 |  |  |             wrkMast.setStaNo(346); // 目标站 | 
 |  |  |         } | 
 |  |  | 
 |  |  |         wrkMast.setModiUser(userId); | 
 |  |  |         wrkMast.setModiTime(now); | 
 |  |  |         if (!wrkMastService.insert(wrkMast)) { | 
 |  |  |             throw new CoolException("保存工作档失败,出库库位号:"+taskDto.getLocNo()); | 
 |  |  |             throw new CoolException("保存工作档失败,出库库位号:" + taskDto.getLocNo()); | 
 |  |  |         } | 
 |  |  |         // 生成工作档明细 | 
 |  |  |         for (LocDto locDto : taskDto.getLocDtos()) { | 
 |  |  |             if (locDto.getAnfme()==null || locDto.getAnfme() <= 0.0D) { continue; } | 
 |  |  |             if (locDto.getAnfme() == null || locDto.getAnfme() <= 0.0D) { | 
 |  |  |                 continue; | 
 |  |  |             } | 
 |  |  |             LocDetl locDetl = locDetlService.selectItem(locDto.getLocNo(), locDto.getMatnr(), locDto.getBatch(), locDto.getContainerCode()); | 
 |  |  |             if (locDetl == null || locDetl.getAnfme() < locDto.getAnfme()) { | 
 |  |  |                 throw new CoolException(locDto.getLocNo() + "库位中" + locDto.getMatnr() + "商品库存不足!"); | 
 |  |  | 
 |  |  |                 } | 
 |  |  |                 //补货单则生成AGV入库通知档 | 
 |  |  |                 generateAgvWaitpakin(wrkDetl); | 
 |  |  |             }else { | 
 |  |  |             } else { | 
 |  |  |                 List<OrderDto> orderDtoList = JSON.parseArray(locDto.getOrderNo(), OrderDto.class); | 
 |  |  |                 orderDtoList.forEach(orderDto -> { | 
 |  |  |                     WrkDetl wrkDetl = new WrkDetl(); | 
 |  |  | 
 |  |  |  | 
 |  |  |             // 修改订单明细 | 
 |  |  |             if (!BaseController.isJSON(locDto.getOrderNo())) { | 
 |  |  |                 OrderDetl orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch(),locDto.getCsocode(),locDto.getIsoseq()); | 
 |  |  |                 OrderDetl orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch(), locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |                 if (orderDetl == null) { | 
 |  |  |                     orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), null,locDto.getCsocode(),locDto.getIsoseq()); | 
 |  |  |                     orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), null, locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |                 } | 
 |  |  |                 if (!orderDetlService.increase(orderDetl.getOrderId(), orderDetl.getMatnr(), orderDetl.getBatch(), locDto.getAnfme(),locDto.getCsocode(),locDto.getIsoseq())) { | 
 |  |  |                 if (!orderDetlService.increase(orderDetl.getOrderId(), orderDetl.getMatnr(), orderDetl.getBatch(), locDto.getAnfme(), locDto.getCsocode(), locDto.getIsoseq())) { | 
 |  |  |                     throw new CoolException("修改订单明细数量失败"); | 
 |  |  |                 } | 
 |  |  |                 orderService.updateSettle(orderDetl.getOrderId(), 2L, userId); | 
 |  |  | 
 |  |  |                 Double orderAnfme; | 
 |  |  |  | 
 |  |  |                 for (OrderDto orderDto : orderDtoList) { | 
 |  |  |                     OrderDetl orderDetl = orderDetlService.selectItem(orderDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch(),locDto.getCsocode(),locDto.getIsoseq()); | 
 |  |  |                     OrderDetl orderDetl = orderDetlService.selectItem(orderDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch(), locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |                     if (orderDetl == null) { | 
 |  |  |                         orderDetl = orderDetlService.selectItem(orderDto.getOrderNo(), locDto.getMatnr(), null,locDto.getCsocode(),locDto.getIsoseq()); | 
 |  |  |                         orderDetl = orderDetlService.selectItem(orderDto.getOrderNo(), locDto.getMatnr(), null, locDto.getCsocode(), locDto.getIsoseq()); | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     orderAnfme = orderDetl.getAnfme() - orderDetl.getQty(); | 
 |  |  |  | 
 |  |  |                     if(locAnfme > orderAnfme){ | 
 |  |  |                     if (locAnfme > orderAnfme) { | 
 |  |  |                         locAnfme -= orderAnfme; | 
 |  |  |                     }else { | 
 |  |  |                     } else { | 
 |  |  |                         orderAnfme = locAnfme; | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     if (!orderDetlService.increase(orderDetl.getOrderId(), orderDetl.getMatnr(), orderDetl.getBatch(), orderAnfme,orderDetl.getThreeCode(),orderDetl.getDeadTime())) { | 
 |  |  |                     if (!orderDetlService.increase(orderDetl.getOrderId(), orderDetl.getMatnr(), orderDetl.getBatch(), orderAnfme, orderDetl.getThreeCode(), orderDetl.getDeadTime())) { | 
 |  |  |                         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.setLocSts(ioType == 101 ? "R" : "P"); | 
 |  |  |             locMast.setModiUser(userId); | 
 |  |  |             locMast.setModiTime(now); | 
 |  |  |             if (!locMastService.updateById(locMast)) { | 
 |  |  |                 throw new CoolException("预约库位状态失败,库位号:"+taskDto.getLocNo()); | 
 |  |  |                 throw new CoolException("预约库位状态失败,库位号:" + taskDto.getLocNo()); | 
 |  |  |             } | 
 |  |  |         } else { | 
 |  |  |             throw new CoolException(taskDto.getLocNo() + "库位不是在库状态"); | 
 |  |  | 
 |  |  |         wrkMast.setIoType(10); // 入出库状态:10.空板入库 | 
 |  |  |         Double ioPri = wrkMastService.getIoPri(10, dto.getLocNo()); | 
 |  |  |         wrkMast.setIoPri(ioPri); // 优先级:10 | 
 |  |  |         wrkMast.setOutMost(locMastService.isOutMost(dto.getLocNo(), true)?1:0);; | 
 |  |  |         wrkMast.setOutMost(locMastService.isOutMost(dto.getLocNo(), true) ? 1 : 0); | 
 |  |  |         ; | 
 |  |  |         wrkMast.setCrnNo(dto.getCrnNo()); | 
 |  |  |         wrkMast.setSourceStaNo(dto.getSourceStaNo()); | 
 |  |  |         wrkMast.setStaNo(dto.getStaNo()); | 
 |  |  | 
 |  |  |         sourceStaNo.setWrkNo(workNo); | 
 |  |  |         sourceStaNo.setModiUser(userId); | 
 |  |  |         sourceStaNo.setModiTime(new Date()); | 
 |  |  |         if (!basDevpService.updateById(sourceStaNo)){ | 
 |  |  |         if (!basDevpService.updateById(sourceStaNo)) { | 
 |  |  |             throw new CoolException("更新源站失败"); | 
 |  |  |         } | 
 |  |  |         // 更新目标库位状态 | 
 |  |  |         LocMast locMast = locMastService.selectById(dto.getLocNo()); | 
 |  |  |         if (locMast.getLocSts().equals("O")){ | 
 |  |  |         if (locMast.getLocSts().equals("O")) { | 
 |  |  |             locMast.setLocSts("S"); // S.入库预约 | 
 |  |  |             locMast.setModiUser(userId); | 
 |  |  |             locMast.setModiTime(new Date()); | 
 |  |  |             if (!locMastService.updateById(locMast)){ | 
 |  |  |             if (!locMastService.updateById(locMast)) { | 
 |  |  |                 throw new CoolException("改变库位状态失败"); | 
 |  |  |             } | 
 |  |  |         } else { | 
 |  |  |             throw new CoolException(dto.getLocNo()+"目标库位已被占用"); | 
 |  |  |             throw new CoolException(dto.getLocNo() + "目标库位已被占用"); | 
 |  |  |         } | 
 |  |  |         return dto.getLocNo(); | 
 |  |  |     } | 
 |  |  | 
 |  |  |     public void emptyPlateOut(EmptyPlateOutParam param, Long userId) { | 
 |  |  |         List<String> locNos = param.getLocNos(); | 
 |  |  |         //检测是否为浅库位 | 
 |  |  |         boolean sign=false; | 
 |  |  |         boolean sign = false; | 
 |  |  |         String th = ""; | 
 |  |  |         for (String locNo:locNos){ | 
 |  |  |             if (sign){ | 
 |  |  |         for (String locNo : locNos) { | 
 |  |  |             if (sign) { | 
 |  |  |                 break; | 
 |  |  |             } | 
 |  |  |             List<String> groupInnerLoc = Utils.getGroupInnerLoc(locNo); | 
 |  |  |             if (!Cools.isEmpty(groupInnerLoc)) { | 
 |  |  |                 for (String insideLoc : groupInnerLoc) { | 
 |  |  |                     if (locNos.contains(insideLoc)){ | 
 |  |  |                     if (locNos.contains(insideLoc)) { | 
 |  |  |                         continue; | 
 |  |  |                     } | 
 |  |  |                     LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", insideLoc)); | 
 |  |  |                     if (locMast != null) { | 
 |  |  |                         if (!locMast.getLocSts().equals("O") && !locMast.getLocSts().equals("R")){ | 
 |  |  |                             sign=true; | 
 |  |  |                             th="库位号:"+locNo+" 浅库位有非空库位!"; | 
 |  |  |                         if (!locMast.getLocSts().equals("O") && !locMast.getLocSts().equals("R")) { | 
 |  |  |                             sign = true; | 
 |  |  |                             th = "库位号:" + locNo + " 浅库位有非空库位!"; | 
 |  |  |                             break; | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         if (sign){ | 
 |  |  |             throw new CoolException("出库失败;"+th); | 
 |  |  |         if (sign) { | 
 |  |  |             throw new CoolException("出库失败;" + th); | 
 |  |  |         } | 
 |  |  |         if (Cools.isEmpty(param.getOutSite())) { | 
 |  |  |             throw new CoolException("站点不存在"); | 
 |  |  | 
 |  |  |             // 获取库位 | 
 |  |  |             LocMast locMast = locMastService.selectById(locNo); | 
 |  |  |             if (Cools.isEmpty(locMast)) { | 
 |  |  |                 throw new CoolException(locNo+"库位不存在"); | 
 |  |  |                 throw new CoolException(locNo + "库位不存在"); | 
 |  |  |             } | 
 |  |  |             Boolean outMost = locMastService.isOutMost(locNo, false); | 
 |  |  |             Integer outCrnNo = locMastService.getOutCrnNo(locMast); | 
 |  |  |             // 获取源站 | 
 |  |  |             Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() | 
 |  |  |                     .eq("type_no", 110) | 
 |  |  |                     .eq("stn_no", param.getOutSite()); | 
 |  |  |             Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>().eq("type_no", 110).eq("stn_no", param.getOutSite()); | 
 |  |  |             StaDesc staDesc = staDescService.selectOne(wrapper); | 
 |  |  |             if (Cools.isEmpty(staDesc)) { | 
 |  |  |                 throw new CoolException("非法路径!"); | 
 |  |  | 
 |  |  |             wrkMast.setIoPri(ioPri); | 
 |  |  |             wrkMast.setSourceStaNo(sourceStaNo); // 源站 | 
 |  |  |             wrkMast.setStaNo(param.getOutSite()); // 目标站 | 
 |  |  |             wrkMast.setOutMost(outMost?1:0);; | 
 |  |  |             wrkMast.setCrnNo(outMost?outCrnNo:locMast.getCrnNo()); | 
 |  |  |             wrkMast.setOutMost(outMost ? 1 : 0); | 
 |  |  |             ; | 
 |  |  |             wrkMast.setCrnNo(outMost ? outCrnNo : locMast.getCrnNo()); | 
 |  |  |             wrkMast.setSourceLocNo(locNo); // 源库位 | 
 |  |  |             wrkMast.setFullPlt("N"); // 满板:Y | 
 |  |  |             wrkMast.setPicking("N"); // 拣料 | 
 |  |  | 
 |  |  |                 throw new CoolException("保存工作档失败"); | 
 |  |  |             } | 
 |  |  |             // 更新库位状态 D.空板 -> R.出库预约 | 
 |  |  |             if (locMast.getLocSts().equals("D")){ | 
 |  |  |             if (locMast.getLocSts().equals("D")) { | 
 |  |  |                 locMast.setLocSts("R"); | 
 |  |  |                 locMast.setModiUser(userId); | 
 |  |  |                 locMast.setModiTime(new Date()); | 
 |  |  | 
 |  |  |         List<LocDetlDto> locDetlDtos = new ArrayList<>(); | 
 |  |  |         for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { | 
 |  |  |             if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) { | 
 |  |  |                 LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch(),paramLocDetl.getSuppCode()); | 
 |  |  |                 LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch(), paramLocDetl.getSuppCode()); | 
 |  |  |                 if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount())); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  | 
 |  |  |     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)){ | 
 |  |  |         if (Cools.isEmpty(sourceLoc)) { | 
 |  |  |             throw new CoolException("未找到库位"); | 
 |  |  |         } | 
 |  |  |         LocMast loc = locMastService.selectById(locNo); | 
 |  |  |         if (Cools.isEmpty(loc)){ | 
 |  |  |         if (Cools.isEmpty(loc)) { | 
 |  |  |             throw new CoolException("未找到库位"); | 
 |  |  |         } | 
 |  |  |         if (!sourceLoc.getCrnNo().equals(loc.getCrnNo())) { | 
 |  |  | 
 |  |  |         wrkMast.setWrkSts(21L); // 工作状态:21.生成出库任务 | 
 |  |  |         wrkMast.setIoType(11); // 入出库状态: 11.库格移载 | 
 |  |  |         wrkMast.setIoPri(10D); | 
 |  |  |         wrkMast.setOutMost(locMastService.isOutMost(locNo, false)?1:0);; | 
 |  |  |         wrkMast.setOutMost(locMastService.isOutMost(locNo, false) ? 1 : 0); | 
 |  |  |         ; | 
 |  |  |         wrkMast.setCrnNo(sourceLoc.getCrnNo()); | 
 |  |  |         wrkMast.setSourceLocNo(sourceLocNo); // 源库位 | 
 |  |  |         wrkMast.setLocNo(locNo); // 目标库位 | 
 |  |  |         wrkMast.setFullPlt(Cools.isEmpty(locDetls)?"N":"Y"); // 满板:Y | 
 |  |  |         wrkMast.setFullPlt(Cools.isEmpty(locDetls) ? "N" : "Y"); // 满板:Y | 
 |  |  |         wrkMast.setPicking("N"); // 拣料 | 
 |  |  |         wrkMast.setExitMk("N"); // 退出 | 
 |  |  |         wrkMast.setEmptyMk(sourceLoc.getLocSts().equals("D")?"Y":"N"); // 空板 | 
 |  |  |         wrkMast.setEmptyMk(sourceLoc.getLocSts().equals("D") ? "Y" : "N"); // 空板 | 
 |  |  |         wrkMast.setBarcode(sourceLoc.getBarcode()); // 货架码 | 
 |  |  |         wrkMast.setLinkMis("N"); | 
 |  |  |         wrkMast.setAppeUser(userId); | 
 |  |  | 
 |  |  |             sourceLoc.setLocSts("R"); // R.出库预约 | 
 |  |  |             sourceLoc.setModiUser(userId); | 
 |  |  |             sourceLoc.setModiTime(now); | 
 |  |  |             if (!locMastService.updateById(sourceLoc)){ | 
 |  |  |             if (!locMastService.updateById(sourceLoc)) { | 
 |  |  |                 throw new CoolException("更新源库位状态失败"); | 
 |  |  |             } | 
 |  |  |         } else { | 
 |  |  |             throw new CoolException(sourceLoc.getLocNo() + "源库位出库失败,状态:"+sourceLoc.getLocSts$()); | 
 |  |  |             throw new CoolException(sourceLoc.getLocNo() + "源库位出库失败,状态:" + sourceLoc.getLocSts$()); | 
 |  |  |         } | 
 |  |  |         // 修改目标库位状态 | 
 |  |  |         if (loc.getLocSts().equals("O")) { | 
 |  |  | 
 |  |  |                 throw new CoolException("更新目标库位状态失败"); | 
 |  |  |             } | 
 |  |  |         } else { | 
 |  |  |             throw new CoolException("移转失败,目标库位状态:"+loc.getLocSts$()); | 
 |  |  |             throw new CoolException("移转失败,目标库位状态:" + loc.getLocSts$()); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |     @Transactional | 
 |  |  |     public void completeWrkMast(String workNo, Long userId) { | 
 |  |  |         WrkMast wrkMast = wrkMastService.selectById(workNo); | 
 |  |  |         if (Cools.isEmpty(wrkMast)){ | 
 |  |  |             throw new CoolException(workNo+"工作档不存在"); | 
 |  |  |         if (Cools.isEmpty(wrkMast)) { | 
 |  |  |             throw new CoolException(workNo + "工作档不存在"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         if (wrkMast.getIoType() == 200) { | 
 |  |  | 
 |  |  |             throw new CoolException("当前工作档已完成"); | 
 |  |  |         } | 
 |  |  |         // 入库 + 库位转移 | 
 |  |  |         if (wrkMast.getWrkSts() < 9 || (wrkMast.getWrkSts() > 10 && wrkMast.getIoType()==11)) { | 
 |  |  |         if (wrkMast.getWrkSts() < 9 || (wrkMast.getWrkSts() > 10 && wrkMast.getIoType() == 11)) { | 
 |  |  |             wrkMast.setWrkSts(9L); | 
 |  |  |             // 出库 | 
 |  |  |         } else if (wrkMast.getWrkSts() > 20) { | 
 |  |  | 
 |  |  |             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()) && Cools.eq(locDetl.getSuppCode(),adjust.getSuppCode()) && Cools.eq(locDetl.getThreeCode(),adjust.getThreeCode()) && Cools.eq(locDetl.getDeadTime(),adjust.getDeadTime())) { | 
 |  |  |                 if (adjust.getCount() == 0) { | 
 |  |  |                     continue; | 
 |  |  |                 } | 
 |  |  |                 if (locDetl.getMatnr().equals(adjust.getMatnr()) && Cools.eq(locDetl.getBatch(), adjust.getBatch()) && Cools.eq(locDetl.getSuppCode(), adjust.getSuppCode()) && Cools.eq(locDetl.getThreeCode(), adjust.getThreeCode()) && Cools.eq(locDetl.getDeadTime(), adjust.getDeadTime())) { | 
 |  |  |                     if (!locDetl.getAnfme().equals(adjust.getCount())) { | 
 |  |  |                         // todo 盘点记录 | 
 |  |  |                         // 修改库存 | 
 |  |  |                         if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(),locDetl.getSuppCode(),locDetl.getThreeCode(),locDetl.getDeadTime())) { | 
 |  |  |                         if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(), locDetl.getSuppCode(), locDetl.getThreeCode(), locDetl.getDeadTime())) { | 
 |  |  |                             throw new CoolException(locDetl.getLocNo() + "库位," + locDetl.getMatnr() + "商品," + locDetl.getBatch() + "序列码修改数量失败"); | 
 |  |  |                         } | 
 |  |  |                         // 保存调整记录 | 
 |  |  | 
 |  |  |         // 删除库存 | 
 |  |  |         for (LocDetl locDetl : locDetls) { | 
 |  |  |             // todo 盘点记录 | 
 |  |  |             if (!locDetlService.updateAnfme(-1.0D, locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(),locDetl.getSuppCode(),locDetl.getThreeCode(),locDetl.getDeadTime())) { | 
 |  |  |             if (!locDetlService.updateAnfme(-1.0D, locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(), locDetl.getSuppCode(), locDetl.getThreeCode(), locDetl.getDeadTime())) { | 
 |  |  |                 throw new CoolException("删除" + locDetl.getLocNo() + "库位," + locDetl.getMatnr() + "商品," + locDetl.getBatch() + "序列码库存明细失败"); | 
 |  |  |             } | 
 |  |  |             // 保存调整记录 | 
 |  |  | 
 |  |  |  | 
 |  |  |         // 添加库存 | 
 |  |  |         for (LocDetlAdjustParam.LocDetlAdjust adjust : list) { | 
 |  |  |             if (adjust.getCount() == 0.0D) { continue; } | 
 |  |  |             if (adjust.getCount() == 0.0D) { | 
 |  |  |                 continue; | 
 |  |  |             } | 
 |  |  |             Mat mat = matService.selectByMatnr(adjust.getMatnr()); | 
 |  |  |             LocDetl locDetl = new LocDetl(); | 
 |  |  |             locDetl.sync(mat); | 
 |  |  | 
 |  |  |     @Transactional | 
 |  |  |     public void cancelWrkMast(String workNo, Long userId) { | 
 |  |  |         WrkMast wrkMast = wrkMastService.selectById(workNo); | 
 |  |  |         if (Cools.isEmpty(wrkMast)){ | 
 |  |  |             throw new CoolException(workNo+"工作档不存在"); | 
 |  |  |         if (Cools.isEmpty(wrkMast)) { | 
 |  |  |             throw new CoolException(workNo + "工作档不存在"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         if (wrkMast.getIoType() == 200) { | 
 |  |  | 
 |  |  |                 // 库位转移:源库位 | 
 |  |  |                 LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo()); | 
 |  |  |                 if (Cools.isEmpty(locMast)) { | 
 |  |  |                     throw new CoolException("取消库位转移失败,源库位不存在:"+ wrkMast.getSourceLocNo()); | 
 |  |  |                     throw new CoolException("取消库位转移失败,源库位不存在:" + wrkMast.getSourceLocNo()); | 
 |  |  |                 } | 
 |  |  |                 locMast.setLocSts("F"); | 
 |  |  |                 locMast.setModiTime(new Date()); | 
 |  |  |                 locMast.setModiUser(userId); | 
 |  |  |                 locMastService.updateById(locMast); | 
 |  |  |             } | 
 |  |  |         // 出库取消(修改源库位) | 
 |  |  |             // 出库取消(修改源库位) | 
 |  |  |         } else if (wrkMast.getWrkSts() > 20) { | 
 |  |  |             locNo = wrkMast.getSourceLocNo(); | 
 |  |  |             // 出库 ===>> F.在库 | 
 |  |  |             if (wrkMast.getIoType() > 100 && wrkMast.getIoType() != 110) { | 
 |  |  |                 locSts = "F"; | 
 |  |  |             // 空板出库 ===>> D.空桶/空栈板 | 
 |  |  |                 // 空板出库 ===>> D.空桶/空栈板 | 
 |  |  |             } else if (wrkMast.getIoType() == 110) { | 
 |  |  |                 locSts = "D"; | 
 |  |  |             // 库位转移 ===>> D.空桶/空栈板 | 
 |  |  |                 // 库位转移 ===>> D.空桶/空栈板 | 
 |  |  |             } else if (wrkMast.getIoType() == 11) { | 
 |  |  |                 locSts = wrkMast.getFullPlt().equalsIgnoreCase("N")?"D":"F"; | 
 |  |  |                 locSts = wrkMast.getFullPlt().equalsIgnoreCase("N") ? "D" : "F"; | 
 |  |  |                 // 库位转移:目标库位 | 
 |  |  |                 LocMast locMast = locMastService.selectById(wrkMast.getLocNo()); | 
 |  |  |                 if (Cools.isEmpty(locMast)) { | 
 |  |  |                     throw new CoolException("取消库位转移失败,目标库位不存在:"+ wrkMast.getSourceLocNo()); | 
 |  |  |                     throw new CoolException("取消库位转移失败,目标库位不存在:" + wrkMast.getSourceLocNo()); | 
 |  |  |                 } | 
 |  |  |                 locMast.setLocSts("O"); | 
 |  |  |                 locMast.setModiTime(new Date()); | 
 |  |  | 
 |  |  |             if (!Cools.isEmpty(wrkDetl.getOrderNo())) { | 
 |  |  |                 if (!BaseController.isJSON(wrkDetl.getOrderNo())) { | 
 |  |  |  | 
 |  |  |                     if (!orderDetlService.decrease(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getAnfme(),wrkDetl.getThreeCode(),wrkDetl.getDeadTime())) { | 
 |  |  |                     if (!orderDetlService.decrease(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getAnfme(), wrkDetl.getThreeCode(), wrkDetl.getDeadTime())) { | 
 |  |  |                         throw new CoolException("订单数据回滚失败"); | 
 |  |  |                     } | 
 |  |  |                 } else { | 
 |  |  | 
 |  |  |                     List<OrderDto> orderDtoList = JSON.parseArray(wrkDetl.getOrderNo(), OrderDto.class); | 
 |  |  |                     for (OrderDto orderDto : orderDtoList) { | 
 |  |  |  | 
 |  |  |                         if(wrkDetlAnfme > orderDto.getAnfme()){ | 
 |  |  |                         if (wrkDetlAnfme > orderDto.getAnfme()) { | 
 |  |  |                             orderAnfme = orderDto.getAnfme(); | 
 |  |  |                             wrkDetlAnfme -= orderAnfme; | 
 |  |  |                         }else { | 
 |  |  |                         } else { | 
 |  |  |                             orderAnfme = wrkDetlAnfme; | 
 |  |  |                         } | 
 |  |  |  | 
 |  |  |                         if (!orderDetlService.decrease(orderDto.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), orderAnfme,wrkDetl.getThreeCode(),wrkDetl.getDeadTime())) { | 
 |  |  |                         if (!orderDetlService.decrease(orderDto.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), orderAnfme, wrkDetl.getThreeCode(), wrkDetl.getDeadTime())) { | 
 |  |  |                             throw new CoolException("订单数据回滚失败"); | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  | 
 |  |  |         // 修改库位状态 | 
 |  |  |         LocMast locMast = locMastService.selectById(locNo); | 
 |  |  |         if (Cools.isEmpty(locMast)) { | 
 |  |  |             throw new CoolException("取消工作档失败,库位不存在:"+ locNo); | 
 |  |  |             throw new CoolException("取消工作档失败,库位不存在:" + locNo); | 
 |  |  |         } | 
 |  |  |         locMast.setLocSts(locSts); | 
 |  |  |         locMast.setModiTime(new Date()); | 
 |  |  | 
 |  |  |     @Transactional | 
 |  |  |     public void pickWrkMast(String workNo, Long userId) { | 
 |  |  |         WrkMast wrkMast = wrkMastService.selectById(workNo); | 
 |  |  |         if (Cools.isEmpty(wrkMast)){ | 
 |  |  |             throw new CoolException(workNo+"工作档不存在"); | 
 |  |  |         if (Cools.isEmpty(wrkMast)) { | 
 |  |  |             throw new CoolException(workNo + "工作档不存在"); | 
 |  |  |         } | 
 |  |  |         // 入出库类型判断 | 
 |  |  |         if (wrkMast.getIoType() != 103 && wrkMast.getIoType() != 104 && wrkMast.getIoType() != 107) { | 
 |  |  | 
 |  |  |             throw new CoolException("保存工作主档历史档失败"); | 
 |  |  |         } | 
 |  |  |         // 获取目标站 | 
 |  |  |         Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() | 
 |  |  |                 .eq("type_no", wrkMast.getIoType() - 50) | 
 |  |  |                 .eq("stn_no", wrkMast.getStaNo()) // 作业站点 = 拣料出库的目标站 | 
 |  |  |         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)) { | 
 |  |  | 
 |  |  |         return ""; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     private void generateAgvWaitpakin(WrkDetl wrkDetl){ | 
 |  |  |     private void generateAgvWaitpakin(WrkDetl wrkDetl) { | 
 |  |  |         String orderNo = wrkDetl.getOrderNo(); | 
 |  |  |         if(orderNo.contains("{")){ | 
 |  |  |         if (orderNo.contains("{")) { | 
 |  |  |             JSONArray orderArray = JSON.parseArray(orderNo); | 
 |  |  |             for (Object o : orderArray){ | 
 |  |  |             for (Object o : orderArray) { | 
 |  |  |                 JSONObject jsonobject = (JSONObject) o; | 
 |  |  |                 Order order = orderService.selectByNo(jsonobject.get("orderNo").toString()); | 
 |  |  |                 DocType docType = docTypeService.selectById(order.getDocType()); | 
 |  |  |                 if("人工补货单".equals(docType.getDocName())){ | 
 |  |  |                 if ("人工补货单".equals(docType.getDocName())) { | 
 |  |  |                     throw new CoolException("合并单据中包含人工补货单,单据为: " + jsonobject.get("orderNo")); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |         }else { | 
 |  |  |         } else { | 
 |  |  |             Order order = orderService.selectByNo(orderNo); | 
 |  |  |             DocType docType = docTypeService.selectById(order.getDocType()); | 
 |  |  |             if("人工补货单".equals(docType.getDocName())){ | 
 |  |  |             if ("人工补货单".equals(docType.getDocName())) { | 
 |  |  |                 AgvWaitPakin agvWaitPakin = new AgvWaitPakin(); | 
 |  |  |                 BeanUtils.copyProperties(wrkDetl,agvWaitPakin); | 
 |  |  |                 BeanUtils.copyProperties(wrkDetl, agvWaitPakin); | 
 |  |  |                 agvWaitPakinService.insert(agvWaitPakin); | 
 |  |  |             } | 
 |  |  |         } | 
 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private OrderDetlService orderDetlService; | 
 |  |  |     @Autowired | 
 |  |  |     private OrderDetlService orderDetlService; | 
 |  |  |     @Autowired | 
 |  |  |     private SnowflakeIdWorker snowflakeIdWorker; | 
 |  |  |     @Autowired | 
 |  |  |     private FlowLogService flowLogService; | 
 |  |  | 
 |  |  |         //用于上报mes的工作档明细 | 
 |  |  |         List<AgvWrkDetl> agvWrkDetlListOld = agvWrkDetlService.selectList(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", agvWrkMast.getWrkNo())); | 
 |  |  |  | 
 |  |  |         try { | 
 |  |  |         long flowId = snowflakeIdWorker.nextId(); | 
 |  |  |         Date now = new Date(); | 
 |  |  |         try{ | 
 |  |  |         try { | 
 |  |  |             int wrkNo = agvWrkMast.getWrkNo(); | 
 |  |  |             String barcode = agvWrkMast.getBarcode(); | 
 |  |  |             String orderNo = getOrderNoByWrkNo(wrkNo); | 
 |  |  | 
 |  |  | //                            if (!flowLogService.insert(flowLog)) { | 
 |  |  | //                                throw new CoolException("同步半成品调拨单流水记录失败"); | 
 |  |  | //                            } | 
 |  |  |                             agvLocDetlService.updateAnfme(updateAnfme,agvLocDetl.getLocNo(),agvLocDetl.getMatnr(),agvLocDetl.getBatch(),agvLocDetl.getThreeCode(),agvLocDetl.getDeadTime()); | 
 |  |  |                             agvLocDetlService.updateAnfme(updateAnfme, agvLocDetl.getLocNo(), agvLocDetl.getMatnr(), agvLocDetl.getBatch(), agvLocDetl.getThreeCode(), agvLocDetl.getDeadTime()); | 
 |  |  |                         } | 
 |  |  |                         //AgvLocDetl agvLocDetl = agvLocDetlService.selectLocdetl(agvWrkMast.getLocNo(),agvWrkDetl.getMatnr(),agvWrkDetl.getBatch(),agvWrkDetl.getThreeCode(),agvWrkDetl.getDeadTime()); | 
 |  |  |  | 
 |  |  | 
 |  |  |                         } | 
 |  |  |                     }); | 
 |  |  |                     // 更新站点 + 库位状态     源库位是站点 | 
 |  |  |                     agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     break; | 
 |  |  |                 case 58: | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     break; | 
 |  |  |                 case 108: | 
 |  |  |                 case 114: | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     //更新库存明细 | 
 |  |  |                     agvLocDetlService.updateStock(agvWrkMast.getSourceLocNo(),agvWrkMast.getLocNo()); | 
 |  |  |                     agvLocDetlService.updateStock(agvWrkMast.getSourceLocNo(), agvWrkMast.getLocNo()); | 
 |  |  |                     //修改源库位状态为O | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue(),"",(short)0); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue(), "", (short) 0); | 
 |  |  |                     break; | 
 |  |  |                 case 109: | 
 |  |  |                     // 库位 -- 接驳位 / 库位 | 
 |  |  |                     if (agvWrkMast.getLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     if (agvWrkMast.getLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                         // 接驳位 -- 库位 | 
 |  |  |                     } else { | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"D",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "D", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     } | 
 |  |  |                     // 接驳位 -- 库位 | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",(short)0); | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", (short) 0); | 
 |  |  |                         // 库位 -- 接驳位 / 库位 | 
 |  |  |                     } else { | 
 |  |  |                         //修改源库位状态为O | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue(),"",(short)0); | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue(), "", (short) 0); | 
 |  |  |                     } | 
 |  |  |                     break; | 
 |  |  |                 case 111: | 
 |  |  |                     // 库位 -- 接驳位 / 库位 | 
 |  |  |                     if (agvWrkMast.getLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     if (agvWrkMast.getLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                         // 接驳位 -- 库位 | 
 |  |  |                     } else { | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"D",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "D", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     // 接驳位 -- 库位 | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",(short)0); | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", (short) 0); | 
 |  |  |                         // 库位 -- 接驳位 / 库位 | 
 |  |  |                     } else { | 
 |  |  |                         //修改源库位状态为O | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue(),"",(short)0); | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue(), "", (short) 0); | 
 |  |  |                         //更新目标库位明细 101.出库 删除源库位库存明细 | 
 |  |  |                         agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no",agvWrkMast.getSourceLocNo())); | 
 |  |  |                         agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no", agvWrkMast.getSourceLocNo())); | 
 |  |  |                     } | 
 |  |  |                     break; | 
 |  |  |                 case 112: | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectList(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", agvWrkMast.getWrkNo())); | 
 |  |  |                     for (AgvWrkDetl agvWrkDetl : agvWrkDetls) { | 
 |  |  |                         AgvLocDetl locDetl = new AgvLocDetl(); | 
 |  |  | 
 |  |  |                         agvLocDetlService.insert(locDetl); | 
 |  |  |                     } | 
 |  |  |                     // 接驳位 -- 库位 | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",(short)0); | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", (short) 0); | 
 |  |  |                         // 库位 -- 接驳位 / 库位 | 
 |  |  |                     } else { | 
 |  |  |                         //修改源库位状态为O | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue(),"",(short)0); | 
 |  |  |                         agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue(), "", (short) 0); | 
 |  |  |                     } | 
 |  |  |                     break; | 
 |  |  |                 case 113: | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"D",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "D", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     // 接驳位 -- 库位 | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0,2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(),"O","",(short)0); | 
 |  |  |                     if (agvWrkMast.getSourceLocNo().substring(0, 2).equals("DB")) { | 
 |  |  |                         agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", (short) 0); | 
 |  |  |                     } | 
 |  |  |                     break; | 
 |  |  |                 case 121: | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(),"F",agvWrkMast.getBarcode(),agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue()); | 
 |  |  |                     //更新库存明细 | 
 |  |  |                     agvLocDetlService.updateStock(agvWrkMast.getSourceLocNo(),agvWrkMast.getLocNo()); | 
 |  |  |                     agvLocDetlService.updateStock(agvWrkMast.getSourceLocNo(), agvWrkMast.getLocNo()); | 
 |  |  |                     //修改源库位状态为O | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",agvWrkMast.getWhsType().shortValue(),"",(short)0); | 
 |  |  |                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue(), "", (short) 0); | 
 |  |  |                     break; | 
 |  |  |  | 
 |  |  |                 default: | 
 |  |  | 
 |  |  |                 //删除AGV工作档 | 
 |  |  |                 agvWrkMastService.deleteById(wrkNo); | 
 |  |  |                 //删除AGV工作明细档 | 
 |  |  |                 agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no",wrkNo)); | 
 |  |  |                 agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", wrkNo)); | 
 |  |  |             } | 
 |  |  | //            else { | 
 |  |  | //                agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getLocNo(),"O","",agvWrkMast.getWhsType().shortValue()); | 
 |  |  | 
 |  |  | //                agvWrkMastService.updateById(agvWrkMast); | 
 |  |  | //            } | 
 |  |  |  | 
 |  |  |             if(!isJSON(orderNo)){ | 
 |  |  |             if (!isJSON(orderNo)) { | 
 |  |  |                 //检查订单是否已完成 | 
 |  |  |                 orderService.checkComplete(orderNo, agvWrkMast.getPltType()); | 
 |  |  |             } else { | 
 |  |  | 
 |  |  |             agvWrkMastService.updateById(agvWrkMast); | 
 |  |  |             //修改源库位状态为O | 
 |  |  |             if (agvWrkMast.getIoType() == 110) { | 
 |  |  |                 agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",null); | 
 |  |  |                 agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", null); | 
 |  |  |             } | 
 |  |  |             if(agvWrkMast.getIoType() == 101){ | 
 |  |  |             if (agvWrkMast.getIoType() == 101) { | 
 |  |  |                 //更新目标库位明细 101.出库 删除源库位库存明细 | 
 |  |  |                 agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no",agvWrkMast.getSourceLocNo())); | 
 |  |  |                 agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no", agvWrkMast.getSourceLocNo())); | 
 |  |  |                 //生成空板入库任务 | 
 |  |  |                 Short containerType = Short.valueOf(agvWrkMast.getBarcode().substring(0, 2)); | 
 |  |  |                 try { | 
 |  |  | 
 |  |  |                     agvBasDevp.setLocSts("R"); | 
 |  |  |                     agvBasDevp.setLocType2(Short.valueOf(agvWrkMast.getBarcode().substring(0, 2))); | 
 |  |  |                     agvBasDevpService.updateById(agvBasDevp); | 
 |  |  |                 }catch (Exception e){ | 
 |  |  |                 } catch (Exception e) { | 
 |  |  |                     e.printStackTrace(); | 
 |  |  |                     log.error(e.getMessage()); | 
 |  |  |                 } | 
 |  |  | 
 |  |  |             //删除AGV工作档 | 
 |  |  |             agvWrkMastService.deleteById(wrkNo); | 
 |  |  |             //删除AGV工作明细档 | 
 |  |  |             agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no",wrkNo)); | 
 |  |  |             if(!isJSON(orderNo)){ | 
 |  |  |             agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", wrkNo)); | 
 |  |  |             if (!isJSON(orderNo)) { | 
 |  |  |                 //检查订单是否已完成 | 
 |  |  |                 orderService.checkComplete(orderNo); | 
 |  |  |             }else{ | 
 |  |  |                 orderService.checkComplete(orderNo, agvWrkMast.getPltType()); | 
 |  |  |             } else { | 
 |  |  |                 List<Map> maps = JSONArray.parseArray(orderNo, Map.class); | 
 |  |  |                 maps.forEach(map -> { | 
 |  |  |                     String o = map.get("orderNo").toString(); | 
 |  |  | 
 |  |  |             agvWrkMast.setModiTime(new Date()); | 
 |  |  |             agvWrkMastService.updateById(agvWrkMast); | 
 |  |  |             //修改源库位状态为O | 
 |  |  |             agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(),"O","",null); | 
 |  |  |             if(agvWrkMast.getIoType() == 101){ | 
 |  |  |             agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", null); | 
 |  |  |             if (agvWrkMast.getIoType() == 101) { | 
 |  |  |                 //更新目标库位明细 101.出库 删除源库位库存明细 | 
 |  |  |                 agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no",agvWrkMast.getSourceLocNo())); | 
 |  |  |                 agvLocDetlService.delete(new EntityWrapper<AgvLocDetl>().eq("loc_no", agvWrkMast.getSourceLocNo())); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             //生成AGV工作历史档 | 
 |  |  | 
 |  |  |             //删除AGV工作档 | 
 |  |  |             agvWrkMastService.deleteById(wrkNo); | 
 |  |  |             //删除AGV工作明细档 | 
 |  |  |             agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no",wrkNo)); | 
 |  |  |             if(!isJSON(orderNo)){ | 
 |  |  |             agvWrkDetlService.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", wrkNo)); | 
 |  |  |             if (!isJSON(orderNo)) { | 
 |  |  |                 //检查订单是否已完成 | 
 |  |  |                 orderService.checkComplete(orderNo); | 
 |  |  |             }else{ | 
 |  |  |                 orderService.checkComplete(orderNo, agvWrkMast.getPltType()); | 
 |  |  |             } else { | 
 |  |  |                 List<Map> maps = JSONArray.parseArray(orderNo, Map.class); | 
 |  |  |                 maps.forEach(map -> { | 
 |  |  |                     String o = map.get("orderNo").toString(); | 
 |  |  |                     orderService.checkComplete(o); | 
 |  |  |                     orderService.checkComplete(o, agvWrkMast.getPltType()); | 
 |  |  |                 }); | 
 |  |  |             } | 
 |  |  |             //上报mes | 
 |  |  | 
 |  |  |     @Synchronized | 
 |  |  |     public ReturnT<String> startPutWayWrk(AgvWrkMast agvWrkMast) throws IOException { | 
 |  |  |  | 
 |  |  |         try{ | 
 |  |  |         try { | 
 |  |  |             //下发任务 | 
 |  |  |             int startWrkCode = agvWrkMastService.startWrk(agvWrkMast); | 
 |  |  |             if(startWrkCode != 0){ | 
 |  |  |             if (startWrkCode != 0) { | 
 |  |  |                 throw new CoolException("任务下发失败"); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             agvWrkMast.setWrkSts(202L); | 
 |  |  |             agvWrkMast.setModiTime(new Date()); | 
 |  |  |             agvWrkMastService.updateById(agvWrkMast); | 
 |  |  |             if(agvWrkMast.getIoType() == 1){ | 
 |  |  |             if (agvWrkMast.getIoType() == 1) { | 
 |  |  |                 //修改AGV入库通知档状态入出状态为Y | 
 |  |  |                 agvWaitPakinService.updateIoStatus(agvWrkMast.getWrkNo(),"Y"); | 
 |  |  |                 agvWaitPakinService.updateIoStatus(agvWrkMast.getWrkNo(), "Y"); | 
 |  |  |             } | 
 |  |  |             return SUCCESS; | 
 |  |  |         } catch (Exception e) { | 
 |  |  | 
 |  |  |     @Transactional | 
 |  |  |     @Synchronized | 
 |  |  |     public ReturnT<String> startAllcationIn(AgvWrkMast agvWrkMast) throws IOException { | 
 |  |  |          | 
 |  |  |  | 
 |  |  |         //下发任务 | 
 |  |  |         try{ | 
 |  |  |         try { | 
 |  |  |             int startWrkCode = agvWrkMastService.startAllcationIn(agvWrkMast); | 
 |  |  |             if(startWrkCode != 0){ | 
 |  |  |             if (startWrkCode != 0) { | 
 |  |  |                 throw new CoolException("任务下发失败"); | 
 |  |  |             } | 
 |  |  |             return SUCCESS; | 
 |  |  |         }catch (Exception e){ | 
 |  |  |             log.error("任务下发失败"+e.getMessage()); | 
 |  |  |         } catch (Exception e) { | 
 |  |  |             log.error("任务下发失败" + e.getMessage()); | 
 |  |  |         } | 
 |  |  |         return FAIL; | 
 |  |  |  | 
 |  |  | 
 |  |  |             List<Map<String, Object>> devNoMaps = agvBasDevpService.selectDevNoAndNumBystationCode(agvWrkMast.getLocNo()); | 
 |  |  |             //取第一个暂存位,并查询其次数与配置的次数做比较 | 
 |  |  |             Map<String, Object> devNoMap = devNoMaps.get(0); | 
 |  |  |             if((int)devNoMap.get("num") < maxWrokNum){ | 
 |  |  |             if ((int) devNoMap.get("num") < maxWrokNum) { | 
 |  |  |                 agvWrkMast.setLocNo(devNoMap.get("dev_no").toString()); | 
 |  |  |                 agvWrkMast.setModiTime(new Date()); | 
 |  |  |                 agvWrkMastService.updateById(agvWrkMast); | 
 |  |  |                 log.info("after:" + devNoMap.toString()  +  ", wrkNo:" + agvWrkMast.getWrkNo() + ", locNo: " + agvWrkMast.getLocNo()); | 
 |  |  |                 log.info("after:" + devNoMap.toString() + ", wrkNo:" + agvWrkMast.getWrkNo() + ", locNo: " + agvWrkMast.getLocNo()); | 
 |  |  |             } | 
 |  |  |         }); | 
 |  |  |  | 
 |  |  | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     private List<AgvWrkMast> filter(List<AgvWrkMast> agvWrkMastList){ | 
 |  |  |     private List<AgvWrkMast> filter(List<AgvWrkMast> agvWrkMastList) { | 
 |  |  |         return agvWrkMastList.stream().filter(agvWrkMast -> { | 
 |  |  |             AgvWrkMast agvWrkMastWroking = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("source_loc_no", agvWrkMast.getLocNo())); | 
 |  |  |             if(!Cools.isEmpty(agvWrkMastWroking) && agvWrkMastWroking.getWrkSts()<=202){ | 
 |  |  |             if (!Cools.isEmpty(agvWrkMastWroking) && agvWrkMastWroking.getWrkSts() <= 202) { | 
 |  |  |                 System.out.println("source_loc_no > 1"); | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  | 
 |  |  |     /* | 
 |  |  |   生成工作档 | 
 |  |  |    */ | 
 |  |  |     private AgvWrkMast createWrkMast(int ioType, long wrkSts, String sourceLocNo, String locNo, String barcode, Date now, Long userId, int containerType, int floor){ | 
 |  |  |     private AgvWrkMast createWrkMast(int ioType, long wrkSts, String sourceLocNo, String locNo, String barcode, Date now, Long userId, int containerType, int floor) { | 
 |  |  |         AgvWrkMast wrkMast = new AgvWrkMast(); | 
 |  |  |         //工作状态 | 
 |  |  |         wrkMast.setWrkSts(wrkSts); | 
 |  |  | 
 |  |  |             throw new CoolException("保存工作档失败"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         wrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("loc_no", locNo).eq("source_loc_no",sourceLocNo).eq("barcode",barcode).orderBy("modi_time",false)); | 
 |  |  |         wrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("loc_no", locNo).eq("source_loc_no", sourceLocNo).eq("barcode", barcode).orderBy("modi_time", false)); | 
 |  |  |  | 
 |  |  |         return wrkMast; | 
 |  |  |     } |