From 02e13964dd95077c5f515156bc0da5187f5c8cf3 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期三, 19 六月 2024 11:49:37 +0800 Subject: [PATCH] 工时分组排序+制单人字段 --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardProductListServiceImpl.java | 98 +++++++++++++++++++++++++++++++++--------------- 1 files changed, 67 insertions(+), 31 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 416e151..c740528 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 @@ -21,6 +21,8 @@ import java.math.BigDecimal; import java.util.*; import java.util.concurrent.CompletableFuture; +import java.util.regex.Matcher; +import java.util.regex.Pattern; import java.util.stream.Collectors; /** @@ -54,9 +56,23 @@ @Override public List<StandardProductList> selectStandardProductList(InsSample insSample) { String[] models = insSample.getModel().split("-(?=[^-]*$)");//鎷嗗垎鏈�鍚庝竴涓��-銆� - List<StandardProductList> list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()).eq(StandardProductList::getState, 1).eq(StandardProductList::getModel, models[0])); + 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 "));*/ if (list.size() == 0) { - list = standardProductListMapper.selectList(Wrappers.<StandardProductList>lambdaQuery().eq(StandardProductList::getStandardMethodListId, insSample.getStandardMethodListId()).eq(StandardProductList::getState, 1)); + 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() + .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 "));*/ } list = list.stream().filter(a -> { try { @@ -66,34 +82,25 @@ List<String> tells = JSON.parseArray(a.getTell(), String.class); List<String> manHours = JSON.parseArray(a.getManHour(), String.class); List<String> prices = JSON.parseArray(a.getPrice(), String.class); - boolean isIf = false; + boolean isIf; for (int i = 0; i < sections.size(); i++) { - if (sections.get(i).contains("&")) { - String[] split = sections.get(i).split("&"); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(split[0])) > -1 && new BigDecimal(models[1]).compareTo(new BigDecimal(split[1])) < 1; - } else if (sections.get(i).contains("鈮�") || sections.get(i).contains(">=")) { - String param = sections.get(i).replace("鈮�", "").replace(">=", ""); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(param)) > -1; - } else if (sections.get(i).contains("鈮�") || sections.get(i).contains("<=")) { - String param = sections.get(i).replace("鈮�", "").replace("<=", ""); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(param)) < 1; - } else if (sections.get(i).contains(">")) { - String param = sections.get(i).replace(">", ""); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(param)) > 0; - } else if (sections.get(i).contains("<")) { - String param = sections.get(i).replace("<", ""); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(param)) < 0; - } else if (sections.get(i).contains("=")) { - String param = sections.get(i).replace("=", ""); - isIf = new BigDecimal(models[1]).compareTo(new BigDecimal(param)) == 0; - } - if (isIf) { - a.setSection(sections.get(i)); - a.setAsk(asks.get(i)); - a.setTell(tells.get(i)); - a.setPrice(prices.get(i)); - a.setManHour(manHours.get(i)); + if (Objects.equals(a.getBsm(), "1")) { return true; + } else { + if (sections.get(i).contains("&")) { + String[] split = sections.get(i).split("&"); + isIf = getIsIf(split[0], models[1]) && getIsIf(split[1], models[1]); + } else { + isIf = getIsIf(sections.get(i), models[1]); + } + if (isIf) { + a.setSection(sections.get(i)); + a.setAsk(asks.get(i)); + a.setTell(tells.get(i)); + a.setPrice(prices.get(i)); + a.setManHour(manHours.get(i)); + return true; + } } } return false; @@ -104,6 +111,31 @@ return true; }).collect(Collectors.toList()); return list; + } + + private boolean getIsIf(String str, String model) { + Matcher matcher = Pattern.compile("\\d+(\\.\\d+)?").matcher(model); + String model2 = ""; + while (matcher.find()) { + model2 += matcher.group(); + } + if (str.contains("鈮�") || str.contains(">=")) { + String param = str.replace("鈮�", "").replace(">=", ""); + return new BigDecimal(model2).compareTo(new BigDecimal(param)) > -1; + } else if (str.contains("鈮�") || str.contains("<=")) { + String param = str.replace("鈮�", "").replace("<=", ""); + return new BigDecimal(model2).compareTo(new BigDecimal(param)) < 1; + } else if (str.contains(">") || str.contains("锛�")) { + String param = str.replace(">", "").replace("锛�", ""); + return new BigDecimal(model2).compareTo(new BigDecimal(param)) > 0; + } else if (str.contains("<") || str.contains("锛�")) { + String param = str.replace("<", "").replace("锛�", ""); + return new BigDecimal(model2).compareTo(new BigDecimal(param)) < 0; + } else if (str.contains("=")) { + String param = str.replace("=", ""); + return new BigDecimal(model2).compareTo(new BigDecimal(param)) == 0; + } + return false; } @Override @@ -149,7 +181,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()); @@ -177,7 +209,7 @@ if (sp.getTemplateId() != null && !sp.getTemplateId().equals("")) { pl.setTemplateId(sp.getTemplateId()); } - if(sp.getTree() != null && !sp.getTree().equals("")){ + if (sp.getTree() != null && !sp.getTree().equals("")) { pl.setTree(sp.getTree()); } break; @@ -187,7 +219,11 @@ if (page == 1) { Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); CompletableFuture.supplyAsync(() -> { - standardProductListMapper.delete(Wrappers.<StandardProductList>lambdaUpdate().eq(StandardProductList::getStandardMethodListId, id).like(StandardProductList::getTree, tree)); + 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]); -- Gitblit v1.9.3