package com.skua.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.skua.modules.system.entity.SysArea;
import com.skua.modules.system.vo.SysFactoryInfo.ParamVO;
import org.apache.ibatis.annotations.Param;

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

public interface SysAreaMapper extends BaseMapper<SysArea> {
    List<Map> queryAllDistrictList();

    List<Map> queryFacListByAreaId(@Param("areaId") String areaId, @Param("departId") String departId, @Param("departName") String departName);

    List<Map<String, String>> queryScale();

    List<Map<String, Integer>> queryDrainageTo();

    List<Map<String, Object>>  queryEffluentStandard();

    Integer queryFacTotalCount();

    List<Map<String, Object>> queryFacListByStandardId(@Param("standardId") String standardId);

    List<Map<String, Object>> queryCraft();

    List<Map<String, Object>> queryFacListByCraftId(@Param("craftId") String craftId);

    List<Map<String, Object>> queryFacListByScale(@Param("start")String start,@Param("end")String end);

    List<Map<String, Object>> queryFacListByDrainageTo(@Param("drainageTo")String drainageTo);

    List<Map<String, Object>> queryStandards();

    Double queryTotalWater(@Param("yesterday")String yesterday);

    String queryLevelIdByCode(@Param("dictId") String dictId);

    List<ParamVO> selEffluentStandard(@Param("id")String id);
}