| | |
| | | import com.core.exception.CoolException; |
| | | import com.zy.asrs.entity.*; |
| | | import com.zy.asrs.entity.param.EmptyPlateOutParam; |
| | | import com.zy.asrs.entity.result.KeyValueVo; |
| | | import com.zy.asrs.service.*; |
| | | import com.zy.common.CodeRes; |
| | | import com.zy.common.model.LocTypeDto; |
| | | import com.zy.common.model.StartupDto; |
| | | import com.zy.common.model.enums.WorkNoType; |
| | | import com.zy.common.service.CommonService; |
| | | import com.zy.common.web.param.SearchLocParam; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | private RowLastnoService rowLastnoService; |
| | | @Autowired |
| | | private WorkService workService; |
| | | @Autowired |
| | | private StaDescService staDescService; |
| | | |
| | | @PostMapping("/pakin/loc/v1") |
| | | @ResponseBody |
| | |
| | | case 10://空托盘入库 |
| | | dto = emptyPlateIn(param.getSourceStaNo(), locTypeDto, param.getBarcode()); |
| | | break; |
| | | // case 201://自动补空板任务 |
| | | // dto = emptyPlateIn201(param.getSourceStaNo(), locTypeDto, param.getBarcode()); |
| | | // break; |
| | | default: |
| | | break; |
| | | } |
| | | log.info("WCS入库接口返参:{},托盘码:{}", dto, param.getBarcode()); |
| | | return R.ok().add(dto); |
| | | } |
| | | |
| | | @PostMapping("/pakin2/loc/v1") |
| | | @ResponseBody |
| | | @Transactional |
| | | public synchronized R getLocNo2(@RequestBody SearchLocParam param) { |
| | | if (Cools.isEmpty(param.getIoType())) { |
| | | return R.error("入出库类型不能为空"); |
| | | } |
| | | if (Cools.isEmpty(param.getSourceStaNo())) { |
| | | return R.error("源站编号不能为空"); |
| | | } |
| | | if (Cools.isEmpty(param.getBarcode())) { |
| | | return R.error("条码不能为空"); |
| | | } |
| | | |
| | | // 源站点状态检测 |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(param.getSourceStaNo(), false); |
| | | sourceStaNo.setLocType1(param.getLocType1()); |
| | | // LocTypeDto locTypeDto = new LocTypeDto(sourceStaNo); |
| | | LocTypeDto locTypeDto = new LocTypeDto(); |
| | | locTypeDto.setLocType1((short)1); |
| | | |
| | | WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>() |
| | | .eq("barcode", param.getBarcode()) |
| | | .eq("io_type", param.getIoType()) |
| | | .eq("wrk_sts",14)); |
| | | StartupDto dto = new StartupDto(); |
| | | |
| | | if (Cools.isEmpty(wrkMast)){ |
| | | try{ |
| | | log.info("/pakin2/loc/v1:"+dto + "======托盘码:"+param.getBarcode()+"此笔工作档未查询到盘点/拣料出库任务,开始查询盘点/拣料再入库任务==》"); |
| | | WrkMast wrkMast1 = wrkMastService.selectOne(new EntityWrapper<WrkMast>() |
| | | .eq("barcode", param.getBarcode()) |
| | | .eq("io_type", param.getIoType()-50) |
| | | .eq("wrk_sts",2)); |
| | | if (Cools.isEmpty(wrkMast1)){ |
| | | return R.error("未查询到工作档===》托盘码:"+param.getBarcode()); |
| | | } |
| | | // 获取目标站 |
| | | Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() |
| | | .eq("type_no", param.getIoType()-50) |
| | | .eq("stn_no", sourceStaNo.getDevNo()) |
| | | .eq("crn_no", wrkMast1.getCrnNo()); |
| | | StaDesc staDesc = staDescService.selectOne(wrapper); |
| | | if (Cools.isEmpty(staDesc)) { |
| | | log.error("type_no={},stn_no={},crn_no={}", param.getIoType()-50, sourceStaNo, wrkMast1.getCrnNo()); |
| | | throw new CoolException("入库路径不存在"); |
| | | } |
| | | if (!staDesc.getCrnStn().equals(wrkMast1.getStaNo())){ |
| | | throw new CoolException("堆垛机作业站点与工作号目标站点不一致!!!请联系工程师修改"+ |
| | | "\\n堆垛机号:"+wrkMast1.getCrnNo()+ |
| | | "\\n堆垛机站点:"+staDesc.getCrnStn()+ |
| | | "\\n工作号:"+wrkMast1.getWrkNo()+ |
| | | "\\n工作档目标站点:"+wrkMast1.getStaNo()); |
| | | } |
| | | dto.setWorkNo(wrkMast1.getWrkNo()); |
| | | dto.setCrnNo(wrkMast1.getCrnNo()); |
| | | dto.setLocNo(wrkMast1.getLocNo()); |
| | | dto.setStaNo(wrkMast1.getStaNo()); |
| | | dto.setSourceStaNo(wrkMast1.getSourceStaNo()); |
| | | log.info("/pakin2/loc/v1:"+dto + "======托盘码:"+param.getBarcode()+"此笔工作档已经是盘点再入库状态,返回wcs下发信息"); |
| | | return R.ok().add(dto); |
| | | }catch (Exception e){ |
| | | log.error("/pakin2/loc/v1:======托盘码:"+param.getBarcode()+"盘点回库查询工作档出错======>"+e); |
| | | return R.error("查看wms==>info==>error"); |
| | | } |
| | | } |
| | | |
| | | List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("zpallet", param.getBarcode())); |
| | | if (Cools.isEmpty(locDetls) || locDetls.size()<1){ |
| | | return R.error("托盘码:"+param.getBarcode()+",未查到库存明细"); |
| | | }else { |
| | | if (!locDetls.get(0).getLocNo().equals(wrkMast.getSourceLocNo())){ |
| | | return R.error("明细已经被修改,故障"); |
| | | } |
| | | } |
| | | |
| | | Date now = new Date(); |
| | | if (param.getIoType() == 107 || param.getIoType() == 103) {//盘点再入库 |
| | | try{ |
| | | // 检索库位 |
| | | try{ |
| | | dto = commonService.getLocNo(1, 1, param.getSourceStaNo(), locDetls.get(0).getMatnr(),null,null, locTypeDto); |
| | | }catch (Exception e){ |
| | | log.error("堆垛机站盘点再入库查询库位出错:"+e.getMessage()+e); |
| | | throw new Exception("查询库位出错,参数:param.getSourceStaNo():"+param.getSourceStaNo()+"==>locDetls:"+locDetls+"==>locTypeDto:"+locTypeDto); |
| | | } |
| | | LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", dto.getLocNo())); |
| | | if (Cools.isEmpty(locMast) || Cools.isEmpty(locMast.getLocSts())){ |
| | | throw new Exception("目标库位locMast查询为空||locMast.getLocSts为空"); |
| | | }else { |
| | | if (!locMast.getLocSts().equals("O")){ |
| | | throw new Exception("目标库位!locMast.getLocSts.equals(“O”)"+locMast.getLocSts()); |
| | | }else { |
| | | locMast.setLocSts("Q"); |
| | | locMast.setBarcode(param.getBarcode()); |
| | | if (!locMastService.updateById(locMast)) { |
| | | log.error(" /pakin2/loc/v1 --- 修改库位状态失败!" + locMast.getLocNo()); |
| | | throw new Exception("修改库位状态失败"); |
| | | } |
| | | } |
| | | } |
| | | if (!locDetlService.updateLocNo(locMast.getLocNo(),wrkMast.getSourceLocNo())){ |
| | | log.error(" /pakin2/loc/v1 --- 库存明细转移失败!" + wrkMast.getWrkNo()); |
| | | throw new Exception("库存明细转移失败"); |
| | | } |
| | | // 修改源库位状态 O 空库位 |
| | | LocMast locMast2 = locMastService.selectById(wrkMast.getSourceLocNo()); |
| | | locMast2.setLocSts("O"); |
| | | locMast2.setBarcode(""); |
| | | locMast2.setModiTime(now); |
| | | if (!locMastService.updateById(locMast2)) { |
| | | log.error(" /pakin2/loc/v1 --- 修改源库位状态失败!" + wrkMast.getSourceLocNo()); |
| | | throw new Exception("修改源库位状态失败"); |
| | | } |
| | | |
| | | try{ |
| | | // 保存工作主档历史档 |
| | | if (wrkMastService.saveWrkMastLog(wrkMast.getWrkNo())==0) { |
| | | log.error(" stnToCrnStnPick2 --- 保存工作主档历史档失败!" + wrkMast.getWrkNo()); |
| | | } |
| | | // 更新工作档数据状态 |
| | | wrkMast.setIoTime(now); |
| | | wrkMast.setIoType(wrkMast.getIoType() - 50); // 入出库类型: 107->57 103->53 |
| | | wrkMast.setWrkSts(2L); // 工作状态: 2.设备上走 |
| | | wrkMast.setSourceStaNo(param.getSourceStaNo()); // 源站 |
| | | wrkMast.setStaNo(dto.getStaNo()); // 目标站 |
| | | wrkMast.setModiTime(now); |
| | | wrkMast.setLocNo(dto.getLocNo()); |
| | | wrkMast.setCrnNo(dto.getCrnNo()); |
| | | if (!wrkMastService.updateById(wrkMast)) { |
| | | log.error(" stnToCrnStnPick --- 更新工作档数据状态失败!" + wrkMast.getWrkNo()); |
| | | throw new CoolException("更新工作档数据状态失败"); |
| | | } |
| | | // 更新明细档io_time (历史档关联使用) |
| | | wrkDetlService.updateIoTimeWms(wrkMast.getWrkNo(),now); |
| | | }catch (Exception e){ |
| | | throw new CoolException("更新工作档数据状态出错"); |
| | | } |
| | | }catch (Exception e){ |
| | | log.error("/pakin2/loc/v1:======托盘码:"+param.getBarcode()+"盘点回库出错======>"+e); |
| | | return R.error("查看wmsError"); |
| | | } |
| | | } else { |
| | | return R.error(); |
| | | } |
| | | log.info("/pakin2/loc/v1:"+dto + "======托盘码:"+param.getBarcode()); |
| | | return R.ok().add(dto); |
| | | } |
| | | |
| | | @PostMapping("/pakin/empty/loc/v1") |
| | | @ResponseBody |
| | | public synchronized R getLocNoEmpty(@RequestBody SearchLocParam param) { |
| | | log.info("收到WCS入库接口请求====>>入参:{}", param); |
| | | if (Cools.isEmpty(param.getIoType())) { |
| | | return R.error("入出库类型不能为空"); |
| | | } |
| | | if (Cools.isEmpty(param.getSourceStaNo())) { |
| | | return R.error("源站编号不能为空"); |
| | | } |
| | | List<WaitPakin> waitPakins = null; |
| | | if (param.getIoType() == 1) { |
| | | if (Cools.isEmpty(param.getBarcode())) { |
| | | return R.error("条码不能为空"); |
| | | } |
| | | waitPakins = waitPakinService.selectList(new EntityWrapper<WaitPakin>().eq("zpallet", param.getBarcode())); |
| | | if (Cools.isEmpty(waitPakins)) { |
| | | WrkMast wrkMast = wrkMastService.selectByBarcode(param.getBarcode()); |
| | | if (wrkMast != null && wrkMast.getIoType() == 103) { |
| | | return R.parse(CodeRes.PICK_600); |
| | | } |
| | | return R.parse(CodeRes.NO_COMB_700); |
| | | } |
| | | int countLoc = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet",param.getBarcode())); |
| | | int countWrk = wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("zpallet",param.getBarcode())); |
| | | if (countLoc > 0 || countWrk > 0) { |
| | | return R.error(CodeRes.EXIST_500); |
| | | } |
| | | } |
| | | if (Cools.isEmpty(param.getLocType1())){ |
| | | return R.error("高低检测信号不能为空"); |
| | | } |
| | | |
| | | LocTypeDto locTypeDto = new LocTypeDto(); |
| | | locTypeDto.setLocType1((short)1); |
| | | |
| | | StartupDto dto = null; |
| | | switch (param.getIoType()) { |
| | | case 10://空托盘入库 |
| | | dto = emptyPlateInEmpty(param.getSourceStaNo(), locTypeDto, param.getBarcode()); |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(12, true); |
| | | |
| | | // 检索库位 |
| | | StartupDto dto = commonService.getLocNo(rowLastnoService.selectNextWhsType(), 10, 15, null, locTypeDto,0); |
| | | StartupDto dto = commonService.getLocNo(rowLastnoService.selectNextWhsType(), 10, 12, null,null,null, locTypeDto); |
| | | Date now = new Date(); |
| | | // 生成工作档 |
| | | WrkMast wrkMast = new WrkMast(); |
| | |
| | | return R.error("库存没有空板"); |
| | | } |
| | | EmptyPlateOutParam emptyPlateOutParam = new EmptyPlateOutParam(); |
| | | emptyPlateOutParam.setOutSite(11); |
| | | emptyPlateOutParam.setOutSite(12); |
| | | emptyPlateOutParam.setLocNos(new ArrayList<String>(){{add(locMast.getLocNo()+"");}}); |
| | | WrkMast wrkMast = workService.emptyPlateOut(emptyPlateOutParam); |
| | | return R.ok(!Cools.isEmpty(wrkMast)? R.ok("自动空托出库成功,工作号:" + wrkMast.getWrkNo()) : R.error("生成自动空托出库失败")); |
| | |
| | | public StartupDto startupFullPutStore(Integer devpNo, String barcode, LocTypeDto locTypeDto, List<WaitPakin> waitPakins) { |
| | | // 源站点状态检测 |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true); |
| | | |
| | | // 检索库位 |
| | | List<String> matNos = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList()); |
| | | StartupDto dto = commonService.getLocNo(1, 1, devpNo, matNos, locTypeDto,0); |
| | | List<KeyValueVo> list = waitPakins.stream().map(item-> new KeyValueVo(item.getMatnr(), item.getBatch())).distinct().collect(Collectors.toList()); |
| | | // List<String> matNos = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList()); |
| | | StartupDto dto = commonService.getLocNo(1, 1, devpNo, null,null,null, locTypeDto); |
| | | int workNo = dto.getWorkNo(); |
| | | Date now = new Date(); |
| | | // 生成工作档 |
| | |
| | | if (!waitPakinService.update(setParam, wrapper)) { |
| | | throw new CoolException("更新通知档失败"); |
| | | } |
| | | // 更新源站点信息 |
| | | sourceStaNo.setWrkNo(workNo); |
| | | sourceStaNo.setModiTime(now); |
| | | if (!basDevpService.updateById(sourceStaNo)){ |
| | | throw new CoolException("更新源站失败"); |
| | | } |
| | | // // 更新源站点信息 |
| | | //// sourceStaNo.setWrkNo(workNo); |
| | | // sourceStaNo.setModiTime(now); |
| | | // if (!basDevpService.updateById(sourceStaNo)){ |
| | | // throw new CoolException("更新源站失败"); |
| | | // } |
| | | // 更新目标库位状态 |
| | | LocMast locMast = locMastService.selectById(dto.getLocNo()); |
| | | if (locMast.getLocSts().equals("O")){ |
| | |
| | | // 源站点状态检测 |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true); |
| | | // 检索库位 |
| | | StartupDto dto = commonService.getLocNo(1, 10, devpNo, null, locTypeDto,0); |
| | | StartupDto dto = commonService.getLocNo(1, 10, devpNo, null,null,null, locTypeDto); |
| | | int workNo = dto.getWorkNo(); |
| | | // 生成工作档 |
| | | WrkMast wrkMast = new WrkMast(); |
| | | wrkMast.setWrkNo(workNo); |
| | | wrkMast.setIoTime(new Date()); |
| | | wrkMast.setWrkSts(2L); // 工作状态:生成入库ID |
| | | wrkMast.setIoType(10); // 入出库状态:10.空板入库 |
| | | wrkMast.setIoPri(13D); // 优先级 |
| | | wrkMast.setCrnNo(dto.getCrnNo()); |
| | | wrkMast.setSourceStaNo(dto.getSourceStaNo()); |
| | | wrkMast.setStaNo(dto.getStaNo()); |
| | | wrkMast.setLocNo(dto.getLocNo()); |
| | | wrkMast.setFullPlt("N"); // 满板 |
| | | wrkMast.setPicking("N"); // 拣料 |
| | | wrkMast.setExitMk("N"); // 退出 |
| | | wrkMast.setEmptyMk("Y"); // 空板 |
| | | wrkMast.setLinkMis("Y"); |
| | | wrkMast.setBarcode(barcode); |
| | | wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型 |
| | | // 操作人员数据 |
| | | wrkMast.setAppeTime(new Date()); |
| | | wrkMast.setModiTime(new Date()); |
| | | boolean res = wrkMastService.insert(wrkMast); |
| | | if (!res) { |
| | | throw new CoolException("保存工作档失败"); |
| | | } |
| | | // // 更新源站点信息 |
| | | // sourceStaNo.setWrkNo(workNo); |
| | | // sourceStaNo.setModiTime(new Date()); |
| | | // if (!basDevpService.updateById(sourceStaNo)){ |
| | | // throw new CoolException("更新源站失败"); |
| | | // } |
| | | // 更新目标库位状态 |
| | | LocMast locMast = locMastService.selectById(dto.getLocNo()); |
| | | if (locMast.getLocSts().equals("O")){ |
| | | locMast.setLocSts("S"); // S.入库预约 |
| | | locMast.setModiTime(new Date()); |
| | | if (!locMastService.updateById(locMast)){ |
| | | throw new CoolException("改变库位状态失败"); |
| | | } |
| | | } else { |
| | | throw new CoolException(dto.getLocNo()+"目标库位已被占用"); |
| | | } |
| | | return dto; |
| | | } |
| | | |
| | | @Transactional |
| | | public StartupDto emptyPlateInEmpty(Integer devpNo, LocTypeDto locTypeDto, String barcode) { |
| | | // 源站点状态检测 |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatusEmpty(devpNo, true); |
| | | // 检索库位 |
| | | StartupDto dto = commonService.getLocNo(1, 10, devpNo, null,null,null, locTypeDto); |
| | | int workNo = dto.getWorkNo(); |
| | | // 生成工作档 |
| | | WrkMast wrkMast = new WrkMast(); |
| | |
| | | return dto; |
| | | } |
| | | |
| | | /*...........................徐工汉云..............以下.............上饶江铜...........................*/ |
| | | /*............................Created by Monkey D. Luffy on 2023.07.19.............................*/ |
| | | |
| | | // 201、自动补空板 |
| | | // @Transactional |
| | | // public StartupDto emptyPlateIn201(Integer devpNo, LocTypeDto locTypeDto, String barcode) { |
| | | // // 源站点状态检测 |
| | | // BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true); |
| | | // // 检索库位 |
| | | // StartupDto dto = commonService.getScanBarcodeEmptyBoard(); |
| | | // if (dto.getStaNo()==0){ |
| | | // return null; |
| | | // } |
| | | // Date now = new Date(); |
| | | // dto.setSourceStaNo(devpNo); |
| | | // int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(201)); |
| | | // // 生成工作档 |
| | | // WrkMast wrkMast = new WrkMast(); |
| | | // wrkMast.setWrkNo(workNo); |
| | | // wrkMast.setIoTime(new Date()); |
| | | // wrkMast.setWrkSts(41L); // 工作状态:前往码垛位 |
| | | // wrkMast.setIoType(201); // 入出库状态:201、自动补空板 |
| | | // wrkMast.setIoPri(13D); // 优先级 |
| | | // wrkMast.setCrnNo(0); |
| | | // wrkMast.setSourceStaNo(dto.getSourceStaNo()); |
| | | // wrkMast.setStaNo(dto.getStaNo()); |
| | | // wrkMast.setLocNo(""); |
| | | // wrkMast.setFullPlt("N"); // 满板 |
| | | // wrkMast.setPicking("N"); // 拣料 |
| | | // wrkMast.setExitMk("N"); // 退出 |
| | | // wrkMast.setEmptyMk("Y"); // 空板 |
| | | // wrkMast.setLinkMis("Y"); |
| | | // wrkMast.setBarcode(barcode); |
| | | // wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型 |
| | | // // 操作人员数据 |
| | | // wrkMast.setAppeTime(now); |
| | | // wrkMast.setModiTime(now); |
| | | // |
| | | // boolean res = wrkMastService.insert(wrkMast); |
| | | // if (!res) { |
| | | // throw new CoolException("保存工作档失败"); |
| | | // } |
| | | // // 更新源站点信息 |
| | | // sourceStaNo.setWrkNo(workNo); |
| | | // sourceStaNo.setModiTime(now); |
| | | // if (!basDevpService.updateById(sourceStaNo)){ |
| | | // throw new CoolException("更新源站失败"); |
| | | // } |
| | | // return dto; |
| | | // } |
| | | /*...........................上饶江铜..............以上.............徐工汉云...........................*/ |
| | | |
| | | |
| | | } |