添加首页大屏数据统计

liulin

6 天以前 2b5c36b4830adf4227f248d4e10bdb90b1e5f3d8

 src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityParameterMapper.java

@@ -1,10 +1,29 @@
package com.fengdu.gas.repository.mapper;

import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.WaterFacilityParameterPO;
import com.fengdu.gas.repository.BasicMapper;
import com.fengdu.gas.repository.po.WaterFacilityParameterPO;
import com.fengdu.gas.repository.vo.WaterFacilityParameterVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

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

    @Select({
            "<script>",
            "SELECT a.*,b.facility_state,b.facility_name,b.point_id,b.point_name FROM water_facility_parameter a ",
            "left join water_facility b ON a.facility_id=b.id WHERE a.is_delete=0",
            "<if test= \"pointId!=null and pointId>0 \">",
            "and b.point_id=#{pointId}",
            "</if>",
            "<if test= \"facilityState!=null\">",
            "and b.facility_state=#{facilityState}",
            "</if>",
            "</script>"
    })
    List<WaterFacilityParameterVO> getListData(Long pointId, Integer facilityState);
}