package com.tievd.jyz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tievd.jyz.dto.DeviceStatusStatDTO;
import com.tievd.jyz.entity.Camera;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

/**
 * Camera
 * @author      cube
 * @since       2023-02-27
 * @version     V2.0.0
 */
public interface CameraMapper extends BaseMapper<Camera> {

    /**
     * 获取设备上终端的最大的修改/创建时间
     * @param deviceId
     * @return
     */
    Date findMaxChangeTime(@Param("deviceId") Long deviceId);

    /** 设备在线状态统计 */
    @Select("select count(if(tc.status =1,1,null)) onlineCount, count(if(tc.status =2,1,null)) offlineCount from t_camera tc where tc.org_code like concat(#{orgCode},'%')")
    DeviceStatusStatDTO cameraStatusStat(String orgCode);

    /** 根据网关id删除 */
    @Delete("delete from t_camera where device_id = #{id} ")
    void deleteByDeviceId(String id);
}