From 08f1b1f1804a8bd833d42f257908d80e88387b55 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 14 三月 2025 11:27:47 +0800
Subject: [PATCH] 3.5增加登录验证、修改密码、人员列表调整
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java | 97 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 97 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java
new file mode 100644
index 0000000..b761fc7
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java
@@ -0,0 +1,97 @@
+package com.panzhihua.service_community.dao;
+
+import java.util.List;
+
+import com.panzhihua.common.model.vos.community.StatisticsCommVO;
+import com.panzhihua.common.model.vos.community.bigscreen.BigScreenVolunteerStatisticsInfo;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+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.ComMngVolunteerMngVO;
+import com.panzhihua.common.model.vos.community.TodoEventsVO;
+import com.panzhihua.service_community.model.dos.ComMngVolunteerMngDO;
+
+/**
+ * @program: springcloud_k8s_panzhihuazhihuishequ
+ * @description: 志愿者
+ * @author: huang.hongfa weixin hhf9596 qq 959656820
+ * @create: 2020-12-15 09:50
+ **/
+@Mapper
+public interface ComMngVolunteerMngDAO extends BaseMapper<ComMngVolunteerMngDO> {
+
+ /**
+ * 分页查询志愿者列表
+ * @param page 分页参数
+ * @param comMngVolunteerMngVO 请求参数
+ * @return 志愿者列表
+ */
+ IPage<ComMngVolunteerMngVO> pageVolunteer(Page page,
+ @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);
+
+ IPage<ComMngVolunteerMngVO> pageVolunteerExamine(Page page,
+ @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);
+
+ @Select("SELECT\n" + "'4' type\n" + "FROM\n" + "com_mng_volunteer_mng v \n" + "WHERE\n" + "v.state = 1 \n"
+ + "AND v.`community_id` = #{communityId} \n")
+ List<TodoEventsVO> selectNeedToDo(Long communityId);
+
+ @Select("select user_id from sys_user where type=1 and phone=#{phone}")
+ Long selectUserIdByPhone(String phone);
+
+ @Select("select id_card from sys_user where type=1 and phone=#{idCard}")
+ Long selectUserIdByIdCard(String idCard);
+
+ /**
+ * 志愿者-组织直方图数据
+ * @param communityId
+ * @return
+ */
+ List<StatisticsCommVO> retrieveVolunteerOrgHistogram(@Param("communityId") Long communityId);
+
+ /**
+ * 获取杨家坪定制页面-志愿服务基础数据
+ * @param communityId
+ * @return
+ */
+ BigScreenVolunteerStatisticsInfo getVolunteerBaseData(@Param("communityId") Long communityId);
+
+ /**
+ * 获取志愿者数据
+ * @param communityId
+ * @return
+ */
+ List<ComMngVolunteerMngVO> retrieveVolunteerServiceTypeCircleData(@Param("communityId") Long communityId);
+
+ /**
+ * 志愿者年龄段占比圆形图数据
+ * @param communityId
+ * @return
+ */
+ List<StatisticsCommVO> retrieveVolunteerAgeCircleData(@Param("communityId") Long communityId);
+
+ /**
+ * 志愿者技能占比圆形图
+ * @param communityId
+ * @return
+ */
+ List<ComMngVolunteerMngVO> retrieveVolunteerSkillCircleData(@Param("communityId") Long communityId);
+
+ /**
+ * 根据社区id查询志愿者
+ * @param communityId
+ * @return
+ */
+ List<ComMngVolunteerMngVO> selectVolunteerByCommunityId(@Param("communityId") Long communityId);
+
+ /**
+ * 志愿者审核详情
+ * @param id
+ * @return
+ */
+ ComMngVolunteerMngVO detailVolunteerExamine(@Param("id") Long id);
+}
--
Gitblit v1.7.1