From b2690b02f12d529ec7bb45e059c6d2eef59b7f2c Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期五, 25 四月 2025 16:36:06 +0800
Subject: [PATCH] 原始检测项管理

---
 ruoyi-system/src/main/resources/mapper/system/TTestMethodConfirmSheetOriginalMapper.xml                      |   30 +++++
 ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalService.java              |    9 +
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalController.java        |   87 ++++++++++++++
 ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalDataService.java          |   16 ++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalDataController.java    |    4 
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalDataMapper.java            |   16 ++
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalMapper.java                |   14 ++
 ruoyi-system/src/main/resources/mapper/system/TResultWorkEvaluateMapper.xml                                  |    6 
 /dev/null                                                                                                    |   20 ---
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalServiceImpl.java     |   13 ++
 ruoyi-system/src/main/java/com/ruoyi/system/model/TResultWorkEvaluate.java                                   |   13 +
 ruoyi-system/src/main/java/com/ruoyi/system/query/TTestMethodConfirmSheetOriginalQuery.java                  |   26 ++++
 ruoyi-system/src/main/java/com/ruoyi/system/vo/TTestMethodConfirmSheetOriginalVO.java                        |   35 +++++
 ruoyi-system/src/main/java/com/ruoyi/system/dto/TTestMethodConfirmSheetOriginalDTO.java                      |   18 +++
 ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetOriginalData.java                   |   12 +-
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalDataServiceImpl.java |   20 +++
 16 files changed, 303 insertions(+), 36 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalController.java
index 56bd24e..fdd98ea 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalController.java
@@ -1,9 +1,31 @@
 package com.ruoyi.web.controller.api;
 
 
+import com.alibaba.fastjson.JSON;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.ruoyi.common.annotation.Log;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.framework.web.service.TokenService;
+import com.ruoyi.system.dto.TTestMethodConfirmSheetOriginalDTO;
+import com.ruoyi.system.mapper.SysUserMapper;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+import com.ruoyi.system.model.TTestMethodConfirmSheetTerm;
+import com.ruoyi.system.query.TTestMethodConfirmSheetOriginalQuery;
+import com.ruoyi.system.service.ISysUserService;
+import com.ruoyi.system.service.TTestMethodConfirmSheetOriginalDataService;
+import com.ruoyi.system.service.TTestMethodConfirmSheetOriginalService;
+import com.ruoyi.system.vo.TTestMethodConfirmSheetOriginalVO;
 import io.swagger.annotations.Api;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.BeanUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
 
 /**
  * <p>
@@ -15,10 +37,69 @@
  */
 @Api(tags = "原始检测项管理")
 @RestController
