添加首页大屏数据统计

liulin

6 天以前 bcf8c46e009d5d825a7bf07b9eac46fb7432418b

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

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

import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.WaterFacilityPO;
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();
}