修改兑换订单筛选问题

lidongdong

2023-09-08 7f91441cddfa6b8cf4c42cf965a2296308ccec91

修改兑换订单筛选问题

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerCreditsExchangeMapper.xml

@@ -75,31 +75,31 @@
        from volunteer_credits_exchange as vce
        <where>
            1=1
            <if test="goodsId!=null">
            <if test="goodsId!=null and goodsId!='' ">
                and vce.goods_id=#{goodsId}
            </if>
            <if test="orderNumber!=null">
            <if test="orderNumber!=null and orderNumber!='' ">
                and vce.order_number=#{orderNumber}
            </if>
            <if test="goodsName!=null">
            <if test="goodsName!=null and goodsName!='' ">
                and ((select vim.name from volunteer_integral_merchant as vim where vim.id=vce.goods_id) like concat('%',#{goodsName},'%'))
            </if>
            <if test="condition!=null">
            <if test="condition!=null and condition!='' ">
                and vce.condition=#{condition}
            </if>
            <if test="userName!=null">
            <if test="userName!=null and userName!='' ">
                and ((select su.name from sys_user as su where su.user_id=vce.user_id) like concat('%',#{userName},'%'))
            </if>
            <if test="communityId!=null">
            <if test="communityId!=null and communityId!='' ">
                and vce.community_id=#{communityId}
            </if>
            <if test="userId!=null">
            <if test="userId!=null and userId!='' ">
                and vce.user_id=#{userId}
            </if>
            <if test="orderType!=null">
            <if test="orderType!=null and orderType!='' ">
                and vce.order_type=#{orderType}
            </if>
            <if test="merchantId!=null">
            <if test="merchantId!=null and merchantId!='' ">
                and vce.merchant_id=#{merchantId}
            </if>
        </where>