package com.skua.modules.alarmtmp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.skua.modules.alarmtmp.entity.AlarmParamStandardConfig;
import com.skua.modules.alarmtmp.vo.ParamVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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

/**
 * @program: skboot
 * @description:
 * @author: xie chao
 * @create: 2020-11-03 15:51
 */
public interface AlarmParamStandardConfigMapper extends BaseMapper<AlarmParamStandardConfig> {

    @Select({"select apsc.id id from alarm_level_standard_config alsc left join alarm_param_standard_config apsc on " +
            "alsc.id = apsc.alarm_level_standard_id where alsc.id = #{alarmLevelStandardId} and apsc.alarm_param_code = #{alarmParamCode}"})
    Map<String,String> getAlarmParamStandardConfigId(@Param("alarmLevelStandardId") String alarmLevelStandardId, @Param("alarmParamCode") String alarmParamCode);

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

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