From 58c18ed858c0c3eaaa95b6abceceb1f1ad320fcd Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期二, 04 六月 2024 21:21:44 +0800
Subject: [PATCH] 部分功能小调整

---
 framework/src/main/java/com/yuanchu/mom/config/OpenFifer.java                          |    1 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsBushingServiceImpl.java   |   18 ++--
 inspect-server/src/main/java/com/yuanchu/mom/mapper/InsSampleMapper.java               |    7 +
 inspect-server/src/main/resources/mapper/InsSampleMapper.xml                           |  149 +++++++++++++++++++++++++++++++++++++
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |   44 ++++++++--
 inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java    |    8 ++
 inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java          |    5 +
 7 files changed, 212 insertions(+), 20 deletions(-)

diff --git a/framework/src/main/java/com/yuanchu/mom/config/OpenFifer.java b/framework/src/main/java/com/yuanchu/mom/config/OpenFifer.java
index 19d990e..a6f221b 100644
--- a/framework/src/main/java/com/yuanchu/mom/config/OpenFifer.java
+++ b/framework/src/main/java/com/yuanchu/mom/config/OpenFifer.java
@@ -59,6 +59,7 @@
 
     @Override
     protected void addInterceptors(InterceptorRegistry registry) {
+        // TODO: 2024/6/4 璁块棶swagger闇�鍏充笅闈㈡嫤鎴櫒
 //        registry.addInterceptor(fiferConfig).addPathPatterns("/**");
 //        registry.addInterceptor(powerConfig).addPathPatterns("/**");
         registry.addInterceptor(logConfig).addPathPatterns("/**");
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java
index 56df2da..0c9ee1d 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java
@@ -61,6 +61,14 @@
     public Result<?> doInsOrder(Integer id, String laboratory) {
         return Result.success(insOrderPlanService.doInsOrder(id, laboratory));
     }
+
+    @ValueAuth
+    @PostMapping("/getInsProduct")
+    @ApiOperation("鑾峰彇妫�楠岄」鐩拰妯℃澘鍐呭")
+    public Result<?> getInsProduct(Integer id, Integer type, String laboratory) {
+        return Result.success(insOrderPlanService.getInsProduct(id, type, laboratory));
+    }
+
     @ValueClassify("妫�楠屼换鍔�")
     @ApiOperation(value = "浠诲姟浜ゆ帴")
     @PostMapping("/upPlanUser")
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsSampleMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsSampleMapper.java
index 62edb36..54dc7ce 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsSampleMapper.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsSampleMapper.java
@@ -6,6 +6,7 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.yuanchu.mom.dto.InsOrderPlanDTO;
 import com.yuanchu.mom.dto.SampleProductDto;
+import com.yuanchu.mom.pojo.InsProduct;
 import com.yuanchu.mom.pojo.InsSample;
 import com.yuanchu.mom.vo.InsOrderPlanTaskSwitchVo;
 import com.yuanchu.mom.vo.InsOrderPlanVO;
@@ -31,6 +32,12 @@
     List<SampleProductDto> getInsOrderAndSample(Integer id, String laboratory);
 
     String getSampleEn(String sample);
+
+    List<InsProduct> getInsProduct1(Integer id, String laboratory);
+
+    List<InsProduct> getInsProduct2(Integer id);
+
+    List<InsProduct> getInsProduct3(Integer id);
 }
 
 
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java
index bf1f1e5..48957a1 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java
@@ -2,7 +2,9 @@
 
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.yuanchu.mom.dto.InsOrderPlanDTO;
+import com.yuanchu.mom.pojo.InsProduct;
 
