From 2bdd329d237fb47e083d243a6d9080848c76d597 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期三, 23 六月 2021 16:18:05 +0800
Subject: [PATCH] 修改bug
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActSignDAO.java | 15 +++++++++++++--
1 files changed, 13 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActSignDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActSignDAO.java
index 3d1d48f..3c13c21 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActSignDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActActSignDAO.java
@@ -59,7 +59,8 @@
"</script>")
List<ActivitySignVO> listActivitySign(ActivitySignVO activitySignVO);
- @Select("SELECT " +
+ @Select("<script> " +
+ "SELECT " +
" caas.user_id, " +
" su.NAME, " +
"CASE " +
@@ -70,6 +71,16 @@
" caas.create_at " +
"FROM " +
" com_act_act_sign AS caas " +
- " LEFT JOIN sys_user AS su ON su.user_id = caas.user_id where caas.activity_id = #{activityPeopleListDTO.activityId}")
+ " LEFT JOIN sys_user AS su ON su.user_id = caas.user_id where caas.activity_id = #{activityPeopleListDTO.activityId} " +
+ "<if test='activityPeopleListDTO.phone != null and activityPeopleListDTO.phone != ""'>" +
+ " and su.phone like concat (#{activityPeopleListDTO.phone},'%') "+
+ " </if> " +
+ "<if test='activityPeopleListDTO.cardNo != null and activityPeopleListDTO.cardNo != ""'>" +
+ " AND su.id_card = #{activityPeopleListDTO.cardNo} " +
+ " </if> " +
+ "<if test='activityPeopleListDTO.name != null and activityPeopleListDTO.name != ""'>" +
+ " AND su.name like concat (#{activityPeopleListDTO.name},'%') "+
+ " </if> " +
+ " </script>")
IPage<ActActivityPeopleListVO> getActActivityPeopleList(Page page,@Param("activityPeopleListDTO") ScreenActActivityPeopleListDTO activityPeopleListDTO);
}
--
Gitblit v1.7.1