From 6bc6c6b528c9625a72a7a485e03332c4e3fd9a9e Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 16 十月 2025 09:20:34 +0800
Subject: [PATCH] 报表修改

---
 ruoyi-system/src/main/resources/mapper/system/TSysPayRecordMapper.xml   |    2 ++
 ruoyi-system/src/main/resources/mapper/system/TErpProcurementMapper.xml |    6 ++++++
 2 files changed, 8 insertions(+), 0 deletions(-)

diff --git a/ruoyi-system/src/main/resources/mapper/system/TErpProcurementMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TErpProcurementMapper.xml
index d522323..14f8c3d 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TErpProcurementMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TErpProcurementMapper.xml
@@ -272,6 +272,7 @@
             <if test="query.phone != null and query.phone != ''">
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
@@ -313,6 +314,7 @@
             <if test="query.phone != null and query.phone != ''">
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
@@ -354,6 +356,7 @@
             <if test="query.phone != null and query.phone != ''">
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
@@ -395,6 +398,7 @@
             <if test="query.phone != null and query.phone != ''">
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
@@ -436,6 +440,7 @@
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
             AND tep.is_platform_commission = 1
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
@@ -477,6 +482,7 @@
                 and tep.phone like concat('%',#{query.phone},'%')
             </if>
             AND tep.is_platform_commission = 1
+            AND tep.status in (3,4,5)
             AND tep.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
         </where>
         order by tep.pay_time desc
diff --git a/ruoyi-system/src/main/resources/mapper/system/TSysPayRecordMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TSysPayRecordMapper.xml
index f0260dd..b9cb6e1 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TSysPayRecordMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TSysPayRecordMapper.xml
@@ -32,6 +32,7 @@
                 AND tspr.pay_time &gt;= #{query.startTime}
                 AND tspr.pay_time &lt;= #{query.endTime}
             </if>
+            AND tspr.pay_state = 2
         </where>
         ORDER BY tspr.pay_time DESC
     </select>
@@ -49,6 +50,7 @@
                 AND tspr.pay_time &gt;= #{query.startTime}
                 AND tspr.pay_time &lt;= #{query.endTime}
             </if>
+            AND tspr.pay_state = 2
         </where>
         ORDER BY tspr.pay_time DESC
     </select>

--
Gitblit v1.7.1