修改商家管理筛选

lidongdong

2023-09-08 63293a5b07a1ed6461c763ff5fa9964f195560bc

修改商家管理筛选

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

@@ -81,7 +81,7 @@
                and merchant_type=#{merchantType}
            </if>
            <if test="name !=null and name !=''  ">
                and ((select vt.name from volunteer_type as vt where vt.id=volunteer_merchant.merchant_type) like concat('%',#{name},'%'))
                and (volunteer_merchant.name like concat('%',#{name},'%'))
            </if>
        </where>
        order by merchantGrade desc,creation_time desc