CeDo
2021-06-07 11e5c5ff34de7da51ae105b4922115ce61f96610
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
package com.panzhihua.service_grid.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.grid.EventGridTodoDataDTO;
import com.panzhihua.common.model.dtos.grid.PageEventGridDataAdminDTO;
import com.panzhihua.common.model.dtos.grid.PageEventGridDataDTO;
import com.panzhihua.common.model.dtos.grid.PageEventGridNearbyDTO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.grid.*;
import com.panzhihua.service_grid.model.dos.EventGridDataDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
/**
 * DAO
 *
 * @author cedoo email:cedoo(a)qq.com
 * @version 1.0
 * @date 2021-05-26
 * @since 1.0
 */
@Mapper
public interface EventGridDataMapper extends BaseMapper<EventGridDataDO> {
 
    /**
     * 分页查询
     *
     * @param eventGridDataDTO
     * @return
     */
    IPage<EventGridAdminVO> findByPage(Page page, @Param("pageEventGridDataDTO") PageEventGridDataAdminDTO eventGridDataDTO);
 
    /**
     * 分页查询网格员所在网格
     *
     * @param pageEventGridDataDTO
     * @return
     */
    IPage<EventGridDataVO> selectUserGrid(Page page, @Param("pageEventGridDataDTO") PageEventGridDataDTO pageEventGridDataDTO);
 
    /**
     * 查询当前用户网格内待处理事件统计信息
     * @param eventGridTodoDataDTO
     * @return
     */
    List<UserEventGridDataVO> getGridTodoData(@Param("eventGridTodoDataDTO") EventGridTodoDataDTO eventGridTodoDataDTO);
    /**
     * 查询社区下所有网格员
     * @param communityId   社区id
     * @return  网格员列表
     */
    List<EventGridMemberAdminVO> getGridMemberLists(@Param("communityId") Long communityId);
 
    List<GridMemberAdminVO> getGridMember(@Param("gridId") Long gridId);
 
    ComGridActVO getComActByActId(@Param("communityId") Long communityId);
 
    void removeGridRelationByGridId(@Param("gridId") Long gridId);
 
    List<EventGridMemberAdminVO> getGridMemberListsByGrid(@Param("gridId") Long gridId);
 
    List<EventGridDataAreaVO> getGridDataListByCommunity(@Param("communityId") Long communityId);
 
    List<EventGridDataAreaVO> selectGridWithArea(Page page, PageEventGridNearbyDTO pageEventGridNearbyDTO);
}