From 3b6b3e356583e7ae3d264b4c59178c8b4087e5c4 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期四, 06 六月 2024 10:57:34 +0800
Subject: [PATCH] 检验任务的附件+提交前校验+复核确认新增不合格项目

---
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java |   20 +++
 inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java            |   20 +++
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java    |    2 
 inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java                    |   68 +++++++++++
 inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java             |    6 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |  114 ++++++++++++++++--
 inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java          |   16 ++
 inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java    |   55 ++++++++
 inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml                        |   25 ++++
 inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java          |    7 +
 10 files changed, 317 insertions(+), 16 deletions(-)

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 0c9ee1d..a8a3b82 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
@@ -5,6 +5,8 @@
 import com.yuanchu.mom.annotation.ValueAuth;
 import com.yuanchu.mom.annotation.ValueClassify;
 import com.yuanchu.mom.dto.InsOrderPlanDTO;
+import com.yuanchu.mom.pojo.InsOrderFile;
+import com.yuanchu.mom.service.InsOrderFileService;
 import com.yuanchu.mom.service.InsOrderPlanService;
 import com.yuanchu.mom.utils.JackSonUtil;
 import com.yuanchu.mom.vo.Result;
@@ -15,7 +17,9 @@
 import org.springframework.web.bind.annotation.RequestBody;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.multipart.MultipartFile;
 
