From 489ec3bc11027d50c20a93da1bb8351cb22d3adf Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期五, 08 九月 2023 09:46:41 +0800
Subject: [PATCH] 修改兑换订单筛选问题
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerCreditsExchangeMapper.xml | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerCreditsExchangeMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerCreditsExchangeMapper.xml
index 3f5e8a1..2d5c2b7 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerCreditsExchangeMapper.xml
+++ b/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}
--
Gitblit v1.7.1