package com.panzhihua.service_grid.dao;
|
|
import java.util.List;
|
|
import com.panzhihua.common.model.vos.screen.GridMemberTrajectoryVo;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
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.grid.EventGridCascadeListDTO;
|
import com.panzhihua.common.model.dtos.grid.MemberStatisticsAdminDTO;
|
import com.panzhihua.common.model.dtos.grid.PageEventGridMemberRelationDTO;
|
import com.panzhihua.common.model.vos.grid.EventGridMemberRelationVO;
|
import com.panzhihua.common.model.vos.grid.EventMapGridCascadeVO;
|
import com.panzhihua.common.model.vos.grid.EventMapGridVO;
|
import com.panzhihua.common.model.vos.grid.EventStatisticsMemberAdminVO;
|
import com.panzhihua.common.model.vos.grid.admin.GridMemberCascadeVO;
|
import com.panzhihua.common.model.vos.grid.admin.GridMemberLcListVO;
|
import com.panzhihua.service_grid.model.dos.EventGridMemberRelationDO;
|
|
/**
|
* DAO
|
*
|
* @author cedoo email:cedoo(a)qq.com
|
* @version 1.0
|
* @date 2021-05-26
|
* @since 1.0
|
*/
|
@Mapper
|
public interface EventGridMemberRelationMapper extends BaseMapper<EventGridMemberRelationDO> {
|
|
/**
|
* 分页查询
|
*
|
* @param pageEventGridMemberRelationDTO
|
* @return
|
*/
|
IPage<EventGridMemberRelationVO> findByPage(Page page,
|
@Param("pageEventGridMemberRelationDTO") PageEventGridMemberRelationDTO pageEventGridMemberRelationDTO);
|
|
/**
|
* 根据网格员id查询关联网格列表
|
*
|
* @param userId
|
* 网格员id
|
* @return 网格列表
|
*/
|
List<EventMapGridVO> getMapGridListByApp(@Param("userId") Long userId);
|
|
/**
|
* 后台管理-网格员统计
|
*
|
* @param statisticsAdminDTO
|
* 请求参数
|
* @return 网格员统计信息
|
*/
|
IPage<EventStatisticsMemberAdminVO> gridMemberStatistics(Page page,
|
@Param("statisticsAdminDTO") MemberStatisticsAdminDTO statisticsAdminDTO);
|
|
/**
|
* 查询市平台网格员列表
|
*
|
* @return 市平台网格员列表
|
*/
|
List<GridMemberLcListVO> getGridMemberLcList();
|
|
List<GridMemberCascadeVO> getGridMemberCascade(@Param("type") Integer type, @Param("id") Long id);
|
|
Integer getVillageCount(@Param("communityId") Long communityId);
|
|
Integer getBuildingCount(@Param("villageId") Long villageId);
|
|
List<EventMapGridVO> getMapGridListsByApp(@Param("cascadeListDTO") EventGridCascadeListDTO cascadeListDTO);
|
|
List<EventMapGridCascadeVO> getMapGridsListsByApp(@Param("userId") Long userId, @Param("type") Integer type,
|
@Param("communityId") Long communityId);
|
|
List<EventStatisticsMemberAdminVO>
|
gridMemberStatisticsAll(@Param("statisticsAdminDTO") MemberStatisticsAdminDTO statisticsAdminDTO);
|
|
/**
|
* 查询该社区的网格员列表
|
* @param communityId 社区id
|
* @return 网格员列表
|
*/
|
List<GridMemberTrajectoryVo> getGridsMemberList(@Param("communityId") Long communityId);
|
|
/**
|
* 查询网格员当天运动轨迹
|
* @param userId 用户id
|
* @return 网格员当天运动轨迹
|
*/
|
List<String> getGridsMemberTrajectory(@Param("userId") Long userId);
|
|
}
|
