| | |
| | | // 生成工作档明细 |
| | | List<MatCodeCountDto> matDtos = new ArrayList<>(); |
| | | param.getList().forEach(elem -> { |
| | | matDtos.add(new MatCodeCountDto(elem.getMatNo(), elem.getCount())); |
| | | matDtos.add(new MatCodeCountDto(elem.getMatNo(), elem.getSupplier(), elem.getCount(),elem.getMemo(),elem.getSource(),elem.getVendor())); |
| | | }); |
| | | wrkDetlService.createWorkDetail(workNo, matDtos, param.getBarcode(), userId); |
| | | // 更新源站点信息 |
| | |
| | | wrkMast.setIoType(ioType); // 入出库状态 |
| | | wrkMast.setIoPri(reduce?13D:15D); // 优先级:13 |
| | | wrkMast.setCrnNo(locMast.getCrnNo()); |
| | | wrkMast.setBarcode(locMast.getBarcode()); |
| | | wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站 |
| | | wrkMast.setStaNo(staDesc.getStnNo()); // 目标站 |
| | | wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位 |
| | |
| | | } |
| | | // 生成工作档明细 |
| | | for (LocDetlDto detlDto : dto.getLocDetlDtos()) { |
| | | MatCode matCode = matCodeService.selectById(detlDto.getLocDetl().getMatNo()); |
| | | if(Cools.isEmpty(matCode)){ |
| | | throw new CoolException("产品编码在基础数据中不存在,请确认"); |
| | | } |
| | | // 出库时,数量为0的直接忽略 |
| | | if (detlDto.getCount()==null || detlDto.getCount() <= 0.0D) {continue;} |
| | | WrkDetl wrkDetl = new WrkDetl(); |
| | |
| | | wrkDetl.setAppeUser(userId); |
| | | wrkDetl.setModiTime(new Date()); |
| | | wrkDetl.setModiUser(userId); |
| | | // wrkDetl.setMemo(detlDto.getLocDetl().getMemo()); |
| | | wrkDetl.setMemo(String.valueOf(detlDto.getLocDetl().getQty())); // 总数量,led显示用 |
| | | wrkDetl.setQtyBox(matCode.getStr6()!=null ? matCode.getStr6() : 0); |
| | | wrkDetl.setWeight(matCode.getWeight()!=null ? matCode.getWeight() : 0); |
| | | wrkDetl.setAllWeight(matCode.getWeight()!=null ? qty*matCode.getWeight()+30 : 0); |
| | | wrkDetl.setAllQty(matCode.getStr6()!=null ? qty*matCode.getStr6() : 0); |
| | | wrkDetl.setVendor(detlDto.getLocDetl().getVendor()); |
| | | wrkDetl.setSource(detlDto.getLocDetl().getSource()); |
| | | wrkDetl.setSupplier(detlDto.getLocDetl().getSupplier()); |
| | | wrkDetl.setStr5(matCode.getStr5()); |
| | | wrkDetl.setStr4(matCode.getStr4()); |
| | | wrkDetl.setStr3(matCode.getStr3()); |
| | | if (!wrkDetlService.insert(wrkDetl)) { |
| | | throw new CoolException("保存工作档明细失败"); |
| | | } |
| | |
| | | // 获取工作号 |
| | | int workNo = commonService.getWorkNo(1); |
| | | |
| | | //2022-06-16 ADD, 出库库位如果是深库位1号货架,且对应浅库位也为D时,先出浅库位 |
| | | if(Utils.isDeepLoc(slaveProperties, locNo)){ |
| | | String shallow = Utils.getShallowLoc(slaveProperties,locNo); |
| | | LocMast shallowLoc = locMastService.selectById(shallow); |
| | | if(!Cools.isEmpty(shallowLoc) && shallowLoc.getLocSts().equals("D")){ |
| | | locNo = shallowLoc.getLocNo(); |
| | | } |
| | | } |
| | | |
| | | // 获取库位 |
| | | LocMast locMast = locMastService.selectById(locNo); |
| | | if (Cools.isEmpty(locMast)) { |
| | |
| | | LocDetl sqlParam = new LocDetl(); |
| | | sqlParam.setLocNo(paramLocDetl.getLocNo()); |
| | | sqlParam.setMatNo(paramLocDetl.getMatNo()); |
| | | sqlParam.setSupplier(paramLocDetl.getSupplier()); |
| | | LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); |
| | | if (null != one) locDetlDtos.add(new LocDetlDto(one, one.getQty())); |
| | | } |
| | |
| | | |
| | | @Override |
| | | @Transactional |
| | | //移库 |
| | | public void locMove(String sourceLocNo, String locNo, Long userId) { |
| | | LocMast sourceLoc = locMastService.selectById(sourceLocNo); |
| | | if (Cools.isEmpty(sourceLoc)){ |
| | |
| | | } |
| | | } |
| | | |
| | | Date now = new Date(); |
| | | // 保存工作档 |
| | | WrkMast wrkMast = new WrkMast(); |
| | | wrkMast.setWrkNo(workNo); |
| | | wrkMast.setIoTime(new Date()); |
| | | wrkMast.setIoTime(now); |
| | | wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID |
| | | wrkMast.setIoType(11); // 入出库状态: 11.库格移载 |
| | | wrkMast.setIoPri(10D); |
| | |
| | | wrkMast.setBarcode(sourceLoc.getBarcode()); // 托盘码 |
| | | wrkMast.setLinkMis("N"); |
| | | wrkMast.setAppeUser(userId); |
| | | wrkMast.setAppeTime(new Date()); |
| | | wrkMast.setAppeTime(now); |
| | | wrkMast.setModiUser(userId); |
| | | wrkMast.setModiTime(new Date()); |
| | | wrkMast.setModiTime(now); |
| | | boolean res = wrkMastService.insert(wrkMast); |
| | | if (!res) { |
| | | throw new CoolException("保存工作档失败"); |
| | |
| | | for (LocDetl locDetl : locDetls) { |
| | | WrkDetl wrkDetl = new WrkDetl(); |
| | | wrkDetl.setWrkNo(workNo); |
| | | wrkDetl.setIoTime(new Date()); |
| | | wrkDetl.setIoTime(now); |
| | | wrkDetl.setQty(locDetl.getQty()); |
| | | VersionUtils.setWrkDetl(wrkDetl, locDetl); // 版本控制 |
| | | wrkDetl.setAppeTime(new Date()); |
| | | wrkDetl.setAppeTime(now); |
| | | wrkDetl.setAppeUser(userId); |
| | | wrkDetl.setModiTime(new Date()); |
| | | wrkDetl.setModiTime(now); |
| | | wrkDetl.setModiUser(userId); |
| | | if (!wrkDetlService.insert(wrkDetl)) { |
| | | throw new CoolException("保存工作档明细失败"); |
| | |
| | | if (sourceLoc.getLocSts().equals("D") || sourceLoc.getLocSts().equals("F")) { |
| | | sourceLoc.setLocSts("R"); // R.出库预约 |
| | | sourceLoc.setModiUser(userId); |
| | | sourceLoc.setModiTime(new Date()); |
| | | sourceLoc.setModiTime(now); |
| | | if (!locMastService.updateById(sourceLoc)){ |
| | | throw new CoolException("更新源库位状态失败"); |
| | | } |
| | |
| | | // 修改目标库位状态 |
| | | if (loc.getLocSts().equals("O")) { |
| | | loc.setLocSts("S"); // S.入库预约 |
| | | loc.setModiTime(new Date()); |
| | | loc.setModiTime(now); |
| | | loc.setModiUser(userId); |
| | | if (!locMastService.updateById(loc)) { |
| | | throw new CoolException("更新目标库位状态失败"); |
| | |
| | | LocDetl sqlParam = new LocDetl(); |
| | | sqlParam.setLocNo(locMast.getLocNo()); |
| | | sqlParam.setMatNo(adjust.getMatNo()); |
| | | sqlParam.setSupplier(adjust.getSupplier()); |
| | | LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); |
| | | // 保存新库存明细 |
| | | if (Cools.isEmpty(one)) { |
| | |
| | | locDetl.setLocNo(locMast.getLocNo()); |
| | | locDetl.setQty(adjust.getCount()); // 数量 |
| | | VersionUtils.setLocDetl(locDetl, matCode); // 版本控制 |
| | | |
| | | if (Cools.isEmpty(adjust.getSupplier())){ |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd"); |
| | | locDetl.setSupplier(sdf.format(new Date())); |
| | | }else { |
| | | locDetl.setSupplier(adjust.getSupplier()); |
| | | } |
| | | |
| | | |
| | | locDetl.setModiUser(userId); // 操作人员信息 |
| | | locDetl.setModiTime(new Date()); |
| | | locDetl.setAppeUser(userId); |
| | | locDetl.setAppeTime(new Date()); |
| | | locDetl.setZpallet(param.getZpallet());//托盘号 |
| | | locDetl.setVendor(adjust.getVendor()); |
| | | locDetl.setSource(adjust.getSource()); |
| | | locDetl.setSupplier(adjust.getSupplier()); |
| | | locDetl.setQtyBox(matCode.getStr6()); |
| | | locDetl.setAllQty(matCode.getStr6()*adjust.getCount()); |
| | | locDetl.setAllWeight(matCode.getWeight()*adjust.getCount()+30); |
| | | locDetl.setStr3(matCode.getStr3()); |
| | | locDetl.setStr4(matCode.getStr4()); |
| | | locDetl.setStr5(matCode.getStr5()); |
| | | if (!locDetlService.insert(locDetl)) { |
| | | throw new CoolException("保存库存明细失败"); |
| | | } |
| | |
| | | throw new CoolException("清除库存明细失败"); |
| | | } |
| | | } else { |
| | | MatCode matCode = matCodeService.selectById(adjust.getMatNo()); |
| | | LocDetl sqlParam1 = new LocDetl(); |
| | | sqlParam1.setQty(adjust.getCount()); |
| | | sqlParam1.setSupplier(adjust.getSupplier()); |
| | | sqlParam1.setModiTime(new Date()); |
| | | sqlParam1.setModiUser(userId); |
| | | sqlParam1.setVendor(adjust.getVendor()); |
| | | sqlParam1.setSource(adjust.getSource()); |
| | | sqlParam1.setSupplier(adjust.getSupplier()); |
| | | sqlParam1.setQtyBox(matCode.getStr6()); |
| | | sqlParam1.setAllQty(matCode.getStr6()*adjust.getCount()); |
| | | sqlParam1.setAllWeight(matCode.getWeight()*adjust.getCount()+30); |
| | | sqlParam1.setStr5(matCode.getStr5()); |
| | | sqlParam1.setStr4(matCode.getStr4()); |
| | | sqlParam1.setStr3(matCode.getStr3()); |
| | | if (!locDetlService.update(sqlParam1, new EntityWrapper<LocDetl>() |
| | | .eq("loc_no", locMast.getLocNo()) |
| | | .eq("mat_no", adjust.getMatNo()))) { |
| | | .eq("mat_no", adjust.getMatNo()) |
| | | .eq("supplier",adjust.getSupplier()))) { |
| | | throw new CoolException("修改库存明细失败"); |
| | | } |
| | | } |
| | |
| | | locSts = "D"; |
| | | // 库位转移 ===>> D.空桶/空栈板 |
| | | } else if (wrkMast.getIoType() == 11) { |
| | | locSts = "F"; |
| | | if(wrkMast.getEmptyMk().equals("Y")){ |
| | | locSts = "D"; |
| | | }else { |
| | | locSts = "F"; |
| | | } |
| | | // 库位转移:目标库位 |
| | | LocMast locMast = locMastService.selectById(wrkMast.getLocNo()); |
| | | if (Cools.isEmpty(locMast)) { |
| | |
| | | |
| | | if (wrkMast.getIoType() != 10 && wrkMast.getIoType() != 110) { |
| | | // 保存工作明细档历史档 |
| | | if (!wrkDetlLogService.save(wrkMast.getWrkNo())) { |
| | | if (!wrkMast.getEmptyMk().equals("Y") && !wrkDetlLogService.save(wrkMast.getWrkNo())) { |
| | | throw new CoolException("保存工作明细历史档失败, workNo = " + wrkMast.getWrkNo()); |
| | | } |
| | | // 删除工作档明细 |
| | |
| | | if (!wrkMastLogService.save(wrkMast.getWrkNo())) { |
| | | throw new CoolException("保存工作主档历史档失败"); |
| | | } |
| | | // 拣、盘、并 作业站转换 |
| | | int stnNo = 0; |
| | | if (wrkMast.getIoType() == 103) { // 拣料出库 |
| | | if(wrkMast.getCrnNo() == 1) { |
| | | stnNo = 104; |
| | | }else if(wrkMast.getCrnNo() == 2) { |
| | | stnNo =204; |
| | | }else if(wrkMast.getCrnNo() == 3) { |
| | | stnNo = 304; |
| | | } |
| | | } else if(wrkMast.getIoType() == 107){ //盘点出库 |
| | | if(wrkMast.getCrnNo() == 1) { |
| | | stnNo = 101; |
| | | }else if(wrkMast.getCrnNo() == 2) { |
| | | stnNo =201; |
| | | }else if(wrkMast.getCrnNo() == 3) { |
| | | stnNo = 301; |
| | | } |
| | | } |
| | | if (stnNo == 0) { |
| | | log.error("{}号任务数据异常!", wrkMast.getWrkNo()); |
| | | throw new CoolException("再入库站点有误"); |
| | | } |
| | | // 获取目标站 |
| | | Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() |
| | | .eq("type_no", wrkMast.getIoType() - 50) |
| | | .eq("stn_no", wrkMast.getStaNo()) // 作业站点 = 拣料出库的目标站 |
| | | .eq("stn_no", stnNo) // 作业站点 = 拣料出库的目标站 |
| | | .eq("crn_no", wrkMast.getCrnNo()); // 堆垛机号 |
| | | StaDesc staDesc = staDescService.selectOne(wrapper); |
| | | if (Cools.isEmpty(staDesc)) { |