From c2c8f1fcd02448bf8ae632c19d9a802b8a1c4024 Mon Sep 17 00:00:00 2001
From: yanghui <2536613402@qq.com>
Date: 星期四, 08 十二月 2022 09:49:11 +0800
Subject: [PATCH] Merge branch 'local_20221104' into huacheng_test
---
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