From 675af262e4e511c9a240d9c1fa3332d1dc8d0c42 Mon Sep 17 00:00:00 2001
From: zouyu <2723363702@qq.com>
Date: 星期二, 13 一月 2026 13:15:37 +0800
Subject: [PATCH] 1.工时管理:辅助工时编辑后录入人姓名变成编辑人问题修复 2.外购下单:标签打印功能调整 3.人员:培训计划导入导出添加【培训大类】字段 4.业务管理:报检新增【物料属性】字段选择,其余页面添加【物料属性】查询条件以及数据回显

---
 inspect-server/src/main/java/com/ruoyi/inspect/dto/ReportPageDto.java                                        |    3 +
 inspect-server/src/main/java/com/ruoyi/inspect/service/InsOrderService.java                                  |    8 ++
 inspect-server/src/main/java/com/ruoyi/inspect/vo/InsOrderPlanVO.java                                        |    3 +
 inspect-server/src/main/resources/mapper/InsSampleMapper.xml                                                 |    3 
 inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java                                    |    8 ++
 cnas-personnel/src/main/java/com/ruoyi/personnel/excel/PersonTrainingDetailedUpload.java                     |    3 +
 cnas-personnel/src/main/java/com/ruoyi/personnel/pojo/PersonTrainingDetailed.java                            |    3 +
 performance-server/src/main/java/com/ruoyi/performance/service/impl/AuxiliaryWorkingHoursDayServiceImpl.java |    4 
 cnas-personnel/src/main/resources/static/person-training.docx                                                |    0 
 inspect-server/src/main/java/com/ruoyi/inspect/service/impl/RawMaterialOrderServiceImpl.java                 |    6 +
 basic-server/src/main/java/com/ruoyi/basic/pojo/IfsInventoryQuantity.java                                    |    3 +
 inspect-server/src/main/java/com/ruoyi/inspect/dto/InsOrderPlanDTO.java                                      |    3 
 inspect-server/src/main/java/com/ruoyi/inspect/controller/InsOrderController.java                            |    8 ++
 inspect-server/src/main/java/com/ruoyi/inspect/controller/RawMaterialOrderController.java                    |    3 
 inspect-server/src/main/java/com/ruoyi/inspect/dto/OrderSplitDTO.java                                        |    4 +
 inspect-server/src/main/resources/mapper/InsOrderMapper.xml                                                  |   39 ++++++++++++
 inspect-server/src/main/resources/mapper/InsReportMapper.xml                                                 |    1 
 inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java                         |    6 ++
 basic-server/src/main/java/com/ruoyi/basic/dto/InventoryDetailDTO.java                                       |   52 +++++++++++++++++
 inspect-server/src/main/java/com/ruoyi/inspect/service/RawMaterialOrderService.java                          |    2 
 20 files changed, 153 insertions(+), 9 deletions(-)

