gongchunyi
2026-06-28 d4b2252268142d9b6f35f6fdc590c4e7cf6f0df3
fix: 销售台账根据合同号倒序
已修改1个文件
12 ■■■■ 文件已修改
src/main/resources/mapper/sales/SalesLedgerMapper.xml 12 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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">