+import java.util.HashMap;
 import java.util.Map;
 
 /**
@@ -28,6 +32,8 @@
 public class InsOrderPlanController {
 
     private InsOrderPlanService insOrderPlanService;
+
+    private InsOrderFileService insOrderFileService;
 
     @ValueClassify("妫�楠屼换鍔�")
     @ApiOperation(value = "鑾峰彇妫�楠屼换鍔″垪琛�")
@@ -55,6 +61,7 @@
     public Result claimInsOrderPlan(@RequestBody InsOrderPlanDTO data) {
         return Result.success(insOrderPlanService.claimInsOrderPlan(data));
     }
+
     @ValueClassify("妫�楠屼换鍔�")
     @ApiOperation(value = "鎵ц妫�楠屾搷浣�")
     @PostMapping("/doInsOrder")
@@ -75,26 +82,70 @@
     public Result<?> upPlanUser(Integer userId, Integer orderId) {
         return Result.success(insOrderPlanService.upPlanUser(userId, orderId));
     }
+
     @ValueClassify("妫�楠屼换鍔�")
     @ApiOperation(value = "澶嶆牳妫�楠屼换鍔�")
     @PostMapping("/verifyPlan")
     public Result<?> verifyPlan(Integer orderId, String laboratory, Integer type, String tell) {
         return Result.success(insOrderPlanService.verifyPlan(orderId, laboratory, type, tell));
     }
+
+    @ValueClassify("妫�楠屼换鍔�")
+    @ApiOperation(value = "鏍¢獙妫�楠屼换鍔℃彁浜�")
+    @PostMapping("/checkSubmitPlan")
+    public Result<?> checkSubmitPlan(Integer orderId, String laboratory) {
+        return Result.success(insOrderPlanService.checkSubmitPlan(orderId, laboratory));
+    }
+
     @ValueClassify("妫�楠屼换鍔�")
     @ApiOperation(value = "妫�楠屼换鍔℃彁浜�")
     @PostMapping("/submitPlan")
     public Result<?> submitPlan(Integer orderId, String laboratory, Integer verifyUser) {
         int num = insOrderPlanService.submitPlan(orderId, laboratory, verifyUser);
-        return num==1?Result.success():Result.fail("鎻愪氦澶辫触锛岄儴鍒嗛」鐩繕鏈繘琛屾楠�");
+        return num == 1 ? Result.success() : Result.fail("鎻愪氦澶辫触锛岄儴鍒嗛」鐩繕鏈繘琛屾楠�");
     }
 
     @ApiOperation(value = "淇濆瓨妫�楠屽唴瀹�")
     @PostMapping("/saveInsContext")
     @ValueAuth
-    public Result<?> saveInsContext(String param){
+    public Result<?> saveInsContext(String param) {
         Map<String, Object> param2 = JSON.parseObject(param, Map.class);
         insOrderPlanService.saveInsContext(param2);
         return Result.success();
     }
+
+    @ValueClassify("妫�楠屼换鍔�")
+    @ApiOperation(value = "鏌ョ湅妫�楠屽崟涓嬬殑闄勪欢鍒楄〃")
+    @PostMapping("/getFileList")
+    public Result<?> getFileList(@RequestBody Map<String, Object> data) throws Exception {
+        Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
+        page.setOptimizeCountSql(false);
+        InsOrderFile insOrderFile = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), InsOrderFile.class);
+        return Result.success(insOrderPlanService.getFileList(page, insOrderFile));
+    }
+
+    @ValueClassify("妫�楠屼换鍔�")
+    @ApiOperation(value = "涓婁紶闄勪欢")
+    @PostMapping("/uploadFile")
+    public Result<?> uploadFile(Integer orderId, MultipartFile file) {
+        return Result.success(insOrderPlanService.uploadFile(orderId, file));
+    }
+
+    @ValueClassify("妫�楠屼换鍔�")
+    @ApiOperation(value = "鍒犻櫎闄勪欢")
+    @PostMapping("/delfile")
+    public Result<?> delfile(Integer id) {
+        return Result.success(insOrderFileService.removeById(id));
+    }
+
+    @ValueClassify("妫�楠屼换鍔�")
+    @ApiOperation(value = "涓嬭浇闄勪欢")
+    @PostMapping("/downFile")
+    public Result<?> downFile(Integer id) {
+        InsOrderFile insOrderFile = insOrderFileService.getById(id);
+        HashMap<String, Object> map = new HashMap<>();
+        map.put("type", insOrderFile.getType());
+        map.put("fileUrl", insOrderFile.getFileUrl());
+        return Result.success(map);
+    }
 }
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java
new file mode 100644
index 0000000..dd3a93e
--- /dev/null
+++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java
@@ -0,0 +1,20 @@
+package com.yuanchu.mom.mapper;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.yuanchu.mom.pojo.InsOrderFile;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * <p>
+ * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
+ * @since 2024-06-06 10:08:21
+ */
+public interface InsOrderFileMapper extends BaseMapper<InsOrderFile> {
+
+    IPage<InsOrderFile> getFileList(Page page, QueryWrapper<InsOrderFile> ew);
+}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java
new file mode 100644
index 0000000..0aa3a66
--- /dev/null
+++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java
@@ -0,0 +1,68 @@
+package com.yuanchu.mom.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+
+import com.yuanchu.mom.annotation.ValueTableShow;
+import com.yuanchu.mom.common.OrderBy;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Getter;
+import lombok.Setter;
+
+/**
+ * <p>
+ * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃
+ * </p>
+ *
+ * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
+ * @since 2024-06-06 10:08:21
+ */
+@Getter
+@Setter
+@TableName("ins_order_file")
+@ApiModel(value = "InsOrderFile瀵硅薄", description = "妫�楠屽崟涓嬬殑闄勪欢鍒楄〃")
+public class InsOrderFile extends OrderBy implements Serializable {
+
+    @TableId(value = "id", type = IdType.AUTO)
+    private Integer id;
+
+    @ApiModelProperty("鍏宠仈 妫�楠屽崟澶栭敭id")
+    private Integer insOrderId;
+
+    @ApiModelProperty("绫诲瀷")
+    @ValueTableShow(2)
+    private Integer type;
+
+    @ApiModelProperty("闄勪欢璺緞")
+    private String fileUrl;
+
+    @ApiModelProperty("闄勪欢鍚嶇О")
+    @ValueTableShow(3)
+    private String fileName;
+
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty("涓婁紶浜�")
+    @ValueTableShow(4)
+    @TableField(exist = false, select = false)
+    private String name;
+
+    @TableField(fill = FieldFill.INSERT)
+    @ApiModelProperty("涓婁紶鏃堕棿")
+    @ValueTableShow(5)
+    private LocalDateTime createTime;
+
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private LocalDateTime updateTime;
+}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java
new file mode 100644
index 0000000..d18b7f3
--- /dev/null
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java
@@ -0,0 +1,16 @@
+package com.yuanchu.mom.service;
+
+import com.yuanchu.mom.pojo.InsOrderFile;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * <p>
+ * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 鏈嶅姟绫�
+ * </p>
+ *
+ * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
+ * @since 2024-06-06 10:08:21
+ */
+public interface InsOrderFileService extends IService<InsOrderFile> {
+
+}
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 48957a1..4ec5f67 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.InsOrderFile;
 import com.yuanchu.mom.pojo.InsProduct;
