From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 09 六月 2025 11:54:00 +0800
Subject: [PATCH] 6.9新增登录失败冻结逻辑

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPbMemberDAO.java |   60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 60 insertions(+), 0 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPbMemberDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPbMemberDAO.java
index 1f081d6..0070f3c 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPbMemberDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPbMemberDAO.java
@@ -3,6 +3,10 @@
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenActivityLine;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenActivityTop;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenServiceData;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenServiceUser;
 import com.panzhihua.common.model.vos.partybuilding.*;
 import com.panzhihua.service_community.model.dos.ComPbMemberDO;
 import org.apache.ibatis.annotations.Mapper;
@@ -26,4 +30,60 @@
      * @return
      */
     ComPbMemberVO selectById(String idCard);
+
+    /**
+     *根据社区id日期查询活动数
+     * @param communityId
+     * @param date
+     * @return
+     */
+    BigScreenActivityLine selectActivityCountMonth(@Param("communityId")Long communityId, @Param("date")String date,@Param("year")String year);
+
+    /**
+     * 查询党员积分前3
+     * @param communityId
+     * @return
+     */
+    IPage<BigScreenActivityTop> selectActivityTop(Page page,@Param("communityId") Long communityId);
+
+    /**
+     * 服务数据查询
+     * @param communityId
+     * @return
+     */
+    BigScreenServiceData bigScreenServiceData(@Param("communityId")Long communityId);
+
+    /**
+     * 服务居民
+     * @param communityId
+     * @return
+     */
+    List<BigScreenServiceUser> bigScreenServiceUser(@Param("communityId")Long communityId);
+
+    /**
+     * 通过userID确认是否是党员
+     * @param userId
+     * @return
+     */
+    Integer checkIsPbMember(@Param("userId") Long userId);
+
+    /**
+     * 通过userID确认是否是志愿者
+     * @param userId
+     * @return
+     */
+    Integer checkIsVolunteer(@Param("userId") Long userId);
+
+    /**
+     * 统计在职干部特长
+     * @return
+     */
+    List<ComPbMemberTypeVO> statisticsPbMemberType();
+
+    /**
+     * 单位类型
+     * @return
+     */
+    List<ComPbMemberTypeVO> selectUnitByNatureName();
+
 }

--
Gitblit v1.7.1