添加监控

elkers

8 天以前 3ca43c0f02fd9974eb087c79f411a3d55f806613

 src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java

@@ -2,6 +2,10 @@

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
@@ -9,4 +13,8 @@
 * @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();
}