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<FacilityAlarmRecordPO> {
|
@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<FacilityAlarm> 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<FacilityAlarmRecordCount> 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<FacilityAlarmRecordPO> getGroupList();
|
}
|
