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<WaterFacilityPO> {
|
@Select("SELECT point_name,COUNT(*) FROM water_facility WHERE is_delete=0 GROUP BY point_name")
|
List<FacilityPointCount> getFacilityPointCount();
|
}
|
