From 73507854f0618fe7f96c93aa64b870ff9c44664a Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 07 六月 2024 10:43:43 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderService.java              |    2 
 inspect-server/src/main/resources/mapper/InsSampleMapper.xml                           |   19 ++++--
 inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java             |    6 ++
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsReportServiceImpl.java    |   12 ++++
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |    2 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java     |   37 +++++++++++-
 inspect-server/src/main/resources/mapper/InsBushingMapper.xml                          |    7 +-
 inspect-server/src/main/resources/mapper/StandardTreeMapper.xml                        |    6 ++
 cnas-server/src/main/java/com/yuanchu/mom/pojo/StructureItemParameter.java             |   10 +++
 cnas-server/src/main/resources/mapper/StructureItemParameterMapper.xml                 |    4 +
 inspect-server/src/main/resources/mapper/InsProductMapper.xml                          |    3 
 inspect-server/src/main/java/com/yuanchu/mom/dto/SampleProductDto.java                 |    2 
 inspect-server/src/main/java/com/yuanchu/mom/pojo/InsSample.java                       |    5 +
 inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderController.java        |    3 
 inspect-server/pom.xml                                                                 |    4 
 inspect-server/src/main/java/com/yuanchu/mom/pojo/InsProduct.java                      |    6 +
 inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductMapper.java              |    2 
 17 files changed, 106 insertions(+), 24 deletions(-)

diff --git a/cnas-server/src/main/java/com/yuanchu/mom/pojo/StructureItemParameter.java b/cnas-server/src/main/java/com/yuanchu/mom/pojo/StructureItemParameter.java
index 9dd4be0..9d59109 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/pojo/StructureItemParameter.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/pojo/StructureItemParameter.java
@@ -67,7 +67,7 @@
     @ApiModelProperty(value = "璁¢噺鍗曚綅")
     private String unit;
 
-    @ValueTableShow(15)
+    @ValueTableShow(18)
     @ApiModelProperty(value = "璇曢獙鏂规硶")
     private String method;
 
@@ -129,5 +129,13 @@
     @ApiModelProperty(value = "瀛楀吀绫诲瀷")
     private String dic;
 
+    @ValueTableShow(16)
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被")
+    private String inspectionItemClass;
+
+    @ValueTableShow(17)
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被EN")
+    private String inspectionItemClassEn;
+
 }
 
diff --git a/cnas-server/src/main/resources/mapper/StructureItemParameterMapper.xml b/cnas-server/src/main/resources/mapper/StructureItemParameterMapper.xml
index 143913e..def7e4c 100644
--- a/cnas-server/src/main/resources/mapper/StructureItemParameterMapper.xml
+++ b/cnas-server/src/main/resources/mapper/StructureItemParameterMapper.xml
@@ -33,7 +33,9 @@
         template_id,
         son_laboratory,
         ask,
-        ask_tell
+        ask_tell,
+        inspection_item_class,
+        inspection_item_class_en
         from structure_item_parameter
         <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
             ${ew.customSqlSegment}
diff --git a/inspect-server/pom.xml b/inspect-server/pom.xml
index a968807..90e5c68 100644
--- a/inspect-server/pom.xml
+++ b/inspect-server/pom.xml
@@ -18,12 +18,12 @@
 
     <dependencies>
         <!--word杞琾df-->
+        <!--D:\JavaWork\center-lims-after\inspect-server\src\main\resources\lib-->
+        <!--mvn install:install-file -Dfile=aspose-words-15.12.0-jdk16.jar -DgroupId=com.aspose -DartifactId=aspose-words -Dversion=15.12.0 -Dpackaging=jar-->
         <dependency>
             <groupId>com.aspose</groupId>
             <artifactId>aspose-words</artifactId>
             <version>15.12.0</version>
-            <scope>system</scope>
-            <systemPath>${project.basedir}/src/main/resources/lib/aspose-words-15.12.0-jdk16.jar</systemPath>
         </dependency>
 
         <dependency>
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderController.java
index a038eac..5e98366 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderController.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderController.java
@@ -70,7 +70,8 @@
         JSONArray jsonArray = JSON.parseArray(map.get("list")+"");
         List<SampleProductDto> list = jsonArray.toJavaList(SampleProductDto.class);
         InsOrder insOrder = JSON.parseObject(JSON.toJSONString(map.get("insOrder")), InsOrder.class);