+import org.springframework.web.multipart.MultipartFile;
 
 import java.util.List;
 import java.util.Map;
@@ -29,4 +31,9 @@
 
     List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory);
 
+    List<String> checkSubmitPlan(Integer orderId, String laboratory);
+
+    Map<String,Object> getFileList(Page page, InsOrderFile insOrderFile);
+
+    int uploadFile(Integer orderId, MultipartFile file);
 }
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java
index 198a274..421eaf5 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java
@@ -1,7 +1,10 @@
 package com.yuanchu.mom.service;
 
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
 import com.yuanchu.mom.dto.UnPassPageDto;
+import com.yuanchu.mom.pojo.InsProductUser;
+import com.yuanchu.mom.pojo.InsUnPass;
 
 import java.util.Map;
 
@@ -9,6 +12,7 @@
  * @author 鏈变匠鍚�
  * @date 2024/5/8 13:00
  */
-public interface InsUnPassService {
+public interface InsUnPassService extends IService<InsUnPass> {
+
     Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto);
 }
\ No newline at end of file
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java
new file mode 100644
index 0000000..05a43c1
--- /dev/null
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java
@@ -0,0 +1,20 @@
+package com.yuanchu.mom.service.impl;
+
+import com.yuanchu.mom.pojo.InsOrderFile;
+import com.yuanchu.mom.mapper.InsOrderFileMapper;
+import com.yuanchu.mom.service.InsOrderFileService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * <p>
+ * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
+ * @since 2024-06-06 10:08:21
+ */
+@Service
+public class InsOrderFileServiceImpl extends ServiceImpl<InsOrderFileMapper, InsOrderFile> implements InsOrderFileService {
+
+}
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 7e312bd..ed801ae 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
@@ -3,6 +3,7 @@
 import cn.hutool.core.bean.BeanUtil;
 import cn.hutool.core.date.DateTime;
 import cn.hutool.core.date.DateUtil;
+import cn.hutool.core.lang.UUID;
 import cn.hutool.core.util.ObjectUtil;
 import cn.hutool.core.util.StrUtil;
 import com.alibaba.fastjson.JSON;
@@ -34,11 +35,13 @@
 import com.yuanchu.mom.utils.QueryWrappers;
 import com.yuanchu.mom.vo.InsOrderPlanTaskSwitchVo;
 import com.yuanchu.mom.vo.InsOrderPlanVO;
+import com.yuanchu.mom.vo.Result;
 import org.apache.commons.io.IOUtils;
 import org.apache.poi.xwpf.usermodel.*;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
 
 import javax.annotation.Resource;
 import java.io.*;
@@ -93,6 +96,9 @@
     private InsProductUserMapper insProductUserMapper;
 
     @Resource
+    private InsUnPassService insUnPassService;
+
+    @Resource
     AuxiliaryOutputWorkingHoursMapper auxiliaryOutputWorkingHoursMapper;
 
     @Resource