+import java.util.List;
 import java.util.Map;
 
 /**
@@ -24,4 +26,7 @@
     int verifyPlan(Integer orderId, String laboratory, Integer type, String tell);
 
     int submitPlan(Integer orderId, String laboratory, Integer verifyUser);
+
+    List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory);
+
 }
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsBushingServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsBushingServiceImpl.java
index 232fe1c..df770da 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsBushingServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsBushingServiceImpl.java
@@ -6,7 +6,6 @@
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.yuanchu.mom.dto.BushingDto;
-import com.yuanchu.mom.dto.FiberDto;
 import com.yuanchu.mom.dto.FibersDto;
 import com.yuanchu.mom.mapper.InsBushingMapper;
 import com.yuanchu.mom.pojo.InsBushing;
@@ -44,17 +43,18 @@
             if(bushingDto.getFiber().size()==0){
                 bushingDto.setFibers(insBushingMapper.selectFibersByBushingId(insBushing.getId()));
                 for (FibersDto fibers : bushingDto.getFibers()) {
-                    getTemplateThing(fibers.getProductList());
+//                    getTemplateThing(fibers.getProductList());
                     fibers.setFiber(insBushingMapper.selectFiberByFibersId(fibers.getId()));
-                    for (FiberDto fiberDto : fibers.getFiber()) {
-                        getTemplateThing(fiberDto.getProductList());
-                    }
-                }
-            }else{
-                for (FiberDto fiberDto : bushingDto.getFiber()) {
-                    getTemplateThing(fiberDto.getProductList());
+//                    for (FiberDto fiberDto : fibers.getFiber()) {
+//                        getTemplateThing(fiberDto.getProductList());
+//                    }
                 }
             }
+//            else{
+//                for (FiberDto fiberDto : bushingDto.getFiber()) {
+//                    getTemplateThing(fiberDto.getProductList());
+//                }
+//            }
             bushingDtos.add(bushingDto);
         }
         return bushingDtos;
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
index fe95792..7e312bd 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
@@ -160,16 +160,37 @@
             insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, id).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, LocalDateTime.now()).set(InsOrderState::getInsState, 1));
         }
         Map<String, Object> map = insOrderService.getInsOrderAndSample(id, laboratory);
-        Set<Integer> set = new HashSet<>();
-        Map<Integer, String> map2 = new HashMap<>();
         List<SampleProductDto> list = JSON.parseArray(JSON.toJSONString(map.get("sampleProduct")), SampleProductDto.class);
         for (SampleProductDto samples : list) {
+//            Set<Integer> set = new HashSet<>();
+//            Map<Integer, String> map2 = new HashMap<>();
             if (BeanUtil.isEmpty(samples.getInsProduct())) continue;
             samples.setBushing(insBushingService.selectBushingBySampleId(samples.getId()));
-            getTemplateThing(set, map2, samples);
+//            getTemplateThing(set, map2, samples.getInsProduct());
         }
         map.put("sampleProduct", list);
         return map;
+    }
+
+    @Override
+    public List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory) {
+        List<InsProduct> insProducts = new ArrayList<>();
+        switch (type){
+            case 0:
+                insProducts = insSampleMapper.getInsProduct1(id, laboratory);
+                break;
+            case 1:
+                insProducts = insSampleMapper.getInsProduct2(id);
+                break;
+            case 2:
+                insProducts = insSampleMapper.getInsProduct3(id);
+                break;
+        }
+        Set<Integer> set = new HashSet<>();
+        Map<Integer, String> map2 = new HashMap<>();
+        if (BeanUtil.isEmpty(insProducts)) return null;
+        getTemplateThing(set, map2, insProducts);
+        return insProducts;
     }
 
     @Override
@@ -361,7 +382,7 @@
             }
             InsOrder insOrder = insOrderMapper.selectById(orderId);
             Map<String, String> user = insProductMapper.selectUserById(insOrder.getUserId());
-            List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId2(orderId);
+            List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId(orderId);
             InsReport insReport = new InsReport();
             insReport.setCode(insOrder.getEntrustCode());
             insReport.setInsOrderId(orderId);
@@ -381,7 +402,7 @@
                 models.add(a.getModel());
                 standardMethod.add(baseMapper.getStandardMethodCode(a.getStandardMethodListId()));
                 Set<String> templateSet = new HashSet<>();
-                getTemplateThing(set, map2, a);
+                getTemplateThing(set, map2, a.getInsProduct());
                 for (InsProduct b : a.getInsProduct()) {
                     if (b.getInsProductResult() != null) {
                         List<JSONObject> jsonObjects = JSON.parseArray(b.getInsProductResult().getEquipValue(), JSONObject.class);
@@ -399,8 +420,8 @@
                     }
                     templateSet.add(JSON.toJSONString(b.getTemplate()));
                 }
-                AtomicInteger index = new AtomicInteger();
                 templateSet.forEach(tem -> {
+                    AtomicInteger index = new AtomicInteger();
                     Set<Integer> set2 = new HashSet<>();
                     List<RowRenderData> rows = new ArrayList<>();
                     List<TextRenderData> text = new ArrayList<>();
@@ -436,6 +457,8 @@
                     List<JSONObject> temp = JSON.parseArray(JSON.toJSONString(excelDtos), JSONObject.class);
                     Map<String, InsProduct> pMap = new HashMap<>();
                     Set<String> delRSet = new HashSet<>();
+                    delRSet.add("0");
+                    delRSet.add("1");
                     for (JSONObject jo1 : temp) {
                         JSONObject v = JSON.parseObject(JSON.toJSONString(jo1.get("v")));
                         if (Integer.parseInt(jo1.get("c") + "") > 9) {
@@ -575,7 +598,8 @@
                             textRenderData.setText(textRenderData.getText() + "鈭�" + jo1.get("mc"));
                         }
                         Style style = new Style();
-                        style.setFontFamily(v.get("ff") == null ? "寰蒋闆呴粦" : v.get("ff") + "");
+//                        style.setFontFamily(v.get("ff") == null ? "瀹嬩綋" : v.get("ff") + "");
+                        style.setFontFamily("瀹嬩綋");
                         if (!((v.get("fc") + "").indexOf("rgb") > -1)) {
                             style.setColor(v.get("fc") == null ? "000000" : (v.get("fc") + "").replace("#", ""));
                         } else {
@@ -760,8 +784,6 @@
                             }
                         }
                     }
-                    maps.forEach((k, v) -> {
-                    });
                     List<String> list = new ArrayList<>();
                     for (String s : maps.keySet()) {
                         list.add(s);
@@ -790,8 +812,8 @@
         return 1;
     }
 
-    private void getTemplateThing(Set<Integer> set, Map<Integer, String> map2, SampleProductDto a) {
-        for (InsProduct product : a.getInsProduct()) {
+    private void getTemplateThing(Set<Integer> set, Map<Integer, String> map2, List<InsProduct> insProducts) {
+        for (InsProduct product : insProducts) {
             if (product.getTemplateId() == null) {
                 product.setTemplate(new ArrayList<>());
                 continue;
diff --git a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
index 50ed614..bfe50f1 100644
--- a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
@@ -262,6 +262,155 @@
         where ins_order_id = #{id}
           and state = 1
     </select>
+    <select id="getInsProduct1" resultMap="product">
+        select ip.id ip_id,
+               inspection_item,
+               inspection_item_en,
+               inspection_item_classify,
+               inspection_item_subclass,
+               inspection_item_subclass_en,
+               ip.factory ip_factory,
+               ip.laboratory ip_laboratory,
+               ip.sample_type ip_sample_type,
+               ip.sample ip_sample,
+               ip.model ip_model,
+               son_laboratory,
+               ip.unit ip_unit,
+               price,
+               man_hour,
+               man_hour_group,
+               inspection_item_type,
+               inspection_value_type,
+               device_group,
+               checkout_number,
+               section,
+               value_type,
+               method,
+               man_day,
+               bsm,
+               ask,
+               `last_value`,
+               ip.ins_result ip_ins_result,
+               state,
+               ins_sample_id,
+               ip.create_user ip_create_user,
+               ip.update_user ip_update_user,
+               ip.create_time ip_create_time,
+               ip.update_time ip_update_time,
+               template_id,
+               ipr.ins_value,
+               ipr.com_value,
+               ipr.equip_value,
+               ipr.equip_name,
+               ip.method_s,
+               ip.tell,
+               ip.dic
+        from ins_product ip
+        left join ins_product_result ipr on ip.id = ipr.ins_product_id
+        where ins_sample_id = #{id}
+          and state = 1
+          and ip.son_laboratory = #{laboratory}
+          and ins_fiber_id is null
+          and ins_fibers_id is null
+    </select>
+    <select id="getInsProduct2" resultMap="product">
+        select ip.id ip_id,
+               inspection_item,
+               inspection_item_en,
+               inspection_item_classify,
+               inspection_item_subclass,
+               inspection_item_subclass_en,
+               ip.factory ip_factory,
+               ip.laboratory ip_laboratory,
+               ip.sample_type ip_sample_type,
+               ip.sample ip_sample,
+               ip.model ip_model,
+               son_laboratory,
+               ip.unit ip_unit,
+               price,
+               man_hour,
+               man_hour_group,
+               inspection_item_type,
+               inspection_value_type,
+               device_group,
+               checkout_number,
+               section,
+               value_type,
+               method,
+               man_day,
+               bsm,
+               ask,
+               `last_value`,
+               ip.ins_result ip_ins_result,
+               state,
+               ins_sample_id,
+               ip.create_user ip_create_user,
+               ip.update_user ip_update_user,
+               ip.create_time ip_create_time,
+               ip.update_time ip_update_time,
+               template_id,
+               ipr.ins_value,
+               ipr.com_value,
+               ipr.equip_value,
+               ipr.equip_name,
+               ip.method_s,
+               ip.tell,
+               ip.dic
+        from ins_product ip
+        left join ins_product_result ipr on ip.id = ipr.ins_product_id
+        where ins_fibers_id = #{id}
+          and state = 1
+          and ins_fiber_id is null
+    </select>
+    <select id="getInsProduct3" resultMap="product">
+        select ip.id ip_id,
+               inspection_item,
+               inspection_item_en,
+               inspection_item_classify,
+               inspection_item_subclass,
+               inspection_item_subclass_en,
+               ip.factory ip_factory,
+               ip.laboratory ip_laboratory,
+               ip.sample_type ip_sample_type,
+               ip.sample ip_sample,
+               ip.model ip_model,
+               son_laboratory,
+               ip.unit ip_unit,
+               price,
+               man_hour,
+               man_hour_group,
+               inspection_item_type,
+               inspection_value_type,
+               device_group,
+               checkout_number,
+               section,
+               value_type,
+               method,
+               man_day,
+               bsm,
+               ask,
+               `last_value`,
+               ip.ins_result ip_ins_result,
+               state,
+               ins_sample_id,
+               ip.create_user ip_create_user,
+               ip.update_user ip_update_user,
+               ip.create_time ip_create_time,
+               ip.update_time ip_update_time,
+               template_id,
+               ipr.ins_value,
+               ipr.com_value,
+               ipr.equip_value,
+               ipr.equip_name,
+               ip.method_s,
+               ip.tell,
+               ip.dic
+        from ins_product ip
+        left join ins_product_result ipr on ip.id = ipr.ins_product_id
+        where ins_fiber_id = #{id}
+          and state = 1
+          and ins_fibers_id is null
+    </select>
 
     <resultMap id="sampleDto" type="com.yuanchu.mom.dto.SampleProductDto">
         <id property="id" column="id" jdbcType="INTEGER"/>

--
Gitblit v1.9.3