From 56dfe0d4bf81262622a1919cceb2b039fd356209 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期二, 03 九月 2024 16:52:49 +0800 Subject: [PATCH] 代码提交 bug解决 --- ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java | 76 ++++++++++++++++++++++++------------- 1 files changed, 49 insertions(+), 27 deletions(-) diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java index d8864dd..51f38d3 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java @@ -57,35 +57,41 @@ @Override public PageDTO<ManagementimgSlVolumeProductionCkVO> getManagementimgSlVolumeProductionCkList(SlGoodsMaterialsSlVolumeProductionRkQuery slGoodsMaterialsSlVolumeProductionRkQuery) { - QueryWrapper<SlVolumeProductionRk> notNull = new QueryWrapper<SlVolumeProductionRk>() - .eq("del_flag", "0") - .isNotNull("new_add_time"); - if (slGoodsMaterialsSlVolumeProductionRkQuery.getId()!=null){ - notNull.eq("management_id", slGoodsMaterialsSlVolumeProductionRkQuery.getId()); - } + QueryWrapper<SlVolumeProductionRk> notNull = new QueryWrapper<SlVolumeProductionRk>() - // 查询该仓库的入库记录 - List<Long> collect = slVolumeProductionRkMapper.selectList(notNull - ).stream().map(SlVolumeProductionRk::getId).collect(Collectors.toList()); - Page<SlVolumeProductionCk> page = new Page<>(slGoodsMaterialsSlVolumeProductionRkQuery.getPageCurr(), slGoodsMaterialsSlVolumeProductionRkQuery.getPageSize()); - LambdaQueryWrapper< SlVolumeProductionCk> wrapper1= Wrappers.lambdaQuery(); - - wrapper1.eq(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); - wrapper1.eq(SlVolumeProductionCk::getDelFlag,0); - wrapper1.orderByDesc(SlVolumeProductionCk::getCreateTime); - if (!collect.isEmpty()){ - wrapper1.in(SlVolumeProductionCk::getRkId,collect); - } - Page<SlVolumeProductionCk> page2 = this.page(page, wrapper1); - PageDTO<ManagementimgSlVolumeProductionCkVO> SlGoodsShelfDTO = PageDTO.of(page2, ManagementimgSlVolumeProductionCkVO.class); - List<ManagementimgSlVolumeProductionCkVO> list2 = SlGoodsShelfDTO.getList(); - for(ManagementimgSlVolumeProductionCkVO list:list2) {{ - SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(list.getRkId()); - list.setRkNumber(slVolumeProductionRk.getRkNumber()); + .eq("del_flag", "0") + .isNotNull("new_add_time"); + if (slGoodsMaterialsSlVolumeProductionRkQuery.getId()!=null){ + notNull.eq("management_id", slGoodsMaterialsSlVolumeProductionRkQuery.getId()); } - } - return SlGoodsShelfDTO; + if (slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()!=null){ + notNull.eq("materials_id", slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); + } + if (slGoodsMaterialsSlVolumeProductionRkQuery.getStoreManagementNumber()!=null){ + notNull.eq("store_management_number", slGoodsMaterialsSlVolumeProductionRkQuery.getStoreManagementNumber()); + } + // 查询该仓库的入库记录 + List<Long> collect = slVolumeProductionRkMapper.selectList(notNull + ).stream().map(SlVolumeProductionRk::getId).collect(Collectors.toList()); + Page<SlVolumeProductionCk> page1 = new Page<>(slGoodsMaterialsSlVolumeProductionRkQuery.getPageCurr(), slGoodsMaterialsSlVolumeProductionRkQuery.getPageSize()); + LambdaQueryWrapper< SlVolumeProductionCk> wrapper2= Wrappers.lambdaQuery(); + wrapper2.like(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); + wrapper2.eq(SlVolumeProductionCk::getDelFlag,0); + wrapper2.isNotNull(SlVolumeProductionCk::getCkTime); + wrapper2.orderByDesc(SlVolumeProductionCk::getCreateTime); + if (!collect.isEmpty()){ + wrapper2.in(SlVolumeProductionCk::getRkId,collect); + } + Page<SlVolumeProductionCk> page3 = this.page(page1, wrapper2); + PageDTO<ManagementimgSlVolumeProductionCkVO> SlGoodsShelfDTO1 = PageDTO.of(page3, ManagementimgSlVolumeProductionCkVO.class); + List<ManagementimgSlVolumeProductionCkVO> list3 = SlGoodsShelfDTO1.getList(); + for(ManagementimgSlVolumeProductionCkVO list:list3) {{ + SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(list.getRkId()); + list.setRkNumber(slVolumeProductionRk.getRkNumber()); + } + } + return SlGoodsShelfDTO1; } @Override @@ -117,6 +123,11 @@ @Override public void addSlVolumeProductionCk(List<AddSlVolumeProductionCkDTO> addSlVolumeProductionCkDTO) { + List<SlVolumeProductionCk> list = this.lambdaQuery().eq(SlVolumeProductionCk::getCkglId, addSlVolumeProductionCkDTO.get(0).getCkgl_id()) + .eq(SlVolumeProductionCk::getDelFlag, "0").list(); + if (!list.isEmpty()){ + this.removeBatchByIds(list.stream().map(SlVolumeProductionCk::getId).collect(Collectors.toList())); + } for (AddSlVolumeProductionCkDTO m:addSlVolumeProductionCkDTO){ SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(m.getRkId()); SlVolumeProductionCk slVolumeProductionCk=new SlVolumeProductionCk(); @@ -222,6 +233,14 @@ PageDTO<InventoriesSuppliesInfoVO> slGoodsMaterialsVO = PageDTO.of(page2, InventoriesSuppliesInfoVO.class); for (SlVolumeProductionRk slVolumeProductionRk : list) { SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(slVolumeProductionRk.getMaterialsId()); + StringBuilder stringBuilder = new StringBuilder(); + for (String s : slVolumeProductionRk.getShelfId().split(",")) { + SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(s); + if (slGoodsShelf!=null){ + stringBuilder.append(slGoodsShelf.getGoodsShelfName()).append(","); + } + } + SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(slVolumeProductionRk.getShelfId()); if (slGoodsMaterials == null || slGoodsShelf == null){ continue; @@ -234,8 +253,11 @@ inventoriesSuppliesInfoVO.setRkModel(slVolumeProductionRk.getRkModel()); inventoriesSuppliesInfoVO.setRkId(slVolumeProductionRk.getId()); inventoriesSuppliesInfoVO.setZkNum(slVolumeProductionRk.getRepertoryZhai()); - inventoriesSuppliesInfoVO.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); inventoriesSuppliesInfoVO.setStoreManagementNumber(slVolumeProductionRk.getStoreManagementNumber()); + // 去除最后一位字符 + if (StringUtils.hasLength(stringBuilder.toString())){ + inventoriesSuppliesInfoVO.setGoodsShelfName(stringBuilder.substring(0, stringBuilder.length() - 1)); + } res.add(inventoriesSuppliesInfoVO); } slGoodsMaterialsVO.setList(res); -- Gitblit v1.7.1