修改

xuhy

2024-11-01 df09300c82124ebb6bc3f5b434a2a8f1b9cf4427

修改

 ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml

@@ -10,9 +10,9 @@
        </if>
    </select>
    <select id="settlementList" resultType="com.ruoyi.order.api.model.TSettlementConfirm">
select t1.* from
                t_settlement_confirm t1
where 1=1
        select t1.* from
            t_settlement_confirm t1
        where 1=1
        <if test="req.partnerId != null ">
            and t1.partner_id = #{req.partnerId}
        </if>
@@ -21,14 +21,14 @@
        </if>
        <if test="req.type == 1 ">
            <if test="req.startTime != null and req.startTime!=''">
                and (t1.start_time between #{req.startTime} and #{req.endTime}
                and (t1.start_time between #{req.startTime} and #{req.endTime})
            </if>
        </if>
        <if test="req.type == 2 ">
            <if test="req.startTime != null and req.startTime!=''">
                and (t1.end_time between #{req.startTime} and #{req.endTime}
                and (t1.end_time between #{req.startTime} and #{req.endTime})
            </if>
        </if>
    and t1.del_flag = 0
        and t1.del_flag = 0
    </select>
</mapper>