| | |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(param.getDevpNo(), true); |
| | | // 检索库位 |
| | | LocTypeDto locTypeDto = new LocTypeDto(sourceStaNo); |
| | | List<String> matnrs = param.getList().stream().map(FullStoreParam.MatCodeStore::getMatnr).distinct().collect(Collectors.toList()); |
| | | |
| | | List<String> matnrs = new ArrayList<>(); |
| | | for (FullStoreParam.MatCodeStore matCodeStore : param.getList()) { |
| | | Mat mat = matService.selectByMatnr(matCodeStore.getMatnr()); |
| | | if (mat != null && !matnrs.contains(mat.getMaktx())) { |
| | | matnrs.add(mat.getMaktx()); |
| | | } |
| | | } |
| | | StartupDto dto = commonService.getLocNo(DEFAULT_ROW_NO_TYPE, 1, param.getDevpNo(), matnrs, locTypeDto, 0); |
| | | // 生成工作号 |
| | | int workNo = dto.getWorkNo(); |
| | |
| | | BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo, true); |
| | | // 检索库位 |
| | | List<Mat> mats = Collections.singletonList(mat); |
| | | List<String> matnrList = mats.stream().map(Mat::getMatnr).distinct().collect(Collectors.toList()); |
| | | List<String> matnrList = mats.stream().map(Mat::getMaktx).distinct().collect(Collectors.toList()); |
| | | StartupDto dto = commonService.getLocNo(1, 1, devpNo, matnrList, locTypeDto,0); |
| | | int workNo = dto.getWorkNo(); |
| | | Date now = new Date(); |
| | |
| | | throw new CoolException(CodeRes.NONE_DETL_900); |
| | | } |
| | | // 检索库位 |
| | | List<String> matnrList = wrkDetls.stream().map(WrkDetl::getMatnr).distinct().collect(Collectors.toList()); |
| | | List<String> matnrList = wrkDetls.stream().map(WrkDetl::getMaktx).distinct().collect(Collectors.toList()); |
| | | return commonService.getLocNo(1, ioType - 50, devpNo, matnrList, locTypeDto,0); // 库位号, 堆垛机,目标站 |
| | | } |
| | | |
| | |
| | | group by loc_no |
| | | ) dual on dual.loc_no = lm.loc_no |
| | | WHERE 1 = 1 |
| | | AND ld.matnr = #{matnr} |
| | | AND ld.maktx = #{matnr} |
| | | AND (lm.row1 >= #{start} AND lm.row1 <= #{end}) |
| | | AND (lm.loc_sts = 'F') |
| | | AND dual.count = 1 |