-@RequestMapping("/t-test-method-confirm-sheet-term")
+@RequestMapping("/t-test-method-confirm-sheet-original")
 public class TTestMethodConfirmSheetOriginalController {
 
+    private final TokenService tokenService;
+    private final ISysUserService sysUserService;
+    private final SysUserMapper sysUserMapper;
+    private final TTestMethodConfirmSheetOriginalService testMethodConfirmSheetOriginalService;
+    private final TTestMethodConfirmSheetOriginalDataService testMethodConfirmSheetOriginalDataService;
+    @Autowired
+    public TTestMethodConfirmSheetOriginalController(TokenService tokenService, ISysUserService sysUserService, SysUserMapper sysUserMapper, TTestMethodConfirmSheetOriginalService testMethodConfirmSheetOriginalService, TTestMethodConfirmSheetOriginalDataService testMethodConfirmSheetOriginalDataService) {
+        this.tokenService = tokenService;
+        this.sysUserService = sysUserService;
+        this.sysUserMapper = sysUserMapper;
+        this.testMethodConfirmSheetOriginalService = testMethodConfirmSheetOriginalService;
+        this.testMethodConfirmSheetOriginalDataService = testMethodConfirmSheetOriginalDataService;
+    }
 
+    /**
+     * 获取检验方法确认单管理列表
+     */
+    @PreAuthorize("@ss.hasPermi('system:testMethodConfirmSheetOriginal:list')")
+    @ApiOperation(value = "获取检验方法确认单分页列表")
+    @PostMapping(value = "/api/t-test-method-confirm-sheet-original/pageList")
+    public R<PageInfo<TTestMethodConfirmSheetOriginalVO>> pageList(@RequestBody String param) {
+        TTestMethodConfirmSheetOriginalQuery query = JSON.parseObject(param, TTestMethodConfirmSheetOriginalQuery.class);
+        return R.ok(testMethodConfirmSheetOriginalService.pageList(query));
+    }
+
+    /**
+     * 修改检验方法确认单
+     */
+    @PreAuthorize("@ss.hasPermi('system:testMethodConfirmSheetOriginal:edit')")
+    @Log(title = "检验方法确认单信息-修改检验方法确认单", businessType = BusinessType.UPDATE)
+    @ApiOperation(value = "修改检验方法确认单")
+    @PostMapping(value = "/api/t-test-method-confirm-sheet-original/update")
+    public R<Boolean> update(@RequestBody String param) {
+        TTestMethodConfirmSheetOriginalDTO dto = JSON.parseObject(param, TTestMethodConfirmSheetOriginalDTO.class);
+        testMethodConfirmSheetOriginalService.updateById(dto);
+        testMethodConfirmSheetOriginalDataService.remove(Wrappers.lambdaQuery(TTestMethodConfirmSheetOriginalData.class).eq(TTestMethodConfirmSheetOriginalData::getOriginalId, dto.getId()));
+        List<TTestMethodConfirmSheetOriginalData> testMethodConfirmSheetOriginalDataList = dto.getTestMethodConfirmSheetOriginalDataList();
+        testMethodConfirmSheetOriginalDataList.forEach(testMethodConfirmSheetOriginalData -> {
+            testMethodConfirmSheetOriginalData.setOriginalId(dto.getId());
+        });
+        testMethodConfirmSheetOriginalDataService.saveBatch(testMethodConfirmSheetOriginalDataList);
+        return R.ok();
+    }
+
+    /**
+     * 查看检验方法确认单详情
+     */
+    @PreAuthorize("@ss.hasPermi('system:testMethodConfirmSheetOriginal:detail')")
+    @ApiOperation(value = "查看检验方法确认单详情")
+    @GetMapping(value = "/open/t-test-method-confirm-sheet-original/getDetailById")
+    public R<TTestMethodConfirmSheetOriginalVO> getDetailById(@RequestParam String id) {
+        TTestMethodConfirmSheetOriginal testMethodConfirmSheet = testMethodConfirmSheetOriginalService.getById(id);
+        TTestMethodConfirmSheetOriginalVO testMethodConfirmSheetVO = new TTestMethodConfirmSheetOriginalVO();
+        BeanUtils.copyProperties(testMethodConfirmSheet, testMethodConfirmSheetVO);
+
+        // 查询检测数据
+        List<TTestMethodConfirmSheetOriginalData> testMethodConfirmSheetOriginalDataList = testMethodConfirmSheetOriginalDataService.list(Wrappers.lambdaQuery(TTestMethodConfirmSheetOriginalData.class).eq(TTestMethodConfirmSheetOriginalData::getOriginalId, id));
+        testMethodConfirmSheetVO.setTestMethodConfirmSheetOriginalDataList(testMethodConfirmSheetOriginalDataList);
+        return R.ok(testMethodConfirmSheetVO);
+    }
 
 }
 
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetTermDataController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalDataController.java
similarity index 75%
rename from ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetTermDataController.java
rename to ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalDataController.java
index e0b7a63..a808d46 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetTermDataController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTestMethodConfirmSheetOriginalDataController.java
@@ -15,8 +15,8 @@
  */
 @Api(tags = "检验记录检测数据管理")
 @RestController
