package com.zy.asrs.service.impl; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.core.common.*; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.*; import com.zy.asrs.mapper.ManLocDetlMapper; import com.zy.asrs.mapper.MatMapper; import com.zy.asrs.mapper.OrderDetlMapper; import com.zy.asrs.service.*; import com.zy.asrs.utils.MatUtils; import com.zy.common.constant.MesConstant; import com.zy.common.entity.Parameter; import com.zy.common.model.DetlDto; import com.zy.common.model.LocTypeDto; import com.zy.common.model.MesCombParam; import com.zy.common.model.StartupDto; import com.zy.common.service.CommonService; import com.zy.common.utils.HttpHandler; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.util.*; import java.util.stream.Collectors; /** * 移动端服务核心类 * Created by vincent on 2020/6/28 */ @Slf4j @Service public class MobileServiceImpl implements MobileService { @Autowired private MatService matService; @Autowired private MatMapper matMapper; @Autowired private WaitPakinService waitPakinService; @Autowired private OrderService orderService; @Autowired private OrderDetlService orderDetlService; @Autowired private BasDevpService basDevpService; @Autowired private WrkMastService wrkMastService; @Autowired private WrkDetlService wrkDetlService; @Autowired private PackService packService; @Autowired private OpenService openService; @Autowired private SnowflakeIdWorker snowflakeIdWorker; @Autowired private ApiLogService apiLogService; @Autowired private BasCrnpService basCrnpService; @Autowired private LocMastService locMastService; @Autowired private LocDetlService locDetlService; @Autowired private StaDescService staDescService; @Autowired private CommonService commonService; @Autowired private NodeService nodeService; @Autowired private ManLocDetlService manLocDetlService; @Autowired private ManLocDetlMapper manLocDetlMapper; @Autowired private DocTypeService docTypeService; @Autowired private LocDetlRullUpDetailService locDetlRullUpDetailService; @Autowired private TagService tagService; @Autowired private BasBoxTypeService basBoxTypeService; @Autowired private WrkMastLogService wrkMastLogService; @Resource private OpenServiceImpl openServiceImpl; @Resource private OrderDetlMapper orderDetlMapper; @Override @Transactional public void trussComb(TrussCombParam param, Long userId) { Date now = new Date(); if (param.getSouSta()==145){ param.setBarcode(String.valueOf(now.getTime())); }else { if (Cools.isEmpty(param.getBarcode())){ throw new CoolException("参数：托盘码为空"); } } param.setPalletizingNo(147); //判断param参数 if (Cools.isEmpty(param.getPalletizingNo())){ throw new CoolException("参数：原站点编号为空"); }else if (param.getSouSta()==145 && param.getMatList().size() != 1){ throw new CoolException("参数：物料明细 matLists为空 或者 大于1个明细"); }else if (Cools.isEmpty(param.getMatList()) || param.getMatList().size() > 2){ throw new CoolException("参数：物料明细 matLists为空 或者 大于2个明细"); } String matnr = null; List waitPakins = new ArrayList<>(); for (TrussCombParam.MatList matList:param.getMatList()){ long rollUp = new Date().getTime(); Mat mat = matService.selectByMatnr(matList.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(matList.getMatnr() + "商品档案不存在"); } matnr = mat.getMatnr(); WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setModel(matList.getModel()); //批次 waitPakin.setSpecs(matList.getSpecs()); //规格 waitPakin.setBatch(matList.getBatch()); //木箱编码 waitPakin.setBrand(param.getBoxType()); //木箱类型 waitPakin.setZpallet(param.getBarcode()); //托盘码 waitPakin.setOrigin(matList.getPosition()); //木箱在托盘上的位置 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme((double)matList.getAnfme()); // 木箱中铜箔数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); waitPakin.setRollUp(rollUp); if (!Cools.isEmpty(matList.getMatDetlList())){ for (TrussCombParam.MatDetlList matDetlList:matList.getMatDetlList()){ LocDetlRullUpDetail locDetlRullUpDetail = new LocDetlRullUpDetail(); locDetlRullUpDetail.setUuid(rollUp); locDetlRullUpDetail.setRollNo(matDetlList.getBoxNoDetl()); locDetlRullUpDetail.setRollWeight(matDetlList.getWeightDetl().toString()); locDetlRullUpDetailService.insert(locDetlRullUpDetail); } } if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } waitPakins.add(waitPakin); } LocTypeDto locTypeDto = new LocTypeDto(); locTypeDto.setLocType1((short)1); StartupDto dto = commonService.getLocNo(1, 1, param.getSouSta(), matnr,null,null, locTypeDto); int workNo = dto.getWorkNo(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态：生成入库ID wrkMast.setIoType(1); // 入出库状态：1.入库 wrkMast.setIoPri(13D); // 优先级 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(param.getBarcode()); // 托盘码 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(0); // 容器类型 // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiTime(now); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 生成工作档明细 waitPakins.forEach(waitPakin -> { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(waitPakin); wrkDetl.setWrkNo(wrkMast.getWrkNo()); wrkDetl.setIoTime(wrkMast.getIoTime()); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setRollUp(waitPakin.getRollUp()); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } }); // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("O")){ locMast.setLocSts("S"); // S.入库预约 locMast.setModiTime(now); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } } //wms入库组托 退库单退库组托 @Override @Transactional public void trussCombOrder(TrussCombParam param, Long userId) { Date now = new Date(); param.setBarcode(String.valueOf(now.getTime())); param.setPalletizingNo(147); //判断param参数 if (Cools.isEmpty(param.getPalletizingNo())){ throw new CoolException("参数：码垛位编号 palletizingNo为空"); }else if (Cools.isEmpty(param.getOrderNo())){ throw new CoolException("参数：退货单单号 orderNo为空"); }else if (Cools.isEmpty(param.getMatList())){ throw new CoolException("参数：物料明细 matLists为空"); } Order order = orderService.selectByNo(param.getOrderNo()); if (Cools.isEmpty(order) || order.getSettle() > 2) { throw new CoolException("单据编号已过期，单号："+param.getOrderNo()); } DocType docType = docTypeService.selectById(order.getDocType()); if (Cools.isEmpty(docType) || !docType.getDocName().equals("退货入库单")){ throw new CoolException("单号："+param.getOrderNo()+"不是退货入库单"); } List orderDetls = orderDetlService.selectByOrderId(order.getId()); if (Cools.isEmpty(orderDetls) || orderDetls.size()==0){ throw new CoolException("未查询到此订单明细，单号："+param.getOrderNo()); } List orderBoxNoList = new ArrayList<>(); for (OrderDetl orderDetl: orderDetls){ if (orderDetl.getWorkQty().equals(0.0)){ orderBoxNoList.add(orderDetl.getBatch()); } } if (orderBoxNoList.size()==0 || orderBoxNoList.size() matListBoxNoList = new ArrayList<>(); for (TrussCombParam.MatList matList: param.getMatList()){ if (!orderBoxNoList.contains(matList.getBatch())){ throw new CoolException("单号："+param.getOrderNo()+" 箱号："+matList.getBatch()+"不属于此订单或者已经入库"); }else { matListBoxNoList.add(matList.getBatch()); } } List orderDetlList = new ArrayList<>(); for (OrderDetl orderDetl: orderDetls){ if (matListBoxNoList.contains(orderDetl.getBatch())){ orderDetlList.add(orderDetl); } } List waitPakins = new ArrayList<>(); String matnrSign = ""; String brandSign = ""; for (OrderDetl orderDetl:orderDetlList){ if (Cools.isEmpty(orderDetl.getMatnr()) || Cools.isEmpty(orderDetl.getBrand())){ throw new CoolException(orderDetl.getOrderNo() + "所选明细存在未知规格或者未知箱型，请维护数据！"); } if (matnrSign.equals("")){ matnrSign = orderDetl.getMatnr(); brandSign = orderDetl.getBrand(); }else { if (!matnrSign.equals(orderDetl.getMatnr())){ throw new CoolException(orderDetl.getMatnr() + "请选择同一个规格的货物！！！"); } if (!brandSign.equals(orderDetl.getBrand())){ throw new CoolException(orderDetl.getMatnr() + "请选择同一种箱型的货物！！！"); } } } Mat mat = matService.selectByMatnr(matnrSign); if (Cools.isEmpty(mat)) { throw new CoolException(matnrSign + "商品档案不存在"); } for (OrderDetl orderDetl:orderDetlList){ WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setOrderNo(order.getOrderNo()); // 单据编号 waitPakin.setModel(orderDetl.getModel()); //批次 waitPakin.setSpecs(orderDetl.getSpecs()); //规格 waitPakin.setBatch(orderDetl.getBatch()); //木箱编码 waitPakin.setBrand(orderDetl.getBrand()); //木箱类型 waitPakin.setZpallet(param.getBarcode()); //托盘码 waitPakin.setWeight(orderDetl.getWeight()); //净重 waitPakin.setVolume(orderDetl.getVolume()); //毛重 waitPakin.setPrice(orderDetl.getPrice()); //长度 waitPakin.setSpecs(String.valueOf(orderDetl.getSpecs())); //接头 waitPakin.setOrigin("1"); //木箱在托盘上的位置 waitPakin.setIoStatus("Y"); // 入出状态 waitPakin.setAnfme(orderDetl.getAnfme()); // 木箱中铜箔数量 waitPakin.setWeight(orderDetl.getWeight()); // 木箱中铜箔净重 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); waitPakin.setZpallet(param.getBarcode()); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } waitPakins.add(waitPakin); } LocTypeDto locTypeDto = new LocTypeDto(); locTypeDto.setLocType1((short)1); StartupDto dto = commonService.getLocNo(1, 1, 145, matnrSign,null,null, locTypeDto); int workNo = dto.getWorkNo(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态：生成入库ID wrkMast.setIoType(1); // 入出库状态：1.入库 wrkMast.setIoPri(13D); // 优先级 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(param.getBarcode()); // 托盘码 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(0); // 容器类型 wrkMast.setBarcode(param.getBarcode()); // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiTime(now); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 生成工作档明细 waitPakins.forEach(waitPakin -> { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(waitPakin); wrkDetl.setOrderNo(order.getOrderNo()); wrkDetl.setWrkNo(wrkMast.getWrkNo()); wrkDetl.setIoTime(wrkMast.getIoTime()); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setZpallet(param.getBarcode()); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } }); // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("O")){ locMast.setLocSts("S"); // S.入库预约 locMast.setModiTime(now); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } // 修改订单作业数量 if (!orderDetlService.increaseWorkQty(order.getId(), orderDetls.get(0).getMatnr(), orderDetls.get(0).getBatch(), orderDetls.get(0).getAnfme())) { throw new CoolException("修改单据作业数量失败"); } orderService.updateSettle(order.getId(), 2L, userId); } @Override @Transactional public void trussComb2Car(Integer staNo) { if (staNo!=212){ throw new CoolException("只允许212呼叫托盘"); } BasDevp basDevp = basDevpService.selectById(212); if (!basDevp.getAutoing().equals("Y")){ throw new CoolException("212站点不是自动"); } else if (basDevp.getLoading().equals("Y")){ throw new CoolException("212站点有物"); } else if (basDevp.getWrkNo()!=0){ throw new CoolException("212站点有工作号"); } WrkMast wrkMast1 = wrkMastService.selectOne(new EntityWrapper().eq("io_type", 212)); if (!Cools.isEmpty(wrkMast1)){ throw new CoolException("任务档案已存在！请等待..."); } int workNo = commonService.getWorkNo(6); Date now = new Date(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(61L); // 工作状态：61、等待空板 wrkMast.setIoType(212); // 入出库状态：212.2楼212呼叫空板 wrkMast.setIoPri(10D); // 优先级 wrkMast.setStaNo(212); wrkMast.setFullPlt("N"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("Y"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(0); // 容器类型 // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiTime(now); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } } @Override @Transactional public void PalletizingCompleteTwoFloorParam(PalletizingCompleteTwoFloorParam param) { Long userId = 7777L;//中控 param.setPalletizingNo(212); WrkMast wrkMast1 = wrkMastService.selectOne(new EntityWrapper() .eq("io_type", 1).eq("wrk_sts", 1).eq("source_sta_no",212)); if (!Cools.isEmpty(wrkMast1)){ throw new CoolException("存在一笔工作档案，请先入库！"); } //判断param参数 if (Cools.isEmpty(param.getBarcode())){ throw new CoolException("参数：托盘码 barcode为空"); }else if (Cools.isEmpty(param.getPalletizingNo())){ throw new CoolException("参数：码垛位编号 palletizingNo为空"); }else if (Cools.isEmpty(param.getBoxType())){ throw new CoolException("参数：木箱类型 boxType为空"); }else if (Cools.isEmpty(param.getMatList()) || param.getMatList().size()==0){ throw new CoolException("参数：物料明细 matLists为空"); } String matnrOne = "";//木箱相同位置 规格 matnr校验 1、左 String matnrTwo = "";//木箱相同位置 规格 matnr校验 2、右 ArrayList boxNos = new ArrayList<>(); //木箱唯一编码查重 （batch） //判断matLists参数 for (PalletizingCompleteTwoFloorParam.MatList matList:param.getMatList()){ if (Cools.isEmpty(matList.getMatnr())){ throw new CoolException("参数：规格 matnr为空"); }else if (Cools.isEmpty(matList.getPosition())){ throw new CoolException("规格："+matList.getMatnr()+"、参数：码垛位置 position为空"); }else if (Cools.isEmpty(matList.getBatch())){ throw new CoolException("规格："+matList.getMatnr()+"、参数：木箱编号 batch为空"); }else if (Cools.isEmpty(matList.getModel())){ throw new CoolException("规格："+matList.getMatnr()+"、参数：卷号 model为空"); }else if (Cools.isEmpty(matList.getBatch())){ throw new CoolException("规格："+matList.getMatnr()+"、参数：木箱编号 boxNo为空"); }else if (Cools.isEmpty(matList.getWeight()) || matList.getWeight().equals(0D)){ throw new CoolException("规格："+matList.getMatnr()+"、参数：净重 weight为空"); }else if (Cools.isEmpty(matList.getRoughWeight()) || matList.getRoughWeight().equals(0D)){ throw new CoolException("规格："+matList.getMatnr()+"、参数：毛重 roughWeight为空"); }else if (Cools.isEmpty(matList.getRollExtent()) || matList.getRollExtent().equals(0D)){ throw new CoolException("规格："+matList.getMatnr()+"、参数：卷长度 rollExtent为空"); } if (matList.getPosition().equals("1")){//1、左 2、右 if (!matnrOne.equals("")){ if (!matnrOne.equals(matList.getMatnr())){ throw new CoolException("木箱位置："+matList.getPosition()+"存在不同规格卷信息"); } }else { matnrOne=matList.getMatnr(); } }else if (matList.getPosition().equals("2")){ if (!matnrTwo.equals("")){ if (!matnrTwo.equals(matList.getMatnr())){ throw new CoolException("木箱位置："+matList.getPosition()+"存在不同规格卷信息"); } }else { matnrTwo=matList.getMatnr(); } }else { throw new CoolException("参数：木箱编号 boxNo:"+matList.getBatch()+",木箱位置错误："+matList.getPosition()); } if (!boxNos.contains(matList.getBatch())){ boxNos.add(matList.getBatch()); }else { throw new CoolException("参数：木箱编号 boxNo:"+matList.getBatch()+",木箱编码存在重复"); } if (locDetlService.selectCount(new EntityWrapper().eq("batch", matList.getBatch()))!=0 || wrkDetlService.selectCount(new EntityWrapper().eq("batch", matList.getBatch()))!=0 || waitPakinService.selectCount(new EntityWrapper().eq("batch", matList.getBatch()))!=0){ throw new CoolException("木箱编号："+matList.getBatch()+"已存在，请勿重复入库"); } } if (locDetlService.selectCount(new EntityWrapper().eq("zpallet", param.getBarcode()))!=0 || wrkDetlService.selectCount(new EntityWrapper().eq("zpallet", param.getBarcode()))!=0 || waitPakinService.selectCount(new EntityWrapper().eq("zpallet", param.getBarcode()))!=0){ throw new CoolException("托盘条码："+param.getBarcode()+"已存在，请勿重复组托"); } String matnr = null; List waitPakins = new ArrayList<>(); Date now = new Date(); for (PalletizingCompleteTwoFloorParam.MatList matList:param.getMatList()){ Mat mat = matService.selectByMatnr(matList.getMatnr()); if (Cools.isEmpty(mat)) { mat = new Mat(); mat.setMatnr(matList.getMatnr()); mat.setMaktx(matList.getMatnr()); mat.setTagId(tagService.getTop().getId()); mat.setBrand(param.getBoxType()); mat.setCreateBy(userId); mat.setCreateTime(now); mat.setUpdateBy(userId); mat.setUpdateTime(now); mat.setStatus(1); if (!matService.insert(mat)) { throw new CoolException("规格添加失败，请联系管理员"); } } matnr = matList.getMatnr(); WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setBatch(matList.getBatch()); //木箱编码 //批次 唯一值 箱号 waitPakin.setModel(matList.getModel()); //卷号 唯一值 waitPakin.setBrand(param.getBoxType()); //木箱类型 waitPakin.setZpallet(param.getBarcode()); //托盘码 waitPakin.setOrigin(matList.getPosition()); //木箱在托盘上的位置 waitPakin.setWeight(matList.getWeight()); //净重 waitPakin.setVolume(matList.getRoughWeight()); //毛重 waitPakin.setPrice(matList.getRollExtent()); //长度 waitPakin.setSpecs(String.valueOf(matList.getJoint())); //接头 waitPakin.setIoStatus("Y"); // 入出状态 waitPakin.setAnfme(matList.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } waitPakins.add(waitPakin); } LocTypeDto locTypeDto = new LocTypeDto(); locTypeDto.setLocType1((short)1); StartupDto dto = commonService.getLocNo(1, 1, 212, matnr,null,null, locTypeDto); int workNo = dto.getWorkNo(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态：生成入库ID wrkMast.setIoType(1); // 入出库状态：1.入库 wrkMast.setIoPri(13D); // 优先级 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(param.getBarcode()); // 托盘码 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(0); // 容器类型 // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiTime(now); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 生成工作档明细 waitPakins.forEach(waitPakin -> { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(waitPakin); wrkDetl.setWrkNo(wrkMast.getWrkNo()); wrkDetl.setIoTime(wrkMast.getIoTime()); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setZpallet(param.getBarcode()); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } }); // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("O")){ locMast.setLocSts("S"); // S.入库预约 locMast.setModiTime(now); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } } @Override @Transactional public void comb(CombParam param, Long userId) { if (Cools.isEmpty(param.getBarcode(), param.getCombMats())) { throw new CoolException(BaseRes.PARAM); } if(param.getCombMats().size()>1){ throw new CoolException("请提取一个商品，或者刷新重新组托！"); } // 判断是否有相同条码的数据 if (waitPakinService.selectCount(new EntityWrapper(). eq("zpallet", param.getBarcode()).eq("io_status", "N")) > 0) { throw new CoolException(param.getBarcode() + "数据正在进行入库"); } if(param.getBarcode().length()!=8){ throw new CoolException("条码长度不是8位===>>" + param.getBarcode()); } if (param.getCombMats().size()>1){ throw new CoolException("不允许混料===>>" + param.getBarcode()); } int countLoc = locDetlService.selectCount(new EntityWrapper().eq("zpallet",param.getBarcode())); int countWrk = wrkDetlService.selectCount(new EntityWrapper().eq("zpallet",param.getBarcode())); int countwait = waitPakinService.selectCount(new EntityWrapper().eq("zpallet",param.getBarcode())); if (countLoc > 0 || countWrk > 0 || countwait > 0) { throw new CoolException("组托档/工作档/库存条码数据已存在===>>" + param.getBarcode()); } Date now = new Date(); // 无单组托 if (Cools.isEmpty(param.getOrderNo())) { // 生成入库通知档 List detlDtos = new ArrayList<>(); param.getCombMats().forEach(elem -> { DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme()); if (DetlDto.has(detlDtos, detlDto)) { DetlDto one = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch()); assert one != null; one.setAnfme(one.getAnfme() + detlDto.getAnfme()); } else { detlDtos.add(detlDto); } }); for (DetlDto detlDto : detlDtos) { Mat mat = matService.selectByMatnr(detlDto.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(detlDto.getMatnr() + "商品档案不存在"); } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setBatch(detlDto.getBatch()); waitPakin.setZpallet(param.getBarcode()); // 托盘码 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme(detlDto.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } } // 关联组托 } else { Order order = orderService.selectByNo(param.getOrderNo()); if (Cools.isEmpty(order) || order.getSettle() > 2) { throw new CoolException("单据编号已过期"); } // 生成入库通知档 List detlDtos = new ArrayList<>(); param.getCombMats().forEach(elem -> { // 订单明细数量校验 OrderDetl orderDetl = orderDetlService.selectItem(order.getId(), elem.getMatnr(), elem.getBatch()); if (elem.getAnfme() > orderDetl.getEnableQty()) { throw new CoolException(orderDetl.getMatnr() + "入库数量不合法"); } // 修改订单作业数量 if (!orderDetlService.increaseWorkQty(order.getId(), elem.getMatnr(), elem.getBatch(), elem.getAnfme())) { throw new CoolException("修改单据作业数量失败"); } DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme()); if (DetlDto.has(detlDtos, detlDto)) { DetlDto one = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch()); assert one != null; one.setAnfme(one.getAnfme() + detlDto.getAnfme()); } else { detlDtos.add(detlDto); } }); for (DetlDto detlDto : detlDtos) { Mat mat = matService.selectByMatnr(detlDto.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(detlDto.getMatnr() + "商品档案不存在"); } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setOrderNo(order.getOrderNo()); // 单据编号 waitPakin.setBatch(detlDto.getBatch()); // 序列码 waitPakin.setZpallet(param.getBarcode()); // 托盘码 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme(detlDto.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } } orderService.updateSettle(order.getId(), 2L, userId); } } // 商品上架 @Override public void onSale(CombParam param) { Date now = new Date(); // 获取库位号 String locno = param.getLocno(); Node node = nodeService.selectByUuid(locno); if (Cools.isEmpty(node)) { throw new CoolException(param.getLocno() + ":库位不存在"); } // 获取商品列表 for(CombParam.CombMat combMat : param.getCombMats()){ Mat mat = matService.selectByMatnr(combMat.getMatnr()); if (Cools.isEmpty(mat)){ throw new CoolException(combMat.getMatnr() + ":商品档案不存在！"); } if (Cools.isEmpty(combMat.getAnfme()) || combMat.getAnfme()==0){ throw new CoolException(combMat.getMatnr() + ":商品数量有误！"); } if (Cools.isEmpty(combMat.getBatch())){ // throw new CoolException(combMat.getMatnr() + ":商品批号有误！"); } ManLocDetl manLocDetl = new ManLocDetl(); manLocDetl.setLocNo(locno); manLocDetl.setNodeId(node.getId()); manLocDetl.setMaktx(mat.getMaktx()); manLocDetl.setMatnr(mat.getMatnr()); manLocDetl.setBatch(Cools.isEmpty(combMat.getBatch()) ? "" : combMat.getBatch()); manLocDetl.setAnfme(combMat.getAnfme()); manLocDetl.setModiTime(now); if (!manLocDetlService.insert(manLocDetl)) { throw new CoolException("商品上架失败！"); } } } // 商品下架 @Override public void offSale(OffSaleParam offSaleParam) { ManLocDetl manLocDetl = manLocDetlMapper.selectLocNo0(offSaleParam.getLocNo(), offSaleParam.getMatnr()); if (Cools.isEmpty(manLocDetl)){ throw new CoolException("无此商品！"); } double anfme = manLocDetl.getAnfme() - offSaleParam.getAnfme(); if (anfme < 0) { throw new CoolException("商品库存不足！"); } else if (anfme == 0){ manLocDetlMapper.deleteLocNo0(offSaleParam.getLocNo(), offSaleParam.getMatnr()); } manLocDetlMapper.updateAnfme0(anfme,manLocDetl.getNodeId()); } // 查找商品 @Override @Transactional public void adjust(MobileAdjustParam param, Long userId) { BasDevp basDevp = basDevpService.selectById(param.getStaNo()); if (null == basDevp || basDevp.getWrkNo() == null) { throw new CoolException(param.getStaNo() + "盘点站无效"); } if (!param.getWrkNo().equals(basDevp.getWrkNo())) { throw new CoolException(param.getStaNo() + "盘点站更新，请重新检索"); } WrkMast wrkMast = wrkMastService.selectById(param.getWrkNo()); if (wrkMast.getWrkSts() < 10) { throw new CoolException("盘点无效，任务已盘点再入库"); } Date now = new Date(); List wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()); List list = param.getWrkDetls(); // 修改数量 Iterator iterator = wrkDetls.iterator(); while (iterator.hasNext()) { WrkDetl wrkDetl = iterator.next(); Iterator iterator1 = list.iterator(); while (iterator1.hasNext()) { WrkDetl wrkDetl1 = iterator1.next(); if (wrkDetl1.getAnfme() == 0) { iterator1.remove(); } if (wrkDetl.getMatnr().equals(wrkDetl1.getMatnr()) && Cools.eq(wrkDetl.getBatch(), wrkDetl1.getBatch())) { if (!wrkDetl.getAnfme().equals(wrkDetl1.getAnfme())) { // todo 盘点记录、保存调整记录 // 修改明细 if (!wrkDetlService.updateAnfme(wrkDetl1.getAnfme(), wrkMast.getWrkNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { throw new CoolException(wrkMast.getWrkNo() + "盘点任务，" + wrkDetl.getMatnr() + "商品，" + wrkDetl.getBatch() + "批号修改数量失败"); } } iterator.remove(); iterator1.remove(); } } } // 删除明细 for (WrkDetl wrkDetl : wrkDetls) { // todo 盘点记录、保存调整记录 if (!wrkDetlService.updateAnfme(-1.0D, wrkMast.getWrkNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { throw new CoolException("删除" + wrkMast.getWrkNo() + "盘点任务，" + wrkDetl.getMatnr() + "商品，" + wrkDetl.getBatch() + "批号任务明细失败"); } } // 添加明细 for (WrkDetl wrkDetl : list) { if (wrkDetl.getAnfme() == 0.0D) { continue; } // todo 盘点记录、保存调整记录 String orderNo = wrkDetl.getOrderNo(); Mat mat = matService.selectByMatnr(wrkDetl.getMatnr()); wrkDetl.sync(mat); wrkDetl.setOrderNo(orderNo); wrkDetl.setModiTime(now); wrkDetl.setModiUser(userId); wrkDetl.setAppeTime(now); wrkDetl.setAppeUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("添加" + wrkMast.getWrkNo() + "盘点任务，" + wrkDetl.getMatnr() + "商品，" + wrkDetl.getBatch() + "批号任务明细失败"); } } // 修改盘点任务主档状态 wrkMast.setFullPlt(wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()).size() != 0?"Y":"N"); wrkMast.setModiTime(now); wrkMast.setModiUser(userId); if (!wrkMastService.updateById(wrkMast)) { throw new CoolException("修改盘点任务主档失败"); } } @Override @Transactional public void packComb(CombParam param, Long userId) { if (Cools.isEmpty(param.getBarcode(), param.getCombMats())) { throw new CoolException(BaseRes.PARAM); } // 判断是否有相同条码的数据 if (waitPakinService.selectCount(new EntityWrapper(). eq("zpallet", param.getBarcode()).eq("io_status", "N")) > 0) { throw new CoolException(param.getBarcode() + "数据正在进行入库"); } Date now = new Date(); boolean packDown = Parameter.get().getPackDown().equals("true"); // 无单组托 if (Cools.isEmpty(param.getOrderNo())) { // 生成入库通知档 List detlDtos = new ArrayList<>(); param.getCombMats().forEach(elem -> { // 打包上线数据校验 if (packDown) { Pack pack = packService.selectByBarcode(elem.getMatnr()); if (pack == null) { throw new CoolException(elem.getMatnr() + "条码冗余，请检查！"); } if (pack.getSettle() != 1) { throw new CoolException(elem.getMatnr() + "条码已下线，请检查！"); } } Mat analyse = MatUtils.analyseMat(elem.getMatnr()); // 条码、物料代码、序列号、数量 DetlDto detlDto = new DetlDto(elem.getMatnr(), analyse.getMatnr(), analyse.getBarcode(), elem.getAnfme()); // DetlDto detlDto = new DetlDto(elem.getMatnr(), elem.getBatch(), elem.getAnfme()); if (DetlDto.has(detlDtos, detlDto)) { DetlDto one = DetlDto.find(detlDtos, detlDto.getMatnr(), detlDto.getBatch()); assert one != null; one.setAnfme(one.getAnfme() + detlDto.getAnfme()); } else { detlDtos.add(detlDto); } }); if (packDown) { MesCombParam mesCombParam = new MesCombParam(); mesCombParam.setZpallet(param.getBarcode()); mesCombParam.setPakinTime(DateUtils.convert(now)); mesCombParam.setLgort("5008"); mesCombParam.setPlantCode("5000"); mesCombParam.setFromCode("5012-20"); mesCombParam.setStationCode("JJQ-PFZPDB-XX"); for (DetlDto detlDto : detlDtos) { mesCombParam.getList().add(new MesCombParam.Detl(detlDto.getOrderNo(), detlDto.getAnfme())); } String response = ""; boolean success = false; try { response = new HttpHandler.Builder() .setUri(MesConstant.URL) .setPath(MesConstant.PACK_DOWN_URL) .setJson(JSON.toJSONString(mesCombParam)) .build() .doPost(); JSONObject jsonObject = JSON.parseObject(response); if (jsonObject.getInteger("code").equals(200)) { success = true; } else if (jsonObject.getInteger("code").equals(500)) { log.error("请求接口失败！！！url：{}；request：{}；response：{}", MesConstant.URL+MesConstant.PACK_DOWN_URL, JSON.toJSONString(mesCombParam), response); throw new CoolException(jsonObject.getString("msg")); } else { log.error("请求接口失败！！！url：{}；request：{}；response：{}", MesConstant.URL+MesConstant.PACK_DOWN_URL, JSON.toJSONString(mesCombParam), response); throw new CoolException("上报mes系统失败"); } } catch (Exception e) { log.error("fail", e); throw new CoolException(e.getMessage()); } finally { try { // 保存接口日志 apiLogService.save( "打包下线帮托上报", MesConstant.URL + MesConstant.PACK_DOWN_URL, null, "127.0.0.1", JSON.toJSONString(mesCombParam), response, success ); } catch (Exception e) { log.error("", e); } } } // 生成入库单据 String orderNo = "PACK" + snowflakeIdWorker.nextId(); OpenOrderPakinParam openParam = new OpenOrderPakinParam(); openParam.setOrderNo(orderNo); openParam.setOrderTime(DateUtils.convert(now)); openParam.setOrderType("打包入库单"); openParam.setOrderDetails(detlDtos); openService.pakinOrderCreate(openParam); Order order = orderService.selectByNo(orderNo); if (null == order) { throw new CoolException("生成单据失败"); } if (!orderService.updateSettle(order.getId(), 2L, userId)) { throw new CoolException("修改单据状态失败"); } // 生成入库通知档 for (DetlDto detlDto : detlDtos) { // 修改作业数量 ---------------------------------------- // 订单明细数量校验 OrderDetl orderDetl = orderDetlService.selectItem(order.getId(), detlDto.getMatnr(), detlDto.getBatch()); if (detlDto.getAnfme() > orderDetl.getEnableQty()) { throw new CoolException(orderDetl.getMatnr() + "入库数量不合法"); } // 修改订单作业数量 if (!orderDetlService.increaseWorkQty(order.getId(), detlDto.getMatnr(), detlDto.getBatch(), detlDto.getAnfme())) { throw new CoolException("修改单据作业数量失败"); } // 保存入库通知档 Mat mat = matService.selectByMatnr(detlDto.getMatnr()); if (Cools.isEmpty(mat)) { throw new CoolException(detlDto.getMatnr() + "商品档案不存在"); } WaitPakin waitPakin = new WaitPakin(); waitPakin.sync(mat); waitPakin.setOrderNo(orderNo); waitPakin.setBatch(detlDto.getBatch()); waitPakin.setZpallet(param.getBarcode()); // 托盘码 waitPakin.setIoStatus("N"); // 入出状态 waitPakin.setAnfme(detlDto.getAnfme()); // 数量 waitPakin.setStatus("Y"); // 状态 waitPakin.setAppeUser(userId); waitPakin.setAppeTime(now); waitPakin.setModiUser(userId); waitPakin.setModiTime(now); if (!waitPakinService.insert(waitPakin)) { throw new CoolException("保存入库通知档失败"); } // 修改打包数据状态 Pack pack = packService.selectByBarcode(detlDto.getOrderNo()); pack.setSettle(2L); pack.setUpdateTime(now); pack.setUpdateBy(userId); if (!packService.updateById(pack)) { throw new CoolException("修改打包数据异常"); } } } } @Override @Transactional public void pakoutByOrder(JSONObject param, Long userId) { Integer staNo = param.containsKey("staNo") ? Integer.parseInt(param.get("staNo").toString()) : 0; String orderNo = param.containsKey("orderNo") ? param.get("orderNo").toString() : ""; BasDevp sta = basDevpService.checkSiteStatus(staNo); //根据订单号生成出库任务工作档 Order order = orderService.selectOne(new EntityWrapper().eq("order_no", orderNo)); if (order.getSettle() != 1 && order.getSettle() != 2){ throw new CoolException("该订单已处理"); } List orderDetls = orderDetlService.selectList(new EntityWrapper().eq("order_no", orderNo)); Date now = new Date(); for(OrderDetl orderDetl : orderDetls){ //查询所有库位状态为F的库位信息 List locDetls = locDetlService.queryStock(orderDetl.getMatnr(),orderDetl.getBatch(),null,null); if (locDetls.size() == 0) { throw new CoolException("库存中没有该物料"); } for(LocDetl locDetl : locDetls){ //如果该库位出库路线所用的堆垛机out_enable不为Y,跳过该循环 LocMast locMast = locMastService.selectOne(new EntityWrapper() .eq("loc_no", locDetl.getLocNo())); if (Cools.isEmpty(locMast)) { continue; } BasCrnp crn_no = basCrnpService.selectOne(new EntityWrapper() .eq("crn_no", locMast.getCrnNo())); if (Cools.isEmpty(crn_no) || !crn_no.getOutEnable().equals("Y")){ continue; } //可出库数量 = 订单数量 - 作业中数量 Double outQty = orderDetl.getAnfme() - orderDetl.getWorkQty(); if(outQty <= 0){ break; } // 判断入出库类型：101.全板出库 or 103.拣料出库 Double sumCount = locDetlService.getLocDetlSumQty(locDetl.getLocNo()); Double curOutQty = outQty >= locDetl.getAnfme() ? locDetl.getAnfme() : outQty; //本次出库量 int ioType = sumCount <= curOutQty ? 101 : 103; stockOut(orderDetl, sta, locDetl, curOutQty, ioType, userId, now); order.setSettle(2L); order.setUpdateBy(userId); order.setUpdateTime(now); if(!orderService.update(order, new EntityWrapper().eq("order_no", orderNo))){ throw new CoolException("更新订单状态失败"); } orderDetl.setWorkQty(orderDetl.getWorkQty() + curOutQty); orderDetl.setUpdateBy(userId); orderDetl.setUpdateTime(now); Wrapper wrapper = new EntityWrapper().eq("order_no", orderNo) .eq("matnr",orderDetl.getMatnr()); if(!Cools.isEmpty(orderDetl.getBatch())){ wrapper.eq("batch", orderDetl.getBatch()); } if(!orderDetlService.update(orderDetl, wrapper)){ throw new CoolException("更新订单明细失败"); } } } } @Override @Transactional public void stockOut(OrderDetl orderDetl, BasDevp staNo, LocDetl locDetl, Double curOutQty, Integer ioType, Long userId, Date now) { // 获取库位 LocMast locMast = locMastService.selectById(locDetl.getLocNo()); // 获取路径 Wrapper wrapper = new EntityWrapper() .eq("type_no", ioType) .eq("stn_no", staNo.getDevNo()) .eq("crn_no", locMast.getCrnNo()); StaDesc staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { throw new CoolException("出库路径不存在"); } // 生成工作号 int workNo = commonService.getWorkNo(2); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(now); wrkMast.setWrkSts(11L); // 工作状态：11.生成出库ID wrkMast.setIoType(ioType); // 入出库状态 wrkMast.setIoPri(13D); // 优先级：13 wrkMast.setCrnNo(locMast.getCrnNo()); wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站 wrkMast.setStaNo(staDesc.getStnNo()); // 目标站 wrkMast.setSourceLocNo(locDetl.getLocNo()); // 源库位 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setAppeUser(userId); // 操作人员数据 wrkMast.setSheetNo("0"); //徐工汉云拆垛标记：0: 初始 1: 未拆 2:已拆 3：已处理可下一步（转历史档） if (wrkMast.getStaNo()<118 || wrkMast.getStaNo()>121){ wrkMast.setSheetNo("3"); } wrkMast.setAppeTime(now); wrkMast.setModiUser(userId); wrkMast.setModiTime(now); wrkMast.setBarcode(locMast.getBarcode()); if (!wrkMastService.insert(wrkMast)) { throw new CoolException("保存工作档失败，出库库位号：" + locDetl.getLocNo()); } WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(locDetl); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(now); wrkDetl.setAnfme(curOutQty); // 数量 wrkDetl.setOrderNo(orderDetl.getOrderNo()); wrkDetl.setAppeTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiTime(now); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作档明细失败"); } // 修改库位状态: F.在库 ====>>> R.出库预约/P.拣料/盘点/并板出库中 locMast = locMastService.selectById(locDetl.getLocNo()); if (locMast.getLocSts().equals("F")) { locMast.setLocSts(ioType == 101 ? "R" : "P"); locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)) { throw new CoolException("预约库位状态失败，库位号：" + locDetl.getLocNo()); } } else { throw new CoolException(locDetl.getLocNo() + "库位不是在库状态"); } } @Override @Transactional public R pakoutFhqr(PdckqrParam param) { // 获取工作档 WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("barcode",param.getBarcode())); if (wrkMast == null) { throw new CoolException("工作档不存在：" + param.getBarcode()); } if (wrkMast.getWrkSts() != 20) { throw new CoolException(wrkMast.getWrkNo() + ",工作档类型：" + wrkMast.getIoType() + "工作状态：" + wrkMast.getWrkSts() + ",不匹配"); } List wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()); List materials = param.getMaterials(); boolean isFullyCancelled = compareAndCheckCancellation(wrkDetls, materials); if (isFullyCancelled) { // 复核确认，更新状态为15出库完成更新 wrkMast.setWrkSts(14L); wrkMastService.updateById(wrkMast); } else { throw new CoolException("出口复核失败"); } return R.ok("出口复核成功"); } @Override @Transactional public R pdckqr(PdckqrParam param) { WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("barcode",param.getBarcode())); if (wrkMast == null) { throw new CoolException("工作档不存在：" + param.getBarcode()); } if (wrkMast.getIoType() != 107 || wrkMast.getWrkSts() != 2) { throw new CoolException(wrkMast.getWrkNo() + "：工作状态不匹配"); } List wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo()); List materials = param.getMaterials(); boolean isFullyCancelled = compareAndCheckCancellation(wrkDetls, materials); // todo 两箱盘两箱需要确定位置没错 if (isFullyCancelled) { // 盘点物料确成功，工作档转换 盘点出库->盘点再入库，下发回库命令 // 保存工作主档历史档 if (!wrkMastLogService.save(wrkMast.getWrkNo())) { throw new CoolException("保存工作主档历史档失败"); } // 获取目标站 Wrapper wrapper = new EntityWrapper() .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)) { throw new CoolException("入库路径不存在"); } Date now = new Date(); // 堆垛机站点(目标站) Integer staNo = staDesc.getCrnStn(); // 更新工作档数据状态 wrkMast.setIoType(wrkMast.getIoType() - 50); // 入出库类型: 103->53,104->54,107->57 wrkMast.setWrkSts(14L); // 工作状态: 14.已出库未确认 wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 源站 wrkMast.setStaNo(staNo); // 目标站 wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 目标库位 = 出库时的源库位 wrkMast.setSourceLocNo(""); // 源库位清空 wrkMast.setModiTime(now); if (!wrkMastService.updateById(wrkMast)) { throw new CoolException("更新工作档数据状态失败"); } // 修改库位状态 Q.拣料/盘点/并板再入库 LocMast locMast = locMastService.selectById(wrkMast.getLocNo()); locMast.setLocSts("Q"); locMast.setModiTime(now); if (!locMastService.updateById(locMast)) { throw new CoolException("修改库位状态失败"); } // 推送给gwcs执行命令 openServiceImpl.pushStaNoToGwcs(wrkMast.getSourceStaNo(),wrkMast.getStaNo(),wrkMast.getWrkNo(),wrkMast.getBarcode(),"盘点确认成功推送gwcs"); return R.ok("盘点确认成功"); } else { // 物料不一致 // 不一致的处理处理方法：弹出调整界面 // 重新扫描实物上面的码进行调整 // 实物在库存里面的地方清空，任务所在库存清空 // 将实物和当前托盘位置和库位绑定 // 一个木箱情况直接调整 // 两个木箱出两个 都调整 // 两个木箱出一个 调整一个 // 工作档标记异常->回库 return R.error("盘点确认异常"); } } @Override @Transactional public R pdaWarehousingNow(PdaWarehousingNowParam param, Long userId) { String barcode = param.getBarcode(); Integer sourceStaNo = param.getSourceStaNo(); int zpalletCount = locDetlService.selectCount(new EntityWrapper().eq("zpallet", barcode)); if (zpalletCount > 0) { throw new CoolException("库存托盘码已存在：" + barcode); } int barcodeCount = wrkMastService.selectCount(new EntityWrapper().eq("barcode", barcode)); if (barcodeCount > 0) { throw new CoolException("工作档已存在该托盘码：" + barcode); } Map> boxGroup = param.getBoxGroup(); List leftPosList = boxGroup.get("左"); List centrePosList = boxGroup.get("中"); List rightPosList = boxGroup.get("右"); // 根据箱号获取包装组号 List boxNoList = leftPosList.stream().map(PdaWarehousingNowParam.Roll::getBoxNo).distinct().collect(Collectors.toList()); boxNoList.addAll(centrePosList.stream().map(PdaWarehousingNowParam.Roll::getBoxNo).distinct().collect(Collectors.toList())); boxNoList.addAll(rightPosList.stream().map(PdaWarehousingNowParam.Roll::getBoxNo).distinct().collect(Collectors.toList())); Map map = new HashMap<>(); // if (boxNoList.size() > 0) { // map = getPackageGroupNoByGwms(boxNoList); // } LocTypeDto locTypeDto = new LocTypeDto(); locTypeDto.setLocType1((short)1); // 根据源站点寻找库位 StartupDto dto = commonService.getLocNo(1, sourceStaNo, locTypeDto,0); int workNo = dto.getWorkNo(); Date now = new Date(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态：1.生成入库id wrkMast.setIoType(1); // 入出库状态：1.入库 wrkMast.setIoPri(13D); // 优先级 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(barcode); // 托盘码 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(1); // 容器类型 // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setModiTime(now); wrkMast.setAppeUser(userId); wrkMast.setModiUser(userId); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } for (PdaWarehousingNowParam.Roll roll: leftPosList) { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setMatnr(roll.getSpecs()); // 规格 wrkDetl.setMaktx(roll.getSpecs()); //规格 wrkDetl.setBatch(roll.getBoxNo()); // 箱号 wrkDetl.setModel(roll.getRollNo()); // 卷号 wrkDetl.setBrand(map.get(roll.getBoxNo()) == null ? "" : map.get(roll.getBoxNo())); // 包装组号 wrkDetl.setZpallet(barcode); // 托盘吗 wrkDetl.setOrigin("左"); // 木箱在托盘位置 wrkDetl.setWeight(roll.getNetWeight()); // 净重 wrkDetl.setVolume(roll.getGrossWeight()); // 毛重 wrkDetl.setPrice(roll.getLength()); wrkDetl.setSpecs(String.valueOf(roll.getSplices())); wrkDetl.setAnfme(1.0); wrkDetl.setIoTime(now); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } } for (PdaWarehousingNowParam.Roll roll: centrePosList) { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setMatnr(roll.getSpecs()); // 规格 wrkDetl.setMaktx(roll.getSpecs()); //规格 wrkDetl.setBatch(roll.getBoxNo()); // 箱号 wrkDetl.setModel(roll.getRollNo()); // 卷号 wrkDetl.setBrand(map.get(roll.getBoxNo()) == null ? "" : map.get(roll.getBoxNo())); // 包装组号 wrkDetl.setZpallet(barcode); // 托盘吗 wrkDetl.setOrigin("中"); // 木箱在托盘位置 wrkDetl.setWeight(roll.getNetWeight()); // 净重 wrkDetl.setVolume(roll.getGrossWeight()); // 毛重 wrkDetl.setPrice(roll.getLength()); wrkDetl.setSpecs(String.valueOf(roll.getSplices())); wrkDetl.setAnfme(1.0); wrkDetl.setIoTime(now); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } } for (PdaWarehousingNowParam.Roll roll: rightPosList) { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setMatnr(roll.getSpecs()); // 规格 wrkDetl.setMaktx(roll.getSpecs()); //规格 wrkDetl.setBatch(roll.getBoxNo()); // 箱号 wrkDetl.setModel(roll.getRollNo()); // 卷号 wrkDetl.setBrand(map.get(roll.getBoxNo()) == null ? "" : map.get(roll.getBoxNo())); // 包装组号 wrkDetl.setZpallet(barcode); // 托盘吗 wrkDetl.setOrigin("右"); // 木箱在托盘位置 wrkDetl.setWeight(roll.getNetWeight()); // 净重 wrkDetl.setVolume(roll.getGrossWeight()); // 毛重 wrkDetl.setPrice(roll.getLength()); wrkDetl.setSpecs(String.valueOf(roll.getSplices())); wrkDetl.setAnfme(1.0); wrkDetl.setIoTime(now); wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } } // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("O")){ locMast.setLocSts("S"); // S.入库预约 locMast.setModiTime(now); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } // 推送GWCS目标消息 openServiceImpl.pushStaNoToGwcs(sourceStaNo,dto.getStaNo(),dto.getWorkNo(),barcode,"pda组托立即入库推送gwcs"); return R.ok("入库启动成功"); } @Override public R pdaFxprk(GwmsGenerateInventoryDto param, Long userId) { if (Cools.isEmpty(param,param.getMatList())) { throw new CoolException("请求参数不能为空：" + param); } if (Cools.isEmpty(param.getBarcode())) { throw new CoolException("条码不能为空：" + param.getBarcode()); } int zpalletCount = locDetlService.selectCount(new EntityWrapper().eq("zpallet", param.getBarcode())); if (zpalletCount > 0) { throw new CoolException("库存托盘码已存在：" + param.getBarcode()); } int barcodeCount = wrkMastService.selectCount(new EntityWrapper().eq("barcode", param.getBarcode())); if (barcodeCount > 0) { throw new CoolException("工作档已存在该托盘码：" + param.getBarcode()); } LocTypeDto locTypeDto = new LocTypeDto(); locTypeDto.setLocType1((short) 1); int iotype = 1; if (Cools.isEmpty(param.getMatList())) { iotype = 10; } // 根据源站点寻找库位 StartupDto dto = commonService.getLocNo(iotype, param.getPalletizingNo(), locTypeDto, 0); int workNo = dto.getWorkNo(); Date now = new Date(); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态：设备上走 wrkMast.setIoType(iotype); // 入出库状态：1.入库 wrkMast.setIoPri(13D); // 优先级 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(param.getPalletizingNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(param.getBarcode()); // 托盘码 wrkMast.setFullPlt("Y"); // 满板：Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("Y"); wrkMast.setCtnType(1); // 容器类型 // 操作人员数据 wrkMast.setAppeTime(now); wrkMast.setAppeUser(userId); wrkMast.setModiTime(now); wrkMast.setModiUser(userId); wrkMastService.insert(wrkMast); if (!Cools.isEmpty(param.getMatList())) { List matList = param.getMatList(); List groupNos = new ArrayList<>(); for (GwmsGenerateInventoryDto.MatList obj : matList) { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(wrkMast.getWrkNo()); obj.getRolls().forEach(roll -> { wrkDetl.setWrkNo(wrkMast.getWrkNo()); wrkDetl.setMatnr(roll.getSpecs()); // 规格 wrkDetl.setMaktx(roll.getSpecs()); //规格 wrkDetl.setUnit(roll.getBoxNo()); // 箱号 wrkDetl.setModel(roll.getRollNo()); // 卷号 wrkDetl.setBrand(obj.getPackageGroupNo()); // 包装组号 wrkDetl.setZpallet(param.getBarcode()); // 托盘码 wrkDetl.setBarcode(param.getBarcode()); wrkDetl.setOrigin(obj.getBoxPos()); // 木箱在托盘位置 wrkDetl.setColor(obj.getBoxType()); // 木箱类型 wrkDetl.setManu(obj.getRollType()); // 管芯类型 wrkDetl.setSku(obj.getWideInWidth()); // 实测宽幅 wrkDetl.setItemNum(obj.getThickness()); // 生箔厚度 wrkDetl.setManuDate(roll.getFqTime()); // 分切下料时间 wrkDetl.setWeight(roll.getNetWeight()); // 净重 wrkDetl.setVolume(roll.getGrossWeight()); // 毛重 wrkDetl.setLength(roll.getLength()); // 长度 wrkDetl.setSpecs(String.valueOf(roll.getSplices())); // 接头 wrkDetl.setAnfme(1.0); // wrkDetl.setThreeCode(null); // 通过mes或excel导入检测是否合格 0不合格，1 合格 // wrkDetl.setDeadWarn(); // 理货标识 0默认，1理货中，2理货完成w // wrkDetl.setInspect(); // 订单明细中用，标识备货的状态 0未备货，1备货中，2备货完成 // wrkDetl.setDanger(); // 订单明细中用，标识跨巷道移库 0未移库，1移库中，2移库完成 wrkDetl.setIoTime(now); wrkDetl.setAppeTime(now); wrkDetl.setAppeUser(userId); wrkDetl.setModiUser(userId); wrkDetl.setModiTime(now); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作明细失败"); } }); groupNos.add(obj.getPackageGroupNo()); } // 一楼反修品入库的木箱通过包装组号需给mes推送待判 pushDpToMes(groupNos); } // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocSts().equals("O")) { locMast.setLocSts("S"); // S.入库预约 locMast.setModiTime(now); if (!locMastService.updateById(locMast)) { throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo() + "目标库位已被占用"); } // 一楼返修入库推送mes做记录 pushFxrkToMes(param); // 返回GWCS目标信息 openServiceImpl.pushStaNoToGwcs(param.getPalletizingNo(), dto.getStaNo(), dto.getWorkNo(), param.getBarcode(), "二楼返修入库推送gwcs"); return R.ok("反修入库成功"); } private void pushFxrkToMes(GwmsGenerateInventoryDto param) { for (GwmsGenerateInventoryDto.MatList matList : param.getMatList()){ matList.setOutOrIn("in"); matList.setStockType("返修入库"); } boolean success = false; // 获取请求头 Map headers = new HashMap<>(); headers.put("Content-Type","application/json;charset=UTF-8"); // 构造请求体 String body = JSON.toJSONString(param); String response = ""; try { response = new HttpHandler.Builder() .setUri(MesConstant.MES_CC_IP_PORT) .setPath(MesConstant.MES_CC_FXRK_URL) .setHeaders(headers) .setJson(body) .build() .doGet(); if (!Cools.isEmpty(response)) { JSONObject jsonObject1 = JSONObject.parseObject(response); int code = (int) jsonObject1.get("code"); boolean state = jsonObject1.getBoolean("state"); if (code == 200 && state) { success = true; } } else { log.error("返修入库推送mes记录失败！！！url：{}；request：{}；response：{}", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_FXRK_URL, body, response); } } catch (Exception e) { log.error("返修入库推送mes记录异常：{}", e.getMessage()); } finally { try { // 保存接口日志 apiLogService.save( "返修入库推送mes记录", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_FXRK_URL, null, "127.0.0.1", body, response, success ); } catch (Exception e) { log.error("", e); } } } @Override @Transactional public R pdtz(PdtzParam param) { String barcode = param.getBarcode(); Integer palletizingNo = param.getPalletizingNo(); List matList = param.getMatList(); // 增加冗余字段，给mes推送时结构和入库保存一致 for (PdtzParam.MatList matList1 : matList) { matList1.setBarcode(barcode); matList1.setPalletizingNo(palletizingNo); } WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper().eq("barcode", barcode)); LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo()); // 实物包装组号 List groups = matList.stream().map(PdtzParam.MatList::getPackageGroupNo).distinct().collect(Collectors.toList()); // 库存明细木箱位置集合 List locDetls = locDetlService.selectList(new EntityWrapper().eq("zpallet", barcode)); List collect1 = locDetls.stream().map(LocDetl::getOrigin).distinct().collect(Collectors.toList()); // 工作明细木箱位置集合 List wrkDetls = wrkDetlService.selectList(new EntityWrapper().eq("zpallet", barcode)); List collect2 = wrkDetls.stream().map(WrkDetl::getOrigin).distinct().collect(Collectors.toList()); // 工作的包装组号 List wrkBrandlist = wrkDetls.stream().map(WrkDetl::getBrand).distinct().collect(Collectors.toList()); // 工作订单明细 List orderDetlList = orderDetlMapper.selectList(new EntityWrapper().in("brand", wrkBrandlist)); Date now = new Date(); // 判断要调整的木箱所在位置关系 if (collect1.size() == 0 || collect2.size() == 0){ return R.parse(barcode+"：任务库存异常！"); } else if(collect1.size() == 2 && collect2.size() == 1) { // 2出1，都是单箱的 if (matList.size() == 0) { // 实物是空 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // todo 标记异常，推送mes，回库 for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); kctzPushMes(jsonObject); kctzReturn(wrkMast); } else { // 实物不为空 // 寻找实物的位置 List locDetls1 = locDetlService.selectList(new EntityWrapper().in("brand", groups).notIn("barcode",barcode)); if (locDetls1.size() == 0) { // 实物无库存 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // 补充木箱位置 matList.get(0).setBoxPos(collect2.get(0)); // 把实物物料信息放入任务所在库位 insertLocDetl(locMast.getLocNo(),barcode,matList); // todo 标记异常，推送mes，回库 for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); jsonObject.put("insert",matList); kctzPushMes(jsonObject); kctzReturn(wrkMast); }else { // 实物有库存 List brandList = locDetls1.stream().map(LocDetl::getBrand).distinct().collect(Collectors.toList()); return R.parse(brandList+"库存已存在，请先处理！"); } } } else if(collect1.size() == 1 && collect2.size() == 1) { if (matList.size() == 0) { // 实物为空 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // 完成这条盘点任务：更新订单完成数量，工作主档5 for(WrkDetl wrkDetl:wrkDetls) { if (!Cools.isEmpty(wrkDetl.getOrderNo())) { // 更新订单完成数量 orderDetlMapper.updateOrderDetlQtyByGroupNo(wrkDetl.getOrderNo(), wrkDetl.getBrand()); } } if (locMast.getLocSts().equals("P")) { locMast.setLocSts("O"); locMast.setBarcode(""); locMast.setSheetNo(""); locMast.setIoTime(now); locMast.setModiTime(now); locMastService.updateById(locMast); } // 修改工作主档状态 wrkMast.setWrkSts(5L); wrkMast.setModiTime(now); wrkMastService.updateById(wrkMast); // todo 标记异常，不回库，给gwcs下发去叠盘机命令,推送mes for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); kctzPushMes(jsonObject); // 推送给gwcs执行命令 openServiceImpl.pushStaNoToGwcs(wrkMast.getSourceStaNo(),3013,wrkMast.getWrkNo(),wrkMast.getBarcode(),"盘点异常调整后回叠盘机推送gwcs"); } else { // 实物不为空 // 寻找实物的位置 List locDetls1 = locDetlService.selectList(new EntityWrapper().in("brand", groups).notIn("barcode",barcode)); if (locDetls1.size() == 0) { // 实物无库存 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // 补充木箱位置 for (PdtzParam.MatList matList1:matList) { matList1.setBoxPos(collect2.get(0)); } // 把实物物料信息放入任务所在库位 insertLocDetl(locMast.getLocNo(),barcode,matList); // todo 标记异常，回库，推送mes for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); jsonObject.put("insert",matList); kctzPushMes(jsonObject); kctzReturn(wrkMast); } else { // 实物有库存 List brandList = locDetls1.stream().map(LocDetl::getBrand).distinct().collect(Collectors.toList()); return R.parse(brandList+"库存已存在，请先处理！"); } } } else if (collect1.size() == 2 && collect2.size() == 2) { if (matList.size() == 0) { // 实物为空 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // 完成这条盘点任务：更新订单完成数量，工作主档5 for(WrkDetl wrkDetl:wrkDetls) { if (!Cools.isEmpty(wrkDetl.getOrderNo())) { // 更新订单完成数量 orderDetlMapper.updateOrderDetlQtyByGroupNo(wrkDetl.getOrderNo(), wrkDetl.getBrand()); } } if (locMast.getLocSts().equals("P")) { locMast.setLocSts("O"); locMast.setBarcode(""); locMast.setSheetNo(""); locMast.setIoTime(now); locMast.setModiTime(now); locMastService.updateById(locMast); } // 修改工作主档状态 wrkMast.setWrkSts(5L); wrkMast.setModiTime(now); wrkMastService.updateById(wrkMast); // todo 标记异常，推送mes,不回库，给gwcs下发去叠盘机命令 for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); jsonObject.put("insert",matList); kctzPushMes(jsonObject); // 推送给gwcs执行命令 openServiceImpl.pushStaNoToGwcs(wrkMast.getSourceStaNo(),3013,wrkMast.getWrkNo(),wrkMast.getBarcode(),"盘点异常调整后回叠盘机推送gwcs"); } else { // 实物不为空 // 寻找实物的位置 List locDetls1 = locDetlService.selectList(new EntityWrapper().in("brand", groups).notIn("barcode",barcode)); if (locDetls1.size() == 0) { // 实物无库存 // 把该任务在库明细删除 locDetlService.delete(new EntityWrapper().in("brand",wrkBrandlist)); // 补充木箱位置 matList.get(0).setBoxPos("左"); matList.get(1).setBoxPos("右"); // 把实物物料信息放入任务所在库位 insertLocDetl(locMast.getLocNo(),barcode,matList); // todo 标记异常，回库，推送mes for(OrderDetl orderDetl:orderDetlList) { orderDetl.setSource(1); orderDetlMapper.updateById(orderDetl); } JSONObject jsonObject = new JSONObject(); jsonObject.put("delete",wrkBrandlist); jsonObject.put("insert",matList); kctzPushMes(jsonObject); kctzReturn(wrkMast); } else { // 实物有库存 List brandList = locDetls1.stream().map(LocDetl::getBrand).distinct().collect(Collectors.toList()); return R.parse(brandList+"库存已存在，请先处理！"); } } } return R.ok("调整成功"); } @Override public R pdaFhhd(PdaDhhdParam param, Long userId) { String orderNo = param.getOrderNo(); Order order = orderService.selectByNo(orderNo); if (order == null) { return R.parse("单据编号不存在：" + orderNo); } else if (!order.getSettle().equals(4L)) { return R.parse("单据状态不为4.已完成"); } order.setSettle(5L); order.setUpdateBy(userId); order.setUpdateTime(new Date()); orderService.updateById(order); return R.ok("发货核对成功"); } // 同步盘点异常调整结果给mes void kctzPushMes(JSONObject jsonObject) { // 接口请求结果 boolean success = false; // 接口记录空间名称 String message = "同步盘点异常调整结果给mes"; // 构造请求体 String body = jsonObject.toJSONString(); String response = ""; try { response = new HttpHandler.Builder() .setUri(MesConstant.MES_CC_IP_PORT) .setPath(MesConstant.MES_CC_YCTZ_URL) .setJson(body) .build() .doPost(); if (!Cools.isEmpty(response)) { JSONObject result = JSON.parseObject(response); if (result.getInteger("code").equals(200)) { success = true; } } else { log.error(message + "失败！！！url：{}；request：{}；response：{}", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_YCTZ_URL, body, response); } } catch (Exception e) { log.error(message + "异常：{}", e); } finally { try { // 保存接口日志 apiLogService.save( message, MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_YCTZ_URL, null, "127.0.0.1", body, response, success ); } catch (Exception e) { log.error("", e); } } } // 盘点异常回库 @Transactional public void kctzReturn(WrkMast wrkMast) { if (!wrkMastLogService.save(wrkMast.getWrkNo())) { throw new CoolException("保存工作主档历史档失败"); } // 获取目标站 Wrapper wrapper = new EntityWrapper() .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)) { throw new CoolException("入库路径不存在"); } Date now = new Date(); // 堆垛机站点(目标站) Integer staNo = staDesc.getCrnStn(); // 更新工作档数据状态 wrkMast.setIoType(wrkMast.getIoType() - 50); // 入出库类型: 103->53,104->54,107->57 wrkMast.setWrkSts(14L); // 工作状态: 14.已出库未确认 wrkMast.setSourceStaNo(wrkMast.getStaNo()); // 源站 wrkMast.setStaNo(staNo); // 目标站 wrkMast.setLocNo(wrkMast.getSourceLocNo()); // 目标库位 = 出库时的源库位 wrkMast.setSourceLocNo(""); // 源库位清空 wrkMast.setModiTime(now); if (!wrkMastService.updateById(wrkMast)) { throw new CoolException("更新工作档数据状态失败"); } // 修改库位状态 Q.拣料/盘点/并板再入库 LocMast locMast = locMastService.selectById(wrkMast.getLocNo()); locMast.setLocSts("Q"); locMast.setModiTime(now); if (!locMastService.updateById(locMast)) { throw new CoolException("修改库位状态失败"); } // 推送给gwcs执行命令 openServiceImpl.pushStaNoToGwcs(wrkMast.getSourceStaNo(),wrkMast.getStaNo(),wrkMast.getWrkNo(),wrkMast.getBarcode(),"盘点异常调整后推送gwcs"); } /** * 调整库存明细 */ @Transactional void insertLocDetl(String locNo, String barcode, List matList) { Date now = new Date(); for (PdtzParam.MatList mat : matList) { LocDetl locDetl = new LocDetl(); locDetl.setBatch(""); locDetl.setLocNo(locNo); locDetl.setMatnr(mat.getSpecs()); // 规格 locDetl.setMaktx(mat.getSpecs()); //规格 locDetl.setUnit(mat.getBoxNo()); // 箱号 locDetl.setModel(mat.getRollNo()); // 卷号 locDetl.setBrand(mat.getPackageGroupNo()); // 包装组号 locDetl.setZpallet(barcode); // 托盘码 locDetl.setBarcode(barcode); locDetl.setOrigin(mat.getBoxPos()); // 木箱在托盘位置 locDetl.setColor(mat.getBoxType()); // 木箱类型 locDetl.setManu(mat.getRollType()); // 管芯类型 locDetl.setSku(mat.getWideInWidth()); // 实测宽幅 locDetl.setItemNum(mat.getThickness()); // 生箔厚度 locDetl.setManuDate(mat.getFqTime()); // 分切下料时间 locDetl.setWeight(mat.getNetWeight()); // 净重 locDetl.setVolume(mat.getGrossWeight()); // 毛重 locDetl.setLength(mat.getLength()); // 长度 locDetl.setSpecs(String.valueOf(mat.getSplices())); // 接头 locDetl.setAnfme(1.0); // wrkDetl.setThreeCode(null); // 通过mes或excel导入检测是否合格 0不合格，1 合格 locDetl.setAppeTime(now); locDetl.setModiTime(now); locDetlService.insert(locDetl); } } /** * 一楼反修品入库的木箱通过包装组号需给mes推送待判 */ private void pushDpToMes(List groupNos) { boolean success = false; // 获取请求头 Map headers = new HashMap<>(); headers.put("Content-Type","application/json;charset=UTF-8"); // 构造请求体 JSONObject jsonObject = new JSONObject(); jsonObject.put("groupNos", groupNos); String body = jsonObject.toJSONString(); String response = ""; try { response = new HttpHandler.Builder() .setUri(MesConstant.MES_CC_IP_PORT) .setPath(MesConstant.MES_CC_DP_URL) .setHeaders(headers) .setJson(body) .build() .doGet(); if (!Cools.isEmpty(response)) { JSONObject jsonObject1 = JSONObject.parseObject(response); int code = (int) jsonObject1.get("code"); boolean state = jsonObject1.getBoolean("state"); String msg = (String) jsonObject1.get("message"); if (code == 200 && state) { success = true; } throw new CoolException(msg); } else { log.error("返修品入库给mes推送待判失败！！！url：{}；request：{}；response：{}", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_DP_URL, body, response); throw new CoolException("返修品入库给mes推送待判失败"); } } catch (Exception e) { log.error("返修品入库给mes推送待判异常：{}", e.getMessage()); } finally { try { // 保存接口日志 apiLogService.save( "返修品入库给mes推送待判", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_DP_URL, null, "127.0.0.1", body, response, success ); } catch (Exception e) { log.error("", e); } } } private Map getPackageGroupNoByGwms(List boxNoList) { Map map = null; Map headers = new HashMap<>(); headers.put("Content-Type", "application/json;charset=UTF-8"); JSONObject jsonObject = new JSONObject(); jsonObject.put("boxNoList", JSONObject.toJSONString(boxNoList)); String body = jsonObject.toJSONString(); boolean success = false; String response = ""; try { response = new HttpHandler.Builder() .setUri(MesConstant.GWMS_IP_PORT) .setPath(MesConstant.GWMS_GET_GROUP_NO_URL) .setHeaders(headers) .setJson(body) .build() .doPost(); if (!Cools.isEmpty(response)) { JSONObject jsonObject1 = JSONObject.parseObject(response); int code = (int) jsonObject1.get("code"); String msg = (String) jsonObject1.get("msg"); if (code != 200) { throw new CoolException(msg); } map = (Map) jsonObject1.get("data"); success = true; } else { log.error("pda组托入库请求gwms接口失败！！！url：{}；request：{}；response：{}", MesConstant.URL + MesConstant.PAKIN_URL, body, response); } } catch (Exception e) { log.error("pda组托入库请求gwms接口异常，工作号：{}，{}", boxNoList.toString(), e.getMessage()); } finally { try { // 保存接口日志 apiLogService.save( "pda组托入库请求gwms接口", MesConstant.URL + MesConstant.PAKIN_URL, null, "127.0.0.1", body, response, success ); } catch (Exception e) { log.error("接口日志保存异常", e); } } if (map == null) { throw new CoolException("请求gwcs查询包装组号异常"); } return map; } /** * 比较两个集合的类的属性，相同则抵消，最后判断两个集合是否完全抵消 */ public boolean compareAndCheckCancellation(List list1, List list2) { if (list1.size() != list2.size()) { return false; // If lists are not of the same size, cancellation is not possible } List remainingList2 = new ArrayList<>(list2); // Compare and cancel out elements for (WrkDetl p1 : list1) { boolean cancelled = false; for (PdckqrParam.Material p2 : remainingList2) { if (p1.getUnit().equals(p2.getBoxNo()) && p1.getModel().equals(p2.getRollNo())) { // 卷号和箱号相同 remainingList2.remove(p2); cancelled = true; break; } } if (!cancelled) { return false; // If any element in list1 cannot be cancelled, return false } } return remainingList2.isEmpty(); // Return true if all elements in list1 were cancelled out } @Override @Transactional public List> boxTypeComb() { EntityWrapper wrapper = new EntityWrapper<>(); List> result = new ArrayList<>(); List basBoxTypes = basBoxTypeService.selectList(wrapper.orderBy("id",true)); for (BasBoxType basBoxType : basBoxTypes){ Map map = new HashMap<>(); map.put("boxType", basBoxType.getBoxType()); map.put("boxSpecs", basBoxType.getBoxSpecs()); result.add(map); } return result; } }