From 257df6a03ac496428aec4052334d204e79a48078 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 18 四月 2025 10:42:04 +0800
Subject: [PATCH] 7.8报告结果完善
---
cnas-process/src/main/resources/mapper/ProcessReportMapper.xml | 3 ++-
cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessReport.java | 3 +++
2 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessReport.java b/cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessReport.java
index d25d222..4be9719 100644
--- a/cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessReport.java
+++ b/cnas-process/src/main/java/com/ruoyi/process/pojo/ProcessReport.java
@@ -26,6 +26,9 @@
@ApiModel(value = "ProcessReport瀵硅薄", description = "妫�楠屾姤鍛婂彂鏀剧櫥璁拌〃")
public class ProcessReport implements Serializable {
+ @TableField(select = false,exist = false)
+ //瀵煎嚭搴忓彿
+ private Integer indexs;
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
diff --git a/cnas-process/src/main/resources/mapper/ProcessReportMapper.xml b/cnas-process/src/main/resources/mapper/ProcessReportMapper.xml
index 6c06783..8770f50 100644
--- a/cnas-process/src/main/resources/mapper/ProcessReportMapper.xml
+++ b/cnas-process/src/main/resources/mapper/ProcessReportMapper.xml
@@ -28,7 +28,8 @@
</if>
</select>
<select id="getIds" resultType="com.ruoyi.process.pojo.ProcessReport">
- select cpr.* ,
+ select ROW_NUMBER() OVER (ORDER BY cpr.id) AS indexs,
+ cpr.* ,
u1.name sendUserName
from cnas_process_report cpr
left join user u1 on send_user=u1.id
--
Gitblit v1.9.3