-@RequestMapping("/t-test-method-confirm-sheet-term-data")
-public class TTestMethodConfirmSheetTermDataController {
+@RequestMapping("/t-test-method-confirm-sheet-original-data")
+public class TTestMethodConfirmSheetOriginalDataController {
 
 }
 
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/dto/TTestMethodConfirmSheetOriginalDTO.java b/ruoyi-system/src/main/java/com/ruoyi/system/dto/TTestMethodConfirmSheetOriginalDTO.java
new file mode 100644
index 0000000..5001b76
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/dto/TTestMethodConfirmSheetOriginalDTO.java
@@ -0,0 +1,18 @@
+package com.ruoyi.system.dto;
+
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+@ApiModel(value = "原始检验记录编辑DTO")
+public class TTestMethodConfirmSheetOriginalDTO extends TTestMethodConfirmSheetOriginal {
+
+    @ApiModelProperty(value = "检测数据及图照集合")
+    private List<TTestMethodConfirmSheetOriginalData> testMethodConfirmSheetOriginalDataList;
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalDataMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalDataMapper.java
new file mode 100644
index 0000000..04ca6f6
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalDataMapper.java
@@ -0,0 +1,16 @@
+package com.ruoyi.system.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+
+/**
+ * <p>
+ * 检验记录检测数据 Mapper 接口
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-04-08
+ */
+public interface TTestMethodConfirmSheetOriginalDataMapper extends BaseMapper<TTestMethodConfirmSheetOriginalData> {
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalMapper.java
index 1f9fa5e..8b10e05 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetOriginalMapper.java
@@ -1,8 +1,14 @@
 package com.ruoyi.system.mapper;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
 import com.ruoyi.system.model.TTestMethodConfirmSheetTerm;
+import com.ruoyi.system.query.TTestMethodConfirmSheetOriginalQuery;
+import com.ruoyi.system.vo.TTestMethodConfirmSheetOriginalVO;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
 
 /**
  * <p>
@@ -14,4 +20,12 @@
  */
 public interface TTestMethodConfirmSheetOriginalMapper extends BaseMapper<TTestMethodConfirmSheetOriginal> {
 
+    /**
+     * 分页查询原始检测项
+     * @param query
+     * @param pageInfo
+     * @return
+     */
+    List<TTestMethodConfirmSheetOriginalVO> pageList(@Param("query") TTestMethodConfirmSheetOriginalQuery query, @Param("pageInfo")PageInfo<TTestMethodConfirmSheetOriginalVO> pageInfo);
+
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetTermDataMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetTermDataMapper.java
deleted file mode 100644
index d354e6d..0000000
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TTestMethodConfirmSheetTermDataMapper.java
+++ /dev/null
@@ -1,16 +0,0 @@
-package com.ruoyi.system.mapper;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.ruoyi.system.model.TTestMethodConfirmSheetTermData;
-
-/**
- * <p>
- * 检验记录检测数据 Mapper 接口
- * </p>
- *
- * @author xiaochen
- * @since 2025-04-08
- */
-public interface TTestMethodConfirmSheetTermDataMapper extends BaseMapper<TTestMethodConfirmSheetTermData> {
-
-}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TResultWorkEvaluate.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TResultWorkEvaluate.java
index 18bde3f..5536c9b 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TResultWorkEvaluate.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TResultWorkEvaluate.java
@@ -13,7 +13,7 @@
 
 /**
  * <p>
- * 实验员工作评定
+ * 实验结果评定
  * </p>
  *
  * @author xiaochen
@@ -22,7 +22,7 @@
 @Data
 @EqualsAndHashCode(callSuper = false)
 @TableName("t_result_work_evaluate")
-@ApiModel(value="TResultWorkEvaluate对象", description="实验员工作评定")
+@ApiModel(value="TResultWorkEvaluate对象", description="实验结果评定")
 public class TResultWorkEvaluate  extends BaseModel {
 
     private static final long serialVersionUID = 1L;
@@ -34,13 +34,17 @@
     @TableField("dispatch_id")
     private String dispatchId;
 
-    @ApiModelProperty(value = "实验员id")
+    @ApiModelProperty(value = "用户id")
     @TableField("user_id")
     private Integer userId;
 
     @ApiModelProperty(value = "实验结果id")
     @TableField("result_report_id")
     private String resultReportId;
+
+    @ApiModelProperty(value = "评定类型 1=工艺工程师 2=化验师 3=实验员")
+    @TableField("evaluate_type")
+    private Integer evaluateType;
 
     @ApiModelProperty(value = "1=良好 2=正确 3=失误")
     @TableField("evaluate_one")
@@ -79,6 +83,9 @@
     @TableField("evaluate_time")
     private LocalDateTime evaluateTime;
 
+    @ApiModelProperty(value = "评定分数 json")
+    @TableField("result_evaluate_json")
+    private String resultEvaluateJson;
 
 
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetTermData.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetOriginalData.java
similarity index 77%
rename from ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetTermData.java
rename to ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetOriginalData.java
index 904d18a..edd8cbf 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetTermData.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TTestMethodConfirmSheetOriginalData.java
@@ -12,7 +12,7 @@
 
 /**
  * <p>
- * 检验记录检测数据
+ * 原始检验记录检测数据
  * </p>
  *
  * @author xiaochen
@@ -20,9 +20,9 @@
  */
 @Data
 @EqualsAndHashCode(callSuper = false)
-@TableName("t_test_method_confirm_sheet_term_data")
-@ApiModel(value="TTestMethodConfirmSheetTermData对象", description="检验记录检测数据")
-public class TTestMethodConfirmSheetTermData extends BaseModel {
+@TableName("t_test_method_confirm_sheet_original_data")
+@ApiModel(value="TTestMethodConfirmSheetOriginalData对象", description="原始检验记录检测数据")
+public class TTestMethodConfirmSheetOriginalData extends BaseModel {
 
     private static final long serialVersionUID = 1L;
 
@@ -46,8 +46,8 @@
     private String dataType;
 
     @ApiModelProperty(value = "图片")
-    @TableField("data_pritures")
-    private String dataPritures;
+    @TableField("data_pictures")
+    private String dataPictures;
 
     @ApiModelProperty(value = "文件json")
     @TableField("data_files")
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/TTestMethodConfirmSheetOriginalQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/TTestMethodConfirmSheetOriginalQuery.java
new file mode 100644
index 0000000..f1d8530
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/TTestMethodConfirmSheetOriginalQuery.java
@@ -0,0 +1,26 @@
+package com.ruoyi.system.query;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.ruoyi.common.core.domain.model.TimeRangeQueryBody;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "原始检测项查询对象query")
+public class TTestMethodConfirmSheetOriginalQuery extends TimeRangeQueryBody {
+
+    @ApiModelProperty(value = "项目课题方案")
+    private String projectName;
+
+    @ApiModelProperty(value = "实验编号")
+    private String experimentCode;
+
+    @ApiModelProperty(value = "创建人")
+    private String createBy;
+
+    @ApiModelProperty(value = "状态 -1=草稿箱 1=未填写 2=已填写")
+    @TableField("status")
+    private Integer status;
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalDataService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalDataService.java
new file mode 100644
index 0000000..841a55c
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalDataService.java
@@ -0,0 +1,16 @@
+package com.ruoyi.system.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+
+/**
+ * <p>
+ * 检验记录检测数据 服务类
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-04-08
+ */
+public interface TTestMethodConfirmSheetOriginalDataService extends IService<TTestMethodConfirmSheetOriginalData> {
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalService.java
index d40b3f4..60f6978 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalService.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetOriginalService.java
@@ -1,8 +1,11 @@
 package com.ruoyi.system.service;
 
 import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
 import com.ruoyi.system.model.TTestMethodConfirmSheetTerm;
+import com.ruoyi.system.query.TTestMethodConfirmSheetOriginalQuery;
+import com.ruoyi.system.vo.TTestMethodConfirmSheetOriginalVO;
 
 /**
  * <p>
@@ -14,4 +17,10 @@
  */
 public interface TTestMethodConfirmSheetOriginalService extends IService<TTestMethodConfirmSheetOriginal> {
 
+    /**
+     * 获取检验方法确认单分页列表
+     * @param query
+     * @return
+     */
+    PageInfo<TTestMethodConfirmSheetOriginalVO> pageList(TTestMethodConfirmSheetOriginalQuery query);
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetTermDataService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetTermDataService.java
deleted file mode 100644
index 3737285..0000000
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TTestMethodConfirmSheetTermDataService.java
+++ /dev/null
@@ -1,16 +0,0 @@
-package com.ruoyi.system.service;
-
-import com.baomidou.mybatisplus.extension.service.IService;
-import com.ruoyi.system.model.TTestMethodConfirmSheetTermData;
-
-/**
- * <p>
- * 检验记录检测数据 服务类
- * </p>
- *
- * @author xiaochen
- * @since 2025-04-08
- */
-public interface TTestMethodConfirmSheetTermDataService extends IService<TTestMethodConfirmSheetTermData> {
-
-}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalDataServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalDataServiceImpl.java
new file mode 100644
index 0000000..3e8fedc
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalDataServiceImpl.java
@@ -0,0 +1,20 @@
+package com.ruoyi.system.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.system.mapper.TTestMethodConfirmSheetOriginalDataMapper;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+import com.ruoyi.system.service.TTestMethodConfirmSheetOriginalDataService;
+import org.springframework.stereotype.Service;
+
+/**
+ * <p>
+ * 检验记录检测数据 服务实现类
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-04-08
+ */
+@Service
+public class TTestMethodConfirmSheetOriginalDataServiceImpl extends ServiceImpl<TTestMethodConfirmSheetOriginalDataMapper, TTestMethodConfirmSheetOriginalData> implements TTestMethodConfirmSheetOriginalDataService {
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalServiceImpl.java
index dd057a0..6c58ce5 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetOriginalServiceImpl.java
@@ -1,13 +1,19 @@
 package com.ruoyi.system.service.impl;
 
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.mapper.TTestMethodConfirmSheetOriginalMapper;
 import com.ruoyi.system.mapper.TTestMethodConfirmSheetTermMapper;
 import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
 import com.ruoyi.system.model.TTestMethodConfirmSheetTerm;
+import com.ruoyi.system.query.TTestMethodConfirmSheetOriginalQuery;
 import com.ruoyi.system.service.TTestMethodConfirmSheetOriginalService;
 import com.ruoyi.system.service.TTestMethodConfirmSheetTermService;
+import com.ruoyi.system.vo.TExperimentResultReportVO;
+import com.ruoyi.system.vo.TTestMethodConfirmSheetOriginalVO;
 import org.springframework.stereotype.Service;
+
+import java.util.List;
 
 /**
  * <p>
@@ -20,4 +26,11 @@
 @Service
 public class TTestMethodConfirmSheetOriginalServiceImpl extends ServiceImpl<TTestMethodConfirmSheetOriginalMapper, TTestMethodConfirmSheetOriginal> implements TTestMethodConfirmSheetOriginalService {
 
+    @Override
+    public PageInfo<TTestMethodConfirmSheetOriginalVO> pageList(TTestMethodConfirmSheetOriginalQuery query) {
+        PageInfo<TTestMethodConfirmSheetOriginalVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+        List<TTestMethodConfirmSheetOriginalVO> list = this.baseMapper.pageList(query,pageInfo);
+        pageInfo.setRecords(list);
+        return pageInfo;
+    }
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetTermDataServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetTermDataServiceImpl.java
deleted file mode 100644
index 9f264e0..0000000
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TTestMethodConfirmSheetTermDataServiceImpl.java
+++ /dev/null
@@ -1,20 +0,0 @@
-package com.ruoyi.system.service.impl;
-
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ruoyi.system.mapper.TTestMethodConfirmSheetTermDataMapper;
-import com.ruoyi.system.model.TTestMethodConfirmSheetTermData;
-import com.ruoyi.system.service.TTestMethodConfirmSheetTermDataService;
-import org.springframework.stereotype.Service;
-
-/**
- * <p>
- * 检验记录检测数据 服务实现类
- * </p>
- *
- * @author xiaochen
- * @since 2025-04-08
- */
-@Service
-public class TTestMethodConfirmSheetTermDataServiceImpl extends ServiceImpl<TTestMethodConfirmSheetTermDataMapper, TTestMethodConfirmSheetTermData> implements TTestMethodConfirmSheetTermDataService {
-
-}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/vo/TTestMethodConfirmSheetOriginalVO.java b/ruoyi-system/src/main/java/com/ruoyi/system/vo/TTestMethodConfirmSheetOriginalVO.java
new file mode 100644
index 0000000..9d99041
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/vo/TTestMethodConfirmSheetOriginalVO.java
@@ -0,0 +1,35 @@
+package com.ruoyi.system.vo;
+
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginal;
+import com.ruoyi.system.model.TTestMethodConfirmSheetOriginalData;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+@ApiModel(value = "原始检验记录返回VO", description = "原始检验记录")
+public class TTestMethodConfirmSheetOriginalVO extends TTestMethodConfirmSheetOriginal {
+
+    @ApiModelProperty(value = "项目课题方案")
+    private String projectName;
+
+    @ApiModelProperty(value = "实验编号")
+    private String experimentCode;
+
+    @ApiModelProperty(value = "实验名称")
+    private String experimentName;
+
+    @ApiModelProperty(value = "检测项编号")
+    private String termCode;
+
+    @ApiModelProperty(value = "检测项名称")
+    private String termName;
+
+    @ApiModelProperty(value = "检测数据")
+    private List<TTestMethodConfirmSheetOriginalData> testMethodConfirmSheetOriginalDataList;
+
+
+
+}
diff --git a/ruoyi-system/src/main/resources/mapper/system/TResultWorkEvaluateMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TResultWorkEvaluateMapper.xml
index 71c32ed..ed5338c 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TResultWorkEvaluateMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TResultWorkEvaluateMapper.xml
@@ -3,11 +3,12 @@
 <mapper namespace="com.ruoyi.system.mapper.TResultWorkEvaluateMapper">
 
     <!-- 通用查询映射结果 -->
-    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TTesterWorkEvaluate">
+    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TResultWorkEvaluate">
         <id column="id" property="id" />
         <result column="dispatch_id" property="dispatchId" />
         <result column="user_id" property="userId" />
         <result column="result_report_id" property="resultReportId" />
+        <result column="evaluate_type" property="evaluateType" />
         <result column="evaluate_one" property="evaluateOne" />
         <result column="evaluate_two" property="evaluateTwo" />
         <result column="evaluate_three" property="evaluateThree" />
@@ -17,6 +18,7 @@
         <result column="status" property="status" />
         <result column="evaluate_person_id" property="evaluatePersonId" />
         <result column="evaluate_time" property="evaluateTime" />
+        <result column="result_evaluate_json" property="resultEvaluateJson" />
         <result column="create_time" property="createTime" />
         <result column="update_time" property="updateTime" />
         <result column="create_by" property="createBy" />
@@ -26,7 +28,7 @@
 
     <!-- 通用查询结果列 -->
     <sql id="Base_Column_List">
-        id, dispatch_id, user_id, result_report_id, evaluate_one, evaluate_two, evaluate_three, evaluate_four, evaluate_five, evaluate_six, status, evaluate_person_id, evaluate_time, create_time, update_time, create_by, update_by, disabled
+        id, dispatch_id, user_id, result_report_id,evaluate_type, evaluate_one, evaluate_two, evaluate_three, evaluate_four, evaluate_five, evaluate_six, status, evaluate_person_id, evaluate_time,result_evaluate_json, create_time, update_time, create_by, update_by, disabled
     </sql>
 
 </mapper>
diff --git a/ruoyi-system/src/main/resources/mapper/system/TTestMethodConfirmSheetOriginalMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TTestMethodConfirmSheetOriginalMapper.xml
index 7f26395..bf1ff11 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TTestMethodConfirmSheetOriginalMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TTestMethodConfirmSheetOriginalMapper.xml
@@ -24,5 +24,35 @@
     <sql id="Base_Column_List">
         id, term_id, original_code, term_standard, term_instrument, term_reagent, term_step, term_result, status, create_time, update_time, create_by, update_by, disabled
     </sql>
+    <select id="pageList" resultType="com.ruoyi.system.vo.TTestMethodConfirmSheetOriginalVO">
+        select ttmcso.id, ttmcso.term_id, ttmcso.original_code, ttmcso.term_standard, ttmcso.term_instrument, ttmcso.term_reagent,
+               ttmcso.term_step, ttmcso.term_result, ttmcso.status, ttmcso.create_time, ttmcso.update_time, ttmcso.create_by,
+               ttmcso.update_by, ttmcso.disabled,tpp.project_name AS projectName,ted.experiment_code AS experimentCode,
+               ted.experiment_name AS experimentName,ttmcst.term_name AS termName,ttmcst.term_code AS termCode
+        from t_test_method_confirm_sheet_original ttmcso
+        left join t_test_method_confirm_sheet_term ttmcst on ttmcso.term_id = ttmcst.id
+        left join t_test_method_confirm_sheet ttmcs on ttmcst.test_id = ttmcs.id
+        left join t_experiment_dispatch ted on ttmcs.dispatch_id = ted.id
+        left join t_project_proposal tpp on ted.project_id = tpp.id
+        <where>
+            <if test="query.projectName != null and query.projectName != ''">
+                and tpp.project_name like concat('%', #{query.projectName}, '%')
+            </if>
+            <if test="query.experimentCode != null and query.experimentCode != ''">
+                and ted.experiment_code like concat('%', #{query.experimentCode}, '%')
+            </if>
+            <if test="query.createBy != null and query.createBy != ''">
+                and ttmcso.create_by like concat('%', #{query.createBy}, '%')
+            </if>
+            <if test="query.status != null">
+                and ttmcso.status = #{query.status}
+            </if>
+            <if test="query.startTime != null and query.startTime != '' and query.endTime != null and query.endTime != ''">
+                AND ttmcso.create_time BETWEEN #{query.startTime} AND #{query.endTime}
+            </if>
+            AND ttmcso.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
+        </where>
+        ORDER BY ttmcso.create_time DESC
+    </select>
 
 </mapper>

--
Gitblit v1.7.1