package com.fengdu.gas.repository.mapper; import com.fengdu.gas.entity.response.alarm.FacilityAlarm; import com.fengdu.gas.repository.BasicMapper; import com.fengdu.gas.repository.po.FacilityAlarmRecordPO; import com.fengdu.gas.repository.vo.FacilityAlarmRecordCount; import org.apache.ibatis.annotations.Select; import java.util.List; import java.util.Map; /** * 设备报警记录 mapper * @author zr */ public interface FacilityAlarmRecordMapper extends BasicMapper { @Select("SELECT description AS NAME ,MIN(min_value) AS minValue ,MAX(max_value) AS maxValue,COUNT(id) AS count FROM facility_alarm_record \n" + "WHERE is_delete=0 and columns_code is Not NULL AND columns_code<>'' AND latest_alarm_time BETWEEN #{beginTime} AND #{endTime} '\n" + "GROUP BY description\n") List getByDateType(String beginTime, String endTime); @Select("SELECT point_name, COUNT(*) as count FROM facility_alarm_record WHERE is_delete=0 AND latest_alarm_time IS NOT NULL AND latest_alarm_time<>'' and columns_code is Not NULL AND columns_code<>'' GROUP BY point_name ;") List getAlarmListByPoint(); @Select("SELECT facility_id,columns_code,alarm_type,COUNT(*) AS alarm_count FROM facility_alarm_record WHERE is_delete=0 and columns_code is Not NULL AND columns_code<>'' GROUP BY facility_id,columns_code,alarm_type;") List getGroupList(); }