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.dtos.property.CommonPage;
|
import com.panzhihua.common.model.vos.community.ComActCommiteeVO;
|
import com.panzhihua.common.model.vos.community.ComActFourMemberVO;
|
import com.panzhihua.common.model.vos.community.StatisticsCommVO;
|
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenFourMemberStatisticsInfo;
|
import org.apache.ibatis.annotations.Mapper;
|
import com.panzhihua.service_community.entity.ComActFourMember;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* (ComActFourMember)表数据库访问层
|
*
|
* @author makejava
|
* @since 2021-09-23 10:13:30
|
*/
|
@Mapper
|
public interface ComActFourMemberDao extends BaseMapper<ComActFourMember> {
|
/**
|
* 分页查询
|
* @param page
|
* @param commonPage
|
* @return
|
*/
|
IPage<ComActFourMemberVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);
|
ComActFourMemberVO getById(Long id);
|
ComActFourMemberVO getByIdVillage(Long id);
|
|
/**
|
* 获取四长四员基础数据
|
* @param communityId
|
* @return
|
*/
|
BigScreenFourMemberStatisticsInfo getFourMemberBaseData(@Param("communityId") Long communityId);
|
|
/**
|
* 获取四长四员成员数据
|
* @param communityId
|
* @return
|
*/
|
List<ComActFourMemberVO> getFourMembers(@Param("communityId") Long communityId);
|
|
/**
|
* 新增解决问题数统计
|
* @param communityId
|
* @return
|
*/
|
List<StatisticsCommVO> retrieveJJWTAddPolylineData(@Param("communityId") Long communityId);
|
|
/**
|
* 累计解决问题数
|
* @param communityId
|
* @param date
|
* @return
|
*/
|
StatisticsCommVO retrieveJJWTTotalPolylineData(@Param("communityId") Long communityId, @Param("date") String date);
|
|
/**
|
* 新增院落议事数统计
|
* @param communityId
|
* @return
|
*/
|
List<StatisticsCommVO> retrieveYLYSAddPolylineData(@Param("communityId") Long communityId);
|
|
/**
|
* 累计院落议事数统计
|
* @param communityId
|
* @param date
|
* @return
|
*/
|
StatisticsCommVO retrieveYLYSTotalPolylineData(@Param("communityId") Long communityId, @Param("date") String date);
|
}
|