package com.yssh.mapper;

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

import java.util.List;

/**
 * @author WWW
 * @date 2023-05-18
 * QxshMapper
 */
@Mapper
public interface QxshMapper {
    public List<Qxsh> selectByTime(String time);

    public List<Qxsh> selectMonthTop10(String time);

    public List<Qxsh> select3Hours(@Param("times") List<String> times);

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

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

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