-        return Result.success(insOrderService.addInsOrder(list, insOrder));
+        List<List<Integer>> pairing = JSON.parseArray(map.get("pairing")+"");
+        return Result.success(insOrderService.addInsOrder(list, insOrder, pairing));
     }
 
     @ApiOperation(value = "鏌ヨ璁㈠崟鏈�闀块璁℃椂闂�")
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/dto/SampleProductDto.java b/inspect-server/src/main/java/com/yuanchu/mom/dto/SampleProductDto.java
index 55699f8..7dea47f 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/dto/SampleProductDto.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/dto/SampleProductDto.java
@@ -13,4 +13,6 @@
 
     private List<BushingDto> bushing;
 
+    private List<SampleProductDto> childSampleList;
+
 }
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductMapper.java
index 3728566..2fe546e 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductMapper.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductMapper.java
@@ -24,7 +24,7 @@
 
     int updateInspected(@Param("id") Integer id);
 
-    List<InsProduct> selectFiberInsProduct(List<Integer> ids);
+    List<InsProduct> selectFiberInsProduct(List<Integer> ids, String laboratory);
 }
 
 
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsProduct.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsProduct.java
index f0e1292..4b628b7 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsProduct.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsProduct.java
@@ -35,7 +35,11 @@
     /**
      * 妫�楠岄」鍒嗙被
      */
-    private String inspectionItemClassify;
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被")
+    private String inspectionItemClass;
+
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被EN")
+    private String inspectionItemClassEn;
 
     /**
      * 妫�楠岄」瀛愮被
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsSample.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsSample.java
index a43c2b0..b49c75c 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsSample.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsSample.java
@@ -109,4 +109,9 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private LocalDateTime updateTime;
 
+    private Integer parentId;
+
+    @TableField(select = false,exist = false)
+    private Integer num;
+
 }
\ No newline at end of file
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java
index 09d5f51..79c2d57 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java
@@ -182,4 +182,10 @@
     private String tree;
 
     private Integer structureItemParameterId;
+
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被")
+    private String inspectionItemClass;
+
+    @ApiModelProperty(value = "妫�楠岄」鍒嗙被EN")
+    private String inspectionItemClassEn;
 }
\ No newline at end of file
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderService.java
index b5da779..d5f7bc6 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderService.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderService.java
@@ -22,7 +22,7 @@
     //淇敼妫�楠屼笅鍗曟暟鎹�
     int upInsOrder(Integer orderId,Integer sampleId, String appointed, Integer userId);
 
-    int addInsOrder(List<SampleProductDto> list, InsOrder insOrder);
+    int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing);
 
     Map<String, Object> getInsOrder(Integer id);
 
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 652e4b3..f384d76 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
@@ -1113,7 +1113,7 @@
         List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));
         List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList());
         List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).isNull(InsProduct::getInsResult).isNull(InsProduct::getInsFiberId).isNull(InsProduct::getInsFibersId));
-        insProducts.addAll(insProductMapper.selectFiberInsProduct(ids));
+        insProducts.addAll(insProductMapper.selectFiberInsProduct(ids, laboratory));
         if (insProducts.size() > 0) {
             String str = "";
             int count = 0;
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
index cd585b3..09d59c6 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
@@ -2,6 +2,7 @@
 
 import cn.hutool.core.util.ObjectUtil;
 import cn.hutool.core.util.StrUtil;
+import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
@@ -26,6 +27,8 @@
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.Objects;
+import java.util.concurrent.atomic.AtomicInteger;
 import java.util.stream.Collectors;
 
 /**
@@ -127,20 +130,38 @@
 
     @Override
     @Transactional(rollbackFor = Exception.class)
-    public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder) {
+    public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) {
         insOrder.setState(0);
         String code = customMapper.selectById(insOrder.getCompanyId()).getCode2();
         insOrder.setEntrustCode(giveCode.giveCode("JCZX-" + code + "-", "ins_order", "-", "yyyyMMdd"));
         insOrderMapper.insert(insOrder);
+        AtomicInteger count = new AtomicInteger();
         list.forEach(a -> {
+            count.getAndIncrement();
             a.setId(null);
             a.setInsOrderId(insOrder.getId());
             if (StrUtil.isEmpty(a.getSampleCode())) {
-                a.setSampleCode(giveCode.giveCode("", "ins_sample", "", "yyMMdd"));
+                a.setSampleCode(giveCode.giveCode("", "ins_sample", "", "yyMMdd")+"-"+count.get());
             }
             insSampleMapper.insert(a);
             if (ObjectUtil.isNotEmpty(a.getInsProduct())) {
                 addInsProductMethod(a.getId(), a.getInsProduct(), null, 0);
+            }
+            if(ObjectUtil.isNotEmpty(a.getChildSampleList())){
+                for (SampleProductDto b : a.getChildSampleList()) {
+                    for (int i = 0; i < b.getNum(); i++) {
+                        b.setId(null);
+                        b.setInsOrderId(insOrder.getId());
+                        b.setParentId(a.getId());
+                        if (StrUtil.isEmpty(b.getSampleCode())) {
+                            b.setSampleCode(giveCode.giveCode("", "ins_sample", "", "yyMMdd"));
+                        }
+                        insSampleMapper.insert(b);
+                        if (ObjectUtil.isNotEmpty(b.getInsProduct())) {
+                            addInsProductMethod(b.getId(), b.getInsProduct(), null, 0);
+                        }
+                    }
+                }
             }
             if (ObjectUtil.isNotEmpty(a.getBushing())) {
                 for (BushingDto bushingDto : a.getBushing()) {
@@ -168,12 +189,22 @@
                 }
             }
         });
+        for (List<Integer> i : pairing) {
+            SampleProductDto sample = JSON.parseObject(JSON.toJSONString(list.get(i.get(0))), SampleProductDto.class);
+            sample.setSampleCode(list.get(i.get(0)-1).getSampleCode() + "/" +list.get(i.get(1)-1).getSampleCode());
+            sample.setId(null);
+            insSampleMapper.insert(sample);
+            InsProduct insProduct = sample.getInsProduct().stream().filter(a -> Objects.equals(a.getInspectionItem(), "鐔旀帴鎹熻��")).findFirst().get();
+            insProduct.setId(null);
+            insProduct.setInsSampleId(sample.getId());
+            insProductMapper.insert(insProduct);
+        }
         return insOrder.getId();
     }
 
     private void addInsProductMethod(Integer sampleId, List<InsProduct> productList, Integer id, Integer type) {
         for (InsProduct product : productList) {
-            if(product.getState()==1){
+            if(product.getState()==1 && !product.getInspectionItem().equals("鐔旀帴鎹熻��")){
                 switch (type){
                     case 1:
                         product.setInsFibersId(id);
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsReportServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsReportServiceImpl.java
index ea79da8..b8f0b85 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsReportServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsReportServiceImpl.java
@@ -223,6 +223,18 @@
         try {
             //鍑瘉 涓嶇劧鍒囨崲鍚庢湁姘村嵃
 //            InputStream inputStream = this.getClass().getResourceAsStream("/lib/license.xml");
+            /*String url;
+            try {
+                InputStream inputStream = this.getClass().getResourceAsStream("/lib/license.xml");
+                File file = File.createTempFile("temp", ".tmp");
+                OutputStream outputStream = new FileOutputStream(file);
+                IOUtils.copy(inputStream, outputStream);
+                url = file.getAbsolutePath();
+            } catch (FileNotFoundException e) {
+                throw new ErrorException("鎵句笉鍒版ā鏉挎枃浠�");
+            } catch (IOException e) {
+                throw new RuntimeException(e);
+            }*/
             InputStream is = new ClassPathResource("/lib/license.xml").getInputStream();
             License license = new License();
             license.setLicense(is);
