From 82a0d121b3581b3634887850e0bded5874afc85d Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期一, 26 十月 2026 11:03:15 +0800
Subject: [PATCH] 接口按service_donatebaseinfo表ReportTime 字段倒序
---
ruoyi-project/src/main/resources/mapper/project/ServiceDonateorganBaseMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewinitiateMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceDeathinfoMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceDonatemaintenanceMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml | 2 +-
ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml | 2 +-
8 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDeathinfoMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDeathinfoMapper.xml
index a0c945f..e377f4b 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDeathinfoMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDeathinfoMapper.xml
@@ -155,7 +155,7 @@
<if test="startDeathtime != null and endDeathtime != null ">and sdi.DeathTime BETWEEN #{startDeathtime} and #{endDeathtime}</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
index a223c09..18527b4 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
@@ -242,7 +242,7 @@
<if test="gcsScore != null ">and gcs_score = #{gcsScore}</if>
</where>
- order by ReportTime desc
+ order by service_donatebaseinfo.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatemaintenanceMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatemaintenanceMapper.xml
index 328e9e4..19eef7b 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatemaintenanceMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatemaintenanceMapper.xml
@@ -91,7 +91,7 @@
<if test="id != null ">and sdt.id = #{id}</if>
<if test="state != null and state != ''">and sdm.state = #{state}</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonateorganBaseMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonateorganBaseMapper.xml
index 53557ef..b8cf99b 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonateorganBaseMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonateorganBaseMapper.xml
@@ -126,7 +126,7 @@
</if>
<if test="startTime != null and endTime != null ">and sdb.allocation_time BETWEEN #{startTime} and #{endTime}</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
index 6d08453..bd9968f 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
@@ -181,7 +181,7 @@
<if test="infoid != null">and sd.ID = #{infoid}</if>
<if test="witnessState != null">and st.witness_state = #{witnessState}</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewinitiateMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewinitiateMapper.xml
index 0d0b795..e735d63 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewinitiateMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewinitiateMapper.xml
@@ -124,7 +124,7 @@
<if test="status != null ">and se.status = #{status}</if>
<if test="startTime != null and endTime != null ">and se.start_time BETWEEN #{startTime} and #{endTime}</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
index f6ff6ea..714a5be 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
@@ -245,7 +245,7 @@
#{treatmenthospitalname}
</if>
</where>
- order by sb.InpatientNo desc
+ order by sb.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
index 8c48d78..f4efa1b 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
@@ -340,7 +340,7 @@
and sr.SignDate <= #{endSigndate}
</if>
</where>
- order by sd.InpatientNo desc
+ order by sd.ReportTime desc
<if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if>
</select>
--
Gitblit v1.9.3