package com.skua.modules.alarmtmp.mapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.alarmtmp.entity.AlarmWaterLevelStandardConfig;
import com.skua.modules.alarmtmp.vo.AlarmParamStandardDepartVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <pre>
 * <请输入描述信息> 报警标准库与厂站关系
 * </pre>
 * @author Gao Ran,
 * @Description: TODO(这里描述这个方法的需求变更情况)
 */
public interface AlarmWaterLevelStandardConfigMapper extends BaseMapper<AlarmWaterLevelStandardConfig> {
	


	@Select("select walsc.depart_id ,apsc.alarm_param_code,apsc.alarm_param_upper_limit,apsc.alarm_param_lower_limit,\n" +
			"\tapsc.alarm_param_upper_warn,apsc.alarm_param_lower_warn from alarm_water_level_standard_config walsc \n" +
			"\tleft join alarm_level_standard_config alsc on walsc.alarm_level_standard_config_id = alsc.id \n" +
			"\tleft join alarm_param_standard_config apsc on alsc.id =  apsc.alarm_level_standard_id ${ew.customSqlSegment} ")
	List<AlarmParamStandardDepartVO> getList(@Param(Constants.WRAPPER) QueryWrapper<AlarmParamStandardDepartVO> alarmParamStandardDepartVOQueryWrapper);}