@@ -109,6 +115,9 @@
 
     @Resource
     private InsBushingService insBushingService;
+
+    @Resource
+    private InsOrderFileMapper insOrderFileMapper;
 
     @Override
     public Map<String, Object> selectInsOrderPlanList(Page page, InsOrderPlanDTO insOrderPlanDTO) {
@@ -175,7 +184,7 @@
     @Override
     public List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory) {
         List<InsProduct> insProducts = new ArrayList<>();
-        switch (type){
+        switch (type) {
             case 0:
                 insProducts = insSampleMapper.getInsProduct1(id, laboratory);
                 break;
@@ -191,6 +200,65 @@
         if (BeanUtil.isEmpty(insProducts)) return null;
         getTemplateThing(set, map2, insProducts);
         return insProducts;
+    }
+
+    @Override
+    public List<String> checkSubmitPlan(Integer orderId, String laboratory) {
+        List<String> collect = new ArrayList<>();
+        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).eq(InsProduct::getInsResult, 0));
+        if (insProducts.size() > 0) {
+            collect = insProducts.stream().map(insProduct -> {
+                return insProduct.getInspectionItem() + "-" + insProduct.getInspectionItemSubclass();
+            }).collect(Collectors.toList());
+        }
+        return collect;
+    }
+
+    @Override
+    public Map<String, Object> getFileList(Page page, InsOrderFile insOrderFile) {
+        Map<String, Object> map = new HashMap<>();
+        map.put("head", PrintChina.printChina(InsOrderFile.class));
+        IPage<InsOrderFile> insOrderFileIPage = insOrderFileMapper.getFileList(page, QueryWrappers.queryWrappers(insOrderFile));
+        map.put("body", insOrderFileIPage);
+        return map;
+    }
+
+    @Override
+    public int uploadFile(Integer orderId, MultipartFile file) {
+        String urlString;
+        String pathName;
+        String path;
+        String filename = file.getOriginalFilename();
+        String contentType = file.getContentType();
+        InsOrderFile insOrderFile = new InsOrderFile();
+        insOrderFile.setInsOrderId(orderId);
+        insOrderFile.setFileName(filename);
+        if (contentType != null && contentType.startsWith("image/")) {
+            // 鏄浘鐗�
+            path = imgUrl;
+            insOrderFile.setType(1);
+        } else {
+            // 鏄枃浠�
+            path = wordUrl;
+            insOrderFile.setType(2);
+        }
+        try {
+            File realpath = new File(path);
+            if (!realpath.exists()) {
+                realpath.mkdirs();
+            }
+            pathName = UUID.randomUUID() + "_" + file.getOriginalFilename();
+            urlString = realpath + "/" + pathName;
+            file.transferTo(new File(urlString));
+            insOrderFile.setFileUrl(pathName);
+            return insOrderFileMapper.insert(insOrderFile);
+        } catch (Exception e) {
+            e.printStackTrace();
+            System.err.println("闄勪欢涓婁紶閿欒");
+            return 0;
+        }
     }
 
     @Override
@@ -368,6 +436,7 @@
         insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, now).set(InsOrderState::getInsState, num).set(InsOrderState::getVerifyTell, tell).set(InsOrderState::getVerifyUser, getLook.selectPowerByMethodAndUserId(null).get("userId")));
         Long count = insOrderStateMapper.selectCount(Wrappers.<InsOrderState>lambdaQuery().eq(InsOrderState::getInsOrderId, orderId).ne(InsOrderState::getInsState, 5));
         if (count == 0 && num == 5) {
+            List<InsUnPass> insUnPasses = new ArrayList<>();
             /*鏍峰搧涓嬬殑椤圭洰鍙鏈変竴涓」鐩笉鍚堟牸鍒欐楠岀粨鏋滀负0,鍚﹀垯涓�1*/
             List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId));
             for (InsSample insSample : insSamples) {
@@ -379,7 +448,25 @@
                     insSample.setInsResult(1);
                 }
                 insSampleMapper.updateById(insSample);