diff --git a/inspect-server/src/main/resources/mapper/InsBushingMapper.xml b/inspect-server/src/main/resources/mapper/InsBushingMapper.xml
index a6f823a..014e4a4 100644
--- a/inspect-server/src/main/resources/mapper/InsBushingMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsBushingMapper.xml
@@ -17,7 +17,7 @@
     <select id="selectFibersByBushingId" resultMap="FibersDto">
         select
             fs.id, fs.code, fs.model, fs.standard, fs.num, fs.ins_bushing_id,
-            p.id pid, p.inspection_item, p.inspection_item_classify, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
+            p.id pid, p.inspection_item, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
             ipr.ins_value,ipr.com_value,ipr.equip_value,ipr.equip_name
         from ins_fibers fs
         left join ins_product p on p.ins_fibers_id = fs.id
@@ -27,7 +27,7 @@
 
     <select id="selectFiberByBushingId" resultMap="FiberDto">
         select f.id, f.bush_color, f.color, f.model, f.standard, f.ins_bushing_id,
-            p.id pid, p.inspection_item, p.inspection_item_classify, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
+            p.id pid, p.inspection_item, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
                ipr.ins_value,ipr.com_value,ipr.equip_value,ipr.equip_name
         from ins_fiber f
         left join ins_product p on p.ins_fiber_id = f.id
@@ -37,7 +37,7 @@
 
     <select id="selectFiberByFibersId" resultMap="FiberDto">
         select f.id, f.bush_color, f.color, f.model, f.standard, f.ins_bushing_id,
