From de91c84954157bb9f8b6d938cbe0b1b51fb6e65d Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期五, 07 五月 2021 15:23:57 +0800
Subject: [PATCH] bugfixed：新增便民服务商家 报错
---
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java
index 4186807..7d708ba 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComBpActivityDAO.java
@@ -50,7 +50,7 @@
"WHERE\n" +
"m.member_id = #{id} \n" +
"<if test='name != null and name.trim() != ""'>" +
- "AND a.`name` = #{name} \n" +
+ "AND a.`name` like concat (#{name},'%') \n" +
" </if> " +
"<if test='releaseTimeBegin != null '>" +
"AND a.create_at BETWEEN #{releaseTimeBegin} \n" +
@@ -81,6 +81,7 @@
"com_pb_activity a\n" +
"left join sys_user u on a.create_by=u.user_id \n" +
"where a.community_id=#{partyBuildingActivityVO.communityId}\n" +
+ " and a.`status` not in(5,6) \n"+
"<if test='partyBuildingActivityVO.name != null and partyBuildingActivityVO.name.trim() != ""'>" +
"and a.name = #{partyBuildingActivityVO.name} \n" +
" </if> " +
@@ -138,8 +139,16 @@
@Update("update com_pb_activity set status=3 where `status`=2 and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_begin)<=0")
int updateStatusToSign();
- @Update("update com_pb_activity set status=(if(TIMESTAMPDIFF(MINUTE,SYSDATE(),activity_time_end)<=0,5,4)) where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_end)<=0")
+ @Update("update com_pb_activity set status=5 where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_end)<=0")
int updateStatusToActiveOrEnd();
@Select("select type,name from sys_user where user_id=#{createBy}")
LoginUserInfoVO selectUserInfoByUserId(Long createBy);
+
+ /**
+ * 根据社区id查询社区名称
+ * @param communityId 社区id
+ * @return 社区名字
+ */
+ @Select("select name from com_act where community_id=#{communityId}")
+ String selectCommunityNameByCommunityId(Long communityId);
}
--
Gitblit v1.7.1