diff --git a/basic-server/src/main/java/com/ruoyi/basic/dto/InventoryDetailDTO.java b/basic-server/src/main/java/com/ruoyi/basic/dto/InventoryDetailDTO.java
new file mode 100644
index 0000000..b939c06
--- /dev/null
+++ b/basic-server/src/main/java/com/ruoyi/basic/dto/InventoryDetailDTO.java
@@ -0,0 +1,52 @@
+package com.ruoyi.basic.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.Date;
+
+@Data
+public class InventoryDetailDTO {
+    // 鏉ヨ嚜 ifs_inventory_quantity
+    @ApiModelProperty(value = "ifs_inventory_quantityID")
+    private Integer id;
+
+    @ApiModelProperty(value = "闆朵欢鎻忚堪")
+    private String partDesc;
+
+    @ApiModelProperty(value = "SN鍙�")
+    private String lotBatchNo;
+
+    @ApiModelProperty(value = "闆朵欢鍙�")
+    private String partNo;
+
+    // 鏉ヨ嚜 ifs_part_props_record
+
+    @ApiModelProperty(value = "缁濈紭棰滆壊")
+    private String insulationColor;
+
+    @ApiModelProperty(value = "鎶ゅ棰滆壊")
+    private String outerColor;
+
+    @ApiModelProperty(value = "杞藉叿缂栧彿")
+    private String drumNo;
+
+    @ApiModelProperty(value = "璧峰绫虫爣")
+    private String startMeterMark;
+
+    @ApiModelProperty(value = "鎴绫虫爣")
+    private String endMeterMark;
+
+    // 鏉ヨ嚜 ins_order
+
+    @ApiModelProperty(value = "鍏ュ簱鏃堕棿")
+    private Date updateTime;
+
+    @ApiModelProperty(value = "妫�娴嬬粨璁�")
+    private Integer insState;
+
+    // 閫昏緫璁$畻瀛楁锛氭楠屼汉 (COALESCE 鍚庣殑缁撴灉)
+
+    @ApiModelProperty(value = "妫�娴嬩汉鍛�")
+    private String inspectorName;
+}
\ No newline at end of file
diff --git a/basic-server/src/main/java/com/ruoyi/basic/pojo/IfsInventoryQuantity.java b/basic-server/src/main/java/com/ruoyi/basic/pojo/IfsInventoryQuantity.java
index 1228374..a391788 100644
--- a/basic-server/src/main/java/com/ruoyi/basic/pojo/IfsInventoryQuantity.java
+++ b/basic-server/src/main/java/com/ruoyi/basic/pojo/IfsInventoryQuantity.java
@@ -40,6 +40,9 @@
     @ApiModelProperty("璁㈠崟绫诲瀷(01raw:鍘熸潗鏂欙紝02wg:澶栬喘鎴愬搧)")
     private String orderType;
 
+    @ApiModelProperty("鐗╂枡灞炴�э紝鐢ㄤ簬鍖哄垎閾溿�侀摑瀵间綋绛夐浂浠�")
+    private String materialProp;
+
     @ExcelProperty(index = 3, value = "闆朵欢鍙�")
     @ApiModelProperty("闆朵欢鍙�")
     private String partNo;
diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/excel/PersonTrainingDetailedUpload.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/excel/PersonTrainingDetailedUpload.java
index 7bc5876..f5dd8b3 100644
--- a/cnas-personnel/src/main/java/com/ruoyi/personnel/excel/PersonTrainingDetailedUpload.java
+++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/excel/PersonTrainingDetailedUpload.java
@@ -6,6 +6,9 @@
 @Data
 public class PersonTrainingDetailedUpload {
 
+    @ExcelProperty("鍩硅澶х被")
+    private String trainingCategory;
+
     @ExcelProperty("鍩硅鐩爣")
     private String trainingObjectives;
 
diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/pojo/PersonTrainingDetailed.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/pojo/PersonTrainingDetailed.java
index 81b5338..b5b7c41 100644
--- a/cnas-personnel/src/main/java/com/ruoyi/personnel/pojo/PersonTrainingDetailed.java
+++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/pojo/PersonTrainingDetailed.java
@@ -30,6 +30,9 @@
     @TableId(value = "id", type = IdType.AUTO)
     private Integer id;
 
+    @ApiModelProperty("鍩硅澶х被")
+    private String trainingCategory;
+
     @ApiModelProperty("鍩硅鐩爣")
     private String trainingObjectives;
 
diff --git a/cnas-personnel/src/main/resources/static/person-training.docx b/cnas-personnel/src/main/resources/static/person-training.docx
index 0a6bf24..ab13ad6 100644
--- a/cnas-personnel/src/main/resources/static/person-training.docx
+++ b/cnas-personnel/src/main/resources/static/person-training.docx
Binary files differ
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/controller/InsOrderController.java b/inspect-server/src/main/java/com/ruoyi/inspect/controller/InsOrderController.java
index e610e2e..d11fa34 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/controller/InsOrderController.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/controller/InsOrderController.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.basic.dto.InventoryDetailDTO;
 import com.ruoyi.basic.mapper.IfsInventoryQuantityMapper;
 import com.ruoyi.basic.pojo.IfsInventoryQuantity;
 import com.ruoyi.basic.pojo.StandardProductList;
@@ -56,6 +57,13 @@
         return Result.success(insOrderService.selectInsOrderParameter(page, sampleOrderDto));
     }
 
