| | |
| | | |
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
| | | import com.core.common.Cools; |
| | | import com.core.common.DateUtils; |
| | | import com.core.exception.CoolException; |
| | | import com.zy.asrs.entity.*; |
| | | import com.zy.asrs.service.LocDetlService; |
| | | import com.zy.asrs.service.LocMastService; |
| | | import com.zy.asrs.service.TestMastService; |
| | | import com.zy.asrs.service.WorkService; |
| | | import com.zy.asrs.entity.param.CombParam; |
| | | import com.zy.asrs.service.*; |
| | | import com.zy.asrs.task.AbstractHandler; |
| | | import com.zy.asrs.task.core.ReturnT; |
| | | import com.zy.asrs.utils.PostMesDataUtils; |
| | | import com.zy.common.model.enums.WorkNoType; |
| | | import com.zy.common.service.CommonService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.transaction.interceptor.TransactionAspectSupport; |
| | |
| | | private TestMastService testMastService; |
| | | @Autowired |
| | | private WorkService workService; |
| | | @Autowired |
| | | private WrkMastService wrkMastService; |
| | | @Autowired |
| | | private CommonService commonService; |
| | | @Autowired |
| | | private WrkDetlService wrkDetlService; |
| | | |
| | | @Value("${channel.equipmentRow}") |
| | | private Integer equipmentRow; //测试库位所在排号 |
| | | @Value("${channel.quietRow}") |
| | | private Integer quietRow; //静置库位所在排号 |
| | | |
| | | @Value("${mes.url}") |
| | | private String mesUrl; |
| | | |
| | | @Value("${mes.inPath}") |
| | | private String inpath; |
| | | |
| | | @Transactional |
| | | public ReturnT<String> start() { |
| | | //测试失败(NG)移库 |
| | | try { |
| | | List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>() |
| | | .eq("loc_sts", "F") |
| | | .eq("pack_status", 3) |
| | | .eq("row1", 2) |
| | | .eq("pack_status", 4)//测试失败 |
| | | .eq("row1", equipmentRow) |
| | | .eq("loc_type1", (short) 1) |
| | | .eq("fire_status",0) |
| | | ); |
| | | if (!Cools.isEmpty(locMasts)){ |
| | | for (LocMast locMast:locMasts){ |
| | | LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", locMast.getLocNo())); |
| | | TestMast testMast = testMastService.selectOne(new EntityWrapper<TestMast>() |
| | | .eq("loc_no",locMast.getLocNo()) |
| | | .eq("barcode",locMast.getBarcode()) |
| | | .eq("status",4) |
| | | .eq("barcode",locDetl.getMatnr()) |
| | | .eq("status",4)//完成测试 |
| | | ); |
| | | if (!Cools.isEmpty(testMast)){ |
| | | if (testMast.getStatus()==4){ |
| | | //移库开始,查询目标库位 |
| | | LocMast targetLocNo = locMastService.queryFreeLocMast(1,(short)2); |
| | | LocMast targetLocNo = locMastService.queryFreeLocMast(2,(short)4); |
| | | if (Cools.isEmpty(targetLocNo)){ |
| | | targetLocNo=locMastService.queryFreeLocMast(2,(short)2); |
| | | targetLocNo=locMastService.queryFreeLocMast(1,(short)4); |
| | | } |
| | | if (targetLocNo != null){ |
| | | workService.locMove(locMast.getLocNo(),targetLocNo.getLocNo(),(long)Integer.parseInt(testMast.getUserId())); |
| | | workService.locMove(locMast.getLocNo(),targetLocNo.getLocNo(),(long)Integer.parseInt("9935")); |
| | | //4.测试完成上报 |
| | | CombParam combParam = new CombParam(); |
| | | combParam.setPackNo(locDetl.getMatnr()); |
| | | combParam.setLocNo(locMast.getLocNo()); |
| | | combParam.setPackSts(2); |
| | | combParam.setStepSts(4); |
| | | combParam.setRequestTime(DateUtils.convert(new Date())); |
| | | new PostMesDataUtils().postMesData("MES系统",mesUrl,inpath,combParam); |
| | | return SUCCESS; |
| | | }else { |
| | | log.error("没有空库位"); |
| | | log.error("测试完成自动移库--->没有空库位!"); |
| | | } |
| | | }else if (testMast.getStatus()!=4) { |
| | | log.error("测试状态异常,库位号为:" + testMast.getLocNo()); |
| | | } |
| | | }else { |
| | | log.error("测试库位:"+locMast.getLocNo()+"所属测试档为空"); |
| | | log.error("测试库位:"+locMast.getLocNo()+"所属测试档为空或者不状态为4"); |
| | | } |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); |
| | | return FAIL.setMsg(e.getMessage()); |
| | | } |
| | | |
| | | //测试成功 出库、移库 |
| | | try { |
| | | List<LocMast> locMasts2 = locMastService.selectList(new EntityWrapper<LocMast>() |
| | | .eq("loc_sts", "F") |
| | | .eq("pack_status", 3)//测试完成 |
| | | .eq("row1", equipmentRow) |
| | | .eq("loc_type1", (short) 1) |
| | | .eq("fire_status",0) |
| | | ); |
| | | if (!Cools.isEmpty(locMasts2)){ |
| | | for (LocMast locMast:locMasts2){ |
| | | LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", locMast.getLocNo())); |
| | | TestMast testMast = testMastService.selectOne(new EntityWrapper<TestMast>() |
| | | .eq("loc_no",locMast.getLocNo()) |
| | | .eq("barcode",locDetl.getMatnr()) |
| | | .eq("status",4) |
| | | ); |
| | | boolean sign=false; |
| | | if (!Cools.isEmpty(testMast)){ |
| | | if (testMast.getStatus()==4){ |
| | | //移库开始,查询目标库位 |
| | | LocMast targetLocNo = locMastService.queryFreeLocMast(4,(short)2); |
| | | if (Cools.isEmpty(targetLocNo)){ |
| | | targetLocNo=locMastService.queryFreeLocMast(3,(short)2); |
| | | } |
| | | if (targetLocNo != null){ |
| | | //生成出库任务 |
| | | if (outLoc(locMast)){ |
| | | sign=true; |
| | | } |
| | | }else { |
| | | //3\4排满 向2排移库,查询目标库位 |
| | | targetLocNo = locMastService.queryFreeLocMast(2,(short)2); |
| | | if (Cools.isEmpty(targetLocNo)){ |
| | | targetLocNo=locMastService.queryFreeLocMast(1,(short)2); |
| | | } |
| | | if (targetLocNo != null){ |
| | | workService.locMove(locMast.getLocNo(),targetLocNo.getLocNo(),(long)9935); |
| | | sign=true; |
| | | }else { |
| | | log.error("测试完成自动移库--->没有空库位!"); |
| | | } |
| | | } |
| | | }else if (testMast.getStatus()!=4) { |
| | | log.error("测试状态异常,库位号为:" + testMast.getLocNo()); |
| | | } |
| | | |
| | | }else { |
| | | log.error("测试库位:"+locMast.getLocNo()+"所属测试档为空或者不状态为4"); |
| | | } |
| | | if (sign){ |
| | | //4.测试完成上报 |
| | | CombParam combParam = new CombParam(); |
| | | combParam.setPackNo(locDetl.getMatnr()); |
| | | combParam.setLocNo(locMast.getLocNo()); |
| | | combParam.setPackSts(1); |
| | | combParam.setStepSts(4); |
| | | combParam.setRequestTime(DateUtils.convert(new Date())); |
| | | new PostMesDataUtils().postMesData("MES系统",mesUrl,inpath,combParam); |
| | | return SUCCESS; |
| | | } |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); |
| | | return FAIL.setMsg(e.getMessage()); |
| | | } |
| | | |
| | | //测试有空库位 移库 |
| | | try { |
| | | List<LocMast> locMasts3 = locMastService.selectList(new EntityWrapper<LocMast>() |
| | | .eq("loc_sts", "F") |
| | | .eq("pack_status", 0) |
| | | .eq("loc_type1", (short) 3) |
| | | .eq("fire_status",0) |
| | | ); |
| | | if (!Cools.isEmpty(locMasts3)){ |
| | | for (LocMast locMast:locMasts3){ |
| | | //移库开始,查询目标库位 |
| | | LocMast targetLocNo = locMastService.queryFreeLocMast(equipmentRow,(short)1); |
| | | if (targetLocNo != null){ |
| | | workService.locMove(locMast.getLocNo(),targetLocNo.getLocNo(),(long)9999); |
| | | }else { |
| | | // log.error("向测试库位移库失败--->等待空库位!"); |
| | | } |
| | | } |
| | | } |
| | |
| | | return SUCCESS; |
| | | } |
| | | |
| | | public boolean outLoc(LocMast locMast){ |
| | | try { |
| | | Date now = new Date(); |
| | | Integer ioType = 101; //入出库类型 |
| | | LocDetl locDetl=locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no",locMast.getLocNo())); |
| | | if (Cools.isEmpty(locDetl)){ |
| | | log.error("库位:"+locMast.getLocNo()+"没有明细"); |
| | | } else if (Cools.isEmpty(locDetl.getDeadWarn())){ |
| | | log.error("库位:"+locMast.getLocNo()+"没有静置时间"); |
| | | } else if (Cools.isEmpty(locMast.getModiTime())){ |
| | | log.error("库位:"+locMast.getLocNo()+"modiTime为空"); |
| | | } else if (Cools.isEmpty(locMast.getBarcode())){ |
| | | log.error("库位:"+locMast.getLocNo()+"托盘码为空"); |
| | | } else { |
| | | // 生成工作号 |
| | | int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType)); |
| | | // 生成工作档 |
| | | WrkMast wrkMast = new WrkMast(); |
| | | wrkMast.setWrkNo(workNo); |
| | | wrkMast.setIoTime(now); |
| | | wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID |
| | | wrkMast.setIoType(ioType); // 入出库状态 |
| | | wrkMast.setIoPri(13D); // 优先级:13 |
| | | wrkMast.setCrnNo(1); |
| | | wrkMast.setSourceStaNo(203); // 源站 |
| | | wrkMast.setStaNo(206); // 目标站 2号堆垛机入库站 |
| | | wrkMast.setSourceLocNo(locMast.getLocNo()); // 源库位 |
| | | wrkMast.setFullPlt("Y"); // 满板:Y |
| | | wrkMast.setPicking("N"); // 拣料 |
| | | wrkMast.setExitMk("N"); // 退出 |
| | | wrkMast.setEmptyMk("N"); // 空板 |
| | | wrkMast.setLinkMis("N"); |
| | | wrkMast.setBarcode(locMast.getBarcode()); |
| | | wrkMast.setAppeTime(now); |
| | | wrkMast.setModiTime(now); |
| | | if (!wrkMastService.insert(wrkMast)) { |
| | | log.error("保存工作档失败,出库库位号:"+locMast.getLocNo()); |
| | | return false; |
| | | } |
| | | // 生成工作档明细 |
| | | WrkDetl wrkDetl = new WrkDetl(); |
| | | wrkDetl.sync(locDetl); |
| | | wrkDetl.setWrkNo(workNo); |
| | | wrkDetl.setIoTime(now); |
| | | wrkDetl.setAnfme(1.0); // 数量 |
| | | wrkDetl.setAppeTime(now); |
| | | wrkDetl.setModiTime(now); |
| | | if (!wrkDetlService.insert(wrkDetl)) { |
| | | log.error("保存工作档明细失败"); |
| | | return false; |
| | | } |
| | | // 修改库位状态: F.在库 ====>>> R.出库预约 |
| | | if (locMast.getLocSts().equals("F")) { |
| | | locMast.setLocSts("R"); |
| | | locMast.setModiTime(now); |
| | | // locMast.setPackStatus(5); //5:开始静置 |
| | | |
| | | CombParam combParam = new CombParam(); |
| | | combParam.setPackNo(wrkDetl.getMatnr()); |
| | | combParam.setLocNo(locMast.getLocNo()); |
| | | combParam.setPackSts(locMast.getPackStatus()); |
| | | combParam.setRequestTime(DateUtils.convert(new Date())); |
| | | new PostMesDataUtils().postMesData("MES系统",mesUrl,inpath,combParam); |
| | | |
| | | if (!locMastService.updateById(locMast)) { |
| | | log.error("预约库位状态失败,库位号:"+locMast.getLocNo()); |
| | | return false; |
| | | }else { |
| | | return true; |
| | | } |
| | | } else { |
| | | log.error(locMast.getLocNo() + "库位不是在库状态"); |
| | | } |
| | | } |
| | | return false; |
| | | } catch (Exception e) { |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | } |