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