package org.jeecg.modules.iot.mdc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.iot.mdc.entity.EquipmentAlarm;
import org.jeecg.modules.iot.mdc.entity.EquipmentLog;
import org.springframework.stereotype.Component;

/**
 * @author: LiuS
 * @create: 2023-04-12 16:39
 */
@Component("iotEquipmentAlarmMapper")
public interface EquipmentAlarmMapper extends BaseMapper<EquipmentAlarm> {
    @Select("SELECT * FROM EquipmentAlarm WHERE EquipmentID = #{ equipmentId } ORDER BY CollectTime DESC LIMIT 1")
    EquipmentAlarm selectEquipmentAlarmByEquipmentId(@Param("equipmentId") String equipmentId);
}