package com.yssh.mapper;

import com.yssh.entity.Qxsh;
import com.yssh.entity.SuYuanMonitorData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * @author WWW
 * @date 2023-05-18
 * QxshMapper
 */
@Mapper
public interface QxshMapper {
    List<SuYuanMonitorData> getNewMonitorData(String name, String start, String end);

    public List<Qxsh> selectByTime(String time);

    public List<Qxsh> selectMonthTop10(String time);

    public List<Qxsh> selectWeekTop10(@Param("start") Integer start, @Param("end") Integer end);

    public List<Qxsh> selectDayTop10(String time);

    public List<Qxsh> selectWarnByBeginAndEnd(@Param("start") Integer start, @Param("end") Integer end);

    public List<Qxsh> selectAlarmByBeginAndEnd(@Param("start") Integer start, @Param("end") Integer end);

    public Integer countMonthForWarn(@Param("start") Integer start, @Param("end") Integer end);

    public Integer countMonthForAlarm(@Param("start") Integer start, @Param("end") Integer end);

    public List<Map<String, Object>> count7DayForWarn(@Param("start") Integer start, @Param("end") Integer end);

    public List<Map<String, Object>> count7DayForAlarm(@Param("start") Integer start, @Param("end") Integer end);

    public Integer countFastSuYuan(@Param("id") String id, @Param("time") String time);

    public Integer hasSuYuan(@Param("suYuanId") String suYuanId, @Param("createTime") String createTime);

    public List<Qxsh> select3Hours(@Param("start") Integer start, @Param("end") Integer end);

    public Qxsh selectByTimeAndName(@Param("time") Integer time, @Param("name") String name);

    public List<Qxsh> selectForReport(@Param("start") Integer start, @Param("end") Integer end);

    public Double selectLastYearVal(@Param("time") Integer time, @Param("name") String name);
}