+                /*澶嶆牳閫氳繃鍚庯紝灏嗕笉鍚堟牸鐨勯」鐩俊鎭坊鍔犲埌ins_un_pass琛ㄤ腑*/
+                for (InsProduct insProduct : insProducts) {
+                    if (insProduct.getInsResult() == 0) {
+                        InsUnPass insUnPass = new InsUnPass();
+                        insUnPass.setModel(insSample.getModel());
+                        insUnPass.setSample(insSample.getSample());
+                        insUnPass.setInspectionItem(insProduct.getInspectionItem());
+                        insUnPass.setInspectionItemSubclass(insProduct.getInspectionItemSubclass());
+                        insUnPass.setLastValue(insProduct.getLastValue());
+                        insUnPass.setEntrustCode(insOrderMapper.selectById(orderId).getEntrustCode());
+                        List<Integer> userIds = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery().eq(InsProductUser::getInsProductId, insProduct.getId())).stream().map(InsProductUser::getCreateUser).distinct().collect(Collectors.toList());
+                        String name = userMapper.selectBatchIds(userIds).stream().map(User::getName).collect(Collectors.joining(","));
+                        insUnPass.setName(name);
+                        insUnPasses.add(insUnPass);
+                    }
+                }
+                insUnPassService.saveBatch(insUnPasses);
             }
+
             InsOrder insOrder = insOrderMapper.selectById(orderId);
             Map<String, String> user = insProductMapper.selectUserById(insOrder.getUserId());
             List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId(orderId);
@@ -398,7 +485,7 @@
             AtomicReference<String> resultEn = new AtomicReference<>("");
             samples.forEach(a -> {
                 Long productCount = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getInsSampleId, a.getId()));
-                productSize.set(productSize.get()+Integer.parseInt(productCount+""));
+                productSize.set(productSize.get() + Integer.parseInt(productCount + ""));
                 models.add(a.getModel());
                 standardMethod.add(baseMapper.getStandardMethodCode(a.getStandardMethodListId()));
                 Set<String> templateSet = new HashSet<>();
@@ -536,8 +623,8 @@
                                         textRenderData.setText("鈭�");
                                         break;
                                     case 0:
-                                        resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (Objects.equals(p.getInspectionItemSubclass(), "") ?"":" "+p.getInspectionItemSubclass()));
-                                        resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "")||Objects.equals(p.getInspectionItemSubclassEn(), null)) ?"":" "+p.getInspectionItemSubclassEn()));
+                                        resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (Objects.equals(p.getInspectionItemSubclass(), "") ? "" : " " + p.getInspectionItemSubclass()));
+                                        resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn()));
                                         textRenderData.setText("脳");
                                         break;
                                     default:
@@ -574,8 +661,8 @@
                                         textRenderData.setText("鉁�");
                                         break;
                                     case 0:
-                                        resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (p.getInspectionItemSubclass().equals("")?"":" "+p.getInspectionItemSubclass()));
-                                        resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "")||Objects.equals(p.getInspectionItemSubclassEn(), null)) ?"":" "+p.getInspectionItemSubclassEn()));
+                                        resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (p.getInspectionItemSubclass().equals("") ? "" : " " + p.getInspectionItemSubclass()));
+                                        resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn()));
                                         textRenderData.setText("鉁�");
                                         break;
                                     default:
@@ -610,7 +697,7 @@
                     }
                     TextRenderData[] text2 = text.toArray(new TextRenderData[0]);
                     rowRenderData = Rows.of(text2).rowAtleastHeight(1).center().create();
-                    if(rowRenderData.getCells().size()!=0){
+                    if (rowRenderData.getCells().size() != 0) {
                         rows.add(rowRenderData);
                     }
                     TableRenderData tableRenderData = new TableRenderData();
@@ -621,7 +708,7 @@
                             System.out.print(cell.getParagraphs().get(0).getContents());
                         }
                         System.out.println("");*/