+    @ApiOperation(value = "澶栬喘涓嬪崟鎴愬搧鏍囩鎵撳嵃")
+    @PostMapping("/labelOutsideOrderPrinting")
+    public Result<List<InventoryDetailDTO>> labelOutsideOrderPrinting(@RequestBody Map<String, Object> param) {
+        List<Integer> ids = (List<Integer>) param.get("ids");
+        return Result.success(insOrderService.labelOutsideOrderPrinting(ids));
+    }
+
     //鐢ㄤ簬妫�楠屼笅鍗曞尯鍒煡鐪嬫墍鏈夎鍗曞拰鍙煡鐪嬪悓涓�涓鎵樺崟浣嶇殑璁㈠崟
     @ApiOperation(value = "鏌ヨ鎵�鏈夋楠屽崟")
     @GetMapping("/selectAllInsOrderParameter")
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/controller/RawMaterialOrderController.java b/inspect-server/src/main/java/com/ruoyi/inspect/controller/RawMaterialOrderController.java
index 85b6577..1e89857 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/controller/RawMaterialOrderController.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/controller/RawMaterialOrderController.java
@@ -106,10 +106,11 @@
     public Result<?> inspectionReport(@RequestBody Map<String, Object> param) {
         List<Long> ids = (List<Long>) param.get("ids");
         String orderType = Objects.nonNull(param.get("orderType"))?param.get("orderType").toString():"";
+        String materialProp = Objects.nonNull(param.get("materialProp"))?param.get("materialProp").toString():"";
         if(!OrderType.validateValue(orderType)){
             throw new ErrorException("鎵归噺鎶ユ澶辫触,闈炴硶鐨勯攢鍞鍗曞垎绫绘灇涓�");
         }
-        return Result.success(rawMaterialOrderService.inspectionReport(ids,orderType));
+        return Result.success(rawMaterialOrderService.inspectionReport(ids,orderType,materialProp));
     }
 
     /**
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/dto/InsOrderPlanDTO.java b/inspect-server/src/main/java/com/ruoyi/inspect/dto/InsOrderPlanDTO.java
index bfaa09b..ee33be7 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/dto/InsOrderPlanDTO.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/dto/InsOrderPlanDTO.java
@@ -1,12 +1,13 @@
 package com.ruoyi.inspect.dto;
 
+import com.ruoyi.basic.pojo.IfsInventoryQuantity;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 
 import java.io.Serializable;
 
 @Data
-public class InsOrderPlanDTO implements Serializable {
+public class InsOrderPlanDTO extends IfsInventoryQuantity implements Serializable {
 
     @ApiModelProperty("妫�楠屼换鍔′富閿甶d")
     private Long insSampleId;
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/dto/OrderSplitDTO.java b/inspect-server/src/main/java/com/ruoyi/inspect/dto/OrderSplitDTO.java
index ab4d170..058a942 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/dto/OrderSplitDTO.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/dto/OrderSplitDTO.java
@@ -31,4 +31,8 @@
     @ApiModelProperty("鏄惁鍚屾鍒癕ES")
     private Boolean pushToMes;
 
+    @ApiModelProperty("鐗╂枡灞炴�э紝鐢ㄤ簬鍖哄垎閾溿�侀摑瀵间綋绛夋潗鏂�")
+    private String materialProp;
+
+
 }
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/dto/ReportPageDto.java b/inspect-server/src/main/java/com/ruoyi/inspect/dto/ReportPageDto.java
index 1b1c69f..307361d 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/dto/ReportPageDto.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/dto/ReportPageDto.java
@@ -24,6 +24,9 @@
     @ApiModelProperty(value = "涓嬪崟绫诲埆")
     private Integer typeSource;
 
+    @ApiModelProperty(value = "鐗╂枡灞炴��")
+    private String materialProp;
+
     @ApiModelProperty(value = "妫�楠岀被鍒�")
     private String orderType;
 
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java
index 1d69e5e..41421a5 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.basic.dto.InventoryDetailDTO;
 import com.ruoyi.basic.pojo.StructureTestObject;
 import com.ruoyi.inspect.dto.SampleOrderDto;
 import com.ruoyi.inspect.dto.SampleProductDto2;
@@ -113,6 +114,13 @@
     List<InsOrderPrintingVo> labelOrderPrinting(@Param("ids") List<Integer> ids);
 
     /**
+     * 澶栬喘浜у搧鏍囩鎵撳嵃
+     * @param ids
+     * @return
+     */
+    List<InventoryDetailDTO> labelOutsideOrderPrinting(@Param("ids") List<Integer> ids);
+
+    /**
      * 鏌ヨ瀵煎嚭淇℃伅
      * @return
      */
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/InsOrderService.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/InsOrderService.java
index 11b1eb5..cb87b26 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/service/InsOrderService.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/InsOrderService.java
@@ -3,6 +3,7 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.basic.dto.InventoryDetailDTO;
 import com.ruoyi.basic.pojo.IfsInventoryQuantity;
 import com.ruoyi.basic.pojo.StandardProductList;
 import com.ruoyi.common.core.domain.Result;
