package com.nanjing.water.repository.mapper;

import com.nanjing.water.repository.BasicMapper;
import com.nanjing.water.repository.po.WaterFacilityParameterPO;
import com.nanjing.water.repository.vo.FacilityParameterDataVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 设备设定参数 mapper
 *
 * @author lin.liu
 */
public interface WaterFacilityParameterMapper extends BasicMapper<WaterFacilityParameterPO> {

    @Select("SELECT wf.id,wf.facility_code,wf.facility_name,wfp.columns_code,wfp.columns_show,wfp.column_value,wfp.last_time FROM  water_facility wf right JOIN water_facility_parameter wfp ON wf.id=wfp.facility_id WHERE wf.is_delete=0\n" +
            "AND (wfp.columns_code='B001StartNumber' OR wfp.columns_code='B002StartNumber')")
    List<FacilityParameterDataVO> getListNewPump();
}