package com.job.zsc.mapper;
|
|
import com.job.zsc.pojo.AnalysisDustData;
|
import com.job.zsc.pojo.DustExceptionData;
|
import com.job.zsc.pojo.DustExceptionType;
|
import com.job.zsc.pojo.DustSiteData;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
public interface FugitiveDustMapper {
|
|
List<DustSiteData> conditonQueryDustHistoryData(String siteName, String mnCode,String beginTime, String endTime,@Param("scenarioType") String[] scenarioType) ;
|
|
@Select("select distinct Type_Name from monitor_site")
|
List<DustSiteData> scenarioData();
|
|
@Select("select DISTINCT name from ja_t_dust_site_info ")
|
List<DustSiteData> allSiteName();
|
|
List<AnalysisDustData> analysisdata( String siteName,String beginTime, String endTime);
|
|
List<AnalysisDustData> analysisByTime(String siteName, String beginTime, String endTime);
|
|
@Select("select DISTINCT exception,exception_type from dust_exception_data")
|
List<DustExceptionType> getExceptionType();
|
|
List<DustExceptionData> getExceptionData(String siteName, @Param("exceptionType")String[] exceptionType, String beginTime, String endTime);
|
|
List<DustExceptionData> getExceptionSitenameAndCode(String exceptionType, String beginTime, String endTime);
|
|
@Select("select count(*) from dust_exception_data as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code where exception_type = #{exceptionType} and (begin_time between #{beginTime} and #{endTime} or end_time between #{beginTime} and #{endTime})")
|
Integer exceptionNum(String exceptionType, String beginTime, String endTime);
|
|
List<DustSiteData> conditonQueryHistoryData(String siteName, String beginTime, String endTime);
|
|
@Select("select DISTINCT mn_code from dust_exception_data")
|
List<DustExceptionData> exceptionSiteNum();
|
}
|