-                        if(row.getCells().size()!=countSize){
+                        if (row.getCells().size() != countSize) {
                             throw new ErrorException("姣忚鍗曞厓鏍间笉鐩哥瓑");
                         }
                     }
@@ -699,13 +786,14 @@
                 throw new ErrorException("鎵句笉鍒版楠屼汉鐨勭鍚�");
             }
             Custom custom = customMapper.selectById(user.get("company"));
-            if(!resultCh.get().equals("")){
-                resultCh.set("渚濇嵁濮旀墭瑕佹眰锛�"+resultCh.get().replaceFirst("銆�", "")+"绛夋墍妫�椤圭洰涓嶇鍚堣姹傦紝鍏朵綑鎵�妫�椤圭洰鍧囩鍚堣姹傘��");
-                resultEn.set("According to commissioned requirements,"+resultEn.get().replaceFirst("銆�", "")+" these inspected items do not meet the requirements, all other inspected items meet the requirements.");
-            }else{
+            if (!resultCh.get().equals("")) {
+                resultCh.set("渚濇嵁濮旀墭瑕佹眰锛�" + resultCh.get().replaceFirst("銆�", "") + "绛夋墍妫�椤圭洰涓嶇鍚堣姹傦紝鍏朵綑鎵�妫�椤圭洰鍧囩鍚堣姹傘��");
+                resultEn.set("According to commissioned requirements," + resultEn.get().replaceFirst("銆�", "") + " these inspected items do not meet the requirements, all other inspected items meet the requirements.");
+            } else {
                 resultCh.set("渚濇嵁濮旀墭瑕佹眰锛屾墍妫�椤圭洰鍧囩鍚堣姹傘��");
                 resultEn.set("According to commissioned requirements, all the tested items meet the requirements.");
             }
+
             XWPFTemplate template = XWPFTemplate.compile(url, builder.build()).render(
                     new HashMap<String, Object>() {{
                         put("order", insOrder);
@@ -849,7 +937,7 @@
             int count = 0;
             for (InsProduct product : insProducts) {
                 count++;
-                str += "<br/>"+count + "锛�" +product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "<br/>";
+                str += "<br/>" + count + "锛�" + product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "<br/>";
             }
             throw new ErrorException("<strong>瀛樺湪寰呮楠岀殑椤圭洰锛�</strong><br/>" + str);
         }
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java
index 5c6ad2e..418555b 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java
@@ -22,10 +22,12 @@
  */
 @Service
 public class InsUnPassServiceImpl extends ServiceImpl<InsUnPassMapper, InsUnPass> implements InsUnPassService {
+
     @Resource
     private GetLook getLook;
     @Resource
     private InsUnPassMapper insUnPassMapper;
+
     @Override
     public Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto) {
         Map<String, Object> map = new HashMap<>();
diff --git a/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml b/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml
new file mode 100644
index 0000000..9d060b9
--- /dev/null
+++ b/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.yuanchu.mom.mapper.InsOrderFileMapper">
+    <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+    <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.InsOrderFile">
+        <id column="id" property="id"/>
+        <result column="ins_order_id" property="insOrderId"/>
+        <result column="type" property="type"/>
+        <result column="file_url" property="fileUrl"/>
+        <result column="file_name" property="fileName"/>
+        <result column="create_user" property="createUser"/>
+        <result column="create_time" property="createTime"/>
+        <result column="update_user" property="updateUser"/>
+        <result column="update_time" property="updateTime"/>
+    </resultMap>
+    <select id="getFileList" resultType="com.yuanchu.mom.pojo.InsOrderFile">
+        select A.*
+        from (select iof.*, name
+              from ins_order_file iof
+                       left join user u on iof.create_user = u.id) A
+        <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
+            ${ew.customSqlSegment}
+        </if>
+    </select>
+</mapper>

--
Gitblit v1.9.3