From d4b2252268142d9b6f35f6fdc590c4e7cf6f0df3 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期日, 28 六月 2026 20:37:20 +0800
Subject: [PATCH] fix: 销售台账根据合同号倒序

---
 src/main/resources/mapper/sales/SalesLedgerMapper.xml |   12 ++++++------
 1 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/src/main/resources/mapper/sales/SalesLedgerMapper.xml b/src/main/resources/mapper/sales/SalesLedgerMapper.xml
index 4340a52..e1c6d62 100644
--- a/src/main/resources/mapper/sales/SalesLedgerMapper.xml
+++ b/src/main/resources/mapper/sales/SalesLedgerMapper.xml
@@ -110,11 +110,11 @@
             </if>
             <if test="salesLedgerDto.reviewStatusList != null and salesLedgerDto.reviewStatusList.size() > 0">
                 AND (
-                    T1.review_status IN
-                    <foreach collection="salesLedgerDto.reviewStatusList" item="status" open="(" separator="," close=")">
-                        #{status}
-                    </foreach>
-                    OR T1.review_status IS NULL
+                T1.review_status IN
+                <foreach collection="salesLedgerDto.reviewStatusList" item="status" open="(" separator="," close=")">
+                    #{status}
+                </foreach>
+                OR T1.review_status IS NULL
                 )
             </if>
 
@@ -133,7 +133,7 @@
                 )
             </if>
         </where>
-        ORDER BY T1.entry_date DESC,T1.id DESC
+        ORDER BY T1.sales_contract_no desc
     </select>
 
     <select id="selectIncomeStats" resultType="com.ruoyi.home.dto.IncomeExpenseAnalysisDto">

--
Gitblit v1.9.3