修改兑换订单筛选问题

lidongdong

2023-09-08 489ec3bc11027d50c20a93da1bb8351cb22d3adf

修改兑换订单筛选问题

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

@@ -82,14 +82,13 @@
                and vce.order_number=#{orderNumber}
            </if>
            <if test="goodsName!=null">
                and vce.goods_name=#{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">
                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},'%') or
                ((select su.phone 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},'%'))
            </if>
            <if test="communityId!=null">
                and vce.community_id=#{communityId}