package com.panzhihua.service_community.dao;
|
|
import java.util.List;
|
|
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.dtos.community.fms.PageTeamMemberDTO;
|
import com.panzhihua.common.model.vos.community.fms.ComFmsTeamMemberExportExcelVO;
|
import com.panzhihua.common.model.vos.community.fms.ComFmsTeamMemberVO;
|
import com.panzhihua.common.model.vos.community.fms.TeamMemberTopStatisticsVO;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Mapper;
|
import com.panzhihua.service_community.entity.ComFmsTeamMember;
|
|
/**
|
* 五微服务-团队成员(ComFmsTeamMember)表数据库访问层
|
*
|
* @author makejava
|
* @since 2022-02-11 13:35:55
|
*/
|
@Mapper
|
public interface ComFmsTeamMemberDAO extends BaseMapper<ComFmsTeamMember> {
|
|
/**
|
* 批量新增数据（MyBatis原生foreach方法）
|
*
|
* @param entities
|
* List<ComFmsTeamMember> 实例对象列表
|
* @return 影响行数
|
*/
|
int insertBatch(@Param("entities") List<ComFmsTeamMember> entities);
|
|
/**
|
* 批量新增或按主键更新数据（MyBatis原生foreach方法）
|
*
|
* @param entities
|
* List<ComFmsTeamMember> 实例对象列表
|
* @return 影响行数
|
* @throws org.springframework.jdbc.BadSqlGrammarException
|
* 入参是空List的时候会抛SQL语句错误的异常，请自行校验入参
|
*/
|
int insertOrUpdateBatch(@Param("entities") List<ComFmsTeamMember> entities);
|
|
/**
|
* 分页查询团队成员
|
* @param page
|
* @param pageTeamMemberDTO
|
* @return
|
*/
|
IPage<ComFmsTeamMemberVO> pageFmsTeamMember(@Param("page") Page page, @Param("pageTeamMemberDTO") PageTeamMemberDTO pageTeamMemberDTO);
|
|
/**
|
* 获取成员数量
|
* @param communityId
|
* @param idCard
|
* @param phone
|
* @return
|
*/
|
Integer countMember(@Param("communityId") Long communityId, @Param("idCard") String idCard, @Param("phone") String phone);
|
|
/**
|
* 微团队顶部统计
|
* @param communityId
|
* @return
|
*/
|
TeamMemberTopStatisticsVO statisticsFmsTeamMember(@Param("communityId") Long communityId);
|
|
/**
|
* 获取团队人员导出数据
|
* @param pageTeamMemberDTO
|
* @return
|
*/
|
List<ComFmsTeamMemberExportExcelVO> exportTeamMember(@Param("pageTeamMemberDTO") PageTeamMemberDTO pageTeamMemberDTO);
|
|
/**
|
* 通过社区id获取团队成员
|
* @param communityId
|
* @return
|
*/
|
List<ComFmsTeamMemberVO> selectListByCommunityId(@Param("communityId") Long communityId);
|
|
/**
|
* 通过团队id查询团队成员
|
* @param teamId
|
* @return
|
*/
|
List<ComFmsTeamMemberVO> selectVOListByTeamId(@Param("teamId") Long teamId);
|
}
|