@@ -91,6 +92,13 @@
     List<InsOrderPrintingVo> labelOrderPrinting(List<Integer> ids);
 
     /**
+     * 澶栬喘浜у搧鏍囩鎵撳嵃
+     * @param ids
+     * @return
+     */
+    List<InventoryDetailDTO> labelOutsideOrderPrinting(List<Integer> ids);
+
+    /**
      * 鏍规嵁鏍峰搧id鏌ヨ妫�楠岄」鏍�
      * @param insSampleId
      * @return
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/RawMaterialOrderService.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/RawMaterialOrderService.java
index c5e6ce9..7164013 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/service/RawMaterialOrderService.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/RawMaterialOrderService.java
@@ -43,7 +43,7 @@
      */
     IPage<IfsInventoryQuantityDto> getIfsByStateOne(IPage<IfsInventoryQuantityDto> page, IfsInventoryQuantityDto ifsInventoryQuantityDto);
 
-    int inspectionReport(List<Long> ids,String orderType);
+    int inspectionReport(List<Long> ids,String orderType,String materialProp);
 
     int revokeInspectionReport(Long id);
 
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java
index ed72ea8..952b412 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsOrderServiceImpl.java
@@ -16,6 +16,7 @@
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.basic.dto.InventoryDetailDTO;
 import com.ruoyi.basic.mapper.IfsInventoryQuantityMapper;
 import com.ruoyi.basic.mapper.StandardProductListMapper;
 import com.ruoyi.basic.mapper.StructureItemParameterMapper;
@@ -906,6 +907,11 @@
         return insOrderMapper.labelOrderPrinting(ids);
     }
 
+    @Override
+    public List<InventoryDetailDTO> labelOutsideOrderPrinting(List<Integer> ids) {
+        return insOrderMapper.labelOutsideOrderPrinting(ids);
+    }
+
     /**
      * 鏍规嵁鏍峰搧id鏌ヨ妫�楠岄」鏍�
      * @param insSampleId
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/RawMaterialOrderServiceImpl.java b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/RawMaterialOrderServiceImpl.java
index b388357..1312120 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/RawMaterialOrderServiceImpl.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/service/impl/RawMaterialOrderServiceImpl.java
@@ -175,7 +175,7 @@
      * @return
      */
     @Override
