From 1e5a1e77b06dccbadf5a36b7c5cb1a20187e935a Mon Sep 17 00:00:00 2001
From: Null <281575458@qq.com>
Date: 星期三, 10 三月 2021 16:03:47 +0800
Subject: [PATCH] 党员活动关系表增加userId字段,解决党员信息删除后无法查看原有的活动

---
 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComBpActivityServiceImpl.java |    6 +++---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java                     |    3 +++
 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/model/dos/ComPbActivityMemberDO.java       |    5 +++++
 3 files changed, 11 insertions(+), 3 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java
index d54ae34..fc49de0 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java
@@ -69,6 +69,9 @@
             "AND t.create_at BETWEEN #{comActMessageVO.publishAtBegin} \n" +
             "AND #{comActMessageVO.publishAtEnd} \n" +
             " </if> " +
+			"<if test='comActMessageVO.type != null and comActMessageVO.type !=0'>" +
+			" AND t.type=#{comActMessageVO.type} \n" +
+			" </if> " +
             " order by create_at desc"+
             "</script>")
 	IPage<PageComActMessageVO> pageMyCommunityMessageApplets(Page page, @Param("comActMessageVO")ComActMessageVO comActMessageVO);
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/model/dos/ComPbActivityMemberDO.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/model/dos/ComPbActivityMemberDO.java
index 00613a2..576c9cf 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/model/dos/ComPbActivityMemberDO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/model/dos/ComPbActivityMemberDO.java
@@ -34,6 +34,11 @@
     private Long memberId;
 
     /**
+     * 用户ID
+     */
+    private Long userId;
+
+    /**
      * 报名时间
      */
     @TableField(fill = FieldFill.INSERT)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComBpActivityServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComBpActivityServiceImpl.java
index 8347a58..e02d3f8 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComBpActivityServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComBpActivityServiceImpl.java
@@ -280,11 +280,11 @@
     @Override
     public R listActivity(Long userId, Long communityId) {
         List<ComActActivityVO> comActActivityVOS = new ArrayList<>();
-        Long memberId=comPbActivityMemberDAO.selectMemberIdByUserId(userId,communityId);
+        /*Long memberId=comPbActivityMemberDAO.selectMemberIdByUserId(userId,communityId);
         if (ObjectUtils.isEmpty(memberId)) {
             return R.fail();
-        }
-        List<ComPbActivityMemberDO> comPbActivityMemberDOS = comPbActivityMemberDAO.selectList(new QueryWrapper<ComPbActivityMemberDO>().lambda().eq(ComPbActivityMemberDO::getMemberId, memberId));
+        }*/
+        List<ComPbActivityMemberDO> comPbActivityMemberDOS = comPbActivityMemberDAO.selectList(new QueryWrapper<ComPbActivityMemberDO>().lambda().eq(ComPbActivityMemberDO::getUserId, userId));
         if (ObjectUtils.isEmpty(comPbActivityMemberDOS)) {
             return R.fail();
         }

--
Gitblit v1.7.1