liujie
2026-07-10 bedff910eb2394a8ce68762a8f3a413d81187ac1
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
package com.ruoyi.system.mapper;
 
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.SysDoorDevice;
import com.ruoyi.system.dto.SysDoorDevicePageRequest;
import com.ruoyi.system.vo.SysDoorDeviceVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
/**
 * 门禁设备数据层
 *
 * @author ruoyi
 */
@Mapper
public interface SysDoorDeviceMapper
{
    public List<SysDoorDeviceVO> pageList(@Param("query") SysDoorDevicePageRequest query,
                                          @Param("pageInfo") PageInfo<SysDoorDeviceVO> pageInfo);
 
    public SysDoorDeviceVO selectVoById(Long doorId);
 
    public SysDoorDevice selectById(Long doorId);
 
    public SysDoorDevice checkDeviceIdUnique(@Param("deviceId") String deviceId,
                                             @Param("excludeDoorId") Long excludeDoorId);
 
    public List<SysDoorDevice> selectEnabledHikvisionDevices();
 
    public int insertDoorDevice(SysDoorDevice doorDevice);
 
    public int updateDoorDevice(SysDoorDevice doorDevice);
 
    public int updateEnabled(@Param("doorIds") List<Long> doorIds, @Param("enabled") Boolean enabled,
                             @Param("updateBy") String updateBy);
 
    public int updateOnlineStatus(@Param("doorIds") List<Long> doorIds, @Param("onlineStatus") String onlineStatus,
                                  @Param("updateBy") String updateBy);
 
    public int deleteByIds(@Param("doorIds") List<Long> doorIds, @Param("updateBy") String updateBy);
}