package com.fengdu.gas.repository.mapper; import com.fengdu.gas.entity.response.facility.FacilityPointCount; import com.fengdu.gas.repository.BasicMapper; import com.fengdu.gas.repository.po.WaterFacilityPO; import org.apache.ibatis.annotations.Select; import java.util.List; /** * 设备信息 mapper * @author zr */ public interface WaterFacilityMapper extends BasicMapper { @Select("SELECT point_name,COUNT(*) FROM water_facility WHERE is_delete=0 GROUP BY point_name") List getFacilityPointCount(); }