package com.skua.modules.dataAnalysis.mapper;

import com.skua.core.api.vo.DictModel;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
public interface WaterAnalysisNewMapper {
    List<Map<String, Object>> queryFacListBySummary(@Param("time") String time, @Param("dayCount") int dayCount, @Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryNoSummaryCount(@Param("time") String time, @Param("yesTime") String yesTime, @Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryNoSummaryList(@Param("time") String time,@Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryFacList(@Param("time") String time,@Param("factoryIds") String factoryIds);
    List<DictModel> queryDictItemsByCode(@Param("code") String code);
    List<Map<String, Object>> queryCSList();
    List<Double> queryAvgByCode(@Param("code") String code, @Param("time") String time,
                                @Param("factoryIds") String factoryIds, @Param("reportId") String reportId);
    Double queryAvgSumByCode(@Param("code") String code, @Param("time") String time, @Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryAllFacList(@Param("factoryIds") String factoryIds);
    Double queryAvgSumByCodeAndFac(@Param("code") String code, @Param("time") String time, @Param("factoryId") String factoryId);
    List<Map<String, Object>> queryCSAnalysisFacList(@Param("code") String code, @Param("time") String time, @Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryTotalBySummary(@Param("time") String time, @Param("departIds") String departIds);
    Long queryTotalCount(@Param("factoryIds") String factoryIds);
    List<Map<String, Object>> queryAlarmRecord(@Param("time") String time, @Param("factoryId") String factoryId);

    List<Map<String, Object>> queryAllFactoryList(@Param("time") String time, @Param("factoryIds") String factoryIds,@Param(value="dataViewName") String dataViewName);

    List<Map<String, Object>> queryNewFacList(@Param("time") String time, @Param("factoryIds") String factoryIds);

    List<Map<String, Object>> queryNewSummaryCount(@Param("time") String time, @Param("factoryIds") String factoryIds);

    Map<String, Object> queryAvgQcl(@Param(value="dataViewName") String dataViewName, @Param("time") String time, @Param("factoryIds") String factoryIds);
}