fix: 质检日期为空条件倒序

gongchunyi

2026-08-06 2e68ffb60d9192bc1fe56935970d1f27b1cd32b9

fix: 质检日期为空条件倒序

 src/main/resources/mapper/quality/QualityInspectMapper.xml

@@ -58,7 +58,7 @@
        <if test="qualityInspect.entryDateEnd != null and qualityInspect.entryDateEnd != '' ">
            AND qi.check_time &lt;= DATE_FORMAT(#{qualityInspect.entryDateEnd},'%Y-%m-%d')
        </if>
        ORDER BY coalesce(qi.check_time, qi.create_time, qi.id) DESC
        ORDER BY (qi.check_time IS NULL) DESC, coalesce(qi.check_time, qi.create_time, qi.id) DESC
    </select>

    <select id="qualityInspectExport" resultType="com.ruoyi.quality.pojo.QualityInspect">