修改订单记录手机号筛选

lidongdong

2023-09-08 ae275fdbad26ae81c53ab30abdd86f283c631faa

修改订单记录手机号筛选

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

@@ -88,7 +88,8 @@
                and vce.condition=#{condition}
            </if>
            <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},'%'))
                and ((select su.name from sys_user as su where su.user_id=vce.user_id) like concat('%',#{userName},'%')) or
                ((select su.phone from sys_user as su where su.user_id=vce.user_id) like concat('%',#{userName},'%'))
            </if>
            <if test="communityId!=null and communityId!='' ">
                and vce.community_id=#{communityId}