修改商家提现申请筛选

lidongdong

2023-09-08 a22a8790d355a1a089c33ca12360f0b0925e5900

修改商家提现申请筛选

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

@@ -34,10 +34,10 @@
        from volunteer_merchant_withdraw
        <where>
            is_delete='0'
            <if test="disposeType !=null ">
            <if test="disposeType !=null and disposeType != '' ">
                and dispose_type=#{disposeType}
            </if>
            <if test="merchantName !=null ">
            <if test="merchantName !=null and merchantName != '' ">
                and
                ((select vm.name from volunteer_merchant as vm where volunteer_merchant_withdraw.merchant_id=vm.id) like concat('%',#{merchantName},'%'))
            </if>