-    public int inspectionReport(List<Long> ids,String orderType) {
+    public int inspectionReport(List<Long> ids,String orderType,String materialProp) {
         Integer userId = SecurityUtils.getUserId().intValue();
         ifsInventoryQuantityMapper.update(null, Wrappers.<IfsInventoryQuantity>lambdaUpdate()
                 .in(IfsInventoryQuantity::getId, ids)
@@ -183,6 +183,7 @@
                 .set(IfsInventoryQuantity::getDeclareUserId, userId)
                 .set(IfsInventoryQuantity::getIsInspect, 1)
                 .set(IfsInventoryQuantity::getOrderType,orderType)
+                .set(IfsInventoryQuantity::getMaterialProp,materialProp)
                 .set(IfsInventoryQuantity::getDeclareDate, LocalDateTime.now())
         );
         threadPoolTaskExecutor.execute(() -> {
@@ -265,6 +266,7 @@
                 .set(IfsInventoryQuantity::getDeclareDate, LocalDateTime.now())
                 .set(IfsInventoryQuantity::getUpdateBatchNo, ifsInventoryQuantity.getUpdateBatchNo())
                 .set(IfsInventoryQuantity::getOrderType,ifsInventoryQuantity.getOrderType())
+                .set(IfsInventoryQuantity::getMaterialProp,ifsInventoryQuantity.getMaterialProp())
         );
 
         threadPoolTaskExecutor.execute(() -> {
@@ -972,7 +974,7 @@
         if(Objects.nonNull(splitOrderList) && !splitOrderList.isEmpty()){
             List<Long> ids = splitOrderList.stream().map(IfsInventoryQuantity::getId).collect(Collectors.toList());
             ids.add(ifsInventoryQuantity.getId());
-            this.inspectionReport(ids,OrderType.RAW.getValue());
+            this.inspectionReport(ids,OrderType.RAW.getValue(),orderSplitDTO.getMaterialProp());
         }
         //鍕鹃�夊悓姝ュ埌MES锛屼繚瀛樿鍗曟媶鍒嗚褰�
         if(orderSplitDTO.getPushToMes()){
diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/vo/InsOrderPlanVO.java b/inspect-server/src/main/java/com/ruoyi/inspect/vo/InsOrderPlanVO.java
index 85a0de4..dfc14fb 100644
--- a/inspect-server/src/main/java/com/ruoyi/inspect/vo/InsOrderPlanVO.java
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/vo/InsOrderPlanVO.java
@@ -15,6 +15,9 @@
     @ApiModelProperty("鏍峰搧鍚嶇О")
     private String sample;
 
+    @ApiModelProperty("鐗╂枡灞炴��")
+    private String materialProp;
+
     @ApiModelProperty("鏍峰搧鍨嬪彿")
     private String sampleModel;
 
diff --git a/inspect-server/src/main/resources/mapper/InsOrderMapper.xml b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
index fb57bb0..d4aa9a2 100644
--- a/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml
@@ -335,7 +335,7 @@
           AND isa.id = #{id}
           and ip.cable_tag is not null
         GROUP BY ip.cable_tag
-        order by ip.cable_tag
+        order by MIN(ip.id)
     </select>
     <select id="selectSampleItemS" resultType="java.lang.Integer">
         select count(*)
@@ -507,4 +507,41 @@
           AND io.id = #{id}
         LIMIT 1
     </select>
+
+    <!-- 澶栬喘涓嬪崟鎴愬搧鏍囩鎵撳嵃 -->
+    <select id="labelOutsideOrderPrinting" resultType="com.ruoyi.basic.dto.InventoryDetailDTO">
+        SELECT
+        iiq.id,
+        iiq.part_desc,
+        iiq.lot_batch_no,
+        iiq.part_no,
+        ippr.insulation_color,
+        ippr.outer_color,
+        ippr.drum_no,
+        ippr.start_meter_mark,
+        ippr.end_meter_mark,
+        io.update_time,
+        io.ins_state,
+        -- 妫�楠屼汉鏌ヨ锛氫紭鍏堝彇鎸囨淳鐨勮礋璐d汉锛屽鏋滄病鏈夊垯鍙栬鍗曞垱寤轰汉
+        COALESCE(isu.userName, u.name) AS inspector_name
+        FROM ifs_inventory_quantity iiq
+        LEFT JOIN ifs_part_props_record ippr ON ippr.ifs_inventory_id = iiq.id
+        LEFT JOIN ins_order io ON io.ifs_inventory_id = iiq.id AND io.state != -1
+        -- 鍏宠仈鐢ㄦ埛琛紝鐢ㄤ簬鑾峰彇璁㈠崟鍒涘缓浜哄鍚�
+        LEFT JOIN user u ON io.create_user = u.id
+        -- 鍏宠仈瀛愭煡璇紝鐢ㄤ簬鑾峰彇 ins_sample_user 琛ㄤ腑鎸囨淳鐨勬楠岃礋璐d汉
+        LEFT JOIN (
+        SELECT
+        ins_sample_id,
+        GROUP_CONCAT(DISTINCT uu.name SEPARATOR ',') AS userName
+        FROM ins_sample_user isu_inner
+        LEFT JOIN user uu ON isu_inner.user_id = uu.id
+        WHERE isu_inner.state = 0
+        GROUP BY ins_sample_id
+        ) isu ON isu.ins_sample_id = io.id
+        WHERE iiq.id IN
+        <foreach collection="ids" index="index" open="(" separator="," close=")" item="val">
+            #{val}
+        </foreach>
+    </select>
 </mapper>
diff --git a/inspect-server/src/main/resources/mapper/InsReportMapper.xml b/inspect-server/src/main/resources/mapper/InsReportMapper.xml
index fa58164..1800539 100644
--- a/inspect-server/src/main/resources/mapper/InsReportMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsReportMapper.xml
@@ -18,6 +18,7 @@
         io.laboratory,
         io.ifs_inventory_id,
         iiq.is_copper,
+        iiq.material_prop,
         ip.son_laboratory
         from ins_report ir
         left join ins_order io on io.id = ir.ins_order_id
diff --git a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
index 4a8569d..4698777 100644
--- a/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsSampleMapper.xml
@@ -193,7 +193,8 @@
         ira.url_s,
         ira.temp_url_pdf,
         iiq.is_copper,
-        iiq.is_split_order
+        iiq.is_split_order,
+        iiq.material_prop AS material_prop
         FROM
         ins_order io
         LEFT JOIN ins_sample isa ON isa.ins_order_id = io.id
diff --git a/performance-server/src/main/java/com/ruoyi/performance/service/impl/AuxiliaryWorkingHoursDayServiceImpl.java b/performance-server/src/main/java/com/ruoyi/performance/service/impl/AuxiliaryWorkingHoursDayServiceImpl.java
index 1880de8..27da7b4 100644
--- a/performance-server/src/main/java/com/ruoyi/performance/service/impl/AuxiliaryWorkingHoursDayServiceImpl.java
+++ b/performance-server/src/main/java/com/ruoyi/performance/service/impl/AuxiliaryWorkingHoursDayServiceImpl.java
@@ -151,8 +151,8 @@
     //缂栬緫
     @Override
     public int updateAuxiliaryWorkingHoursDay(AuxiliaryWorkingHoursDay auxiliaryWorkingHoursDay) {
-        Integer userId = SecurityUtils.getUserId().intValue();
-        auxiliaryWorkingHoursDay.setNameUser(userId);//濮撳悕id
+//        Integer userId = SecurityUtils.getUserId().intValue();
+//        auxiliaryWorkingHoursDay.setNameUser(userId);//濮撳悕id
         return auxiliaryWorkingHoursDayMapper.updateById(auxiliaryWorkingHoursDay);
     }
 

--
Gitblit v1.9.3