package com.panzhihua.service_community.dao;
|
|
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;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 党员
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-11-30 10:52
|
**/
|
@Mapper
|
public interface ComPbMemberDAO extends BaseMapper<ComPbMemberDO> {
|
/**
|
* 根据用户手机号查询党员信息
|
* @param idCard
|
* @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();
|
|
}
|
