修改bug

lidongdong

2023-09-06 17d16eddacf32b37686f2e08ddca3919dca7f845

修改bug

 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 ((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 vce.community_id=#{communityId}
@@ -96,12 +97,12 @@
            <if test="userId!=null">
                and vce.user_id=#{userId}
            </if>
            <if test="merchantId!=null">
                and vce.merchant_id=#{merchantId}
            </if>
            <if test="orderType!=null">
                and vce.order_type=#{orderType}
            </if>
            <if test="merchantId!=null">
                and vce.merchant_id=#{merchantId}
            </if>
        </where>
        order by vce.creation_time desc
    </select>