-               p.id pid, p.inspection_item, p.inspection_item_classify, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
+               p.id pid, p.inspection_item, p.inspection_item_subclass, p.factory, p.laboratory, p.sample_type, p.sample, p.model pmodel, p.son_laboratory, p.unit, p.price, p.man_hour, p.man_hour_group, p.inspection_item_type, p.inspection_value_type, p.device_group, p.checkout_number, p.section, p.value_type, p.method, p.man_day, p.bsm, p.ask, p.tell, p.`last_value`, p.ins_result, p.state, p.ins_sample_id, p.template_id, p.dic, p.method_s,
                ipr.ins_value,ipr.com_value,ipr.equip_value,ipr.equip_name
         from ins_fiber f
         left join ins_product p on p.ins_fiber_id = f.id
@@ -68,7 +68,6 @@
     <resultMap id="product" type="com.yuanchu.mom.pojo.InsProduct">
         <id property="id" column="pid" jdbcType="INTEGER"/>
         <result property="inspectionItem" column="inspection_item" jdbcType="VARCHAR"/>
-        <result property="inspectionItemClassify" column="inspection_item_classify" jdbcType="VARCHAR"/>
         <result property="inspectionItemSubclass" column="inspection_item_subclass" jdbcType="VARCHAR"/>
         <result property="factory" column="factory" jdbcType="VARCHAR"/>
         <result property="laboratory" column="laboratory" jdbcType="VARCHAR"/>
diff --git a/inspect-server/src/main/resources/mapper/InsProductMapper.xml b/inspect-server/src/main/resources/mapper/InsProductMapper.xml
index 792a419..b877783 100644
--- a/inspect-server/src/main/resources/mapper/InsProductMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsProductMapper.xml
@@ -92,8 +92,9 @@
         where state = 1
         and (ins_fibers_id is not null or ins_fiber_id is not null)
         and ins_result is null
+        and son_laboratory = #{laboratory}
         and ins_sample_id in
-        <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
+        <foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
             #{item}
         </foreach>
     </select>
diff --git a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
index bfe50f1..3d0ac72 100644
--- a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
@@ -114,7 +114,8 @@
                ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
+               inspection_item_class,
+               inspection_item_class_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
                ip.factory ip_factory,
@@ -163,7 +164,8 @@
                ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
+               inspection_item_class,
+               inspection_item_class_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
                ip.factory ip_factory,
@@ -220,9 +222,10 @@
                ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
                inspection_item_subclass,
                inspection_item_subclass_en,
+               inspection_item_class,
+               inspection_item_class_en,
                ip.factory ip_factory,
                ip.laboratory ip_laboratory,
                ip.sample_type ip_sample_type,
@@ -266,7 +269,6 @@
         select ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
                inspection_item_subclass,
                inspection_item_subclass_en,
                ip.factory ip_factory,
@@ -317,7 +319,8 @@
         select ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
+               inspection_item_class,
+               inspection_item_class_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
                ip.factory ip_factory,
@@ -366,7 +369,8 @@
         select ip.id ip_id,
                inspection_item,
                inspection_item_en,
-               inspection_item_classify,
+               inspection_item_class,
+               inspection_item_class_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
                ip.factory ip_factory,
@@ -440,9 +444,10 @@
         <id property="id" column="ip_id" jdbcType="INTEGER"/>
         <result property="inspectionItem" column="inspection_item" jdbcType="VARCHAR"/>
         <result property="inspectionItemEn" column="inspection_item_en" jdbcType="VARCHAR"/>
-        <result property="inspectionItemClassify" column="inspection_item_classify" jdbcType="VARCHAR"/>
         <result property="inspectionItemSubclass" column="inspection_item_subclass" jdbcType="VARCHAR"/>
         <result property="inspectionItemSubclassEn" column="inspection_item_subclass_en" jdbcType="VARCHAR"/>
+        <result property="inspectionItemClass" column="inspection_item_class" jdbcType="VARCHAR"/>
+        <result property="inspectionItemClassEn" column="inspection_item_class_en" jdbcType="VARCHAR"/>
         <result property="factory" column="ip_factory" jdbcType="VARCHAR"/>
         <result property="laboratory" column="ip_laboratory" jdbcType="VARCHAR"/>
         <result property="sampleType" column="ip_sample_type" jdbcType="VARCHAR"/>
diff --git a/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml b/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml
index ce4a5cc..982cc12 100644
--- a/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml
+++ b/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml
@@ -137,6 +137,8 @@
                inspection_item_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
+               inspection_item_class,
+               inspection_item_class_en,
                method,
                son_laboratory,
                unit,
@@ -174,6 +176,8 @@
                inspection_item_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
+               inspection_item_class,
+               inspection_item_class_en,
                method,
                son_laboratory,
                unit,
@@ -215,6 +219,8 @@
                inspection_item_en,
                inspection_item_subclass,
                inspection_item_subclass_en,
+               inspection_item_class,
+               inspection_item_class_en,
                method,
                son_laboratory,
                unit,

--
Gitblit v1.9.3