package org.jeecg.modules.mdc.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @author: LiuS
 * @create: 2023-04-07 14:57
 */
@Mapper
@Repository
public interface EquipmentTemperatureMapper {

    @Select("select top 1 X,Y,Z,A,B from EquipmentTemperature where EquipmentID= #{equipmentId} order by CollectTime desc")
    List<Map<String, Object>> getEquipmentTemperature(String equipmentId);

    @Select("select top 1 X,Y,Z,A,B from EquipmentLagError where EquipmentID=#{equipmentId} order by CollectTime desc")
    List<Map<String, Object>> getEquipmentLagError(String equipmentId);

    @Select("select top 1 X,Y,Z,A,B from EquipmentCurrent where EquipmentID=#{equipmentId} order by CollectTime desc")
    List<Map<String, Object>> getEquipmentCurrent(String equipmentId);
}