From fc7e4d3a79dc5808cddc864e1d235fea92c4f627 Mon Sep 17 00:00:00 2001 From: value <z1292839451@163.com> Date: 星期日, 23 六月 2024 23:43:57 +0800 Subject: [PATCH] bug修复 --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java | 156 ++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 144 insertions(+), 12 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java index c740528..66ca4aa 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java @@ -8,6 +8,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.mom.common.GetLook; +import com.yuanchu.mom.dto.ProductDto; import com.yuanchu.mom.mapper.StandardProductListMapper; import com.yuanchu.mom.mapper.StandardTreeMapper; import com.yuanchu.mom.pojo.InsSample; @@ -56,23 +57,17 @@ @Override public List<StandardProductList> selectStandardProductList(InsSample insSample) { String[] models = insSample.getModel().split("-(?=[^-]*$)");//鎷嗗垎鏈�鍚庝竴涓��-銆� - List<StandardProductList> list = standardProductListMapper.selectDetail(insSample.getStandardMethodListId(), 1, models[0]); - /* List<StandardProductList> list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery() - .eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()) - .eq(StandardProductList::getState, 1) - .eq(StandardProductList::getModel, models[0]) - .apply("ORDER BY case when man_hour_group is NULL then 1 else 0 end, CAST(man_hour_group as UNSIGNED), man_hour_group REGEXP '^[0-9]', id asc "));*/ + String[] factorys = insSample.getFactory().split(" - "); + List<StandardProductList> list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()).eq(StandardProductList::getState, 1).eq(StandardProductList::getModel, models[0]).eq(StandardProductList::getSampleType, factorys[2])); if (list.size() == 0) { if (Objects.equals(insSample.getFactory(), "") || insSample.getFactory() == null) { return null; } String[] split = insSample.getFactory().split(" - "); - list = standardProductListMapper.selectDetail2(insSample.getStandardMethodListId(), 1, split[0] + " - " + split[1] + " - " + split[2] + " - " + split[3]); - /*list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery() + list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery() .eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()) .eq(StandardProductList::getState, 1) - .like(StandardProductList::getTree, split[0] + " - " + split[1] + " - " + split[2] + " - " + split[3]) - .apply("ORDER BY case when man_hour_group is NULL then 1 else 0 end, CAST(man_hour_group as UNSIGNED), man_hour_group REGEXP '^[0-9]', id asc "));*/ + .like(StandardProductList::getTree, split[0] + " - " + split[1] + " - " + split[2] + " - " + split[3])); } list = list.stream().filter(a -> { try { @@ -140,7 +135,7 @@ @Override public Map<String, Object> selectStandardProductListByMethodId(Integer id, String tree, Integer page) { - String[] trees = tree.split(" - "); + /*String[] trees = tree.split(" - "); List<StandardProductList> list = new ArrayList<>(); if (trees.length == 3) { List<StandardTree> treeList = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2])); @@ -181,7 +176,7 @@ for (StandardProductList sp : standardProductLists) { for (StandardProductList pl : list) { if (Objects.equals(sp.getInspectionItem(), pl.getInspectionItem()) - && Objects.equals((sp.getInspectionItemSubclass() == null) ? "" : sp.getInspectionItemSubclass(), pl.getInspectionItemSubclass() == null ? "" : pl.getInspectionItemSubclass()) + && Objects.equals((sp.getInspectionItemSubclass() == null)? "" : sp.getInspectionItemSubclass(), pl.getInspectionItemSubclass() == null ? "" : pl.getInspectionItemSubclass()) && Objects.equals(sp.getModel(), pl.getModel()) && Objects.equals(sp.getStructureItemParameterId(), pl.getStructureItemParameterId())) { pl.setId(sp.getId()); @@ -209,6 +204,143 @@ if (sp.getTemplateId() != null && !sp.getTemplateId().equals("")) { pl.setTemplateId(sp.getTemplateId()); } + if(sp.getTree() != null && !sp.getTree().equals("")){ + pl.setTree(sp.getTree()); + } + break; + } + } + } + if (page == 1) { + Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); + CompletableFuture.supplyAsync(() -> { + if(trees.length == 5){ + standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate().eq(StandardProductList::getStandardMethodListId, id).eq(StandardProductList::getTree, tree)); + }else{ + standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate().eq(StandardProductList::getStandardMethodListId, id).like(StandardProductList::getTree, tree)); + } + standardProductListService2.saveBatch(list.stream().map(a -> { + a.setFactory(trees[0]); + a.setLaboratory(trees[1]); + a.setSampleType(trees[2]); + a.setCreateUser(userId); + a.setUpdateUser(userId); + a.setStandardMethodListId(id); + return a; + }).collect(Collectors.toList())); + return null; + }).thenAccept(res -> { + }).exceptionally(e -> { + e.printStackTrace(); + return null; + }); + } + Map<String, Object> map = new HashMap<>(); + try { + map.put("productList", list.subList((page - 1) * 50, page * 50)); + } catch (IndexOutOfBoundsException e) { + map.put("productList", list.subList((page - 1) * 50, list.size())); + } + map.put("total", list.size()); + return map;*/ + String[] trees = tree.split(" - "); + List<StandardProductList> list = new ArrayList<>(); + if (trees.length == 3) { + List<StandardTree> treeList = new ArrayList<>(); + StandardTree standardTree = new StandardTree(); + standardTree.setFactory(trees[0]); + standardTree.setLaboratory(trees[1]); + standardTree.setSampleType(trees[2]); + List<ProductDto> pList = standardTreeMapper.selectPList(trees[2]); + if (pList.size() == 0 || pList.get(0) == null) { + List<StandardTree> treeList1 = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2])); + if (treeList1.size() == 0) { + treeList.add(standardTree); + } else { + treeList.addAll(treeList1); + } + } else { + for (ProductDto p : pList) { + standardTree.setSample(p.getName()); + List<StandardTree> treeList1 = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, p.getName())); + if (treeList1.size() == 0) { + treeList.add(JSON.parseObject(JSON.toJSONString(standardTree), StandardTree.class)); + } else { + treeList.addAll(treeList1); + } + } + } + for (StandardTree standardTree2 : treeList) { + String tree2 = trees[0] + " - " + trees[1] + " - " + trees[2] + " - " + standardTree2.getSample() + " - " + standardTree2.getModel(); + /*if(standardTree2.getSample()!=null){ + tree2 += trees[0] + " - " + trees[1] + " - " + trees[2] + " - " + standardTree2.getSample(); + } + if(standardTree2.getModel()!=null){ + if(standardTree2.getSample()!=null){ + tree2 += standardTree2.getModel(); + }else{ + tree2 += trees[0] + " - " + trees[1] + " - " + trees[2] + " - " + null + " - " + standardTree2.getModel(); + } + }*/ + list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", standardTree2.getSample(), standardTree2.getModel(), tree2)); + list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + standardTree2.getSample() + "\"", standardTree2.getSample(), standardTree2.getModel(), tree2)); + } + } else if (trees.length == 4) { + List<StandardTree> treeList = standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery().eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3])); + if (treeList.size() == 0) { + StandardTree standardTree = new StandardTree(); + standardTree.setFactory(trees[0]); + standardTree.setLaboratory(trees[1]); + standardTree.setSampleType(trees[2]); + standardTree.setSample(trees[3]); + treeList.add(standardTree); + } + for (StandardTree standardTree : treeList) { + String str = tree + " - " + standardTree.getModel(); + list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", standardTree.getSample(), standardTree.getModel(), str)); + list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + trees[3] + "\"", standardTree.getSample(), standardTree.getModel(), str)); + } + } else { + list.addAll(standardTreeMapper.selectStandardProductListByTree("\"" + trees[2] + "\"", trees[3].equals("null") ? null : trees[3], trees[4], tree)); + list.addAll(standardTreeMapper.selectStandardProductListByTree2("\"" + trees[2] + "\",\"" + trees[3] + "\"", trees[3].equals("null") ? null : trees[3], trees[4], tree)); + } + for (StandardProductList productList : list) { + productList.setId(IdWorker.getId()); + } + List<StandardProductList> standardProductLists = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, id).like(StandardProductList::getTree, tree)); + for (StandardProductList sp : standardProductLists) { + for (StandardProductList pl : list) { + if (Objects.equals(sp.getInspectionItem(), pl.getInspectionItem()) + && Objects.equals((sp.getInspectionItemSubclass() == null) ? "" : sp.getInspectionItemSubclass(), pl.getInspectionItemSubclass() == null ? "" : pl.getInspectionItemSubclass()) +// && Objects.equals(sp.getSample(), pl.getSample()) + && Objects.equals(sp.getModel(), pl.getModel()) + && sp.getTree().indexOf(pl.getSample()==null?"null":pl.getSample())>-1 + && Objects.equals(sp.getStructureItemParameterId(), pl.getStructureItemParameterId())) { + pl.setId(sp.getId()); + if (sp.getState() != null && !sp.getState().equals("")) { + pl.setState(sp.getState()); + } else { + pl.setState(id == 0 ? 1 : 0); + } + pl.setMethodS(sp.getMethodS()); + if (sp.getAsk() != null && !sp.getAsk().equals("")) { + pl.setAsk(sp.getAsk()); + } + if (sp.getTell() != null && !sp.getTell().equals("")) { + pl.setTell(sp.getTell()); + } + if (sp.getPrice() != null && !sp.getPrice().equals("")) { + pl.setPrice(sp.getPrice()); + } + if (sp.getManHour() != null && !sp.getManHour().equals("")) { + pl.setManHour(sp.getManHour()); + } + if (sp.getSection() != null && !sp.getSection().equals("")) { + pl.setSection(sp.getSection()); + } + if (sp.getTemplateId() != null && !sp.getTemplateId().equals("")) { + pl.setTemplateId(sp.getTemplateId()); + } if (sp.getTree() != null && !sp.getTree().equals("")) { pl.setTree(sp.getTree()); } -- Gitblit v1.9.3